RFPb Attachment 4 - Price Submission Worksheet.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Terrorism Risk Insurance Program (TRIP) Claims Management - Amendment 02 Federal contract opportunity
Solicitation number
2032H323R00001
Issued by
Department of the Treasury Departmental Offices

About this file

Written by GovTribe AI ·

This document contains a price submission worksheet and details for a federal contract opportunity with the Department of the Treasury to provide claims management support for the Terrorism Risk Insurance Program. The contract involves maintaining, testing, and operating the TRIP Claims System to process any claims from covered insurers in the event of a certified act of terrorism. It would also require assisting Treasury with administrative functions under the Terrorism Risk Insurance Act. The price submission worksheet includes detailed labor categories and hourly rates for tasks such as project management, operations supervision, systems analysis, and claims examination across multiple contract periods and option years. However, all pricing in the template is currently shown as TBD, indicating the amounts are still to be determined by offerors in their proposals.

View the file

Other files for this federal contract opportunity

Other files attached to Terrorism Risk Insurance Program (TRIP) Claims Management - Amendment 02, newest first.
File Type Posted
II_02_Amendment 02 - RFP 2032H323R00001.pdf PDF
II_02_Amendment 01 - RFP 1 Attch 4 -PriceSubWrksht.xlsx XLSX spreadsheet
II_02_Amendment 01 - RFP 2032H323R00001.pdf PDF
II_02_Amendment 01 - RFP Attachment 1 - TRIP CLAIMS SYSTEM PWS.pdf PDF
II_02_Amendment 01 - Questions and Answers RE RFP 2032H23R00001.pdf PDF
RFPb Attachment 5 - SB Concerns Subcontracting Plan Outline.docx DOCX document
RFPa 2032H323R00001.pdf PDF
RFPb Attachment 1 - TRIP CLAIMS SYSTEM PWS v8.pdf PDF
RFPb Attachment 2 - QASP TRIP Claims Management v2.pdf PDF
RFPb Attachment 3 - Labor Category Descriptions.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Summary

SUMMARY OF PROPOSED FIRM FIXED PRICE (FFP) AND LABOR HOUR (LH) COSTS
RFP ReferenceTask 1 (LH)Task 2 (FFP)Task 3 (FFP)Task 4 (LH)Task 5 (LH)Task 6 (FFP)Task 7 (LH)Task 8 (LH)Task 9 (LH)Grand Total
BASE PERIOD$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OPTION PERIOD 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OPTION PERIOD 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OPTION PERIOD 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OPTION PERIOD 4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
FAR 52.217-8 PERIOD (6 months)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Evaluated Price$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

FFP CLINS

SUMMARY SCHEDULE - Firm Fixed Price (FFP) BREAKDOWN PER FFP TASK BY CONTRACT PERIOD

RFP REFERENCEBASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTIONTOTAL with 52.217-8
TASK 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TASK 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TASK 6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total FFP$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

LH CLINS

SUMMARY SCHEDULE - Labor Hour (LH) BREAKDOWN PER LABOR HOUR TASK BY CONTRACT PERIOD

