Attachment 3.3 - SOW Exhibit No. 1.pdf

eDelivery Request for Proposal

C-

SOW Exhibit No. 1 – Workflow Diagrams, Example Reports, System-wide Queries, Progress Payment Summary Dashboard View, and Account Data Tracked

TABLE OF CONTENTS Page

1.1 SOW Exhibit No. 1 - Workflow Diagrams, Example Reports, System-wide Queries, Progress Payment Summary Dashboard View, and Account Data Tracked

1.1.1 Current FLH Business Workflow

1.1.1.1 System Data Flow

1.1.1.2 Design Business Workflows

1.1.1.2.1 Design Figure 1 – Design Estimate Overview

1.1.1.2.2 Design Figure 2 – Create Project

1.1.1.2.3 Design Figure 3 – Pay Item Estimate/Select Pay Items

1.1.1.2.4 Design Figure 4 – Add Quantities

1.1.1.2.5 Design Figure 5 – Unit Price Analysis for Each Pay Item

1.1.1.2.6 Design Figure 6 – Add Incentives

1.1.1.2.7 Design Figure 7 – Calculate Estimate

1.1.1.2.8 Design Figure 8 – Reports

1.1.1.3 Acquisition Business Workflows

1.1.1.3.1 Acquisition Figure 1 – Acquisitions Process Overview

1.1.1.3.2 Acquisition Figure 2 – Prepare Solicitation Package

0 SOW

1.1.1.3.3 Acquisition Figure 3 – Bid Evaluation Process

1.1.1.3.4 Acquisition Figure 4 – Award Process

1.1.1.4 Construction Business Workflows

1.1.1.4.1 Construction Figure 1 – Progress Estimate & Project Records Overview ... 17

1.1.1.4.2 Construction Figure 1A – Contract Modification Process

1.1.1.4.3 Construction Figure 2 – Pay Note Details

1.1.1.4.4 Construction Figure 3 - Progress Estimate Process

1.1.1.4.5 Construction Figure 4 - Progress Estimate Approval Process

1.1.1.4.6 Construction Figure 5 - Progress Estimate Final Voucher

1.1.2 Example Project Specific Reports

1.1.2.1 Design Reports

1.1.2.1.1 Engineer’s Estimate Report for each Schedule/Option

1.1.2.1.2 Summary of Quantities for Each Schedule

1.1.2.1.3 Unit Price Analysis (UPA Report)

1.1.2.2 Acquisition Reports

1.1.2.2.1 Bid Schedule and Bid Schedule Summary

1.1.2.2.2 Amendment Estimate Reports

1.1.2.2.3 BODEE Report

1.1.2.2.4 Bid Tabulation Report

1.1.2.2.5 Bid Error Report

1.1.2.2.6 Bid Analysis Report

1.1.2.2.7 Obligation Tabulation Report

1.1.2.2.8 Bid Schedule Low – Exercised

1.1.2.3 Construction Reports

1.1.2.3.1 Construction STATUS Report

1.1.2.3.2 Government Receiving Report

1.1.2.3.3 Progress Payment Report – Government Version

1.1.2.3.4 Progress Payment Report – Contractor Version

1.1.2.3.5 Progress Payment Schedule Summary

1.1.2.3.6 Pay Note Report - Government Version

1.1.2.3.7 Pay Note Report - Contractor Version

1.1.2.3.8 Pay Note Summary – Government & Contractor Version

1.1.2.3.9 Pay Note Summary – Contractor Version

1.1.2.3.10 Daily Inspector Report (IDR) - Contractor Daily Report (CDR)

1.1.2.3.11 Daily Diary Report

1.1.2.3.12 Contract Modification Report

1.1.2.3.13 CM affected Pay item list: unit prices, quantities, etc

1.1.3 System-wide Queries

1.1.4 Progress Payment Summary View or Dashboard

1.1.6 Account Data Tracked in Construction Module

1.1 SOW Exhibit No. 1 - Workflow Diagrams, Example Reports, System-wide Queries, Progress Payment Summary Dashboard View, and Account Data Tracked

1.1.1 Current FLH Business Workflow

