The following table shows the actual demand observed over the last 4 years:YearDemand18Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers)YearForecast (NA)282Using exponential smoothing with a=0.50 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place).1YearForecast (ES)7.0233634410455

Actual Demand for last 4 years is given below:

Answered: The following table shows the actual…

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

Below is the actual demand for electrical boxes for Abco Electric for the last nine periods along with a forecast. A) Complete the Mean Absolute Deviation for this forecast. B) Complete an additional forecast for periods 4-12 using a weighted moving average of your choice. Change the title to describe your method. C) Calculate the MAD for your forecast. D) In the text box below put your comment comparing the accuracy of your forecast versus the one given in A. Was your method more accurate? Why or why not? Use whole numbers for all forecasts. Use ONE decimal place for the MAD calculations. Period Demand Naïve Method Error (e) MAD Your Title here Your MAD 1 855 Abs e Abs e 2 910 3 930 4 890 930 5 935 890 6 980 935 7 1020 980 8 960 1020 9 905 960 10 895 905 11 955 895 12 820 955 MAD D. Your comment on Forecast Accuracy:
usexx=23 need urgent
Prepare a graph of the monthly forecasts and average forecast demand for Chicago Paint Corp., a manufacturer of specialized paint for artists. Compute the demand per day for each month (round your responses to one decimal place). Month January February March April May June July August September October November December Choose the correct graph of the forecast demands below. OA Production Days 2222222222 23 19 20 21 20 23 21 20 19 Demand Forecast 950 1,050 1,250 1,350 1,300 1,300 1,250 1,150 1,050 1,000 1,000 950 Demand per Day 325
Please do not give solution in image format thanku
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.
For the data below, answer the following four questions: Period Demand 1 58 2 59 3 60 4 61 What would be the simple moving average forecast for the 5th period? 68.2 58 60.7 59.5 61
Consider the following yearly demand values for a particular product. Year Demand 1 360 389 3 410 4 381 368 374 (a) Produce forecast for year 4,5,6, and 7 by using 3-week moving average. (b) Produce forecast for year 4,5,6, and 7 by using 3-week weighted moving average where weights are as follows; wt–3 = .1, wt-2 = .3, and wt-1 = .6. (c) Produce forecast for year 4,5,6, and 7 by using exponential smoothing with a = .2. Please assume that the forecast for the first year is 360.
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a 3-year moving average to forecast demand?
The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 2 40 3 40
Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows Year Mileage 1 3,100 2 4,000 3 3,450 4 3,850 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 108.3 miles (round your response to one decimal place). (Hint. You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = miles (round your response to the nearest whole number)
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.

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