PROJECT WORK (BUSINESS ANALYST)

silu
sample.xlsx

WBS OUTLINE

2.1 UML Design For Interface
2.1.1 Create Outline of UML
2.1.2 Derived Requirements Artifacts
2.2 System/Software Design
2.2.1 Design Software Components
2.2.2 Peer Review
2.3 Approve Design
2.3.1 Derive Component Level Requirements
2.3.2 Unit test
2.3.3 System and Enterprise Test
2.3.4 Derive sell-off Acceptance Criteria
2.3.5 Peer review
3.1 Approve Content S/W Component Design
3.1.1 Provide Design Crafts
3.1.2 Derive sell-off Acceptance Criteria
3.1.2 Peer Review
3.2 Code and Unit Test
3.2.1 Code Test Software
3.2.2 Unit Test Software
3.3 Function Test
3.3.1 Check the Function
4.1 Design Test Artifacts
4.1.1 Derive System Level Test Cases
4.1.2 Derive Enterprise Level Test Cases
4.1.3 Peer Review
4.2 Perform Environment Level Tests
4.2.1 Execute Test Cases
4.3 Approve Test Services
4.3.1 Quality Check
4.3.2 Design Review
4.3.3 Pre-Ship Review
4.4 Run Test on Live Environment
4.4.1 Quality Check
4.4.2 Final Acceptance Test
4.5 Deploy to Operational Environment
4.5.1 Work with Customer facility

WBS

Astin Martin LLC

2.1.1 Create Outline of UML

2.1.2 Derived Requirements Artifacts

2.2 System/Software Design

2.2.1 Design Software Components

2.2.2 Peer Review

2.3 Approve Design

2.3.1 Derive Component Level Requirements

2.3.2 Unit test

2.3.3 System and Enterprise Test

2.3.4 Derive sell-off Acceptance Criteria

2.3.5 Peer review

3.1 Approve Content S/W Component Design

3.1.1 Provide Design Crafts

3.1.2 Derive sell-off Acceptance Criteria

3.1.2 Peer Review

3.2 Code and Unit Test

3.2.1 Code Test Software

3.2.2 Unit Test Software

3.3 Function Test

3.3.1 Check the Function

4.1 Design Test Artifacts

4.1.1 Derive System Level Test Cases

4.1.2 Derive Enterprise Level Test Cases

4.1.3 Peer Review

4.2 Perform Environment Level Tests

4.2.1 Execute Test Cases

4.3 Approve Test Services

4.3.1 Quality Check

4.3.2 Design Review

4.3.3 Pre-Ship Review

4.4 Run Test on Live Environment

4.4.1 Quality Check

4.4.2 Final Acceptance Test

4.5 Deploy to Operational Environment

4.5.1 Work with Customer facility

2.1UML Design For Interface

RAM

Project manager Chief Engineer System Engineer | System Engineer || System Engineer ||| Lead System Engineer Software Engineer | Software Engineer || Software Engineer ||| Lead Software Engineer System Test Engineer | System Test Engineer || System Test Engineer ||| Lead System Test Engineer Quality Engineer | Quality Engineer || Quality Engineer ||| Lead Quality Engineer
WBS Item Work Item
2.1 UML Design For Interface
2.1.1 Create UML Outline P S P S S S
2.1.2 Derive Requirement Artifacts P P S S
2.2 System/Software Design
2.2.1 Design Software Components S P S S S
2.2.2 Peer Review S P P S S
2.3 Approve Design
2.3.1 Derive Component Level Requirements S P P S S
2.3.2 Unit Test P S S
2.3.3 System and Enterprise Test P S S
2.3.4 Derive sell-off Acceptance Criteria P P S
2.3.5 Peer Review S P S P P P
3.1 Approve Content S/W Component
3.1.1 Provide Design Artifacts S S P S
3.1.2 Derive sell-off Acceptance Criteria S P S
3.1.3 Peer Review S P S P S
3.2 Code and Unit Test
3.2.1 Code Test Software S S S P P S
3.2.2 Unit Test Software S P P S
3.3 Function Test
3.3.1 Check The Function S S P S
4.1 Design Test Artifacts
4.1.1 Derive System Level Test Cases S P S P P P S
4.1.2 Derive Enterprise Level Test Cases S S S P S P S S
4.1.3 Peer Review S S S S P P
4.2 Perform Environmental Tests
4.2.1 Execute Test Cases S P S P S P P S
4.3 Approve Test Services
4.3.1 Quality Check S S P S P P
4.3.2 Design Review S P S P
4.3.3 Pre-Ship Review S P P
4.4 Run Test On Live Environment
4.4.1 Quality Checks S P S S P
4.4.2 Final Acceptance Test S S P S S P P
4.5 Deploy to Operational Environment
4.5.1 Work with Customer Facility S S P P

