A project manager is in charge of 3 ongoing projects, A, B, and C. Due to recent reorganization, theproject manager can assign additional employees to the 3 projects. Each employee who is assigned toa project can reduce the time to complete the project. The table below summarizes the data for the 3projects. For instance, at most 5 employees may be assigned to project A. Each employee assigned toproject A reduces the completion time by 3 days. (For example, if 3 employees are assigned to projectA, its completion time is reduced by 9 days.) Total 11 employees are available. The project managermust maximize the least reduction among all 3 projects. For instance, if we can reduce the completiontime of projects A, B, and C by 6, 8, and 9 days, respectively, the least reduction among all 3 projectsis 6 days. Please formulate an LP model that helps the project manager assign the 11 employees.ProjectsMaximum Number of EmployeesReduction of Completion Time (days / employee)A B53C644 3

Let, A = Number of employees assigned to Project A B = Number of employees assigned to project B C =…

Answered: A project manager is in charge of 3…

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

Quality Consulting has two consultants, Alfred and Barbara that can be scheduled to work for clients up to a maximum of 170 hours each over the next four weeks. A third consultant, Charlie, has some administrative assignments already planned and is available for clients up to a maximum of 150 hours over the next four weeks. The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the four- week period are: Client Hours A: 180 B: 75 C: 100 D: 85 Hourly rates vary for the consultant-client combination and are based on several factors, including project type and the consultant’s experience. The rates (dollars per hour) for each consultant-client combination are as follows: Client Consultant A B C D Alfred 100 125 115 100 Barbara 120 135 115 120 Charlie 155 150 140 130 1) Develop a network…
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. AT1 truck and a C1 car yield profits of $325 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = 240 (round your response to two decimal places).
A B C D F G H M N O P Raptor Consulting has three (3) projects to complete this year. They have four (4) project teams currently available. Each project team can at most do one project. Based on the mix of skills and experience on each of the teams, Raptor has developed the following estimates on time taken by each team (in days) to 2 complete each proiect. 3 4 5 6 7 8 9 10 Determine the optimal assignment of teams to projects in order minimize the total days taken to complete all the projects. 11 12 Please answer items A-E below 13 A. Formulate the problem as an assignment problem. Use worksheet tab "Q2 SS Model" to develop your formulation. 14 Use worksheet tab "Q2 SS Model" to develop your formulation 15 16 B. Solve the problem using Excel Solver. 17 Use worksheet tab "Q2 SS Model" Teams Project Team 1 Team 2 Project A 50 30 Project B 35 28 Project C 33 37 Ready Title Q1 E Accessibility: Investigate Team 3 Team 4 55 27 25 35 30 23 18 19 C. What is the optimal assignment of teams to…
4. A large donor has come on board to support the city in this initiative. This donor has given the city $100,000 dollars for the program but has specified that the money MUST be used to promote the program to families. Therefore, management has decided that this money will be the project advertising budget. The goal of this advertising budget is to maximize the number of people reached. The ads must be ordered ahead of time and there are 3 different types of ads to choose from. There is Television, Billboards, and Social media. It is assumed that every ad purchased is used and the number of people reached is listed below. These ads are subject to the following constraints: A) Television ads require 2 hours of labor and cost $2k each B) Social Media ads require 1 hour of labor and cost $1k each C) Billboards require 5 hours of labor and cost $6K each MEDIA # OF PEOPLE REACHED PER AD Television 30K Social Media Billboards 25K 22K Formulate the advertising linear model and solve for the…
A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The processing time on each workstation are as follows:Workstation V, 11 minutes per unit,Workstation W, 6 minutes per unit,Workstation X, 19 minutes per unit,Workstation Y, 19 minutes per unit. The raw material is always available in the front of workstation V. The manufacturing system can produce __________ units in 27 hours. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
Mangement Project management is the discipline of planning, organizing, motivating, and controlling resources to achieve specific goals and objectives within a specified time frame. It involves identifying project requirements, defining scope, establishing timelines, allocating resources, and managing risks. Project managers oversee the execution of projects, ensuring that they are completed on time, within budget, and according to quality standards. Effective project management requires strong leadership, communication, and problem-solving skills, as well as the ability to adapt to changing circumstances and stakeholders' needs. It is crucial for achieving project success and delivering value to stakeholders. Question: How does project management contribute to organizational efficiency and effectiveness?
You want to assign a set of jobs to a set of machines. The following table provides data as to the production/day of each machine when performing a particular job. Machine Job A В C D 140 | 180 | 160 | 200 210 | 195 || 140 | 120 220 | 170 | 180 | 125 185 230 | 100 | 160 1 2 3 4 Determine the best assignment of jobs to. What is the resulting total production of the assignment?
Amanufacturer is designing a product layout for a new product production. It plans to use a production line for 8 hours per day in order to meet forecasted demand of 180 units per day. The product requires 7 tasks in total. These tasks are namely,. A. B, C, D, E. F.and Grespectively, TaskAdoes not have any predecessor to start. To start Task B, it requires Task Ato be completed. Starting tasks Cneeds, the task B to be completed. Also, starting task D needed task B to be completed. Task E can only start upon completion of Task C. Whereas starting task Fneeds the completion of both the tasks Dand E. Finally, starting task Gneeded, task F to be completed. The processing times for tasks. A. B, C. D.E.F. and Gare 2.4, 22,0.9, 10, 1.2. 1.8, are 1.5 minutes respectively. Applying the most remaining tasks rule for balancing the assembly line, with ties broken according to longest task time first, the tasks that will be assigned to the THIRD workstation are O a D,E.and F Ob. D.E Oc CandE Od.…
There are four critical paths in a network. A-B-C-D-E, A-F-E, A-B-H-J-K-E and A-S-T-E. Each activity in this network can be crashed by a maximum of 6 weeks. The crashing cost (per week), for the first week (crashing first time), for activity A is: $480, E is $495 and all other activities is : $120 (per week per activity). The crashing cost, second week and onwards(crashing second time), for activity A is $1200 per week, E is $1440 per week and for all other activities is $240 per activity per week. You have a maximum crashing budget of $3005. The maximum possible reduction in the project duration will be: a. 6 weeks b. 3 weeks c. 2 week d. 5 weeks e. 4 weeks
The client of a project has requested the project team to crash 8 hours of time. The table below provides the necessary information about the possible project crashing. (a) What is the crash cost for 8 hours of time-savings?(b) Assume the team calls the client and asks for a project extension, reducing the amount of time they need to crash. The project team has a $20 crash budget. Is the budget sufficient to crash 4 hours of time?
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
Task 4In this task, you are asked to formulate the linear programming problem below andthen solve it.A carpenter produces Tables (T) and Chairs (C).Each Table unit requires 6kg of wood and 1kg of plastic.Each Chair unit requires 4kg of wood and 4kg of plastic.The carpenter has only 100kg of wood and only 50kg of plastic in stock.On each sale, the carpenter makes a profit of £15 per Table unit sold and a profit of£30 per Chair unit sold.Required:Formulate the Linear Programming problem above by defining the variables,stating the object function and the constraints.You are required to produce the graph for all inequalities (copy image to Word)Find the quantity to make of Tables and Chairs to maximise profit.

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