DEMAND FORECAST WITH LINEAR REGRESSION Historical demand for a product is: Period MONTH DEMAND x2 XY (X) (Y) 1 January 12 2 February 11 3 March 15 4 April 12 May 16 6 June 15 FORECAST FOR JULY Period TREND (X) FORECAST 7 Using simple linear regression analysis, calculate the regression equation for the preceding demand data Using the regression equation you found, calculate the forecast for July THERE IS NO NEED TO SEASONALIZE OR DESEASONALIZE----JUST FIND THE REGRESSION EQUATION AND APPLY IT TO CALCULATE THE FORECAST FOR JULY ONLY.

DEMAND FORECAST WITH LINEAR REGRESSION Historical demand for a product is: Period MONTH DEMAND x2 XY (X) (Y) 1 January 12 2 February 11 3 March 15 4 April 12 May 16 6 June 15 FORECAST FOR JULY Period TREND (X) FORECAST 7 Using simple linear regression analysis, calculate the regression equation for the preceding demand data Using the regression equation you found, calculate the forecast for July THERE IS NO NEED TO SEASONALIZE OR DESEASONALIZE----JUST FIND THE REGRESSION EQUATION AND APPLY IT TO CALCULATE THE FORECAST FOR JULY ONLY.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 46 for Day 8, an initial trend estimate of 2, and α = β = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.) MSE = Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number sold: 31 32 35 38 38 42 42 43 41 44 46 46 49 55 52
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period simple moving average method to forecast the number of sales to expect next month. Month Demand Forecast 1 308 341 388 343.3 3 344 364.7 4 400 346.7 341 377.3
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October Actual Demand 108 80 108 115 105 114 125 120 Forecast Demand 100 100 97 101 104 104 108 107 November December For the given forecast, the tracking signal = MADS (round your response to two decimal places). 4
The actual demand of a product for six months are summarized in the table below: Month (t) Demand Dt 1 80 2 90 3 70 4 100 5 70 6 90 Find three months weighted moving averages by assuming the weights, W1 =1, W2 = 0.4 and W3 = 0.5 ii. Compute the mean forecast error iii. Compute the mean square error (MSE) iv. Compute the mean absolute deviation (MAD). v. Mean absolute percent error (MAPE)
All forecasting methods using exponential smoothing, adaptive smoothing, and exponential smoothing including trend require starting values to get the equations going. How would you select the starting value for, say, Ft21?
National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a seven-month period is reported below: Sales (1000 units) Forecast Observation Month Yt Ft 1 February 19 2 March 18 3 April 15 4 May 20 5 June 18 6 July 22 7 August 20 8 September ? Use Excel to plot the data and forecast September sales using the following methods: The naïve forecast A three-month moving average Exponential smoothing with a smoothing coefficient of α = 0.2, assuming a February forecast of 19 A 3-month weighted moving average, with weights 0.60, 0.3, and 0.1. With 0.6 applied to the most recent past.
Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?
Please solve the attached question.
The following data relate the sales figures of the barin Mark Kaltenbach’s small bed-and-breakfast inn in Portand, tothe number of guests registered that week:WEEK GUESTS BAR SALES1 16 $3302 12 2703 18 3804 14 300 a) Perform a linear regression that relates bar sales to guests (notto time).b) If the forecast is for 20 guests next week, what are the salesexpected to be? PX
The following represents the actual demand and two different sets of forecasts using different methods. Compute the MAD for each forecasting method and determine the best method for this set of data. Year-Qtr Actual demand Forecast methos 1 MAD1 (A-F) Forecast Method 2 MAD2 (A-F) 2020-3 98 97 89 2020-4 108 110 106 2021-1 83 68 70 2021-2 100 101 102 2021-3 95 86 87 2021-4 90 94 92 2022-1 71 68 72 2022-2 104 105 106 2022-3 84 91 88 2022-4 80 93 91 2023-1 78 68 70 2023-2 120 118 122
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 1 45 53 2 50 7 59 3 44 8. 59 4 51 9 64 5 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about ? Obtain the trend projection with regression forecast for weeks 10 – 13. (Enter your responses rounded to two decimal places.) Period Forecast, F, 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD МАРЕ
Sales for the past 6 months at Dalworth Company are given in the following table: O Month July August September October What is the Mean Absolute Deviation (MAD) for August through December forecasts produced by using exponential smoothing with a = 0.9? (Note: Do not round the forecasts, and choose the closest answer.) Multiple Choice O November December O 15.28 9.04 8.75 Sales 52 61 53 35 31 28 31.59