Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with aweighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1.YearDemand (Bags)46.34.4.1068.8.8.1210141115O A. 13.67O B. 14.00OC. 14.87O D. 11.79Click to select your answer.UsMacBook Air888* ESF2F4F6F74)F9F10%232$&*46.789.QWRTYFCVВaltcommandcommandoption%#3

YearDemand 1426344551068778891210141115Weight 1 = 2Weight 2 = 1Weight 3 = 1

Answered: Data collected on the yearly demand for…

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

George Kypansis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows Year P Season Winter Spring Summer Fall 1 1.400 1,520 1,000 640 2 1,200 1,420 2,100 770 3 1,000 1,620 2,020 650 4 900 1,580 1,960 560 George has forecasted that annual demand for his sailboats in year 5 will equal 6.500 sailboats Based on the given data and using the seasonal model, the demand level for George's salboats in the spring of year 5 will be sailboats (enter your final answer as a whole number and round a intermediate calculations to two decimal places)
DEMAND FOR FERTILIZER YEAR (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 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a 3-year moving average to forecast demand. Forecast demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the…
Problem 18-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. Last year This year JAN 150 170 FEB MAR 170 190 190 APR MAY 235 225 175 245 270 Forecast for the third quarter JUN 250 215 SEP 175 AUG JUL 195 185 OCT 250 ▸ NOV DEC 275 295
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and inventory data to determine planned order releases in central warehouses. address each problem using full sentences and proper spelling and grammar and submit in an Excel template. 2. For the warehouse of Figure 14.8, suppose actual demands were 24, 16, and 18 in periods 1, 2, and 3, respectively. The initial DRP record is: Forecast requirements In transit Projected available balance Planned shipments Q=40; lead time=1; SS=6. 6 1 20 40 26 Period 2 3 4 5 20 20 20 20 6 266 26 40 40 a. Create the other three DRP records as done in Figure 14.8. What problem is created in period 2? What can be done? b. Does error addback work for this set of circumstances?
I'm trying to determine optimal order quantity but only have a Mean forecast and a standard deviation of it to use for sales data. How would I determine the sales data to use in the optimal order quantity formula?
Please solve this
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
12.7 The Intrepid mutual fund of growth stocks has had the following average monthly price for the past 10 months. Month 1 2 3 4 5 6 7 8 9 10 Fund Price 62.7 63.9 68.0 66.4 67.2 65.8 68.2 69.3 67.2 70.1 Compute the exponentially smoothed forecast with a = 0.40, the adjusted exponentially smoothed forecast with a = 0.40 and ß = 0.30, and the linear trend line forecast. Compare the accuracy of the three forecasts using cumulative error and MAD, and indicate which forecast appears to be most accurate.
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 2 6 7 10 3 4 5 6 7 8 9 a. Calculate the single exponential smoothing forecast for these data using an a of 30 and an initial forecast (F of 31. (Round your answers to 2 decimal places) Month 50 Month 31 4 5 6 7 b. Calculate the exponential smoothing with trend forecast for these data using and of 0:30, a 5 of 0.30, an initial trend forecast (Tof 1, and an initial exponentially smoothed forecast (F3 of 30. (Round your answers to 2 decimal places) B 9 Exponential Smoothing 10 31 34 33 35 FITI 37 36 38 40 40 41 e-2. Which is best? c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your answers to 2 decimal places) MAD Single exponential smoothing forecast Exponential amoothing with trend forecast Single exponential smoothing forecast O Exponential smoothing with trend forecast
Please solve this question...
Demand at Nature Trails Ski Resort has a seasonal pattern.Demand is highest during the winter, as this is the peak ski season.However, there is some ski demand in the spring and even fallmonths. Th e summer months can also be busy as visitors oft encome for summer vacation to go hiking on the mountain trails.Th e owner of Nature Trails would like to make a forecast for eachseason of the next year. Total annual demand has been estimatedat 4000 visitors. Given the last two years of historical data, what isthe forecast for each season of the next year?

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