excel

profileMudiab655
CM5521WQ2019Calculationsworkbook1HW2duenextweek.xlsx
Home>Architecture and Design homework help>excel

Sheet1

Nomencature
Calculated Cells are RED
Input Cells are BLUE

Payback

Change fixtures to LED Formula
Fixtures/ hr 4
Number of 4' fixtures 170
Number of hours 42.5 =B3/B2
Days to complete 5
Cost of fixtures $ 6,460.00 $ 38.00 ea =B3*C6
Mobilization $ 250.00
Rental $ 500.00
Labor $ 3,938.00 =B5*8*B27
Project cost (I) $ 11,148.00 =SUM(B6:B9)
Annual Hours of use Life of lamps in hours Years of service
2,000 50,000 25 =C12/B12
Price /KWH watts/fixture hourly savings per fixture
0.26 37 $ 0.010 =B14/1000*A14
Cash flows ( R ) $ 3,270.80 per year =B12*C14*B3
Payback period ( P ) 3.41 years =B10/B16
Laborer $ 19.99
Gr. 4 Apprentice $ 22.57
Journeyman $ 55.89
Crew / hr $ 98.45 =SUM(B24:B26)

SDI-2016-2

GENERAL PREVAILING WAGE DETERMINATION MADE BY THE DIRECTOR OF INDUSTRIAL RELATIONS
PURSUANT TO CALIFORNIA LABOR CODE PART 7, CHAPTER 1, ARTICLE 2, SECTIONS 1770, 1773 AND 1773.1
FOR COMMERCIAL BUILDING, HIGHWAY, HEAVY CONSTRUCTION AND DREDGING PROJECTS
LOCALITY: SAN DIEGO COUNTY
DETERMINATION: SDI-2016-2 EMPLOYER PAYMENTS STRAIGHT-TIME OVERTIME HOURLY RATE CONTRACT PROVISIONS
CRAFT (JOURNEY LEVEL) ISSUE DATE EXPIRATION DATE BASIC HOURLY RATE HEALTH AND WELFARE PENSION VACATION/ HOLIDAY TRAINING OTHER PAYMENTS HOURS TOTAL HOURLY RATE DAILY SATURDAY SUNDAY AND HOLIDAY HOLIDAYS SCOPE OF WORK TRAVEL & SUBSISTENCE PREDETERMINED INCREASE
# BRICKLAYER: 2/22/16 10/31/2016** A 34.440 8.500 7.940 - B 0.770 0.100 C 8.0 51.750 D 68.970 D 68.970 86.190 018-00004-008 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/018-4-8-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/018-4-8-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/018-4-8-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/018-4-8-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
MASON FINISHER 2/22/16 10/31/2016* A 26.370 8.500 7.940 - B 0.690 0.100 C 8.0 43.600 D 56.790 D 56.790 69.970 018-00004-008 (15) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/018-4-8-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/018-4-8-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/018-4-8-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/018-4-8-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# BRICK TENDER 2/22/16 10/31/2016** 29.120 6.100 6.600 E 4.160 0.370 0.340 8.0 46.690 F 61.250 G 61.250 75.810 102-00089-002 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/102-89-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/102-89-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/102-89-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/102-89-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# CARPET LAYER:
RESILIENT TILE LAYER 2/22/16 06/30/2016* 26.770 6.000 6.380 0.700 0.450 0.150 8.0 40.450 F 53.830 H 53.830 67.220 200-01399-002 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/200-1399-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/200-1399-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/200-1399-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/200-1399-2-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# DRYWALL FINISHER 2/22/15 03/31/2015* & 15.000 7.050 3.000 3.070 0.670 - 8.0 28.790 I 36.290 I 36.290 I 36.290 830-00200-004 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/830-200-4-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/830-200-4-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/830-200-4-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/830-200-4-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# ELECTRICIAN:
INSIDE WIREMAN, TECHNICIAN 8/22/16 09/30/2016** 42.250 6.910 J 4.350 - 0.870 0.240 8.0 55.890 K 77.650 K 77.650 99.410 061-00569-002 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
CABLE SPLICER 8/22/16 09/30/2016** 43.000 6.910 J 4.350 - 0.870 0.240 8.0 56.660 K 78.810 K 78.810 100.950 061-00569-002 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
TUNNEL WIREMAN 8/22/16 09/30/2016** 47.530 6.910 J 4.350 - 0.870 0.240 8.0 61.330 K 85.800 K 85.800 110.280 061-00569-002 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
TUNNEL CABLE SPLICER 8/22/16 09/30/2016** 48.280 6.910 J 4.350 - 0.870 0.240 8.0 62.100 K 86.960 K 86.960 111.830 061-00569-002 (40) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
SOUND AND SIGNAL TECHNICIAN 8/22/16 06/04/2017** 30.220 6.910 J 3.620 - 0.810 0.110 8.0 42.580 F 58.140 L 58.140 73.700 061-00569-014 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-14-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-14-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-14-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-14-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
M STREETLIGHTING, TRAFFIC SIGNAL, UNDERGROUND SYSTEMS JOURNEYMAN TECHNICIAN GRADE 1 2/22/16 09/30/2016* 29.500 5.670 J 1.500 - 0.250 0.170 8.0 37.980 53.180 53.180 68.370 061-00569-016 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-16-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
M TECH GRADE 2 2/22/16 09/30/2016* 24.650 5.670 J 1.500 - 0.250 0.170 8.0 32.980 45.670 45.670 58.360 061-00569-016 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-16-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
M TECH GRADE 3 2/22/16 09/30/2016* 22.500 5.670 J 1.500 - 0.250 0.170 8.0 30.770 42.360 42.360 53.950 061-00569-016 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-16-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
M TECH GRADE 4 2/22/16 09/30/2016* 16.000 5.670 J - - 0.250 0.170 8.0 22.570 30.810 30.810 39.050 061-00569-016 (40) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-16-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
M TECH GRADE 5 2/22/16 09/30/2016* 13.500 5.670 J - - 0.250 0.170 8.0 19.990 26.950 26.950 33.900 061-00569-016 (50) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/061-569-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/061-569-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/061-569-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/061-569-16-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# FIELD SURVEYOR:
N CHIEF OF PARTY (018.167-010) 2/22/16 09/30/2016* 44.810 11.200 9.650 E 4.150 0.900 0.150 8.0 70.860 O 93.260 O 93.260 115.670 063-00012-003 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/063-12-3-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/063-12-3-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/063-12-3-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/063-12-3-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
N INSTRUMENTMAN (018.167-034) 2/22/16 09/30/2016* 42.310 11.200 9.650 E 4.150 0.900 0.150 8.0 68.360 O 89.510 O 89.510 110.670 063-00012-003 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/063-12-3-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/063-12-3-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/063-12-3-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/063-12-3-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
N CHAINMAN/RODMAN (869.567-010) 2/22/16 09/30/2016* 41.730 11.200 9.650 E 4.150 0.900 0.150 8.0 67.780 O 88.650 O 88.650 109.510 063-00012-003 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/063-12-3-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/063-12-3-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/063-12-3-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/063-12-3-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# GLAZIER 2/22/16 09/30/2016** P 40.800 7.780 9.300 - 0.580 0.350 Q 8.0 58.810 R 79.210 R 79.210 99.610 200-01399-001 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/200-1399-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/200-1399-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/200-1399-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/200-1399-1-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# MARBLE FINISHER 8/22/16 05/31/2017* S 29.200 9.250 2.830 - 0.850 0.330 T 8.0 42.460 U 57.060 V 57.060 W 71.660 162-00018-001 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/162-18-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/162-18-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/162-18-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/162-18-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# PAINTER
X INDUSTRIAL PAINTER 8/22/16 06/30/2017** A 32.520 8.050 3.040 1.550 0.700 0.910 8.0 46.770 Y 63.030 Y 63.030 Y 63.030 200-00000-002 (80) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/200-X-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/200-X-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/200-X-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/200-X-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# PAINTER:
X PAINTER, LEAD ABATEMENT 8/22/16 06/30/2017** A 31.120 8.050 3.040 1.550 0.600 0.910 8.0 45.270 Y 60.830 Y 60.830 Y 60.830 200-00000-002 (40) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/200-X-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/200-X-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/200-X-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/200-X-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# PLASTERER 8/22/16 08/01/2017** 34.410 9.130 4.210 Z 5.580 0.630 0.990 AA 8.0 54.950 Y 72.150 AB 72.150 89.360 203-00000-002 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/203-X-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/203-X-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/203-X-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/203-X-2-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# AC PLASTER TENDER 8/22/16 08/01/2017** 34.150 7.060 6.150 Z 5.050 1.020 1.020 8.0 54.450 AD 71.530 AE 71.530 88.600 102-00000-016 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/102-X-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/102-X-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/102-X-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/102-X-16-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
PLASTER CLEAN-UP LABORER 8/22/16 08/01/2017** 31.600 7.060 6.150 Z 5.050 1.020 1.020 8.0 51.900 AD 67.700 AE 67.700 83.500 102-00000-016 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/102-X-16-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/102-X-16-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/102-X-16-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/102-X-16-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# PLUMBER:
PLUMBER, INDUSTRIAL AND GENERAL PIPEFITTER 8/22/16 06/30/2017** S 44.160 8.160 AF 11.400 AG 3.030 1.850 AH 1.100 8.0 69.700 AI 92.500 AI 92.500 113.780 204-00000-006 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(1)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(1)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
SEWER AND STORM DRAIN PIPELAYER 8/22/16 06/30/2017** S 33.870 8.050 AF 8.550 AG 1.000 1.580 AH 1.100 8.0 54.150 70.790 AJ 70.790 86.920 204-00000-006 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(1)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(1)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
AK SEWER AND STORM DRAIN PIPE TRADESMAN 8/22/16 06/30/2017** S 17.410 8.050 0.380 - 1.010 AH 0.950 8.0 27.800 35.710 AJ 35.710 43.610 204-00000-006 (25) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(1)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(1)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
SERVICE & REPAIR (PLUMBER/HVAC-FITTER) 8/22/16 06/30/2017** S 42.700 8.160 AF 11.090 AG 3.030 1.180 AH 1.100 8.0 67.260 89.330 AL 89.330 AM 109.880 204-00000-006 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(Service)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(Service)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
LANDSCAPE/IRRIGATION FITTER 8/22/16 06/30/2017** S 28.340 8.160 AF 11.400 AG 2.490 1.240 AH 0.900 AJ 8.0 52.530 67.950 67.950 82.120 204-00000-006 (60) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(1)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(1)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
AN LANDSCAPE/IRRIGATION TRADESMAN 8/22/16 06/30/2017* S 14.110 2.000 AF 0.880 - 0.100 AH 0.850 AJ 8.0 17.940 25.000 25.000 32.050 204-00000-006 (65) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-X-6(1)-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-X-6(1)-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-X-6-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-X-6-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
FIRE SPRINKLER FITTER (PROTECTION AND CONTROL SYSTEMS, OVERHEAD AND UNDERGROUND) 8/22/16 12/31/2016** 37.670 8.770 AO 10.340 - 0.450 0.250 8.0 57.480 76.320 76.320 95.150 204-00669-001 (40) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/204-669-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/204-669-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/204-669-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/204-669-1-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
# ROOFER 8/22/16 06/30/2017* AP 27.730 6.000 1.620 - 0.300 - 8.0 35.650 49.150 AQ 49.150 W 62.650 232-00045-001 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/232-45-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/232-45-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/232-45-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/232-45-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
PITCH WORK 8/22/16 06/30/2017* AP 29.230 6.000 1.620 - 0.300 - 8.0 37.150 51.400 AQ 51.400 W 65.650 232-00045-001 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/232-45-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/232-45-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/232-45-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/232-45-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# SHEET METAL WORKER (HVAC) 8/22/16 06/30/2017** A 36.860 AR 8.220 AS 15.550 - AT 0.780 AU 0.540 AJ 8.0 61.950 AI 80.380 AI 80.380 98.810 166-00206-001 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/166-206-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/166-206-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/166-206-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/166-206-1-Sft.PDF HOLIDAYS SCOPE TRAVEL INCREASE
AV SHEET METAL TECHNICIAN 8/22/16 06/30/2017* A 27.680 AR 5.570 AS 1.250 - AT 0.730 AU 0.490 AJ 8.0 35.720 AI 49.560 AI 49.560 63.400 166-00206-001 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/166-206-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/166-206-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/166-206-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/166-206-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
AW UTILITY WORKER 8/22/16 06/30/2017* 13.000 AR 5.170 AX - - AT 0.450 AU 0.490 AJ 8.0 19.110 AI 25.610 AI 25.610 32.110 166-00206-001 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/166-206-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/166-206-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/166-206-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/166-206-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# TERRAZZO FINISHER 8/22/14 08/31/2015* P 27.530 7.510 3.270 AY - 0.490 0.120 AJ 8.0 38.920 U 52.690 V 52.690 W 66.450 018-00018-002 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/018-18-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/018-18-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/018-18-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/018-18-2-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# TERRAZZO WORKER 8/22/14 08/31/2015* P 34.570 8.300 3.270 AY - 0.570 0.120 AJ 8.0 46.830 U 64.110 V 64.110 W 81.400 018-00018-002 (10) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/018-18-2-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/018-18-2-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/018-18-2-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/018-18-2-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# TILE FINISHER 8/22/16 05/31/2016* S 24.530 8.430 1.890 - 0.760 0.280 T 8.0 35.890 U 48.160 V 48.160 W 60.420 162-00018-001 (20) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/162-18-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/162-18-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/162-18-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/162-18-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
# TILE LAYER 8/22/16 05/31/2016* S 35.890 9.250 6.030 - 0.960 0.370 T 8.0 52.500 U 70.440 V 70.440 W 88.390 162-00018-001 (30) http://www.dir.ca.gov/OPRL/2016-2/PWD/Holidays/162-18-1-Hol.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Scope/162-18-1-Sco.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Travel/162-18-1-Tra.PDF http://www.dir.ca.gov/OPRL/2016-2/PWD/Shift/162-18-1-Sft.PDF HOLIDAYS SCOPE TRAVEL NO INCREASE
FOOTNOTES

