I am trying to solve for the selling and administrative budget to complete the budgeted income statement. How would I calculate the advertising and sales salaries and commissions for the SG&A budget?

My calculation:

Wonky Widgets Manufacturing Company
Selling & Administrative Expense Budget for 2021
Selling Expense:
Advertising	$ 60,500.00
Sales salaries and commissions	$ 389,000.00
Travel and entertainment	$ 60,000.00
Total selling expenses	$ 509,500.00
Depreciation (warehouse)	$ 5,000.00
Office salaries	$ 60,000.00
Executive salaries	$ 250,000.00
Supplies	$ 4,000.00
Depreciation (office)	$ 6,000.00
Total fixed selling & administrative expenses	$ 325,000.00
Total selling & administrative expenses	$ 834,500.00

Please show your work, thanks so much!

Introduction: Wonky Widgets Manufacturing Company makes two widgets identified as C15 and C60. Selected budget data for 2021 follow: Finished Widgets C15 C60 10 8 0 4 1 2 2 3 Requirements for each finished widget (in kilograms): RM 1 RM 2 RM3 Direct labor hours Product information: Sales price Sales (units) Estimated beginning inventory (units) Target ending inventory (units) $150 12,000 400 $220 9,000 150 200 300 $ Cost per kilogram Estimated beginning inventory in kilograms Target ending inventory in kilograms Direct Materials Data RM1 RM2 RM3 2.00 $ 2.50 $ 0.50 3,000 1,500 1,000 4,000 1,000 1,500 The management of Wonky Widgets expects a $25 per hour average wage rate in 2021. Wonky Widgets applies manufacturing overhead based on direct labor hours. Every year, the company's management determines the manufacturing overhead rate based on budgeted production levels for the year. Wonky Widgets maintains no work-in-process inventory and managements expects the unit cost for inventories of finished products to be the same at the end of the year as at the beginning of the year. The following schedule details the composition of manufacturing overhead at the anticipated production level. $ Indirect materials-variable Miscellaneous supplies-variable indirect labor-variable Supervisioin-fixed Payroll taxes and fringe benefits-variable Maintenance costs - fixed Maintenance costs -variable Depreciation-fixed Heat, light, and power-fixed Heat, light, and power-variable 10,000 5,000 40,000 120,000 250,000 20,000 10,080 71,330 43,420 11,000 The following schedule details the composition of selling and administrative expenses at the anticipated sales level. Advertising Sales salaries and commissions Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office $50,000 + $0.50 per unit $200,000 + 5% of sales dollars $ 60,000 5,000 60,000 250,000 4,000 6,000 Wonky Widgets has an effective income tax rate of 40 percent. Part 1: Prepare an Excel workbook that contains the following schedules for 2021: 1. Sales Budget 2. Production budget (units and dollar amounts) 3. Direct materials budget (units and dollar amounts) 4. Direct labor budget (hours and dollar amounts) 5. Manufacturing overhead budget 6. Budgeted income statement Your workbook should be constructed to facilitate easy what-if analysis to enable quick address of Parts 2 and 3 below. Part 2: C15 is a long-standing product for which management believes that the price can be raised to $160 per unit with no effect on demand. C60 is a fairly new product that management believes has significant potential. Management expects that reducing the price to $180 will likely double demand. Would you recommend to the management of Wonky Widgets that this strategy be executed? Explain. Part 3: The management of Wonky Widgets Company has had a continuous improvement program for a few years. Consequently, management anticipates C15 and C60 can be manufactured with the following specifications: Finished Widgets C60 C15 9 7 Requirements for each finished widget (in kilograms): RM 1 RM2 RM 3 Direct labor hours 3.6 0 1.8 0.8 1.5 2 Management expects that the variable manufacturing overhead will decrease by 10 percent while the fixed manufacturing overhead will decrease by 5 percent, except for depreciation which will not change. Management does not expect the price of raw materials to change, but the hourly wage rate is expected to increase to $30. None of the other items in the problem introduction will change. What is the budgeted after-tax operating income if management can achieve these changes