Sales Espresso Drip Coffee Food/Beverage Merchandise Computer A Total Sales Expenses ||| 74°F Haze First Q ulation Mode: Automatic ✓fx 26400 B JAN $ 26,400 $ $ 14,400 $ $ 11,100 $ $ 5,300 $ $ 1,050 $ C Downtown Internet Café First Quarter Forecast First Q Goal Seek FEB D Workbook Statistics MAR 27,200 $ 26,500 $ 14,500 $ 14,800 $ 11,000 $ 4,400 $ 1,165 $ 10,800 $ 4,500 $ 1,245 $ Minivan Loan + E TOTAL COM F Q AVG 80,100 $ 26,700 43,700 $14,567 32,900 $10,967 14,200 $ 4,733 3,460 $ 1,153 [ G Proportion i 1 H
Sales Espresso Drip Coffee Food/Beverage Merchandise Computer A Total Sales Expenses ||| 74°F Haze First Q ulation Mode: Automatic ✓fx 26400 B JAN $ 26,400 $ $ 14,400 $ $ 11,100 $ $ 5,300 $ $ 1,050 $ C Downtown Internet Café First Quarter Forecast First Q Goal Seek FEB D Workbook Statistics MAR 27,200 $ 26,500 $ 14,500 $ 14,800 $ 11,000 $ 4,400 $ 1,165 $ 10,800 $ 4,500 $ 1,245 $ Minivan Loan + E TOTAL COM F Q AVG 80,100 $ 26,700 43,700 $14,567 32,900 $10,967 14,200 $ 4,733 3,460 $ 1,153 [ G Proportion i 1 H
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Indo
37
1
2
B
S
0
Clipboard
Sales
Espresso
Drip Coffee
A
Food/Beverage
Merchandise
1
P
3 Expenses
Computer
Total Sales
= First Q
alculation Mode: Automatic
74°F
Haze
$
$
Font
fx 26400
B
JAN
C
Downtown Internet Café
First Quarter Forecast
$ 11,100 $
5,300 $
$
$ 1,050 $
First Q Goal Seek
FEB
D
26,400 $ 27,200 $ 26,500 $
14,400 $
14,500 $
14,800 $
11,000 $
10,800 $
4,400 $
4,500 $
1,165 $ 1,245 $
Workbook Statistics
MAR
E
Minivan Loan +
Alignment
TOTAL
F
AVG Proportion
80,100 $ 26,700
43,700 $14,567
32,900 $10,967
14,200 $ 4,733
3,460 $ 1,153
OL
Number
H
E
I
Transcribed Image Text:c
Undo
B7
12
13
14
15
<
6 1
Paste
Clipboard
LE
computer
Expenses
16 Payroll
A
Total Sales
V
17
18
19
20
21
22
23 Income
24
Net Income
25 Profit Margin
Cost of Goods
Cost of Merchandise
Internet
Building
Advertising
Capital Assets
Miscellaneous
Total Exp
BIUD ab ✓
= First Q
Font
X✓ fx 26400
$
$
$
$
$
$
$
$
$
B
HYENTS
17,580 $
3,710 $
12,000 $
325 $
2,100 $
600 $
1,500 $
1,300 $
$
First Q Goal Seek
C
A
17,750 $
3,080 $
12,000 $
325 $
D
17,545 $
3,150 $
12,000 $
325 $
2,100 $
2,100 $
600 $
600 $
1,500 $
1,500 $
1,300 $ 1,300 $
$
M
Minivan Loan
$
+
il
E
Merge & Center ✓
Alignment
UITOEY
F
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
$
G
$% 900 90
Number
H
C
Fa
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 2 steps
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