In: Accounting
irkland Company combines its operating expenses for budget
purposes in a selling and administrative expense budget. For the
first 6 months of 2020, the following data are available.
| 1. | Sales: 20,800 units quarter 1; 22,100 units quarter 2. | |
| 2. | Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. | |
| 3. | Fixed costs per quarter: sales salaries $10,900, office salaries $6,160, depreciation $4,490, insurance $2,080, utilities $880, and repairs expense $670. | |
| 4. | Unit selling price: $24. |
Prepare a selling and administrative expense budget by quarters for
the first 6 months of 2020. (List variable expenses
before fixed expense.)
| KIRKLAND COMPANY Selling and Administrative Expense Budget For the Quarter Ending June 30, 2020For the Six Months Ending June 30, 2020June 30, 2020 |
|||||
|
Quarter |
|||||
|
1 |
2 |
Six Months |
|||
Selling and administrative expenses budget is prepared as follows:
| Quarter 1 | Quarter 2 | Six Months | |
|---|---|---|---|
| Sales in units (a) | 499,200 | 530,400 | 1,029,600 |
| (20,800 * $24) | (22,100 * $24) | (42,900 * $24) | |
| Variable Cost: | |||
| Sale commission (a* 5%) | 24,960 | 26,520 | 51,480 |
| Delivery Expenses (a* 2%) | 9,984 | 10,608 | 20,592 |
| Advertising (a* 3%) | 14,976 | 15,912 | 30,888 |
| Total Variable Cost: | $49,920 | $53,040 | $102,960 |
| Fixed Cost: | |||
| Sales salaries | 10,900 | 10,900 | 21,800 |
| Office salaries | 6,160 | 6,160 | 12,320 |
| Depreciation | 4,490 | 4,490 | 8,980 |
| insurance | 2,080 | 2,080 | 4,160 |
| utilities | 880 | 880 | 1,760 |
| repairs expense | 670 | 670 | 1,340 |
| Total Fixed Cost: | $25,180 | $25,180 | $50,360 |
| Total Selling and administrative expenses | $75,100 | $78,220 | $153,320 |