Attachment_2_-_Price_Proposal_Worksheet_v2.xlsx

XLSX spreadsheet 309 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

Amended - Attachment 2 Price Proposal Worksheet - Required

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

BASE YEAR

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
Region 3
Prime Contractor Information:INSTRUCTIONS:Region 4
(Contractor Name)Offerors are required to propose fixed-price, pre-established profit, G&A, and overhead rates. These rates will be used to calculate fully burdened labor rates by adding the offeror’s profit, G&A, 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. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination. 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 2
PROPOSED RATESBase YearOption Year 1Option Year 2Option Year 3Option Year 4
Overhead %
G&A %
Profit %
SAMPLE TASK ORDER (TO) PRICING - BASE YEAR
Offeror shall complete the following table for the base year and all option years. Additional option years are located in the four (4) tabs located at the bottom of this document. 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 field currently pre-populates with WDC SCA salary minimums for the applicable positions. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination.
Base Year
HourlyFringeOverheadG&AProfit/FeeBurdened
Occupation CodeWage%$%$%$%$Rate
01011 Accounting Clerk I$16.59
01012 Accounting Clerk II$18.61
01013 Accounting Clerk III$22.30
01020 Administrative Assistant$31.41
01041 Customer Service Representative I$14.40
01042 Customer Service Representative II$16.18
01043 Customer Service Representative III$17.66
01051 Data Entry Operator I$14.71
01052 Data Entry Operator II$16.05
01070 Document Preparation Clerk$14.70
01090 Duplicating Machine Operator$14.70
01111 General Clerk I$14.88
01112 General Clerk II$16.24
01113 General Clerk III$18.74
01141 Messenger Courier$14.98
01191 Order Clerk I$15.12
01192 Order Clerk II$16.50
01261 Personnel Assistant (Employment)$18.15
01262 Personnel Assistant (Employment)$20.32
01263 Personnel Assistant (Employment)$22.65
01311 Secretary I$18.07
01312 Secretary II$20.18
01313 Secretary III$25.29
01460 Switchboard Operator/Receptionist$14.43
01531 Travel Clerk I$13.46
01532 Travel Clerk II$14.46
01533 Travel Clerk III$15.53
01611 Word Processor I$15.63
01612 Word Processor II$17.67
01613 Word Processor III$19.95
AVERAGE$17.65ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MEDIAN$16.37ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

SOURCE SELECTION INFORMATION

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

PRICE PROPOSAL WORKSHEET

BASE YEAR AG-SPEC-S-16-0028

Attachment 2

OPTION YEAR 1

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
SAMPLE TASK ORDER (TO) PRICING - OPTION YEAR 1
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 field currently pre-populates with WDC SCA salary minimums for the applicable positions. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination.
Base Year
HourlyFringeOverheadG&AProfit/FeeBurdened
Occupation CodeWage%$%$%$%$Rate
01011 Accounting Clerk I$16.59
01012 Accounting Clerk II$18.61
01013 Accounting Clerk III$22.30
01020 Administrative Assistant$31.41
01041 Customer Service Representative I$14.40
01042 Customer Service Representative II$16.18
01043 Customer Service Representative III$17.66
01051 Data Entry Operator I$14.71
01052 Data Entry Operator II$16.05
01070 Document Preparation Clerk$14.70
01090 Duplicating Machine Operator$14.70
01111 General Clerk I$14.88
01112 General Clerk II$16.24
01113 General Clerk III$18.74
01141 Messenger Courier$14.98
01191 Order Clerk I$15.12
01192 Order Clerk II$16.50
01261 Personnel Assistant (Employment)$18.15
01262 Personnel Assistant (Employment)$20.32
01263 Personnel Assistant (Employment)$22.65
01311 Secretary I$18.07
01312 Secretary II$20.18
01313 Secretary III$25.29
01460 Switchboard Operator/Receptionist$14.43
01531 Travel Clerk I$13.46
01532 Travel Clerk II$14.46
01533 Travel Clerk III$15.53
01611 Word Processor I$15.63
01612 Word Processor II$17.67
01613 Word Processor III$19.95
AVERAGE$17.65ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MEDIAN$16.37ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
Average Overhead, G&A, and Profit RateERROR:#DIV/0!
Median Overhead, G&A, and Profit RateERROR:#NUM!
Average Fully Burdened RateERROR:#DIV/0!
Median Fully Burdened RateERROR:#NUM!

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

