Explore BrainMass

Forecast: Monthly Index

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Each worker's monthly caseload is determined by the number of cases received and the number of workers available during the month. There are two excel spreadsheets attached. One shows the number of cases for each month, number of staff who reported to work, and the caseload per worker for each of the past 48 months. The other one shows the seasonal index for each month and caseload forecasts for the next 48 months. The workers' caseload changes periodically, mainly down in the summer, up in the fall, down in winter, up in the spring.

a) Determine the average monthly rate at which caseload is changing.

b) At which rate or point in time should additional workers be made available to keep caseload from going over 12. (Please explain).

© BrainMass Inc. brainmass.com October 25, 2018, 3:08 am ad1c9bdddf


Solution Preview

Please refer to the EXCEL attachment for details.

The average monthly change of caseload is given by the following equation:

Solution Summary

This solution is comprised of detailed step-by-step calculation and analysis of the given problemrelated to Seasonal Forecasting and provides students with a clear perspective of underlying concept.

See Also This Related BrainMass Solution

Forecasting Monthly Sales on a Month by Month Basis

I am trying to develop a model using Excel (data table perhaps) that can be used to forecast monthly sales on a month-by-month basis based on previous monthly data starting with January of year 7. The sales history is attached.

View Full Posting Details