QUESTIONS All Ans to 3 Decimal Places1Use the Naiive method to forecast for Feb -Aug 2021Calculate a 2-period moving average forecast2Calulate a weighted forecast with 0.55, 0.25, 0.2Calculate the Forecast with a smoothing constant à = 0.35 and the Forecast for FEB = 1982Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts345 ABC DAll answers to 3 Decimal Places2020ActualJAN1000FEB899MARC1892APRIL 2225MAY2250JUNE 3251JULY 2750EF

As per our guidelines, we are supposed to answer only three sub-parts if multiples sub-parts are…

Answered: QUESTIONS All Ans to 3 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

Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
Problem 3-22 (Algo) 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:
Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here. Part 2 Week 1 2 3 4 5 6 7 8 9 10 Rentals 23 22 25 23 22 11 21 34 19 13 Part 3 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average LOADING... . (Enter your responses rounded to two decimal places.) Week Forecast 6 enter your response here Part 4 7 enter your response here Part 5 8 enter your response here Part 6 9 enter your response here Part 7 10 enter your response here Part 8 What is the…
Month Actual Forecast Jan 100 100 Feb 110 Mar 200 Apr 140 For the above data, calculate the exponential smoothed forecast for March. Use α = 0.8. A. 135 B. 117 C. 116 D. 108
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
Please answer all three subparts with explanation. I will really really upvote. Thanks
Part C Exponential Exponential Gasoline Demand Gasoline Month smoothed forecast smoothed forecast Exponential smoothed forecast (a = 0.25) Demand (a = 0.25) (a = 0.45) Exponential smoothed forecast (a = 0.45) Mar 900 920 920 1200 Apr May 755 915.00 911.00 1100 1000 650 875.00 840.80 g20 915.00 846 80 755 818.75 754.94 904.76 835.12 Jun 550 818.75 754.94 800 320 751.56 66272 645.74 746.83 Jul 625 751.56 662.72 650 600 550 Aug Sep 730 719.92 645.74 820 722.44 683.66 400 D Oct 1100 746.83 745.01 200 1 Nov 835.12 904.76 Mar Apr May Jun Jul Aug Sep Oct Nov 1. Make a comparative analysis out of your answers in the plotted data. (3-5 5 sentences)
Forecast based on averages. Given the following data: Period Number of Complaints 1 70 2 75 3 65 4 68 5 74 Prepare a forecast for period 6 using each of these approaches: a. A weighted average using weights of .50 (most recent), .30, .20 b. Exponential smoothing with a smoothing constant of .40
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 Week 1 Actual Passenger Miles (in thousands) 17 Week Forecasted Passenger Miles (in thousands) a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responses to two decimal places). 10 11 4 5 6 7 8 9 23 18 16 20 18 22 20 15 2 1 3 4 6 7 17.00 17.00 17.80 18.04 19.03 18.83 18.26 5 8 18.61 9 18.49 19.19 10 12 22 11 12
1
2. The AirGo is the largest publicly listed low budget airlines company. On the negative side for the company, which spent billions of dollars in development costs, is the consistently negative cash flow due to poor prediction of its passengers. Question: Airlines company approaches you to suggest possible methods for an effective Forecast and it's Monitoring & Controlling. Help the airlines for the better prediction of its passengers.

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

QUESTIONS All Ans to 3 Decimal Places Use the Naiive method to forecast for Feb -Aug 2021 2 Calculate a 2-period moving average forecast 3 Calulate a weighted forecast with 0.55, 0.25, 0.2