Question: how do you develop a comprehensive current state budget analysis report from this excel spreadsheet? ID Task Name Fixed Cost Total Cost Baseline Cost Cost
how do you develop a comprehensive "current state" budget analysis report from this excel spreadsheet?
| ID | Task Name | Fixed Cost | Total Cost | Baseline Cost | Cost Variance | Actual Cost | Remaining Cost |
| 1 | NearlyFree Employee Orientation Project | $0.00 | $30,380.00 | $22,300.00 | $8,080.00 | $20,453.95 | $9,926.05 |
| 2 | Initiating | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3 | Develop project charter | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4 | Review charter | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5 | Charter signed | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 6 | Planning | $0.00 | $8,160.00 | $2,160.00 | $6,000.00 | $8,160.00 | $0.00 |
| 7 | Develop project plan | $0.00 | $3,840.00 | $720.00 | $3,120.00 | $3,840.00 | $0.00 |
| 8 | Review project plan | $0.00 | $240.00 | $240.00 | $0.00 | $240.00 | $0.00 |
| 9 | Project plan approved | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 10 | Kickoff Meeting | $0.00 | $0.00 | $120.00 | ($120.00) | $0.00 | $0.00 |
| 11 | Executing | $0.00 | $21,980.00 | $19,900.00 | $2,080.00 | $12,293.95 | $9,686.05 |
| 12 | Interface Requirement | $0.00 | $600.00 | $600.00 | $0.00 | $600.00 | $0.00 |
| 13 | Software Requirement | $0.00 | $960.00 | $480.00 | $480.00 | $960.00 | $0.00 |
| 14 | User Documentation | $0.00 | $480.00 | $480.00 | $0.00 | $480.00 | $0.00 |
| 15 | Training Materials | $0.00 | $2,400.00 | $800.00 | $1,600.00 | $2,400.00 | $0.00 |
| 16 | Product Requirements Review Meeting | $0.00 | $640.00 | $640.00 | $0.00 | $640.00 | $0.00 |
| 17 | Construction | $0.00 | $11,280.00 | $11,280.00 | $0.00 | $7,213.95 | $4,066.05 |
| 18 | Develop Software Application | $0.00 | $10,000.00 | $10,000.00 | $0.00 | $7,149.95 | $2,850.05 |
| 19 | Analyze Interface Needs | $0.00 | $400.00 | $400.00 | $0.00 | $400.00 | $0.00 |
| 20 | Analyze Software Needs | $0.00 | $480.00 | $480.00 | $0.00 | $480.00 | $0.00 |
| 21 | Write Interface Specs | $0.00 | $2,000.00 | $2,000.00 | $0.00 | $2,000.00 | $0.00 |
| 22 | Write Software Specs | $0.00 | $2,400.00 | $2,400.00 | $0.00 | $2,400.00 | $0.00 |
| 23 | Code Software Application | $0.00 | $2,400.00 | $2,400.00 | $0.00 | $1,547.95 | $852.05 |
| 24 | Develop Interface | $0.00 | $1,000.00 | $1,000.00 | $0.00 | $300.00 | $700.00 |
| 25 | Test Interface | $0.00 | $400.00 | $400.00 | $0.00 | $0.00 | $400.00 |
| 26 | Test Software Application | $0.00 | $480.00 | $480.00 | $0.00 | $0.00 | $480.00 |
| 27 | Application Development Review Meeting | $0.00 | $440.00 | $440.00 | $0.00 | $22.00 | $418.00 |
| 28 | Develop User Documentation | $0.00 | $480.00 | $480.00 | $0.00 | $24.00 | $456.00 |
| 29 | Develop Training Materials | $0.00 | $800.00 | $800.00 | $0.00 | $40.00 | $760.00 |
| 30 | Integration and Testing | $0.00 | $1,640.00 | $1,640.00 | $0.00 | $0.00 | $1,640.00 |
| 31 | Put Application on Intranet | $0.00 | $600.00 | $600.00 | $0.00 | $0.00 | $600.00 |
| 32 | Quality Assurance Test | $0.00 | $600.00 | $600.00 | $0.00 | $0.00 | $600.00 |
| 33 | Integration and Testing Review Meeting | $0.00 | $440.00 | $440.00 | $0.00 | $0.00 | $440.00 |
| 34 | Training | $0.00 | $3,980.00 | $3,980.00 | $0.00 | $0.00 | $3,980.00 |
| 35 | Software Training for HR | $0.00 | $3,240.00 | $3,240.00 | $0.00 | $0.00 | $3,240.00 |
| 36 | Training Review Meeting | $0.00 | $740.00 | $740.00 | $0.00 | $0.00 | $740.00 |
| 37 | Controlling | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 38 | Status Report | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 39 | Status Report 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 40 | Status Report 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 41 | Status Report 3 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 42 | Status Report 4 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 43 | Status Report 5 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 44 | Status Report 6 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 45 | Status Report 7 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 46 | Status Report 8 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 47 | Status Report 9 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 48 | Status Report 10 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 49 | Status Report 11 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 50 | Status Report 12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 51 | Status Report 13 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 52 | Status Report 14 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 53 | Status Report 15 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 54 | Status Report 16 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 55 | Status Report 17 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 56 | Status Report 18 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 57 | Change reports | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 58 | Project Close | $0.00 | $240.00 | $240.00 | $0.00 | $0.00 | $240.00 |
| 59 | Post Mortem Lessons Learned | $0.00 | $120.00 | $120.00 | $0.00 | $0.00 | $120.00 |
| 60 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help