FBI_STACH_Attachment_A-3_Price_Template.xlsx

Instructions Instructions

BOE Example

rmalenich: These fields are locked and cannot be edited. Values are rolled up from the BOE Validate worksheet unlike the Example data values.

rmalenich: Enter the amounts based on the BOE description in the Contract Year fields.

rmalenich: These fields are locked and cannot be edited. Values are rolled up from the BOE Validate worksheet unlike the Example data values.

rmalenich: 3% is an example escalation rate.

rmalenich: NOTE: This cell does not match the corresponding CLINS 1-4 BASE YEAR amount of $300,000 to the right. Conditional formatting checks to see if this cell is equal to the corresponding CLINS 1-4 BASE YEAR cell value to the right. If the cell values do not match a mismatch exists and must be corrected. All of the BOE Contract Year fields contain conditional formatting mapped to the corresponding CLINS 1-4 Contract Year fields to the right. The values must match. If the cell does not match red fill color is placed into the mismatched cell. All BOE red formatted cells must be fixed for the BOE worksheet to be considered accurate.

rmalenich: A second quote labeled from ABC RESALES.

rmalenich: Identify the page number and line numbers or group.

UNIQUE NUMBER FOR THE BOE CREATE A LABEL TO NAME THE BASIS OF ESTIMATE (BOE), USE ONLY ONE (1) LABEL PER ROW ANY ADDITIONAL DESCRIPTIVE DATA TO DESCRIBE YOUR BOE DATE OF THE BOE, USE ONLY ONE DATE PER BOE ITEM# AND NAME USED TO INDICATE WHERE THE SOURCE OF THE ESTIMATE WAS DERIVED CREATE A LABEL (WITH A NUMBER IF MORE THAN ONE FOR THE SAME SOURCE) TO IDENTIFY AND MAP THE SOURCE APPLICABLE TO THE BOE TYPE IDENTIFY THE PAGE(S) OF THE APPLICABLE SOURCE CREATE A LABEL TO IDENTIFY THE LINE ITEM(S) THAT MAP TO THE LABELED OR NUMBERED ITEM(S) ON THE APPLICABLE SOURCE OF ESTIMATE LIST, ENTER ALL FOR ENTIRE LIST INSERT ADDITIONAL COLUMNS AS NECESSARY ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE SUM OF EACH CONTRACT YEAR/PERIOD OF PERFORMANCE (POP) INCLUDE ANY NECESSARY NOTES

BOE Validate

CLIN 000X - Example

rmalenich: Must map to an entry in the BOE Reference Table in order to rollup to the Total Price Proposal Summary.

$210,120.00 rmalenich: Must map to an entry in the BOE Reference Table in order to rollup to the Total Price Proposal Summary.

rmalenich: Tab to move between each field in the table. A tab from this field will automatically insert a new row and provide the next unique row number.

rmalenich: Click the arrow within the cell for dropdown list choices.

rmalenich: Click the arrow within the cell for dropdown list choices.

rmalenich: Must map to an entry in the BOE Reference Table in order to rollup to the Total Price Proposal Summary.

rmalenich: Must map to an entry in the BOE Reference Table in order to rollup to the Total Price Proposal Summary.

rmalenich: Will automatically enter a row # if insert is used.

rmalenich: Must map to an entry in the BOE Reference Table in order to rollup to the Total Price Proposal Summary.

Total 0 $0.00 2040 $210,120.00 0 $0.00 0 $0.00 $210,120.00

PROVIDE A UNIQUE NUMBER FOR EACH ROW ITEM PICK FROM THE DROPDOWN LIST OF FBI OR CONTRACTOR FOR THE LOCATION OF THE POSITION PICK FROM THE DROPDOWN LIST OF PRIME OR SUBCONTACTOR THE NAME OF THE COMPANY LABOR CATEGORY INSERT ADDITIONAL COLUMNS AS NECESSARY HOW MANY OF SAID ITEM? LABOR RATE FOR THE POSITION ENTER THE BOE ITEM # FROM THE BOE WORKSHEET ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE HOW MANY OF SAID ITEM? LABOR RATE FOR THE POSITION ENTER THE BOE ITEM # FROM THE BOE WORKSHEET ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE HOW MANY OF SAID ITEM? LABOR RATE FOR THE POSITION ENTER THE BOE ITEM # FROM THE BOE WORKSHEET ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE HOW MANY OF SAID ITEM? LABOR RATE FOR THE POSITION ENTER THE BOE ITEM # FROM THE BOE WORKSHEET ENTER THE PRICE FOR THE CONTRACT YEAR/PERIOD OF PERFORMANCE SUM OF EACH CONTRACT YEAR/PERIOD OF PERFORMANCE (POP) INCLUDE ANY NECESSARY NOTES

Total Price Proposal Summary Total Price Proposal Summary

Grand Total $0.00 $0.00 $0.00 $0.00 $0.00

BOE

CLIN 0001 - Hardware