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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education