Case Study

Case Study 1

 

Springfield Express is a luxury passenger carrier in Texas. All seats are first class, and the following data are available:

 

Number of seats per passenger train car                                            90

 

Average load factor (percentage of seats filled)                               70%

 

Average full passenger fare                                                               $ 160

 

Average variable cost per passenger                                               $   70

 

Fixed operating cost per month                                                  $3,150,000

   

Formula :

 

Revenue = Units Sold * Unit price

 

Contribution Margin = Revenue – All Variable Cost

 

Contribution Margin Ratio = Contribution Margin/Selling Price

 

Break Even Points in Units = (Total Fixed Costs + Target Profit )/Contribution Margin

 

Break Even Points in Sales = (Total Fixed Costs + Target Profit )/Contribution Margin Ratio

 

Margin of Safety = Revenue – Break Even Points in Sales

 

Degree of Operating Leverage = Contribution Margin/Net Income

 

Net Income = Revenue – Total Variable Cost – Total Fixed Cost

 

Unit Product Cost using Absorption Cost  = (Total Variable Cost + Total Fixed Cost)/# of units

   

a.     Contribution margin per passenger =?

 

Contribution margin ratio =?

 

Break-even point in passengers = Fixed costs/Contribution Margin =  

 

 Passengers =?

 

Break-even point in dollars = Fixed Costs/Contribution Margin Ratio =

 

$ ?

    

b.     Compute # of seats per train car (remember load factor?)

 

If you know # of BE passengers for one train car and the grand total of passengers, you can compute # of train cars (rounded) =?

   

c.      Contribution margin =?

 

Break-even point in passengers = fixed costs/ contribution margin

 

  Passengers =?

 

  train cars (rounded) =?

   

d.     Contribution margin =?

 

Break-even point in passengers = fixed costs/contribution margin

   Passengers =? 

   train cars ( rounded) = ?

   

e.     Before tax profit less the tax rate times the before tax profit = after-tax income = $ ?

 

Then,

proceed to compute # of passengers -=?                              

   

f.      # of discounted seats = ?

 

Contribution margin for discounted fares  X # discounted seats = $ each train X$ ? train cars per day X ? days per month= $?  minus $ additional fixed costs = $?  pretax income.

   

g.     1.

   

Compute Contribution margin

   Then,    

# seats X $ X # train cars =                                      $            ?

 

Increased fixed cost                                                             ( ?)

 

Pretax gain (loss) on new route                                           $

     

2 and 3.  Compute # of passengers and train cars using computation approaches employed in some of the above problems.       

     

4. Springfield should consider such things as (Think of qualitative factors that are important. In    other words, not the numbers but other things that have to be considered, e.g., risks)