Compute the forecast sale using α = 0.20 and α = 0.35 respectively.(Note: express all answers using 4 decimal places) Exponential SmoothingThe following data shows the monthly sales (millions of pesos) of a product over the pastperiods.Actual25.6024.7021.3013.9012.6018.0021.5022.3030.7015.0013.8022.60DataMonth May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19

Forecasting is the process of estimation in which the future demand is determined based on previous…

Answered: Compute the forecast sale using α =…

Business

Operations Management

Compute the forecast sale using α = 0.20 and α = 0.35 respectively. (Note: express all answers using 4 decimal places)

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

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
Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.7. Forecast the number of calls for week 6, which is next week.
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: _______
Respond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LO
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OFMERLOT WINE 2005 321 2006 407 2007 449 2008 507 2009 409 2010 551 2011 461 2012 427 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.
If a 2-year moving average is used to make the forecast, the Mean Absolute Deviation based on this how many miles?
Sales of the Crown Gems have been increasing over the past five years. The operations manager has estimated sales in 2017 to be 410 Crown Gems. Using exponential smoothing with a weight of α = 0.30, the forecasts for 2017 through 2022 were developed. The forecasts for 2017 through 2022 is: Year Forecast 2016 450 2017 450 2018 463.5 2019 479.85 2021 504.795 2022 528.5565 a. Advise Crown Gems of the benefits associated with this method of forecasting. b.Caution the manager on the limitations associated with your forecast.
Elna inc is a microwave manufacturing and distribution company based in Jakarta. The company needs to estimate production demand using the historical sales data of the last 24 months (periods).A logistics manager of the company then uses the moving average, exponential smoothing, and simple linear regression methods to determine sales forecasts for the next 12 months (Graphically illustrate the results). Provide an analysis and the results of bias, MAPE, MSE, and MAD for the forecasting decisions.Moving average is 4 month, and alfa is 0.05
24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) 1 83 2 78 3 75 4 81 5 86 6 85 7 89 8 90 9 86
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 miles (round your response to the nearest whole number). a) Using a 2-year moving average, the forecast for year 6 = 1 3,050 2 4,000 3 3,450 4 3,750 5 3,750
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 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3750 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 = 116.7 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.35 and 0.65 (the weight of 0.65 is for the most recent period) = 3750 miles (round your response to the nearest whole number). 1 3,050 2 3,950 The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.35 and 0.65 = data.) 3 3,400 3,750 miles (round your response to one decimal place) (Hint You will have only 3 years of matched
The Victory Plus Mutual Fund of growth stocks has had the following average monthly price for the past 10 months: Month Fund Price 1 62.7 2 63.9 3 68.0 4 66.4 5 67.2 6 65.8 7 68.2 8 69.3 9 67.2 10 70.1 Compute the forecast for Month 11 using the exponentially smoothed forecast with α=.40, Compute the forecast for Month 11 using the adjusted exponential smoothing forecast with α=.40and β=.30, and Compute the forecast for Month 11 using the linear trend line forecast. (Compute a and b by constructing columns xy and x^2) Compare the accuracy of the three forecasts, using cumulative error and MAD, and indicate which forecast appears to be most accurate.