Solve all and receive a like!

( 30 marks) A microbrewery is located in a town which has become isolated after a powerful storm. Until the bridge on the highway into town can be repaired, the supply of hops, yeast, and barley is limited to 20kg,18kg, and 19kg respectively. A linear optimization model has been made in which the variables are the number of litres of light beer, lager and ale to be made until the bridge can be repaired. The profit margins per litre for the three types of beer are $2.50 for light, $2.30 for lager, and $2.80 for ale. To make a litre of light beer requires 9 grams (g) of hops, 8g of yeast, and 6g of barley. A litre of lager requires 7g of hops, 8g of yeast, and 12g of barley. Each litre of ale requires 6g of hops, 8g of yeast, and 10g of barley. There is also an overall production constraint; using 5 units per litre of light, 8 units per litre of lager, and 4 units per litre of ale, the total cannot exceed 11,000 units. (a) Give the algebraic model for this situation. (b) Solve this model in LINGO or the Excel Solver, and obtain the sensitivity re-port. (c) Checking the allowable ranges, determine what would happen to the objective function value in each of the following situations (considered independently). (Assume that all proposed changes are feasible.) (i) The price per litre for all three types of beer rises by 16 cents. (ii) A bakery in the town has some yeast which is not needed in the short term. They are willing to sell up to 1000 grams of yeast at a price of 20 cents per gram. Should the brewery take the deal, and if so, by how much would the profit increase? (iii) Up to 300 grams of any combination of hops, yeast and barley could be dropped from a drone. What should the drone deliver? Ignoring the cost of the drone, by how much would the profit increase? (iv) Something happens to the production process which causes the cost of making light beer to increase by 35 cents per litre. Is this in the allowable range? If so, what happens to the profit? (v) The plant manager hikes in hip waders up to the main highway, and returns with 750 grams of yeast, but it is discovered that water damage from the storm has destroyed 2kg of barley. Are these two changes allowable according to the 100% rules? If so, what happens to the profit