II_02_Amendment 01 - RFP 1 Attch 4 -PriceSubWrksht.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Terrorism Risk Insurance Program (TRIP) Claims Management - Amendment 02
Solicitation number
2032H323R00001
Issued by

About this file

This document contains a price worksheet for a federal contract solicitation to provide claims management support services to the Terrorism Risk Insurance Program. The solicitation seeks contractor support to maintain and operate the TRIP Claims System, review and process claims from insured entities following a certified terrorist attack, and assist the Department of the Treasury with administrative functions under the Terrorism Risk Insurance Act. The price worksheet includes labor categories, hourly rates, and estimated hours for tasks including claims processing, system maintenance and testing, and administrative assistance across multiple contract periods and option years. However, all pricing fields in the worksheet are blank.

View the file

Other files

On GovTribe

Work with this file

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

Text version

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 .