Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. (Click the icon to view the additional information.) All sales are made on account with 65%of sales made in a quarter collected in the same quarter and 35%collected in the following quarter. Calculate the cash collected from receivables in each of the 4 quarters of 2020(If an input field is not used in the table, leave the input field empty; do not enter a zero.) Schedule of Cash Collections Accounts receivable balance on 1-1-2020 (Fourth-quarter sales from prior year) From first-quarter 2020 sales From second-quarter 2020 sales From third-quarter 2020 sales From fourth-quarter 2020 sales Total collections 1 2 Quarters Data table 3 4 Accounts receivable (January 1, 2020) Budgeted sales in Quarter 1 (January 1 to March 31, 2020) Budgeted sales in Quarter 2 (April 1 to June 30, 2020) Budgeted sales in Quarter 3 (July 1 to September 30, 2020) Budgeted sales in Quarter 4 (October 1 to December 31, 2020) $ - X 49,000 240,000 225,000 190,000 275,000
Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. (Click the icon to view the additional information.) All sales are made on account with 65%of sales made in a quarter collected in the same quarter and 35%collected in the following quarter. Calculate the cash collected from receivables in each of the 4 quarters of 2020(If an input field is not used in the table, leave the input field empty; do not enter a zero.) Schedule of Cash Collections Accounts receivable balance on 1-1-2020 (Fourth-quarter sales from prior year) From first-quarter 2020 sales From second-quarter 2020 sales From third-quarter 2020 sales From fourth-quarter 2020 sales Total collections 1 2 Quarters Data table 3 4 Accounts receivable (January 1, 2020) Budgeted sales in Quarter 1 (January 1 to March 31, 2020) Budgeted sales in Quarter 2 (April 1 to June 30, 2020) Budgeted sales in Quarter 3 (July 1 to September 30, 2020) Budgeted sales in Quarter 4 (October 1 to December 31, 2020) $ - X 49,000 240,000 225,000 190,000 275,000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020.
(Click the icon to view the additional information.)
All sales are made on account with 65%of sales made in a quarter collected in the same quarter and 35%collected in the following quarter.
Calculate the cash collected from receivables in each of the 4 quarters of 2020(If an input field is not used in the table, leave the input field empty; do not enter a zero.)
Schedule of Cash Collections
Accounts receivable balance on 1-1-2020
(Fourth-quarter sales from prior year)
From first-quarter 2020 sales
From second-quarter 2020 sales
From third-quarter 2020 sales
From fourth-quarter 2020 sales
Total collections
1
2
Quarters
Data table
3
4
Accounts receivable (January 1, 2020)
Budgeted sales in Quarter 1 (January 1 to March 31, 2020)
Budgeted sales in Quarter 2 (April 1 to June 30, 2020)
Budgeted sales in Quarter 3 (July 1 to September 30, 2020)
Budgeted sales in Quarter 4 (October 1 to December 31, 2020)
$
I
49,000
240,000
225,000
190,000
275,000
X
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Knowledge Booster
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


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education