A1 Q2:2 Project Assignment34Garment5 Project A6 Project B7Project C891011121314151617181920212223242526272829303132333435363738394041BTeam 1503533CTeam 2302837TeamsDTeam 3552530ETeam 4273523•F02RS ModelGQ3HQ3 SS ModelJQ4 ABCDFGHMNOPRaptor Consulting has three (3) projects to complete this year. They have four (4) project teams currently available. Each project team can at most do oneproject. 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) to2 complete each proiect.345678910 Determine the optimal assignment of teams to projects in order minimize the total days taken to complete all the projects.1112 Please answer items A-E below13 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 formulation1516 B. Solve the problem using Excel Solver.17 Use worksheet tab "Q2 SS Model"TeamsProject Team 1 Team 2Project A5030Project B3528Project C3337ReadyTitleQ1EAccessibility: InvestigateTeam 3 Team 45527253530231819 C. What is the optimal assignment of teams to projects.20212223242526 D. What is the minimum number of days needed to complete the three projects.27282930 E. Suppose that at most only one of Teams 2 and 3 can be assigned to a project. Write below the additional constraint that you need to add.31 Note: No need to solve the model with this additional constraint.32333435.363738Q1 SS ModelQ244+Q2 SS ModelKQ3LQ3 SS ModelQ4+Q4 SS ModelQQ5RSQ5 Model

Answered: M O Raptor Consulting has three (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

The table below shows the duration and direct costs for the activities of a construction project. It is required to calculate the duration of the project that achieves the lowest possible total cost using the technique of crashing if the indirect costs are 5000$ per week. TITTI Activity Normal Time Normal Cost (NC) $ 6000 Crash Cost (CC) $ 12000 5000 Crash Time (NT) Weeks (CT) Weeks A 3 B 5 3000 2000 3 3 4000 6. 3000 3 6000 6. 9000 24000 Total Direct 23000 Cost
Consider a project with seven tasks. Three tasks – tasks 3, 4, and 5 – require a specific resource for completion; all needed resources must be available at the site before a task can be started. Task Duration Predecessor (s) Units of Value of Resource Completed Task Needed 3 3 10 $4000 3 1 10 S3000 3 12 $5000 1 4 7 2, 5,6 Each resource unit cost $100; no quantity discounts are available. In addition, it costs $2 per unit per time period to hold this resource in stock, and it costs $45 just to place an order for materials (independent of the number of units ordered). When should each task in the project be started and when and how many resources should be ordered to minimize total project costs? 1. 1, en en 1. 2. en
An office complex is to be renovated. Before the job can be completed, various tradespeople and skilled workers must install their materials. The table for this problem describes the relationships between the activities that need to be completed. Activity Immediate Predecessors Time (days) A1 - 6 A2 A1 7 A3 A1 3 A4 A1 10 A5 A2 10 A6 A3, A4 4 A7 A4 8 A8 A4 5 A9 A5, A6, A7 7 A10 A8 6 a) Develop a project network for this problem. b) Determine the EST, EFT, LST, LFT, and slack for each activity. c) What is the critical path and project completion time? d) Submit your file
An office complex is to be renovated. Before the job can be completed, various tradespeople and skilled workers must install their materials. The table for this problem describes the relationships between the activities that need to be completed. Activity Immediate Predecessors Time (days) A1 - 6 A2 A1 7 A3 A1 3 A4 A1 10 A5 A2 10 A6 A3, A4 4 A7 A4 8 A8 A4 5 A9 A5, A6, A7 7 A10 A8 6 a) Develop a project network for this problem. b) Determine the EST, EFT, LST, LFT, and slack for each activity. c) What is the critical path and project completion time?
Patel and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in days are as follows. Project Leader Client 1 Client 2 Client 3 Jackson 10 16 32 Ellis 14 22 14 Smith 22 24 34 Formulate the problem as a linear program. (Express your answers in the form xij where xij is 1 if leader i is assigned to client j and 0 otherwise.) Then solve: Relationship Value Time (Days) x11 x12 x13 x21 x22 x23 x31 x32 x33
Liam is estimating the schedule for all activities in the GHI Project. He is working with his project team and comparing the results of a past similar project to forecast the schedule for his current project. This is an example of which estimating approach? Group of answer choices Analogous Organizational process assets Parametric PERT
Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experience of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in days are as follows: Client Project Leader 1 2 3 Jackson 10 16 32 Ellis 14 22 40 Smith 22 24 34 Formulate the problem as a linear program, and solve. What is the total time required?
An IT company must complete a project with the following tasks listed A to G. ACTIVITY NORMAL DURATION (DAYS) CRASHED DURATION (DAYS) NORMAL COST ($) CRASHED COST ($) A 7 5 500 900 B 4 2 400 600 C 5 5 500 500 D 6 4 800 1000 E 7 4 700 1000 F 5 2 800 1400 G 6 4 800 1600 The following are all the paths in the project from start to end and the durations of each: A-B-E-G : 24 days A-C-E-G : 25 days A-C-F-G : 23 days A-D-F-G : 24 days Develop a crashing schedule to show which activities should be crashed to crash the project by 4 days and the lowest cost of doing so.
10.6 This optional problem requires knowledge of statistics. Heywood Home Healthcare is evaluating a project with the following net cash flows and probabilities: Time 0 Year 1 Year 2 Year 2 Year 3 Year 4 Prob = 0.2 ($100,000) 20,000 20,000 20,000 20,000 30,000 Prob = 0.6 ($100,000) 30,000 30,000 30,000 30,000 40,000 Prob = 0.2 ($100,000) 40,000 40,000 40,000 40,000 50,000 The year 5 values include salvage value. Heywood’s corporate cost of capital is 10 percent. What is the project’s expected NPV on the basis of the scenario analysis? What is the project’s standard deviation of NPV? Assume that Heywood’s managers judge the project to have lower-than-average risk. Furthermore, the company’s policy is to adjust the corporate cost of capital up or down by 3 percentage points to account for differential risk. Is the project financially attractive?
A company is setting up an assembly line to produce 90 units per hour. The table below identifies the work elements, times, and immediate predecessors. Work Element Time (Sec.) Immediate Predecessor(s) A 25 - B 18 A C 20 A D 5 B, C E 12 C F 8 E G 16 D, F H 12 G Use one of the heuristic decision rules described in Table below to balance the assembly line so that it will produce 90 units per hour. Clearly state the decision rule you use and complete the below table using the selected rule. Decision Rule Logic Longest work element Picking the candidate with the longest time to complete is an effort to fit in the most difficult elements first, leaving the ones with short times to “fill out” the station. Shortest work element This rule is the opposite of the longest work element rule because it gives preference in workstation assignments to those work elements that are quicker. It can be tried…
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?
Scott and Associates, Inc., is accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader- client assignments differ in terms of projected completing times. The possible assignments and the estimated completion times in days are as follows: Client Project Leader 1 2 3 Abby 10 16 32 Bovi 14 22 40 Claire 22 24 34 Develop a network representation of this problem. Formulate the problem as a linear program.

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