JL.3 and JL.4 Price Model and Price Summary.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
MARINE AND BIOLOGICAL RESOURCES MONITORING AND PROGRAM MGMT SVCS at Various Locations - Naval Facilities Engineering Commands Atlantic and Pacific area of Responsibility Worldwide
Solicitation number
N6247024R0065
Issued by

About this file

Written by GovTribe AI ·

This is a pricing template workbook (Attachments JL.3 and JL.4) for a Navy contract providing marine and biological resources monitoring services. The template includes detailed labor category worksheets for the base year and four option years, with 14 specified labor categories including Program Manager, Technical Project Manager, Marine Biologist, Wildlife Biologist/Zoologist, Marine Bioacoustician, and others, totaling 35,360 hours per year.

Each year's worksheet includes Other Direct Costs fixed at $500,000, subcontractor costs of $6,000,000, and travel costs of $250,000, totaling $6,750,000 in non-labor costs annually. The template requires offerors to input labor rates and burden multipliers, with strict instructions not to modify the structure or hours. A summary sheet (JL.4) requires breakdown of work distribution between prime contractor/JV members and key subcontractors, with associated markup calculations. The file is designed to standardize price submissions for evaluation purposes, with all calculations to be submitted in Excel format on CD along with hard copies.

View the file

Other files

File Type Posted
Amendment 0002.pdf PDF
N6247024R0065 Amendment 0002.pdf PDF
N6247024R0065 Amendment 0001.pdf PDF
Attachment C revised2- Experience Project Data Sheet.pdf PDF
Attachment G revised- Historical Business Utilization.pdf PDF
Final Data Appendices A-D (12192019).pdf PDF
Attachment C revised- Experience Project Data Sheet.pdf PDF
Attachment G- Historical Business Utilization.pdf PDF
Amendment 0001.pdf PDF
Attachment E- Past Performance Questionnaire (Form PPQ).pdf PDF
JL.1A and JL.1 Burdened Labor Rates.xlsx XLSX spreadsheet
Attachment JL.5 - Past Performance Questionnaire (Small Business).pdf PDF
Attachment C- Experience Project Data Sheet.pdf PDF
Attachment JL.7-Small Business Participation Commitment Document (SBPCD).pdf PDF
Attachment 1 - QASP.pdf PDF
Attachment D - Resume Submittal (Key Personnel).pdf PDF
Attachment B - Certificate of Non-Disclosure and Conflict of Interest Statement.pdf PDF
Attachment JL.2 Proposed Distribution of Work.pdf PDF
N62470-24-R-0065 Marine Monitoring IDIQ Solicitation.pdf PDF
JL.6 - Small Business Subcontracting Plan (SBSP).pdf PDF
Show all 20

On GovTribe

Work with this file

  • 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.

Base Year

BASE YEAR PRICE MODEL WORKSHEET JL.3
LABOR CATEGORIES, RATES AND HOURS- Table 12080
Labor Category- ABRate ($/hr)- CDHours ETotal ($) F
Program Managerx2080$0.00
Technical Project Managerx10400$0.00
Marine Biologistx2080$0.00
Wildlife Biologist/Zoologistx2080$0.00
Marine Bioacousticianx2080$0.00
Biostatisticianx1040$0.00
Marine Species Observerx4160$0.00
Fisheries Biologist and Oceanographerx2080$0.00
Biological/Laboratory Technicianx2080$0.00
Technical Editorx1040$0.00
GIS Analystx2080$0.00
Web/app Developerx2080$0.00
Database Managerx1040$0.00
Clerical/Administrativex1040$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
$0.00
TOTAL TABLE 1(BURDENED LABOR)35360$0.00
BASE YEAR
OTHER DIRECT COSTS AND MULTPLIERS - TABLE 2
Other Direct Costs (Equipment, Supplies, Materials, etc.)$500,000.00
Burden (multiplier JL.1)applied to Other Direct Costs (%)0.00%x$500,000.00$0.00
Subcontractors$6,000,000.00
Burden (Multiplier JL.1) applied to Subcontractors (%)0.00%x$6,000,000.00$0.00
Travel$250,000.00
Burden (Multiplier JL.1) applied to travel (%)0.00%x$250,000.00$0.00