net of inflation discount rate

nett of inflation discount rate’
Interest rate 6.75% 4.4521% =((1+C40)/(1+C42))-1
Inflation rate 2.20%
ndr= 4.4521%

Net Preset Value

T $ 500.00
$ 296.73 =C24/(1+C26)^C28
Rate ( r ) 11.00%
term (n) 5 years
PV = $ 296.73

Net Preset Value 2

Net Present Value Tabular Method
Tax Rate 35%
ndr 4.70%
Year Expenditure Tax Influence Net Cash 1/(1+r) PV
0 (1,500.00) 131.25 (1,368.75) 1.00000 (1,368.75)
1 (100.00) 35.00 (65.00) 0.95511 (62.08)
2 (100.00) 35.00 (65.00) 0.91223 (59.30)
3 (500.00) 175.00 (325.00) 0.87128 (283.17)
4 (100.00) 35.00 (65.00) 0.83217 (54.09)
5 500.00 (175.00) 325.00 0.79482 258.32
6 - 0 - 0 0.75914 - 0
7 - 0 - 0 0.72506 - 0
8 - 0 - 0 0.69251 - 0
9 - 0 - 0 0.66142 - 0
10 - 0 - 0 0.63173 - 0
11 - 0 - 0 0.60337 - 0
12 - 0 - 0 0.57629 - 0
13 - 0 - 0 0.55042 - 0
14 - 0 - 0 0.52571 - 0
15 - 0 - 0 0.50211 - 0
16 - 0 - 0 0.47957 - 0
17 - 0 - 0 0.45804 - 0
18 - 0 - 0 0.43748 - 0
19 - 0 - 0 0.41784 - 0
NPV (1,569.07)