PRICE PROPOSAL WORKSHEET

OPTION YEAR 1 AG-SPEC-S-16-0028

OPTION YEAR 2

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
SAMPLE TASK ORDER (TO) PRICING - OPTION YEAR 2
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 field currently pre-populates with WDC SCA salary minimums for the applicable positions. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination.
Base Year
HourlyFringeOverheadG&AProfit/FeeBurdened
Occupation CodeWage%$%$%$%$Rate
01011 Accounting Clerk I$16.59
01012 Accounting Clerk II$18.61
01013 Accounting Clerk III$22.30
01020 Administrative Assistant$31.41
01041 Customer Service Representative I$14.40
01042 Customer Service Representative II$16.18
01043 Customer Service Representative III$17.66
01051 Data Entry Operator I$14.71
01052 Data Entry Operator II$16.05
01070 Document Preparation Clerk$14.70
01090 Duplicating Machine Operator$14.70
01111 General Clerk I$14.88
01112 General Clerk II$16.24
01113 General Clerk III$18.74
01141 Messenger Courier$14.98
01191 Order Clerk I$15.12
01192 Order Clerk II$16.50
01261 Personnel Assistant (Employment)$18.15
01262 Personnel Assistant (Employment)$20.32
01263 Personnel Assistant (Employment)$22.65
01311 Secretary I$18.07
01312 Secretary II$20.18
01313 Secretary III$25.29
01460 Switchboard Operator/Receptionist$14.43
01531 Travel Clerk I$13.46
01532 Travel Clerk II$14.46
01533 Travel Clerk III$15.53
01611 Word Processor I$15.63
01612 Word Processor II$17.67
01613 Word Processor III$19.95
AVERAGE$17.65ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MEDIAN$16.37ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

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

PRICE PROPOSAL WORKSHEET

OPTION YEAR 2 AG-SPEC-S-16-0028

OPTION YEAR 3

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
SAMPLE TASK ORDER (TO) PRICING - OPTION YEAR 3
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 field currently pre-populates with WDC SCA salary minimums for the applicable positions. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination.
Base Year
HourlyFringeOverheadG&AProfit/FeeBurdened
Occupation CodeWage%$%$%$%$Rate
01011 Accounting Clerk I$16.59
01012 Accounting Clerk II$18.61
01013 Accounting Clerk III$22.30
01020 Administrative Assistant$31.41
01041 Customer Service Representative I$14.40
01042 Customer Service Representative II$16.18
01043 Customer Service Representative III$17.66
01051 Data Entry Operator I$14.71
01052 Data Entry Operator II$16.05
01070 Document Preparation Clerk$14.70
01090 Duplicating Machine Operator$14.70
01111 General Clerk I$14.88
01112 General Clerk II$16.24
01113 General Clerk III$18.74
01141 Messenger Courier$14.98
01191 Order Clerk I$15.12
01192 Order Clerk II$16.50
01261 Personnel Assistant (Employment)$18.15
01262 Personnel Assistant (Employment)$20.32
01263 Personnel Assistant (Employment)$22.65
01311 Secretary I$18.07
01312 Secretary II$20.18
01313 Secretary III$25.29
01460 Switchboard Operator/Receptionist$14.43
01531 Travel Clerk I$13.46
01532 Travel Clerk II$14.46
01533 Travel Clerk III$15.53
01611 Word Processor I$15.63
01612 Word Processor II$17.67
01613 Word Processor III$19.95
AVERAGE$17.65ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MEDIAN$16.37ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

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

PRICE PROPOSAL WORKSHEET

OPTION YEAR 3 AG-SPEC-S-16-0028

OPTION YEAR 4

