The manager wants to forecast the month 6's sales using the following historical data:MonthsMonth 1Month 2Month 3Month 4Month 5Sales2025323538Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, andweight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6.Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75

Answered: Months Month 1 Month 2 Month 3 Month 4…

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:
The sale data is shown as follows: Month 1: 11 Month 2: 52 Month 3: 95 Using Weighted Simple Moving Average method (Month 1: 0.2; Month 2: 0.3; Month 3: 0.5) to forecast the sales of Month 4: ________ (Round your answer to the nearest integer)
Show the steps on excel to plot the graph and insert the equation on the graph
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
Consider the following from an estate agent business: Month Houses Sold Jan 380 Feb 360 Mar 390 Apr 400 May 390 June 380 July 394 Aug 454 Sep 460 Oct 460 Nov 430 Dec 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) A detective figures he has a one in nine chance of recovering stolen property. His out-of-pocket expenses for the investigation are $9,000. If he is paid his fee only if he recovers the stolen property, what should he charge clients in order to breakeven? c) At the races, your horse, has a probability of 1/20 of coming 151, 1/10 of coming 2nd and a probability of ¼ in coming 3rd. First place pays $4,500 to the winner, second place $3,500 and third place $1,500. Hence, is it worth entering the race if it costs $1,000? d) Your company plans to invest in a particular…
Assume Sandra's forecasted ADR for the night is $1600.99. What would be her estimated total room revenue for this day? ADR = Total room revenue / Number of rooms sold
Given is a historical time series for job services demand in the prior 6 months. Month 1 2 3 4 5 6 Demand 799 816 789 814 815 805 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = Blank 1 (in 2 decimal places)
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
For the following data, calculate 'MAPE' Month Forecast Actual 1 1100 950 1100 1050 6. 3 1100 1100 4 1100 1200 5 1100 1090 б 1100 1070
The long-term financial forecast plays a crucial part in the company's long-term strategic plan. True or False True False 25 28 étv N 4
A ski resort has recorded its recent sales as follows (in $$). Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600 The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall? Answer: _______
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: CASES OF MERLOT WINE 276 362 YEAR 2005 2006 2007 2008 2009 2010 2011 2012 404 462 364 506 416 382 Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast for 2008, and then smooth the forecast forward to 2012. (Round your intermediate calculations and final answer to the nearest whole number.) Answer is complete but not entirely correct. Forecast for 2012 372

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