Are my formulas correct and did I get the correct answer? Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20. a. Determine how Sunblessed can maximize its profit.
Are my formulas correct and did I get the correct answer? Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20. a. Determine how Sunblessed can maximize its profit.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
100%
Are my formulas correct and did I get the correct answer?
Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20.
a. Determine how Sunblessed can maximize its profit.
Transcribed Image Text:insert
Draw
Page Layout
Formulas
Data
Review View
SolverTable
fx
Σ
V
V
?
V
V
Ө
V
L
Insert
Function
AutoSum Recently Financial Logical Text Date &
Name
Lookup &
Lookup & Math &
Reference Trig
More
Functions
Used
Time
Manager C
Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you
H28
-x fx
A
B
C
D
E
F
G
H
1 Selling oranges and orange juice
Range Names
Available
2
3
Revenues, variable costs
Mix
=Model I$F$10:$F$11
-Model!$B$10:$C$11
=Modell$B$27
4
Profit
Revenue
=Model 1$B$20:$C$20
=Model!$B$22:$C$22
6
Quality
Required
Used
Variable cost
7
=Model!$D$10:$D$11
8
Grades used to make juice and bags
9
Grade
10
6
11
9
12
Sold
13
14 Required average quality
15
16
17
18 Quality constraints
19
20 Actual
21
22 Required
23
24 Total variable cost
25 Total revenue
26
27 Profit
28
29
30
31
32
33
34
35
36
5
O
Ready
P4-46 Model
JUN
Q
9
Juice
$2.25
$1.35
Juice
26666.666
53333.332
80000
Juice
8
Juice
640000
X
640000
$456,000
$760,000
$304,000
Bags
$2.00
$1.20
Bags Used
193333.328 220000
96666.664 150000
289999.992
Bags
7
Bags
2029999.944
>=
2029999.944
P4-46 Sensitivity Analysis
슈슈
Available
220000
150000
P4-48 Model
+
P4-48 Sensitivity Analysis
S
8
1
لله -
F
Transcribed Image Text:Copy of M3 MAC Excel Assignment Template for mac (1)
Home Insert Draw Page Layout
Review
View SolverTable
SolverTable for Mac
fx [
V
V
V
ӨГ
Define Name v
V
Insert
Function
AutoSum Recently Financial Logical
Used
Text
Date & Lookup & Math &
Time Reference Trig
More
Name
Functions Manager
Use in Formula v
Create from Selection
Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?
H28
x ✓ fx
A
B
C
D
E
1 Selling oranges and orange juice
2
3
Revenues, Variable costs
Juice
Bags
Revenue
2.25
6
Variable cost
1.35
7
8
Grades used to make juice and bags
9
Grade
Bags
10 6
26666.666
193333.328
<=
11 9
53333.332
96666.664
=SUM(C10:C11)
12
Sold
=SUM(B10:B11)
13
14 Required average quality
15
Juice
Bags
16
17
18 Quality constraints
Juice
Bags
19
20 Actual
=SUMPRODUCT($A$10:$A$11,B10:B11) =SUMPRODUCT($A$10:$A$11,C10:C11)
>=
>=
21
=C12*C16
=B12 B16
P
22 Required
23
-SUMPRODUCT(B6:C6,B12:C12)
24 Total variable cost
=SUMPRODUCT(B5:C5,B12:C12)
25 Total revenue
26
=B25-B24
27 Profit
28
29
30
31
32
33
34
35
P4-50 Model
36
P4-48 Sensitivity Analysis
P4-46 Sensitivity Analysis
♫
al S
3:
5
O
Ready
P4-46 Model
JUN
9
00
Formulas
Al
V
Data
Juice
2
1.2
7
P4-48 Model
Zali
MacBook Pro
Used
=SUM(B10:C10)
=SUM(B11:C11)
♥
Tell me
Trace Precedents
Trace Dependents
Remove Arrows ✓
F
f
220000
150000
P4-50 Sensitivity Analysis 3
回
X
A i
B
Available
W
o
00
Vfx
V
Show Error Watch
Formulas Checking Window
G
H
Range Names
Available
Mix
Profit
Quality
Required
Used
+
Thu Jun 9 10:54 AM
a gº
Comments
Share
Calculation
Options
Yes
No
=Model I$F$10:$F$11
=Model!$B$10:$C$11
=Model!$B$27
-Model 1$B$20:$C$20
-Model 1$B$22:$C$22
-Modell$D$10:$D$11
100%
+
gle Pla
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 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.