FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

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, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:

October $133,000
November 166,000
December 243,000

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

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

Office World Inc.
Schedule of 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 Noember      
November sales on account:      
Collected in November      
Collected in December      
December sales on account:      
Collected in December      
Total cash receipts      
Expert Solution
Check Mark
Step 1 schedule of cash collections from sales for October, November, and December
PARTICULARS OCTOBER NOVEMBER DECEMBER
Receipts from cash sales:      
Cash sales

$133000 * 25% 

= $33250

$166000 * 25%

= $41500 

$243000 * 25%

= $60750

September sales on account  $89000    
Collected in October  $71200    
October sales on account

 $133000 * 75% 

= $99750

 

 

Collected in October

 $99750 *20%

= $19950

 

 

Collected in November

 $99750 * 80%

= $79800

 

 

November sales on account:  

 $166000 * 75%

=$124500

 

Collected in November  

$124500 *20%

= $24900

 
Collected in December  

 = $124500 * 80%

= $99600

 
December sales on account:    

$243000 * 75%

= $182250

Collected in December    

 $182250 * 20%

= $36450

Total cash receipts

$124450

(OCTOBER MONTH CASH COLLECTION)

$146200

(NOVEMBER MONTH CASH COLLECTION)

$196800

(DECEMBER MONTH CASH COLLECTION)

       
       
       
       
       
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education