Question
Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45. Yeopays experience is that 25% of its
Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45. Yeopays experience is that 25% of its sales are for cash and bank credit cards. The remaining 75% are on credit. Of the cash sales, 40% pay cash and the remaining 60% pay with bank credit cards. Yeopay receives payments from the bank on credit card sales at the end of the day. However, Yeopay has to pay 3% for these services. An aging schedule for accounts receivable shows the following pattern on credit sales: |
20 | % | pay in the month of sale. |
50 | % | pay in the first month following the month of sale. |
15 | % | pay in the second month following the month of sale. |
12 | % | pay in the third month following the month of sale. |
3 | % | are never collected. |
|
All accounts not paid by the end of the second month following the month of sale are considered overdue and are subject to a 2% monthly late charge. Yeopay has prepared the following sales forecasts: |
June | $ | 60,000 |
July | 80,000 | |
August | 90,000 | |
September | 96,000 | |
October | 88,000 | |
|
Required: |
1a. | Prepare a schedule of cash receipts for September. Cash receipts for September should total $86,082. (All percentage answers should be entered as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.) |
1b. | Prepare a schedule of cash receipts for October. Cash receipts for September should total $88,141. (All percentage answers should be entered as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.) |
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