How do I completed the excel copy on the right hand side of the imagine to calculate the forecast for year 5 using a linear forecast? Please show formulas used in excel and (hint: use Linear Forecast sheet which is the excel sheet).

H47 X V fx B E F H Question 2 Slope Intercept Month Year 1 Seasonality Index Deseasonalitze Extrapolate Forecast 1 55,220 57 ,350 15,445 27.776 21,408 17,118 11 18,028 12 8 19.883 13 15,796 14 10 53,665 C D E F G H I 15 B 11 83,269 A 16 12 72,991 13 39,875 64, 128 Demand Question 1 15 47.653 16 43,050 Month Year 1 Year 2 Year 3 Year 4 Season Average Seasonality Index 17 39,359 10,317 W 55,220 39,875 32, 180 62,377 47,413 1. 1187902 19 45,194 20 46.530 57,350 64, 128 38,600 66,501 56,645 1.3366290 22, 105 41,350 15,445 47,653 25,020 31,404 29,881 0.7050811 23 46,024 27,776 43,050 51,300 36,504 39,658 0.9357860 24 41,856 25 32, 180 21,408 39,359 31,790 16,888 27,361 0.6456351 38.600 27 25,020 17, 118 10,317 31, 100 18,909 19,361 0.4568557 28 51,300 3 76 0 VOU A W N - 29 31,790 18,028 45, 194 59,832 35,500 39,639 0.9353377 0 31,100 19,883 46,530 30,740 51,250 37, 101 0.8754552 31 59,832 32 30,740 15,796 22, 105 47,800 34,443 30,036 0.7087504 47.800 34 73,890 53,665 41,350 73,890 68,088 59,248 1.3980630 35 60.202 36 55.200 83,269 46,024 60,202 68, 175 64,418 1.5200402 37 62,377 8 66,501 14 72,991 41,856 55,200 61, 100 57,787 1.3635764 39 31.404 40 36,504 15 42,379 41 16,888 18,909 43 35,500 44 51,250 45 34.443 68 088 47 68. 175 48 61,100 49 50