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 following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 700 3 810 4 800 5 900 6. 700 7 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? iii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method.
part b)
Month Jan Feb Mar Apr Answer: Demand Using a 3-month weighted moving average forecasting method with weights of 50% for the most recent demand, 30% for demand from 2 periods before, and 20% from 3 periods back, what is the forecast for May? Answer to 1 decimal place. Check 130 123 100 80
Matrix uses simple exponential smoothing with S.F = 0.6 to forecast demand. The forecast for the week of Nov 1 was 350 units, whereas the actual demand turned out to be 400 units. Forecast the demand for the week of Nov 8 to week Nov 22 Week Actual Demand Forecast Nov 01 350 400 Nov 08 460 430 Nov 15 501 448 Nov 22 495 479.8 Element of Competency Determine the quantity of raw materials and other products order.
A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There are 8 hours of production per day. Table 1 Other data Month 1 January 22 Production Demand Days Forecast 950 2 February 18 750 Inventory carrying cost Subcontracting cost per unit Average pay rate Overtime pay Rate 3 March 21 750 4 April 21 1,000 5 May 22 1,300 6 June 20 1,050 Labor-hours per unit Cost of increasing daily production rate (hiring & training) Cost of decreasing daily production rate (layoffs) $5 per unit per month $10 per unit $5 per hour ($40 per day) $7 per hour (above 8 hrs per day) 1.6 hrs per unit $300 per unit $600 per unit This exercise only contains part b. b) Juarez has yet a sixth plan. A constant workforce of 7 is selected, with the remainder of demand filled by subcontracting. Evaluate this plan. The production rate per day = ☐ units. (Enter your response as a whole…
March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same
Forecast based on averages. Given the following data: Period Number of Complaints 1 70 2 75 3 65 4 68 5 74 Prepare a forecast for period 6 using each of these approaches: a. A weighted average using weights of .50 (most recent), .30, .20 b. Exponential smoothing with a smoothing constant of .40
Given an actual demand this period of 143, a forecast value for this period of 119, and an alpha of .6, what is the exponential smoothing forecast for next period? 123.8 118.2 O 122.2 119.8 O 117.4
Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.2 and 0.4. Use the actual value in Period 1 as your starting forecast in Period 2. (Round all answers to two decimal places. Use these rounded answers when computing subsequent answers.) Period Actual Demand 1 2 3 4 5 6 7 8 9 10 11 Period 1 2 3 4 5 6 7 8 9 10 11 12 SESS 10 10 10 10 57 56 оннNUUо 55 55 52 51 51 50 47 49 46 a = 0.2 Forecast α = 0.4 Forecast

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.