Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: where t = 6.00+ 0.600t - 2.75Dit +0.25D2t + 3.5D3t Ỹ₁ = predicted sales (in millions of dollars) in quarter t 6.00 quarterly sales (in millions of dollars) when t = 0 t = time period (quarter) where the fourth quarter of 2012 = 0, first quarter of 2013 = 1, second qua Dit 1 for first-quarter observations; 0 otherwise D2 = 1 for second-quarter observations; 0 otherwise D3t 1 for third-quarter observations; 0 otherwise Forecast Savings-Mart's sales of patio and lawn furniture for each quarter of 2020. Quarter 2020 First Quarter 2020 Second Quarter 2020 Third Quarter 2020 Fourth Quarter Sales Forecast (Millions of dollars)

Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: where t = 6.00+ 0.600t - 2.75Dit +0.25D2t + 3.5D3t Ỹ₁ = predicted sales (in millions of dollars) in quarter t 6.00 quarterly sales (in millions of dollars) when t = 0 t = time period (quarter) where the fourth quarter of 2012 = 0, first quarter of 2013 = 1, second qua Dit 1 for first-quarter observations; 0 otherwise D2 = 1 for second-quarter observations; 0 otherwise D3t 1 for third-quarter observations; 0 otherwise Forecast Savings-Mart's sales of patio and lawn furniture for each quarter of 2020. Quarter 2020 First Quarter 2020 Second Quarter 2020 Third Quarter 2020 Fourth Quarter Sales Forecast (Millions of dollars)

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter5: Business And Economic Forecasting

Section: Chapter Questions

Problem 9E: Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are...

See similar textbooks

Similar questions

The demand of a product of a company is given below for the periods. Can we use Winter method for forecasting demands of the A following 3 periods? Why? If yes, apply it past 4. 6. Demand 27 31 40 31 35 45
4. Suppose we have a summary of forecasting techniques calculation results for Gundam Auto Sales Inc. (in the prior item) as follows: Mean Next Standard Period Error Forecasting Method Used Forecast (MSE) 1.3-period UnWMA 10.42 3.24 2.4-period UnWMA 10.38 3.51 3.3-period WMA 10.83 3.03 4. Simple Exponential Smoothing 5. Trend Projection 8.24 5.04 11.43 1.16 a. Which among the techniques is the most reliable? b. What does the result of the most reliable technique say?
Historical demand for Peeps is as displayed in the table. Month Demand January 11 February 18 March 31 April 39 May 44 June 53 July 67 August 82 September 96 Develop forecasts from June through October using these techniques: Holt's method with alpha=0.2 and beta=0.1. For Holt's model, the level and trend for May are assumed to be 44 and 12. Judge which forecast method is the best based on MAD.
Mai sells makeup online and has noticed that demand for her products, glittery lip gloss, has varied wildly over the past few months she has been selling it. She's been doing some online advertising and thinks there might be a relationship between how much she's spending each week on ads and her weekly lip gloss sales, so she's used Excel to create an Associative Forecast: where the intercept is -20 and the slope is 2.5 per $ spent advertising. Use this information to forecast lip gloss sales in week 18, when she will be spending $100 on advertising. Answer:
The following is the data of recent refrigerator sales at a local Home Depot store. Month 1 2 3 4 5Actual Sales 95 100 80 90 ???Inputs will be exact numbers. What is the forecasted sales in month 5 using naive approach.Please use a 2-month simple moving average method to forecast sales in month 5.Please use a weighted moving average method, with weights of 0.6 one period ago, 0.3 two periods ago, and 0.1 three periods ago, to forecast sales in month 5.
Use simple exponential smoothing with a = 0.6 to forecast the tire sales for September through December. Assume that the forecast for August was for 46 sets of tires. Do your forecasts seem to be biased? Why or why not? Month Sales August 53 September35 October 48 November 40
Campus Advising needs to allocate time this week for office appointments, so she needs te forecast the number of students who will seek appointments. The advisor has gathered th following time series data recently: Period Student Appointments 4 weeks ago 95 3 weeks ago 80 2 weeks ago 65 Last week 50 Answer the next two questions (questions 11 and 12), based on this information. 11. What is this week's forecast for student appointments using a three-week moving average? a) 80 b) 50 c) 52 d) 65 e) 78
Here are the errors associated with a particular forecast over the past five months, in chronological order: 5, 10,-10, 0, 10. Which of the following statements is (are) true? 10. L The mean error over these five months is 3. 11. The forecast was too high during the third month. III. The forecast was perfectly accurate during one of the months. a) I only b) Il only c) Ill only d) I and III e) I, II and III
A local moving company has collected data on the number of moves they have been asked to perform over the past two years. Moving is highly seasonal, so the owner/operator, who is both burly and highly educated, decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. The equation for the trend line of yearly sales is Ft = 16 + 60t. Please forecast demand for each quarter in Year 3. (Round the forecasts to whole numbers and show all calculations). Complete the table below and forecast the sales of Year 3 by quarter. Year 1 Year 2 Year 3 Quarter Demand Seasonal Index Quarter Demand Seasonal Index Average Seasonal Index Forecast 1 20 1 27 2 40 2 45 3 45 3 55 4 31 4 41 Total Average
Name two coincident indicators used in forecasting
Show that b ^β0 is an unbiased estimator of β0. (Hint: Use the fact that ^β1 isunbiased.
Mr. Geppetto uses exponential smoothing to predict revenue in his wood carving business. He uses a weight of  = .4 for the naïve forecast and (1-) = .6 for the past forecast. What revenue did he predict for March using the data below? MONTH REVENUE FORECAST Nov 100 100 Dec 90 100 Jan 115 ---- Feb 110 ---- MARCH ? ?