setup earned value scenario analysis for the following details attached with this question. please right-click on images and select open in a new tab so that picture would become clear as the original.

A B C D E F G . 1 J K L M N JOB TITLE Warehouse 3 LABOR Materials Months Price 4 PROJECT ESTIMATE TOTALS TOTAL EQUIPMENT $0.00 TOTAL TOTAL MATERIAL LABOR $9,12,309.30 $5,20,242.06 $10,03,540.23 $5,20,242.06 Total with waste $ $ 6,615.00 5 6 22 23 24 25 26 Labor Months Price Total Labor Equipment Price SITE PREP Dumpster / Waste Removal Materials 5.00 Total Material $ 1,485.00 3 $ 99.00 Portable Restroom Facilities The WC will be executed in the first month 28 32 2.00 20.00 1 $ $ $ 150.00 120.00 $ $ 300.00 2,400.00 Surface Protection Temporary Powerl lightining Estimating the worst case, if the contractor doesn't provide $ 2,000.00 $ 2,000.00 $6,185.00 SUBTOTAL $0.00 38 40 41 103 FOUNDATION / CONCRETE Months Price 104 105 111 113 Reinforcement for the foundation Pile Caps footings - concrete Foundation - Walls Labor Price (per sq ft) $ 1.20 S 3.00 $ 3.00 Materials 2129.22 23328.00 330.00 $ $ $ Price Total Material Total Labor 40.00 $ 85,168.80 $ 2,555.06 It was consider 0.005% of 6.25 $ 1,45,800.00 $ 69,984.00 steel for each m3 of 6.25 $ 2,062.50 $ 990.00 concrete Equipment levels, tape measures, moisture retarders, saws, shovels, rakes, tampers, , , vibrators, screeds, bull floats, magnesium floats, kneeling boards, trowels, float blades, groove cutter, edger, brooms, polishers, grinders, thermohygrometers, hammer drills, concrete moisture meters, RH Test Kits S $ S 114 115 116 117 131 Floor with finishing Wire mash for the floor Steel Columns Forms for the foundation 2.60 1.20 3.00 $ 12600.00 25200.00 18.00 7.25 0.40 $ 700.00 $ 1,000.00 $ S $ $ 91,350.00 $ 32,760.00 10,080.00 $ 30,240.00 12,600.00 $ 54.00 1,000.00 $3,48,061.30 $ 1,36,583.06 $ $ 5,000.00 5,000.00 SUBTOTAL $0.00 Labor (per sa ft) 133 MASONRY / EXTERIOR WALLS Materials Months Price Total Material Total Labor Price Equipment 115V wet masonry saw, 5 cubic foot mortar box, small plate compactor Exterior Walls 134 $ 14.00 16500.00 $ 14.00 Total material price for masonry per sq foot $ $ 65.00 149 150 151 2,31,000.00 $ 2,31,000.00 0 $2,31,000.00 $ 2,31,000.00 SUBTOTAL $0.00 $ 65.00 152 WINDOWS + DOORS (Exterior) Labor Materials Months Price Total Material Total Labor Price $ $ Personal Doors 153 300.00 $ S 300.00 4.00 250.00 $ $ 1,000.00 $ 1,200.00 Equipment hammer, casing nails, level, wooden shims, screws, spray foam, trim, screwdriver, door knob kit with hardware 154 Roof Hatch $ 200.00 2.00 $ 540.00 $ 1,080.00 $ 400.00 155 Overhead Doors $ 300.00 14.00 $ 2,500.00 $ 35,000.00 $ 4,200.00 156 Skylights 28.00 WC Doors Foom for doors S $ S $ 120.00 300.00 4.00 2.00 30.00 $ $ $ 350.00 $ 200.00 $ 6.00 $ 9,800.00 $ 400.00 $ 180.00 $ $47.460.00 $ 3,360.00 600.00 120.00 157 158 167 100 SUBTOTAL 9,880.00 $ 300.00 Preliminary Estimate Materials Quantitative calculations + A B C D E F G . J K M N 168 169 FINISH Labor Materials Months Price Total Material Total Labor Price Stucco Equipment Paint roller, masking tape, ladder, drop cloth, paint brush Not consider, except requested by the owner 175 $ 187 Paint (exteriori interior) S $ 3.00 165.00 35 $ 5,775.00 $ 495.00 It was considered 1 gallon per 400 sq foot for 4.00 walls Paint for internal doors $ 2.00 45 $ 2.00 $0.00 90.00 $ $5,775.00 $ $ $ SUBTOTAL 499.00 50.00 50.00 192 193 194 195 196 Labor Months Price Materials 26536 Price Total Material Total Labor 5.50 $ 1,45,948.00 $ 1,32,680.00 $ $ 5.00 $ ROOFING Root + Drip Edge Roof Hatch Skylights Equipment fastener drivers, electric swivel head metal shears, nibblers, blade cutters, metal snips, S 2 197 198 120.00 120.00 $0.00 $ $ $ S 540.00 $ 350.00 $ $ 28 1,080.00 $ 240.00 9,800.00 $ 3,360.00 1,56,828.00 $ 136,280.00 $ 400.00 400.00 SUBTOTAL $ $ PLUMBING Months Price 202 203 242 243 244 245 246 260 261 Drain - piping Waste - piping Vent - piping $ $ $ $ Labor 300.00 300.00 300.00 Materials 1 1 Price 500 500 500 Total Material Total Labor 500 $ 300.00 500 $ 300.00 500 $ 300.00 Equipment pipe wrench, basin wrench, adjustable wrench, faucet key, hacksaw, tube and pipe cutters, pliers, press fitting system, plungers, hand auger, screwdrivers 1 0 $ $ 300.00 300.00 SUBTOTAL $0.00 900.00 $1,500.00 $ Labor Months Total Labor Price 263 264 265 266 Materials 1.00 2.00 Price Total Material $ 10,000.00 $ 10,000.00 $ 5,000.00 $ 10,000.00 $ 20,000.00 $ 20,000.00 Labor cost considered assuming 50 hours of work ELECTRICAL Service Panels Sub-Panels Rough Wiring Phone/Cable / Internet Wiring Lighting Fixtures Outlets Switches SUBTOTAL Equipment measuring tape, hammer, torpedo level, flashlight, utility knife, screwdrivers, tongue-and-groove pliers, non contact voltage tester, wire strippers, needle , nose pliers, linesman pliers, diagonal cutting pliers, fish tape, voltmeter or multimeter, wire crimpers $ $ $ S 500.00 180.00 1.00 300.00 110.00 50.00 $ $ $ 75.00 75.00 500.00 54,000.00 8,250.00 3,750.00 $ 1,06,500.00 $ $ $ 200.00 $ 3,500.00 $0.00 3,500.00 3,500.00 $ $ $ 200.00 BATH Labor Months Equipment Materials 1 Price $ 300.00 267 268 271 272 283 351 352 353 358 359 360 363 364 369 370 384 385 386 4 4 4 Fixtures Countertops Toilet Mirrors Shower Tile / Stone Materials $ 500.00 $ $ 75.00 $ $ 500.00 $ 150.00 $ 1,000.00 $ 12.50 Total Material Total Labor $ 500.00 $ 300.00 $ 2,000.00 $ 600.00 $ 4,000.00 $ 1.600.00 $ 1,600.00 $9,000.00 $ 1,600.00 Labor cost considered assuming 20 hours of work 4 4 128 $ 1,600.00 $0.00 SUBTOTAL $ 300.00 OTHER Labor Materials Total Equipment Price 0 0 Preliminary Estimate Materials Quantitative calculations + OTHER Labor Materials Total Equipment Price 0 0 0 0 384 385 386 387 398 389 390 391 392 393 204 0 0 $0.00 SUBTOTAL $0.00 $0.00 Preliminary Estimate Materials Quantitative calculations + D H I 2 Labor Foundation $ 2.60 per sq ft Total Labor Cost $ 65,520.00 A B 1 Quantitative calculations 2 3 Building Area 25200 sq. feet 4. Perimeter 660 feet 5 6 Wall height 25 feet 7 Building Length 210 feet 8 Building width 120 feet 9 Collumns 18 unit 10 Floor Thickness 6 in 11 Footing depth 12 in 12 Footing length x wide 36x36 in 13 Footing area - each 1296 sq foot 14 15 16 Walls 16500 sq feet 17 Roof Area 26536 sq foot 18 19 Concrete for foundation 20 Foundation for columns 23328 sq foot 21 Foundation for wall 330 sq foot 22 23 Concrete with finishing 24 Floor 12600 sq foot 25 26 27 28 29 30 31 32 33 34 | Preliminary Estimate Materials M Quantitative calculations A B C D E F G . 1 J K L M N JOB TITLE Warehouse 3 LABOR Materials Months Price 4 PROJECT ESTIMATE TOTALS TOTAL EQUIPMENT $0.00 TOTAL TOTAL MATERIAL LABOR $9,12,309.30 $5,20,242.06 $10,03,540.23 $5,20,242.06 Total with waste $ $ 6,615.00 5 6 22 23 24 25 26 Labor Months Price Total Labor Equipment Price SITE PREP Dumpster / Waste Removal Materials 5.00 Total Material $ 1,485.00 3 $ 99.00 Portable Restroom Facilities The WC will be executed in the first month 28 32 2.00 20.00 1 $ $ $ 150.00 120.00 $ $ 300.00 2,400.00 Surface Protection Temporary Powerl lightining Estimating the worst case, if the contractor doesn't provide $ 2,000.00 $ 2,000.00 $6,185.00 SUBTOTAL $0.00 38 40 41 103 FOUNDATION / CONCRETE Months Price 104 105 111 113 Reinforcement for the foundation Pile Caps footings - concrete Foundation - Walls Labor Price (per sq ft) $ 1.20 S 3.00 $ 3.00 Materials 2129.22 23328.00 330.00 $ $ $ Price Total Material Total Labor 40.00 $ 85,168.80 $ 2,555.06 It was consider 0.005% of 6.25 $ 1,45,800.00 $ 69,984.00 steel for each m3 of 6.25 $ 2,062.50 $ 990.00 concrete Equipment levels, tape measures, moisture retarders, saws, shovels, rakes, tampers, , , vibrators, screeds, bull floats, magnesium floats, kneeling boards, trowels, float blades, groove cutter, edger, brooms, polishers, grinders, thermohygrometers, hammer drills, concrete moisture meters, RH Test Kits S $ S 114 115 116 117 131 Floor with finishing Wire mash for the floor Steel Columns Forms for the foundation 2.60 1.20 3.00 $ 12600.00 25200.00 18.00 7.25 0.40 $ 700.00 $ 1,000.00 $ S $ $ 91,350.00 $ 32,760.00 10,080.00 $ 30,240.00 12,600.00 $ 54.00 1,000.00 $3,48,061.30 $ 1,36,583.06 $ $ 5,000.00 5,000.00 SUBTOTAL $0.00 Labor (per sa ft) 133 MASONRY / EXTERIOR WALLS Materials Months Price Total Material Total Labor Price Equipment 115V wet masonry saw, 5 cubic foot mortar box, small plate compactor Exterior Walls 134 $ 14.00 16500.00 $ 14.00 Total material price for masonry per sq foot $ $ 65.00 149 150 151 2,31,000.00 $ 2,31,000.00 0 $2,31,000.00 $ 2,31,000.00 SUBTOTAL $0.00 $ 65.00 152 WINDOWS + DOORS (Exterior) Labor Materials Months Price Total Material Total Labor Price $ $ Personal Doors 153 300.00 $ S 300.00 4.00 250.00 $ $ 1,000.00 $ 1,200.00 Equipment hammer, casing nails, level, wooden shims, screws, spray foam, trim, screwdriver, door knob kit with hardware 154 Roof Hatch $ 200.00 2.00 $ 540.00 $ 1,080.00 $ 400.00 155 Overhead Doors $ 300.00 14.00 $ 2,500.00 $ 35,000.00 $ 4,200.00 156 Skylights 28.00 WC Doors Foom for doors S $ S $ 120.00 300.00 4.00 2.00 30.00 $ $ $ 350.00 $ 200.00 $ 6.00 $ 9,800.00 $ 400.00 $ 180.00 $ $47.460.00 $ 3,360.00 600.00 120.00 157 158 167 100 SUBTOTAL 9,880.00 $ 300.00 Preliminary Estimate Materials Quantitative calculations + A B C D E F G . J K M N 168 169 FINISH Labor Materials Months Price Total Material Total Labor Price Stucco Equipment Paint roller, masking tape, ladder, drop cloth, paint brush Not consider, except requested by the owner 175 $ 187 Paint (exteriori interior) S $ 3.00 165.00 35 $ 5,775.00 $ 495.00 It was considered 1 gallon per 400 sq foot for 4.00 walls Paint for internal doors $ 2.00 45 $ 2.00 $0.00 90.00 $ $5,775.00 $ $ $ SUBTOTAL 499.00 50.00 50.00 192 193 194 195 196 Labor Months Price Materials 26536 Price Total Material Total Labor 5.50 $ 1,45,948.00 $ 1,32,680.00 $ $ 5.00 $ ROOFING Root + Drip Edge Roof Hatch Skylights Equipment fastener drivers, electric swivel head metal shears, nibblers, blade cutters, metal snips, S 2 197 198 120.00 120.00 $0.00 $ $ $ S 540.00 $ 350.00 $ $ 28 1,080.00 $ 240.00 9,800.00 $ 3,360.00 1,56,828.00 $ 136,280.00 $ 400.00 400.00 SUBTOTAL $ $ PLUMBING Months Price 202 203 242 243 244 245 246 260 261 Drain - piping Waste - piping Vent - piping $ $ $ $ Labor 300.00 300.00 300.00 Materials 1 1 Price 500 500 500 Total Material Total Labor 500 $ 300.00 500 $ 300.00 500 $ 300.00 Equipment pipe wrench, basin wrench, adjustable wrench, faucet key, hacksaw, tube and pipe cutters, pliers, press fitting system, plungers, hand auger, screwdrivers 1 0 $ $ 300.00 300.00 SUBTOTAL $0.00 900.00 $1,500.00 $ Labor Months Total Labor Price 263 264 265 266 Materials 1.00 2.00 Price Total Material $ 10,000.00 $ 10,000.00 $ 5,000.00 $ 10,000.00 $ 20,000.00 $ 20,000.00 Labor cost considered assuming 50 hours of work ELECTRICAL Service Panels Sub-Panels Rough Wiring Phone/Cable / Internet Wiring Lighting Fixtures Outlets Switches SUBTOTAL Equipment measuring tape, hammer, torpedo level, flashlight, utility knife, screwdrivers, tongue-and-groove pliers, non contact voltage tester, wire strippers, needle , nose pliers, linesman pliers, diagonal cutting pliers, fish tape, voltmeter or multimeter, wire crimpers $ $ $ S 500.00 180.00 1.00 300.00 110.00 50.00 $ $ $ 75.00 75.00 500.00 54,000.00 8,250.00 3,750.00 $ 1,06,500.00 $ $ $ 200.00 $ 3,500.00 $0.00 3,500.00 3,500.00 $ $ $ 200.00 BATH Labor Months Equipment Materials 1 Price $ 300.00 267 268 271 272 283 351 352 353 358 359 360 363 364 369 370 384 385 386 4 4 4 Fixtures Countertops Toilet Mirrors Shower Tile / Stone Materials $ 500.00 $ $ 75.00 $ $ 500.00 $ 150.00 $ 1,000.00 $ 12.50 Total Material Total Labor $ 500.00 $ 300.00 $ 2,000.00 $ 600.00 $ 4,000.00 $ 1.600.00 $ 1,600.00 $9,000.00 $ 1,600.00 Labor cost considered assuming 20 hours of work 4 4 128 $ 1,600.00 $0.00 SUBTOTAL $ 300.00 OTHER Labor Materials Total Equipment Price 0 0 Preliminary Estimate Materials Quantitative calculations + OTHER Labor Materials Total Equipment Price 0 0 0 0 384 385 386 387 398 389 390 391 392 393 204 0 0 $0.00 SUBTOTAL $0.00 $0.00 Preliminary Estimate Materials Quantitative calculations + D H I 2 Labor Foundation $ 2.60 per sq ft Total Labor Cost $ 65,520.00 A B 1 Quantitative calculations 2 3 Building Area 25200 sq. feet 4. Perimeter 660 feet 5 6 Wall height 25 feet 7 Building Length 210 feet 8 Building width 120 feet 9 Collumns 18 unit 10 Floor Thickness 6 in 11 Footing depth 12 in 12 Footing length x wide 36x36 in 13 Footing area - each 1296 sq foot 14 15 16 Walls 16500 sq feet 17 Roof Area 26536 sq foot 18 19 Concrete for foundation 20 Foundation for columns 23328 sq foot 21 Foundation for wall 330 sq foot 22 23 Concrete with finishing 24 Floor 12600 sq foot 25 26 27 28 29 30 31 32 33 34 | Preliminary Estimate Materials M Quantitative calculations