FINAL ESTIMATES LEVEL 2, Exams of Marketing Business-to-business (B2B)

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

2025/2026

Available from 02/09/2026

EliteCo
EliteCo šŸ‡ŗšŸ‡ø

2

(1)

630 documents

1 / 53

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35

Partial preview of the text

Download FINAL ESTIMATES LEVEL 2 and more Exams Marketing Business-to-business (B2B) in PDF only on Docsity!

Which of the following is an authorized way to modify the contract, once it has been executed?

  • ANSWER=Work Orders and Supplimental Agreements Of the Contract Documents listed below which one would govern? - ANSWER=Special Provisions Why is it important to run a progress estimate soon after Final Acceptance? - ANSWER=So the estimate can be paid through EED quickly to prevent interest. On Financial Project No.000101- 1 - 52 - 01, which is a conventional project, the notice to proceed is dated December 1, 2015 and the contract time is to start 16 days after the Notice to Proceed per the contract. The Contractor begins work on December 18, 2015 and the project is Final Accepted on December 31, 2015. There are no added weather or other reasons. What is the 1st chargeable day and how many total days should be recorded in the Contract Time File? - ANSWER=12/17/2015 with 15 chargeable days. On Lump Sum Contracts, upon Final Acceptance, the Project Administrator will send? - ANSWER=The Offer of Final Payment Field Records for multiple jobs, same contract, should be kept? - ANSWER=In seperate Field Books & In seperate files within Project Solve and EDMS On Lump Sum Project, A Superpave Asphalt Course item requires a Composite Pay Factor (CPF) adjustment. What is the total dollar adjustment amount? Lot 1 with 2000 Tons and a CPF of 0.

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?

  • ANSWER=Work Orders and Supplimental Agreements Of the Contract Documents listed below which one would govern? - ANSWER=Special Provisions Why is it important to run a progress estimate soon after Final Acceptance? - ANSWER=So the estimate can be paid through EED quickly to prevent interest. On Financial Project No.000101- 1 - 52 - 01, which is a conventional project, the notice to proceed is dated December 1, 2015 and the contract time is to start 16 days after the Notice to Proceed per the contract. The Contractor begins work on December 18, 2015 and the project is Final Accepted on December 31, 2015. There are no added weather or other reasons. What is the 1st chargeable day and how many total days should be recorded in the Contract Time File? - ANSWER=12/17/2015 with 15 chargeable days. On Lump Sum Contracts, upon Final Acceptance, the Project Administrator will send? - ANSWER=The Offer of Final Payment Field Records for multiple jobs, same contract, should be kept? - ANSWER=In seperate Field Books & In seperate files within Project Solve and EDMS On Lump Sum Project, A Superpave Asphalt Course item requires a Composite Pay Factor (CPF) adjustment. What is the total dollar adjustment amount? Lot 1 with 2000 Tons and a CPF of 0.

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