Variable Cells Name Sandwich Regular Sandwich Hamster Sandwich Breadtastic Final Reduced Value Cost 10 0 8 0 -2.533333333 Objective Allowable Allowable Coefficient Increase Decrease 1.7 0.292307692 0.1 2 0.125 0.271428571 1.4 2.533333333 1E+30 Constraints Name Butter Ingredients used Bread Ingredients used Ham Ingredients used Final Shadow Value Price 270 0.033333333 800 0.03 520 0 Constraint R.H. Side 270 800 680 Allowable Increase 30 80 1E+30 Allowable Decrease 30 80 160 1- Determine the optimal values for each decision variable and the value of the objective function (15 marks) 2- Identify the binding constraints (10 marks) 3- Determine the range in values for the price of the Hamster (to the nearest cent) that would not affect the optimal production mix. (10 marks) 4- How many grams of ham will be left over if the optimal quantity of each product is produced? (20 marks) 5. If Anne can purchase 50 extra grams of bread for 2 cents per gram, will that help or hurt her profit, and if so by how much? Explain (25 marks)