Question: 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

Forecasting Assignment Question 1: Weekly demand

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

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 General Management Questions!