The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5 years are shown on the Q1-4 Time Series tab. Use the Seasonal Index technique shown as Forecasting Methods spreadsheet to answer the following: Predicted Predicted Annual Period Sales ($mil) $5.00 Year Quarter Period Annual Sales Seasonal Quarter AE MPE MAD МАРЕ 2008 1 1 2008 1 2 $3.00 2008 1 3 3 $2.00 2008 1 4 4 $7.00 2009 2 1 $6.00 2009 6. $4.00 2009 2 3 7 $4.00 2009 4 8. $14.00 2010 1. 9 $10.00 2010 10 $3.00 2010 11 $5.00 2010 4 12 $16.00 $12.00 $9.00 2011 4 1 13 2011 2. 14 2011 4 15 $7.00 2011 4 16 $22.00 2012 5 1. 17 $18.00 2012 5 2 18 $10.00

The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5 years are shown on the Q1-4 Time Series tab. Use the Seasonal Index technique shown as Forecasting Methods spreadsheet to answer the following: Predicted Predicted Annual Period Sales ($mil) $5.00 Year Quarter Period Annual Sales Seasonal Quarter AE MPE MAD МАРЕ 2008 1 1 2008 1 2 $3.00 2008 1 3 3 $2.00 2008 1 4 4 $7.00 2009 2 1 $6.00 2009 6. $4.00 2009 2 3 7 $4.00 2009 4 8. $14.00 2010 1. 9 $10.00 2010 10 $3.00 2010 11 $5.00 2010 4 12 $16.00 $12.00 $9.00 2011 4 1 13 2011 2. 14 2011 4 15 $7.00 2011 4 16 $22.00 2012 5 1. 17 $18.00 2012 5 2 18 $10.00

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

The monthly demand for units manufactured by the Acme Rocket Company has been as follows:Month Units Month UnitsMay 100 September 105June 80 October 110July 110 November 125August 115 December 120a. Use the exponential smoothing method to forecast the number of units for June to January. The initial forecast for May was 105 units; α = 0.2.b. Calculate the absolute percentage error for each month from June through December and the MAD and MAPE of forecast error as of the end of December.c. Calculate the tracking signal as of the end of December. What can you say about the performance of your forecasting method?
Below is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MAE (or MAD). Month Demand Forecast 1 308 310 2 388 390 3 344 342
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 105 82 110 112 108 106 130 120 Forecast Demand 100 108 97 98 108 102 105 107 November December For the given forecast, the tracking signal = MADS (round your response to two decimal places).
Assume Sandra's forecasted ADR for the night is $1600.99. What would be her estimated total room revenue for this day? ADR = Total room revenue / Number of rooms sold
376.98 says its wrong
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 For the given forecast, the tracking signal = = MADS (round your response to two decimal places). November December Actual Demand 100 80 1/10 115 105 110 125 120 Forecast Demand 100 104 99 101 104 104 105 109
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 345 372 408 383 368 October 5 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = 376.25 pints (round your response to two decimal places and remember to use the weights in propriate order– the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 345 and a = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places).…
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
2
Month Demand Forecast Error 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Abs Error Problem 6: The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent public warehouse space, something that Maverick would like to avoid. In order to estimate the space requirements the demand manager is evaluating moving-average forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below. Bias MAD (mean error) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 18 21 25 24 27 22 30 23 20 29 22 Use a three-month moving average to estimate the month-in- advance forecast of demand for months 4-12. Calculate the Bias and MAD. (Note: Adjust all cell values to two decimal points.)
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. (use excel to show formauls used) Year Sales 1 290 2 340 3 400 4 410 5 400 1. What is the tracking signal for the forecast?