[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?

To solve the problem by using the solver, we need to input some numbers, cells, and formulas. Answer the following questions. Note: Cells B2:C4 are the designated cells for the optimal values of the decision variables, respectively, while cell F5 is the designated cell for the objective function value. This is an example of how to answer the following questions.  Complete the following cells, which are related to the transportation cost (F2:G4) and Netflow (D7:D11). F2:  5 D7: =B7-C7 F3:  8 D8: =B8-C8 F4:  9 D9: =B9-C9 G2:  4 D10: =B10-C10 G3:  10 D11: =B11-C11 G4:  11