XYZ, Inc. had actual sales of $150,000 in February and $170,000 in March. The firm's managers estimate that sales in April, May, June and July will be $180,000, $200,000, $240,000, and $250,000, respectively. Purchases are 40% of the next month's sales. Sales receipt patterns indicate that 70% of sales are received the same month as the sale. 20% are collected one month later and 10% are collected two months later. 50% of purchases are paid in the same month as the purchase and 50% are paid the following month. Assume that the firm has no other charges (either in Accounts Receivable or Accounts Payable) during these months.
a. Compute cash receipts from sales and cash payments from purchases in April, May and June (doing each month separately and showing your work).
b. What is the estimated Accounts Payable balance on June 30?
c. What is the estimated Accounts Receivable balance on June 30?