Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required Required 6 Required 7 Required Required 9 Required 10 Cash budget. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Calculation of Cash receipts from customers: $ Total budgeted sales Cash sales Sales on credit 30% 70% April 520.000 156.000 354.000 $ May June 540.0005 522,500 162.000 156,750 378.000 365,750 Current month's cash sales Collections of receivables Total cash receipts Total cash receipts from customers April S 156.000 s 354.000 $ 520.000 May 162,000 5 364,000 525,000 $ June 156,750 378,000 534,750 ZIGBY MANUFACTURING Cash Budget April, May, and June 2017 April $ 42.000 s 520.000 562.000 May 42.000 s 526,000 568,000 June 42,000 534,750 576.750 132,000 Beginning cash balance Cash receipts from customers Total cash available Cash payments for: Purchases of equipment Dividends General & administrative salaries Loan interest Sales salaries Sales commissions Additional loan loan repayment) Direct labor Variable overhead Taxes paid 14 000 3.570 3.200 41.600 211.300 182.240 32.100 53.260 12.000 14,000 3.570 3.200 43. 200 212.400 178,840 31,560 52.660 14,000 3,570 3,200 41,800 209,300 176,970 31,230 52,330 Total cash payments Preliminary cash balance Additional loan loan repayment) Ending cash balance 541 330 20.670 21.330 42.000 $ 551.430 16,670 25.330 42.000 654,400 87.650 129,650 217,300 $ Loan balance April 5 Loan balance - Beginning of month Additional loan on repayment) Loan balance - End of month May os 25,330 25.330 $ June 25,330 129,650 154,90 $ 05