Question

Problem 4.26 P Question Help George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Year Season 1 2 3 4 Winter 1,440 1.280 1,000 960 Spring 1,500 1.440 1,620 1,540 Summer 1,020 2,140 2,020 1,960 Fall 600 750 650520 George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats. Based on the given data and using the multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be number) sailboats (enter a whole

Answer 1

Ratios fall winter 1.13 1.00 0.78 0.75 spring 1.17 1.13 summer 0.80 1.68 1.58 1.53 1.40 1.27 0.47 0.59 0.51 0.41 0.49 1.21 Average 0.92 1.19 35 36 Forecast for one complete cycle Year 5 6500.00 1488 Ans 1940 2271 801 37 38 39 Demand of sails boat for year 5 spring 1940 40

E F 6 Data 7 Period Demand (y) Time (x) Average Ratio 8 Year 1 Winter 9 spring 10 summer 11 fall 1440 1500 1020 600 1277.50 1277.50 1277.50 1277.50 1.13 1.17 0.80 0.47 12 Year 2Winter 13 spring 14 summer 15 fall 1280 1440 2140 1277.50 1277.50 1277.50 1277.50 1.00 1.13 1.68 0.59 750 L 16 Year 3 Winter 17 spring 18 summer 19 fall 1000 1620 2020 650 1277.50 1277.50 1277.50 1277.50 0.78 1.27 1.58 0.51 20 Year 4 Winter 21 spring 22 summer 23 fall 24 960 1540 1960 520 1277.50 1277.50 1277.50 1277.50 0.75 1.21 1.53 0.41

Formulas:

B 6 Data 7 Period Demand (y) Time (x) Average Ratio 8 Year 1 Winter 9 spring 10 summer 11 fall 1440 1500 1020 600 =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =B8/E8 =B9/E9 =B10/E10 =B11/E11 12 Year 2Winter 13 spring 14 summer 15 fall 1280 1440 2140 750 =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =B12/E12 =B13/E13 =B14/E14 =B15/E15 16 Year 3 Winter 17 spring 18 summer 19 fall 1000 1620 2020 650 =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =B16/E16 =B17/E17 =B18/E18 =B19/E19 20 Year 4 Winter 21 spring 22 summer 23 fall 24 960 1540 1960 520 =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =AVERAGE(B8:B23) =B20/E20 =B21/E21 =B22/E22 =B23/E23

Ratios winter spring summer =F8 =F9 =F10 =F11 =F12 =F13 =F14 =F15 =F16 =F17 =F18 =F19 =F20 =F21 =F22 =F23 =AVERAGE(B30:B33) =AVERAGE(C30:C33) |=AVERAGE(D30:D33) =AVERAGE(E30:E33) Average 36_Forecast for one complete cycle 6500 =$B$36 * B34 / 4 006 Ans =$B$36 * C34 / 4 Year 5 =$B$36 * D34 / 4 =$B$36 * E34 / 4 Demand of sails boat for year 5 spring =1940