please help me fill in the blue boxes. (with excel formulas)

B2- Insert Draw from exsy from o cashow budget ouding Formulas Data Review Vie File Page Layout Help Comments O Connect Connection TIT Geography A ST: Get De comes Son formand A D 1 G March May fune AN M December Recap 8354 January 20,000 30,00 H September October November 135,000 116,000 141,000 144000 147,000 90.750 123,000 126,000 129.000 137,000 150 000 001 14400 GO 12000 - 16000 -7000 19500 Cash Balance Beginning Collections Total Cash Available Less Disbursements Inventory Purchases Commissions Payroll Utilities Other Total Disements Deces (deficiency of receipts over disbursements Financing Interest Borrowings Repayments Total Financing Dividends Paid Cash Balance, Endine 6150 1200 16000 000 19500 470" 6300 12600 16000 -7000 -19500 " 6450 12900 16000 2000 19500 " 6600 -13.00 16000 7000 19500 43500 6750 13500 1600 2000 1940 MO" 10 16000 2000 17.00 4500 - 14100 16000 000 1 47400 -2500 15000 16000 2000 -7350 14700 - 16000 1000 -19500 47500 7000 19500 4500 1500 16000 1000 19500 400 1700 2140 2370 200 21000 410 21000 620 21000 1260 22000 20000 1930 2.3000 37000 14 22000 0 10 21000 O 20170 0 D 0 1040 22000 O sono 0 0 0 0 0 0 20300 20500 2010 20140 200 2000 0 0 0 D 0 0 O Inputs Supporting Schedules Order of Operation Cash Budget Operating Budget g W20 BI Type here to search o AutoSave On cash flow budget - Upload Pending e Search Home Insert Help From Text/CSV From Web Get Data From Table/Range Draw Page Layout Recent Sources Existing Connections Formulas Data Review View Queries & Connections Refresh e Properties All Edit Links Queries & Connections 21 21 Sort Geography Stocks Se Consolidate Remove Duplicates Relationships Text to Columns Data Validation - Manage Data Model B Reapply Advanced Filter Get & Transform Data DataTypes Sort & Data Tools 838 X -SUM(126) N July 5450 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 D E January February March April May 10000 10,250 10,500 10,750 6150 6300 6600 16150 16550 16950 17350 6000 6150 6300 6450 10150 10400 10650 10900 60900 62400 63900 65400 120000 123000 126000 129000 12000 12300 12600 12900 F G June 11,000 11,250 6750 6900 17750 18150 6600 6750 11150 11400 66900 68400 132000 135000 13200 13500 H 1 M August September October November December 11,500 11,750 12,000 12,250 12,500 12,750 7050 7200 7350 7500 7650 7650 18550 18950 19350 19750 20150 20400 6900 7050 7200 7350 7500 7650 11650 11900 12150 12000 12650 12750 71400 72900 76400 75900 76500 138000 141000 146000 147000 150000 153000 13800 14100 14400 14700 15000 15.100 Mary June July August September October November December 25 SON 25% 2S SON 25 25% SON 25 25 SON 25 25 SON 25 25 SON 11 Collection Ratio January February March 12 January 25% 50% 25% 13 February 2 SON 25% 14 March so 15 April 25% 16 May 17 June 18 July 19 August 20 September 21 October 22 November 23 December 24 25 Collections January February March April May 26 January 30000 60000 30000 D 27 February 0 30750 61500 30750 28 March D 0 31500 63000 29 April a 0 32250 inputs Supporting Schedules Order of Operations Operating fludget SON 253 son 25N August September October 0 0 November December O 0 O 0 0 0 0 June July 0 0 0 31500 0 64500 32250 Cash Budget + 0 0 O 0 O D 0 0 D 0 O 0 O Type here to search RA B21 X 16000 D F E LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption TRIM Function Gross Margin Commission Ending Inventory $ SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption A B C 1 Budget Assumptions 2 First Month's Sales in Units 10,000 3 Unit Sales Growth Per Month 250 4 Unit Sales Price $ 12.00 5 6 7 Gross Margin 50% 8 Commission 10% 9 Ending Inventory 60% 10 11 12 Minimum Cash Balance 20,000 13 Interest Rate 12% 14 15 Month Collections Payments 16 Month 1 25% 60% 17 Month 2 50% 40% 18 Month 3 25% 0% 19 20 Operating Expenses - Per Month 21 Payroll 16,000 22 Utilities 7,000 23 Other 19,500 24 25 26 27 28 29 Inputs Supporting Schedules Order of Operations Ready CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOD 2 PERIOD 3 MID Function 7200 Payroll 7500. Utilities 7900. Other Operating Budget Cash Budget a d Queries & Connections Recent Sources Eesting Connections BAN From Text/CSV From Web From Table Range E th Refresh Adits Stocks Geography 210 77 Sort 21 & Reapply Filter Advanced Sot Se consolidate Remove Duplicates in Text to Columns Data Validation Manage Data Model Data Tools What Ford Analysis & Transformat Os contos Foreca - F B January February D March E April May H July June August September October November M December N Total 8354 Income Sales 120,000 123,000 126,000 129,000 135,000 138,000 141,000 144,000 147,000 150,000 153,000 1,613,000 132,000 132,000 120,000 123,000 126,000 129,000 135,000 138,000 141,000 140,000 147,000 150,000 153,000 1,630,000 (62.400) (12.100) (66,9001 (13,2001 169,900) 113,800) (75,500) (15,000) 0828,9001 (163 800) in (60,000) (12,000) 72,900 47.100 (63,900) (12,600) 76,500 49,500 (65.4001 (12,9001 78,300 50,700 68.4001 (13,500) 81,900 53.100 (71.4001 (14,100 85,500 55,500 (72,9001 (14 400) 87.100 56,700 (74400) (14,700) 89.100 57,900 176,500) 115,300) 91.000 61,200 80,100 83,700 74,700 48,300 90.900 59,100 (992.700) 645,300 51.900 54,500 Total income Cost of Goods Sold Purchases Commissions 0 Total Cost of Goods Sold 1 Gross Profit 2 Operating Expenses Payroll 4 Utilities 5 Other 7 Total Operating Expenses 8 Net Income -9 Ons (16,000) (7,000) (19,500) (42.500) 4.600 (16,000) 17,000) (19,500) (42,500) 5.800 (16,000) 17,0001 (19,500) (47.500) 7.000 (16,000) (7,000) (19,500 (42,500) 1.200 (16,000) 17,000) (19,500) (42,500) 9,400 (16,000) (7,000 (19,500 (42,500) 10.600 (16,000) 67,000 (19,500) (42,500) 11,000 116,000) 17.000) (19,500) (42,5001 13,000 (16,000 17.000 119.5000 (42,500 14,200 (16,0001 (7.000) (19.500) (42,500) 15,400 116,000) 17.000 (19,5001 (42.500) 16,600 (16,000) 17,000 (19,500) (42,500 18.700 1197,000) (84.0001 1234,000) (510,000) 135,500 2 4 5 6 7 Inputs Supporting Schedules Order of Operations Operating Budget Cash Budget Type here to search ly