Reference no: EM131443889
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.
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.
|
Discuss about the utilitarianism and kants deontology
: The movie i have selected is "Saving Private Ryan". You will briefly summarize this film (250 words). Then, you will analyze how the film treats this moral issue. Use the text to support your analysis (about 500 words). Employ an APA title page, ..
|
|
Indicate which point equilibrium wage and quantity hired
: Indicate which point could correspond to the equilibrium wage and quantity hired a. at the initial equilibrium. b. if the price of the output produced by the labour increased. c. if the price of the output produced by the labour decreased. d. with an..
|
|
Briefly describe the health issue of the study focus
: Please use the questions provided in this guide to analyse one of the journal articles reporting (available in the assessment tab on vUWS). Background of the study - Briefly describe the health issue of the study's focus? What is the significance of..
|
|
How many seats should jetred overbook
: a. How many seats should JetRed overbook? b. JetRed management is dreading bad publicity around Thanksgiving so it decides instead that it does not want to bump passengers more than 5% of thetime. What is the maximum number of seats that JetRed ca..
|
|
Construct gantt charts and pert models
: 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.
|
|
Discuss about the contemporary environmental issues
: As you know, our world is heavily dependent on oil. In Chapter 6 of Contemporary Environmental Issues, you have read that there is concern about the possibility of reaching a peak in oil production, while Chapter 8 of Contemporary Environmental Is..
|
|
Develop a budget for the strategy
: BSB61015 Demonstrate knowledge and skills required to influence groups and individuals - Develop a budget for the strategy and develop a communication plan for the change strategy.
|
|
Determine the impact on equilibrium wage and quantity
: How would each of the following affect the demand or supply of workers? In each case, determine the impact on equilibrium wage and quantity. a. Immigration increases dramatically. b. Demand for Canadian manufactured goods declines.
|
|
Counting the non-negative constraints
: If a transportation problem has five origins and five destinations, the LP formulation of the problem will have how many constraints not counting the non-negative constraints?
|