Question
Please work in the excel with formula's- Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the
Please work in the excel with formula's-
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 2016 and expected service revenues for 2017 are November 2016, $94,290; December 2016, $83,720; January 2017, $104,810; February 2017, $122,860; March 2017, $133,740.
Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2016 and expected purchases for 2017 are December 2016, $16,190; January 2017, $13,080; February 2017, $17,510; March 2017, $21,410.
(a)
Prepare the following schedules for each month in the first quarter of 2017 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, 2017March 31, 2017For the Quarter Ending March 31, 2017 | ||||
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 For the Quarter Ending March 31, 2017For the Year Ending March 31, 2017March 31, 2017 | ||||
January | February | March | Quarter | |
December | $ | $ | $ | $ |
January | ||||
February | ||||
March | ||||
Total payments | $ | $ | $ | $ |
(b)
Determine the following balances at March 31, 2017:
(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