INTRODUCTION TO OPERATIONS RESEARCH QUESTION Person A is planning to organize a party with his friends. Since they have a tight budget,Person A has assigned specific tasks (related to renting party equipment) to his friendsPerson B, Person C, Person D and Person E. Person B and Person D were unable to getquotations for the confetti cannon and bubble machine respectively. The table below showsthe quotations (in USD) each friend has obtained for each item.Bouncy Castle Helium Tank Confetti Cannon Bubble MachinePerson B500500200Person C700400200300Person D900300500Person E700200600700Help Person A decide which of his friends should rent which equipment, and how much it willcost. Person A is only interested in the optimal combination.

Find the Given details below: Given details: Bouncy Castle Helium Tank Confetti Cannon Bubble…

Answered: Person A is planning to organize a…

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

INTRODUCTION TO OPERATIONS RESEARCH QUESTION

Person A is planning to organize a party with his friends. Since they have a tight budget,
Person A has assigned specific tasks (related to renting party equipment) to his friends
Person B, Person C, Person D and Person E. Person B and Person D were unable to get
quotations for the confetti cannon and bubble machine respectively. The table below shows
the quotations (in USD) each friend has obtained for each item.
Bouncy Castle Helium Tank Confetti Cannon Bubble Machine
Person B
500
500
200
Person C
700
400
200
300
Person D
900
300
500
Person E
700
200
600
700
Help Person A decide which of his friends should rent which equipment, and how much it will
cost. Person A is only interested in the optimal combination.

Expert Solution

Step by step

