(a) Formulate this problem.

(b) Solve it using the Excel Solver.

6.6.6 Fish Plant Production Quantfisher Inc. buys fresh fish for processing. Quantfisher has an annual contract with its supplier to buy up to 4600 Tonnes at the following set of incremental prices: First 1000 Tonnes (or any fraction) may be purchased @ $0.80/kg. Next 2000 Tonnes (or any fraction) may be purchased @ $1.00/kg. Next 1600 Tonnes (or any fraction) may be purchased @ $1.20/kg. Quantfisher's fish processing plant can operate on a one, two, or three shift per day basis. (Shift two operates only if shift one operates, and shift three operates only if shift two operates.) For each shift there is a fixed cost which exists if the shift operates, but is nil otherwise, and a variable cost per kilogram of fish processed. The costs and shift capacities are: Shift Fixed Cost Per Annum $500,000 $300,000 $100,000 Variable Cost Per Kilogram $0.50 $0.70 $0.95 Annual Capacity (Tonnes) 1700 1500 1300 2 3 If a shift operates at all, then the minimum amount processed is 1000 Tonnes per annum on that shift (i.e. the amount processed on any shift is either 0 or greater than or equal to 1000 Tonnes). Quantfisher can sell processed fish for $1.80 per kg. They wish to know what they should do to maximize their annual profit. 6.6.6 Fish Plant Production Quantfisher Inc. buys fresh fish for processing. Quantfisher has an annual contract with its supplier to buy up to 4600 Tonnes at the following set of incremental prices: First 1000 Tonnes (or any fraction) may be purchased @ $0.80/kg. Next 2000 Tonnes (or any fraction) may be purchased @ $1.00/kg. Next 1600 Tonnes (or any fraction) may be purchased @ $1.20/kg. Quantfisher's fish processing plant can operate on a one, two, or three shift per day basis. (Shift two operates only if shift one operates, and shift three operates only if shift two operates.) For each shift there is a fixed cost which exists if the shift operates, but is nil otherwise, and a variable cost per kilogram of fish processed. The costs and shift capacities are: Shift Fixed Cost Per Annum $500,000 $300,000 $100,000 Variable Cost Per Kilogram $0.50 $0.70 $0.95 Annual Capacity (Tonnes) 1700 1500 1300 2 3 If a shift operates at all, then the minimum amount processed is 1000 Tonnes per annum on that shift (i.e. the amount processed on any shift is either 0 or greater than or equal to 1000 Tonnes). Quantfisher can sell processed fish for $1.80 per kg. They wish to know what they should do to maximize their annual profit