please help me with the steps!
Step 17 of 40: Beginning Inventory 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 6300 6450 6600 6750 7650 7650 4 Total Needs 16150 16550 16950 17350 17750 50 20150 20400 5 Less Beginning inventory 6 Required Purchases in Units 7 Required Purchases in Dollars YOUR TURN: The Beginning Inventory formula is similar in nature 8 Budgeted Sales in Dollars to the Ending Inventory formula, but is a percentage of current month sales (as 9 Sales Commissions in Dollars opposed to the following month's sales as you used earlier). In other words: 10 January Sales multiplied by Ending Inventory Percentage. inputs Supporting C D January February March April 10000 10250 10500 6150 6300 6450 15150 16550 16950 May June 10750 11000 6750 17350 1 7750 November December 50 12500 12750 7650 7650 20150 20400 6600 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 if you calculate a number outside of Excel, such as with your calculator and then type it into the spreadsheet for this exercise, the cell turn red. You will not get full credit for any such cells that contain static values instead of formulas. 10 inputs Supporting Schedules Operating Budget Cash Budget July August 1 2 3 4 January February March April May June 10000 10250 10500 10750 11000 6150 6300 6450 6600 6750 Septembe October November December 12250 12500 12750 7650 7650 Wally's Widget Budgeted Sales in Units Add: Ending Inventory Total Needs Less Beginning Inventory Required Purchases in Units Required Purchases in Dollars Budgeted Sales in Dollars Sales Commissions in Dollars 6 7 8 9 May 11 Collection Ratio 12 January 13 February 14 March 15 April 16 May 17 June 18 July 19 August 20 September 21 October + Inputs 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 March March March March March March March March April April April April April April April April April April April April May May May May May May May May May May May June June June June June June June June June June June June July July July July July July July July July July July July August August August August August August August August August August August August Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe Septembe September October October October October October October October October October October October October November November November November November November November November November November November November Supporting Schedules Step 18 of 40: Required Purchases in Units 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 E February March April May 10000 10250 10500 10750 6150 6300 6450 6600 16150 16550 16950 17350 6000 6150 63.00 6450 October November December 12250 12500 12750 7500 7650 7650 19750 20150 20400 7350 7500 7650 YOUR TURN:Use an Excel formula to compute the number of inventory units Wally's Widgets will need to purchase each month to maintain the desired ending inventory balance. Inputs Supporting Schedules March April May June -100*0.03 -100+70.03 -(100+7)*0.03 Click this button or press Shift-F11 to insert a new worksheet. Assign the name Order of Operations to this worksheet Enter the formulas shown to get a sense of Excel's order of operations. As you can see, parentheses alter the order of operations, Order of Operations: Excel calculates formulas from left to right, and then in this order: Parenthesis Exponents . Division Multiplication Addition . Subtraction Budget Cash Budget Inputs Supporting Schedules Order of Operations Operatin