Solved in 2 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Fowle Marketing Research, Inc. is faced with the problem of assigning three available project leaders (agents) to each of three new research studies (tasks). Fowle’s management realizes, however, that the time required to complete each study will depend on the experience and ability of the project leader assigned to the study. Since the three studies have been judged to have approximately the same priority, the company would like to determine the assignments that will minimize the total number of days required to complete all three. If a project leader is to be assigned to one and only one client, what assignments should be made (optimal solutions)? How many days are required (objective function value).With three project leaders and three clients, there are total of nine possible assignment alternatives. The alternatives and the estimated project completion times in days are summarized in Table Client Project Leader 1 2…
Two law students, John and Marsha, are planning an all-nighter to prepare for theirlaw boards the following day. Between them they have one set of materials in thefollowing five subjects: contracts, torts, civil law, corporate law, and patents.Based on their previous experience, they estimate that they will need the following amount of time (in hours) with each set of materials:Contracts Torts Civil Corporate PatentsJohn 1.2 2.2 0.7 0.5 1.5Marsha 1.8 0.8 3.1 1.1 2.3They agree that Marsha will get the opportunity to see each set of notes beforeJohn. Assume that they start their studying at 8:00 P.M. Determine the exact timesthat each will begin and end studying each subject in order to minimize the totaltime required for both to complete studying all five subjects
A consulting firm has four projects to consider. Each project will require time (in days) in the next three months according to the table below. Project Time in first month Time in second month Time in third month Revenue A 6 8 6 22000 B 5 6 8 18000 C 8 7 6 16000 D 5 5 4 15000 Revenue from each project is also shown. There is 20 days’ time available in the first month, 22 days’ time available in the second month, and 22 days’ time available in the third month to do these projects. The management wants to select at most 3 projects. If project B is selected, then project C must also be selected. The objective of the firm is to maximize the total revenue. Formulate an integer optimization model for this problem by defining the decision variables, the objective function and all the constraints.…
What is true about the assignment problem if the solution has reached the table below? Project A Project B Project C Project D Expert W 0 100 200 0 Expert X 0 0 200 300 Expert Y 0 100 300 0 Expert Z 200 100 0 0 a. The minimum number of vertical and horizontal lines needed to cross out 0s is three. b. Optimal assignment of projects cannot be determined yet. c. Optimal assignment of projects can now be determined.
What is the minimum cost of crashing the following project that James Walters manages at Athabasca University by 4 days Activity Normal Time (days) Crash Time (days) Normal Cost Crash Cost Immediate Predecessor(s) A 5 4 $800 $1,000 — B 8 6 $200 $600 — C 5 4 $600 $650 — D 7 4 $750 $1,500 A E 6 4 $1,200 $1,650 C A. By how many days should each activity be crashed to reduce the project completion time by 4 days? Fill in the table below. (Enter your responses as whole numbers.) Activity Each Activity Should be Reduced BY (days) A 1 B 0 C 1 D 3 E 2 B. The total cost of crashing the project by 4 days is _____ (Enter your response as a whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You…
Troy and Tristan have decided to open a competitive Cheer and Dance business. Troy’s expertise is in business. He has a degree in Business Administration with a minor in Underwater Basket Weaving. Tristan, on the other hand, has a degree in Sports Management and has been coaching the Tesoro cheerleading team, while his girlfriend, Beatrix, has been coaching the dance team. The problem is that no one has much capital to invest. In fact, both are having a little trouble figuring out how they will be able to get the startup capital for the business. Fortunately, there are no other competitive Cheer and Dance companies in the area. Unfortunately, the potential buildings they have found to lease costs over $7,000 per month and they expect that utilities and water will cost approximately $650 per month. Liability insurance is expensive as well, estimated to be $2,000 per month due to possible injuries. What type of business organization should Troy ad Tristan adopt?
Saad has been a manager at Revel Consulting for the past five years. As the business has grown, Saad has taken on more and more responsibilities and is now at the point where he is working on over 10 projects every quarter. Saad’s supervisor, Vance, wants Saad to hire two assistant managers to aid Saad in managing projects; however, while Saad agrees that he is becoming overwhelmed, he fears that additional employees will make completing the projects more difficult, which makes him hesitant to agree with Vance’s plan. Saad appears to be stuck at which step of the motivational process? a. Need b. Motive c. Satisfaction or dissatisfaction d. Feedback 4.Which theory holds that needs are based on personality and are developed and learned as people interact with the environment? a. Acquired needs theory b. Hierarchy of needs theory
Daniel needs to assign his mechanics to four pending jobs. The table below shows how much time (in minutes) it takes each mechanic to perform each job. Help Daniel determine the optimal assignments. In the optimal solution, who should be assigned to work on Job 4?
During 2019, Susan incurred and paid the following expenses for Beth (her daughter), Ed (her father), and herself:Surgery for Beth $4,500Red River Academy charges for Beth:Tuition 5,100Room, board, and other expenses 4,800Psychiatric treatment 5,100Doctor bills for Ed 2,200Prescription drugs for Susan, Beth, and Ed 780Insulin for Ed 540Nonprescription drugs for Susan, Beth, and Ed 570Charges at Heartland Nursing Home for Ed:Medical care 5,000Lodging 2,700Meals 2,650 Beth qualifies as Susan’s dependent, and Ed would also qualify except that hereceives $7,400 of taxable retirement benefits from his former employer. Beth’s…
Consider a small Oil production firm with 5 competing oil production projects, A - E. The table below shows the estimated long-term profit (Net Present Value) for each project as well as the amount of investment capital required to start the project. You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million. Production Project A B C D E Estimated Profit (millions) 25 20 19 28 21 Capital Required (millions) 11 8 14 19 13 Formulate a Binary Integer Programming (BIP) model on a spreadsheet. Solver the model using Solver.
A health Centre will be built to serve 7 communities. The geographical location of the communities and their population is shown in the table below. Communities A, X =2.5 (km), Y=4.5(km), Population( 000's)=2 Communities B, X =2.5 (km), Y=2.5(km), Population( 000's)=5 Communities C, X =5.5 (km), Y=4.5(km), Population( 000's)=10 Communities D, X =5 (km), Y=2(km), Population( 000's)=7 Communities E, X =8 (km), Y=5(km), Population( 000's)=10 Communities F, X =7 (km), Y=2(km), Population( 000's)=20 Communities G, X =9 (km), Y=2.5(km), Population( 000's)=14 There is a possibility of building the Centre in two communities, community C and F. Based on the Demand-Distance criterion what is your recommendation for the site of the Centre. The distances to be measured based on Rectilinear method. Based on…
Four jobs are to be assigned to employees. There are 5 available employees. Durations for each job/employee combination are given in the following table. Build an assignment model to minimize the total time. What is the minimum optimal time? Employees Jobs 1 2 3 4 5 A 15 20 18 28 16 B 16 25 14 18 20 C 25 30 27 32 17 D 32 25 20 26 20

SEE MORE QUESTIONS

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