Project Quantity Reports
Hit the Roadway Running - Streamlining DOT Project Costs using PCM Session ID#: 201300
Bexar County Public Works Department San Antonio, TX
Prepared by: Donna Coleman Senior Consultant/President Samsara Project Technology, LLC
REMINDER Check in on the COLLABORATE mobile app
Types of Projects ■ Flood Control Program ■ TxDOT Pass-through Finance Projects* * Presentation focus
Modules Used in Pass-through Projects ■ Companies
■ Committed Contracts*
■ RFIs
■ Materials Delivery*
■ Daily Reports*
■ Payment Requisitions*
■ Notepads
■ Change Orders*
■ Corr Received
■ Cost Worksheet*
■ Submittals * Modules to be discussed
What is a Pass-through Finance Project?
■ Pass-through financing allows local communities to fund upfront costs for constructing a state highway project. The state then reimburses a portion of the project cost to the community over time by paying a fee for each vehicle that drives on the new highway. Projects must be on the state highway system to be eligible to be developed under this program.
Project Team ■ Engineering Consultant/Construction Manager (CM) ■ Bexar County Public Works Construction Administration Engineer ■ Bexar County Public Works Project Manager ■ Contractor
TxDOT Procedures ■ Daily Requirements ▪ TxDOT 1257 Work Report form must be filled out daily —
Records the quantity of each pay item completed
—
One 1257 per Contract pay item
—
Location of Work Performed and how Quantity was determined
■ Monthly Requirements ▪ Monthly Estimate —
Every line must have a unique number
—
Every item must have a TxDOT Cost Element associated
▪ Time Statement —
Identifies every Work and Non-Work day in calendar year
PCM Module Translation ■ TxDOT 1257 Work Report
= Materials Delivery
■ Time Statement
= Daily Report custom fields
■ Monthly Estimate
= Payment Requisition
Customizations to PCM ■ Custom fields in Daily Report for Time Statement ■ Time Statement report ■ Renamed Materials module to Project Quantities ■ Renamed Materials tab in Daily Reports - Project Quantities ■ Custom Project Quantity Reports ■ Custom Monthly Estimate form (Payment Requisition)
Project Quantities Module (Materials) ■ Contractor’s contract entered as line item based Committed Contract ■ Materials generated from Contract as Project Quantity “folders”
■ Delivery Tickets (renamed Completed Progress) entered via Daily Report
DEMO
This is a subtitle or bulleted list
Daily Report Module ■ Inspectors (hired by CM) use Daily Report module ■ Inspectors fill out 1257, then record work performed using Project Quantities tab within Daily Report ■ 1257 is scanned and attached on Attachments tab of the corresponding quantity entered
TXDot 1257 Work Report
DEMO
This is a subtitle or bulleted list
Project Quantity Reports ■ Quantities not yet Requisitioned report ▪ Used at end-of-month Project Meeting, for everyone to agree on quantities ▪ Used prior to generating monthly estimate
■ “Jim Brannan report” ▪ Prompt for criteria on TxDOT item codes, then reports which payment requisitions quantities have been applied/invoiced and date it was created
Payment Requisitions ■ Generated monthly ■ Project Quantities (aka materials) are “gotten” into each payment requisition ■ Invoice is built automatically for Contractor’s payment
DEMO
This is a subtitle or bulleted list
Change Orders ■ Line item based, like the Contract ■ Added to the monthly estimate as an additional line for each change item ■ New estimate line items renumbered to sort under each change’s original contract pay item ■ Project Quantity folders created manually to allow quantities for each new change line item
Questions?
This is a subtitle or bulleted list
Please complete the session evaluation We appreciate your feedback and insight
You may complete the session evaluation either on paper or online via the mobile app
OPSIG is the home for Primavera Users ■ Our purpose is to inform and educate our members on current and future functionality of Oracle Primavera products, while offering a forum for peers to share their experience and knowledge in the use of Primavera.
■ Educational opportunities across the Primavera product suite ■ Online Learning Series August 17th – September 4th ■ Call for presentation opening April 27th
■ Monthly Community Calls ■ 3rd Thursday of the month at 1:00 pm ET ■ Networking with other users within the Primavera community
■ Partnering with Oracle Primavera to meet the needs of our diverse membership. ■ Membership is open to anyone with an interest in the Oracle Primavera products, with no dues for membership. All members can vote on matters brought before the OPSIG. Membership requests may be reviewed by the OPSIG board.
Bexar County Public Works Department San Antonio, TX
Prepared by: Donna Coleman Senior Consultant/President Samsara Project Technology, LLC
REMINDER Check in on the COLLABORATE mobile app
Types of Projects ■ Flood Control Program ■ TxDOT Pass-through Finance Projects* * Presentation focus
Modules Used in Pass-through Projects ■ Companies
■ Committed Contracts*
■ RFIs
■ Materials Delivery*
■ Daily Reports*
■ Payment Requisitions*
■ Notepads
■ Change Orders*
■ Corr Received
■ Cost Worksheet*
■ Submittals * Modules to be discussed
What is a Pass-through Finance Project?
■ Pass-through financing allows local communities to fund upfront costs for constructing a state highway project. The state then reimburses a portion of the project cost to the community over time by paying a fee for each vehicle that drives on the new highway. Projects must be on the state highway system to be eligible to be developed under this program.
Project Team ■ Engineering Consultant/Construction Manager (CM) ■ Bexar County Public Works Construction Administration Engineer ■ Bexar County Public Works Project Manager ■ Contractor
TxDOT Procedures ■ Daily Requirements ▪ TxDOT 1257 Work Report form must be filled out daily —
Records the quantity of each pay item completed
—
One 1257 per Contract pay item
—
Location of Work Performed and how Quantity was determined
■ Monthly Requirements ▪ Monthly Estimate —
Every line must have a unique number
—
Every item must have a TxDOT Cost Element associated
▪ Time Statement —
Identifies every Work and Non-Work day in calendar year
PCM Module Translation ■ TxDOT 1257 Work Report
= Materials Delivery
■ Time Statement
= Daily Report custom fields
■ Monthly Estimate
= Payment Requisition
Customizations to PCM ■ Custom fields in Daily Report for Time Statement ■ Time Statement report ■ Renamed Materials module to Project Quantities ■ Renamed Materials tab in Daily Reports - Project Quantities ■ Custom Project Quantity Reports ■ Custom Monthly Estimate form (Payment Requisition)
Project Quantities Module (Materials) ■ Contractor’s contract entered as line item based Committed Contract ■ Materials generated from Contract as Project Quantity “folders”
■ Delivery Tickets (renamed Completed Progress) entered via Daily Report
DEMO
This is a subtitle or bulleted list
Daily Report Module ■ Inspectors (hired by CM) use Daily Report module ■ Inspectors fill out 1257, then record work performed using Project Quantities tab within Daily Report ■ 1257 is scanned and attached on Attachments tab of the corresponding quantity entered
TXDot 1257 Work Report
DEMO
This is a subtitle or bulleted list
Project Quantity Reports ■ Quantities not yet Requisitioned report ▪ Used at end-of-month Project Meeting, for everyone to agree on quantities ▪ Used prior to generating monthly estimate
■ “Jim Brannan report” ▪ Prompt for criteria on TxDOT item codes, then reports which payment requisitions quantities have been applied/invoiced and date it was created
Payment Requisitions ■ Generated monthly ■ Project Quantities (aka materials) are “gotten” into each payment requisition ■ Invoice is built automatically for Contractor’s payment
DEMO
This is a subtitle or bulleted list
Change Orders ■ Line item based, like the Contract ■ Added to the monthly estimate as an additional line for each change item ■ New estimate line items renumbered to sort under each change’s original contract pay item ■ Project Quantity folders created manually to allow quantities for each new change line item
Questions?
This is a subtitle or bulleted list
Please complete the session evaluation We appreciate your feedback and insight
You may complete the session evaluation either on paper or online via the mobile app
OPSIG is the home for Primavera Users ■ Our purpose is to inform and educate our members on current and future functionality of Oracle Primavera products, while offering a forum for peers to share their experience and knowledge in the use of Primavera.
■ Educational opportunities across the Primavera product suite ■ Online Learning Series August 17th – September 4th ■ Call for presentation opening April 27th
■ Monthly Community Calls ■ 3rd Thursday of the month at 1:00 pm ET ■ Networking with other users within the Primavera community
■ Partnering with Oracle Primavera to meet the needs of our diverse membership. ■ Membership is open to anyone with an interest in the Oracle Primavera products, with no dues for membership. All members can vote on matters brought before the OPSIG. Membership requests may be reviewed by the OPSIG board.
