Question
On June 12, 2002, Alpha Corporation was awarded a $160,000 contract for testing a product. The contract consisted of $143,000 for labor and materials, and
- On June 12, 2002, Alpha Corporation was awarded a $160,000 contract for testing a product. The contract consisted of $143,000 for labor and materials, and the remaining $17,000 was profit. The contract had a scheduled start date of July 3. The network logic, as defined by the project manager by the customer resulted in the following project planning budget:
Activity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
AB | 2000 | 2000 | 3000 | 3000 | 4000 | 4000 | 3000 | ||||||||
AC | 3000 | 3000 | 3000 | 4000 | 4000 | 4000 | 4000 | 2000 | 2000 | 1000 | |||||
AD | 5000 | 5000 | 6000 | 4000 | 4000 | 4000 | 3000 | 1000 | |||||||
BC | 3000 | 4000 | 4000 | 5000 | |||||||||||
BE | 6000 | 6000 | |||||||||||||
CF | 2000 | 3000 | 3000 | ||||||||||||
DF | 3000 | 3000 | 3000 | 4000 | 4000 | ||||||||||
EF | 2000 | 2000 | |||||||||||||
FG | 3000 |
On August 27, 2002, the executive steering committee received the following report indicating the status of the project at the end of the eighth week:
Activity | % Complete (Based on Weeks) | Actual Cost | Time Remaining (Weeks) |
AB | 100 | $23,500 | 0 |
AC | 70 | $19,200 | 3 |
AD | 75 | $37,500 | 2 |
BC | 75 | $8,000 | 1 |
BE | 50 | $5,500 | 1 |
The steering committee could not identify the real status of the project from the brief report. Even after comparing this brief status report with the project planning budget above, the real status was not clear.
Management instructed the project manager to prepare a better status report that depicted the true status of the project at the end of week eight. Your assignment is to prepare a table using the template available in the Blackboard assignment folder labelled Alpha Project Status Report. Submit the completed Excel spreadsheet along with the rest of your assignment.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started