NPV Assign 2

Net Present Value Tabular Method
Capitol Cost $6,370.80
Tax Rate 0%
ndr 1.46%
Year Expenditure Tax Influence Net Cash 1/(1+r) PV
0 (1,274.16) - 0 (1,274.16) 1.00000 (1,274.16)
1 (1,274.16) - 0 (1,274.16) 0.98558 (1,255.78)
2 (1,274.16) - 0 (1,274.16) 0.97136 (1,237.67)
3 (1,274.16) - 0 (1,274.16) 0.95735 (1,219.82)
4 (1,274.16) - 0 (1,274.16) 0.94354 (1,202.23)
5 0.92994 - 0
6 - 0 - 0 0.91652 - 0
7 - 0 - 0 0.90330 - 0
8 - 0 - 0 0.89028 - 0
9 - 0 - 0 0.87744 - 0
10 - 0 - 0 0.86478 - 0
11 - 0 - 0 0.85231 - 0
12 - 0 - 0 0.84002 - 0
13 - 0 - 0 0.82790 - 0
14 - 0 - 0 0.81596 - 0
15 - 0 - 0 0.80419 - 0
16 - 0 - 0 0.79259 - 0
17 - 0 - 0 0.78116 - 0
18 - 0 - 0 0.76989 - 0
19 - 0 - 0 0.75879 - 0
NPV (6,189.66)

