How could this be solved in Excel? Gloria’s Sauce on-line business uses a dedicated data line to connect their electronic business to the internet. They have been in business for one year and have had the same bandwidth (Internet access capacity) for that entire year. Their percentage utilization is given as follows:
|
Month |
Bandwidth |
|
January |
33.5% |
|
February |
36.2% |
|
March |
42.1% |
|
April |
45.7% |
|
May |
50.2% |
|
June |
53.9% |
|
July |
62.0% |
|
August |
60.3% |
|
September |
63.7% |
|
October |
73.1% |
|
November |
72.7% |
|
December |
79.3% |
Produce a forecast for the next month (January of next year) using each of the following techniques. A) Three period moving average. B) Three period weighted moving average using the weights of 1, 2, and 5. C) Exponential smoothing using the forecast for the first period of 34% and a = 0.8. D) Linear trend model. E) When do you think Gloria will need additional bandwidth?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
