Budget Thirst Quencher sells plastic water bottles to outdoor enthusiasts for $1.25 each. The company's marketing manager prepared the following sales forecast (in units) for the first half of the year:
Jan 150000
Feb 125000
March 180000
April 165000
May 165000
June 155000
Total 940000
Historically, the cash collection of sales has been as follows: 55 percent of sales collected in month of sale, 35 percent of sales collected in month following sale, and 9 percent of sales collected in second month following sale. The remaining 1 percent is never collected because customers do not pay. Required: For the following task, round the per unit answers to the nearest cent, if required. Prepare a cash receipts budget for each month of the second quarter (April, May, and June).