Can you help me with this table I attached? I am having troubles filling in the rest of the information. I know how to calculate the percentages, but am unsure of what goes where....! I have filled in what I believe I know, if I am wrong, please correct me. Thanks.

skahl_cashbudget_031119.xls [Compatibility Mode] - Microsoft Excel X File Home Insert Page Layout Formulas Data Review View A ? O X do Cut Verdana a Copy 10 . A A 'Wrap Text General Norma Bad Good Neutral Calculation E AutoSum Fill Paste Format Painter BID- & -A- Merge & Center $% 168 08 Conditional Format Check Cell Explanatory T... Followed Hyp... Hyperlink Input Insert Delete Format Formatting . as Table 2 Clear Sort & Find & Filter - Select Clipboard Font Alignment Number Styles Cells Editing K21 G K Q R S Cash Budget -NM Sales for Blue Bill Corporation are projected as follows for the months of June through November: 4 5 June $200,000 6 July 200,000 7 August 200,000 8 September 300,000 9 October 500,000 10 November 200,000 11 12 Credit sales account for 70% of the monthy sales and are collected one month after the sale. 13 Other receipts for October are $50,000. 14 Variable disbursements are 60% of sales each month. 15 Fixed disbursements are $10,000 each month. 16 $80,000 should be included in August for taxes 17 The company is obligated to make a $400,000 debt repayment in November. 18 Beginning cash in June is $50,000. 19 Desired ending cash each month is $10,000. 20 21 Complete the monthly cash budget for Blue Bill Corporation for June through November. Blue Bill Corporation Cash Budget June July August September October November Sales $200,000 $200,000 $200,000 $300,000 $500,000 $200,000 29 Cash sales Collections 31 Other Receipts 50,000 32 Total cash receipts 33 34 Variable disbursements 120,000 120,000 120,000 180,000 300,000 120,000 35 Fixed disbursements 10,000 10,000 10,000 10,000 10,000 10,000 36 Other disbursements 37 Total cash disbursements 38 39 Net change during the month 40 41 Beginning cash 50,000 42 Ending cash 10,000 10,000 10,000 10,000 10,000 10,000 43 Required cash 44 Excess cash to invest 45 Cash borrowed 400,000 46 47 48 1 1 Problem 1 Ready J 100% - + Search Windows So X 10:56 AM 3/11/2019