Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has cash and
ID: 2573086 • Letter: S
Question
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has cash and carry customers and credit customers. OfficeMart estimates that 30% o monthly sales are to cash customers, while the remaining sales are to credit customers of the credit customers, 20% pay their accounts in the nth 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 follo $116,000 145,000 212,000 The Accounts Receivable balance on September 30 was $78,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 Collections from Sales For the Three Months Ending December 31 Receipts from cash sales: Cash sales September sales on account: Colected in October October sales on account: Colected in October Colected in November November sales on account Colected in November Colected in December December sales on account: Colected in December Total cash receiptsExplanation / Answer
Preparation of schedule of cash collections from customers
October November December
Receipts from cash sales 34800 43500 63600
(116000 X 30%) (145000 X 30%) (212000 X 30%)
September Sales on account:
Collected in october 78000
October sales on account:
Collected in October (116000 X 70% X 20%) 16240
Collected in november (116000 X 70% X 80%) 64960
November sales on account:
Collected in novenber ( 145000 X 70% X 20%) 20300
Collected in December ( 145000 X 70% X 80%) 81200
December sales on account:
Collected in december (212000 X 70% X 20%) 29680
_____________________________________________
Total cash receipts 129040 128760 174480
______________________________________________
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.