Please provide the detail excel formula for each blank

4 Lab Exercises (for submission) Open Excel_Sess4_Lab1.xlsx. 1. Fill in the Sales Forecasts for years 2 to 5, based on the given Growth Assumptions. This is the 'Normal' scenario. 2. Load the Solver add-in, and create two more scenarios as follows: 'Optimistic' scenario - the total sales in year 5 is $2,000,000. 'Pessimistic' scenario - the total sales in year 5 is $1,000,000. 3. Using a suitable chart type, display the Total Sales from Year 1 to Year 5. B C D G Year 4 Year 5 Growth Assumptions 15% 10% 15% 20% 1 Company A's sales forecast for the next 5 years 2 3 Sales Forecasts 4 Year 1 Year 2 Year 3 5 Shoes $125,000 3 Jeans $500,000 7 Belts $240,000 3 Caps $80,000 3 Total Sales $945,000 0 1 2 3 4 5 6 7