Need help with Sales commission in dollars.
Step 20 of 40: Budgeted Sales and Commissions G June 1. Wally's Widgets 2 Budgeted Sales in Units 3. Add: Ending Inventory 4 Total Needs 5 Less Beginning Inventory 6 Required Purchases in Units 7 Required Purchases in Dollars 8 Budgeted sales in Dollars 9 Sales Commissions in Dollars C D January February March April 10000 10250 10500 6150 6300 6450 16150 16550 16950 6000 6150 6300 10150 10400 10650 EN900 62400 63000 E May 10750 6600 17350 6450 10900 65400 11000 6750 17750 6600 11150 66900 November December 12500 12750 7650 7650 20150 20400 7500 7650 12650 12750 25900 265.00 (1 YOUR TURN: Compute the budgeted sales in dollars for each month and set the number format to General. Inputs Supporting Schedules Oper 200 6450 DE 1 Wally's Widgets January February March April May June November December 2 Budgeted sales in Units 10000 10250 10500 10750 11000 12500 12750 3 Add: Ending Inventory 6150 100 6600 7650 7650 4 Total Needs 16150 20150 YOUR TURN: Compute the sales commission for 20400 5 Less Beginning Inventory 6000 each month and set the number format to General 7500 7650 6 Required Purchases in Units 10150 12650 12750 7 Required Purchases in Dollars 60900 62400 63900 65400 66900 6720 75900 76500 8 Budgeted sales in Dollars 120000 2000 126000 1500 158000 9 Sales Commissions in Dollars 10 Inputs Supporting Schedules Operating Budget Cash Budget B C D E 1 Wally's Widget January February March April May June July August Septembe October November December 2 Budgeted Sales in Units 10000 10250 10500 10750 11000 11250 11500 11750 12000 12250 12500 12750 3 Add: Ending Inventory 6150 6300 6450 6600 6750 6900 7050 7200 7350 7500 7650 7800 4 Total Needs 16150 16550 16950 1735017750 18150 18550 18950 19350 19750 20150 20400 5 Less Beginning Inventory 6000 6150 6300 6450 6600 6750 6900 7050 7200 7350 7500 7650 6 Required Purchases in Units 16150 16550 16950 1735017750 18150 18550 18950 19350 19750 20150 20400 7 Required Purchases in Dollars 60900 62400639006540066900 68400 69900 71400 72900 74400 7590076500 8 Budgeted Sales in Dollars 120000 123000 126000 129000 132000 135000 138000 141000 14400 147000 150000 153000 9 Sales Commissions in Dollars 10 11 Collection Ratio January January January January January January January January January January January January January February February February February February February February February February February February February March March March March 13 March February March March March March March March March April April April April April 14 March April April April April April April April May May May April May May 15 May May May MayMay June June June June June June June June June June June 16 May July July July July July July July July July July July July 17 June August August August August August August August August August August August 18 August July 19 August Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe September 20 September October October October October October October October October October October October October 21 October November November November November November November November November November November November November Cash Budget Operating Budget Supporting Schedules Inputs Order of operations May May June 7 8 Gross Margin Commission Ending Inventory Minimum Cash Balance Interest Rate $ 60,000 $ 12,000 6150 units $ 20,000 12% 10 11 15 Month 16 Month 1 17 Month 2 18 Month 3 Collections 25% 50% 25% Payments 60% 40% 0% Concatenate/Right Function Upper function Lower Function Period 1 PERIOD 1 Period 2 PERIOD 2 Period 3 PERIOD 3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other Per Month $16,000 $7,000 $19,500 Inputs Supporting Schedules Operating Budget Cash Budget Order of Operations Budget Assumptions First month's Sales in units Sales Growth per month Sales Price per unit $ 10,000 250 units Gross Margin Commission Ending Inventory Minimum Cash Balance Interest Rate $ 60,000 $ 12,000 6150 units $ 20,000 12% Month Month 1 Month 2 Month 3 Collections 25% 50% 25% Payments 60% 40% Concatenate/Right Function Upper function Lower Function Period 1 PERIOD 1 Period 2 PERIOD 2 Period 3 PERIOD 3 OD 15 0% Operating Expenses Pavoll Inputs Per Month $16.000 Supporting Schedules Cash Budget Order of Operations Operating Budget Step 20 of 40: Budgeted Sales and Commissions G June 1. Wally's Widgets 2 Budgeted Sales in Units 3. Add: Ending Inventory 4 Total Needs 5 Less Beginning Inventory 6 Required Purchases in Units 7 Required Purchases in Dollars 8 Budgeted sales in Dollars 9 Sales Commissions in Dollars C D January February March April 10000 10250 10500 6150 6300 6450 16150 16550 16950 6000 6150 6300 10150 10400 10650 EN900 62400 63000 E May 10750 6600 17350 6450 10900 65400 11000 6750 17750 6600 11150 66900 November December 12500 12750 7650 7650 20150 20400 7500 7650 12650 12750 25900 265.00 (1 YOUR TURN: Compute the budgeted sales in dollars for each month and set the number format to General. Inputs Supporting Schedules Oper 200 6450 DE 1 Wally's Widgets January February March April May June November December 2 Budgeted sales in Units 10000 10250 10500 10750 11000 12500 12750 3 Add: Ending Inventory 6150 100 6600 7650 7650 4 Total Needs 16150 20150 YOUR TURN: Compute the sales commission for 20400 5 Less Beginning Inventory 6000 each month and set the number format to General 7500 7650 6 Required Purchases in Units 10150 12650 12750 7 Required Purchases in Dollars 60900 62400 63900 65400 66900 6720 75900 76500 8 Budgeted sales in Dollars 120000 2000 126000 1500 158000 9 Sales Commissions in Dollars 10 Inputs Supporting Schedules Operating Budget Cash Budget B C D E 1 Wally's Widget January February March April May June July August Septembe October November December 2 Budgeted Sales in Units 10000 10250 10500 10750 11000 11250 11500 11750 12000 12250 12500 12750 3 Add: Ending Inventory 6150 6300 6450 6600 6750 6900 7050 7200 7350 7500 7650 7800 4 Total Needs 16150 16550 16950 1735017750 18150 18550 18950 19350 19750 20150 20400 5 Less Beginning Inventory 6000 6150 6300 6450 6600 6750 6900 7050 7200 7350 7500 7650 6 Required Purchases in Units 16150 16550 16950 1735017750 18150 18550 18950 19350 19750 20150 20400 7 Required Purchases in Dollars 60900 62400639006540066900 68400 69900 71400 72900 74400 7590076500 8 Budgeted Sales in Dollars 120000 123000 126000 129000 132000 135000 138000 141000 14400 147000 150000 153000 9 Sales Commissions in Dollars 10 11 Collection Ratio January January January January January January January January January January January January January February February February February February February February February February February February February March March March March 13 March February March March March March March March March April April April April April 14 March April April April April April April April May May May April May May 15 May May May MayMay June June June June June June June June June June June 16 May July July July July July July July July July July July July 17 June August August August August August August August August August August August 18 August July 19 August Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe September 20 September October October October October October October October October October October October October 21 October November November November November November November November November November November November November Cash Budget Operating Budget Supporting Schedules Inputs Order of operations May May June 7 8 Gross Margin Commission Ending Inventory Minimum Cash Balance Interest Rate $ 60,000 $ 12,000 6150 units $ 20,000 12% 10 11 15 Month 16 Month 1 17 Month 2 18 Month 3 Collections 25% 50% 25% Payments 60% 40% 0% Concatenate/Right Function Upper function Lower Function Period 1 PERIOD 1 Period 2 PERIOD 2 Period 3 PERIOD 3 19 20 Operating Expenses 21 Payroll 22 Utilities 23 Other Per Month $16,000 $7,000 $19,500 Inputs Supporting Schedules Operating Budget Cash Budget Order of Operations Budget Assumptions First month's Sales in units Sales Growth per month Sales Price per unit $ 10,000 250 units Gross Margin Commission Ending Inventory Minimum Cash Balance Interest Rate $ 60,000 $ 12,000 6150 units $ 20,000 12% Month Month 1 Month 2 Month 3 Collections 25% 50% 25% Payments 60% 40% Concatenate/Right Function Upper function Lower Function Period 1 PERIOD 1 Period 2 PERIOD 2 Period 3 PERIOD 3 OD 15 0% Operating Expenses Pavoll Inputs Per Month $16.000 Supporting Schedules Cash Budget Order of Operations Operating Budget
