QUESTION 21 5 points 8 F G H Goal Se 62500 22500 52000 74500 -12000 Toy by changing А B C D 1 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 Cell E4 to calculate Annual...
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 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
А D E F G H M N O P Q A 3 4. Problem D (38 points): 5 Weather-Tight sells windows and doors. The following data applies to the company's current operating activities: Solution: Please place your answer and supporting calculations in the space below and either highlight your final answer or surround it with a border so that it can be easily identified by the grader. Total 100.00% 1 Total Units (products combined) to Break Even: $ $...