Question: Question # 1/11 marks] The following table shows monthly demand during the past five months for one of a firm's major products: the standard 26-inch
Question # 1/11 marks] The following table shows monthly demand during the past five months for one of a firm's major products: the standard 26-inch 10-speed street bike. 220+ 0.2 = 220,2 simple a) Calculate the demand forecast for November using simple exponential smoothing with a = 0.2 and September forecast = 250. Exponential Smoothing +0.7 250 - 236 x | A +-1 - F -1) where a = 8.4 and 235, respectively. 21 74 -1 Month June July August September October L = J Demand 220 245 265 0.1 2306 215 F + = F+= =+=1+2 | A+=1 - Ft October > Ft = 1890 +0.1 (250-130) Apparty bound Soreast sejfmbre Novembror ft- October foresit +0.dis-?) b) Calculate the demand forecast for November using the exponential smoothing with trend method 0.2 and 8=0.3. Assume trend component and Forecast including trend for October are #+-1 - F+ -1 ) sep 1 frost 0.2 (215 2 +02 (215 - F1_1 ewlier good for at A+ 135 October AF & St + (1-2) (A+++ +-1) +x=> [A+ = $ 1-1/16 - 14-1 * 6.3 A 2 = 00 2 / 2 13 ) + ( 1 = 0.27 ( 235 + 0, 4/ A++++ = F + + +
The following table shom monthly demand during the past five months for one of a firm's major products: the standard 26 -inch 10 -speed street bike a) Calculate the demand forceast for November using simple exponential smoothingt with a =0.2 and September forceast -250. b) Caleulate the demand forocast for November using the exponential smoothing with trend method where =0.2 and =0.3. Assume trend component and Forecast including trend for Oetober are 8.4 and 235 , respectively
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
