Question

Laura Hall, Bramble & Kevin Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter.

		January		February		March		Quarter
Budgeted revenue		$400,000		$460,000		$620,000		$1,480,000

The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 72% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 2% of sales are uncollectible. The company expects to have an accounts receivable balance of $98,200 on January 1, and this amount represents the remaining receivables from December's sales.

Prepare Bramble & Kevin's cash receipts budget for the first quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

	Cash Receipts Budget
			January	February	March	Total Cash Receipts	Uncollectible
	December credit sales		$enter a dollar amount	$enter a dollar amount	$enter a dollar amount	$enter a dollar amount	$enter a dollar amount
	January sales		enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount
	February sales		enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount
	March sales		enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount	enter a dollar amount
	Totals		$enter a total amount	$enter a total amount	$enter a total amount	$enter a total amount	$enter a total amount

Determine the Net Accounts Receivable at the end of the quarter. Assume that there are no outstanding accounts receivable and allowance for doubtful accounts balances at the beginning of December for the prior year.

Net Accounts Receivable

$enter net accounts receivable amount in dollars

Answer 1

Cash Receipts Budget
		January	February	March	Total Cash Receipts	Uncollectible
December credit sales		$   98,200.00			$      98,200.00
January sales		$ 288,000.00	$ 104,000.00		$    392,000.00	$     8,000.00
February sales			$ 331,200.00	$ 119,600.00	$    450,800.00	$     9,200.00
March sales				$ 446,400.00	$    446,400.00	$   12,400.00
Totals		$ 386,200.00	$ 435,200.00	$ 566,000.00	$ 1,387,400.00	$   29,600.00
Determine the Net Accounts Receivable at the end of the quarter. Assume that there are no outstanding accounts receivable and allowance for doubtful accounts balances at the beginning of December for the prior year.
Net Accounts Receivable	$161,200
Account Receivables ($620,000 x 26%)