Dan Jones is CFO for a newly formed manufacturing company. Below is the anticipated monthly production for the first six months of operation. Dan is interested in learning which of the first six months will require cash outlays of more than $40,000 toward the purchase of materials. Each unit requires 10 pounds of material at $6 per pound. All material is purchased in the month prior to its expected use. Purchases are paid for 15% in the month of purchase, 40% in the month following the month of purchase, and 45% in the second month following the month of purchase. Which months will require cash outlays in excess of the $40,000 amount? Does the production in any given month necessarily correspond to the cash flow for that same month? What are the business implications of your observation?
	UNITS Purchasing Activity (Month prior to production)	Total Pounds Units x 10lbs	Total materials cost Pounds x $6/lb.	Paid in Month 15%	Paid in Month Relating to Prior Month 40%	Paid in Month Relating to Two Months Prior 45%	Total
January	600	6,000	$36,000	$5,400
February	800	8,000	$48,000	$7,200
March	900	9,000	$54,000	$8,100
April	400	4,000	$24,000	$3,600
May	500	5,000	$30,000	$4,500
June	550	5,500	$33,000	$4,950
Total			$225,000	$33,750

I am having some trouble with this problem. I started the work and want to confirm that what I have done is correct so far and need some assistance with the others.