I need excel formulas to fill out the grey shaded cells. please and thank you

3.3 32 33 34 35 36 37 38 39 40 41 Winter Life Sports Wear Manufacturing manufacturers a complete line of sportswear. The marketing manager has been asked to produce a 5 year forcast on a new product- battery operated thermal socks. The manager has been asked to prepare and show 3 different projections or scenarios using the data assumptions provided below. Complete the following exercise and produce a web page to show one (1) business case. Pay attention to accuracy and formatting . 10 marks BONUS Show an example of data validation and a comment in your work 6 marks (hint: scenario manager) Winter Life Sports Manufacturing 0 Revenues Year Units Sold Unit Price Gross Revenue Fixed Costs Production facility Administration Variable cost Unit mfg cost Variable mfg cost Utilities 42 43 Income 44 45 46 47 48 Expenses 49 50 51 52 53 54 55 56 57 58 59 60 Assumptions 61 62 63 64 65 66 67 68 69 70 71 72 Earnings before taxes Initial Values Consensus Increase Pessimistic Optimistic Increase Increase First year sales (units) Selling price Unit mfg cost Production facility Utilities Administration First year of forecast 120000 $ 10.00 $ 5.00 $ 60,000.00 $ 30,000.00 $ 32,000.00 2016 0.1 0.05 0.1 0.08 0.01 0.05 0.05 0.01 0.05 0.05 0.009 0.02 0.2 0.1 0.15 0.1 0.012 0.09