The answer is
C. =B5*B7
Annual variable cost = Variable cost per unit*Number of units
Hence, B5*B7 i.e. 9*2500 = $22,500
QUESTION 21 5 points 8 F G H Goal Se 62500 22500 52000 74500 -12000 Toy...
QUESTION 20 А B D E F H Goal Seek 5 62500 22500 52000 74500 -12000 by changing OK Cance 2 Inputs Calculations and Outputs 3 Units Sales Price 25 Annual Revenue 4 Annual Fixed Cost 52000 Annual Variable Cost 5 Unit Variable Cost 9 Annual Fixed Cost 6 Annual Total Cost 7 Quantity Made and Sold 2500 Annual Profit (Loss) 8 Reference Break Even Analysis What information should be entered in Goal Seek to compute the break-even quantity A....
QUESTION 19 5 points Save F G H G А B D 1 2 Inputs Calculations and Outputs 3 Units Sales Price 25 Annual Revenue 62500 4 Annual Fixed Cost 52000 Annual Variable Cost 22500 5 Unit Variable Cost 9 Annual Fixed Cost 52000 6 Annual Total Cost 74500 7 Quantity Made and Sold 2500 Annual Profit (Loss) - 12000 8 eference Break Even Analysis If Goal Seek is used, which formula should be entered in Cell B7 to compute...
QUESTION 22 5 points A B 1 Inputs 2 Units Sales Price 25 3 Annual Fixed Cost 52000 4 Unit Variable Cost 9 5 6 Quantity Made and Sold 7 8 Calculations and Outputs 9 Annual Revenue 10 Annual Variable Cost 11 Annual Fixed Cost 12 Annual Total Cost 13 Annual Profit (Loss) Reference Break Even Analysis. Excel To calculate the break-even quantity in cell 36 the correct formula is A-B3/B4-B2) OB A3/A2-A4) C.-86/85-87) D.-03/02-04) E-03/02-14