Buster enterprises have found that their total cash receipts each month or total collection equals 20% of sales are collected in cash at time of sale, 50% are collected in the month following the sale and the remaining in 30% are collected in the second month following the sale. Cash Disbursements equals: Cost of Goods Sold is 80% of sales. Purchases are made in the month prior to the sales and payments for the purchases are made in the month of the sales. Total other cash expenses are $40,00/month. The company's cash balance as of Feb 28, 06 will be $50,000. excess cash will be used to retire short-term borrowing (if any). Buster enterprises has no short-term borrowing as of Feb. 28, 06. Assume that the interest rate on short-term borrowing is 1% per month. The company must have a minimum cash balance of 20,000 at the beginning of each month. What is Buster Enterprises' total cash receipts or total collections for April 2006. Round to nearest $100
GIVEN: Jan 300,000, Feb 340,000, Mar 380,000, April 400,000, May 420,000, June 420,000