The Toro Cutlery Company has collected monthly sales information below:MONTHJanuaryFebruaryMarchAprilThe company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales.a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number.Forecast (January, 3-month MA): 87667Forecast (January, 4-month MA): 72500Forecast (January, 5-month MA): 69600b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearestwhole number.SALES25,00018,00043,000110,000MONTHMayJuneJulyAugustSALESMONTH84,000 September28,000October97,000 November58,000 DecemberSALES27,000105,00082,00076,000

Forecasting is knowing the part of future events by making predictions and estimates mainly based on…

Answered: What will the forecast be for January…

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

Demand for oil changes at Garcia's Garage has been as follows: Number of Oil Changes January 44 February 49 March 66 IT April 59 May 53 June 58 59 63 Month July August a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For Janu The forecasting model is given by the equation Y=+x. (Enter your responses rounded to two decimal places) J Show Transcribed Text >. Use the model to forecast demand for September, October, and November. Here, X=9, 10, and 11, respectively. (Enter your responses rounded to two decimal places.) Forecast for the number of Oil Changes Show Transcribed Text Month September October November can you do all the parts please corrrect
The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. Note: Enter your answers in millions. YEAR 1 2345 5 6 7 8 9 10 11 Period 12 13 14 15 REVENUE (MILLIONS) $4,865.7 5,072.3 5,507.7 5,738.2 5,495.4 5,198.7 5,087.0 5,111.5 5,559.7 5,740.4 5,868.4 Forecast
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October Actual Demand 105 82 110 112 108 106 130 120 Forecast Demand 100 108 97 98 108 102 105 107 November December For the given forecast, the tracking signal = MADS (round your response to two decimal places).
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
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The t below shows the number of emergencies each evening. Weekday Number of calls each day Monday 10 Tuesday 2 Wednesday 12 Thursday 12 (Round your answer to 1 decimal place.) What would be their forecast for the emergencies on Friday using a two-day moving average approach? Forecast for Friday calls
Professor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gathered the following data: Week 6 weeks ago 5 weeks ago 4 weeks ago 3 weeks ago 2 weeks ago Last week # Students 83 110 95 80 65 50 What is this week's forecast using trend-adjusted (double) smoothing with alpha = .5 and beta = .1, if the forecast for last week was 65, the forecast for two weeks ago was 75, and the trend estimate for last week's forecast was -5? 49.3 78.7 51.3 50.6 65.4
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: D Price $2.50 $3.40 $2.10 $4.30 $3.00 $4.10 Using simple linear regression and given that the price per cup is $1.75, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place). Number Sold 765 515 975 245 315 480
A check-processing center uses exponetial smoothing to forecast the number of incoming checks each month. the number of checks recewived in June was 40 million while the forecast was 42 million. A smoothibg constant of 0.15 is used. a) Using exponential smoothing and given a the forecast for the month of July={__} million checks received (round your response to one decimal place
The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months. Compute an exponentially smoothed forecast with an a value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals) Month October November December January February March April May June July 733.25 Gasoline Demanded (gal.) 800 725 630 500 645 690 730 810 1,200 980

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