[Part3] The constraint for peanuts

[Part1] Acquiring input data is part of:

[Part1] Which of the following variables is considered non-random or deterministic?

[Part2] The below Excel spreadsheet is used to model the following linear programming problem: Table 1 for Part 2 A B C D E F 2 X1 X2 Objective function value 3 Number of Make 4 5 Unit Profit $5 $4 6 7 Constraints Used Sign Available 8 (1) 9 (2) 1 1

[Part1] This linear programming model has __________________________. 

[Part2] In Table 1, what formula should be entered in cell D9 for constraint (2)?

(Excel) Complete the following cells B7:B11.  Use the relative cell reference (No $). Do not leave blank. For example, if the answer is zero, you SHOULD write 0 instead of “blank”. A B 6 Flow in 7 Cleveland =[B7] 8 Dallas =[B8] 9 Evansville =[B9] 10 Boston =[B10] 11 LA =[B11]

3. [4pts] Draw the feasible region (You should upload your figure after this quiz). After you submit your quiz, you should submit your graph in the Assignment within 30 minutes. 1. Take a picture of your drawing.  2. Upload your picture in the Assignment (name: Quiz 1, Question 3)

(Excel) Complete the following cells D2:D4, related to the flow-out of the net flow equation.  Use the relative cell reference (No $). No space in the formula.  A D 2 Cleveland = [D2] 3 Dallas = [D3] 4 Evansville = [D4]

[Part1] This linear programming model violates which of the following assumptions?