Attachment_2_-_Price_Proposal_Worksheet.xlsx

XLSX spreadsheet 76 KB Posted

Attached to
National Administrative Support Services Federal contract opportunity
Solicitation number
AG-SPEC-S-16-0028
Issued by
Department of Agriculture National Resources Conservation Service Headquarters

About this file

Attachment 2 - Price Proposal Worksheet *.xls

View the file

Other files for this federal contract opportunity

Show all 12

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

Text version

Proposal

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
Region 3
Prime Contractor Information:INSTRUCTIONS:
(Contractor Name)Offerors are required to propose fixed-price, pre-established profit and overhead rates. These rates will be used to calculate fully burdened labor rates by adding the offeror’s profit and overhead to the salary (including fringe) for the applicable position(s). For the purposes of this source selection document, the offeror shall use the Washington, DC using local wage rates from Wage Determination: 15-4281 Revision: 2 Dated: 12/29/2015. PLEASE NOTE: Salary and fringe benefits may be edited by the contractor, but must be equal to, or exceed, the applicable Wage Determination rate. Shaded fields contain formulas.
(Contractor Address)
(Contractor Address)
(Contractor Address)
(City, State, Zip)
(DUNS NUMBER)
REGION(S) PROPOSED
Offeror may request consideration for one region, multiple regions, or all regions. A separate proposal must be submitted for each region.REGION
Region 1
PROPOSED RATESBase YearOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4
Overhead and Profit %10.00%15.00%20.00%30.00%35.00%
AVERAGE/MEDIAN RATES OVER LIFE OF CONTRACT
Average Overhead and Profit Rate22.00%
Median Overhead and Profit Rate20.00%
Average Fully Burdened Rate$27.46
Median Fully Burdened Rate$26.59
SAMPLE TASK ORDER (TO) PRICING
The Offeror's proposal would result in the following fully burdened contract rate for positions based in Washington, DC using local wage rates from Wage Determination: 15-4281 Revision: 2 Dated: 12/29/2015. The Salary and Fringe field pre-populates with the WDC SCA salary and fringe minimum for the position. Contractors may edit the field to exceed this amount if desired. Salary and fringe amount must equal or exceed the applicable SCA Wage Determination.
Base YearOPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4
Occupation CodeSalary and FringeOverhead and Profit %Total RateSalary and FringeOverhead and Profit %Total RateSalary and FringeOverhead and Profit %Total RateSalary and FringeOverhead and Profit %Total RateSalary and FringeOverhead and Profit %Total Rate
01011 Accounting Clerk I$20.8610.00%$22.95$20.8615.00%$23.99$20.8620.00%$25.03$20.8630.00%$27.12$20.8635.00%$28.16
01012 Accounting Clerk II$22.8810.00%$25.17$22.8815.00%$26.31$22.8820.00%$27.46$22.8830.00%$29.74$22.8835.00%$30.89
01013 Accounting Clerk III$26.5710.00%$29.23$26.5715.00%$30.56$26.5720.00%$31.88$26.5730.00%$34.54$26.5735.00%$35.87
01020 Administrative Assistant$35.6810.00%$39.25$35.6815.00%$41.03$35.6820.00%$42.82$35.6830.00%$46.38$35.6835.00%$48.17
01041 Customer Service Representative I$18.6710.00%$20.54$18.6715.00%$21.47$18.6720.00%$22.40$18.6730.00%$24.27$18.6735.00%$25.20
01042 Customer Service Representative II$20.4510.00%$22.50$20.4515.00%$23.52$20.4520.00%$24.54$20.4530.00%$26.59$20.4535.00%$27.61
01043 Customer Service Representative III$21.9310.00%$24.12$21.9315.00%$25.22$21.9320.00%$26.32$21.9330.00%$28.51$21.9335.00%$29.61
01051 Data Entry Operator I$18.9810.00%$20.88$18.9815.00%$21.83$18.9820.00%$22.78$18.9830.00%$24.67$18.9835.00%$25.62
01052 Data Entry Operator II$20.3210.00%$22.35$20.3215.00%$23.37$20.3220.00%$24.38$20.3230.00%$26.42$20.3235.00%$27.43
01070 Document Preparation Clerk$18.9710.00%$20.87$18.9715.00%$21.82$18.9720.00%$22.76$18.9730.00%$24.66$18.9735.00%$25.61
01090 Duplicating Machine Operator$18.9710.00%$20.87$18.9715.00%$21.82$18.9720.00%$22.76$18.9730.00%$24.66$18.9735.00%$25.61
01111 General Clerk I$19.1510.00%$21.07$19.1515.00%$22.02$19.1520.00%$22.98$19.1530.00%$24.90$19.1535.00%$25.85
01112 General Clerk II$20.5110.00%$22.56$20.5115.00%$23.59$20.5120.00%$24.61$20.5130.00%$26.66$20.5135.00%$27.69
01113 General Clerk III$23.0110.00%$25.31$23.0115.00%$26.46$23.0120.00%$27.61$23.0130.00%$29.91$23.0135.00%$31.06
01141 Messenger Courier$19.2510.00%$21.18$24.0115.00%$27.61$24.0120.00%$28.81$24.0130.00%$31.21$24.0135.00%$32.41
01191 Order Clerk I$19.3910.00%$21.33$25.0115.00%$28.76$25.0120.00%$30.01$25.0130.00%$32.51$25.0135.00%$33.76
01192 Order Clerk II$20.7710.00%$22.85$26.0115.00%$29.91$26.0120.00%$31.21$26.0130.00%$33.81$26.0135.00%$35.11
1261 Personnel Assistant (Employment)$22.4210.00%$24.66$22.4215.00%$25.78$22.4220.00%$26.90$22.4230.00%$29.15$22.4235.00%$30.27
1262 Personnel Assistant (Employment)$24.5910.00%$27.05$24.5915.00%$28.28$24.5920.00%$29.51$24.5930.00%$31.97$24.5935.00%$33.20
1263 Personnel Assistant (Employment)$26.9210.00%$29.61$26.9215.00%$30.96$26.9220.00%$32.30$26.9230.00%$35.00$26.9235.00%$36.34
1311 Secretary I$22.3410.00%$24.57$22.3415.00%$25.69$22.3420.00%$26.81$22.3430.00%$29.04$22.3435.00%$30.16
1312 Secretary II$24.4510.00%$26.90$24.4515.00%$28.12$24.4520.00%$29.34$24.4530.00%$31.79$24.4535.00%$33.01
1313 Secretary III$29.5610.00%$32.52$29.5615.00%$33.99$29.5620.00%$35.47$29.5630.00%$38.43$29.5635.00%$39.91
1460 Switchboard Operator/Receptionist$18.7010.00%$20.57$18.7015.00%$21.51$18.7020.00%$22.44$18.7030.00%$24.31$18.7035.00%$25.25
1531 Travel Clerk I$17.7310.00%$19.50$19.7015.00%$22.66$19.7020.00%$23.64$19.7030.00%$25.61$19.7035.00%$26.60
1532 Travel Clerk II$18.7310.00%$20.60$20.7015.00%$23.81$20.7020.00%$24.84$20.7030.00%$26.91$20.7035.00%$27.95
1533 Travel Clerk III$19.8010.00%$21.78$21.7015.00%$24.96$21.7020.00%$26.04$21.7030.00%$28.21$21.7035.00%$29.30
1611 Word Processor I$19.9010.00%$21.89$19.9015.00%$22.89$19.9020.00%$23.88$19.9030.00%$25.87$19.9035.00%$26.87
1612 Word Processor II$21.9410.00%$24.13$21.9415.00%$25.23$21.9420.00%$26.33$21.9430.00%$28.52$21.9435.00%$29.62
1613 Word Processor III$24.2210.00%$26.64$24.2215.00%$27.85$24.2220.00%$29.06$24.2230.00%$31.49$24.2235.00%$32.70

