Question: ( PLEASE SHOW THROUGH EXCEL ) Modify the original Grand Prix example as follows. Increase the demands at the regions by 2 0 0 each,

(

PLEASE SHOW THROUGH EXCEL

)

Modify the original Grand Prix example as follows. Increase the demands at the regions by

200

each, so that total demand is well above total plant capacity. This means that some demands cannot be supplied. Suppose there is a unit penalty cost at each region for not supplying an automobile. Let these unit penalty costs be $

600,

750,

625,

and $

550

for the four regions. Develop a model to minimize the sum of shipping costs and penalty costs for unsatisfied demands.

(

Hint: This requires a trick. Introduce a fourth plant with plenty of capacity, and set its

unit shipping costs

to the regions equal to the unit penalty costs. Then interpret an auto shipped from this fictitious plant to a region as a unit of demand not satisfied.

)

(PLEASE SHOW THROUGH EXCEL) Modify the original Grand Prix example as

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 General Management Questions!

Modify the original Grand Prix example as follows. Increase the demands at the regions by 2 0 0 each, so that total demand is well above total plant capacity. This means that some demands cannot be...

Modify the original Grand Prix example as follows. Increase the demands at the regions by 200 each, so that total demand is well above total plant capacity. This means that some demands cannot be...

QUESTIONS 120 Question 2. Use the file finalexam q2.xlsx. The Grand Prix Automobile Company manufactures cars in three plants and then ships them to four regions of the country The plants can supply...

Modify the original Grand Prix example as follows. Increase the demands at the regions by 2 0 0 each, so that total demand is well above total plant capacity. However, now interpret these demands as...

Modify the original Grand Prix example as follows. Increase the demands at the regions by 200 each, so that total demand is well above total plant capacity. However, now interpret these demands as...

The Grand Prix Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The plants can supply the amounts listed in the right column of the...

Modify the original Grand Prix example by increasing the demand at each region by 200, so that total demand is well above total plant capacity. This means that some demands cannot be supplied....

Modify the original Grand Prix example by increasing the demand at each regions by 200, so that total demand is well above total plant capacity. However, now interpret these demands as maximum sales,...

#2 & #4 D GINCS une question of how any biles each region can really sell. It might be more realistic to keep the lower bow sales (the current demand constraints) but to impose upper limits on sales...

In the original Grand Prix example, the total capacity of the three plants is 1 5 5 0 , well above the total customer demand. Would it help to have 1 0 0 more units of capacity at plant 1 ? What is...

Q.15 A complex is comlposed of one chromium, three bromides and six water molecules. Upon addition of excess AgNO3, 1.0g aqueous solution of a complex gave 0.94g of AgBr. The molecular formula of...

Identify the factors that are relevant in determining the annual depreciation charge, and explain whether these factors are determined objectively or whether they are based on judgment.

When completing progress, know which of the following should you do . Write in subjective terms what the client reports. Sign the note with your credentials. Show support of your observations. D ....

-/1 View Policies Current Attempt in Progress The following amortization and interest schedule reflects the issuance of 10-year bonds by Bridgeport Corporation on January 1, 2014, and the subsequent...