[Part 3] A snack company packages and sells three different 1-pound canned party mixes: Plain Nuts, Mixed Nuts, and Premium Mix. Plain Nuts sells for $2.25 per can, Mixed Nuts sells of $3.37, and Premium Nuts sells for $6.49 per can. A can of Plain Nuts contains 0.8-pound peanuts and 0.2-pound cashews. A can of Mixed Nuts consists of 0.5 pound peanuts, 0.3 pound cashews, 0.1 pound almonds, and 0.1 pound walnuts. A can of Premium Nuts is made up of 0.3-pound cashews, 0.3-pound almonds, and 0.4-pound walnuts. The company has on hand 600 pounds of peanuts, 300 pounds of cashews, 100 pounds of almonds, and 80 pounds of walnuts.  Use the following notations X1: the number of plain nuts X2: the number of mix nuts X3: the number of premium nuts. 

[Part1] Which of the following variables is considered random?

(Part Assignment) Complete the cells B6:D6, which are related to the net flow equation. Use the relative cell reference (No $). No space in the formula.  B C D 6 =[B6] =[C6] =[D6]

[Part2] In Table 1, which cell(s) are the Changing Cells as designated by “Solver”?

Which of the following statements concerning the transshipment model is FALSE?

[Part2] What is the value of the objective function at (X1, X2)=(8, 2)?

Non-negativity: X1, X2, X3 >=0

[Part3] The constraint for cashews

[Part 3] The objective function (in terms of X1, X2, and X3)

[Part2] In Table 1, what cell reference designates the Target Cell in “Solver”?