Question
Crane Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step in the budgeting process is to prepare a cash
Crane 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, $84,800; December 2021, $95,400; January 2022, $106,000; February 2022, $127,200; and March 2022, $148,400.
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,840; January 2022, $12,720; February 2022, $15,900; and March 2022, $19,080.
(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.
(1) Expected collections from clients. CRANE LANDSCAPING INC. Schedule of Expected Collections From Clients January February March Quarter November $ $ $ ta $ December January February March Total collections $ $ $ $ (2) Expected payments for landscaping supplies. CRANE LANDSCAPING INC. Schedule of Expected Payments for Landscaping Supplies January February March Quarter December $ $ $ January February March Total payments $ $ $ (b) Determine the following balances at March 31, 2022: (1) Accounts receivable $ ta (2) Accounts payable $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started