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…
7
(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…
A linear programming computer package is needed. The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown. Model Men's Women's Production Costs men's model in month 1 women's model in month 1 $120 men's model in month 2 $90 Labor Requirements (hours) Assembly Manufacturing 2.0 1.6 bicycles 1.5 Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges…
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