













































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This study material is a compilation of test questions and answers covering two distinct professional development areas. The first section (pages 1-22) addresses the Construction Training and Qualification Program (CTQP) Final Estimates Level 2 certification, focusing on Florida Department of Transportation (FDOT) construction project documentation, earthwork calculations, and contract adjustments (e.g., asphalt tonnage, liquidated damages). The second section (pages 23-44) is an Excel Level 2 guide, with multiple-choice questions on advanced spreadsheet features such as conditional formatting, built-in functions (VLOOKUP, COUNTIF), PivotTables, data validation, and collaborative workbook options.
Typology: Exams
1 / 53
This page cannot be seen from the preview
Don't miss anything!














































Which of the following is an authorized way to modify the contract, once it has been executed?
Lot 2 with 4000 Tons and CPF of 0. Lot 3 with 4000 Tons and CPF of 1. Lot 4 with 4000 Tons and a CPF of 1.00 - ANSWER=$5425. Under the current Specifications for Lump Sum Projects, the Project Administrator will approve and pay the Final Estimate? - ANSWER=False Original Terrain line sections: - ANSWER=A)Represent the terrain prior to Contruction B) Are necessary to establish earthwork quantities C) Must be shown on cross sections. ALL OF THE ABOVE The plans show the designer calculations for Clearing & Grubbing with a total of 3.2 Acres to be cleared and grubbed. During the Construction, a plan error was encountered which required the clearing and grubbing of an additional 800 SY. This required an adjustment to the original Lump Sum Pay Item. Calculate the adjusted Final Pay Quantity. The secondary unit is in Acres not SY. Note 1 Acre= 4840 SY: Pay Item= Clearing and grubbing Original Quantity = 1.0 Lump Sum - ANSWER=3.2 Ac x 4840 SY= 15488 SY 15488 + 800 SY = 16288 SY 16288 SY/15488 SY = 1.052 Lump Sum
On a dual FIN Project under one Contract: Project A has 20,000 tons and Project B has 25, tons. the total tonnage for the contract =45,000 tons. The tonnage placed for the month= tons. Determine how many tons should be reported on each project for this month. - ANSWER=A) 20,000/45,000 =0.444 X 4525 Tons= 2011.1 TNS B) 25,000/45,000 = 0.556 X 4525 Tons= 2513.9 TNS On a new construction project, the length of conduit for a signalization job located under a utility strip & between the back of curb and front of sidewalk is paid for as? - ANSWER=As underground conduit. On design build Contracts, the Contractor will receive monthly progress payments based on? - ANSWER=Monthly Estimates On Conventional jobs, concrete class IV (superstructure) methos of measurement is? - ANSWER=Plan Quantities Using the Current Specifications and the attached Summary Tables what is the pay quantity for the concrete production pile? (80' authorized pile length) - ANSWER=80 ft Determine the adjusted plan quantity tonnage and the maximum tonnage that can be paid for Miscllaneous Asphalt based on the current Specifications, which allows a maximum pay of 105% of the adjusted plan quantity tons. ( pay to the appropriate accuracy) Plan Quantity Area (SY) =700 SY ( no revisions)
Plan Quantity Tons: 70.0 Tons based on 2" thick per specs Adjusted PQ Tonnage Placed =75.2 Tons from report Gmm fromSpecs = 2.540 and Target Spread Rate =220 Lbs/SY Gmm from Mix 1: 2.522 and tonnage- weighted Gmm=2.55 Lbs/SY - ANSWER=69.5 Tons and max pay 73.0 Tons Find the total thickness on a composite base which includes 4 inches of Limerock Base and 4 inches of type B (12.5) Asphalt Base given the following information: Limerock Base Thickness from Core Out Report =4.19" Asphalt (12.5) Base: Gmm =2.365 from the design mix Average Spread Rate from the roadway report= 429 Lbs/SY - ANSWER=Gmm x 43.3 =102. 429 / 102.4 = 4.19" 4.19" + 4.19" = Total 8.38 inches On an open graded Friction Course (FC-5) Pavement, a straightedge deficiency was left in place at no pay. Calculate the equivalent tonnage at no pay. ( Pay to the appropriate accuracy) Lane Width =12 ft Location of Deficiency= STA 1+56 to STA 1+67 ( 167-156=11) - ANSWER=Lx Wx. L=50'+11'+50' = 111' 111' X 12' X 0.0044 = 5.9 TNS
Determine the Total Volumes of original and final Subsoils: - ANSWER=497+353= 353+312=665 =1515 x100=151,500/54= 445+259= 259+446=705=1409x100+140,900/54=2609. Final Plans that have no changes are? - ANSWER=Required to be signed by the Resident Engineer using appropriate statements. How is extra depth subsoil (5'-15' below plan elevation) paid? - ANSWER=Extra depth subsoil excavation at Contract unit price plus 25% How is extra depth subsoil (greater than 15' below plan elevation) paid? - ANSWER=Extra depth subsoil excavation paid for as extra work What are the limits to paying for extra depth subsoil? - ANSWER=No pay for extra depth subsoils outside the 1:2 slope The submittal of the "Contractors Compliance with Specifications & Plans" form must? - ANSWER=A)Note all material exceptions B)Be signed by the contractor C)Be submitted monthly with the partial estimates ALL OF THE ABOVE
Determine the final pay quantity for each project under one contract for the following plan Quantity ietms, based on the current Specifications. Project 1) Planned Quantity 3,000 LF, Planned errors = +98LF, Authorized change amount =+25LF Project 2)Planned Quantity 2000 LF, Planned errors = +300LF, Authorized change amount = - 45LF - ANSWER=Project 1) 3123 LF Project 2) 2255 LF Conduit could be? - ANSWER=A) Open trench or Jack and Bore B) Above ground and Bridge Mount C) Bore under railroad ALL OF THE ABOVE Surge protection devices are under? - ANSWER=Grounding and lighting protection, Section 620 of the Specifications. The contractor has to request to work during the holiday in order to receive a Holiday extension if the holiday falls within his normal workweek schedule? - ANSWER=False Determine the pay area (SY) and pay adjustment (SY) for Superpave Asphalt Base (Pay Item 285) based on the information provided below. The maximum pay is not to exceed 105%? - ANSWER=Planned Qty 40, Thickness 6" - two layers 3" each
Material samples should be checked at what frequency to ensure sampling is in compliance? - ANSWER=Monthly On multi FIN project numbers under one contract, the Asphalt is reported on the certification, by the CONTRACTOR, under what Project FIN Number? - ANSWER=The Contractor shows the Asphalt on the lead FIN project number A roadway is being constructed and has a Subsoil Excavation Quantity of 835 CY, a Regular Excavation Quantity of 250 CY and an embankment Quantity of 1040 CY. Based upon this information, the Final Quantity to be paid for embankment will be? - ANSWER=1875 CY Which Document is used to authorize payment from original contingency Amount? - ANSWER=Work Order Friction Course (FC-12.5) Straight edge Deficiency: A straightedge deficiency was left in place at no pay. Calculate the equivalent tonnage at no pay. ( pay to appropriate accuracy) Gmm= 2.417, thickness =1.5 inches, road width =12 feet, length of deficiency = 5 ft. (this occurred 25 feet from the bridge deck) - ANSWER=8.4 Tons Overruns or Underruns must be explained when? - ANSWER=A pay item overruns or underruns $10,000 or more. Prices are adjusted on each progress estimate to reflect increases or decreases in the price of fuel for contracts with original Contract Time: - ANSWER=In excess of 120 calendar days.
Which of the following is an authorized way to modify the contract, once it has been executed?
The Prime Contractor is required to certify previous payments for? - ANSWER=1st tier Subcontractors and Suppliers Borrow Excavation is paid for as a? - ANSWER=Final Measurement When should Liquidated Damages be reflected on a progress estimate? - ANSWER=(**Begins after Contract time runs out up to the estimate cut off date. Liquidated Damages are withheld monthly.) ON SUBSEQUENT PROGRESS REPORTS Final Measurements are to be documented on which of the following? - ANSWER=A)Miscellaneous Forms B)Field Books C)Directly on Plan Summary Boxes ALL OF THE ABOVE If the Resident Office receives an unpaid bill notice, what should the Resident Office do? - ANSWER=A)Respond in writing to the Prime Contractor B)Send a copy to the DFEM C)Copy the Subcontractor ALL OF THE ABOVE
On a dual FIN Project under one Contract: Project A has 20,000 tons and Project B has 25, tons. the total tonnage for the contract =45,000 tons. The tonnage placed for the month= tons. Determine how many tons should be reported on each project for this month. - ANSWER=A) 20,000/45,000 =0.444 X 4525 Tons= 2011.1 TNS B) 25,000/45,000 = 0.556 X 4525 Tons= 2513.9 TNS On a new construction project, the length of conduit for a signalization job located under a utility strip & between the back of curb and front of sidewalk is paid for as? - ANSWER=As underground conduit. On design build Contracts, the Contractor will receive monthly progress payments based on? - ANSWER=Monthly Estimates On Conventional jobs, concrete class IV (superstructure) methos of measurement is? - ANSWER=Plan Quantities Using the Current Specifications and the attached Summary Tables what is the pay quantity for the concrete production pile? (80' authorized pile length) - ANSWER=80 ft Determine the adjusted plan quantity tonnage and the maximum tonnage that can be paid for Miscllaneous Asphalt based on the current Specifications, which allows a maximum pay of 105% of the adjusted plan quantity tons. ( pay to the appropriate accuracy) Plan Quantity Area (SY) =700 SY ( no revisions)
Lot 3 has a Tonnage of 2529.0 tons with a Composite Pay Factor of 1.04. What would the calculated Composite Pay Factor adjustment amount be if the unit price is $100.00 per ton? - ANSWER=(CPF-1) = Unit price (1.04-1) $100= 4 $4/ton x 2529 tn= $10, As items in the feild are completed,within 30 days, you will need to have the supporting documentation available to support the pay item in the? - ANSWER=Plan Summary Boxes Using the current Specifications and the attached Summary Tables, what is the pay quantity for this steel test pile? ( 60' Authorized pipe length) - ANSWER=60' On the plan quantity item, what describes the criteria of a plan error? - ANSWER=B)A difference between the original plan quantity and the final quantity or more than 5% C) Any change in quantity which causes a change in the amount payable of more than $ For Limerock base the pay area shall not exceed 105% of the surface area. What is the total square yards that will be paid for given the following information? Surface area = 30,000 SY Design thickness=8 in Core out report= 7.65 in - ANSWER=7.65/8=.95625 x30000 = 28688 SY
Determine the Total Volumes of original and final Subsoils: - ANSWER=497+353= 353+312=665 =1515 x100=151,500/54= 445+259= 259+446=705=1409x100+140,900/54=2609. Final Plans that have no changes are? - ANSWER=Required to be signed by the Resident Engineer using appropriate statements. How is extra depth subsoil (5'-15' below plan elevation) paid? - ANSWER=Extra depth subsoil excavation at Contract unit price plus 25% How is extra depth subsoil (greater than 15' below plan elevation) paid? - ANSWER=Extra depth subsoil excavation paid for as extra work What are the limits to paying for extra depth subsoil? - ANSWER=No pay for extra depth subsoils outside the 1:2 slope The submittal of the "Contractors Compliance with Specifications & Plans" form must? - ANSWER=A)Note all material exceptions B)Be signed by the contractor C)Be submitted monthly with the partial estimates ALL OF THE ABOVE