Please show how to do this problem in Excel solver. please show part b. in detailed solution. all steps to solve it in EXCEL SOLVER.

6.6.6 Fish Plant Production Quant isher 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 Fixed Cost |Variable Cost Annual Capacity Shift Per Annum Per Kilogram 1$500,000 2 $300,000 3 $100,000 $0.50 $0.70 $0.95 (Tonnes) 1700 1500 1300 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) they should do to maximize their annual profit. (a) Formulate this problem (b) Solve it using the Excel Solver. Quantfisher can sell processed fish for $1.80 per kg. They wish to know what