Hi tutors, I am not sure what excel functions I would use to answer these questions on the cost volume profit analysis sheet (D3-D12). Any help is appreciated.

A Cost Volume Profit Analysis Product Information Unit Sales Price Units Manufactured and Sold Sales Mix (% oftotal units sold) LDDOSlmLHAD-lNH ._t D Vary with Unit Costs Direct Material Direct Labor OtherVary-with-Unit Costs Total Varywith Unit Costs H H I'I'I'I'H mU'JE-UJN Break Even Analysis Contribution Margin Per Unit I'I'H WOUN Break Even Point in Units/Product Break Even in Sales Dollars NNN NI'D $35.00 $16.71 $52.50 $17.88 Fixed Costs Vary-with-RevenueCosts Sales Commissions Weighted Average Contribution Margin Break Even Units (weighted) Break Even Variable Costs Direct Material Direct Labor OtherVary-with-Unit Costs Sales Commissions Total Variable Costs Break Even Contribution Margin Break Even Prot Before Tax $179,208.00 E B C D E F Bill of Materials IN 3 Product Part Code Quantity Product Decsription Price Each Total Price WB660 PX1004683 DESCRIPTION $13.19 $13.19 WB660 PX242979 4 DESCRIPTION $1.83 $7.32 WB660 PX373195 DESCRIPTION $2.49 $2.49 WB660 PX374089 1 DESCRIPTION $53.11 $53.11 8 WB660 PX374561 DESCRIPTION $2.74 $2.74 9 WB660 PX577199 DESCRIPTION $1.99 $15.92 10 WB660 PX723206 DESCRIPTION $1.99 $7.96 11 WB66 PX723541 DESCRIPTION $1.66 $1.66 12 WB500 PX723542 DESCRIPTION $1.99 $1.99 13 WB660 PX723557 4 DESCRIPTION $2.49 $9.96 14 WB500 PX723566 DESCRIPTION $2.29 $2.29 5 WB660 PX723593 DESCRIPTION $1.91 $15.28 16 WB500 PX723594 2 DESCRIPTION $2.39 $4.78 17 WB500 PX723596 4 DESCRIPTION $2.49 $9.96 8 WB660 PX723742 DESCRIPTION $1.74 $1.74 WB500 PX723743 N DESCRIPTION $2.29 $4.58 WB660 PX723745 DESCRIPTION $3.11 $12.44 21 WB500 PX723820 DESCRIPTION $2.49 $9.96 22 WB500 PX725125 DESCRIPTION $2.19 $8.76 23 B660 PX792653 8 DESCRIPTION $2.08 $16.64 24 WB500 PX796490 DESCRIPTION ND $2.49 $9.96 25 WB660 PX797516 ESCRIPTION $1.83 $3.66 26 WB660 PX807530 DESCRIPTION $2.99 $2.99 27 WB660 PX807531 IN DESCRIPTION $1.66 $3.32 3 WB660 PX807532 DESCRIPTION $1.74 $3.48 29 WB500 PX807539 NNN DESCRIPTION $18.69 $37.38 30 WB660 PX807540 DESCRIPTION $3.33 $6.66 31 WB660 PX809486 8 DESCRIPTION $2.08 $16.64 32 WB660 PX820261 DESCRIPTION $12.99 $12.99 33 WB500 X820262 P DESCRIPTION $13.19 $13.19 34 WB500 X820263 2 DESCRIPTION $2.49 $4.98 35 WB500 PX82026 1 DESCRIPTION $10.99 $10.99 36 WB660 PX820728 2 DESCRIPTION $2.19 $4.38 37 WB500 PX820728 N DESCRIPTION $2.19 $4.38 38 WB500 PX820834 DESCRIPTION $1.99 $1.99 39 WB660 PX823385 DESCRIPTION $1.66 $6.64 40 WB660 PX823386 DESCRIPTION $1.74 $13.92 41 WB660 PX823978 DESCRIPTION $26.24 $26.24 42 WB500 X823978 DESCRIPTION $26.24 $26.24 43 WB500 PX860085 DESCRIPTION $2.19 $4.38 44\fA B C D E F G H Fixed Costs 2 3 Fixed Cost Items Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarterly Average % of Total 4 Rent 30,400.00 $ 30,400.00 $ 31,464.00 $ 31,464.00 $ 30,932.00 69% 5 Utilities 3,730.00 $ 3,730.00 $ 3,730.00 3,730.00 3,730.00 8% 6 Admin Costs S 6,990.00 ur 7,200.00 7,200.00 7,130.00 ur 7,130.00 16% 7 Insurance S 3,120.00 $ 2,900.00 $ 3,120.00 2,900.00 3,010.00 7% 8 9 Quarterly Totals $ 44,240.00 $ 44,230.00 $ 45,514.00 $ 45,224.00 10 11 Total Fixed Costs $ 179,208.00 12 13 Highest Quarterly Admin Costs: 7,200.00 14 Average Monthly Rent: 10,310.67 15 Rent % Increase: 3.5% 3039896.50% 16 17 18In 311 and C11, use the information in the BOM to calculate the Direct material D3 costs for one unit of each product. D4 In 312 and C12 use the values in the Labour Costs sheet to calculate the cost of labour to produce one unit of each product. D5 In 317 and C17 calculate the contribution margin per unit for each product (ensure you include vary with unit and vary with revenue costs). D6 In F9 calculate the Weighted Average Contribution Margin using the sales mix percentages calculated previously. D? In F10 calculate the break-even units (the combined number of units from the two products that need to be sold to not make a loss). As we cannot sell part of a product, apply an appropriate rounding function to get the answer to 0 decimal places. (This answer is very important so double check it.) Question Instruction D8 In 319 and C19 use the previous result and the sales mix to work out the break-even point in units per product. D9 In 320 and C20 calculate the break even point in dollars for each product. D10 In F13 to F16 calculate the BreakEven Variable Costs for the two products. D11 In F19 calculate the BreakEven Contribution Margin (this is the contribution margin for the total number of units required to break even.) D12 In F20 calculate the BreakEven Profit Before Tax. (Break even prot would normally be 0, but because we rounded up our break-even units, this should be slightly more than 0.)