Question: Please only answer #3. Thank you Number 3 only. Forecasting Assignment Question 1: Weekly demand at Hot Pizza are as shown. Estimate demand for the

Please only answer #3. Thank you
Number 3 only.
Forecasting Assignment Question 1: Weekly demand at Hot Pizza are as shown. Estimate demand for the next 4 weeks using a 4- week moving average as well as simple exponential smoothing with a =0.1. Evaluate the MAD, MAPE, MSE, and TS in each case. Which of the two methods do you prefer? Why? Question 2: for the data set provided in the excel document: a) plot the data to determine the type of the equation. b) Obtain a regression equation for the data. c) Estimate average sales when the number of break-ins is five. Question 3: for the data given on excel spreadsheet: a) Obtain a linear trend line. b) Estimate the demand in period 14. c) Plot your projected line. Question 4: Plot the graph for data provided in Gas and Electrics file. What method would be best to forecast for the next 12 months? And what are your forecasts for the next 12 months for the Gas and Electric Usage. A B Period 1 2 Actual 700 724 | 3 4 5 720 728 740 742 758 750 6 7 8 9 10 770 775Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
