Attachment J-2 Pricing Matrix Template.xlsx

XLSX spreadsheet 55 KB Posted

Attached to
Amendment 0006 - Financial Management Oversight (FMO) Program
Solicitation number
69319521R000003
Issued by

View the file

Other files

Show all 16

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

Base Year

CLINDescriptionLabor RatePercentage Discount from initial labor rateDiscounted Labor RateEstimated LOE TOTAL/ YearEstimated QuantityTotal Price
0001Program ManagementFFP, LH
Partner400$0.00
LaborSr. Manager500$0.00
CategoriesTransit Financial Analyst400$0.00
Sr. Account150$0.00
Staff Accountant75$0.00
Adminstrative Assistant0$0.00
TOTAL1525$0.00
0002Special AssignmentNTE LH
Partner450$0.00
Labor CategoriesSr. Manager600$0.00
Transit Financial Analyst45$0.00
Sr. Account500$0.00
Staff Accountant200$0.00
Adminstrative Assistant100$0.00
TOTAL1895$0.00
0003FMO Oversight ReviewsLH
Partner1250$0.00
Labor CategoriesSr. Manager2125$0.00
Transit Financial Analyst1875$0.00
Sr. Account1600$0.00
Staff Accountant1350$0.00
Adminstrative Assistant375$0.00
TOTAL8575$0.00
0004FMO Resource Manual and Workshop WorkbookNTE LH
Partner250$0.00
Labor CategoriesSr. Manager300$0.00
Transit Financial Analyst225$0.00
Sr. Account250$0.00
Staff Accountant60$0.00
Adminstrative Assistant0$0.00
TOTAL1085$0.00
0005Corrective Action SupportNTE LH
Partner500$0.00
Labor CategoriesSr. Manager675$0.00
Transit Financial Analyst450$0.00
Sr. Account500$0.00
Staff Accountant400$0.00
Adminstrative Assistant125$0.00
TOTAL2650$0.00
0006Targeted Technical AssistanceNTE LH
Partner500$0.00
Labor CategoriesSr. Manager725$0.00
Transit Financial Analyst475$0.00
Sr. Account500$0.00
Staff Accountant400$0.00
Adminstrative Assistant100$0.00
TOTAL2700$0.00
0007FMO TrainingNTE LH
Partner500$0.00
Labor CategoriesSr. Manager500$0.00
Transit Financial Analyst200$0.00
Sr. Account0$0.00
Staff Accountant0$0.00
Adminstrative Assistant0$0.00
TOTAL1200$0.00
0008FMO Program ReportsNTE LH
Partner50$0.00
Labor CategoriesSr. Manager100$0.00
Transit Financial Analyst50$0.00
Sr. Account50$0.00
Staff Accountant50$0.00
Adminstrative Assistant25$0.00
TOTAL325$0.00
0009Risk AssessmentsNTE LH
Partner500$0.00
Labor CategoriesSr. Manager600$0.00
Transit Financial Analyst500$0.00
Sr. Account400$0.00
Staff Accountant250$0.00
Adminstrative Assistant100$0.00
TOTAL2350$0.00
0010Regional WorkshopsNTE LH
Partner200$0.00
Labor CategoriesSr. Manager200$0.00
Transit Financial Analyst100$0.00
Sr. Account0$0.00
Staff Accountant0$0.00
Adminstrative Assistant0$0.00
TOTAL500$0.00
0011Innovation TraningNTE LH
Partner200$0.00
Labor CategoriesSr. Manager250$0.00
Transit Financial Analyst200$0.00
Sr. Account200$0.00
Staff Accountant100$0.00
Adminstrative Assistant50$0.00
TOTAL1000$0.00
0012Other Direct CostsNTE$10,000
0013TravelNTE$800,000
Total Price$810,000.00

Option Yr. 1

