Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / Question ZTVRTRS): A company which makes chocolate bars needs to buy some exotic nuts: wal...

Question ZTVRTRS): A company which makes chocolate bars needs to buy some exotic nuts: walnuts, chestnuts, and hazelnuts. They do not have to buy any of any one type, but they do need to satisfy

Question ZTVRTRS): A company which makes chocolate bars needs to buy some exotic nuts: walnuts, chestnuts, and hazelnuts. They do not have to buy any of any one type, but they do need to satisfy certain combinations of types, which has been modelled using three constraints. Also, there is a capacity restriction. The model has been formulated as: Let X1, X2, and X3 represent respectively the number of kilograms of walnuts, chestnuts, and hazelnuts to be used each hour in the chocolate bar plant. 2X1 + 7X2 + 4x3 minimize subject to Combination 1 Combination 2 Combination 3 Capacity non-negativity 5X1 + 8X2 +6X3 230 2X1 + X2 + 4X3 145 3X1 + 4X2 + 5X3 196 8X1 +9X2 + 4X3 S252 X1, X2.X320 (a) Solve using a spreadsheet Solver, and create the Answer and Sensitivity Reports. (2 marks) (b) State the solution in words, and indicate which constraints are binding, (1 mark) (© By using the information from the Sensitivity Report (NOT by re-running the model each time), give the predicted change to the objective function value and the reasoning behind your answer) for the following situations (where each situation is independent of the others). If the OFV cannot be predicted exactly, then give an answer such as the OFV will decrease by at least $50"

Apr 14 2021 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions