Waterway Landscaping Inc. is preparing its budget for the first quarter of 2022. 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, $81,600; December 2021, $91,800; January 2022, $102,000; February 2022, $122,400; and March 2022, $142,800. 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,280: January 2022, $12,240; February 2022, $15,300; and March 2022, $18.360. (a) Prepare the following schedules for each month in the first quarter of 2022 and for the quarter in total: (1) Expected collections from clients.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![Waterway Landscaping Inc. is preparing its budget for the first quarter of 2022. 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, $81,600; December 2021, $91,800;
January 2022, $102,000; February 2022, $122,400; and March 2022, $142,800.
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,280; January 2022, $12,240; February 2022, $15,300;
and March 2022. $18,360.
(a)
Prepare the following schedules for each month in the first quarter of 2022 and for the quarter in total:
(1) Expected collections from clients.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd985a829-0788-4997-8ef8-1e5d63a0a18d%2F16ba6040-7f0c-4708-bb77-3c39624d8381%2Fgs3fv9j_processed.jpeg&w=3840&q=75)
![November $
December
January
February
March
Total
collections
Show Transcribed Text
December $
January
February
March
Total
payments
(b)
January
S
(2)
January
(1) Accounts receivable $
Accounts payable
WATERWAY LANDSCAPING INC.
Schedule of Expected Collections From Clients
$
$
Determine the following balances at March 31, 2022:
$
$
February
WATERWAY LANDSCAPING INC.
Schedule of Expected Payments for Landscaping Supplies
$
February
$
March
$
March
$
$
$
Quarter
Quarter](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd985a829-0788-4997-8ef8-1e5d63a0a18d%2F16ba6040-7f0c-4708-bb77-3c39624d8381%2Fhwwsuss_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)