FLH Current Business Workflows are provided for information only. The intent for the new system is not necessarily to exactly replicate the current workflow, but to provide a better understanding of our current practices that may need to change in order to implement the new system requirements.

Numerous new system requirements, including electronic bidding, document management, and mobile offline capabilities are not shown in the FLH Workflows, since they are not part our current business practices.

Basic Flowchart Shape Key:

Also provided for information only is a link to the users guides for FLH’s existing system. The intent is not to recreate the old system, but to provide a better understanding of FLH current processes. https://highways.dot.gov/federal-lands/estimates/eebacs-guide https://highways.dot.gov/federal-lands/estimates/eebacs-guide

1.1.1.1 System Data Flow

1.1.1.2 Design Business Workflows

1.1.1.2.1 Design Figure 1 – Design Estimate Overview

1.1.1.2.2 Design Figure 2 – Create Project

1.1.1.2.3 Design Figure 3 – Pay Item Estimate/Select Pay Items

1.1.1.2.4 Design Figure 4 – Add Quantities

1.1.1.2.5 Design Figure 5 – Unit Price Analysis for Each Pay Item

1.1.1.2.6 Design Figure 6 – Add Incentives

1.1.1.2.7 Design Figure 7 – Calculate Estimate

1.1.1.2.8 Design Figure 8 – Reports

1.1.1.3 Acquisition Business Workflows

1.1.1.3.1 Acquisition Figure 1 – Acquisitions Process Overview

1.1.1.3.2 Acquisition Figure 2 – Prepare Solicitation Package

1.1.1.3.3 Acquisition Figure 3 – Bid Evaluation Process

1.1.1.3.4 Acquisition Figure 4 – Award Process

1.1.1.4 Construction Business Workflows

1.1.1.4.1 Construction Figure 1 – Progress Estimate & Project Records Overview

1.1.1.4.2 Construction Figure 1A – Contract Modification Process

1.1.1.4.3 Construction Figure 2 – Pay Note Details

1.1.1.4.4 Construction Figure 3 - Progress Estimate Process

1.1.1.4.5 Construction Figure 4 - Progress Estimate Approval

Process

1.1.1.4.6 Construction Figure 5 - Progress Estimate Final Voucher

1.1.2 Example Project Specific Reports

Example reports are provided for information only. Reports to be developed do not have to be exactly the same; however, they must include the data as described in Section C.1 – C.5.

Example reports included show representative pages, not the entire report.

1.1.2.1 Design Reports

1.1.2.1.1 Engineer’s Estimate Report for each Schedule/Option

1.1.2.1.2 Summary of Quantities for Each Schedule

PDF - Example A

PDF - Example B

Excel – Example B

CSV – Example B

1.1.2.1.3 Unit Price Analysis (UPA Report)

1.1.2.2 Acquisition Reports

1.1.2.2.1 Bid Schedule and Bid Schedule Summary

PDF

Bid Schedule

Bid Schedule Summary

Bid Schedule Summary with Time Bid (A+B Bidding)

1.1.2.2.2 Amendment Estimate Reports

Amendment Estimate Reports:

• Engineer’s Estimate Report - Amended

• Summary of Quantities Reports - Amended

• Unit Price Analysis Report - Amended

• Bid Schedule Report – Amended

These amended reports are exactly the same as the original versions shown earlier in this appendix, except the changes that were made as part of the Amendment are labeled with the Amendment #, and any deletions are shown with strikeout through the text. Examples of the Amendment tracking within these reports is shown in the following Examples.

Engineer’s Estimate Report – Amended

Engineer’s Estimate Report – Amended

Summary of Quantities Reports – Amended

Excel

CSV

Bid Schedule – Amended

1.1.2.2.3 BODEE Report

BODEE Report

BODEE Report with Time Bid (A+B Bidding)

1.1.2.2.4 Bid Tabulation Report

Bid Tabulation Report

Bid Tabulation Report with Time Bid (A+B Bidding)

1.1.2.2.5 Bid Error Report

1.1.2.2.6 Bid Analysis Report

1.1.2.2.7 Obligation Tabulation Report

1.1.2.2.8 Bid Schedule Low – Exercised

1.1.2.3 Construction Reports

1.1.2.3.1 Construction STATUS Report

