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.

Use LINGO ONLY, give code and list variables. Excel and any other

(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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!