Question 1) The monthiy sales Of yamizí Battery company are asfollows:-MonthJales20002100150014001300Calcuiate fore cost sales for June using each of thefo llowing method: -i) Naive Method1M 3 Month Simple moving averogerTi) Exponentral smoothing using an a =0:3 cand mayforecast of 1600 units.

Forecasting is the process of predicting future data based on previous or past data and information.…

Answered: g Calcuiate fore cost sales for June…

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

Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Period Demand 1 40 2 40 3 43 4 41 5 41 A. The naive forecast for period 6 is __ B. Compute a weighted average forecast using a weight of .40 for the most recent period. .30 for the most recent, .30 for the next, the forecast for period 6 is __
State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.
8.6 Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing constant is 0.2, and the old forecast for month 1 is 245. Month 1 2 3 4 5 6 LO Actual Demand 260 230 225 245 250 Forecast Demand
Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10 weeks are shownin the ta ble below: a) Forecast demand for each week, including week 10, usingexponential smoothing with a = .5 (in itial forecast = 20).b) Compute the MAD.c) Compute the tracking signal.
Please solve this
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two moving average forecasting methods to see which one was better over this period. Month Actual Demand Jan 120 Feb 140 March 160 April 180 May 170 June 190 July 150 August 160 September 170 a. Forecast April through September using a three-month moving average and calculate MAD for the forecasts. b. Forecast May through September using a four-month moving average and calculate MAD for the forecasts.
Use simple exponential smoothing with a=0.6 to forecast chargers sales for February through May. Assume that the forecast for January was 24 chargers. *** Month January Charger Sales 42 February 33 March 28 April 59 May ? a) What will be the forecast for May? b) Calculate the MSE.
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. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September 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? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?

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

g Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1) 3 month Simple moving avereges Ti) Exponentral smoothing using an a =0:3 and muy forecast of l600 units.