Construction Status - Version A

Construction Status – Version B

Construction Status – Version C

Excel format – Active Projects:

Excel Format – Completed Projects

1.1.2.3.2 Government Receiving Report

1.1.2.3.3 Progress Payment Report – Government Version

1.1.2.3.4 Progress Payment Report – Contractor Version

1.1.2.3.5 Progress Payment Schedule Summary

Original Contract Amount (without incentives)

Revised Award Amount: Original Contract Amount + “Options Awarded” by Contract Modification

Revised Contract Amount: Original Contract Amount + all changes made by Contract Modification.

Current PP Amount (Current Progress Payment Period Amount)

1.1.2.3.6 Pay Note Report - Government Version

1.1.2.3.7 Pay Note Report - Contractor Version

1.1.2.3.8 Pay Note Summary – Government & Contractor Version

1.1.2.3.9 Pay Note Summary – Contractor Version

1.1.2.3.10 Daily Inspector Report (IDR) - Contractor Daily Report

(CDR)

The only difference between IDR and CDR is the report title and report signatures.

1.1.2.3.11 Daily Diary Report

1.1.2.3.12 Contract Modification Report

1.1.2.3.13 CM affected Pay item list: unit prices, quantities, etc.

Excel format, fully editable

1.1.3 System-wide Queries

1.1.4 Progress Payment Summary View or Dashboard

The intent of this mock-up is to convey the data required as part of the Progress Payment Summary View, as described in SOW Attachment No. 1, Section 4.6.4. The provided system view does not have to be exactly the same.

eDelivery Request for Proposal C-98

1.1.6 Account Data Tracked in Construction Module

The intent of this mock-up is to convey account data the eDelivery system shall track in the Construction Module, as described in SOW Attachment No. 1, Section 1.6.

ACCOUNT INFORMATION FOR PAYMENT PERIOD 2

Current Account Code (Acct type, number) Account Description Account Number

Original Obligated Amount

Current Obligated Amount

Previous Paid Expenditure

Current Approved Amount

Account priority (chain)

Current Payment Override

To-Date Expenditures

Probable Amount Account Comments

CON01 CA FLAP funding 1516042200101-540.CN.G31E.04-1604000000 $2,100,000.00 $249,618.03 $10,302.08 $292,819.88 CON01-CON03 $23,915.95 No $249,618.03 $2,434,837.34

CON02

Discretionary funding from NPS LAVO 151606PP14001 540.CN.G310.06 1606000000 $2,218,846.97 $2,289,721.97 $5,547.27 $119,054.71 $75,889.62 Yes $81,436.89 $2,218,846.97

CON03 Add. CA FLAP funding 1516042200101-540.CN.K31E.04-1604000000 $249,618.03 $2,142,750.00 $0.00 $0.00 CON01-CON03 $53,503.93 No $53,503.93 $42,750.00 Use AFTER all CON01 expended

CON04 CA-Trinity County FLAP Match 1516042200101-540.CN.J31F.04-1604000000 $85,219.31 $85,219.31 $0.00 $0.00 $0.00 No $0.00 $0.00 CA Match account: 3.5% match

CON05

Old Discretionary from NPS LAVO 151606PP14001 540.CN.G150.06 1606000000 $0.00 $43,165.09 $0.00 $0.00 $43,165.09 Yes $43,165.09 $0.00 Use BEFORE CON02

CE01

Construction engineering in-house FY14 P1515510ESV002 T520.CE.G320.51 O1551000000 $60,000.00 $60,000.00 $60,000.00 DELPHI 09-30-2014

CE02

Construction engineering in-house FY15 P1515510ESV002 T520.CE.G320.51 O1551000000 $75,560.00 $34,485.27 $85,000.00 DELPHI 02-18-2015

CEA01

Contracted inspection - ABC Company P1515510ESV002 T552.CE.G320.51 O1551000000 $25,425.40 $25,425.40 $25,425.40 DELPHI 02-18-2015

Construction Totals $4,653,684.31 $4,810,474.40 $15,849.35 $411,874.59 $196,474.59 $427,723.94 $4,696,434.31

Construction Engineering Totals $160,985.40 $119,910.67 $170,425.40