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
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark">
xlsx
</span>
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark">
pdf
</span>