Question
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. 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 2019 and expected service revenues for 2020 are November 2019, $93,660; December 2019, $82,580; January 2020, $104,570; February 2020, $124,710; and March 2020, $133,440. Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $17,570; January 2020, $16,320; February 2020, $17,320; and March 2020, $22,350. (a) Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total: (1) Expected collections from clients.
GREEN LANDSCAPING INC. Schedule of Expected Collections From Clients For the Year Ending March 31, 2020For the Quarter Ending March 31, 2020March 31, 2020 | ||||||||
January | February | March | Quarter | |||||
November | $ | $ | $ | $ | ||||
December | ||||||||
January | ||||||||
February | ||||||||
March | ||||||||
Total collections | $ | $ | $ | $ |
(2) Expected payments for landscaping supplies.
GREEN LANDSCAPING INC. Schedule of Expected Payments for Landscaping Supplies March 31, 2020For the Year Ending March 31, 2020For the Quarter Ending March 31, 2020 | ||||||||
January | February | March | Quarter | |||||
December | $ | $ | $ | $ | ||||
January | ||||||||
February | ||||||||
March | ||||||||
Total payments | $ | $ | $ | $ |
(b) Determine the following balances at March 31, 2020:
(1) | Accounts receivable | $ | ||
(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