5) Screen 2018-12 Screen 2019-11 A food processor operates two tomato-canning plants, A and B. Growers from three cooperatives supply fresh tomatoes to the canning plants. Co-op 1 can supply up to 200 tons per week at $15/ton; Co-op 2 up to 320 tons at $13/ton; and Co-op 3 up to 420 tons at $18/ton. Plant A can process up to 460 tons of fresh tomatoes at $30/ton and Plant B up to 400 tons at $21/ton. The cost of shipping fresh tomatoes from each of the co-ops to each of the canning plants, which must be borne by processor, are: Plant A Plant B Co-op 1 $3/ton SS/ton Co-op 2 $2/ton Stron Co-op 3 S4/on $4/ton The processor can sell all the canned tomatoes it can produce to distributors at $300/ton. The processor needs to determine the quantities of fresh tomatoes to purchase from each of the three co-ops and how to distribute them between its two plants in order to maximize profits a) Formulate the processor's profit maximization problem. Be sure to clearly specify the decision variables, objective function, and constraints, b) Solve the processor's profit maximization problem in Excel. What is the processor's optimal purchase, distribution, and processing plan and maximum profit? c) If the processor could expand processing capacity by 50 tons per week at one, but not both of its two processing plants at the same cost, which one would it choose? Why? ser 2010-11 PM Sen she M. 2010-11-03 Screen Shot 2019-11...5.24 5) Screen 2018-12 Screen 2019-11 A food processor operates two tomato-canning plants, A and B. Growers from three cooperatives supply fresh tomatoes to the canning plants. Co-op 1 can supply up to 200 tons per week at $15/ton; Co-op 2 up to 320 tons at $13/ton; and Co-op 3 up to 420 tons at $18/ton. Plant A can process up to 460 tons of fresh tomatoes at $30/ton and Plant B up to 400 tons at $21/ton. The cost of shipping fresh tomatoes from each of the co-ops to each of the canning plants, which must be borne by processor, are: Plant A Plant B Co-op 1 $3/ton SS/ton Co-op 2 $2/ton Stron Co-op 3 S4/on $4/ton The processor can sell all the canned tomatoes it can produce to distributors at $300/ton. The processor needs to determine the quantities of fresh tomatoes to purchase from each of the three co-ops and how to distribute them between its two plants in order to maximize profits a) Formulate the processor's profit maximization problem. Be sure to clearly specify the decision variables, objective function, and constraints, b) Solve the processor's profit maximization problem in Excel. What is the processor's optimal purchase, distribution, and processing plan and maximum profit? c) If the processor could expand processing capacity by 50 tons per week at one, but not both of its two processing plants at the same cost, which one would it choose? Why? ser 2010-11 PM Sen she M. 2010-11-03 Screen Shot 2019-11...5.24