Region 1
* WILL BE USED FOR SOURCE SELECTION PURPOSES*Region 2
SAMPLE TASK ORDER (TO) PRICING - OPTION YEAR 4
The Offeror's proposal shall untilize fully burdened contract rates for positions based in Washington, DC using local wage rates from Wage Determination: 15-4281 Revision: 2 Dated: 12/29/2015. The Salary field currently pre-populates with WDC SCA salary minimums for the applicable positions. Contractors are required to ensure that all statutory expenses (SUTA, FUTA, FICA, WC, etc.) and fringe benefits are included in the Fringe column. Fringe benefits must be equal to or exceed the applicable SCA Wage Determination.
Base Year
HourlyFringeOverheadG&AProfit/FeeBurdened
Occupation CodeWage%$%$%$%$Rate
01011 Accounting Clerk I$16.59
01012 Accounting Clerk II$18.61
01013 Accounting Clerk III$22.30
01020 Administrative Assistant$31.41
01041 Customer Service Representative I$14.40
01042 Customer Service Representative II$16.18
01043 Customer Service Representative III$17.66
01051 Data Entry Operator I$14.71
01052 Data Entry Operator II$16.05
01070 Document Preparation Clerk$14.70
01090 Duplicating Machine Operator$14.70
01111 General Clerk I$14.88
01112 General Clerk II$16.24
01113 General Clerk III$18.74
01141 Messenger Courier$14.98
01191 Order Clerk I$15.12
01192 Order Clerk II$16.50
01261 Personnel Assistant (Employment)$18.15
01262 Personnel Assistant (Employment)$20.32
01263 Personnel Assistant (Employment)$22.65
01311 Secretary I$18.07
01312 Secretary II$20.18
01313 Secretary III$25.29
01460 Switchboard Operator/Receptionist$14.43
01531 Travel Clerk I$13.46
01532 Travel Clerk II$14.46
01533 Travel Clerk III$15.53
01611 Word Processor I$15.63
01612 Word Processor II$17.67
01613 Word Processor III$19.95
AVERAGE$17.65ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MEDIAN$16.37ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

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

PRICE PROPOSAL WORKSHEET

OPTION YEAR 4 AG-SPEC-S-16-0028

Sheet1

01011Accounting Clerk I01011 Accounting Clerk I16.59016.59
01012Accounting Clerk II01012 Accounting Clerk II18.61018.61
01013Accounting Clerk III01013 Accounting Clerk III22.3022.3
01020Administrative Assistant01020 Administrative Assistant31.41031.41
01041Customer Service Representative I01041 Customer Service Representative I14.4014.4
01042Customer Service Representative II01042 Customer Service Representative II16.18016.18
01043Customer Service Representative III01043 Customer Service Representative III17.66017.66
01051Data Entry Operator I01051 Data Entry Operator I14.71014.71
01052Data Entry Operator II01052 Data Entry Operator II16.05016.05
01070Document Preparation Clerk01070 Document Preparation Clerk14.7014.7
01090Duplicating Machine Operator01090 Duplicating Machine Operator14.7014.7
01111General Clerk I01111 General Clerk I14.88014.88
01112General Clerk II01112 General Clerk II16.24016.24
01113General Clerk III01113 General Clerk III18.74018.74
01120Housing Referral Assistant01120 Housing Referral Assistant25.29025.29
01141Messenger Courier01141 Messenger Courier14.98014.98
01191Order Clerk I01191 Order Clerk I15.12015.12
01192Order Clerk II01192 Order Clerk II16.5016.5
01261Personnel Assistant (Employment)01261 Personnel Assistant (Employment)18.15018.15
01262Personnel Assistant (Employment)01262 Personnel Assistant (Employment)20.32020.32
01263Personnel Assistant (Employment)01263 Personnel Assistant (Employment)22.65022.65
01270Production Control Clerk01270 Production Control Clerk24.23024.23
01290Rental Clerk01290 Rental Clerk16.55016.55
01300Scheduler, Maintenance01300 Scheduler, Maintenance18.07018.07
01311Secretary I01311 Secretary I18.07018.07
01312Secretary II01312 Secretary II20.18020.18
01313Secretary III01313 Secretary III25.29025.29
01320Sevice Order Dispatcher01320 Sevice Order Dispatcher16.98016.98
01410Supply Technician01410 Supply Technician31.41031.41
01420Survey Worker01420 Survey Worker20.03020.03
01460Switchboard Operator/Receptionist01460 Switchboard Operator/Receptionist14.43014.43
01531Travel Clerk I01531 Travel Clerk I13.46013.46
01532Travel Clerk II01532 Travel Clerk II14.46014.46
01533Travel Clerk III01533 Travel Clerk III15.53015.53
01611Word Processor I01611 Word Processor I15.63015.63
01612Word Processor II01612 Word Processor II17.67017.67
01613Word Processor III01613 Word Processor III19.95019.95

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