Question
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has cash and carry customers and credit customers. OfficeMart estimates that 20% of monthly sales are
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% 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 | $119,000 |
November | 149,000 |
December | 218,000 |
The Accounts Receivable balance on September 30 was $80,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
October | November | December | |
Receipts from cash sales: | - | - | - |
Cash sales | 23,800 | 29,800 | 43,600 |
September sales on account: | 80,000 | - | - |
Collected in October | 19,040 | - | - |
October sales on account: | - | - | - |
Collected in October | - | - | |
Collected in November | - | 23,840 | - |
November sales on account: | - | - | - |
Collected in November | - | - | |
Collected in December | - | - | |
December sales on account: | - | - | - |
Collected in December | - | - | |
Total cash receipts | $ | $ | $ |
I need help solving the blanks, I'm having a hard time finishing this problem. Thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started