Need help from CVP analysis to last.Section C The following are to be completed in the CVP Analysis Worksheet 17C1 In B14 calculate the Total Fixed Costs. 1 ?C2 In E5, using the information in the BoM, calculate the Direct Material Cost per unitspecified in B3. (Note Do NOT use the value in BoM!K9 as this can be for anotherproduct, and ensure the calculation works regardless of sort order in the BoM.)2 ?C3 In E6 use the information in the Labour Costs sheet to calculate the Direct LabourCost per unit. Note if the values in the changes this figure should update.1 ?C4 In E9 calculate the Variable Manufacturing Cost per unit. 1 ?C5 In E14 calculate the Variable Selling & Admin Cost per unit (as a %). 1 ?C6 In H4 calculate the Contribution Margin per Unit (this is the Unit Sales Price less theVariable Manufacturing Cost per unit and the Variable Selling & Admin Cost perunit).2 ?Question Instruction Marks DoneC7 In H5 calculate your break-even volume (in units) rounded up to 0 decimal places.(This answer is very important so double check it, multiply it by the variable costfigures and add the fixed costs back in and unrounded it should give you 0).2 ?C8 In H6 multiply the Break-Even Volume in Units by the Unit Sales Price to calculatethe Break-Even Sales Value.1 ?C9 In H9 to H14 calculate the Break-Even Variable Costs using the calculated figures inH5 or H6 (where appropriate). Note, each answer is worth ½ mark which will only beawarded if the answer is correct.3 ?C10 In H15 calculate the Total Break-Even Variable Costs. (Answer must be correct to getmark.)1 ?C11 In H17 calculate the Break-Even Contribution Margin. 1 ?C12 In H18 calculate the Profit Before Tax. (If we hadn't rounded this should be 0). 1 ?Section D The following are to be completed in the Forecast Worksheet 20D1 In C4 create a calculation to add the Increment (the amount our forecast isincreasing by) in B3 to the volume in B4. (Note we want the ability to change theincrement so do NOT just add 100, use a relative reference or a range name). Dragthe formula across to G41 ?D2 In row 5 calculate the total sales revenue for each of the different Sales Volumes. 1 ?D3 Complete the variable costs table for the different sales volumes (B8:G14). 4 ?D4 In row 16 calculate the Contribution Margin for each sales volume. 1 ?D5 In row 17 calculate Contribution Margin less Fixed Costs for each sales volume. 1 ?D6 In B20:G22 complete the income tax for each sales volume. Formulas must take intoconsideration that in some cases there may have been a loss in which case theincome tax should be 0. (Do NOT just type the 0 as the model should work withdifferent inputs.)5 ?D7 In row 24 calculate the profit after factoring in the income tax. 1 ?D8 In row 26 work out the profit for each sales volume as a percentage of sales. (Formatas a percentage with 2 decimal places, do not apply rounding formulas.)1 ?D9 Complete the Break-Even Analysis Line Chart Data in B29 to G32 for each of the Unitvolumes. (Note Total Costs = Variable Costs + Fixed Costs+ Income Tax)2 ?D10 Using the data generated in question D9, create a Line Chart that plots the TotalFixed Costs, Total Costs & Total Sales. Add the Volume Units as Horizontal AxisLabels and add the Chart Title "Break-Even Analysis". (N.B. Only include one chartensure 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).3 ?Section E The following are to be completed in the Inventory Worksheet 5E1 In H4 create a formula to convert the weight in grams to a weight in pounds. Thecalculation must round the result to 2 decimal places. (Ensure the formula is copieddown for the whole table.)2 ?E2 In J4 create a calculation to work out the reorder quantity. If the stock level is belowthe minimum level shown in M3, then reorder the appropriate amount as shown inthe Re-Order Quantities table (L5:M9), otherwise return 0. (Ensure the formula iscopied down for the whole table. Note you should have one consistent calculationfor the column and the calculations should work regardless of values or sort order.)