uffins Budgeted Sales Selling price per dozen Total Sales Revenue from Muffins ookies Budgeted Sales Selling price per dozen read Total Sales Revenue for Cookies Budgeted Sales Selling price per loaf Total Sales Revenue for Bread otal Sales Revenue ollections from last year 1 Sales 2 Sales 3 Sales 4 Sales Total Cash Collections Sales Budget Q1 36,000 $6.00 $216,000 52,000 $5.25 $273,000 Q1 $586,463 $325,600 Q2 $0 Quarter $0 $0 $912,063 37,800 $6.00 $226,800 54,600 $5.25 $286,650 68,000 $5.75 $391,000 $880,000 $924,000 $970,200 Q3 Schedule of Cash Collections 39,690 $6.00 $238,140 57,330 $5.25 $300,983 Q2 $225,563 $356,400 $341,880 $0 $0 $923,843 71,400 74,970 93,713 $5.75 $5.75 $5.75 $410,550 $431,078 $538,847 Collections in Quarter Q3 Q4 49,613 $6.00 $297,675 71,663 $5.25 $376,228 $1,236,861 Q4 308,083 $5.75 $1,771,474 $1,212,750 $3,986,950 $0 $198,000 $374,220 $207,900 $358,974 $392,931 $448,718 $0 $931,194 $1,049,549 Total 2019 $0 163,103 $6.00 $978,615 0 235,593 $5.25 Total 2019 $812,025 $880,000 $924,000 $751,905 $448,718 $3,816,648 Q1 2020 43,758 $6.00 $262,548 63,206 $5.25 $331,832 Q2 45,946 $6.00 $275,675 66,366 $5.25 $348,423 82,654 86,787 $5.75 $5.75 $475,261 $499,024 $1,069,640 $1,123,122
uffins Budgeted Sales Selling price per dozen Total Sales Revenue from Muffins ookies Budgeted Sales Selling price per dozen read Total Sales Revenue for Cookies Budgeted Sales Selling price per loaf Total Sales Revenue for Bread otal Sales Revenue ollections from last year 1 Sales 2 Sales 3 Sales 4 Sales Total Cash Collections Sales Budget Q1 36,000 $6.00 $216,000 52,000 $5.25 $273,000 Q1 $586,463 $325,600 Q2 $0 Quarter $0 $0 $912,063 37,800 $6.00 $226,800 54,600 $5.25 $286,650 68,000 $5.75 $391,000 $880,000 $924,000 $970,200 Q3 Schedule of Cash Collections 39,690 $6.00 $238,140 57,330 $5.25 $300,983 Q2 $225,563 $356,400 $341,880 $0 $0 $923,843 71,400 74,970 93,713 $5.75 $5.75 $5.75 $410,550 $431,078 $538,847 Collections in Quarter Q3 Q4 49,613 $6.00 $297,675 71,663 $5.25 $376,228 $1,236,861 Q4 308,083 $5.75 $1,771,474 $1,212,750 $3,986,950 $0 $198,000 $374,220 $207,900 $358,974 $392,931 $448,718 $0 $931,194 $1,049,549 Total 2019 $0 163,103 $6.00 $978,615 0 235,593 $5.25 Total 2019 $812,025 $880,000 $924,000 $751,905 $448,718 $3,816,648 Q1 2020 43,758 $6.00 $262,548 63,206 $5.25 $331,832 Q2 45,946 $6.00 $275,675 66,366 $5.25 $348,423 82,654 86,787 $5.75 $5.75 $475,261 $499,024 $1,069,640 $1,123,122
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please figure out the missing categories shown in one of the photos based on the numbers from the previous photo. THank you.
Transcribed Image Text:Muffins
Budgeted Sales
Selling price per dozen
Total Sales Revenue from Muffins
Cookies
Budgeted Sales
Selling price per dozen
Bread
Total Sales Revenue for Cookies
Budgeted Sales
Selling price per loaf
Total Sales Revenue for Bread
Total Sales Revenue
Collections from last year
Q1 Sales
Q2 Sales
Q3 Sales
Q4 Sales
Total Cash Collections
Sales Budget
Q1
36,000
$6.00
$216,000
52,000
$5.25
$273,000
$880,000
Q1
$586,463
$325,600
Q2
$0
Quarter
$0
$0
$912,063
37,800
$6.00
$226,800
68,000
$5.75
$391,000 $410,550
54,600
$5.25
$286,650
71,400
$5.75
Schedule of Cash Collections
Q3
Q2
$225,563
$356,400
$341,880
39,690
49,613
$6.00
$6.00
$238,140 $297,675
57,330
$5.25
$300,983
$0
$0
$923,843
Collections in Quarter
Q3
Q4
74,970
93,713
$5.75
$5.75
$431,078 $538,847 $1,771,474
$924,000 $970,200 $1,212,750 $3,986,950
71,663
$5.25
$376,228 $1,236,861
Q4
$0
$198,000
$374,220
$207,900
$358,974 $392,931
$448,718
$0
$931,194 $1,049,549
Total
2019
$0
163,103
$6.00
$978,615
0
235,593
$5.25
308,083
$5.75
Total
2019
$812,025
$880,000
$924,000
$751,905
$448,718
$3,816,648
Q1
2020
43,758
$6.00
$262,548
63,206
$5.25
$331,832
82,654
$5.75
$475,261
Q2
45,946
$6.00
$275,675
66,366
$5.25
$348,423
86,787
$5.75
$499,024
$1,069,640 $1,123,122
Transcribed Image Text:Muffins
Sales
Add ending inventory
Less beginning inventory
Required production
Q1
Q2
Q3
Q4
Total
Expert Solution
Step 1
Based on the information provided, the question appears to be related to accounting and budgeting, specifically in the area of sales forecasting and production planning. Therefore, it can be categorized under the broad topic of finance and accounting.
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