Question

Analyze the cost data received for the given project activities (provided in table) using earn value management technique and find the values of below
questions;
1. Are we ahead or behind schedule? Find the value of variance in Rupees
(Rs.) & in percentage If there is any deviation from work planned.
2. How efficiently are we using time?
3. Are we over or under budget? Express the variance in Rupees (Rs.) & in
percentage.
4. How efficiently are we using our resources?
5. How efficiently must we use our remaining resources?
6. What is the project likely to cost if it goes with current pace?
7. What will the remaining work cost?
8. Will we be over or under budget if we perform out activities with
current pace?

Activity ID Description of Activities Duration Predecessor Budgeted cost Percentage of work Complete schedule (%) R$ 136,350 100 Actual cost of Work Performed R$110,000 А CN + 10 B CN + 30 A Rs116,370 100 Rs86.000 C D ܢܫܬ F G H 1 Clearing & Grubbing Roadway Excavation in Surplus/Unsuitable Common Material Compaction of Natural Ground Structural Excavation in Common Material Subgrade Preparation in Earth Cut Subgrade Preparation on Existing Road PCC including placing, compacthg and curing Ratio 1:48 Construction of RCC Box Culvert (Single cell) Granular Sub Base Using Crushed Stone Aggregates Water Bound Macadam Base Course Bitumenous Prime Coat Tack Сези Asphatic Wearing Course (Asphalt Batch Mont Hot Mixed) CN+ 45 CN+ 50 CN +40 10 CN CN + 70 CN+ 15 CN+30 CN + 2 CN CN.5 А A B C D G EF Rs646,598 R$50,000 R$72,090 Rs810424 Rs 136,000 R$5.394,670 R$6.291,085 Rs11.291,868 Rs 3.800,277 R$2.750,000 327972,770 100 ON +23 ON - 19 ON+19 ON 17 ONOS ON + 10 ONO CN-05 R$589,000 R 29,500 R341812 R$ 470,046 R$76,160 Rs2,535,495 Rs3.082.632 Rs5,307,178 Rs1,672,122 1 к D 1 M н. KL CN=52

please solve this as soon as possible