Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner. b. Discuss any trends or patterns observed in the calculated moving average demand values. c. Make an interpretation of the results and their implications for forecasting demand in care center operations.
Exercise 1:
You are the operations manager at the company Servicios de Salud, Inc., which provides care services to the elderly. An important aspect of your job is ensuring that nursing homes have a healthy inventory of nutritional drinks for residents. Below is the historical demand for the product for one year:
Month |
Historical demand (boxes) |
Forecasted demand (boxes) |
January |
300 |
|
February |
340 |
|
March |
370 |
|
April |
410 |
¿? |
May |
470 |
¿? |
June |
570 |
¿? |
July |
630 |
¿? |
August |
720 |
¿? |
September |
640 |
¿? |
October |
460 |
¿? |
November |
420 |
¿? |
December |
390 |
¿? |
a. Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner.
b. Discuss any trends or patterns observed in the calculated moving average demand values.
c. Make an interpretation of the results and their implications for
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images