Analytics Exercise 4-2 (Static) You work for a company that makes cell phones and have been made project manager for the design of a new cell phone. Your supervisors have already scoped the project, so you have a list showing the work breakdown structure, and this includes major project activities. You must plan the project schedule and calculate project duration. Your boss wants the schedule on his desk tomorrow morning! You have been given the information in Exhibit 4.13. It includes all the activities required in the project and the duration of each activity. Also, dependencies between the activities have been identified. Remember that the preceding activity must be fully completed before work on the following activity can be started. Your project is divided into five major subprojects. Subproject "P" involves developing specifications for the new cell phone. Here, decisions related to such things as battery life, size of the phone, and features need to be made. These details are based on how a customer uses the cell phone. These user specifications are redefined in terms that have meaning to the subcontractors that will actually make the new cell phone in subproject "S" supplier specifications. These involve engineering details for how the product will perform. The individual components that make up the product are the focus of subproject "D." Subproject "I" brings all the components together, and a working prototype is built and tested. Finally, in subproject "V," suppliers are selected and contracts are negotiated. Exhibit 4.13: Work Breakdown Structure and Activities for the Cell Phone Design Project MAJOR SUBPROJECTS/ACTIVITIES Product Specifications (P) Market research Overall product specifications Hardware Software Supplier specifications (S) Product design (D) Product integration (I) Subcontracting (V) Hardware Software Battery Display Camera Outer cover Hardware User interface Software coding Prototype testing Suppliers selection Contract negotiation ACTIVITY IDENTIFICATION P1 E DOOD AAN ES P2 P3 P4 S1 S2 D1 D2 D3 D4 11 12 13 14 V1 V2 DEPENDENCY P1 P2 P3 P4 P4 S1 S1 S1 D1, D2, D3 8 D4 D2 12 11, 13 S1,S2 14, V1 DURATION (WEEKS) 4 4 4 4 10 2

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...
icon
Related questions
Question

Connect HW Q1

