For the data presented in the figure below A B C 1 Inputs-Costs, Capacities, Demands 2 3 4 Supply Region N. America S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints Demand Regio Production and Transportation Cos N America S America Europe 92 81 117 102 115 142 5 6 Europe 7 Asia 8 Africa 9 Demand 10 11 Decision Variables 12 13 Supply Region N America S. America Europe 14 N. America 0 15 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmet Demand 29 30 Objective Function 31 Cost- 12 0 2000 21 Supply Region Excess Capacity 22 N. America 23 S. America S 23,751 12 1003 2刀 13 125 100 Demand Region - Production Allo Plants 0 77 D 8 8000 101 108 95 90 103 14 3 N. America S. America Europe 0 0 04000 10 E 0 Fixed Low Fixed High Cost (5) Capacity Cost (5) Capacity 6.000 10 9,000 4,500 10 6,750 6,500 10 9.750 4,100 10 6,150 10 6,000 4,000 Plants (1-open) (1-open) G 0000 H 682222 20 20 20 20 20 1- Assuming that the unit cost in the above excel snapshot is given per 1,000, 000 units, and the resulting deman allocation is shown in 1000 units. Then, what is the variable cost of shipping from Asia to Europe? 2- What is the cell formula for the unmet demand for Europe? 3- What is the cell formula for the excess capacity of Asia?
For the data presented in the figure below A B C 1 Inputs-Costs, Capacities, Demands 2 3 4 Supply Region N. America S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints Demand Regio Production and Transportation Cos N America S America Europe 92 81 117 102 115 142 5 6 Europe 7 Asia 8 Africa 9 Demand 10 11 Decision Variables 12 13 Supply Region N America S. America Europe 14 N. America 0 15 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmet Demand 29 30 Objective Function 31 Cost- 12 0 2000 21 Supply Region Excess Capacity 22 N. America 23 S. America S 23,751 12 1003 2刀 13 125 100 Demand Region - Production Allo Plants 0 77 D 8 8000 101 108 95 90 103 14 3 N. America S. America Europe 0 0 04000 10 E 0 Fixed Low Fixed High Cost (5) Capacity Cost (5) Capacity 6.000 10 9,000 4,500 10 6,750 6,500 10 9.750 4,100 10 6,150 10 6,000 4,000 Plants (1-open) (1-open) G 0000 H 682222 20 20 20 20 20 1- Assuming that the unit cost in the above excel snapshot is given per 1,000, 000 units, and the resulting deman allocation is shown in 1000 units. Then, what is the variable cost of shipping from Asia to Europe? 2- What is the cell formula for the unmet demand for Europe? 3- What is the cell formula for the excess capacity of Asia?
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
Y2
Transcribed Image Text:For the data presented in the figure below
A
B
C
1 Inputs-Costs, Capacities, Demands
2
3 Supply Region
4
N America
S. America
5
6 Europe
7 Asia
Demand Regio
Production and Transportation Cos
N America S America Europe
81
117
102
115
142
8 Africa
9 Demand
10
11 Decision Variables
12
13 Supply Region
14 N. America
15 S. America
16 Europe
17 Asia
18 Africa
19
20 Constraints
21 Supply Region Excess Capacity
22 N. America
23 S. America
24 Europe
25 Asia
26 Africa
27
28 Unmet Demand
29
30 Objective Function
31 Cost-
12
S 23,751
០០០០
12
92
77
105
60030
125
100
8
OOOOO
8
Demand Region - Production Allo Plants
N. America S. America Europe
0
0
D
0
0
N. America S. America Europe
0
0
101
108
95
90
103
14
70040
10
E
0
6,000
4,500
6,500
4,100
4,000
Fixed
Low Fixed
High
Cost (5) Capacity Cost (5) Capacity
20
F
OOOOO
G
10 9,000
10 6,750
10 9.750
Plants
(1-open) (1-open)
10 6,150
10 6,000
0
1
0
1
H
88888
20
20
20
20
1- Assuming that the unit cost in the above excel snapshot is given per 1,000, 000 units, and the resulting demand
allocation is shown in 1000 units. Then, what is the variable cost of shipping from Asia to Europe?
2- What is the cell formula for the unmet demand for Europe?
3- What is the cell formula for the excess capacity of Asia?
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.