Question: 4.10. Prepare a spreadsheet model for the ferry passenger data in Table 14.6 g, and recalculate the forecasts using an a of 0.3, a of

4.10. Prepare a spreadsheet model for the ferry

4.10. Prepare a spreadsheet model for the ferry passenger data in Table 14.6 g, and recalculate the forecasts using an a of 0.3, a of 0.1, and a y of 0.2. Has this change in the smoothing constants improved the MAD? Noon 422 A B D m E F G I 1 alpha 0.2 2 beto 0.2 3 gamma 0.3 4 Actual Smoothed TrendIndex Forecast Error 5 Period + At St T! A Ft A-FH 6 2019-2020 7 January 1 1,651 0.837 8 February 2 1,305 0.662 9 March 3 1,617 0.820 10 April 4 1,721 0.873 11 May 5 2,015 1.022 12 June 6 2,297 1.165 13 July 7 2,606 1.322 14 August 8 2,687 1.363 15 September 9 2,292 1.162 16 October 10 1.981 1.005 17 November 11 1,696 0.860 18 December 12 1,794 1,794.00 0.00 0.910 19 January 13 1,806 1,866.74 14.55 0.876 20 February 14 1,731 2,027.99 43.89 0.719 1,245 486 21 March 15 1733 2,080.19 45.55 0.824 1,699 34 22 April 16 1.904 2,136.79 47.76 0.878 1,856 48 23 May 17 2,036 2.146.07 40.071.000 2,233 197 24 June 18 2.560 2,188.39 40.52 1.166 2,547 13 25 July 19 2,679 2,188.42 32.42 1.293 2,947 268 26 August 20 2.821 2,190.61 26.37 1.340 3,027 206 27 September 21 2,359 2,179.61 18.90 1.138 2,576 217 28 October 22 2,160 2.188.66 16.93 1.000 2.210 50 29 November 23 1.802 2,183.54 12.52 0.850 1,897 95 30 December 24 1,853 2,164.10 6.13 0.894 1,998 145 31 32 MAD 160 11 Tai

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

4.10. Prepare a spreadsheet model for the ferry passenger data in Table 14.6, and recalculate the forecasts using an of 0.3 , a of 0.1 , and a of 0.2 . Has this change in the smoothing constants...

TABLE 14.6 Exponential Smoothing with Seasonal and Trend Adjustments: Excel Spreadsheet Illustration Ferry Passengers Taken to a Resort Island (alpha=0.2, beta =0.2, gamma =0.3 ) 4.10. Prepare a...

please use questions 14.10 and the table to answer questions 20-22 14.10. Prepare a spreadsheet model for the ferry passenger data in Table 14.6 0 , and recalculate the forecasts using an of 0.3, a...

What is the revised forecast (Ft) for December? Do not round your forecast to a whole number. Your Answer: Answer Question 18 (5 points) What is the new MAD? Your Answer: Answer Question 19 (5...

Prepare a spreadsheet model for the ferry passenger data in [ Table 14.6, and recalculate the forecasts using an a of 0.3, a of 0.1, and a y of 0.2. Has this change in the smoothing constants...

Prepare a spreadsheet model for the ferry passenger data in Table 14.6, and recalculate the forecasts using an of 0.3, a of 0.1, and a of 0.2. Has this change in the smoothing constants improved the...

Prepare a spreadsheet model for the ferry passenger data in Table 14.6 , and recalculate the forecasts using an a of 0.3, a b of 0.1, and a g of 0.2. Has this change in the smoothing constants...

14.10. Prepare a spreadsheet model for the ferry passenger data in Table 14.6, and recalculate the forecasts using an of 0.3, a of 0.1, and a of 0.2. Has this change in the smoothing constants...

Use a three - month moving average to make a forecast for July. 1 4 . 5 . For the data in Exercise 1 4 , 4 , use an of 0 . 1 to make a forecast for July. 1 4 . 6 . For the data in Exercise 1 4 . 4 ,...

PLEASE ANSWER QUESTION 20-22 ! Prepare a spreadsheet model for the ferry passenger data in Table 17.6, and recalculate the forecasts using an a of 0.3, a B of 0.1, and a of 0.2. Has this change in...

Based on the recent increase in residential property prices in Dublin a company has decided to diverse its investment portfolio and invest in property. The company is considering purchasing a newly...

Which of the following is an example of qualitative data? A. preferred color of most employees in the organization B. increase in profit margin over a five-year period C. average weight of employees...

SullivanSullivan Corporation manufactures lamps. It has set up the following standards per finished unit for direct materials and direct manufacturing labor: LOADING... ( Click the icon to view the...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...