Landis Company has the following sales forecasts for the selected three-month period in the current year:
Month Sales
April $12,000
May 7,000
June 8,000
Seventy percent of sales are collected in the month of the sale, and the remaining balance is collected in the following month.
Accounts Receivable balance (April 1) $10,000
Cash balance (April 1) 5,000
Minimum cash balance is $5,000. Cash can be borrowed in $1,000 increments from the local bank (assume no interest charges). Calculate the expected cash balance at the end of April and May, assuming that cash is received only from customers and that $16,000 is paid out during April and 14,000 is paid out during May.