Plot the demand data. What do you observe?Forecast XR-42S demand for month 7, using a weightedmoving average. The weights are 0.5, 0.3, and 0.2, where0.5 refers to the most recent demand.а.b.Repeat part b using a three period moving average.Repeat part b, using exponential smoothing with a = 0.2.Assume the forecast for period 2 was 15.Develop a linear trend forecast for period 7.Based on MAD criterion, which of the following modelsyou prefer:i. Linear trend developed in part e.ii. Naïve model.С.d.е.f. The K&R Camera shop sells all the latest cameras and accessories.To meet customer demand, the manager must forecast demand foritems she sells. Lately the XR-42S zoom lens has been very popular.Recent monthly demand for this item has been as shown:Number ofLensesMonth Sold11217234152018236.

Given data - Month Number of lenses sold 1 12 2 17 3 15 4 20 5 18 6 23

Answered: Plot the demand data. What do you…

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 table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.2, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,200 units. Forecast: Time Sales 5 years ago 1,140 4 years ago 1,220 3 years ago 1,450 2 years ago 1,090 Last year 1,150 (Do not round intermediate calculations, round your final answer to the nearest whole number.)
Needs all
2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $7 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (use excel to show formulas for your calculations) Month Forecast 270 2 310 280 4 350 310 280
State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.
Sales (in thousands) of ABC Co. for the previous 7 months are 80, 82, 88, 95, 103, 105 and 122 respectively. Forecast the sales by 4 point moving average method for the forthcoming period O a. 102600 units O b. 110000 units O c. 106250 units O d. 113500 units
The department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.3, and an initial forecast of 30.0 for period 1. a. Calculate the MAD covering periods 2-10. b. Calculate the tracking signal covering periods 2-10. c. What do you recommend? Period (t) Demand (At) 1 24 2 23 3 26 4 36 5 26 6 30 7 32 8 26 9 25 10 28
Pls solve this question correctly instantly in 5 min i will give u 3 like for sure
forgiven product demand the time series trying equation is 53.3+2.1 X what is your forecast demand for period six?
OQ6
Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six days of the week. Mario, the manager, has collected information on the number of customers served each day for the past two weeks. If Mario expects total demand for next week to be around 336, what is the forecast for each day of nvext week? (Round intermediate colculations to 4 decimal places, eg. 1.2645 and final answers to 1 decimal place, es 15.2) Number of custooers Day Week 1 Week 2 Tuesdav 45 47 Wednesday 34 28 Thursday 44 31 Friday 92 107 Saturday 104 94 Sunday 55 79 Forecast Day Tuesday
please answer in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?
part b)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Plot the demand data. What do you observe? Forecast XR-42S demand for month 7, using a weighted moving average. The weights are 0.5, 0.3, and 0.2, where 0.5 refers to the most recent demand. а. b. С. Repeat part b using a three period moving average.