Question

In: Accounting

Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...

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 Quarter Ending March 31, 2017March 31, 2017For the Year 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 Year Ending March 31, 2017For the Quarter 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 $

Solutions

Expert Solution


(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 Quarter Ending March 31, 2017

January

February

March

Quarter

November

$9429 $ $ $9429

December

25116 8372 33488

January

62886 31443 10481 104810

February

73716 36858 110574

March

80244 80244

    Total collections

$97431 $113531 $127583 $338545


(2) Expected payments for landscaping supplies.

GREEN LANDSCAPING INC.
Schedule of Expected Payments for Landscaping Supplies

For the Quarter Ending March 31, 2017

January

February

March

Quarter

December

$6476 $ $ $6476

January

7848 5232 13080

February

10506 7004 17510

March

12846 12846

    Total payments

$14324 $15738 $19850 $49912



(b)

Determine the following balances at March 31, 2017:

(1) Accounts receivable $65782
(2) Accounts payable $12846*4/6 = 8564

Related Solutions

Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
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...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a schedule of cash collections and a schedule of cash payments. The following information has been collected: All sales are on account and 60% is collected in the month of sale, 30% 1 month after the sale, and 10% two months after the sale. Actual sales revenues for November 2016 were $80,000 and December 2016 $90,000. Projected...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
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...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
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...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
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...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
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. Prepare schedules for cash receipts and cash payments, and determine ending balances for balance sheet. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after...
Novak Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Novak 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...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step...
A Landscaping Inc. is preparing its budget for the first months of 2019. 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. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving service. The remaining 2% is written off...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 41,000 for January, 61,000 for February, and 51,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions 9 % of sales dollars Rent $ 18,000 per month Advertising 13 % of sales dollars Office salaries $ 72,000 per month Depreciation...
II. WIth Excel Formulas if possible   . Frontenac Landscaping Inc. is preparing its budget for the...
II. WIth Excel Formulas if possible   . Frontenac Landscaping Inc. is preparing its budget for the first months of 2019. 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. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT