Save & ExitNote: 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 certainbuildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that eachbuilding is cleaned. The management science department formulated the following linear programming model to help with theselection process.0:54Min 200x1 + 250x2 + 225x3 + 190x4 +215x5 + 245x6 + 235x7 + 220xgs.t x1 + x2 + x5 + x7 2 1{Ruilding 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}x1X4 + X6 2 1 {Building H constraint}x1 + x6 + xg 2 1 {Building I constraint}x1 + x2 + x7 2 1 {Building J constraint}| 1, if crewjis selectedTj =10, otherwiseSet up the problem in Excel and find the optimal solution. Which crews are selected?

Answered: Note: This problem requires the use of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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:…
Dongguk Furniture Is A Manufacturer Of Fine Hand-Crafted Furniture. During The Next Production Period, Management Is management is considering producing 3 products; dining room tables, dining room chairs, and/or bookcases. The time required for each item to go through the two stages of production (assembly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Formulate the objective functions and constraints determine the breakdown of each product and the expected profit
Fashion Fun makes 2 types of high end sneakers for toddlers, "Run-It-Out" brand and Jump-It-Out" brand. Manufacturing times for each set of sneakers is given below: Run-It-Out Jump-It-Out Total Hours Available Molding Time 2 4 39 Assembly Time 44 Accessory Time 3 34 The profit for the Run-It-Out brand is 85 per pair sold and the profit for Jump-lt-Out is $150 per pair sold FORMULATE the linear programming problem using the above data. Do NOT solve the problem. Be sure to define the decision variables, objective function, and all constraints.
Diana are currently employed as full-time supervisor at a wealth management company in Kuala Lumpur, and she want to negotiate with the head manager, Mrs. Janice to work flexible hours from home on long term bases due to her condition which have previously miscarriage for two times. She is worried about her current pregnancy which just entered the second month. She and her husband has been waiting to conceive for more than 4 years. However, Diana want to implement this flexible hour (work remotely) to everyone in the company. Diana want to work remotely because she is now having to take care of herself as according to the doctor, she is so fragile at the early of her pregnancy. She must reduce her steps to make sure no bleeding could happen. Since she was on work from home mode for the last month as she is given bed rest by the doctor, she seems to prefer working in such condition. Diana found that working remotely gave her the flexibility and was able to concentrate a lot more…
(Linear Objective Function and Optimization Application) On a special occasion, renowned electronic giant retailer Best Buy sold a variety of TVs at a discounted prices or on huge sales. Task-1: Write down an appropriate equation for the net profit function, P in order to account for the net profit made by Best Buy after selling: (i) x-number of televisions (TVs) that made $250 profit on the sale of each SONY TVs (ii) y-number of televisions that made $10,500 profit on the sale of each PHILIP TVs respectively, in that event. Task-2: Profit margin, P as discussed in Task-1 was subject to the following constraints applied to the products. a. Maximum cost price was $5000 to manufacture each piece of SONY TVs and $10,000 to manufacture each piece of PHILIP TVs respectively. All TVs were manufactured at a maximum cost of $10 x106 as given in Plot No 1: Plot No. 1: ($5000 x + $ 10000y) ≤ $10 million; Graph the Plot No. 1 up to the scale in a paper. b. 10 and 150 employees worked to…
Casper Geriatric Center, a senior medical facility located in a large hospital in New Zealand, started a procedure where their guests receive their meals in their rooms while the food is still as hot as possible. The facility will continue to prepare the food in the commissary, but will now deliver it in bulk (not individual servings) to one of three new meal serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and sections of the facility. The three new serving stations are as efficiently located as possible to reach the various hallways in the facility. The purpose of the new procedure is to increase the temperature of the hot meals that the guest receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to section. The table below summarizes the time associated with…
Chalimbana university farm is about to hire workers for its production of cabbage in a space of 5 months. as a student of farm management, you decide to increase the labour by 2 units at the first output,1 unit in the second and third output, 16 units in the fourth output and 20 units in the fifth output at each production level. The farm then realizes an output of 10,25, 65,30, and 30 in that period. The farm workers got a wage of k40 per month.a. Calculate the following at different level of output.i. marginal product, (MP) ii marginal revenue product (MRP) iii marginal resource cost (MRC)
Airline Scheduling. Alpha Airline wishes to schedule no more than one flight out of a given airport to each of the following cities: C, D, L, and N. The available departure slots are 8 a.m., 10 a.m., and 12 noon. Alpha leases the airplanes at the cost of $5000 before and including 10 a.m. and $3000 after 10 a.m., and is able to lease at most two per departure slot. Also, if a flight leaves for location N in a time slot, there must be a flight leaving for location L in the same time slot. The expected profit (in $1000) contribution before rental costs per flight is shown in the table below. Time Slot 8 10 12 C 10 6 6 D 9 10 9 L 14 11 10 N 18 15 10 a) Formulate an integer linear program model that can be used to find the profit-maximizing schedule. Define your decision variables as Xij = 1 if a flight to destination i occurs in time slot j and Xij = 0 otherwise; and Yj = number of airplanes rented for time slot j. Write the objective function and all the constraints. b)…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS