Question

Laura Falk, Swifty & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter.

		January		February		March		Quarter
Budgeted revenue		$156,200		$304,590		$273,350		$734,140

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

Prepare Swifty & Hill's cash receipts budget for the first quarter. (Round answers to 0 decimal places, e.g. 5,275. 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 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 amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount
	February sales		Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount
	March sales		Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount	Enter a dollar amountEnter a dollar amount
	Totals		$Enter a total amountEnter a total amount	$Enter a total amountEnter a total amount	$Enter a total amountEnter a total amount	$Enter a total amount Enter a total amount	$Enter a total amountEnter 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 the Net Accounts Receivable in dollars Enter the Net Accounts Receivable in dollars

Answer 1

Swifty & Hill's cash receipts budget for the first quarter

Cash Receipts	Jan	Feb	Mar	Quarter
Sales (Credit sales)	$ 156,200.00	$ 305,590.00	.$ 273,350.00	$ 735,140.00
Collection:-
a) 70% in same month	$ 109,340.00	$ 213,913.00	$ 191,345.00	$ 514,598.00
b) 26% in month following sale	$ 41,535.00	$ 40,612.00	$ 79,543.40.00	$ 161,600.40
Total collection	$ 150,875.00	$ 254,525.00	$ 270,798.40	$ 676,198.40
b) 4% - Uncollectible (Bad debts)	$ 6,248.00	$ 12,223.60	$ 10,934.00	$ 29,405.60

Eg. Jan sales will be collected as follows -
70% ($ 109,340) in the same month i.e. Jan and next 26% ($ 40,612) will be collected in next month i.e Feb and balance 4% ($ 6,248) will be trated as Uncollectible i.e Bad debts

Net Accounts Receivable at the end of the quarter and also monthwise

Net Accounts Receivable	Jan	Feb	Mar
Opening balance	$ 41,535.00	$ 40,612.00	$ 79,453.40
Add- Sales (from above table)	$ 156,200.00	$ 305,590.00	$ 273,350.00
Less- Collections (from above table)	$ (150,875.00)	$ (254,525.00)	$ (270,798.40)
Less- Uncollectible (Bad debts) (from above table)	$ (6,248.00)	$ (12,223.60)	$ (10,934.00)
Closing balance - Accounts receivable (Net)	$ 40,612.00	$ 79,453.40	$ 71,071.00