Explore BrainMass

Forecast: Monthly Index

This content was STOLEN from BrainMass.com - View the original, and get the 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 September 21, 2018, 1:36 pm ad1c9bdddf - https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/328670


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.