Question: Recall the Sun Oil example from class. a) If a plant must be built in Europe, what constraint(s) would you add to the model? b)

Recall the Sun Oil example from class. a) If a plant must be built in Europe, what constraint(s) would you add to the

Recall the Sun Oil example from class.

a) If a plant must be built in Europe, what constraint(s) would you add to the model?

b) Re-run Solver with your updated model from part a. Submit your Excel file.

c) What is the new optimal solution with the updated model from part a?

d) What is the minimum cost of the optimal solution using the model from part a?

D H Large Capacity 81 101 130 Fixed Cost (Small) Small Fixed Cost (Large) (thousands of $) Capacity (thousands of $) 6,000 9,000 4,500 6,750 6,500 9,750 4,100 6,150 4,000 6,000 95 111 12 B F 1 Inputs - Costs, Capacities, Demands 2 Production and Transportation Cost (thousands of $) per 1,000,000 3 Supply Region N. America S. America Europe Asia Africa 4 N. America 92 115 5 S. America 117 77 108 98 100 6 Europe 102 105 119 7 Asia 115 125 90 59 8 Africa 142 100 103 105 71 9 Demand 8 14 16 10 11 Decision Variables and Constraints 12 Demand Region - Production Allocation 13 Supply Region (Capacity) N. America S. America Europe Asia Africa 14 N. America (Small) 15 S. America (Small) 16 Europe (Small) 17 Asia (Small) 18 Africa (Small) 19 N. America (Large) 20 S. America (Large) 21 Europe (Large) 22 Asia (Large) 23 Africa (Large) Demand LHS Plant Decision (1=open) Supply LHS Supply RHS or 1 1 1 COOOOOOOOOO 1 1 1 1 1 Demand RHS 12 8 14 $ 23,751 28 Objective 20 Let i = 1,2,..., 10: Index for potential plant locations/capacity levels, where: 1 represents North America (Small) 2 represents South America (Small) 3 represents Europe (Small) 4 represents Asia (Small) 5 represents Africa (Small) 6 represents North America (Large) 7 represents South America (Large) 8 represents Europe (Large) 9 represents Asia (Large) 10 represents Africa (Large) Let j = 1,2,...,5: Index for markets/demand points, where: 1 represents North America 2 represents South America 3 represents Europe 4 represents Asia 5 represents Africa Let y = 1 if plant is opened at location i, o otherwise Let Xij = quantity shipped from plantito marketi min 6000 y + 4500y2 + 6500y3 + 4100y4 + 4000ys +900076 +6750y7 +9750yg + 6150y, + 6000y10 +81x11 +92x12 + 101X13 + 130X14 + 115x15 +117x21 + 77X22 + 108x 23 +98X24 + 100x 25 +102X 31 + 105X32 +95X 33 + 119X34 + 111X35 +115x41 + 125x42 +90x 43 +59x44 + 74x 45 +142x 51 + 100X52 + 103x 53 + 105x54 + 71x 55 +81x 61 +92x62 + 101X63 + 130X64 + 115x65 +117x71 + 77X72 +108X73 +98X74 + 100x75 +102x 81 + 105 Xg2 +95x83 + 119x84 +111X85 +115x91 + 125X92 +90x93 +59X94 + 74x95 +142x10.1 + 100x10,2 + 103x10,3 + 105x10,4 + 71x10,5 s.t. X11+ X21+ X 31+ X 41+ X51+ X 61+X71+ X 81+ X91+ X10,1 = 12 X12+X 22+ X 32+ X42+ X52+ X 62+ X 71+ X82+ X92+ X 10,2 = 8 X13+X23+ X 33+ X43+X53+ X 63+ X 73+ X83+ X 93+ X10,3 = 14 X14+X24+ X 34+ X44+X54+ X 64+ X 74+ X84+ X94+ X10,4 = 16 X15+X 25+ X 35+ X45+X55+ X 65+ X 75+ X85+ X 95+ X10,5 = 7 *11+ X12+ X13+ X14+ X15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Recall the Sun Oil example from class. a ) If a plant must be built in Europe, what constraint ( s ) would you add to the model? b ) Re - run Solver with your updated model from part a . Submit your...

Recall the Sun Oil example from class. a ) If a plant must be built in Europe, what constraint ( s ) would you add to the model? c ) What is the new optimal solution with the updated model from part...

Recall the Sun Oil example from class. a ) If a plant must be built in every market, what constraint ( s ) would you add to the model? b ) Re - run Solver with your updated model from part a . Submit...

I have provided all of the information that was given to me. there is no excel sheet provided, as the question requires me to create an excel model. please help me and let me know where I can help or...

A1 - fx Inputs - Costs, Capacities, Demands B D D F G H J K N R A 1 Inputs - Costs, Capacities, Demands L L M 0 1. Using Data Analysis Solver, salve the problem to obtain Figure 5-7 2 3 Supply Rorkin...

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

FILE TOOLS VIEW 6401819_1_writing-case--4 - Word (Product Activation Failed) Financing Early Operations Musk's first entrepreneurial venture was to join up with his brother, Kimbal, and establish...

Due Sunday, 11/20: Problems from Zimmerman text: 2-11, 2-44, Case 2-3, 7-7, and 7-20 Chapter Two The Nature of Costs Chapter Outline A. Opportunity Costs 1. Characteristics of Opportunity Costs 2....

Toyota Motor Manufacturing, U.S.A., Inc. On the Friday before the running of the 118th Kentucky Derby, Doug Friesen, manager of assembly for Toyotas Georgetown, Kentucky, Plant, was approaching the...

Scenario You and your group work for a multi-national consulting firm. Your team is a group of capital budget consultants and are seeking new engagements. You intend on responding to a Request for...

General Motors has isued a zero-coupon bond. The zero-coupon bond has a price in the market today of 97.5 dollars. The zero-coupon bond pays 100 dollars in exactly one year from now. To be precise,...

Bryant Construction Company changed from the cost-recovery to the percentage-of-completion method of accounting for long-term construction contracts during 2010. For tax purposes, the company employs...

A swap is used to hedge against an unexpected change in the credit risk of a counterparty to a loan or bond. total return credit change credit default partial return

java1 Write a Java program to generate a user's daily average number of walking steps for a given month of the year. To do so, write the appropriate code for each of the following steps: a) First the...