Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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?

Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 2.1A: The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based...
See similar textbooks
icon
Related questions
Question
Y2
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?
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
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
SEE MORE TEXTBOOKS