Exercise 14-3A (Algo) Preparing a schedule of cash receipts LO 14-2

The budget director of Heathers Florist has prepared the following sales budget. The company had $220,000 in accounts receivable on July 1. Heathers Florist normally collects 100 percent of accounts receivable in the month following the month of sale.

Required

1. Complete the schedule of cash receipts by filling in the missing amounts.

2. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

Complete this question by entering your answers in the tabs below.

• Required A
• Required B

Complete the schedule of cash receipts by filling in the missing amounts.

	July	August	September
Sales Budget
Cash sales	$78,000	$81,000	$82,000
Sales on account	91,000	109,000	136,600
Total budgeted sales	$169,000	$190,000	$218,600
Schedule of Cash Receipts
Current cash sales
Plus: Collections from accounts receivable
Total budgeted collections	$298,000	$172,000	$191,000

Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

Accounts receivable