PROJ587 Course Project - Amazon
unknown_person
Program_Resource_Management_Sample1.xlsxInstructions
| INSTRUCTIONS | |
| 1. | Change the starting month and drag it across the table. |
| 2. | Select the resource group. |
| 3. | Select the resource type. |
| 4. | Enter the program component name. |
| 5. | Enter the number of resources of that type and group. |
| NOTE: Change the drop-down menus. | |
| Right-click worksheet name and select "Unhide." | |
| Add or change the drop-down items. | |
| RIght-click worksheet name and select "Hide." |
Program Resource Summary
| Component Name | Start | End | Duration | January | February | March | April | May | June | July | August | September | October | November | December |
| Project A | January | August | 7 | 17 | 17 | 17 | 12 | 17 | 17 | 12 | 12 | 0 | 0 | 0 | 0 |
| Project B | March | September | 6 | 0 | 0 | 19 | 29 | 16 | 10 | 8 | 15 | 14 | 0 | 0 | 0 |
| Project C | |||||||||||||||
| 0 | |||||||||||||||
| ` | |||||||||||||||
| Total |
Resource Management
| Resource Group | Resource Type | Component Name | January | February | March | April | May | June | July | August | September | October | November | December | Start | |
| Team Members | Specialists | Project A | 5 | 5 | 5 | 5 | 5 | |||||||||
| Equipment | Machine 1 | Project A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
| Team Members | Project Managers | Project A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
| Team Members | Technicians | Project A | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | ||||||
| Team Members | Technicians | Project B | 7 | 7 | 7 | 7 | 7 | 7 | ||||||||
| Team Members | Specialists | Project B | 3 | 3 | 3 | 2 | 2 | |||||||||
| Equipment | Machine 1 | Project B | 1 | 1 | 1 | 1 | 1 | |||||||||
| Team Members | Developers | Project B | 18 | 18 | 5 | 5 | 5 | 17 | ||||||||
| Team Members | Specialists | Project C | 5 | 5 | ||||||||||||
| Team Members | Project Managers | Project C | 1 | 1 | 1 | |||||||||||
| Technicians | 10 | 10 | 10 | 17 | 17 | 17 | 17 | 17 | 7 | 0 | 0 | 0 | 0 | |||
| Project Managers | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | |||
| Specialists | 5 | 5 | 5 | 3 | 8 | 8 | 0 | 2 | 7 | 5 | 0 | 0 | 0 | |||
| Labor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Developers | 0 | 0 | 18 | 18 | 5 | 0 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | |||
| Machine 1 | 1 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | |||
| TOTAL | 17 | 17 | 36 | 41 | 33 | 27 | 20 | 27 | 20 | 6 | 1 | 0 |
DropDown
| Resource Group | ResourceType | Available Resources |
| Team Members | Technicians | 5 |
| Equipment | Project Managers | 10 |
| Material/Supplies | Specialists | 8 |
| Labor | 25 | |
| Developers | 5 | |
| Machine 1 | 1 |
