les Information: Estimated % drop: es: Q4 Q1 Q2 Current Year Q3 Q4 Q1 02 Last Year Next Year
les Information: Estimated % drop: es: Q4 Q1 Q2 Current Year Q3 Q4 Q1 02 Last Year Next Year
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
I would like to figure out how the numbers highlighted in yellow were found and what calculations were used to determine. Thank you!

Transcribed Image Text:Sales Information:
Estimated % drop:
Sales:
Q4
Q1
Q2
Q3
Q4
Q1
Q2
Last Year
Current Year
Next Year
Sales Price/Item:
Credit Policy
20%
Muffins
2018
Collection Information:
Quarter
Q3
Q4
45,000
2019
36,000
37,800
39,690
49,613
2020
43,758
45,946
$6.00
Cash Sales
Credit Sales
Collection in Current Quarter
Collection in Following Quarter
Collection in 3rd Quarter
Collections from Last Year's Sales
Sold
$802,000
$1,002,500
Manufacturing Information:
Next quarter inventory, days
Cookies
65,000
Estimated Growth:
52,000
54,600
57,330
71,663
Case Data
63,206
66,366
$5.25
2018
Prior Year
Received
10%
90%
30%
45%
25%
$621,550
$370,925
Bread
85,000
68,000
71,400
74,970
93,713
82,654
86,787
$5.75
2019
Current Year
10%
90%
30%
45%
25%
Q1
$180,450
$406,013
$586,463
5%
Estimated Additional Holiday Increase:
$0
$225,563
$225,563
Q1
Q2
Q3
Payments in Current Year (2019)
Q2
Q3
$0
$0
$0
37.0%
40.5%
22.5%
Q4
$0
$0
$0
15%
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 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