A erage lise es ods erchandise ets bus e B $ 11,100 $ 5,300 $ se si $ $ 1,050 $ $ 58,250 $ $ 17,580 $ $ 3,710 $ $ 12,000 es is esse $ $ 2,100 $ 600 $ $ 1,500 $ 1,300 $ $ 39,115 $ $ $ 325 $ $ 12,000 $ 325 $ C 11,000 $ 4,400 $ 1,165 $ 58,265 $ $ 19,135 $ 32.85% 17,750 $ 17,545 $ 52,875 $17,625 3,080 $ 3,150 $ 9,940 $3,313 12,000 $ 36,000 $12,000 325 $ 975 $ 325 2,100 $ 6,300 $2,100 600 $ 1,800 $ 600 1,500 $ 4,500 $1,500 1,300 $ 3,900 $1,300 38,520 $ 116,290 $38,763 2,100 $ 600 $ 1,500 $ 1,300 $ 38,655 $ D 10,800 $ 4,500 $ 1,245 $ 57,845 $ 19,610 $ 33.66% E F 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 19,325 $ 58,070 $19,357 33.41% 33.30% 33% G 18.87% 8.14% 1.98% 100.00% 45.5% 8.55% 31.0% 0.8% 5.4% 1.5% 3.9% 3.4% 100.00% H
A erage lise es ods erchandise ets bus e B $ 11,100 $ 5,300 $ se si $ $ 1,050 $ $ 58,250 $ $ 17,580 $ $ 3,710 $ $ 12,000 es is esse $ $ 2,100 $ 600 $ $ 1,500 $ 1,300 $ $ 39,115 $ $ $ 325 $ $ 12,000 $ 325 $ C 11,000 $ 4,400 $ 1,165 $ 58,265 $ $ 19,135 $ 32.85% 17,750 $ 17,545 $ 52,875 $17,625 3,080 $ 3,150 $ 9,940 $3,313 12,000 $ 36,000 $12,000 325 $ 975 $ 325 2,100 $ 6,300 $2,100 600 $ 1,800 $ 600 1,500 $ 4,500 $1,500 1,300 $ 3,900 $1,300 38,520 $ 116,290 $38,763 2,100 $ 600 $ 1,500 $ 1,300 $ 38,655 $ D 10,800 $ 4,500 $ 1,245 $ 57,845 $ 19,610 $ 33.66% E F 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 19,325 $ 58,070 $19,357 33.41% 33.30% 33% G 18.87% 8.14% 1.98% 100.00% 45.5% 8.55% 31.0% 0.8% 5.4% 1.5% 3.9% 3.4% 100.00% H
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
What goes in the missing boxes and is my data correct?
Transcribed Image Text:ont
A
9 Food/Beverage
0 Merchandise
1
Computer
2 Total Sales
3 Expenses
4 Cost of Goods
5
Miscellaneous
Total Exp
Cost of Merchandise
Payroll
Internet
Building
Advertising
Capital Assets
Income
Net Income
>
Profit Margin
Student's Namai
First Q
lılı
||||
Դ Դ Դ Դ
esssssss
B
$ 11,100 $
es s
121
Sss
Alignment
$
M
$ 58,250 $
5,300 $
$ 17,580 $
$ 3,710 $
$
12,000 $
$
325 $
$
2,100 $
$
600 $
$
1,500 $
1,300 $
$ 39,115 $
1,050 $
$ 19,135 $
32.85%
First Q Goal Seek
S
C
11,000 $
4,400 $
1,165 $
58,265 $
17,750 $
3,080 $
$
325 $
2,100 $
600 $
1,500 $
1,300 $
38,655 $
12,000
500 000
Minivan Loan
Number
D
10,800 $
4,500 $
1,245 $
57,845 $
17,545 $
3,150 $
12,000 $
325 $
2,100 $
600 $
1,500 $
1,300 $
38,520 $
19,610 $ 19,325 $
33.66%
33.41%
S
Format as Table
Cell Styles
Styles
E
F
32,900 $10,967
14,200 $4,733
3,460 $ 1,153
174,360 $58,120
52,875 $17,625
9,940 $3,313
36,000 $12,000
975 $ 325
6,300 $2,100
1,800 $ 600
4,500 $ 1,500
3,900 $ 1,300
116,290 $38,763
58,070 $19,357
33.30%
33%
G
18.87%
8.14%
1.98%
100.00%
45.5%
8.55%
31.0%
0.8%
5.4%
1.5%
3.9%
3.4%
100.00%
Delete
Format
Cells
H
↓
8:08
2
Sor
Filta
Ed
Transcribed Image Text:Font
234
5
6 Sales
7
8
9
10 Merchandise
11
12
13 Expenses
14 Cost of Goods
A
Espresso
Drip Coffee
Food/Beverage
Computer
Total Sales
Payroll
Internet
Building
15 Cost of Merchandise
16
17
18
17
First Q
$
$
$
$
Alignment
$
$
B
26,400 $
14,400 $
11,100 $
5,300 $
1,050 $
$ 58,250 $
JAN
D
E
Downtown Internet Café
First Quarter Forecast
17,580 $
3,710 $
12,000 $
325 $
$
$
$
$
2,100
First Q Goal Seek
C
FEB
27,200 $
14,500 $
11,000 $
4,400 $
1,165 $
58,265 $
.00 →.0
17,750 $
3,080 $
12,000 $
325 $
2,100 $
Minivan Loan
Number
MAR
17,545 $
3,150 $
12,000 $
325 $
$
5
2,100
10
Cell Styles
TOTAL
Styles
26,500 $ 80,100 $26,700
14,800 $
43,700 $14,567
10,800 $
32,900 $10,967
4,500 $
14,200 $4,733
1,245 $
3,460 $ 1,153
57,845 $
174,360 $58,120
F
AVG
52,875 $17,625
9,940 $3,313
36,000 $12,000
975 $ 325
6,300 $2,100
G
Proportion
45.94%
25.06%
18.87%
8.14%
1.98%
100.00%
45.5%
8.55%
31.0%
0.8%
5.4%
◄
Format v
Cells
H
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 3 steps with 1 images
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