A В D E F G J K L M Cost Per Case Cases Sold Sales Discount Net 1 Year Quarter Winery 1991 Q1 1991 Q2 1991 Q3 1991 Q4 1992|Q1 1992 Q2 1992 Q2 Appellation Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Merlot Beaulieu Merlot Beaulieu Merlot $165 $165 $165 $165 450 550 575 26.50% 30% 3 4 $165 $165 $165 $165 $163 $163 650 310 625 314 670 6. 7 Directions 8 Determine the Sales amounts by multiplying the cost per case times the cases sold. If the cost per case is greater than or equal to $160, the Discount is 26.5% (cell K3) times the sale. Otherwise the Discount is 30% (cell K4) times sales. Be sure to use an absolute reference 1. 9 1992 Q4 1991 Q1 1991 Q2 1991 Q3 1991 Q4 1992 Q1 1992 Q1 1992 Q2 10 230 425 460 11 12 $163 13 $163 450 14 $163 $163 $163 170 15 230 16 175 232 208 180 in the formula. 3. Determine the Net by subtracting the discount 17 1992 Q2 $163 $163 18 1992 Q3 1992 Q3 $163 $163 $163 $163 $163 $160 $160 $160 19 from the Sales. 20 1992 Q3 21 1992 Q4 22 219 220 175 225 180 320 325 190 4. Determine the Totals fo the columns F, G, H and I. 1992 Q4 23 1992 Q4 24 1991 Q1 1991 Q1 1991 Q2 1991 Q2 1991 Q3 25 $160 $160 $160 27 Beaulieu Merlot Beaulieu Merlot Beaulieu Merlot 28 195 29 1991 Q4 200 275 30 1001l01 Inuckhorn IModet S148 Wine Sales Cinderella's Grades Your GPA 2.
A В D E F G J K L M Cost Per Case Cases Sold Sales Discount Net 1 Year Quarter Winery 1991 Q1 1991 Q2 1991 Q3 1991 Q4 1992|Q1 1992 Q2 1992 Q2 Appellation Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Cabernet Sauvignon Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Chardonnay Beaulieu Merlot Beaulieu Merlot Beaulieu Merlot $165 $165 $165 $165 450 550 575 26.50% 30% 3 4 $165 $165 $165 $165 $163 $163 650 310 625 314 670 6. 7 Directions 8 Determine the Sales amounts by multiplying the cost per case times the cases sold. If the cost per case is greater than or equal to $160, the Discount is 26.5% (cell K3) times the sale. Otherwise the Discount is 30% (cell K4) times sales. Be sure to use an absolute reference 1. 9 1992 Q4 1991 Q1 1991 Q2 1991 Q3 1991 Q4 1992 Q1 1992 Q1 1992 Q2 10 230 425 460 11 12 $163 13 $163 450 14 $163 $163 $163 170 15 230 16 175 232 208 180 in the formula. 3. Determine the Net by subtracting the discount 17 1992 Q2 $163 $163 18 1992 Q3 1992 Q3 $163 $163 $163 $163 $163 $160 $160 $160 19 from the Sales. 20 1992 Q3 21 1992 Q4 22 219 220 175 225 180 320 325 190 4. Determine the Totals fo the columns F, G, H and I. 1992 Q4 23 1992 Q4 24 1991 Q1 1991 Q1 1991 Q2 1991 Q2 1991 Q3 25 $160 $160 $160 27 Beaulieu Merlot Beaulieu Merlot Beaulieu Merlot 28 195 29 1991 Q4 200 275 30 1001l01 Inuckhorn IModet S148 Wine Sales Cinderella's Grades Your GPA 2.
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Transcribed Image Text:File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
A Share
P Comments
Еб
fe
165
A
в
D
E
F
G
H
J
K
M
N
P
RA
1 Year Quarter Winery
Appellation
Cost Per Case Cases Sold Sales Discount Net
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Cabernet Sauvignon
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Chardonnay
Beaulieu Merlot
Beaulieu Merlot
Beaulieu Merlot
Beaulieu Merlot
Beaulieu Merlot
Beaulieu Merlot
2
1991|Q1
1991|Q2
1991 Q3
1991 Q4
$165
450
$165
550
26.50%
4
$165
575
30%
5
$165
650
6
1992 Q1
$165
310
1992 Q2
$165
625
Directions
1992 Q2
1992 Q4
1991 Q1
1991 Q2
1991 Q3
1991 Q4
8
$165
314
Determine the Sales amounts by multiplying the
cost per case times the cases sold.
If the cost per case is greater than or equal to
$160, the Discount is 26.5% (cell K3) times the
sale. Otherwise the Discount is 30% (cell K4)
1.
9
$165
670
10
$163
230
11
$163
425
2.
12
$163
460
13
$163
450
14
1992 Q1
$163
170
1992 Q1
1992 Q2
1992 Q2
15
$163
$163
230
times sales. Be sure to use an absolute reference
16
175
in the formula.
Determine the Net by subtracting the discount
17
$163
232
18
1992 Q3
$163
208
3.
1992 Q3
20 1992 Q3
1992 Q4
19
$163
180
from the Sales.
$163
219
4.
Determine the Totals fo the columns F, G, H and
21
$163
220
22 1992 Q4
$163
175
I.
23
1992 Q4
$163
225
24
1991 Q1
$160
180
1991Q1
25
26 1991 Q2
27 1991 Q2
1991 Q3
1991 Q4
$160
320
$160
325
$160
190
28
$160
195
29
$160
200
30 1001lo1
Inuckhorn IMorlot
$148
276
Wine Sales
Cinderella's Grades
Your GPA
+ 100%
|田
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 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, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education