The business is going to establish a new office location. The information of the main jobs involved is provided in the table below. To finish this project as soon as possible, they also work on weekends (i.e., 7 days a week). Note that one-day job time means a full processing day through the midnight to next day. For example, if the job starts at 2/1/2023 and requires the job time of 3 days, it will be finished on 2/4/2023. Answer the questions below, Q1-Q3. Job A B С D E F G Description Lease the site Hire the workers Arrange for the furnishir Install the furnishings Arrange for the phones Install the phones Move into the office Immediate Predecessor A A C A D, E B,D,F Job Time 7 30 6 13 8 7 15 Q1: The business plans to start the project no sooner than 3/1/2023. The manager was told that it might take extra 3 days (i.e., a job time of 18 days instead of 15) to move into the office (Job G) because more equipment need to be relocated. It is possible that the installation of the furnishings (Job D) cannot start until 3/17/2023 due to the installation team's busy schedule in March. It is also possible that the phones cannot be arranged (job E) until 3/20/2023 given the cable/wiring issues recently found for repair. If with all these delays and issues for jobs D, E and G, what is the earliest date the project can be finished on? Besides the answer, you must show your calculation and analysis.
The business is going to establish a new office location. The information of the main jobs involved is provided in the table below. To finish this project as soon as possible, they also work on weekends (i.e., 7 days a week). Note that one-day job time means a full processing day through the midnight to next day. For example, if the job starts at 2/1/2023 and requires the job time of 3 days, it will be finished on 2/4/2023. Answer the questions below, Q1-Q3. Job A B С D E F G Description Lease the site Hire the workers Arrange for the furnishir Install the furnishings Arrange for the phones Install the phones Move into the office Immediate Predecessor A A C A D, E B,D,F Job Time 7 30 6 13 8 7 15 Q1: The business plans to start the project no sooner than 3/1/2023. The manager was told that it might take extra 3 days (i.e., a job time of 18 days instead of 15) to move into the office (Job G) because more equipment need to be relocated. It is possible that the installation of the furnishings (Job D) cannot start until 3/17/2023 due to the installation team's busy schedule in March. It is also possible that the phones cannot be arranged (job E) until 3/20/2023 given the cable/wiring issues recently found for repair. If with all these delays and issues for jobs D, E and G, what is the earliest date the project can be finished on? Besides the answer, you must show your calculation and analysis.
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...
Related questions
Question
Please Solve in Excel. ..
(Need all three questions. ...attempt if you will solve all three questions. ...thanks)
Transcribed Image Text:The business is going to establish a new office location. The information of the main jobs involved is provided in the table below. To finish this project as soon as possible, they also work on weekends (i.e., 7 days a
week). Note that one-day job time means a full processing day through the midnight to next day. For example, if the job starts at 2/1/2023 and requires the job time of 3 days, it will be finished on 2/4/2023.
Answer the questions below, Q1*03.
Job
ABCDEFG
в
Description
Lease the site
Hire the workers
Arrange for the furnishir
Install the furnishings
Arrange for the phones
Install the phones
Move into the office
XOCOEFG
Answer
Job Description
A Lease the site
Immediate
Predecessor
A
A
Hire the workers
Arrange for the furnishir
Install the furnishings
Arrange for the phones
Install the phones
Move into the office
C
A
D, E
B,D,F
Q1: The business plans to start the project no sooner than 3/1/2023. The manager was told that it might take extra 3 days (i.e., a job time of 18 days instead of 15) to move into the office (Job G) because more
equipment need to be relocated. It is possible that the installation of the furnishings (Job D) cannot start until 3/17/2023 due to the installation team's busy schedule in March. It is also possible that the phones
cannot be arranged (Job E) until 3/20/2023 given the cable/wiring issues recently found for repair. If with all these delays and issues for jobs D, E and G, what is the earliest date the project can be finished on?
Besides the answer, you must show your calculation and analysis.
Job
Time
7
Q2: This question is separate from Q1. The manager re-estimated the job times as shown in the table below. He hopes that everything can be moved into the new office and settle in within 8 weeks (i.e., 56 days).
What is the probability that his goal can be achieved? Use PERT to calculate the answer and show your analysis below.
30
6
13
8
7
15
A
A
С
A
D, E
B,D,F
Immediate Optimi Most
Predecessor stic Likely
S
Pessimi
stic Job
Job Job Time Time
5
20
5
11
7
6
13
39 00 00 + ~~.
29
14
15
CÔN Ô CÓ GÌ Sự có
31
15
19
10
12
Probability
Q3: Continued from Q2, the manager was considering two options to improve the likelihood of achieving his goal. Option 1 is adding part timers to the workforce for Job C (arrange for the furnishings) to reduce
the overall job time. It means the optimistic, mostlikely and pessimistic job times become 4, 6 and 14 days, respectively. Option 2 is using another team for Job C which offers a better consistency in the job time,
with the optimistic, mostlikely and pessimistic job times of 6, 7 and 14 days, respectively. Which option should he choose? Show your calculation and analysis.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Examine - Given details:
VIEWStep 2: Q1) Calculate - Actual Duration:
VIEWSolution
VIEWStep 3: Q1) Calculate - Actual Duration - Date:
VIEWStep 4: Q1) Calculate - Actual Duration with delay:
VIEWStep 5: Q2) Calculate - Duration and Variance:
VIEWStep 6: Q2) Calculate - Duration and Path:
VIEWStep 7: Q2) Calculate - Probability:
VIEWStep 8: Q3) Calculate - Option 1 - Duration:
VIEWStep 9: Q3) Calculate - Option 1 - Probability:
VIEWStep 10: Q3) Calculate - Option 2 - Duration:
VIEW
Trending now
This is a popular solution!
Step by step
Solved in 11 steps with 17 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
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
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
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.