(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

4. Please find the optimal corner point and the maximum value of the objective function

(Excel) Complete the following cell F5. Use the relative cell reference (No $). No space in the formula.  E F 5 Total Cost = [F5]

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

Write all constraints (in terms of F, P1, P2, P3, and P4).  F, P1, P2, P3, P4 >=0

The Executive Furniture Company manufactures office desks at three locations: Cleveland, Dallas, and Evansville. The firm distributes the desks through regional warehouses located in Boston, and LA. Estimates of the monthly supplies available at each factory and the monthly desk demands at each of the two warehouses are shown in the below figure. The firm has found that production costs per desk are identical at each factory, and hence the only relevant costs are those of shipping from each factory to each warehouse. These costs, shown in the below table, are assumed to be constant, regardless of the volume shipped. The transportation problem can now be described as determining the number of desks to be shipped on each route so as to minimize total transportation costs. From To Boston LA Cleveland $5 $4 Dallas $8 $10 Evansville $9 $11 Notation: Xij = number of desks shipped from factory i to warehouse j, where i=C (for Cleveland), D (for Dallas), or E (for Evansville) j=B (for Boston) or L (for LA).  For example, XCL is the number of desks shipped from Cleveland to LA.