Analytics Exercise 4-2 (Algo) 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

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

Analytics Exercise 4-2 (Algo)

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

Analytics Exercise 4-2 (Algo)
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)
Overall product specifications
Market research
Product design (D)
Supplier specifications (S)
Hardware
Software
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
P2
P3
P4
S1
S2
D1
D2
D3
D4
Il
I2
I3
14
V1
V2
DEPENDENCY
P1
P2
P3
P4
P4
S1
S1
S1
D1, D2, D3
D4
D2
I2
Il, 13
S1,S2
14,
V1
DURATION (WEEKS)
4355
56
6
HNL4
1
2
1
3+++
4
4
4
10
3
Transcribed Image Text:Analytics Exercise 4-2 (Algo) 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) Overall product specifications Market research Product design (D) Supplier specifications (S) Hardware Software 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 P2 P3 P4 S1 S2 D1 D2 D3 D4 Il I2 I3 14 V1 V2 DEPENDENCY P1 P2 P3 P4 P4 S1 S1 S1 D1, D2, D3 D4 D2 I2 Il, 13 S1,S2 14, V1 DURATION (WEEKS) 4355 56 6 HNL4 1 2 1 3+++ 4 4 4 10 3
a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever required.)
Activity
P1
22ISX-~~~
P2
P3
P4
S1
D1
D2
D3
D4
11
12
13
14
V1
V2
Earliest Start Time Earliest Finish Time Latest Start Time
b. Determine the minimum number of weeks for completing the project.
Minimum number of weeks
Latest Finish Time
c. Find the activities that are on the critical path for completing the project in the shortest time.
Transcribed Image Text:a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever required.) Activity P1 22ISX-~~~ P2 P3 P4 S1 D1 D2 D3 D4 11 12 13 14 V1 V2 Earliest Start Time Earliest Finish Time Latest Start Time b. Determine the minimum number of weeks for completing the project. Minimum number of weeks Latest Finish Time c. Find the activities that are on the critical path for completing the project in the shortest time.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar 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.