Question

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 27,000 20,000 25,000 Budgeted unit sales 28,000 The company's variable selling and administrative expense per unit is $2.60. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $47,000 per quarter, and depreciation of $26,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first querter and $5,000 in the third quarter. Finally, property taxes of $8,800 will be paid in the second quarter. bok int rint Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.) rences Weller Company Selling and Administrative Expense Budget Year 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses

Answer 1

Selling and administrative expense budget

	1st quarter	2nd quarter	3rd quarter	4th quarter	Year
Budgeted unit Sales	27000	28000	20000	25000	100000
Variable selling and administrative expense per unit	2.6	2.6	2.6	2.6	2.6
variable selling and administrative expense	70200	72800	52000	65000	260000
Fixed selling and administrative expense
Advertising	12000	12000	12000	12000	48000
Executive salaries	47000	47000	47000	47000	188000
Depreciation	26000	26000	26000	26000	104000
Insurance	5000		5000		10000
Property taxes		8800			8800
Total fixed selling and administrative expense	90000	93800	90000	85000	358800
Total Selling and administrative expense	160200	166600	142000	150000	618800
Less: Depreciation	-26000	-26000	-26000	-26000	-104000
Cash disbursement on selling and administrative expense	134200	140600	116000	124000	514800