Question: Using Excel, please provide your demand forecast for the number of guests RUHungry should plan on for the 2nd quarter of 2018.Please provide your demand

Using Excel, please provide your demand forecast for the number of guests RUHungry should plan on for the 2nd quarter of 2018.Please provide your demand forecast using a last period forecasting technique, a four (4) period moving average technique and a cumulative average technique.Which demand forecasting technique provides the forecast with the least amount of forecast error?Explain to your manager, using a forecast error measurement, why you recommend one forecast technique over the others. RUHungry Banquet Hall - Guests Served by quarter since January 2014.

Calendar Year Quarter Period # Guests Served 2014 1 1 3,500 2 2 8,300 3 3 5,400 4 4 9,050 2015 1 5 4,300 2 6 5,800 3 7 3,300 4 8 5,800 2016 1 9 5,200 2 10 9,300 3 11 7,700 4 12 15,300 2017 1 13 13,500 2 14 17,500 3 15 12,800 4 16 18,300 2018 1 17 13,600 2 18 ?????

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!