Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45. Yeopay's 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 th 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 5% monthly late charge. Yeopay has prepared the following sales forecasted

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter9: Accounting For Receivables
Section: Chapter Questions
Problem 4Q: American Signs allows customers to pay with their Jones credit card and cash. Jones charges American...
icon
Related questions
Question
Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45.
Yeopay's 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 5%
monthly late charge. Yeopay has prepared the following sales forecasts:
June
July
August
$ 78,000
116,000
126,000
150,000
September
October
106,000
Required:
1a. Prepare a schedule of cash receipts for September. Cash receipts for September should total $126,771.
1b. Prepare a schedule of cash receipts for October. Cash receipts for October should total $123,151.
Complete this question by entering your answers in the tabs below.
Req 1A
Req 18
Prepare a schedule of cash receipts for September. Cash receipts for September should total $126,771. (All percentage answers should be
entered as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.)
Budgeting Cash Receipts
Cash Receipts for September
Total
Sales
Sales %
Payment %
Collection %
Cash
Receipts
Collection of accounts receivable:
%
0
%
0
%
0
%
D
Total cash receipts
$
0
Reg 1A
Req 1B >
Req 1A
Req 1B
Prepare a schedule of cash receipts for October. Cash recipts for October should total $123,151. (All percentage ans
as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.)
Budgeting Cash Receipts
Total
Cash Receipts for October
Sales %
Payment %
Collection%
Cash
Receipts
Sales
$
%
Collection of accounts receivable:
Total cash receipts
%
%
%
%
< Req 1A
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
Req 18
0
%
$
0
0
0
0
0
0
0
Transcribed Image Text:Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45. Yeopay's 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 5% monthly late charge. Yeopay has prepared the following sales forecasts: June July August $ 78,000 116,000 126,000 150,000 September October 106,000 Required: 1a. Prepare a schedule of cash receipts for September. Cash receipts for September should total $126,771. 1b. Prepare a schedule of cash receipts for October. Cash receipts for October should total $123,151. Complete this question by entering your answers in the tabs below. Req 1A Req 18 Prepare a schedule of cash receipts for September. Cash receipts for September should total $126,771. (All percentage answers should be entered as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.) Budgeting Cash Receipts Cash Receipts for September Total Sales Sales % Payment % Collection % Cash Receipts Collection of accounts receivable: % 0 % 0 % 0 % D Total cash receipts $ 0 Reg 1A Req 1B > Req 1A Req 1B Prepare a schedule of cash receipts for October. Cash recipts for October should total $123,151. (All percentage ans as whole numbers. If "Collection %" is 100 percent for a particular period, leave the corresponding cell blank.) Budgeting Cash Receipts Total Cash Receipts for October Sales % Payment % Collection% Cash Receipts Sales $ % Collection of accounts receivable: Total cash receipts % % % % < Req 1A % % % % % % % % % % % % % % % Req 18 0 % $ 0 0 0 0 0 0 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Credit Cards
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT