red brand
...putations most profitable product is paste he produces paste as much as it is demanded. To produce one case of paste 25,5 lbs of tomato is used. 81000 x 25,5 = 2065500 of paste can be sold.Remaining tomatoes will be used for juice because it gives profit.Whole tomatoes won¡¯t be produced because it gives loss. Solution with Excel: Xij =i type of tomato ,j type of product. X11+X21 X12 + X22 X13 + X23 Max: -3 ------------- + 24 --------------- + 165 -------------- 18,20 20,10 25,5 X11 + X21 9 X 11 + 5X 21 Constraints: -------------- ¡Ü 820000 ----------------- ¡Ý 8 18,20 X11 + X21 X12 + X22 9X12 + 5X22 -------------- ¡Ü 58000 ------------------- ¡Ý 6 20,10 X12 + X22 X23 + X13 9X13 + 5X23 --------------- ¡Ü 81000 ------------------ ¡Ý 5 25,5 X13 + X23 X11 +X12 +X13 ¡Ü 600000 X21 +X22 +X23 ¡Ü 2400000 X11 ,X12 ,X13 ,X21 ,X22 ,X23 ¡Ý 0 4)Formulate as an LP the problem of determining the optimal canning policy for this season¡¯s crop. Solution: Xij = i refers to type of tomato ,j refers to type of product. X11+X21 X12 + X22 X13 + X23 Max: -3 ------------- + 24 --------------- + 165 -------------- 18,20 20,10 25,5 X11 + X21 9 X 11 + 5X 21 Constraints: -------------- ¡Ü 820000 ----------------- ¡Ý 8 18,20 X11 + X21 X12 + X22 9X12 + 5X22 -------------- ¡Ü 58000 ------------------- ¡Ý 6 20,10 X12 + X22 X23 + X13 9X13 + 5X23 --------------- ¡Ü 81000 ------------------ ¡Ý 5 25,5 X13 + X23 X11 +X12 +X13 ¡Ü 600000 X21 +X22 +X23 ¡Ü 2400000 X11 ,X12 ,X13 ,X21 ,X22 ,X23 ¡Ý 0 Solution with Excel: 5)How should model be modified to include the possibility of additional purchases suggested by Gordon? Solution: Xij = i refers to type of tomato ,j refers to type of product. X11+X21 + X31 X12 + X22 + X32 X13 + X23 +X33 Max: -3 ---------------------- + 24---------------------- + 165 ------------------ -7,5(X31+X32+X33) 18,20 20,10 25,5 X11 + X21 +X31 9 X 11 + 5X 21+X31 Constraints: ------------------- ¡Ü 820000 -------------------------- ¡Ý 8 18,20 X11 + X21 +X31 X12 + X22 +X32 9X12 + 5X22 + X32 -------------------- ¡Ü 58000 -------------------------- ¡Ý 6 20,10 X12 + X22 + X32 X23 + X13 +X33 9X13 + 5X23 +X33 ---------------------- ¡Ü 81000 -------------------------- ¡Ý 5 25,5 X13 + X23 +X33 X11 +X12 +X13 ¡Ü 600000 X21 +X22 +X23 ¡Ü 2400000 X31 + X32 + X33 ¡Ü 80000 X11 ,X12 ,X13 ,X21 ,X22 ,X23 ,X31 ,X32 ,X33 ¡Ý 0 Solution with Excel: 6)What is the maximum pounds of canned whole tomatoes ?Can Cooper¡¯s suggestion be implemented? Solution: As Grade ¡®C¡¯ tomatoes rated as 3 we can¡¯t use ¡®C¡¯ tomatoes for whole tomatoes.As much as we use ¡®C¡¯ tomatoes ,we must use less ¡®C¡¯ tomatoes to reach quality standards needed. X11 + X12 +X13 Max: ---------------------------- 18,2 Constraints: 9X11 + 5X12 + 3X13 ------------------------------------- ¡Ý 8 X11+X12 +X13 X11 ¡Ü 600000 X12 ¡Ü 1200000 X13 ¡Ü 800000 Xij ¡Ý 0 Solution with Excel : 7) How does Myers compute his tomato costs according to marginal cost? How does he reach his conclusion that the company should use 800000lbs of Grade ¡®C¡¯ and 1200000lbs of Grade ¡®B¡¯ tomatoes for paste ,and rest of the tomatoes for juice?What is wrong with Myers suggestion? Solution:He again computes the costs according to quality standards.He formulize it as Z Y X ---- = ---- = ----- 9 6 ...