1. National mixer, Inc. sells can openers. Monthly sales fo a seven-month. period were as follows:SalesMonth(000 units)Feb---19March-18AprilMayJune-152018JulyAug.---2220a. Forecast September sales volume using each of the following:1. A five month-moving average2. The naïve approach3. A weighted using .60 for August, .30 for July, and .10 for June.b. Which method seems least appropriate? And Why?c. What does use of the term sales rather than demand presume?

Find the Given details below: Given details: Month Sales (000 units) Feb 19 March 18…

Answered: National mixer, Inc. sells can openers.…

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

A. Find the tracking signal for each month. B. Does the model provide acceptable answers!
Compute the one-step-ahead three-month and six-month moving-average forecastsfor July through December. What effect does increasing N from 3 to 6 have on theforecasts?
1. Discuss the differences between Qualitative and Quantitative forecasting models. How do Associative and Time Series techniques differ? 2. What is the Mean Absolute Deviation (MAD)? 3. Use the following set of data to calculate the Mean Absolute Deviation (MAD) for the following set of data. Actual (A:) Forecast (Ft) Forecast Error Absolute (Deviation) Month Forecast Eror January February March 45 45 42 50 34 45 April 48 40 Мay 38 45 MAD =
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales duringthe last 15 days wereDay: 1 2 3 4 5 6 7 8 9Number sold: 36 38 42 44 48 49 50 49 52Day: 10 11 12 13 14 15Number sold: 48 52 55 54 56 57a. Using linear trend equation method, predict future sales from the given data.b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain.
4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
A forecast for the first six months of the year revealed a tendency to underpredict the actual demand for the revitalized Hubig’s Pies plant in the Marigny. Month Actual Forecast January 675 600 February 720 700 March 640 620 April 510 495 May 480 410 June 565 535 What is the mean squared error of this forecast? a. 1,694 b. 1,873 c. 2,075 d. 1,469
Please explain the calculation to get get the answers in the column provided?!
It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…
To have a stable forecasting tool when using the simple moving average method, what value of N (the number of periods) should a firm choose among the following choices? a. 3b. 2c. 8d. 6
All forecasts are subject to error. Do you think topmanagers would be concerned about the effectson the firm if sales revenues or unit costs, forexample, turned out to be different from the forecasted level? How could you provide informationon the effects of such errors?
376.98 says its wrong
A producer of picture frames uses a tracking signal withlimits of ± 4 to decide whether a forecast should be reviewed.Given historical information for the past four weeks, computethe tracking signal and decide whether the forecast should bereviewed. Th e MAD for this item was computed as 2.

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