ACTIVITY COST

Activity Cost and Activity Duration Schedule
MAY JUNE JULY August September October November
Task Employee Work Days Labor Rate Labor Cost OH (15.95%) Total Employee Work Days Labor Rate labor Cost OH(15.55%) Total Employee Work Days Labor Rate Labor Cost OH(15.55%) Total Employee Work Days Labor Rate Labor Cost OH(15.55%) Total Employee Work Days Labor Rate Labor Cost OH(15.55%) Total Employee Work Days Labor Rate Labor Cost OH(15.55%) Total Employee Work Days Labor Rate Labor Cost OH(15.55%) Total
2.1 UML Design For Interface
2.1.1 Create Outline of UML CE 5 75.41 3016.4 481.1158 3497.5158
LSE 10 56.91 4552.8 726.1716 5278.9716
SE3 10 51.17 4093.6 652.9292 4746.5292
SW3 5 51.01 2040.4 325.4438 2365.8438
QE3 5 52.01 2080.4 331.8238 2412.2238
2.1.2 Derived Requirements Artifacts SE2 15 47.37 5684.4 906.6618 6591.0618
SE1 15 41.15 4938 787.611 5725.611
SW2 10 47.62 3809.6 607.6312 4417.2312
QE2 10 52.01 4160.8 663.6476 4824.4476
2.2 System/Software Design
2.2.1 Design Software Components SE2 10 47.37 3789.6 604.4412 4394.0412
SE1 15 41.15 4938 787.611 5725.611
SW1 15 42.38 5085.6 811.1532 5896.7532
QE1 5 40.38 1615.2 257.6244 1872.8244
2.2.2 Peer review LSE 10 56.91 4552.8 707.9604 5260.7604
SE2 15 47.37 5684.4 883.9242 6568.3242
SE1 15 41.15 4938 767.859 5705.859
SW1 15 42.38 5085.6 790.8108 5876.4108
QE1 10 40.38 3230.4 502.3272 3732.7272
2.3 Approve Design
2.3.1 Derive Component Level Requirements LSE 5 56.91 2276.4 353.9802 2630.3802
SE3 15 51.17 6140.4 954.8322 7095.2322
SE2 20 47.37 7579.2 1178.5656 8757.7656
SW3 20 51.01 8161.6 1269.1288 9430.7288
QE3 15 52.01 6241.2 970.5066 7211.7066
2.3.2 Unit Test SE1 10 41.15 3292 511.906 3803.906
SW1 15 42.38 5085.6 790.8108 5876.4108
QE1 10 40.38 3230.4 502.3272 3732.7272
2.3.3 System and Enterprise Test SE2 10 47.37 3789.6 589.2828 4378.8828
SW2 15 47.62 5714.4 888.5892 6602.9892
QE2 10 47.55 3804 591.522 4395.522
2.3.4 Derive sell-off Acceptance Criteria LSTE 10 55.25 4420 687.31 5107.31
STE3 20 49.25 7880 1225.34 9105.34
QE3 15 52.01 6241.2 970.5066 7211.7066
2.3.5 Peer Review SE3 15 51.17 6140.4 954.8322 7095.2322
SE2 15 47.37 5684.4 883.9242 6568.3242
SW3 10 51.01 4080.8 634.5644 4715.3644
SW2 10 47.62 3809.6 592.3928 4401.9928
STE3 15 49.25 5910 919.005 6829.005
QE3 15 52.01 6241.2 970.5066 7211.7066
3.1 Approve Content S/W Component Design
3.1.1 Provide Design Artifacts LSW 10 58.83 4706.4 731.8452 5438.2452
SW3 20 51.01 8161.6 1269.1288 9430.7288
SE3 10 51.17 4093.6 636.5548 4730.1548
QE2 10 47.55 3804 591.522 4395.522
3.1.2 Derive sell-off Acceptance Criteria STE2 20 43.62 6979.2 1085.2656 8064.4656
STE1 20 41.78 6684.8 1039.4864 7724.2864
QE1 15 40.38 4845.6 753.4908 5599.0908
3.1.3 Peer Review SW3 20 51.01 8161.6 1269.1288 9430.7288
SE3 20 51.17 8187.2 1273.1096 9460.3096
STE2 15 43.62 5234.4 813.9492 6048.3492
STE1 10 41.78 3342.4 519.7432 3862.1432
QE1 10 40.38 3230.4 502.3272 3732.7272
3.2 Code and Unit Test
3.2.1 Code Test Software LSW 15 58.38 7005.6 1089.3708 8094.9708
SW3 25 51.01 10202 1586.411 11788.411
SW2 25 47.62 9524 1480.982 11004.982
SW1 25 42.38 8476 1318.018 9794.018
SE3 20 51.17 8187.2 1273.1096 9460.3096
QE3 15 52.01 6241.2 970.5066 7211.7066
3.2.2 Unit Test Software SW1 25 42.38 8476 1318.018 9794.018
SE1 25 41.15 8230 1279.765 9509.765
SE2 25 47.37 9474 1473.207 10947.207
QE1 20 40.38 6460.8 1004.6544 7465.4544
3.3 Function Test
3.3.1 Check the Function SW3 20 51.01 8161.6 1269.1288 9430.7288
SW1 20 42.38 6780.8 1054.4144 7835.2144
SE3 15 51.17 6140.4 954.8322 7095.2322
QE3 15 52.01 6241.2 970.5066 7211.7066
4.1 Design Test Artifacts
4.1.1 Derive System Level Test Cases LSTE 10 55.25 4420 687.31 5107.31
STE3 15 49.25 5910 919.005 6829.005
SE3 10 51.17 4093.6 636.5548 4730.1548
SE2 15 47.37 5684.4 883.9242 6568.3242
SW3 10 51.01 4080.8 634.5644 4715.3644
SW1 15 42.38 5085.6 790.8108 5876.4108
QE2 10 47.55 3804 591.522 4395.522
4.1.2 Derive Enterprise Level Test Cases STE3 15 49.25 5910 919.005 6829.005
STE1 20 41.78 6684.8 1039.4864 7724.2864
SE2 15 47.37 5684.4 883.9242 6568.3242
SE1 20 41.15 6584 1023.812 7607.812
SW2 15 47.62 5714.4 888.5892 6602.9892
SW1 20 42.38 6780.8 1054.4144 7835.2144
QE2 10 47.55 3804 591.522 4395.522
QE1 10 40.38 3230.4 502.3272 3732.7272
4.1.3 Peer Review LSTE 10 55.25 4420 687.31 5107.31
STE3 15 49.25 5910 919.005 6829.005
STE2 15 43.62 5234.4 813.9492 6048.3492
STE1 15 41.78 5013.6 779.6148 5793.2148
SE1 10 41.15 3292 511.906 3803.906
SW1 10 42.38 3390.4 527.2072 3917.6072
4.2 Perform Environment Level Tests
4.2.1 Execute Test Cases SE3 20 51.17 8187.2 1273.1096 9460.3096
SE2 20 47.37 7579.2 1178.5656 8757.7656
SW2 15 47.62 5714.4 888.5892 6602.9892
SW1 15 42.38 5085.6 790.8108 5876.4108
LSTE 10 55.25 4420 687.31 5107.31
STE3 20 49.25 7880 1225.34 9105.34
STE2 20 43.62 6979.2 1085.2656 8064.4656
QE3 15 52.01 6241.2 970.5066 7211.7066
4.3 Approve Test Services
4.3.1 Quality Checks STE3 20 49.25 7880 1225.34 9105.34
STE2 20 43.62 6979.2 1085.2656 8064.4656
STE1 15 41.78 5013.6 779.6148 5793.2148
QE3 10 52.01 4160.8 647.0044 4807.8044
QE2 15 47.55 5706 887.283 6593.283
QE1 10 40.38 3230.4 502.3272 3732.7272
4.3.2 Design Review QE3 20 52.01 8321.6 1294.0088 9615.6088
QE2 20 47.55 7608 1183.044 8791.044
STE3 15 49.25 5910 919.005 6829.005
STE2 15 43.62 5234.4 813.9492 6048.3492
4.3.3 Pre-Ship Review QE3 15 52.01 6241.2 970.5066 7211.7066
QE2 15 47.55 5706 887.283 6593.283
QE1 15 40.38 4845.6 753.4908 5599.0908
4.4 Run Test on Live Environment
4.4.1 Quality Checks QE3 10 52.01 4160.8 647.0044 4807.8044
QE2 10 47.55 3804 591.522 4395.522
QE1 15 40.38 4845.6 753.4908 5599.0908
STE3 10 49.25 3940 612.67 4552.67
STE2 10 43.62 3489.6 542.6328 4032.2328
4.4.2 Final Acceptance Test LQE 10 59.83 4786.4 744.2852 5530.6852
QE3 15 52.01 6241.2 970.5066 7211.7066
QE2 15 47.55 5706 887.283 6593.283
QE1 10 40.38 3230.4 502.3272 3732.7272
STE3 10 49.25 3940 612.67 4552.67
STE2 10 43.62 3489.6 542.6328 4032.2328
STE1 10 41.78 3342.4 519.7432 3862.1432
4.5 Deploy to Operational Environment
4.5.1 Work with Customer Facility LSTE 5 55.25 2210 343.655 2553.655
STE3 5 49.25 1970 306.335 2276.335
STE2 5 43.62 1744.8 271.3164 2016.1164
STE1 5 41.78 1671.2 259.8716 1931.0716
May Total 57748.6656 June Total 91060.333 July Total 136162.7334 August Total 164865.8156 September Total 142981.57 October Total 112172.2424 Novemeber Total 44292.626
Total Budget Cost 749283.986
Task
MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
2.1 Create UML Outline and Derive requirement artifacts 39859.4358
2.2 System/Software Design 17889.2298 27144.0816
2.3 Approve Design 63916.2514 58245.9818
3.1 Approve Content S/W Component 77916.7516
3.2 Code/Unit Test 95070.8424
3.3 Function Test 31572.882
4.1 Design Test Artifacts 38222.0912 82795.2726
4.2 Perform Envirnomental Test 60186.2974
4.3 Approve Test Services 88784.9224
4.4 Run Test on Live Environment 23387.33 35515.448
4.5 Deploy to Operational Environment 8777.178
Total Budget Cost 57748.6656 91060.333 136162.7334 164865.8156 142981.57 112172.2524 44292.626

Graph

Month TBC CBC
MAY 57748.6656 57748.6656
JUNE 91060.333 148808.9986
JULY 136162.7334 284971.732
AUG 164865.8156 449837.5476
SEP 142981.57 592819.1176
OCT 112172.2524 704991.37
NOV 44292.626 749283.996

Cummulitive Budget Curve

TBC MAY JUNE JULY AUG SEP OCT NOV 57748.6656 91060.332999999999 136162.7334 164865.8156 142981.57 112172.2524 44292.625999999997 CBC MAY JUNE JULY AUG SEP OCT NOV 57748.6656 148808.99859999999 284971.73199999996 449837.54759999993 592819.1176 704991.37 749283.99600000004

Month

Budget