Question: How do I enter the formula on B8 to get 120,000 as the computed budget? Resources Presenter Info Slide ID: 4558 Step 20 of 40:

How do I enter the formula on B8 to get 120,000 asHow do I enter the formula on B8 to get 120,000 as the computed budget?

Resources Presenter Info Slide ID: 4558 Step 20 of 40: Budgeted Sales and Commissions January 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 K L M February March April Ma October November December 10000 10250 10500 10750 12250 12500 12750 611 6300 6450 6600 7500 7650 16 YOUR TURN: Compute the budgeted sales in dollars for 1150 20400 6000 each month and set the number format to General. 7650 10156 2650 12750 60900 62400 63900 654.00 74400 75900 76500 7650 500 10 nous Sunnarting Schedules Operating Budaat C ash Budaat 150 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 January February March April Ma October November December 10000 10250 10500 10750 12250 12500 12750 6150 6300 6450 6600 7500 7650 7650 16150 YOUR TURN: Compute the sales commission for 20400 6000 each month and set the number format to General. Po 7650 10150 550 12750 60900 6240063900 65400 900 74400 75900 76500 120,000 1 23.000 126,000 _129.000 147.000 150.000 153,000 1 10 Inputs Supporting Schedules Operating Budget C ash Budget

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!