Analytics Exercise 4-2 (Static)
You work for a company that makes cell phones and have been made project manager for the design of a new cell phone. Your
supervisors have already scoped the project, so you have a list showing the work breakdown structure, and this includes major project
activities. You must plan the project schedule and calculate project duration. Your boss wants the schedule on his desk tomorrow
morning!
You have been given the information in Exhibit 4.13. It includes all the activities required in the project and the duration of each
activity. Also, dependencies between the activities have been identified. Remember that the preceding activity must be fully
completed before work on the following activity can be started.
Your project is divided into five major subprojects. Subproject "P" involves developing specifications for the new cell phone. Here,
decisions related to such things as battery life, size of the phone, and features need to be made. These details are based on how a
customer uses the cell phone. These user specifications are redefined in terms that have meaning to the subcontractors that will
actually make the new cell phone in subproject "S" supplier specifications. These involve engineering details for how the product will
perform.
The individual components that make up the product are the focus of subproject "D." Subproject "I" brings all the components
together, and a working prototype is built and tested.
Finally, in subproject "V," suppliers are selected and contracts are negotiated.
Exhibit 4.13: Work Breakdown Structure and Activities for the Cell Phone Design Project
1
MAJOR SUBPROJECTS/ACTIVITIES
Product Specifications (P)
Market research
Overall product specifications
Hardware
Software
Supplier specifications (S)
Product design (D)
Product integration (I)
?
Subcontracting (V)
f2
2
Hardware
User interface
Software coding
Prototype testing
Suppliers selection
Contract negotiation
W
f3
#
Hardware
Software
Battery
Display
Camera
Outer cover
3
E
f4
$
ACTIVITY IDENTIFICATION
4
P1
P2
P3
P4
$1
S2
BORD HAAN SO
D1
D2
D3
D4
I1
12
13
14
V1
V2
f5
%
5
Q
f6
A
T
DEPENDENCY
4-
P1
P2
P3
S1
S1
S1
D1, D2, D3
P4
P4
D4
D2
12
11, 13
6
$1,52
14, V1
f7
4+
Y
DURATION (WEEKS)
ly
7
2455
5
5
6
1
2
1
4
3444
10
2
fg
*
D
@
8
fg
X
KAA
9
ho
DII
fir
DDI
Transcribed Image Text:Analytics Exercise 4-2 (Static) You work for a company that makes cell phones and have been made project manager for the design of a new cell phone. Your supervisors have already scoped the project, so you have a list showing the work breakdown structure, and this includes major project activities. You must plan the project schedule and calculate project duration. Your boss wants the schedule on his desk tomorrow morning! You have been given the information in Exhibit 4.13. It includes all the activities required in the project and the duration of each activity. Also, dependencies between the activities have been identified. Remember that the preceding activity must be fully completed before work on the following activity can be started. Your project is divided into five major subprojects. Subproject "P" involves developing specifications for the new cell phone. Here, decisions related to such things as battery life, size of the phone, and features need to be made. These details are based on how a customer uses the cell phone. These user specifications are redefined in terms that have meaning to the subcontractors that will actually make the new cell phone in subproject "S" supplier specifications. These involve engineering details for how the product will perform. The individual components that make up the product are the focus of subproject "D." Subproject "I" brings all the components together, and a working prototype is built and tested. Finally, in subproject "V," suppliers are selected and contracts are negotiated. Exhibit 4.13: Work Breakdown Structure and Activities for the Cell Phone Design Project 1 MAJOR SUBPROJECTS/ACTIVITIES Product Specifications (P) Market research Overall product specifications Hardware Software Supplier specifications (S) Product design (D) Product integration (I) ? Subcontracting (V) f2 2 Hardware User interface Software coding Prototype testing Suppliers selection Contract negotiation W f3 # Hardware Software Battery Display Camera Outer cover 3 E f4 $ ACTIVITY IDENTIFICATION 4 P1 P2 P3 P4 $1 S2 BORD HAAN SO D1 D2 D3 D4 I1 12 13 14 V1 V2 f5 % 5 Q f6 A T DEPENDENCY 4- P1 P2 P3 S1 S1 S1 D1, D2, D3 P4 P4 D4 D2 12 11, 13 6 $1,52 14, V1 f7 4+ Y DURATION (WEEKS) ly 7 2455 5 5 6 1 2 1 4 3444 10 2 fg * D @ 8 fg X KAA 9 ho DII fir DDI
References
Mc
Graw
64°F
Sunny
esc
https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%
a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever required.)
Activity
P1
P2
P3
P4
S1
S2
D1
D2
D3
D4
11
12
13
14
V1
V2
b. Determine the minimum number of weeks for completing the project.
h
Earliest Start Time Earliest Finish Time Latest Start Time Latest Finish Time
Minimum number of weeks
c. Find the activities that are on the critical path for completing the project in the shortest time.
O P1-P2-P3-P4-S1-D1-D4-11-14-V2
O P1-P2-P3-P4-S1-D2-12-13-14-V2
O P1-P2-P3-P4-S1-D2-D4-11-14-V2
O P1-P2-P3-P4-S1-D3-D4-11-14-V2
?
f2
f3
*
f4
HOL
f5
16
4-
f7
9
ly
J+
8
En
18
90
Transcribed Image Text:References Mc Graw 64°F Sunny esc https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F% a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever required.) Activity P1 P2 P3 P4 S1 S2 D1 D2 D3 D4 11 12 13 14 V1 V2 b. Determine the minimum number of weeks for completing the project. h Earliest Start Time Earliest Finish Time Latest Start Time Latest Finish Time Minimum number of weeks c. Find the activities that are on the critical path for completing the project in the shortest time. O P1-P2-P3-P4-S1-D1-D4-11-14-V2 O P1-P2-P3-P4-S1-D2-12-13-14-V2 O P1-P2-P3-P4-S1-D2-D4-11-14-V2 O P1-P2-P3-P4-S1-D3-D4-11-14-V2 ? f2 f3 * f4 HOL f5 16 4- f7 9 ly J+ 8 En 18 90
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.