In: Accounting
Vaughn Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static budget based on sales of 2,000 kits was prepared for the year. Fixed operating expenses account for 80% of total operating expenses at this level of sales. Sales Revenue $ 100,280 Cost of goods sold (all variable) 60,000 Gross margin 40,280 Operating expenses 35,170 Operating income $ 5,110 Prepare a flexible budget based on sales of 1,467, 2,570, and 3,840 units.
| Working | ||||
| Amount | ÷ Units | Per unit | Fixed - 80% | |
| Sales Revenue | $100,280 | 2000 | 50.14 | |
| Cost of goods sold (all variable) | 60,000 | 2000 | 30.00 | |
| Gross margin | 40,280 | 2000 | 20.14 | |
| Operating expenses - 80% Fixed | 35,170 | 2000 | 3.517 | 28136 | 
| Operating income | $5,110 | |||
| Flexible Budget | ||||
| Units | 1467 | 2570 | 3840 | |
| Sales Revenue ( No of units x $50.14) | $ 73,555.38 | $ 128,859.80 | $ 192,537.60 | |
| Cost of goods sold (No. of units x $30) | 44,010.00 | 77,100.00 | 115,200.00 | |
| Gross Margin | 29,545.38 | 51,759.80 | 77,337.60 | |
| Operating Expenses: | ||||
| Variable (No. of units x $3.517) | 5,159.44 | 9,038.69 | 13,505.28 | |
| Fixed Expenses | 28,136.00 | 28,136.00 | 28,136.00 | |
| Operating Income | (3,750.06) | 14,585.11 | 35,696.32 | |