Total (ODCs, travel and subcontrator cost with burden)

Direct Costs applied to labor base
(e.g. computer services $ per hour)x$0.00
Burden (Multiplier) applied to direct costs added to labor base
Total direct cost applied to labor base with burden

TOTAL TABLE 2 $6,750,000.00

TOTAL BASE YEAR (Burdened Labor, "Other Direct Costs," and Subcontractors)$6,750,000.00
Notes:
1. Offeror shall not add labor categories, make structural changes, or change the hours on this form.
2. The only entries shall be in column "C". No other columns shall be changed, modified or deleted, with the exception of Column "E" for "Direct
Costs applied to labor base". See note 5 below.
3. Offeror shall only utilize listed labor categories and input burdened direct labor hourly ceiling rates from Attachment JL.1.
4. Under "Other Direct Costs and Multipliers,"offerors shall input under column "C" the applicable multipliers for ODCs, subcontractors and travel
from Attachment JL.1 Chart 2.
5. Offerors shall input the "Direct Costs Applied to Labor Base" from Attachment JL.1 Chart 2. The number of hours listed in Column "E" for
"Direct Cost Applied to Labor Base" reflects the total number of hours under Table 1 above. If the "Direct Cost" is not applied to the total labor
base, e.g. applied to only certain labor categories, adjust the number of hours in Column E to reflect the correct number of hours using the
applicable hours from Table 1 above. If more than one "Direct Cost" (e.g. $3.00/hr. Computer usage and $2.50/hr. health and safety is applicable,
Modify Table 2 as necessary to show these costs.
6. Table 2 does not include any formulas. In addition to hard copies, Offerors shall submit this form in Microsoft Excel format on a CD showing
all calculations (i.e. multiplier application to other direct costs) used to arrive at the total cost.
7. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred
on this contract.

SOLICITATION N62470-18-R-7009

ATTACHMENT JL.3

Option Yr 1

OPTION YEAR 1 PRICE MODEL WORKSHEET JL.3
LABOR CATEGORIES, RATES AND HOURS- Table 12080
Labor Category- ABRate ($/hr)- CDHours ETotal ($) F
Program Managerx2080$0.00
Technical Project Managerx10400$0.00
Marine Biologistx2080$0.00
Wildlife Biologist/Zoologistx2080$0.00
Marine Bioacousticianx2080$0.00
Biostatisticianx1040$0.00
Marine Species Observerx4160$0.00
Fisheries Biologist and Oceanographerx2080$0.00
Biological/Laboratory Technicianx2080$0.00
Technical Editorx1040$0.00
GIS Analystx2080$0.00
Web/app Developerx2080$0.00
Database Managerx1040$0.00
Clerical/Administrativex1040$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
$0.00
TOTAL TABLE 1(BURDENED LABOR)35360$0.00
BASE YEAR
OTHER DIRECT COSTS AND MULTPLIERS - TABLE 2
Other Direct Costs (Equipment, Supplies, Materials, etc.)$500,000.00
Burden (multiplier JL.1)applied to Other Direct Costs (%)x$500,000.00$0.00
Subcontractors$6,000,000.00
Burden (Multiplier JL.1) applied to Subcontractors (%)x$6,000,000.00$0.00
Travel$250,000.00
Burden (Multiplier JL.1) applied to travel (%)x$250,000.00$0.00

Total (ODCs, travel and subcontrator cost with burden)

Direct Costs applied to labor base
(e.g. computer services $ per hour)x$0.00
Burden (Multiplier) applied to direct costs added to labor base
Total direct cost applied to labor base with burden

TOTAL TABLE 2 $6,750,000.00

TOTAL OPTION YEAR 1 (Burdened Labor, "Other Direct Costs," and Subcontractors) $7,250,000.00

Notes:
1. Offeror shall not add labor categories, make structural changes, or change the hours on this form.
2. The only entries shall be in column "C". No other columns shall be changed, modified or deleted,
with the exception of Column "E" for "Direct Costs applied to labor base". See note 5 below.
3. Offeror shall only utilize listed labor categories and input burdened direct labor hourly ceiling rates from Attachment JL.1.
4. Under "Other Direct Costs and Multipliers,"offerors shall input under column "C" the applicable multipliers for ODCs,
subcontractors and travel from Attachment JL.1 Chart 2.
5. Offerors shall input the "Direct Costs Applied to Labor Base" from Attachment JL.1 Chart 2. The number of
hours listed in Column "E" for "Direct Cost Applied to Labor Base" reflects the total number of hours under Table 1 above.
If the "Direct Cost" is not applied to the total labor base, e.g. applied to only certain labor categories, adjust the number of hours
in Column E to reflect the correct number of hours using the applicable hours from Table 1 above.
If more than one "Direct Cost" (e.g. $3.00/hr. Computer usage and $2.50/hr. health and safety is applicable,
Modify Table 2 as necessary to show these costs.
6. Table 2 does not include any formulas. In addition to hard copies, Offerors shall submit this form in Microsoft Excel
format on a CD showing all calculations (i.e. multiplier application to other direct costs) used to arrive at the total cost.
7. The direct cost amounts presented above are for informational purposes only and not necessarily
representative of actual costs to be incurred on this contract.

Option Yr 2

OPTION YEAR 2 PRICE MODEL WORKSHEET JL.3
LABOR CATEGORIES, RATES AND HOURS- Table 12080
Labor Category- ABRate ($/hr)- CDHours ETotal ($) F
Program Managerx2080$0.00
Technical Project Managerx10400$0.00
Marine Biologistx2080$0.00
Wildlife Biologist/Zoologistx2080$0.00
Marine Bioacousticianx2080$0.00
Biostatisticianx1040$0.00
Marine Species Observerx4160$0.00
Fisheries Biologist and Oceanographerx2080$0.00
Biological/Laboratory Technicianx2080$0.00
Technical Editorx1040$0.00
GIS Analystx2080$0.00
Web/app Developerx2080$0.00
Database Managerx1040$0.00
Clerical/Administrativex1040$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
$0.00
TOTAL TABLE 1(BURDENED LABOR)35360$0.00
BASE YEAR
OTHER DIRECT COSTS AND MULTPLIERS - TABLE 2
Other Direct Costs (Equipment, Supplies, Materials, etc.)$500,000.00
Burden (multiplier JL.1)applied to Other Direct Costs (%)x$500,000.00$0.00
Subcontractors$6,000,000.00
Burden (Multiplier JL.1) applied to Subcontractors (%)x$6,000,000.00$0.00
Travel$250,000.00
Burden (Multiplier JL.1) applied to travel (%)x$250,000.00$0.00

Total (ODCs, travel and subcontrator cost with burden)

Direct Costs applied to labor base
(e.g. computer services $ per hour)x$0.00
Burden (Multiplier) applied to direct costs added to labor base
Total direct cost applied to labor base with burden

TOTAL TABLE 2 $6,750,000.00

TOTAL OPTION YEAR 2 (Burdened Labor, "Other Direct Costs," and Subcontractors) $7,250,000.00

Notes:
1. Offeror shall not add labor categories, make structural changes, or change the hours on this form.
2. The only entries shall be in column "C". No other columns shall be changed, modified or deleted,
with the exception of Column "E" for "Direct Costs applied to labor base". See note 5 below.
3. Offeror shall only utilize listed labor categories and input burdened direct labor hourly ceiling rates from Attachment JL.1.
4. Under "Other Direct Costs and Multipliers,"offerors shall input under column "C" the applicable multipliers for ODCs,
subcontractors and travel from Attachment JL.1 Chart 2.
5. Offerors shall input the "Direct Costs Applied to Labor Base" from Attachment JL.1 Chart 2. The number of
hours listed in Column "E" for "Direct Cost Applied to Labor Base" reflects the total number of hours under Table 1 above.
If the "Direct Cost" is not applied to the total labor base, e.g. applied to only certain labor categories, adjust the number of hours
in Column E to reflect the correct number of hours using the applicable hours from Table 1 above.
If more than one "Direct Cost" (e.g. $3.00/hr. Computer usage and $2.50/hr. health and safety is applicable,
Modify Table 2 as necessary to show these costs.
6. Table 2 does not include any formulas. In addition to hard copies, Offerors shall submit this form in Microsoft Excel
format on a CD showing all calculations (i.e. multiplier application to other direct costs) used to arrive at the total cost.
7. The direct cost amounts presented above are for informational purposes only and not necessarily
representative of actual costs to be incurred on this contract.

ATTACHMENT JL.3

Option Yr 3

OPTION YEAR 3 PRICE MODEL WORKSHEET JL.3
LABOR CATEGORIES, RATES AND HOURS- Table 12080
Labor Category- ABRate ($/hr)- CDHours ETotal ($) F
Program Managerx2080$0.00
Technical Project Managerx10400$0.00
Marine Biologistx2080$0.00
Wildlife Biologist/Zoologistx2080$0.00
Marine Bioacousticianx2080$0.00
Biostatisticianx1040$0.00
Marine Species Observerx4160$0.00
Fisheries Biologist and Oceanographerx2080$0.00
Biological/Laboratory Technicianx2080$0.00
Technical Editorx1040$0.00
GIS Analystx2080$0.00
Web/app Developerx2080$0.00
Database Managerx1040$0.00
Clerical/Administrativex1040$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
$0.00
TOTAL TABLE 1(BURDENED LABOR)35360$0.00
BASE YEAR
OTHER DIRECT COSTS AND MULTPLIERS - TABLE 2
Other Direct Costs (Equipment, Supplies, Materials, etc.)$500,000.00
Burden (multiplier JL.1)applied to Other Direct Costs (%)x$500,000.00$0.00
Subcontractors$6,000,000.00
Burden (Multiplier JL.1) applied to Subcontractors (%)x$6,000,000.00$0.00
Travel$250,000.00
Burden (Multiplier JL.1) applied to travel (%)x$250,000.00$0.00

Total (ODCs, travel and subcontrator cost with burden)

Direct Costs applied to labor base
(e.g. computer services $ per hour)x$0.00
Burden (Multiplier) applied to direct costs added to labor base
Total direct cost applied to labor base with burden

TOTAL TABLE 2 $6,750,000.00

TOTAL OPTION YEAR 3 (Burdened Labor, "Other Direct Costs," and Subcontractors) $7,250,000.00

Notes:
1. Offeror shall not add labor categories, make structural changes, or change the hours on this form.
2. The only entries shall be in column "C". No other columns shall be changed, modified or deleted,
with the exception of Column "E" for "Direct Costs applied to labor base". See note 5 below.
3. Offeror shall only utilize listed labor categories and input burdened direct labor hourly ceiling rates from Attachment JL.1.
4. Under "Other Direct Costs and Multipliers,"offerors shall input under column "C" the applicable multipliers for ODCs,
subcontractors and travel from Attachment JL.1 Chart 2.
5. Offerors shall input the "Direct Costs Applied to Labor Base" from Attachment JL.1 Chart 2. The number of
hours listed in Column "E" for "Direct Cost Applied to Labor Base" reflects the total number of hours under Table 1 above.
If the "Direct Cost" is not applied to the total labor base, e.g. applied to only certain labor categories, adjust the number of hours
in Column E to reflect the correct number of hours using the applicable hours from Table 1 above.
If more than one "Direct Cost" (e.g. $3.00/hr. Computer usage and $2.50/hr. health and safety is applicable,
Modify Table 2 as necessary to show these costs.
6. Table 2 does not include any formulas. In addition to hard copies, Offerors shall submit this form in Microsoft Excel
format on a CD showing all calculations (i.e. multiplier application to other direct costs) used to arrive at the total cost.
7. The direct cost amounts presented above are for informational purposes only and not necessarily
representative of actual costs to be incurred on this contract.

Option Yr 4

OPTION YEAR 4 PRICE MODEL WORKSHEET JL.3
LABOR CATEGORIES, RATES AND HOURS- Table 12080
Labor Category- ABRate ($/hr)- CDHours ETotal ($) F
Program Managerx2080$0.00
Technical Project Managerx10400$0.00
Marine Biologistx2080$0.00
Wildlife Biologist/Zoologistx2080$0.00
Marine Bioacousticianx2080$0.00
Biostatisticianx1040$0.00
Marine Species Observerx4160$0.00
Fisheries Biologist and Oceanographerx2080$0.00
Biological/Laboratory Technicianx2080$0.00
Technical Editorx1040$0.00
GIS Analystx2080$0.00
Web/app Developerx2080$0.00
Database Managerx1040$0.00
Clerical/Administrativex1040$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
x$0.00
$0.00
TOTAL TABLE 1(BURDENED LABOR)35360$0.00
BASE YEAR
OTHER DIRECT COSTS AND MULTPLIERS - TABLE 2
Other Direct Costs (Equipment, Supplies, Materials, etc.)$500,000.00
Burden (multiplier JL.1)applied to Other Direct Costs (%)x$500,000.00$0.00
Subcontractors$6,000,000.00
Burden (Multiplier JL.1) applied to Subcontractors (%)x$6,000,000.00$0.00
Travel$250,000.00
Burden (Multiplier JL.1) applied to travel (%)x$250,000.00$0.00

Total (ODCs, travel and subcontrator cost with burden)

Direct Costs applied to labor base
(e.g. computer services $ per hour)x$0.00
Burden (Multiplier) applied to direct costs added to labor base
Total direct cost applied to labor base with burden

TOTAL TABLE 2 $6,750,000.00

TOTAL OPTION YEAR 4(Burdened Labor, "Other Direct Costs," and Subcontractors) $7,250,000.00

Notes:
1. Offeror shall not add labor categories, make structural changes, or change the hours on this form.
2. The only entries shall be in column "C". No other columns shall be changed, modified or deleted,
with the exception of Column "E" for "Direct Costs applied to labor base". See note 5 below.
3. Offeror shall only utilize listed labor categories and input burdened direct labor hourly ceiling rates from Attachment JL.1.
4. Under "Other Direct Costs and Multipliers,"offerors shall input under column "C" the applicable multipliers for ODCs,
subcontractors and travel from Attachment JL.1 Chart 2.
5. Offerors shall input the "Direct Costs Applied to Labor Base" from Attachment JL.1 Chart 2. The number of
hours listed in Column "E" for "Direct Cost Applied to Labor Base" reflects the total number of hours under Table 1 above.
If the "Direct Cost" is not applied to the total labor base, e.g. applied to only certain labor categories, adjust the number of hours
in Column E to reflect the correct number of hours using the applicable hours from Table 1 above.
If more than one "Direct Cost" (e.g. $3.00/hr. Computer usage and $2.50/hr. health and safety is applicable,
Modify Table 2 as necessary to show these costs.
6. Table 2 does not include any formulas. In addition to hard copies, Offerors shall submit this form in Microsoft Excel
format on a CD showing all calculations (i.e. multiplier application to other direct costs) used to arrive at the total cost.
7. The direct cost amounts presented above are for informational purposes only and not necessarily
representative of actual costs to be incurred on this contract.

Sum Cost Model for Multiple Off

PRICE MODEL SUMMARY SHEET JL.4
THIS FORM TO BE SUBMITTED BY PRIME CONTRACTOR/JV ENTITY ONLY
BASE YEARTotal Price Model Value for Base Year% of work (JL.2)Total Value of Base Year based on % of Work
Prime / JV member$0.00$0.00
Prime/JV member$0.00$0.00
Key Subcontractor$0.00$0.00
Key Subcontractor$0.00$0.00
100%$0.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV multiplier ceiling mark-up on Key Subcontactors as provided on JL.1$0.00$0.00
TOTAL VALUE OF PRICE MODEL FOR BASE YEAR$0.00
OPTION YEAR 1Total Price Model Value for First Option Year% of work (JL.2)Total Value of First Option Year based on % of Work
Prime / JV member$0.00$0.00
Prime/JV member$0.00$0.00
Key Subcontractor$0.00$0.00
Key Subcontractor$0.00$0.00
100%$0.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV multiplier ceiling mark-up on Key Subcontactors as provided on JL.1$0.00$0.00
TOTAL VALUE OF PRICE MODEL FOR OPTION YEAR 1$0.00
OPTION YEAR 2Total Price Model Value for Second Option Year% of work (JL.2)Total Value of Second Option Year based on % of Work
Prime / JV member$0.00$0.00
Prime/JV member$0.00$0.00
Key Subcontractor$0.00$0.00
Key Subcontractor$0.00$0.00
100%$0.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV multiplier ceiling mark-up on Key Subcontactors as provided on JL.1$0.00$0.00
TOTAL VALUE OF PRICE MODEL FOR OPTION YEAR 2$0.00
OPTION YEAR 3Total Price Model Value for Second Option Year% of work (JL.2)Total Value of Second Option Year based on % of Work
Prime / JV member$0.00$0.00
Prime/JV member$0.00$0.00
Key Subcontractor$0.00$0.00
Key Subcontractor$0.00$0.00
100%$0.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV multiplier ceiling mark-up on Key Subcontactors as provided on JL.1$0.00$0.00
TOTAL VALUE OF PRICE MODEL OPTION YEAR 3$0.00
OPTION YEAR 4Total Price Model Value for Second Option Year% of work (JL.2)Total Value of Second Option Year based on % of Work
Prime / JV member$0.00$0.00
Prime/JV member$0.00$0.00
Key Subcontractor$0.00$0.00
Key Subcontractor$0.00$0.00
100%$0.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV multiplier ceiling mark-up on Key Subcontactors as provided on JL.1$0.00$0.00
TOTAL VALUE OF PRICE MODEL FOR OPTION YEAR 4$0.00

1. For evaluation purposes, the Governmentwill utilize the percentages listed on Attachment JL.2 (Distribution of Work) rodger.jackson: rodger.jackson:

Make sure proper JL is referenced

(this will be performed for the base and each option year) to arrive at a TOTAL PRICE MODEL VALUE (PER YEAR)
2. In the event an offeror utilizes multiple cost centers, the price model will be filled out for each cost center expected to be utilized in the performance of this contract.
For evaluation purposes, the cost center with the highest "Total" price for the price model will be utilized.
3. Key Subcontractor mark-up : If the prime contractor is a JV, the rate for the JV member with the highest ceiling rate mark-up for a Key sub will be used.
In addittion to hard copy, offerors shall submit this form in Microsoft Excel format on CD.
SEE ADDITIONAL INSTRUCTIONS IN SECTION L.
SAMPLE
Total Price Model Value for Base Year% of work (JL.2)Total Value of Base Year based on % of Work
Prime / JV member$490,000.0030%$147,000.00
Prime/JV member$505,000.0025%$126,250.00
Key Subcontractor A$479,000.0020%$95,800.00
Key Subcontractor B$515,000.0025%$128,750.00
100%$497,800.00
Key Sub Total% Mark-upKey Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontactors,i.e. G&A, as provided on JL.5$224,550.007.5%$16,841.25
TOTAL VALUE OF PRICE MODEL FOR BASE YEAR$514,641.25

rodger.jackson: rodger.jackson:

Make sure proper JL is referenced

ATTACHMENT JL.4

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