Question

Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.
Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2021 and expected service revenues for 2022 are November 2021, $80,000; December 2021, $90,000; January 2022, $100,000; February 2022, $120,000; and March 2022, $140,000.

Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are December 2021, $14,000; January 2022, $12,000; February 2022, $15,000; and March 2022, $18,000.

Prepare the following schedules for each month in the first quarter of 2017 and for the quarter in total:

January February March Quarter
November
December
January
February
March
Total collections

Answer 1

Answer:

a-1. Total cash collection for the Quarter Ending March 31, 2022 = $336,000

a-2. Total cash payment for the Quarter Ending March 31, 2022 = $43,400

b-1. Account receivable balance = $68,000

b-2. Account payable balance = $7,200

Explanation:

Note: This question is not complete and contains different dates (2017 and 2022). The complete question is therefore provided and 2022 is picked as the date before answering the question. See the attached pdf file for the complete question with 2022 as the date.

The explanation of the answer is now given as follows:

a-1. Schedule of expected cash collections from clients.

Note: See part a-1 of the attached excel file for the Schedule of expected cash collections from clients.

From the attached excel file, we have:

Total cash collection for the Quarter Ending March 31, 2022 = $336,000

a-2. Schedule of expected payments for landscaping supplies.

Note: See part a-2 of the attached excel file for the Schedule of expected payments for landscaping supplies.

From the attached excel file, we have:

Total cash payment for the Quarter Ending March 31, 2022 = $43,400

b. Determine the following balances at March 31, 2022:

b-1. Accounts receivable

Account receivable balance = ($120,000*10%) + ($140,000*40%) = $68,000

b-2. Accounts payable

Account payable balance = $18,000*40% = $7,200

Download xlsx

<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark"> xlsx

<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark"> pdf