Please include formulas for understanding.

3.3 33 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 34 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 35 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 36 manager) 37 38 39 40 Winter Life Sports Manufacturing 41 42 Consensus Increase 43 Income Revenues Year 2017 2018 2019 2020 2021 44 Units Sold 132000.00 45 Unit Price $10.50 46 Gross Revenue $1,386,000.00 47 48 Expenses Fixed Costs 49 Production facility $64,800.00 50 Administration $33,600.00 51 52 Variable cost 53 Unit mfg cost $5.50 54 Variable mfg cost $5.00 55 Utilities $30,300.00 56 57 Earnings before taxes 58 59 60 Assumptions Initial Values Consensus Pessimistic Optimistic 61 Increase Increase Increase 62 63 First year sales (units) 120000 0.1 0.05 0.2 64 Selling price 10.00 0.05 0.01 0.1 65 Unit mfg cost 5.00 0.1 0.05 0.15 66 Production facility 60,000.00 0.08 0.05 0.1 67 Utilities 30,000.00 0.01 0.009 0.012 68 Administration 32,000.00 0.05 0.02 0.09 69 First year of forecast 2016