1 Inputs 2 3 4 A Units Sales Price Annual Fixed Cost Unit Variable Cost 5 6 7 8 9 10 11 12 13 Reference: Break Even Analysis - Excel Quantity Made and Sold Calculations and Outputs Annual Revenue Annual Variable Cost Annual Fixed Cost Annual Total Cost Annual Profit (Loss) B 25 52000 9 To calculate the break-even quantity in cell B6 the correct formula is O A. B3/(B4-B2) O B. B3/B2-B4 C.=B3/(B2-B4) O D. A3/(A2-A4) O E. B6/(B5-B7)

To calculate the break-even quantity in cell B6 the correct formula is A. =B3/(B4B2) B. =B3/B2B4 C. =B3/(B2B4) D. =A3/(A2A4) E.=B6/(B5B7) Reference: Break Even Analysis - Excel To calculate the break-even quantity in cell B6 the correct formula is A.=B3/(B4B2) B.=B3/B2B4 C. =B3/(B2B4) D.=A3/(A2A4) E. =B6/(B5B7)