Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (JanuaryMarch). The Accrued Expenses Payable balance on January 1

A.

EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (JanuaryMarch). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows:

January February March
Salaries $60,300 $73,400 $81,200
Utilities 5,000 5,500 6,600
Other operating expenses 46,400 50,600 55,700
Total $111,700 $129,500 $143,500

Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.

Prepare a schedule of cash payments for operations for January, February, and March.

B.

Schedule of Cash Collections of Accounts Receivable

Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:

October $129,000
November 161,000
December 236,000

The Accounts Receivable balance on September 30 was $86,000.

Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.

image text in transcribedimage text in transcribed

CH 22 Problems eBook Calculator Schedule of Cash Payments EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $81,200 Utilities $60,300 5,000 46,400 $111,700 $73,400 5,500 50,600 6,600 55,700 Other operating expenses Total $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. March EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months Ending March 30 January February Payments of prior month's expense $ 26,200 $ Payments of current month's expense 75,320 87,780 Total payments $ 101,520 Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $129,000 November 161,000 December 236,000 The Accounts Receivable balance on September 30 was $86,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. December $ 59,000 Office World Inc. Schedule of Collections from Sales For the Three Months Ending December 31 October November Receipts from cash sales: Cash sales $ 32,250 $ 40,250 September sales on account: Collected in October 86,000 October sales on account: Collected in October 8,062.50 Collected in November 24,187.50 November sales on account: Collected in November 10,062.50 30,187.50 Collected in December December sales on account: Collected in December 44,250 Total cash receipts $ 126,312.50 143,000 $ 133,437.50

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Digging For Disclosure Tactics For Protecting Your Firms Assets From Swindlers, Scammers, And Imposters

Authors: Kenneth S. Springer, Joelle Scott

1st Edition

0131385569, 9780131385566

More Books

Students also viewed these Accounting questions

Question

5.3 Explain internal recruitment methods.

Answered: 1 week ago