Reference no: EM131440394
Project Scheduling
Purpose: (1) Demonstrate a basic ability to construct Gantt charts and PERT models.
(2) Demonstrate an ability to interpret the relationships and results of your models.
Required: Using data from the "Raw Data" file as inputs to the Scenario below, construct Excel models to calculate (1) a Gantt chart, (2) a PERT chart, and (3) a critical path.
Put all your work in one Excel workbook.
Use two different worksheets for your charts, one worksheet per chart type.
Label a fourth worksheet "Summary." There you will writea short statement labeled "Interpretation" in which you state lessons learned from this assignment, and an interpretation of what it means to you.
Scenario
(Your exact values for needed variables are in the "Raw Data" file.)
The following table lists activity labels and predecessors for a simple project
|
Activity
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
End
|
|
Predecessors
|
Start
|
Start
|
A
|
A
|
B,C
|
B,C
|
D,E
|
D,E
|
H
|
F,G
|
G,I
|
All loose ends
|
Your raw data file has duration values for each activity, given as a, b, and m. Use your textbook for definitions of what those mean.
Using Excel, construct the following. Use a separate worksheet for each chart.
1. A Gantt chart. Use the m values for durations of each activity.
2. A PERT chart. Add a table to this worksheet in which you calculate EV for each activity, and then use EV as the duration for each activity.
3. Add a table to your SUMMARY worksheet in which you use the Excel MIN and MAX functions to calculate the critical path for your project. Use colors to highlight the activities on the critical path, and name the path (e.g. "A-F-G-K") in your Interpretation space.
|
Who have found the internet to be a useful tool
: Share your thoughts about people who have found the Internet to be a useful tool for perpetrating crimes, conducting terrorism, and even waging war.
|
|
Materials requirements planning
: An MRP exercise is being implemented over an 8-week period and the following relevant information is provided: One unit of A is made of two units of B, one unit of C, and two units of D. B is composed of two unit of E and one unit of D. C is made o..
|
|
Occupational safety and health administration
: One source must be from the Occupational Safety and Health Administration (OSHA) website, which can be accessed by clicking the following link: https://www.osha.gov/ Information about accessing the grading rubric for this assignment is provided be..
|
|
How can written communications be bias-free
: What are the challenges when an organization practices valuing diversity - How can written communications be bias-free? Provide specific examples.
|
|
Demonstrate a basic ability to construct gantt charts
: Purpose: (1) Demonstrate a basic ability to construct Gantt charts and PERT models. (2) Demonstrate an ability to interpret the relationships and results of your models.
|
|
What oil issues would impact the supply
: What oil issues would impact the supply? What supply issues would impact prices? What oil issues would impact the demand? What demand would impact prices?
|
|
Ow many servings of each food should have in an optimal diet
: Joe is an active 26-year-old male who lifts weights 6 days a week. His rigorous training program requires a diet that will help his body recover efficiently. He is also a graduate student who is looking to minimize the cost of consuming his favori..
|
|
What are the key market-strategy changes heinz
: According to Professor Sheth, there are several key characteristics of emerging markets that are different from traditional industrialized markets, which require marketers to rethink core marketing assumptions. Discuss and evaluate the suggested m..
|
|
What other points in the chapter did you find interesting
: What is economic efficiency? Why do economists define efficiency in this way? What other points in the chapter did you find interesting?
|