TASK 1
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director91$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 091$ - 00$ - 0$ - 091$ - 0
Operations Supervisor64$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 064$ - 00$ - 0$ - 064$ - 0
Systems Analyst150$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0150$ - 00$ - 0$ - 0150$ - 0
Programmer114$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0114$ - 00$ - 0$ - 0114$ - 0
Admin/Clerical28$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 028$ - 00$ - 0$ - 028$ - 0
Project Manager64$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 064$ - 00$ - 0$ - 064$ - 0
Qual. Assur. Analyst24$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 024$ - 00$ - 0$ - 024$ - 0
IT Proj. Mgr/Database Analy.76$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 076$ - 00$ - 0$ - 076$ - 0
Total LH Cost611$ - 00$ - 00$ - 00$ - 00$ - 0611$ - 00$ - 0611$ - 0
TASK 4
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0500$ - 050$ - 0$ - 0550$ - 0
Operations Supervisor50$ - 0$ - 050$ - 0$ - 050$ - 0$ - 050$ - 0$ - 050$ - 0$ - 0250$ - 025$ - 0$ - 0275$ - 0
Accountant (CPA)40$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 0200$ - 020$ - 0$ - 0220$ - 0
Systems Analyst100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0100$ - 0$ - 0500$ - 050$ - 0$ - 0550$ - 0
Claims Examiner40$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 0200$ - 020$ - 0$ - 0220$ - 0
Tech. Serv. Rep40$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 0200$ - 020$ - 0$ - 0220$ - 0
Actuary40$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 0200$ - 020$ - 0$ - 0220$ - 0
Programmer120$ - 0$ - 0120$ - 0$ - 0120$ - 0$ - 0120$ - 0$ - 0120$ - 0$ - 0600$ - 060$ - 0$ - 0660$ - 0
Admin/Clerical40$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 040$ - 0$ - 0200$ - 020$ - 0$ - 0220$ - 0
Total LH Cost470$ - 0470$ - 0470$ - 0470$ - 0470$ - 02,350$ - 0235$ - 02,585$ - 0
TASK 5
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 04,210$ - 0421$ - 0$ - 04,631$ - 0
Operations Supervisor842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 0842$ - 0$ - 04,210$ - 0421$ - 0$ - 04,631$ - 0
Accountant (CPA)475$ - 0$ - 0475$ - 0$ - 0475$ - 0$ - 0475$ - 0$ - 0475$ - 0$ - 02,375$ - 0238$ - 0$ - 02,613$ - 0
Systems Analyst181$ - 0$ - 0181$ - 0$ - 0181$ - 0$ - 0181$ - 0$ - 0181$ - 0$ - 0905$ - 091$ - 0$ - 0996$ - 0
Claims Examiner508$ - 0$ - 0508$ - 0$ - 0508$ - 0$ - 0508$ - 0$ - 0508$ - 0$ - 02,540$ - 0254$ - 0$ - 02,794$ - 0
Tech. Serv. Rep718$ - 0$ - 0718$ - 0$ - 0718$ - 0$ - 0718$ - 0$ - 0718$ - 0$ - 03,590$ - 0359$ - 0$ - 03,949$ - 0
Programmer362$ - 0$ - 0362$ - 0$ - 0362$ - 0$ - 0362$ - 0$ - 0362$ - 0$ - 01,810$ - 0181$ - 0$ - 01,991$ - 0
Admin/Clerical1,238$ - 0$ - 01,238$ - 0$ - 01,238$ - 0$ - 01,238$ - 0$ - 01,238$ - 0$ - 06,190$ - 0619$ - 0$ - 06,809$ - 0
Project Manager62$ - 0$ - 062$ - 0$ - 062$ - 0$ - 062$ - 0$ - 062$ - 0$ - 0310$ - 031$ - 0$ - 0341$ - 0
Total LH Cost4,386$ - 04,386$ - 04,386$ - 04,386$ - 04,386$ - 021,930$ - 02,193$ - 024,123$ - 0
TASK 7
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director488$ - 0$ - 0488$ - 0$ - 0488$ - 0$ - 0488$ - 0$ - 0488$ - 0$ - 02,438$ - 0244$ - 0$ - 02,681$ - 0
Operations Supervisor600$ - 0$ - 0600$ - 0$ - 0600$ - 0$ - 0600$ - 0$ - 0600$ - 0$ - 03,000$ - 0300$ - 0$ - 03,300$ - 0
Business Analyst3,758$ - 0$ - 03,758$ - 0$ - 03,758$ - 0$ - 03,758$ - 0$ - 03,758$ - 0$ - 018,788$ - 01,879$ - 0$ - 020,666$ - 0
Sr. Analyst/Actuary/CPA38$ - 0$ - 038$ - 0$ - 038$ - 0$ - 038$ - 0$ - 038$ - 0$ - 0188$ - 019$ - 0$ - 0206$ - 0
Data Processing300$ - 0$ - 0300$ - 0$ - 0300$ - 0$ - 0300$ - 0$ - 0300$ - 0$ - 01,500$ - 0150$ - 0$ - 01,650$ - 0
IT Prod. Services Consult.263$ - 0$ - 0263$ - 0$ - 0263$ - 0$ - 0263$ - 0$ - 0263$ - 0$ - 01,313$ - 0131$ - 0$ - 01,444$ - 0
Software Analyst/ Prog.150$ - 0$ - 0150$ - 0$ - 0150$ - 0$ - 0150$ - 0$ - 0150$ - 0$ - 0750$ - 075$ - 0$ - 0825$ - 0
IT Proj. Mgr/Database Analy.38$ - 0$ - 038$ - 0$ - 038$ - 0$ - 038$ - 0$ - 038$ - 0$ - 0188$ - 019$ - 0$ - 0206$ - 0
Total LH Cost5,633$ - 05,633$ - 05,633$ - 05,633$ - 05,633$ - 028,163$ - 02,816$ - 030,979$ - 0
TASK 8
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director0$ - 0$ - 0113$ - 0$ - 0675$ - 0$ - 0675$ - 0$ - 0675$ - 0$ - 02,138$ - 0338$ - 0$ - 02,476$ - 0
Operations Supervisor0$ - 0$ - 085$ - 0$ - 0844$ - 0$ - 0844$ - 0$ - 0844$ - 0$ - 02,617$ - 0422$ - 0$ - 03,039$ - 0
Accountant (CPA)0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 00$ - 0$ - 00$ - 0
Systems Analyst0$ - 0$ - 0270$ - 0$ - 0323$ - 0$ - 0323$ - 0$ - 0323$ - 0$ - 01,239$ - 0162$ - 0$ - 01,401$ - 0
Claims Examiner0$ - 0$ - 029$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 029$ - 00$ - 0$ - 029$ - 0
Tech. Serv. Rep0$ - 0$ - 042$ - 0$ - 03,642$ - 0$ - 03,642$ - 0$ - 03,642$ - 0$ - 010,968$ - 01,821$ - 0$ - 012,789$ - 0
Programmer0$ - 0$ - 03$ - 0$ - 0479$ - 0$ - 0479$ - 0$ - 0479$ - 0$ - 01,440$ - 0240$ - 0$ - 01,680$ - 0
Project Manager0$ - 0$ - 00$ - 0$ - 017$ - 0$ - 017$ - 0$ - 017$ - 0$ - 051$ - 09$ - 0$ - 060$ - 0
Total LH Cost0$ - 0542$ - 05,980$ - 05,980$ - 05,980$ - 018,482$ - 02,990$ - 021,472$ - 0
TASK 9
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0100$ - 0$ - 0100$ - 00$ - 0$ - 0100$ - 0
Operations Supervisor0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 050$ - 0$ - 050$ - 00$ - 0$ - 050$ - 0
Accountant (CPA)0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Systems Analyst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0100$ - 0$ - 0100$ - 00$ - 0$ - 0100$ - 0
Claims Examiner0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Tech. Serv. Rep0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Actuary0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Programmer0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0120$ - 0$ - 0120$ - 00$ - 0$ - 0120$ - 0
Admin/Clerical0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Total LH Cost0$ - 00$ - 00$ - 00$ - 0470$ - 0470$ - 00$ - 0470$ - 0
TASK 10
BASE PERIODOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4TOTAL52.217-8 OPTION PERIODTOTAL WITH 52.217-8
(6 months)
Labor CategoryProposed Labor CategoryEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursLoaded RateAmountEstimated HoursAmountEstimated HoursLoaded RateAmountEstimated HoursAmount
Project Director0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0100$ - 0$ - 0100$ - 00$ - 0$ - 0100$ - 0
Operations Supervisor0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 050$ - 0$ - 050$ - 00$ - 0$ - 050$ - 0
Accountant (CPA)0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Systems Analyst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0100$ - 0$ - 0100$ - 00$ - 0$ - 0100$ - 0
Claims Examiner0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Tech. Serv. Rep0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Actuary0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Programmer0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0120$ - 0$ - 0120$ - 00$ - 0$ - 0120$ - 0
Admin/Clerical0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 040$ - 0$ - 040$ - 00$ - 0$ - 040$ - 0
Total LH Cost0$ - 00$ - 00$ - 00$ - 0470$ - 0470$ - 00$ - 0470$ - 0

File details come from the government source that posted it. Updated .