Calculate the borrowings for April and Total, Repayments for June and Total, and Cash balance, ending for April and June.

The monthly cash budgets for the second quarter of 2016 follow ($000 omitted) for Morrison Mfg. Co. Aminimum cash balance of $20,000 is required to start each month, and a S50,000 line of credit has been arranged with a local bank at a 11% interest rate Required Calculate the missing amounts (Hint: The total cash available includes collections from customers for all three months, plus the beginning cash balance from April 1, 2016.) (Enter your answers in thousands rounded to 2 decimal places. (i.e., 20,550 should be entered as 20.55). Use 360 days a year for calculations.) Total April May June S 27.0o S 20.00$ 20.00 27.00 S 67.00106.00134.00 307.00 $ 94.00 126.00154.00 334.00 Cash balance, beginning Add collections from customers Total cash available Less disbursements: S 51.00 61.00 49.00 $ 161.00 S 29.00 36.00 23.00$ 88.00 9.00 2.00 45.00 $ 11.00$ 11.00 S 114.00 S 106.00 85.00 S305.00 Purchase of inventory Operating expenses Capital additions Payment of dividends S 34.009 Total disbursements Excess (deficiency) of cash available s (20.00)20.0069.00 29.00 over disbursements Borrowings Repayments (including interest) Cash balance, ending S 20.00 $ 27.90