07 Exercise 8-6 (Algo) Selling and Administrative Expense Budget (LO8-7) 187 point 02:06:44 Weller Company's budgeted unit sales for the upcoming fiscal you are provided below: 1st Quarter 2nd Quarter Sed Quarter 4th Quarter Budgeted unit sales 18,000 22,000 17,000 16,000 The company's variable seling and administrative expense per unit is $1.70. Fixed seiling and administrative expenses include advertising expenses of $11,000 per quarter, executive salaries of $38,000 per quarter, and depreciation of $17000 per quarter in addition, the company will make insurance payments of S4 000 in the first quarter and $4.000 in the third quarter. Finally, property taxes of $8,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.) Answer is not complete. Weller Company Selling and Administrative Expense Budget 157 2nd Srd Quarter Quarter Duarter 18.000 22 000 Budgeted and sales 14 000 1.70 170 Variable selling and administrative expense per unit 170 Year Quarter 16 000 1705 73.000 1.70 loo 07 decimal places.) Answer is not complete. 187 points 8 02:00 Year o 3rd Quarter 14.000 1.70 28.900 4th Quarter 10 000 170 27.2003 5 73000 1 70 124 100 Weller Company Selling and Administrative Expense Budget 1st 2nd Quarter Quarter Budgeted unit sales 18,000 22.000 Variable selling and administrative expense por un s 170 $ 1.703 Variable selling and administrative expurse $ 30,000 $ 37400 Fixed selling and administrative expenses Advertising 11.000 11.000 Executive sales 38.000 38000 Insurance 4000 Property taxes 0.200 Depreciation 17.000 17 000 Totalfred selling and administrative expenses 70.000 74200 Total seting and administrative opensos 4.000 112,700 Less Depreciation 17 000 17 000 Cash disbursements for selling and administrative expenses $ 100 000 5 111.600 11.000 30,000 11 000 311.000 OOOO 17 000 00.000 040003 17 000 95.000 35 17.000 60.000 50.000 17,000 93.2005 44000 152.000 8000 0200 68000 200 200 280 200 68,000 404300 MC Draw 5 Nax