SOURCE SELECTION INFORMATION

SEE FAR 2.101 AND FAR 3.104 &"Arial,Bold"&12

PRICE PROPOSAL WORKSHEET AG-SPEC-S-16-0022

Attachment 2

Sheet1

BaseFringeTotal
1011Accounting Clerk I1011 Accounting Clerk I16.594.2720.86
1012Accounting Clerk II1012 Accounting Clerk II18.614.2722.88
1013Accounting Clerk III1013 Accounting Clerk III22.34.2726.57
1020Administrative Assistant1020 Administrative Assistant31.414.2735.68
1041Customer Service Representative I1041 Customer Service Representative I14.44.2718.67
1042Customer Service Representative II1042 Customer Service Representative II16.184.2720.45
1043Customer Service Representative III1043 Customer Service Representative III17.664.2721.93
1051Data Entry Operator I1051 Data Entry Operator I14.714.2718.98
1052Data Entry Operator II1052 Data Entry Operator II16.054.2720.32
1060Document Preparation Clerk1060 Document Preparation Clerk14.74.2718.97
1090Duplicating Machine Operator1090 Duplicating Machine Operator14.74.2718.97
1111General Clerk I1111 General Clerk I14.884.2719.15
1112General Clerk II1112 General Clerk II16.244.2720.51
1113General Clerk III1113 General Clerk III18.744.2723.01
1120Housing Referral Assistant1120 Housing Referral Assistant25.294.2729.56
1141Messenger Courier1141 Messenger Courier14.984.2719.25
1191Order Clerk I1191 Order Clerk I15.124.2719.39
1192Order Clerk II1192 Order Clerk II16.54.2720.77
1261Personnel Assistant (Employment)1261 Personnel Assistant (Employment)18.154.2722.42
1262Personnel Assistant (Employment)1262 Personnel Assistant (Employment)20.324.2724.59
1263Personnel Assistant (Employment)1263 Personnel Assistant (Employment)22.654.2726.92
1270Production Control Clerk1270 Production Control Clerk24.234.2728.5
1290Rental Clerk1290 Rental Clerk16.554.2720.82
1300Scheduler, Maintenance1300 Scheduler, Maintenance18.074.2722.34
1311Secretary I1311 Secretary I18.074.2722.34
1312Secretary II1312 Secretary II20.184.2724.45
1313Secretary III1313 Secretary III25.294.2729.56
1320Sevice Order Dispatcher1320 Sevice Order Dispatcher16.984.2721.25
1410Supply Technician1410 Supply Technician31.414.2735.68
1420Survey Worker1420 Survey Worker20.034.2724.3
1460Switchboard Operator/Receptionist1460 Switchboard Operator/Receptionist14.434.2718.7
1531Travel Clerk I1531 Travel Clerk I13.464.2717.73
1532Travel Clerk II1532 Travel Clerk II14.464.2718.73
1533Travel Clerk III1533 Travel Clerk III15.534.2719.8
1611Word Processor I1611 Word Processor I15.634.2719.9
1612Word Processor II1612 Word Processor II17.674.2721.94
1613Word Processor III1613 Word Processor III19.954.2724.22

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