Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has cash and carry customers and credit customers. OfficeMart estimates that 30% of monthly sales are

Schedule of Cash Collections of Accounts Receivable

OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% 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 $115,000
November 144,000
December 210,000

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

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

OfficeMart Inc.
Schedule of Cash Collections from Sales
For the Three Months Ending December 31
October November December
Receipts from cash sales:
Cash sales $ $ $
September sales on account:
Collected in October
October sales on account:
Collected in October
Collected in November
November sales on account:
Collected in November
Collected in December
December sales on account:
Collected in December
Total cash receipts $ $

$

Schedule of Cash Payments for a Service Company

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 $33,100. The budgeted expenses for the next three months are as follows:

January February March
Salaries $76,100 $92,700 $102,600
Utilities 6,300 7,000 8,300
Other operating expenses 58,600 63,900 70,300
Total $141,000 $163,600 $181,200

Other operating expenses include $4,200 of monthly depreciation expense and $900 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. Enter all amounts as positive numbers.

EastGate Physical Therapy Inc.
Schedule of Cash Payments for Operations
For the Three Months Ending March 31
January February March
$ $ $
Total cash payments $ $ $

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

Police Auditing Standards And Applications

Authors: Allan Y. Jiao

2nd Edition

0398090750, 978-0398090753

More Books

Students also viewed these Accounting questions

Question

Describe the seven standard parts of a letter.

Answered: 1 week ago

Question

Explain how to develop effective Internet-based messages.

Answered: 1 week ago

Question

Identify the advantages and disadvantages of written messages.

Answered: 1 week ago