In: Accounting
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.)
Required:
a. Assume that only one product is being sold in each of the four following case situations:
b. Assume that more than one product is being sold in each of the four following case situations:
| Part 1 | ||||||||||||||||||||||||||||||||||||
  | 
| Part 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
  | 
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
Answer
--Part 1
| 
 Case #1  | 
 Case #2  | 
 Case #3  | 
 Case #4  | 
|
| 
 Unit sold  | 
 15,000  | 
 4,000  | 
 10,000  | 
 6,000  | 
| 
 Sales  | 
 $180,000  | 
 $100,000  | 
 $200,000  | 
 $300,000  | 
| 
 Variable expenses  | 
 $120,000  | 
 $60,000  | 
 $70,000  | 
 $210,000  | 
| 
 Fixed expenses  | 
 $50,000  | 
 $32,000  | 
 $118,000  | 
 $100,000  | 
| 
 Net operating income (loss)  | 
 $10,000  | 
 $8,000  | 
 $12,000  | 
 ($10,000)  | 
| 
 Contribution margin per unit  | 
 $4  | 
 $10  | 
 $13  | 
 $15  | 
--Working for Part 1
| 
 Case #1  | 
 Case #2  | 
 Case #3  | 
 Case #4  | 
|
| 
 Unit sold  | 
 15000  | 
 =+(100000-60000)/10  | 
 10000  | 
 6000  | 
| 
 Sales  | 
 180000  | 
 100000  | 
 =70000+118000+12000  | 
 300000  | 
| 
 Variable expenses  | 
 120000  | 
 =100000-32000-8000  | 
 70000  | 
 =+(300000-100000+10000)  | 
| 
 Fixed expenses  | 
 50000  | 
 32000  | 
 =+(10000*13)-12000  | 
 100000  | 
| 
 Net operating income (loss)  | 
 =180000-120000-50000  | 
 8000  | 
 12000  | 
 -10000  | 
| 
 Contribution margin per unit  | 
 =+(180000-120000)/15000  | 
 10  | 
 13  | 
 =+(300000-210000)/6000  | 
--Part 2
| 
 Case #1  | 
 Case #2  | 
 Case #3  | 
 Case #4  | 
|
| 
 Sales  | 
 $500,000  | 
 $400,000  | 
 $250,000  | 
 $600,000  | 
| 
 Variable expenses  | 
 $400,000  | 
 $260,000  | 
 $100,000  | 
 $420,000  | 
| 
 Fixed expenses  | 
 $93,000  | 
 $100,000  | 
 $130,000  | 
 $185,000  | 
| 
 Net operating income (loss)  | 
 $7,000  | 
 $40,000  | 
 $20,000  | 
 ($5,000)  | 
| 
 Contribution margin ratio (percent)  | 
 20%  | 
 35%  | 
 60%  | 
 30%  | 
--Working for Part 2
| 
 Case #1  | 
 Case #2  | 
 Case #3  | 
 Case #4  | 
|
| 
 Sales  | 
 500000  | 
 400000  | 
 =+(130000+20000)/60%  | 
 600000  | 
| 
 Variable expenses  | 
 =500000*80%  | 
 260000  | 
 =250000*40%  | 
 420000  | 
| 
 Fixed expenses  | 
 =500000-400000-7000  | 
 100000  | 
 130000  | 
 =600000-420000+5000  | 
| 
 Net operating income (loss)  | 
 7000  | 
 =400000-260000-100000  | 
 20000  | 
 -5000  | 
| 
 Contribution margin ratio (percent)  | 
 0.2  | 
 =+(400000-260000)/400000  | 
 0.6  | 
 =+(600000-420000)/600000  |