Question: Use LINGO ONLY, give code and list variables. Excel and any other response will be downvoted. (20 marks) Before the COVID-19 pandemic, a slaughterhouse in
Use LINGO ONLY, give code and list variables. Excel and any other response will be downvoted.

(20 marks) Before the COVID-19 pandemic, a slaughterhouse in Alberta would operate one shift per day with a 10,000kg of product (meat) per shift capacity. Now, because of the need for physical distancing, they can process only 4000kg of product per shift, so they are considering operating on two shifts or even three shifts per day. They buy the cattle from nearby farms in Alberta for only $0.80 per kg of animal, but only 40% of each animal is meat, making the effective cost $0.800.4=$2.00 per kg of meat. The supply per day at this price is limited to 20,000kg of animal, or 8000kg of meat. However, there is another 5000kg of animal available per day from further away, but this would cost $1.00 per kg of animal because of the extra costs of shipping. There is annual $1,500,000 fixed cost of operating the first shift regardless of the level of production. There is also a variable cost of $1.20 per kg of product on shift 1. If shift 2 operates (which can only happen if shift 1 operates), there would be a fixed cost of $500,000, and a variable cost of $1.40 per kg of product. If shift 3 operates (which can only happen if shift 2 operates), there would be a annual fixed cost of $500,000, and a variable cost of $1.60 per kg of product. The annual fixed costs can be pro-rated over 250 working-days per year in order to perform a daily analysis. If a shift operates at all, then the minimum amount processed is 2000kg of product on that shift (i.e. the amount processed on any shift is either 0 or greater than or equal to 2000kg ). The company sells processed meat at a variety of prices, depending on the quality, but for the purpose of this analysis we can assume an average price of $5.00 per kg. They wish to know what they should do to maximize their daily profit. (a) Pre-pandemic, what would the daily profit have been if they operated shift 1 at the 10,000kg of product capacity? (b) Follow page I part (d). (c) Solve the model, and state the solution in words
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