CLINDescriptionLabor RatePercentage Discount from initial labor rateDiscounted Labor RateEstimated LOE TOTAL/ YearEstimated QuantityTotal Price
0001Program ManagementNTE LH
Partner$0.00400$0.00
LaborSr. Manager$0.00500$0.00
CategoriesTransit Financial Analyst$0.00400$0.00
Sr. Account$0.00150$0.00
Staff Accountant$0.0075$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1525$0.00
0002Special AssignmentNTE LH
Partner$0.00450$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.0045$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00200$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL1895$0.00
0003FMO Oversight ReviewsFFP, LH
Partner$0.001250$0.00
Labor CategoriesSr. Manager$0.002125$0.00
Transit Financial Analyst$0.001875$0.00
Sr. Account$0.001600$0.00
Staff Accountant$0.001350$0.00
Adminstrative Assistant$0.00375$0.00
TOTAL8575$0.00
0004FMO Resource Manual and Workshop WorkbookNTE LH
Partner$0.00250$0.00
Labor CategoriesSr. Manager$0.00300$0.00
Transit Financial Analyst$0.00225$0.00
Sr. Account$0.00250$0.00
Staff Accountant$0.0060$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1085$0.00
0005Corrective Action SupportNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00675$0.00
Transit Financial Analyst$0.00450$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00125$0.00
TOTAL2650$0.00
0006Targeted Technical AssistanceNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00725$0.00
Transit Financial Analyst$0.00475$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2700$0.00
0007FMO TrainingNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00500$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1200$0.00
0008FMO Program ReportsNTE LH
Partner$0.0050$0.00
Labor CategoriesSr. Manager$0.00100$0.00
Transit Financial Analyst$0.0050$0.00
Sr. Account$0.0050$0.00
Staff Accountant$0.0050$0.00
Adminstrative Assistant$0.0025$0.00
TOTAL325$0.00
0009Risk AssessmentsNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.00500$0.00
Sr. Account$0.00400$0.00
Staff Accountant$0.00250$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2350$0.00
0010Regional WorkshopsNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00200$0.00
Transit Financial Analyst$0.00100$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL500$0.00
0011Innovation TraningNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00250$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.00200$0.00
Staff Accountant$0.00100$0.00
Adminstrative Assistant$0.0050$0.00
TOTAL1000$0.00
0012Other Direct CostsNTE$10,000
0013TravelNTE$800,000
Total Price$810,000.00

Option Yr. 2

CLINDescriptionLabor RatePercentage Discount from initial labor rateDiscounted Labor RateEstimated LOE TOTAL/ YearEstimated QuantityTotal Price
0001Program ManagementNTE LH
Partner$0.00400$0.00
LaborSr. Manager$0.00500$0.00
CategoriesTransit Financial Analyst$0.00400$0.00
Sr. Account$0.00150$0.00
Staff Accountant$0.0075$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1525$0.00
0002Special AssignmentNTE LH
Partner$0.00450$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.0045$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00200$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL1895$0.00
0003FMO Oversight ReviewsFFP, LH
Partner$0.001250$0.00
Labor CategoriesSr. Manager$0.002125$0.00
Transit Financial Analyst$0.001875$0.00
Sr. Account$0.001600$0.00
Staff Accountant$0.001350$0.00
Adminstrative Assistant$0.00375$0.00
TOTAL8575$0.00
0004FMO Resource Manual and Workshop WorkbookNTE LH
Partner$0.00250$0.00
Labor CategoriesSr. Manager$0.00300$0.00
Transit Financial Analyst$0.00225$0.00
Sr. Account$0.00250$0.00
Staff Accountant$0.0060$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1085$0.00
0005Corrective Action SupportNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00675$0.00
Transit Financial Analyst$0.00450$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00125$0.00
TOTAL2650$0.00
0006Targeted Technical AssistanceNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00725$0.00
Transit Financial Analyst$0.00475$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2700$0.00
0007FMO TrainingNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00500$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1200$0.00
0008FMO Program ReportsNTE LH
Partner$0.0050$0.00
Labor CategoriesSr. Manager$0.00100$0.00
Transit Financial Analyst$0.0050$0.00
Sr. Account$0.0050$0.00
Staff Accountant$0.0050$0.00
Adminstrative Assistant$0.0025$0.00
TOTAL325$0.00
0009Risk AssessmentsNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.00500$0.00
Sr. Account$0.00400$0.00
Staff Accountant$0.00250$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2350$0.00
0010Regional WorkshopsNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00200$0.00
Transit Financial Analyst$0.00100$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL500$0.00
0011Innovation TraningNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00250$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.00200$0.00
Staff Accountant$0.00100$0.00
Adminstrative Assistant$0.0050$0.00
TOTAL1000$0.00
0012Other Direct CostsNTE$10,000
0013TravelNTE$800,000
Total Price$810,000.00

Option Yr. 3

