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.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
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%
|田
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Sales
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
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
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)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
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-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education