Question

Excel Cruiseline offers nightly dinner cruises departing from several cities on the eastern coast of the United States including Charleston, Baltimore, and Alexandria. Dinner Cruise tickets sed for $50 per passenger Excel Cuisines variable cost of providing the dinner is $20 per passenger, and the red cost of operating the vessels (depreciation salaries, docking fees, and other expenses) is $270.000 per month The company's relevant range extends to 15.000 monthly passengers. The breakeven units are 9,000 tickets sold. Excel Cruiseline seils 12.000 dinner cruises, compute the margin of safety a in units (dinner Cruise tickets). b. in sales dollars c. as a percentage of sales a. If Excel Cruiseline sels 12.000 dinner Cruises, compute the margin of safety in units (dinner Cruise tickets). Begin by determining the formula, then compute the margin of safety in units (dinner cruise tickets) Margin of safety in units

Answer 1

B C D a. 1 2 3 - Actual units sold 12.000 Breakeven units 9,000 Margin of safety in units 3,000 . | = Actual sales $600,000 Margin of safety in dollars $150,000 $450,000 / 10 Margin of safety in dollars 11 $150,000 Actual sales $600,000 Margin of safety as a percentage of sales 25.0% Calculations are shown below: B C D E A 1 a. 2 Actual units sold 3 12000 - . Breakeven units 9000 = = Margin of safety in units =A3-C3 5 b. Actual sales 7 =12000*50 - | - Breakeven sales =9000*50 = Margin of safety in dollars = =A7-C7 9 C. 10 Margin of safety in dollars 11 =E7 Actual sales =A7 Margin of safety as a percentage of sales =A11/C11