Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver. The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection proces. 54 Min 200x1 + 250x2 + 225x3 + 190x4 +215x5 + 245x6 + 235x7 + 220xg s.t. x1 + x2 + x5 + x7 2 1Ruilding A constraint) x1 + x2 + x3 2 1{Building B constraint) X6 + x8 2 1 (Building C constraint) x1 + x4 + x7 2 1 {Building D constraint} x2 + x7 2 1{Building E constraint) x3 + x8 2 1 {Building F constraint) x2 + x5 + X7 2 1 (Building G constraint} X1 + X4 + X6 2 1 (Building H constraint) x1 + x6 + xg 2 1 (Building I constraint} x1 + x2 + x7 2 1 (Building J constraint} S 1, if crew jis selected 10, otherwise Ij = Set up the problem in Excel and find the optimal solution. Which crews are selected?

SCM1012 – SCM Quantitative Techniques Assignment #1     The following table summarizes the key facts about two products, A and B, and the resources, Q, R, and S, required to produce them.   Product A Product B Unit Profit $3,000 $2,000   Resource Usage per Unit Produced   Product A Product B Amount of Resource Available Resource Q 2 1 2 Resource R 1 2 2 Resource S 3 3 4       All the assumptions of linear programming hold. Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver. Determine units to produce of each unit. Note: Round your answers to 3 decimal places. Determine the total profit. Note: Round your answer to 2 decimal places.

An IE graduate student named Vladimir will soon purchase a new top of the line Apple iPhone or Samsung Galaxy. He bases his choice on the three factors: cost C, ease of use E, and features F. He assigns weights of 0.40 to C, 0.30 to E, and 0.30 to F. For C, he assigns weights of 0.40 to iPhone and 0.60 to Galaxy. For E, he also assigns weights of 0.40 to iPhone and 0.60 to Galaxy. For F, he assigns weights of 0.70 to iPhone and 0.30 to Galaxy. Use these weights in a value tree and determine which phone Vladimir should buy and the corresponding overall weight for the chosen phone. iPhone, 0.53 O Galaxy, 0.51 O iPhone, 0.51 O Galaxy, 0.49 « Previous Next> Simpfun

The Bayside Art Gallery is considering installing a video camera security system to reduce its insurance premiums. A diagram of the eight display rooms that Bayside uses for exhibitions is shown in the figure below; the openings between the rooms are numbered 1 through 13. A blueprint of a gallery with eight rooms, one entrance and thirteen doorways is shown. The gallery is laid out in a grid of three columns and four rows. Some rooms take up more than one row. The left-hand side contains rooms 1 and 2, the middle column rooms 3, 4, 5, and 6, and the right-hand side rooms 7 and 8. The following list contains each doorway and the rooms it connects. Entrance: Room 1 Opening 1: Rooms 1 and 3 Opening 2: Rooms 3 and 7 Opening 3: Rooms 3 and 4 Opening 4: Rooms 1 and 4 Opening 5: Rooms 4 and 7 Opening 6: Rooms 1 and 2 Opening 7: Rooms 4 and 5 Opening 8: Rooms 2 and 5 Opening 9: Rooms 5 and 7 Opening 10: Rooms 5 and 6 Opening 11: Rooms 7 and 8 Opening 12: Rooms 2 and 6 Opening 13:…