can anyone help me on D 12 section?

Cost Volume Profit Analysis Product Name Unit Sales Price Total units sold Total Fixed Costs $ $ $ X-800 5,600.00 350.00 109,700.00 5 Variable Costs per Unit Vary with Unit Costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Total Vary with Unit Costs Break Even Analysis Contribution Margin Per Unit Rreak Even Volume in Units Break Even Sales Value s 1,540.27 1,548,60 120.00 80.00 3,288.82 1947.13 5633944514 315,500.89 S $ Vary-with-Revenue Costs Sales Commissions Other Vary with Revenue Costs Total Vary with Revenue Costs Break Even Variable Costs Direct Labor Direct Material Factory Overhead Other Vary with Unit Costs Sales Commissions Other Vary with Revenue Costs Total Variable Costs 86,778.18 87.247.26 6,760,73 4,507.16 15,775.04 4,732.51 205800.89 1.5% 6.5% $ S S Income Tax State Tax Federal Tax 100 5.0 Contribution Margin Profit Before Tax $ $ 109,700.00 1,644,499.11 O- NONSER Information Fored Costs HR Labour Costs BOM CVP Analysis Profit Volume Forecast Inventory i 9 e @ L question Instruction D1 In B4 use a formula to retrieve the Unit Sales Price from the Fixed Costs sheet for the product shown in B3. Marks 2 2 In B5 use a formula to retrieve the Unit Sale from the Fixed Costs sheet for the product shown in B3. In B6 use a formula to retrieve the Total Fixed Costs from the Fixed Costs sheet for the product shown in B3. In E5 use the information in the Labour Costs sheet to calculate the Direct Labour Cost per unit for the product shown in B3. In E6 use the information in the BOM to calculate the Direct Material Cost per unit for the product specified in B3. In E14 calculate the Variable Selling & Admin Cost per unit (as a %). In H4 calculate the Contribution Margin per Unit (this is the Unit Sales Price less the Variable Manufacturing Cost per unit and the Variable Selling & Admin Cost per unit) D8 In H5 calculate your break-even volume (in units). Apply an appropriate rounding function to get the answer to 0 decimal places (Consider whether to use ROUND, ROUNDUP OR ROUNDDOWN). (This answer is very important so double check it!) 19 In H6 calculate the Break-Even Sales Value ($ sales or break even volume in units). 010 In H9 to H14 calculate the Break-Even Variable Costs using the calculated figures in H5 or H6 (where appropriate). Note, each answer is worth X mark which will only be awarded if the answer and formula are correct. In H17 calculate the Break-Even Contribution Margin. 012 In H18 calculate the Break-Even Profit Before Tax. (If we hadn't rounded Break Even Units this should be 0) Section The following are to be completed in the Profit Volume Forecast Worksheet In this sheet we want to be able to forecast what our profits will look like with different sales volumes. E1 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 values in B3 and 83 so do NOT just add 25, use a relative reference or a range name). Drag the formula across to G4 In 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:13). In row 16 calculate the Contribution Margin for each sales volume. 0000 In row 17 calculate Contribution Margin less Fixed Costs for each sales volume