Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining duringthe past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year.The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over thepast 12 quarters:LASTTHISYEARTWOYEARS AGOUNITSYEARUNITSUNITS4,7853,4952,6963,4753,2102,0782,7051,695IIIII3,4754,195IIIIIIIIIIIIIIV2,995IV2,375IVUse the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Roundyour answers to 2 decimal places.)PeriodForecast (UnitsIIIIIIIV

Decomposition is a determining procedure that isolates or deteriorates verifiable information into…

TWO LAST THIS YEARS AGO UNITS YEAR UNITS 3,495 2,696 3,475 2,375 YEAR UNITS I 4,785 3,475 4,195 2,995 I 3,210 2,078 2,705 1,695 II II II III III III IV IV IV Use the decomposition technique to forecast demand for the next four quarters. ( your answers to 2 decimal places.) Period Forecast (Units) I II III IV

TWO LAST THIS YEARS AGO UNITS YEAR UNITS 3,495 2,696 3,475 2,375 YEAR UNITS I 4,785 3,475 4,195 2,995 I 3,210 2,078 2,705 1,695 II II II III III III IV IV IV Use the decomposition technique to forecast demand for the next four quarters. ( your answers to 2 decimal places.) Period Forecast (Units) I II III IV

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

If ABC Corporation has following historical data about sales volume: Years Sales Years Sales Years Sales Years Sales 2001 110 2006 99 2011 100 2016 110 2002 112 2007 101 2012 104 2017 111 2003 122 2008 95 2013 108 2018 109 2004 111 2009 98 2014 102 2019 114 2005 104 2010 96 2015 115 2020 112 Note: All the sale values are in thousands. Required: Which type of forecasting approach is suitable for this type of data? Which forecasting technique is best to employ in order to forecast the above data? And also define the suggested technique. Calculate the predicted values by employing the discussed technique in part (b) on the above data.
Please show how you got part C
9. Problem 18-28 (Algo) The following are historical demand data: ACTUAL YEAR SEASONDEMAND 2011 Spring 203 Summer 144 Fall 382 Winter 565 2012 Spring 471 Summer 271 Fall 686 Winter 955 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Forecast for summer 2013 = 364
please answer within 30 minutes.
part c
a. Forecast demand for each week, including week 10, usingexponential smoothing with a 5 .5 (initial forecast 5 20). b. Compute the MAD. c. Compute the tracking signal. ANSWER A,B, C
Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast Error 1 1 30 45 -15 2 2 25 15 10 3 2 55 65 -10 4 3 15 20 -5 Your answer?
Given an actual demand this period of 100, a forecast value for this period of 130, and an alpha of 0.6, what is the exponential smoothing forecast for next period? (Round answer to the nearest whole number.) O A. 100 OB. 130 C. 82 O D. O E. 112 118
Month Demand Forecast Error Abs Error alpha 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 Bias MAD (mean error) Problem 6: Maverick Jeans' demand manager decided to evaluate exponential smoothing. To maintain com- parability, she used the data from problem 6, copied below. 1 Month 2 3 Demand 20 18 21 25 4 5 24 6 7 8 9 10 11 12 27 22 30 23 20 29 22 Develop forecasts for months 5-12. Calculate the Bias and MAD. Use a starting forecast of 20 for month 4 and an alpha value of 0.2. (Note: Adjust all cell values to two decimal points.)
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July August 194 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) Forecast for September 191.00 b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September 191.30 c. Using single exponential smoothing and assuming that the forecast for June had been 142, forecast sales for September with a smoothing constant a of 0.30. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September
Q23
please do ii. and explain and breakdown workings.