Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May $40,000 June 49,000 July 31,000 August Sales Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 5 percent are uncollectible, 50 percent are collected in the month of sale, 40 percent are collected in the following month, and 5 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule. February $46,000 57,000 61,000 Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ January 41000 $ March 39000 ✔ $ 40000 $ 20000 ✔ 2000 16000 10000 38000 April 49000 24500 1960 19600 $ 46550 10000 $ May 31000 15500 1240 12400 $ 29450 $ S June 46000 23000✔ 1840 18400 O 43700 Return to question July $ 57000 28500 2280 22800 O $ 54150 O

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
i need the answer quickly
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales.
Marchi
April
May
$40,000 June
49,000 July
31,000 August
Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 5 percent
are uncollectible, 50 percent are collected in the month of sale, 40 percent are collected in the following month, and 5 percent are
collected two months after sale.
Sales
$46,000
57,000
61,000
Prepare a monthly cash receipts schedule for the firm for March through August.
Simpson Glove Company
Cash Receipts Schedule
February
39000
Collections of current sales.
Collections of prior month's sales
Collections of sales 2 months earlier
Total cash receipts
$
January
41000
$
March
40000✔ $
20000
2000
16000
38000
0 0 0 0 0
$
May
June
April
49000 ✓ $31600✔ $ 46000 ✓ $
24500
1960
19600
46550
* * * * *
15500 ✔
1240
12400 x
> O
$ 29450
23000
0 0 0 0 0
1840 x
Return to question
18400 x
July
57000
28500
2280
22800
0 0 0 0 0
43700 * $ 54150 x
Transcribed Image Text:Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. Marchi April May $40,000 June 49,000 July 31,000 August Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 5 percent are uncollectible, 50 percent are collected in the month of sale, 40 percent are collected in the following month, and 5 percent are collected two months after sale. Sales $46,000 57,000 61,000 Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule February 39000 Collections of current sales. Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ January 41000 $ March 40000✔ $ 20000 2000 16000 38000 0 0 0 0 0 $ May June April 49000 ✓ $31600✔ $ 46000 ✓ $ 24500 1960 19600 46550 * * * * * 15500 ✔ 1240 12400 x > O $ 29450 23000 0 0 0 0 0 1840 x Return to question 18400 x July 57000 28500 2280 22800 0 0 0 0 0 43700 * $ 54150 x
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Income Statement Analysis
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.
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