Rockers expects total sales of $700,000 for January and $351,000 for February. November sales totaled $392,000 and December sales were $425,000. Now assume that Rockers's sales are collected as follows: 60% in the month of the sale The following schedule of cash receipts for January and February was prepared based upon the collection history given: (Click the icon to view the collection history.) 30% in the month after the sale 5% two months after the sale 5% never collected (Click the icon to view the schedule of cash receipts.) Prepare a revised schedule of cash receipts for January and February. (If an input field is not used in the table leave the input field empty: do not enter a zero.) More Info Cash Receipts from Customers January February Total sales 700,000 351,000 50% in the month of the sale January February 40% in the month after the sale Cash Receipts from Customers: 6% two months after the sale Nov.-Credit sales, collection of Nov. sales in Jan. 19600 4% never collected Dec.-Credit sales, collection of Dec. sales in Jan. 127500 Dec.-Credit sales, collection of Dec. sales in Feb. 21250 Print Done lan 420000 Credit sales colloction

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
Rockers expects total sales of $700,000 for January and $351,000 for
February. November sales totaled $392,000 and December sales were
$425,000.
Now assume that Rockers's sales are collected as follows:
60% in the month of the sale
The following schedule of cash receipts for January and February was
prepared based upon the collection history given:
(Click the icon to view the collection history.)
30% in the month after the sale
5% two months after the sale
5% never collected
(Click the icon to view the schedule of cash receipts.)
Prepare a revised schedule of cash receipts for January and February.
(If an input field is not used in the table leave the input field empty; do not enter a zero.)
More Info
Cash Receipts from Customers
January
February
Total sales
700,000
351,000
50% in the month of the sale
January
February
40% in the month after the sale
Cash Receipts from Customers:
6% two months after the sale
Nov.-Credit sales, collection of Nov. sales in Jan.
19600|
4% never collected
Dec.-Credit sales, collection of Dec. sales in Jan.
127500
Dec.-Credit sales, collection of Dec. sales in Feb.
21250
Print
Done
Jan
Credit sales, collection of Jan. sales in Jan.
420000
Jan.-Credit sales, collection of Jan. sales in Feb.
210000
Feb.-Credit sales, collection of Feb. sales in Feb.
210600
567100
441850
Total cash receipts from customers
Transcribed Image Text:Rockers expects total sales of $700,000 for January and $351,000 for February. November sales totaled $392,000 and December sales were $425,000. Now assume that Rockers's sales are collected as follows: 60% in the month of the sale The following schedule of cash receipts for January and February was prepared based upon the collection history given: (Click the icon to view the collection history.) 30% in the month after the sale 5% two months after the sale 5% never collected (Click the icon to view the schedule of cash receipts.) Prepare a revised schedule of cash receipts for January and February. (If an input field is not used in the table leave the input field empty; do not enter a zero.) More Info Cash Receipts from Customers January February Total sales 700,000 351,000 50% in the month of the sale January February 40% in the month after the sale Cash Receipts from Customers: 6% two months after the sale Nov.-Credit sales, collection of Nov. sales in Jan. 19600| 4% never collected Dec.-Credit sales, collection of Dec. sales in Jan. 127500 Dec.-Credit sales, collection of Dec. sales in Feb. 21250 Print Done Jan Credit sales, collection of Jan. sales in Jan. 420000 Jan.-Credit sales, collection of Jan. sales in Feb. 210000 Feb.-Credit sales, collection of Feb. sales in Feb. 210600 567100 441850 Total cash receipts from customers
Cash Receipts from Customers
January
February
Total sales
$ 700,000 $
351,000
January
February
Cash Receipts from Customers:
Nov.-Credit sales, collection of Nov. sales in Jan.
$.
23,520
Dec.-Credit sales, collection of Dec. sales in Jan.
170,000
Dec.-Credit sales, collection of Dec. sales in Feb.
$4
25,500
Jan.-Credit sales, collection of Jan. sales in Jan.
350,000
Jan.-Credit sales, collection of Jan. sales in Feb.
280,000
Feb.-Credit sales, collection of Feb. sales in Feb.
175,500
543,520 $
481,000
Total cash receipts from customers
Transcribed Image Text:Cash Receipts from Customers January February Total sales $ 700,000 $ 351,000 January February Cash Receipts from Customers: Nov.-Credit sales, collection of Nov. sales in Jan. $. 23,520 Dec.-Credit sales, collection of Dec. sales in Jan. 170,000 Dec.-Credit sales, collection of Dec. sales in Feb. $4 25,500 Jan.-Credit sales, collection of Jan. sales in Jan. 350,000 Jan.-Credit sales, collection of Jan. sales in Feb. 280,000 Feb.-Credit sales, collection of Feb. sales in Feb. 175,500 543,520 $ 481,000 Total cash receipts from customers
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Receivables Management
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
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