In: Finance
Exercise 9-12
Kirkland 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
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 |
|||
Budget Sales in Units |
|||||
Variable Expenses | |||||
Sales Commissions | $ | $ | $ | ||
Delivery Expense |
|||||
Advertising |
|||||
Total Variable |
|||||
Fixed Expenses | |||||
Sales Salaries |
|||||
Office Salaraies |
|||||
Depreciation |
|||||
Insurance |
|||||
Utilities |
|||||
Repair Expense |
|||||
Total Fixed |
|||||
Total Selling and Administrative Expenses | $ | $ | $ |
Calculation:
Sales Commissions, Qtr 1 = 20,800 * $24 * 5% = $24,960
Sales Commissions, Qtr 2 = 22,100 * $24 * 5% = $26,520
Delivery Expense, Qtr 1 = 20,800 * $24 * 2% = $9,984
Delivery Expense, Qtr 2 = 22,100 * $24 * 2% = $10,608
Advertising, Qtr 1 = 20,800 * $24 * 3% = $14,976
Advertising, Qtr 2 = 22,100 * $24 * 3% = $15,912