Question

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 33,000 35,000 26,000 31,000 Budgeted unit sales The company's variable selling and administrative expense per unit is $3.20. Fixed selling and administrative expenses include advertising expenses of $10,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $32,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $9,200 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.) Weller Company Selling and Administrative Expense Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: Total fixed selling and administrative expenses Total selling and administrative expenses Cash disbursements for selling and administrative expenses

Answer 1

	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Year
Budgeted unit sales	33000	35000	26000	31000	125000
Variable selling and administrative Expense per unit	3.20	3.20	3.20	3.20	3.20
Variable selling and administrative Expense	105600	112000	83200	99200	400000
Fixed selling and administrative Expenses:
Advertising	10000	10000	10000	10000	40000
Executive Salaries	53000	53000	53000	53000	212000
Insurance	5000		5000		10000
Property taxes		9200			9200
Depreciation	32000	32000	32000	32000	128000
Total Fixed selling and administrative Expense	100000	104200	100000	95000	399200
Total selling and administrative expenses	205600	216200	183200	194200	799200
Less depreciation	32000	32000	32000	32000	128000
Cash disbursements for selling and administrative expenses	173600	184200	151200	162200	671200