Please answer and provide excel explanation of each step. The last picture is all the relevant info needed.

In C4 create a calculation to add the Increment (the amount our forecast is increasing by) in B3 to the volume in B4. (Note we want the ability to change the increment so do NOT just add 100, use a relative reference or a range name). Drag the formula across to G4 n row 5 calculate the total sales revenue for each of the different Sales Volumes. Complete the variable costs table for the different sales volumes (B8:G14) In row 16 calculate the Contribution Margin for each sales volume. In row 17 calculate Contribution Margin less Fixed Costs for each sales volume. In B20:G22 complete the income tax for each sales volume. Formulas must take into consideration that in some cases there may have been a loss in which case the income tax should be 0. (Do NOT just type the 0 as the model should work with different inputs.) In row 24 calculate the profit after factoring in the income tax. In row 26 work out the profit for each sales volume as a percentage of sales. (Format as a percentage with 2 decimal places, do not apply rounding formulas.) Complete the Break-Even Analysis Line Chart Data in B29 to G32 for each of the Unit volumes. (Note Total Costs = Variable Costs + Fixed Costs+ Income Tax) Using the data generated in question D9, create a Line Chart that plots the Total Fixed Costs, Total Costs & Total Sales. Add the Volume Units as Horizontal Axis Labels and add the Chart Title "Break-Even Analysis". (N.B. Only include one chart ensure it is on the Forecast Sheet and that it is a 2D Line Chart with no line markers (not a Scatter chart with smooth lines) In C4 create a calculation to add the Increment (the amount our forecast is increasing by) in B3 to the volume in B4. (Note we want the ability to change the increment so do NOT just add 100, use a relative reference or a range name). Drag the formula across to G4 n row 5 calculate the total sales revenue for each of the different Sales Volumes. Complete the variable costs table for the different sales volumes (B8:G14) In row 16 calculate the Contribution Margin for each sales volume. In row 17 calculate Contribution Margin less Fixed Costs for each sales volume. In B20:G22 complete the income tax for each sales volume. Formulas must take into consideration that in some cases there may have been a loss in which case the income tax should be 0. (Do NOT just type the 0 as the model should work with different inputs.) In row 24 calculate the profit after factoring in the income tax. In row 26 work out the profit for each sales volume as a percentage of sales. (Format as a percentage with 2 decimal places, do not apply rounding formulas.) Complete the Break-Even Analysis Line Chart Data in B29 to G32 for each of the Unit volumes. (Note Total Costs = Variable Costs + Fixed Costs+ Income Tax) Using the data generated in question D9, create a Line Chart that plots the Total Fixed Costs, Total Costs & Total Sales. Add the Volume Units as Horizontal Axis Labels and add the Chart Title "Break-Even Analysis". (N.B. Only include one chart ensure it is on the Forecast Sheet and that it is a 2D Line Chart with no line markers (not a Scatter chart with smooth lines)