Create a Gantt Chart with EXCEL and show all steps.
Homework Answers
| Dur | EF= ES+Dur | |||||||
| Task | Pre | Duration | ES | EF | Critical | LS | LF | End Slack |
| a | ------ | 2 | 0 | 2 | Yes | 0 | 2 | 0 |
| b | ------ | 2 | 0 | 2 | Yes | 0 | 2 | 0 |
| c | a, b | 4 | 2 | 6 | Yes | 2 | 6 | 0 |
| d | c | 3 | 6 | 9 | Yes | 6 | 9 | 0 |
| e | a, b, c | 1 | 6 | 7 | 8 | 9 | 2 | |
| f | d, e | 2 | 9 | 11 | Yes | 9 | 11 | 0 |
| g | f | 3 | 11 | 14 | Yes | 11 | 14 | 0 |
| h | g | 1 | 14 | 15 | Yes | 14 | 15 | 0 |
| Project duration | (Max of EF) | 15 |
B.
So we assume weekend days are included in time if they come on from 5 to 7, 12 to 14, 19 to 21 etc.
| Including weekends | ||||
| Start | End | Time | Weekends days | |
| a | 0 | 2 | 2 | 0 |
| b | 0 | 2 | 2 | 0 |
| c | 2 | 8 | 6 | 2 |
| d | 8 | 11 | 3 | 0 |
| e | 11 | 12 | 1 | 0 |
| f | 12 | 16 | 4 | 2 |
| g | 16 | 19 | 3 | 0 |
| h | 19 | 22 | 3 | 2 |
Add Answer to:
Create a Gantt Chart with EXCEL and show all steps.
Activity Preceding Activity Duration (Weeks) C,D...
: A network consists of the following list. Times are given in weeks. Activity Preceding Duration...
: A network consists of the following list. Times are given in weeks. Activity Preceding Duration A -- 9 B A 2 C A 12 D A 5 E B 6 F B 8 G C, F 3 H D 2 I H 8 J G, I 6 K E, J 2 Draw the network diagram. Find ES, EF, LS, LF, and the slack times for each of the activities. Which activities are critical? Determine the critical path(s). What is...
Create a Gantt Chart for the following project, and show the Gantt Chart below. Set a...
Create a Gantt Chart for the following project, and show
the Gantt Chart below. Set a start date of January 6, 2020. Assume
that work can be done 5 days per week. Identify the Critical Path.
When will the project be completed?
Create a Gantt Chart for the following project, and show the Gantt Chart below. Set a start date of January 6, 2020. Assume that work can be done 5 days per week. Identify the Critical Path. When will...
Draw an Gantt chart using the following figure. Duration (Days) Preceded by Activity B 22 10...
Draw an Gantt chart using the following figure.
Duration (Days) Preceded by Activity B 22 10 13 8 15 Immediately Following Activities DJ CF DJ -- C, F, G H, I, K HI, K DJ BE A, C, H F 17 ewuQIM 15 11 22
Calculate the expected project completion time (in weeks) using a Gantt chart and the international convention....
Calculate the expected project
completion time (in weeks) using a Gantt chart and the
international convention.
Then, write the exact date of the
completion of this project using the Official International
Standard.
ANSWER ONLY IF YOU KNOW THESE
TWO QUESTIONS!
A) Duration of the project (IN
WEEKS)
B) Exact completion data using
the OFFICIAL INTERNATIONAL STANDARD
Activity DurationPredecessorsStart Date 2019-04-01 A,B D, E F,G
Activity Duration (days) Preceding activity A 3 - B 5 - C 2 B D 1...
Activity Duration (days) Preceding activity A 3 - B 5 - C 2 B D 1 A E 6 A F 3 D G 3 C,E a. Construct a network diagram showing the critical path. b. Identify the earliest time the campaign can start. c. Identify the activities where there is float/slack time in the project, and calculate how much float/slack time there is. ** You should show all of your workings and state, clearly, any assumptions made.
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! PLEASE SHOW ALL WORK...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table ctivity Immediate Predecessor Activity Time (wks) Total Budgeted Cost 25,000 4 28,000 16,000 10 44,000 36,000 B, D, E 55,000 B, D, E 80,000 21,000...
Activity Predecessor Duration (weeks) a none 12 b none 5 c a, b 7 d c,...
Activity Predecessor Duration (weeks) a none 12 b none 5 c a, b 7 d c, e 2 e b 8 f e 9 g d 5 h f,g 8 Your firm is implementing a balanced scorecard. As the project manager, you need to make sure the project is completed on time and on-budget. The table below lists the steps that need to be complete. The data analysis team members are going to be late delivering some key data points...
1. Consider the following information: Activity Predecessor Duration (weeks) A None 2 B A 4 C...
1. Consider the following information: Activity Predecessor Duration (weeks) A None 2 B A 4 C A 3 D A 2 E B 3 F C 6 G C, D 5 H E, F 6 I G 5 J H, I 5 Activities B and H can be shortened by a minimum of 2 time units. Which activity would you shorten to reduce the project duration of 2 weeks. Why? (be specific)
1. Using Microsoft Excel prepare a Gantt Chart for the following project. Predecessor(s) Duration (Days) Activity...
1. Using Microsoft Excel prepare a Gantt Chart for the following project. Predecessor(s) Duration (Days) Activity 1. Forming the problem statement 2. Identifying functional requirements 3. Identifying constraints and limitations 4. Defining a schedule 5. Defining the design parameters 6. Identifying alternatives 7. Evaluating and analyzing alternatives 8. Select a solution 9. Gather supplies 10. Construct prototype 11. Test performance 12. Redesign 13. Demonstrate solution to class 2,3 2 8 10 11 12
Concerning the activities the following standards were set: ACTIVITY DESCRIPTION PRECEDING ACTIVITY ACTIVITY DURATION(DAYS) A Feasibility...
Concerning the activities the following standards were set: ACTIVITY DESCRIPTION PRECEDING ACTIVITY ACTIVITY DURATION(DAYS) A Feasibility Study None 7 B Internal Specs A 5 C External Specs A 13 D Internal Analysis B 5 E Functional Specs C,D 10 F Hardware Specs E 15 G Hardware Acquisition F 5 H System Installation G 3 I Design material A 45 J System Testing H,I 10 a) Draw a network diagram (Activity-on-None) of the project presented in the case study with all...
Create a Gantt Chart for the following project, and show
the Gantt Chart below. Set a start date of January 6, 2020. Assume
that work can be done 5 days per week. Identify the Critical Path.
When will the project be completed?
Create a Gantt Chart for the following project, and show the Gantt Chart below. Set a start date of January 6, 2020. Assume that work can be done 5 days per week. Identify the Critical Path. When will...
Draw an Gantt chart using the following figure.
Duration (Days) Preceded by Activity B 22 10 13 8 15 Immediately Following Activities DJ CF DJ -- C, F, G H, I, K HI, K DJ BE A, C, H F 17 ewuQIM 15 11 22
Calculate the expected project
completion time (in weeks) using a Gantt chart and the
international convention.
Then, write the exact date of the
completion of this project using the Official International
Standard.
ANSWER ONLY IF YOU KNOW THESE
TWO QUESTIONS!
A) Duration of the project (IN
WEEKS)
B) Exact completion data using
the OFFICIAL INTERNATIONAL STANDARD
Activity DurationPredecessorsStart Date 2019-04-01 A,B D, E F,G
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table ctivity Immediate Predecessor Activity Time (wks) Total Budgeted Cost 25,000 4 28,000 16,000 10 44,000 36,000 B, D, E 55,000 B, D, E 80,000 21,000...
1. Using Microsoft Excel prepare a Gantt Chart for the following project. Predecessor(s) Duration (Days) Activity 1. Forming the problem statement 2. Identifying functional requirements 3. Identifying constraints and limitations 4. Defining a schedule 5. Defining the design parameters 6. Identifying alternatives 7. Evaluating and analyzing alternatives 8. Select a solution 9. Gather supplies 10. Construct prototype 11. Test performance 12. Redesign 13. Demonstrate solution to class 2,3 2 8 10 11 12
Most questions answered within 3 hours.
-
suppose you own a chain of five restaurants in
downtown Vancouver. as the manager, you want...
asked 21 seconds ago -
Here are summary statistics for randomly selected weights of
newborn​ girls:
nequals=225x overbarxequals=28.7hg, sequals=7.5hg. Construct a...
asked 3 minutes ago -
Q) Simplify the following functions and implement them with two-
level NAND gate circuits:
a) F(A,B,C,D)=...
asked 2 minutes ago -
If you could afford exactly 6 apples and 14 bananas, or 10
apples and 6 bananas,...
asked 17 minutes ago -
Write functions squareByValue,
squareByRef, squareByPointer that find the square of an integer, in
three different ways:...
asked 12 minutes ago -
Find the P - value for the test statistic ?=2.74z=2.74
for the following null and alternative...
asked 18 minutes ago -
An software company has three different promotion plans for
its software purchase:
plan A: each software...
asked 37 minutes ago -
If
P(A)=.62, P(B)=.47, & P(A or B)=.88. What is the likeliness of
selecting only A?
A)...
asked 36 minutes ago -
What is the FUTURE VALUE of $500 invested for 3 years at 7% with
ANNUAL Compounding...
asked 46 minutes ago -
Modify the method so that instead of manually making teams, it
reads it from a text...
asked 44 minutes ago -
1. Which of the following is not a principle to apply to
construction:
Select one:
a....
asked 46 minutes ago -
In what way is a Christian’s position made more challenging by
revealing faith in the workplace?...
asked 53 minutes ago