Question

Sales Receipts: The financial manager of Hearty Cereals is in the process of preparing a cash budget for the first quarter of 2012. The firm typically sells 1/3 of its monthly sales on cash terms and the rest on credit. An analysis of the accounts receivables shows that on average 40% of the sales are collected in the next month, 50% in 60 days, 7% in 90 days, with the rest ending up as bad debts. As the manager's assistant it is your job to project the sales receipts for the first quarter of 2012, using the monthly sales figures listed below 2011 Sales October $1,750,000 November $2,000,000 December $2,450,000 2012 Forecasted Sales January $1,850,000 February $1,650,000 March $1,900,000

Answer 1

Cash Collection Budget
	Sales Figures	January	February	March	Total
Sales		$    1,850,000.00	$   1,650,000.00	$            1,900,000.00
Cash Sales (1/3)		$       616,666.67	$      550,000.00	$               633,333.33	$   1,800,000.00
January Credit Sales	$   1,233,333.33
Collected in February			$      493,333.33		$       493,333.33
Collected in March				$               616,666.67	$       616,666.67
February Credit Sales	$      550,000.00
Collected in March				$               220,000.00	$       220,000.00
Accounts Receivables:
Credit Sales Collected:
October credit Sales	$   1,166,666.67
Collected in January		$          81,666.67			$         81,666.67
November Credit Sales	$   1,333,333.33
Collected in January		$        666,666.67			$       666,666.67
Collected in February			$        93,333.33		$         93,333.33
December Credit Sales	$   1,633,333.33
Collected in January		$        653,333.33			$       653,333.33
Collected in February			$      816,666.67		$       816,666.67
Collected in March				$               114,333.33	$       114,333.33
Total Cash Collected		$    2,018,333.33	$ 1,953,333.33	$            1,584,333.33	$   5,556,000.00

Please give positive rating