CLINDescriptionLabor RatePercentage Discount from initial labor rateDiscounted Labor RateEstimated LOE TOTAL/ YearEstimated QuantityTotal Price
0001Program ManagementNTE LH
Partner$0.00400$0.00
LaborSr. Manager$0.00500$0.00
CategoriesTransit Financial Analyst$0.00400$0.00
Sr. Account$0.00150$0.00
Staff Accountant$0.0075$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1525$0.00
0002Special AssignmentNTE LH
Partner$0.00450$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.0045$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00200$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL1895$0.00
0003FMO Oversight ReviewsFFP, LH
Partner$0.001250$0.00
Labor CategoriesSr. Manager$0.002125$0.00
Transit Financial Analyst$0.001875$0.00
Sr. Account$0.001600$0.00
Staff Accountant$0.001350$0.00
Adminstrative Assistant$0.00375$0.00
TOTAL8575$0.00
0004FMO Resource Manual and Workshop WorkbookNTE LH
Partner$0.00250$0.00
Labor CategoriesSr. Manager$0.00300$0.00
Transit Financial Analyst$0.00225$0.00
Sr. Account$0.00250$0.00
Staff Accountant$0.0060$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1085$0.00
0005Corrective Action SupportNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00675$0.00
Transit Financial Analyst$0.00450$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00125$0.00
TOTAL2650$0.00
0006Targeted Technical AssistanceNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00725$0.00
Transit Financial Analyst$0.00475$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2700$0.00
0007FMO TrainingNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00500$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1200$0.00
0008FMO Program ReportsNTE LH
Partner$0.0050$0.00
Labor CategoriesSr. Manager$0.00100$0.00
Transit Financial Analyst$0.0050$0.00
Sr. Account$0.0050$0.00
Staff Accountant$0.0050$0.00
Adminstrative Assistant$0.0025$0.00
TOTAL325$0.00
0009Risk AssessmentsNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.00500$0.00
Sr. Account$0.00400$0.00
Staff Accountant$0.00250$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2350$0.00
0010Regional WorkshopsNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00200$0.00
Transit Financial Analyst$0.00100$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL500$0.00
0011Innovation TraningNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00250$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.00200$0.00
Staff Accountant$0.00100$0.00
Adminstrative Assistant$0.0050$0.00
TOTAL1000$0.00
0012Other Direct CostsNTE$10,000
0013TravelNTE$800,000
Total Price$810,000.00

Option Yr. 4

CLINDescriptionLabor RatePercentage Discount from initial labor rateDiscounted Labor RateEstimated LOE TOTAL/ YearEstimated QuantityTotal Price
0001Program ManagementNTE LH
Partner$0.00400$0.00
LaborSr. Manager$0.00500$0.00
CategoriesTransit Financial Analyst$0.00400$0.00
Sr. Account$0.00150$0.00
Staff Accountant$0.0075$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1525$0.00
0002Special AssignmentNTE LH
Partner$0.00450$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.0045$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00200$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL1895$0.00
0003FMO Oversight ReviewsFFP, LH
Partner$0.001250$0.00
Labor CategoriesSr. Manager$0.002125$0.00
Transit Financial Analyst$0.001875$0.00
Sr. Account$0.001600$0.00
Staff Accountant$0.001350$0.00
Adminstrative Assistant$0.00375$0.00
TOTAL8575$0.00
0004FMO Resource Manual and Workshop WorkbookNTE LH
Partner$0.00250$0.00
Labor CategoriesSr. Manager$0.00300$0.00
Transit Financial Analyst$0.00225$0.00
Sr. Account$0.00250$0.00
Staff Accountant$0.0060$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1085$0.00
0005Corrective Action SupportNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00675$0.00
Transit Financial Analyst$0.00450$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00125$0.00
TOTAL2650$0.00
0006Targeted Technical AssistanceNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00725$0.00
Transit Financial Analyst$0.00475$0.00
Sr. Account$0.00500$0.00
Staff Accountant$0.00400$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2700$0.00
0007FMO TrainingNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00500$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL1200$0.00
0008FMO Program ReportsNTE LH
Partner$0.0050$0.00
Labor CategoriesSr. Manager$0.00100$0.00
Transit Financial Analyst$0.0050$0.00
Sr. Account$0.0050$0.00
Staff Accountant$0.0050$0.00
Adminstrative Assistant$0.0025$0.00
TOTAL325$0.00
0009Risk AssessmentsNTE LH
Partner$0.00500$0.00
Labor CategoriesSr. Manager$0.00600$0.00
Transit Financial Analyst$0.00500$0.00
Sr. Account$0.00400$0.00
Staff Accountant$0.00250$0.00
Adminstrative Assistant$0.00100$0.00
TOTAL2350$0.00
0010Regional WorkshopsNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00200$0.00
Transit Financial Analyst$0.00100$0.00
Sr. Account$0.000$0.00
Staff Accountant$0.000$0.00
Adminstrative Assistant$0.000$0.00
TOTAL500$0.00
0011Innovation TraningNTE LH
Partner$0.00200$0.00
Labor CategoriesSr. Manager$0.00250$0.00
Transit Financial Analyst$0.00200$0.00
Sr. Account$0.00200$0.00
Staff Accountant$0.00100$0.00
Adminstrative Assistant$0.0050$0.00
TOTAL1000$0.00
0012Other Direct CostsNTE$10,000
0013TravelNTE$800,000
Total Price$810,000.00

