This question is about Exercise 2.10 of the textbook. The Excel file 208h2 Q1.xlsx contains a model that could have been rushed by a student; the Solver states the model has no feasible solution. This work is a disaster: there are modelling errors (due to misunderstanding the problem), implementation errors (bugs), implementation choices that are correct but inappropriate, no explanation of the model. I am asking you to read carefully the text of the problem, review this model, try to understand it (this is far from easy) and describe clearly all the errors and poor choices that you find, justifying clearly each of your claims. Then write a correct and well explained model for this problem
Excel FIle:
Page 2
Question from textbook 2.10:
Scheduling Tire Production Parameters 4.555.56 Decisions \begin{tabular}{|r|r|r|r|r|r|} \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline \end{tabular} Objective 000000000000000000 Constraints 000000000000>=>=>=>=>=>=>=>=>=>=>=>=80007000600018000160001800040001000515000600050008000 2.10. Cargo Loading You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freight ship bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship. 64 Chapter 2 Linear Programming: Allocation, Covering, and Blending Models You can elect to load any and/or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions. More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold must be between 40 percent and 60 percent of the total weight on board. (a) What is the maximum profit and the loading plan that achieves it? What is the optimal total weight to be loaded? What is the optimal total volume to be loaded? (b) Suppose each one of the cargo holds could be expanded. Which holds and which forms of expansion (weight or volume) would allow ICC to increase its profits on this trip, and what is the marginal value of each form of expansion? Scheduling Tire Production Parameters 4.555.56 Decisions \begin{tabular}{|r|r|r|r|r|r|} \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \\ \hline \end{tabular} Objective 000000000000000000 Constraints 000000000000>=>=>=>=>=>=>=>=>=>=>=>=80007000600018000160001800040001000515000600050008000 2.10. Cargo Loading You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freight ship bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship. 64 Chapter 2 Linear Programming: Allocation, Covering, and Blending Models You can elect to load any and/or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions. More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold must be between 40 percent and 60 percent of the total weight on board. (a) What is the maximum profit and the loading plan that achieves it? What is the optimal total weight to be loaded? What is the optimal total volume to be loaded? (b) Suppose each one of the cargo holds could be expanded. Which holds and which forms of expansion (weight or volume) would allow ICC to increase its profits on this trip, and what is the marginal value of each form of expansion
