Note:-Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure. PA 15-5 My App is a small but growing start-up that sees...My App is a small but growing start-up that sees demand for several of its apps increasing quickly. Thetable below shows the last six months of downloads. Use a forecast for the first month of 200000, aninitial trend forecast of 50000, and smoothing parameters of 0.25 for both demand smoothing and trendsmoothing.a.b.Month(t)Answer is complete but not entirely correct.123456Monthly ApplicationDownloads245,000250,100328,000440,000420,000484,000Forecast for NextMonth(Round your answer to 2 decimal places.)Month 7's forecast is:Trend50,000.00200,000.00211,250.0048,750.00 X285,650.0036,900.00 X323,913.0038,263.00 X38,163.0057,719.00434,513.00 52,881.00 X486,545.00 X52,033.00 X(Round your answer to 2 decimal places.)Complete the table above, filling in the "Forecast for next month" and "Trend" columns, usingdouble exponential smoothing.403,933.59 X

Single exponential smoothing is good time series is free of seasonal or trend components.Single…

My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 200000, an initial trend forecast of 50000, and smoothing parameters of 0.25 for both demand smoothing and trend smoothing. a. b. Month (t) 1 2 3 4 5 6 Monthly Application Downloads 245,000 250,100 328,000 440,000 420,000 484,000 Forecast for Next Month (Round your answer to 2 decimal places.) Month 7's forecast is: 200,000.00 211,250.00 285,650.00 323,913.00 Trend 50,000.00 48,750.00 X 36,900.00 X 38,263.00 57,719.00 X 38,163.00 434,513.00 52,881.00 486,545.00 52,033.00 (Round your answer to 2 decimal places.) Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double exponential smoothing. 403,933.59 X

My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 200000, an initial trend forecast of 50000, and smoothing parameters of 0.25 for both demand smoothing and trend smoothing. a. b. Month (t) 1 2 3 4 5 6 Monthly Application Downloads 245,000 250,100 328,000 440,000 420,000 484,000 Forecast for Next Month (Round your answer to 2 decimal places.) Month 7's forecast is: 200,000.00 211,250.00 285,650.00 323,913.00 Trend 50,000.00 48,750.00 X 36,900.00 X 38,263.00 57,719.00 X 38,163.00 434,513.00 52,881.00 486,545.00 52,033.00 (Round your answer to 2 decimal places.) Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double exponential smoothing. 403,933.59 X

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Similar questions

The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 220,000, an initial trend forecast of 35,000, and smoothing parameters of 015 for both demand smoothing and trend smoothing Month (t) Monthly Application Downloads Forecast for Next Month Trend 220,000.00 35,000.00 200,000 2 250, 100 334,000 380,000 440,000 500,000 (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double a. exponential smoothing (Round your answers to 2 decimal places.) Month 7's forecast is b.
The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals) O a. None is correct O b. 43.25 O c. 41 O d. 41.92 O e. 42.8
st Info Period 1 2 3 4 5 6 7 8 9 10 K Develop two exponential smoothing forecasts for periods 2 through 11. For the first forecast, use a = 0.3. For the second, use α = 0.7. Assume that your forecast for period 1 was 205. Click the icon to view the time series data. Find the exponential smoothing forecast for each period when a = 0.3 (enter your responses rounded to one decimal place). Demand 222 249 222 228 235 155 161 153 163 152 X Period 1 2 Demand 222 249 Forecast (α = 0.3) 205
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES QUARTER SALES 1. 211 5 155 235 6 198 3 206 7 154 4 190 8 142 Use regression and seasonal indexes to forecast quarterly sales for the next year. (Do n ot round intermediate calculations. Round your answers to the nearest whole number.) Answer is complete but not entirely correct. Quarter Forecast 142 8 157 8 121 8 10 11 12 103
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 215 2 240 3 205 4 190 5 160 6 195 7 150 8 140 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to 1 decimal place.
The Nuts’n’Bolts hardware store stocks some high-value items and a large number of rel- atively low-value components. Inventory is reviewed weekly, and orders are placed with suppliers when inventory levels indicate that current levels are “too low.” Most suppliers deliver the low-value items within two weeks; some of the high-value items may take four weeks for delivery. How would you develop a forecasting system to predict the sales of such items at the individual (SKU ? stock-keeping unit) level? How would you use such fore- casts to plan future purchases?Use PHIVE to go through the necessary steps. For purposes of the discussion, assume that that any historical data you might need can be made available.
It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…
Evaluate what is the purpose of a forecast. What factors does a firm use to create its forecasts of future sales, income, expenses, and capital expenditures?
4, The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange 09/03/2010 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72…
Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecasts and specify what procedure you would utilize. Month Actual Demand 1 64 2 67 3 69 4 65 5 71 6 73 7 76 8 77 9 77 10 82 11 83 12 85 Calculate the simple three-month moving average forecast for periods 4–12.(Round your answers to 3 decimal places.) Month Actual Demand 4 66.667 5 67.000 6 68.333 7 69.666 8 73.333 9 75.333 10 76.666 11 78.666 12 80.666 Calculate the weighted three-month moving average for periods 4–12 using weights of 0.30 (for the period t−1); 0.20 (for the period t−2), and 0.50 (for the period t−3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Month Actual Demand 4 66.7 5 67.0 6 68.3 7 69.7 8 73.3 9 75.3…