Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 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: June Total budgeted sales Cash sales April $ 166,750 $ 500,250 $ 667,000 $ May 137,750 $ 413,250 103,313 $ 25% 136,300 408,900 102,225 Sales on credit 75% May Current month's cash sales Collections of receivables Total cash receipts Total cash receipts from customers April $ 166,750 IS 137,750 500,250 500,250 $ 667,000 $ 638,000 June is 136,300 413,250 $ 549,550 ZIGBY MANUFACTURING Cash Budget April, May, and June 2019 April $ 99,000 $ 667.000 766,000 May June $ Beginning cash balance Cash receipts from customers Total cash available 171,690 638,000 809,600 262,082 549,550 811,632 slo Cash payments for Raw materials Direct labor Variable overhead Sales commissions Sales salaries General & administrative salaries 209,700 242,400 36,360 66,700 3,900 195,300 226,320 33,948 55,100 3,000 ololololo 203,000 260,880 39,132 54,520 3,900 10,000 10.000 10,000 . Dm 2 $ 99,000 $ 171,690 $ 262,082 Beginning cash balance Cash receipts from customers Total cash available > 549,550 667,000 766,000 638,000 809,690 811,632 59:54 209,700 242,400 36,360 66,700 3,900 195,300 226,320 33,948 55,100 3,900 203,000 260,880 39,132 54,520 3,900 OOOO 10,000 10,000 10,000 19,000 Cash payments for: Raw materials Direct labor Variable overhead Sales commissions Sales salaries General & administrative salaries Dividends Loan interest Long-term note interest Purchases of equipment Taxes paid Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance 210 4,040 4,040 4,040 139,000 573,310 192,690 547,608 262,082 714.472 97,160 12,840 110,000 21,000 X $ 171,690 $ 262,082 $ Loan balance April May June $ 21,000 $ 42,000 $ 42,000 Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month 21,000 X 12.840 $ 42,000 $ 42,000 S 54,840