In: Accounting
Sparkle Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on Ottawa Air. Sparkle's fixed costs are$ 29,500 per month. Ottawa Air charges passengers $1,600 per round-trip ticket.
Breakeven number of units = ____ / ____
Calculate the number of tickets Sparkle must sell each month to (a) break even and (b) make a target operating income of $19,000 per month in each of the following independent cases. (Round up to the nearest whole number. Forexample, 10.2 should be rounded up to 11.)
| 
 1.  | 
 Sparkle's variable costs are $42 per ticket. Ottawa Air pays Sparkle 10% commission on ticket price. | 
| 
 2.  | 
 Sparkle's variable costs are $35 per ticket. Ottawa Air pays Sparkle 10% commission on ticket price. | 
| 
 3.  | 
 Sparkle's variable costs are $35 per ticket. Ottawa Air pays $55 fixed commission per ticket to Sparkle.Comment on the results.  | 
| 
 4.  | 
 Sparkle's variable costs are $35 per ticket. It receives $55 commission per ticket from Ottawa Air. It charges its customers a delivery fee of $5 per ticket. Comment on the results.  | 
| Ques 1 | |||||
| a) | |||||
| Variable cost | 42 | ||||
| comission | 10% | ||||
| SP(Comission%) | 160 | ||||
| VC | 42 | ||||
| Contribution margin | 118 | ||||
| FC | 29500 | ||||
| Breakeven=FC/Contribution magin per unit | |||||
| Breakeven= | 250 | tickets | |||
| b) | |||||
| Q=FC+Target profit / contribution margin per unit | |||||
| Q= | 411 | TICKEt | |||
| (19000+29500)/118 | |||||
| Ques 2 | |||||
| a) | |||||
| Variable cost | 35 | ||||
| comission | 10% | ||||
| SP(Comission%) | 160 | ||||
| VC | 35 | ||||
| Contribution margin | 125 | ||||
| FC | 29500 | ||||
| Breakeven=FC/Contribution magin per unit | |||||
| Breakeven= | 236 | tickets | |||
| (19000+29500)/125 | |||||
| b) | |||||
| Q=FC+Target profit / contribution margin per unit | |||||
| Q= | 388 | TICKEt | |||
| Ques 3 | |||||
| a) | |||||
| Variable cost | 35 | ||||
| comission | 55 | ||||
| SP(given) | 55 | ||||
| VC | 35 | ||||
| Contribution margin | 20 | ||||
| FC | 29500 | ||||
| Breakeven=FC/Contribution magin per unit | |||||
| Breakeven= | 1475 | tickets | |||
| (19000+29500)/20 | |||||
| b) | |||||
| Q=FC+Target profit / contribution margin per unit | |||||
| Q= | 2425 | TICKEt | |||
| Because of the fixed comission sales revenue has come down (from 160 to 55) | |||||
| hence breakeven increases | |||||
| Ques 4 | |||||
| a) | |||||
| Variable cost | 35 | ||||
| Delivery | 5 | ||||
| comission | 55 | ||||
| SP(given+delivery) | 60 | ||||
| VC | 35 | ||||
| Contribution margin | 25 | ||||
| FC | 29500 | ||||
| Breakeven=FC/Contribution magin per unit | |||||
| Breakeven= | 1180 | tickets | |||
| b) | |||||
| Q=FC+Target profit / contribution margin per unit | |||||
| Q= | 1940 | TICKEt | |||
| (19000+29500)/25 | |||||