Net Preset Value 2 (2)

Net Present Value Tabular Method
$5.00 per yr for 20 years
Tax Rate 0%
ndr 4.70%
Year Expenditure Tax Influence Net Cash 1/(1+r) PV
0 (5.00) - 0 (5.00) 1.00000 (5.00)
1 (5.00) - 0 (5.00) 0.95511 (4.78)
2 (5.00) - 0 (5.00) 0.91223 (4.56)
3 (5.00) - 0 (5.00) 0.87128 (4.36)
4 (5.00) - 0 (5.00) 0.83217 (4.16)
5 (5.00) - 0 (5.00) 0.79482 (3.97)
6 (5.00) - 0 (5.00) 0.75914 (3.80)
7 (5.00) - 0 (5.00) 0.72506 (3.63)
8 (5.00) - 0 (5.00) 0.69251 (3.46)
9 (5.00) - 0 (5.00) 0.66142 (3.31)
10 (5.00) - 0 (5.00) 0.63173 (3.16)
11 (5.00) - 0 (5.00) 0.60337 (3.02)
12 (5.00) - 0 (5.00) 0.57629 (2.88)
13 (5.00) - 0 (5.00) 0.55042 (2.75)
14 (5.00) - 0 (5.00) 0.52571 (2.63)
15 (5.00) - 0 (5.00) 0.50211 (2.51)
16 (5.00) - 0 (5.00) 0.47957 (2.40)
17 (5.00) - 0 (5.00) 0.45804 (2.29)
18 (5.00) - 0 (5.00) 0.43748 (2.19)
19 (5.00) - 0 (5.00) 0.41784 (2.09)
NPV (66.93)