In: Accounting
Managerial ACC
Parkland, Inc. sells a unit of its product for $16.00,resulting in a contribution margin of $8.50 per unit. Fixed costs are budgeted at $220,000 per quarter for volumes up to 30,000 units and $250,000 for volumes exceeding 30,000 units.
Prepare the flexible budget for the next quarter for volume levels of 25,000,30,000, nd 35,000 units.
| Units | 25,000 | 30,000 | 35,000 | 
| Sales Revenue | |||
| Vriable expenses | |||
| fixed expenses | |||
| Total expenses | |||
| Operating income | 
| Units | 25,000 units | 
 30,000 units  | 
35,000 units | 
| Sales Revenue | 
 25000*$16 = $400000  | 
 30000*$16 =$480000  | 
 35000*$16 =$560000  | 
| Variable expenses | 
 25000 * $7.5 =187500  | 
 30000 * $7.5 =225000  | 
 35000*$7.5 =$262500  | 
| fixed expenses | $220000 | $220000 | $250000 | 
| Total expenses | 407500 | 445000 | 512500 | 
| Operating income (sales - total expenses) | ($7500) | $35000 | $47500 | 
Note:- variable cost = sales per unit - contribution margin per unit
= $16 - $8.5
= $7.5