Suppose Excel Cruiseline decides to offer two types of dinner cruises: regular cruises and executive cruises. The executive cruise includes complimentary cocktails and a five-course dinner on the upper deck. Assume that fixed expenses remain at $360,000 per month and that the following ticket prices and variable expenses apply: (Click the icon to view the ticket prices and expenses.) Assuming that Excel Cruiseline expects to sell four regular cruises for every executive cruise, compute the weighted average contribution margin per unit. Is it higher or lower than a simple average contribution margin? (A simple average is calculated by adding both contribution margins per passenger together and dividing by two.) Why? Is it higher or lower than the regular cruise contribution margin of $40? Why? Will this new sales mix cause Excel Cruiseline's breakeven point to increase or decrease from what it was when it only sold regular cruises? Assuming that Excel Cruiseline expects to sell four regular cruises for every one executive cruise, compute the weighted average contribution margin per unit. Determine the formula, then complete the table one section at a time. Regular Executive Total Less: Weighted average contribution margin per unit A simple average contribution margin would be $ Is the weighted average contribution margin higher or lower than a simple average contribution margin? The weighted average is the simple average because Excel Cruiseline sells regular cruises, which have a contribution margin, than executive cruises. Less than/More than Fewer/More Higher/Lower Is the weighted average contribution margin higher or lower than the regular cruise contribution margin of $40? Why? Higher/Lower The weighted average contribution margin is than the contribution margin of regular cruises because Excel Cruiseline sells some executive cruises, and they have a contribution margin than regular cruises. Higher/Lower Will this new sales mix cause Excel Cruiseline's breakeven point to increase or decrease from what it was when it only sold regular cruises? Higher/Lower Because the new sales mix creates a weighted-average contribution margin, Excel Cruiseline will need to sell cruises, in total, to breakeven than when they just sold regular cruises. Fewer/More Data Table Regular Cruise Sale price per ticket...................$ 80 Executive Cruise $ 160 Variable expense per passenger.... 40 80 Print Done