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. 

True/False: Exams are open book / open note, but you have to work alone.

(Excel) Complete the following cells C7:C11. 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 C Flow out 7 Cleveland =[C7] 8 Dallas =[C8] 9 Evansville =[C9] 10 Boston =[C10] 11 LA =[C11]

The gaseous envelope that surrounds the earth is called the

1.8. Lees die volgende stelling en bepaal die korrekte antwoord:   Die Nederlanders vestig ‘n nedersetting aan die Kaap om: 1

INSTRUKSIES   1. Die antwoorde moet jou eie, oorspronklike werk wees. Geen kopiëring van enige bron word toegelaat nie.   2. Hierdie vraestel bestaan uit AFDELING A, AFDELING B, AFDELING C en AFDELING D gebaseer op die voorgeskrewe inhoud raamwerk soos vervat in die KABV-dokument.   3. AFDELING A en B: (25 punte)    4. AFDELING Cen D: (25 punte)    5. Jy moet ALLE vrae beantwoord.   6. Wanneer jy die vrae beantwoord, moet jy jou kennis, vaardighede en insig toepas.   7. Gebruik jou eie  kennis. Jy mag nie kul en plagiaat pleeg nie .Indien daar  bewyse van sulke gevalle in jou vraestel voorkom ,sal dit lei tot ‘n punt van nul.