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 5years are as follows:YearMileage13,05024,05033,45043,85053,700a) Using a 2-year moving average, the forecast for year 6 =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 = miles (round your response to one decimal place). (Hint: You will have only 3 years of matcheddata.)c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = miles (round your response to thenearest whole number).The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.35 and 0.65= miles (round your response to one decimal place). (Hint: You will have only3 years of matched data.)d) Using exponential smoothing with a = 0.30 and the forecast for year 1 being 3,050, the forecast for year 6 =miles (round your response to the nearest whole number).

Forecastin's primary goal of forecasting is to decrease uncertainty and make corrective decisions by…

Answered: a) Using a 2-year moving average, the…

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

please answer within 30 minutes.
9) Gasoline sales Times Series week sales (1000s of gallons 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 With the above gasoline time series data, show the exponential smoothing forecast using alpha = 0.1 i)Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of Alpha= 0.1 or alpha=0.2 for the gasoline sales time series? ii)Are the results the same if you apply MAE as the measure of accuracy? iii)What are the results if MAPE is used?
snip
Compute the forecast sale using α = 0.20 and α = 0.35 respectively. (Note: express all answers using 4 decimal places)
Jean and Dinah had been in business for two years producing umbrellas to be sold to the cruise ship passengers when they docked. They found that they are constantly out of umbrellas and had to rush producions which has resulted in the increase of their production cost. Jean has a nephew who is enrolled in the UWIOC and he advised her to prepare forecasted qualities using the sales that they made over the past months. The data below represents sales for the last 9 months. In order to assist Jean and Dinah you are asked to; a. plot the data on a graph showing the trend b. determine the equation of the trend line c. predict sales for month 10 and 11. Months Sales 1 44 2 52 3 50 4 54 5 55 6 55 7 60 8 56 9 62
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
Please do not give solution in image formate thanku.
d) Using exponential smoothing with α = 0.40 and the forecast for year 1 being 3,000, the forecast for year 6 = ? miles (round your response to the nearest whole number).
January February March April May June a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. February March April May June ACTUAL FORECAST 100 85 96 103 82 66 90 MAD Forecasts 91 93 97 91 81 b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
Given the following original forecast and actual data: Month Actual Forecast Jan Feb Mar Apr May Jun Jul 600 475 550 575 688 649 ??? 400 —— 1 ??? Using exponential smoothing with a - = 0.64, what is the forecast for July. Round your answer to 2 decimal places.
a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decis and include a minus sign if necessary.) Y= - 23 + .945 x where Y = Production rating and X = Test score. b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.) c. Comment on the strength of the relationship between the test scores and production ratings. The coefficient of correlation for the least-squares regression model is and the coefficient of determination is (Enter your responses rounded to three decimal places.) More info Test Score Production Rating Production Test Worker Worker Rating Score A 55 43 K 58 57 B 38 43 75 75 93 87 67 48 D 86 77 31 26 E 88 82 62 49 F 66 68 24 25 G 55 47 Q 78 84 Clear all Check 50 46 34 32 41 41 51 58 J 69 74 T 39 30 Print Done LLMN OPoRS

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