Question: PLEASE DO ALL IN EXCEL HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. Information
PLEASE DO ALL IN EXCEL
HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations.
- Information on a projects activities is shown in the following table:
| Activity | Immediate Predecessor | Activity Time (wks) | Total Budgeted Cost |
| A | - | 5 | 25,000 |
| B | - | 4 | 28,000 |
| C | B | 1 | 16,000 |
| D | A | 10 | 44,000 |
| E | C | 3 | 36,000 |
| F | D, E | 5 | 50,000 |
| G | D, E | 4 | 80,000 |
| H | E | 7 | 21,000 |
| I | F | 6 | 36,000 |
| J | G, H | 4 | 60,000 |
| K | I, J | 3 | 30,000 |
| L | G, H | 1 | 20,000 |
- Create a Gantt chart based on earliest start times. (20 pts)
- Create a budget cost chart, using earliest start times. (20 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
