Tuckered Outfitters Ingredients Chocolate Peanuts 5% Min 50% Max Raisins Grain Almonds Total Desired 2 Amount (lbs) Cost/ lb $2.50 $1.50 $2.00 $3.50 $3.00 Total Amount per lb Vitamins (grams) Minerals (grams) Protein (grams) Calories Raisins 20 7 Grain 10 4 2 160 Chocolate 10 5 1 500 Peanuts 30 9 10 300 Almonds 20 3 Required 40 15 10 600 450 500 Hints: this problem is laid out in similar fashion to the blending problem in Section 3.12 of the textbook. It's just a single product but with several quality requirements as in that example. Remember, do not divide, which in this case pertains to incorporating the % requirements in the last sentence of the word problem. We'll revisit that idea on Tuesday. Also on Tuesday, we'll see that you can create a constraint to compare a block of cells on the left to a single value on the right. For example, the author usually explicitly puts in non-negativity constraints (rather than simply checking that box) of the form [variable list] >= 0. In this homework you can do the same, but instead of a 0 an item weight based those % requirements. There's no need to enter separate constraints one at a time. Notes: Problems appear at the end of the chapter. Spreadsheet Shells are attached via hyperlink. For all problems, skip the algebraic formulation of part (a) and simply formulate an Excel spreadsheet model as directed in part (b), indicating your solution and total cost (of part (c)) therein. Submit completed file(s) (via the button above) before the deadline. Tuckered Outfitters Ingredients Chocolate Peanuts 5% Min 50% Max Raisins Grain Almonds Total Desired 2 Amount (lbs) Cost/ lb $2.50 $1.50 $2.00 $3.50 $3.00 Total Amount per lb Vitamins (grams) Minerals (grams) Protein (grams) Calories Raisins 20 7 Grain 10 4 2 160 Chocolate 10 5 1 500 Peanuts 30 9 10 300 Almonds 20 3 Required 40 15 10 600 450 500 Hints: this problem is laid out in similar fashion to the blending problem in Section 3.12 of the textbook. It's just a single product but with several quality requirements as in that example. Remember, do not divide, which in this case pertains to incorporating the % requirements in the last sentence of the word problem. We'll revisit that idea on Tuesday. Also on Tuesday, we'll see that you can create a constraint to compare a block of cells on the left to a single value on the right. For example, the author usually explicitly puts in non-negativity constraints (rather than simply checking that box) of the form [variable list] >= 0. In this homework you can do the same, but instead of a 0 an item weight based those % requirements. There's no need to enter separate constraints one at a time. Notes: Problems appear at the end of the chapter. Spreadsheet Shells are attached via hyperlink. For all problems, skip the algebraic formulation of part (a) and simply formulate an Excel spreadsheet model as directed in part (b), indicating your solution and total cost (of part (c)) therein. Submit completed file(s) (via the button above) before the deadline