Hours Summary

CLINDescriptionEstimated LOE TOTAL/ YearEstimated LOE TOTAL/ 5 Years
0001Program Management
Partner4002000
LaborSr. Manager5002500
CategoriesTransit Financial Analyst4002000
Sr. Account150750
Staff Accountant75375
Adminstrative Assistant00
TOTAL15257625
0002Special Assignment
Partner4502250
Labor CategoriesSr. Manager6003000
Transit Financial Analyst45225
Sr. Account5002500
Staff Accountant2001000
Adminstrative Assistant100500
TOTAL18959475
0003FMO Oversight Reviews
Partner12506250
Labor CategoriesSr. Manager212510625
Transit Financial Analyst18759375
Sr. Account16008000
Staff Accountant13506750
Adminstrative Assistant3751875
TOTAL857542875
0004FMO Resource Manual and Workshop Workbook
Partner2501250
Labor CategoriesSr. Manager3001500
Transit Financial Analyst2251125
Sr. Account2501250
Staff Accountant60300
Adminstrative Assistant00
TOTAL10855425
0005Corrective Action Support
Partner5002500
Labor CategoriesSr. Manager6753375
Transit Financial Analyst4502250
Sr. Account5002500
Staff Accountant4002000
Adminstrative Assistant125625
TOTAL265013250
0006Targeted Technical Assistance
Partner5002500
Labor CategoriesSr. Manager7253625
Transit Financial Analyst4752375
Sr. Account5002500
Staff Accountant4002000
Adminstrative Assistant100500
TOTAL270013500
0007FMO Training
Partner5002500
Labor CategoriesSr. Manager5002500
Transit Financial Analyst2001000
Sr. Account00
Staff Accountant00
Adminstrative Assistant00
TOTAL12006000
0008FMO Program Reports
Partner50250
Labor CategoriesSr. Manager100500
Transit Financial Analyst50250
Sr. Account50250
Staff Accountant50250
Adminstrative Assistant25125
TOTAL3251625
0009Risk Assessments
Partner5002500
Labor CategoriesSr. Manager6003000
Transit Financial Analyst5002500
Sr. Account4002000
Staff Accountant2501250
Adminstrative Assistant100500
TOTAL235011750
0010Regional Workshops
Partner2001000
Labor CategoriesSr. Manager2001000
Transit Financial Analyst100500
Sr. Account00
Staff Accountant00
Adminstrative Assistant00
TOTAL5002500
0011Innovation Traning
Partner2001000
Labor CategoriesSr. Manager2501250
Transit Financial Analyst2001000
Sr. Account2001000
Staff Accountant100500
Adminstrative Assistant50250
TOTAL10005000
0012Other Direct Costs
0013Travel
Total PriceTotal Price

Summary by Labor Category

LABOR CATEGORIESBASEEST. HRSTOTALOPTION YR1EST. HRSTOTALOPTION YR2EST. HRSTOTALOPTION YR3EST. HRSTOTALOPTION YR4EST. HRSTOTALGrand Total
Partner/Principal$0.004800$0.00$0.004800$0.00$0.004800$0.00$0.004800$0.00$0.004800$0.00
Senior Manager$0.006575$0.00$0.006575$0.00$0.006575$0.00$0.006575$0.00$0.006575$0.00
Transit financial analyst$0.004520$0.00$0.004520$0.00$0.004520$0.00$0.004520$0.00$0.004520$0.00
Senior Accountant$0.004150$0.00$0.004150$0.00$0.004150$0.00$0.004150$0.00$0.004150$0.00
Accountant$0.002885$0.00$0.002885$0.00$0.002885$0.00$0.002885$0.00$0.002885$0.00
Administrative Assistant$0.00875$0.00$0.00875$0.00$0.00875$0.00$0.00875$0.00$0.00875$0.00
23805238052380523805238050
ODC$10,000.00$10,000.00$10,000.00$10,000.00$10,000.00
TRAVEL$800,000.00$800,000.00$800,000.00$800,000.00$800,000.00

Per Performance Year TOTAL $810,000.00 $810,000.00 $810,000.00 $810,000.00 $810,000.00 $4,050,000.00

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