Scannell, Inc., sells tire rims. Its sales budget and inventory, purchases, and cost of goods sold budget for the nine months ended September 30, 2024, follow (Click the icon to view the sales budget and inventory, purchases, and cost of goods sold budget) Scannell's selling and administrative expenses include the following (Click the icon to view the expenses.) Prepare a selling and administrative expense budget for each of the three quarters of 2024 and totals for the nine-month period Variable expenses: Total variable expenses Fixed expenses: Scannell, Inc. Selling and Administrative Expense Budget Nine Months Ended September 30, 2024 Total fixed expenses Total selling and administrative expenses Data table Quarter Quarter Quarter Ended Ended Ended Nine-month March 31 June 30 September 30 Total Rent, $1,600 per month Salaries, $1,500 per month Commissions 5% of sales Depreciation, $1,100 per month Miscellaneous expenses, 1% of sales - X Scannell, Inc. Sales Budget Nine Months Ended September 30, 2024 Quarter Ended Nine-Month March 31 June 30 September 30 Total Cash sales, 30% Credit sales, 70% S 33,000 $ 77,000 48,000 $ 40,500 $ 121,500 112,000 94,500 283,500 110,000 $ 160,000 $ 135,000 $ 405,000 Total sales Scannell, Inc. Inventory, Purchases, and Cost of Goods Sold Budget Nine Months Ended September 30, 2024 Quarter Ended Quarter Ended Quarter Ended Nine-Month March 31 June 30 September 30 Total Cost of goods sold $44,000 $64,000 $54,000 $162,000 $16,400 Plus Desired ending merchandise inventory $15,400 $18,400 Total merchandise inventory required $60,400 $79,400 $72,400 $37,000 $16,400 Less: Beginning merchandise inventory $15,400 $23,400 $63,000 $57,000 Budgeted purchases