Spreadsheet: 39bafd33-e51a-43c9-af6a-348e4107f870
Sheet: FPL & Pricing Sheet Information

All offerors under the Multiple Award Schedule Environmental Solicitation TFTP-EW-990899-B (Refresh #17) must complete and submit the "FPL and Pricing Sheets.xls" document as part of their price proposal.  This "FPL and Pricing Sheets.xls" document contains four (4) MS Excel worksheets (tabs) in the following order:  FPL-Hourly Rate Service Pricing, Training Pricing, Non-Hourly Rate Service Pricing, and Support Pricing.  A brief description of each worksheet is as follows:  FPL-Hourly Rate Service Pricing-- The Formatted Pricelist (FPL) contains 13-28 fields to be completed for each offered hourly rate labor category/rate, depending on the nature of support documentation, company pricing information, most favored customer (MFC) information, etc. (this does not include any tiered discount information, if offered).  A description and detailed information on how to complete each field are included in the below FPL instructions/description table.  Training Pricing-- This pricing sheet contains 17 fields per course and is only required in the event training classes are being proposed.  An example of how to complete each field is contained in the first row of information.  Non-Hourly Rate Service Pricing--  This pricing sheet contains 16 fields service item and is only required when offering services on an "other than" hourly basis.  An example of how to complete each field is contained in the first row of information.  Support Pricing-- This pricing sheet contains 16 fields per product and is only required when offering support products.  An example of how to complete each field is contained in the first row of information.  Offerors are encouraged to read the following FPL description/information sheet prior to completing the "FPL-Hourly Rate Service Pricing" spreadsheet.
"FPL-Hourly Rate Service Pricing" information sheet.
FPL Column | Field Name | Field Description | Field Type | [NAME]? | Sample Value | Additional Information
B | Offered Labor Category Name/Title | The offeror should only provide the Labor Category Name/Title in this field, exactly as the offeror would have it be awarded (see Additional Information). | Open Field | Yes | "Intermediate Program Manager" | Important Note: A separate line of information must be entered for the same proposed labor category if you are proposing a distinction in Vendor Site/Government Site (on-site/off-site) rate, CONUS/OCONUS rate, and/or Regional Pricing.  For instance, if a "Program Manager" is being offered with both CONUS/OCONUS and  Vendor Site/Government Site being applicable, then 4 rows of information would need to be provided, each listing "Program Manager" under this column with the respective combinations of site and geographic location chosen under the FPL columns W and [NAME]  If only one rate distinction is being offered under either column W or X, then just 2 lines of information for "Program Manager" must be provided.  With no distinction in either W or X, just one rate is being offered and therefore only one row of information for "Program Manager" should be provided.
C | Schedule # -Special Item Number (SIN) | The offeror should enter the all SIN's for which the labor category/rate is being proposed, separating each SIN with a comma. | Open Field | Yes | "1,3" | SINs listed must be iaw scope of work proposed in technical/admin proposal.  Potential choices for the Environmental schedule include: "1,3,5,7,8,9,10 and/or 99" Note:  If the same labor category is offered with more than one rate, depending on the SIN under which it performs, list only the SIN in this field for which the respective GSA offered rate (column "S") will apply, and provide another row of information for each subsequent SIN/rate distinction.
D | Minimum Experience Requirement | Enter the minimum number of years of Experience required for this labor category (cannot be a range). | Number | Yes | "5"
E | Minimum Education Requirement | Enter the minimum required Education level for this labor category. | Drop-Down | Yes | "Bachelor's" | Drop-down consists of the following choices:  "None/Not Listed" "High School" "Associates" "Bachelor's" "Master's" "Ph.D." and "Prof. [NAME]." for Professional Certification.
F | Labor Category Description, Duties/ Functional Responsibilities | Enter the labor category description. | Open Field | Yes | "Under general direction, oversees the operational planning, establishment, execution, and evaluation of a multifaceted program/ project typically consisting of a set of closely related subprograms or associated activities. Oversees fiscal, operational, administrative, and human resources management of the program; seeks and develops outside funding sources, serves as principal point of representation and liaison with external constituencies on operational matters, and provides day-to-day technical/professional guidance and leadership as appropriate to the area of expertise."
G | Is there a MFC for this labor category? | Enter "Yes" if there is a single customer or group of customers who receives the most preferential rate.  Indication here should be consistent with representation on the Commercial Sales Practices Format (CSPF). | Drop-Down | Yes | "Yes" | Select "Yes" or "No".
H | Lowest MFC Price | The offeror should enter the lowest price offered the MFC within the past 2 years.  Leave blank if Column G is "No". | Number | Not if column "G" is "No", otherwise Yes | "124.59"
I | Name of Most Favored Customer or group/ category of customers considered as MFC | Enter the Name of the MFC (or group of customers) receiving the lowest price.  Leave blank if Column G is "No". | Open Field | Not if column "G" is "No", otherwise Yes | "Prime Customers"
J | Lowest Rate depicted on supp. [NAME] for offered L.C. (broken out if depicted in a lump-sum amount) | Enter the lowest rate that is reflected on the Support documentation (e.g. copies of invoices or previously awarded contracts) that are being provided for this labor category/rate offered to GSA.  In accordance with solicitation instructions, each labor category should be supported. Leave blank if no price support doc. is provided (e.g. if only a cost breakout is available for offered labor category). (see Additional Information) | Number (USD$) | No | "124.59" | To the greatest extent possible, the support document should be applicable not only to the labor category being offered to GSA, but also to the rate being offered to GSA.  In other words, if there is any distinction in the on-site/off-site rate, CONUS/OCONUS rate, or regional pricing, the labor category/rate depicted on the support document should be applicable to the same on-site/off-site rate, CONUS/OCONUS, or Regional distinction.
K | Is this lowest rate depicted as a specific hourly rate (i.e. not a lump sum amount) on the support document? | If a specific hourly rate is listed or clearly discernible from the information on the support document alone, enter "Yes", otherwise enter "No". Leave blank if no price support doc. is provided (e.g. if only a cost breakout is available for offered labor category). | Drop-Down | Not if column "J" is blank, otherwise Yes | "Yes" | For any labor category in which the answer is "No", please provide a build-up of the lump sum amount depicted on the support documentation, clearly depicting the hourly rate and number of hours used to reach the lump sum amount, and attach it with the supporting documentation.
L | Electronic file page number of the support doc. that depicts this lowest rate | Enter the electronic file page number of the specific support document that contains the rate cited in column J. Leave blank if no price support doc. is provided (e.g. if only a cost breakout is available for offered labor category). | Number | Not if column "J" is blank, otherwise Yes | "3" | The support documentation for all offered labor categories should be consolidated into a single file (e.g. .pdf).  The CO/CS should then be able to locate the specific support document for this labor category by going to the electronic page number provided here.  Value must be a whole number between 0 and 200.
M | Name of labor category cited on the support document for this rate. | Provide the name of the labor category that is being offered to GSA if it is the exact same name depicted on the support documentation.  Provide the name of the equivalent labor category listed on the support document if for any reason the name is different from that being offered to GSA.  Leave blank if no price support doc. is provided (e.g. if only a cost breakout is available for offered labor category). | Open Field | Not if column "J" is blank, otherwise Yes | "Intermediate Program Manager" | This will typically be the same as the name of the labor category being offered to GSA, in which case it should be copied from column B and pasted here.  If for any reason the invoice being provided does not depict the exact same name, this information will serve as a crosswalk for the CS/CO.
N | Name of the client who received this rate (or MFC group/category name) | Provide the name of the customer for whom this lowest price invoice applies (or MFC group/category name)  Leave blank if no price support doc. is provided (e.g. if only a cost breakout is available for offered labor category). (see Additional Information) | Open Field | Not if column "J" is blank, otherwise Yes | "Prime Customers" | Important Note: If the MFC for this L.C. is a group/category of customers (as the Sample Value depicted for column J), and the client is a part of this group/category of customers, then enter the group/category name.
O | Is there a pricelist/ quote sheet that could be considered a CPL? | If the offeror has any type of a Commercial Pricelist or quote sheet, published or otherwise, then enter "Yes" | Drop-Down | Yes | "Yes"
P | Is this doc./ CPL published or maintained on a website? | If this is a published or publically viewable pricelist, such as on a company website, enter "Yes". Leave blank if Column O is "No". | Drop-Down | Not if column "O" is "No", otherwise Yes | "No"
Q | Name of applicable labor category, as depicted on the CPL. | Provide the name of the labor category that is being offered to GSA if it is the exact same labor category named on the Pricelist.  Provide the name of the equivalent labor category listed on the pricelist if for any reason the name is different from that being offered to GSA.  Leave blank if Column O is "No". | Open Field | Not if column "O" is "No", otherwise Yes | "Program Manager Level II" | This will typically be the same as the name of the labor category being offered to GSA, in which case it should be copied from column B and pasted here.  If for any reason the Pricelist provided does not depict the exact same name, this information will serve as a crosswalk for the CS/CO.
R | Standard Commercial Rate (CPL, Internal Quote Sheet, catalog, etc.) or Market Price | Provide the current standard commercial price or, in the absence of a Commercial Pricelist (e.g. Column "O" is "No") provide the Market Price. | Number (USD$) | Yes | "130.00" | This should be the same price as depicted on the commercial pricelist or, if no commercial pricelist exists, it should reflect the company's standard Market Price for this labor category.
S | Name of Commercial (Non-Federal) Customer that receives Lowest Rate | If the MFC depicted in column "I" is a Federal Agency, provide the name of the commercial customer that receives your lowest rate. | Open Field | Not if column "I" is a Non-Federal customer, otherwise Yes | "Acme Inc." | Only applies if the MFC identified in Column "I" is a Federal Agency.
T | Lowest Non-Federal Rate | Lowest Non-Federal customer rate (leave blank if the MFC identified in column "I" is Non-Federal). | Number (USD$) | Not if column "I" is a Non-Federal customer, otherwise Yes | "124.59" | Only applies if the MFC identified in Column "I" is a Federal Agency.
U | Proposed GSA EXCLUDING the IFF | Provide the rate offered to GSA without the Industrial Funding Fee (IFF) being included. | Number (USD$) | Yes | "122.00" | This is the ceiling rate for the offered labor category.  Any discounts can be listed under the respective Prompt Payment and/or Quantity Discount columns (AA-AC, AD…xx).
V | Price Offered to GSA INCLUDING the IFF | Fully loaded rate (inclusive of the Industrial Funding Fee).  No user input. | Number | No (auto-fills) | "129.92" | Locked Cell, Value depends on amount listed in Column "U".  This automatically calculates proper amount of IFF inclusion in price using a formula to avoid having vendor pay "IFF on top of IFF".
W | Is rate applicable to work performed on [NAME], Government Site, or both (i.e. no distinction in on-site/off-site work)? | The offeror may propose separate rates for "Vendor Site" and "Government Site" (also known  as "onsite/offsite"),based on the application of variations in its indirect costs depending upon where  the services are performed. Two sets of rates are not required. In the event two sets of rates are offered, the offeror must provide a separate row of information for each. | Drop-Down | Yes | "Both" | Must be iaw with offeror's standard commercial practices.  If only offering one rate regardless of it being on-site or off-site work, then choose applicability for "Both".  If offering a different rate depending on site, then two lines of information must be provided, one for Vendor Site and another for Government Site.  See the "Important Note" for column B.
X | Is rate applicable to work performed CONUS, OCONUS, or both (i.e. no distinction in CONUS/OCONUS)? | The offeror may propose a separate rate for CONUS (domestic) and OCONUS (overseas) services based on the application of variations in their indirect costs, depending upon where the services are performed. Two sets of rates are not required. In the event two sets of rates are offered, the offeror must provide a separate row of information for each. | Drop-Down | Yes | "Both" | Must be iaw administrative proposal representations.  If only offering to perform domestically, then list CONUS.  If performing worldwide but the same rate listed in column S applies to both CONUS and OCONUS work, then choose applicability for "Both".  If performing worldwide but with a different rate for CONUS and OCONUS, then two lines of information must be provided for the same labor category, one describing the CONUS information, and the other the OCONUS.  See the "Important Note" for column B.
Y | Region Code | Region Code (leave blank unless regional pricing is proposed) see Additional Information and refer to worksheet "Regional Definition Template" for required information. | Number | No |  | If as part of the offeror's standard commercial pricing regional pricing is offered, regional pricing may also be offered to GSA.  Any specific regional rates must be depicted on the Vendors Commercial Pricelist and supported by evidence (e.g. invoices) of the various regional rates being sold.  Regional pricing must be all inclusive for CONUS and/or OCONUS coverage (i.e. can leave no area undefined). See worksheet "Regional Definition Template" for required information.
Z | If proposed price w/o IFF is higher than the lowest MFC, support doc or CPL price, please explain (Open Field) | Offeror should provide an explanation for any instance in which the price offered to GSA is higher than the MFC price, the support documentation or the CPL.  If none leave blank. | Open Field | Yes
AA | Indicate whether the MFC, GSA, Both, or Neither are offered a Prompt Payment Discount. | Provide indication about any prompt payment discounts that are offered to MFC and/or to GSA. | Drop-Down | Yes | "Both" | Select from the following:  "MFC" -- If a prompt payment if offered to MFC but is not being offered to GSA. "GSA"--If a prompt payment if offered to GSA but is not offered to MFC. "Both"--If a prompt payment if offered to MFC and is being offered to GSA. "Neither"--If no prompt payment discount is offered to either [NAME] nor GSA.
AB | Prompt Payment Discount Percentage (leave blank if "Neither" is selected for column AA) | Provide the percent discount offered to MFC and/or GSA. | Number (%) | Not if column "AA" is "Neither", otherwise Yes. | "1.50"
AC | Payment term (in days) for Prompt Payment Discount to apply | Provide the payment term (in days) for Prompt Payment Discount to apply (Net 30 days) (leave blank if "Neither" is selected in column AA) | Number (Days) | Not if column "AA" is "Neither", otherwise Yes. | "20" | Provides the threshold (in days) for which the prompt payment discount (specified in column AB) will apply.
AD | Indicate whether the MFC, GSA, Both or Neither are offered a Quantity Discount. | Provide indication about any Quantity Discounts offered the MFC and/or GSA.  If Neither receive/are offered a Quantity Discount, then leave remaining columns (AE-AG) blank. | Drop-Down | Yes | "GSA" | Select from the following:  "MFC" -- If a quantity discount is offered to MFC but is not being offered to GSA. "GSA"--If a quantity discount is offered to GSA but is not offered to MFC. "Both"--If a quantity discount is offered to MFC and is being offered to GSA. "Neither"--If no quantity discount is offered to either [NAME] nor GSA.
AE | Specify basis of quantity discounts offered to customer identified in Column AD. | Specify basis of quantity discounts offered to customer identified in Column AD.  Leave blank if "Neither" is selected in column AD (drop-down) note: LC = Labor Category | Drop-Down | Not if column "AD" is "Neither", otherwise Yes. | "TaskOrderValue($)" | Select: "TaskOrderValue($)"-- If the discount is dependent on the cumulative dollar value of a Task Order. "Ind.LC # of hrs."-- If the discount is dependent on the number of Labor Hours (per task order) for the applicable Labor Category. "Ind. LC $ Amount"-- If the discount is dependent on the dollar value of a Labor Category ordered under a Task Order. "Other"-- If the discount is dependent on some other basis. (specify type of discount in column "AF")
AF | If Column Z="Other", specify type of discount. | If Column Z="Other", specify type of discount.  Leave blank if not applicable. (open field) | Open Field | Not if column "AD" is "Neither", otherwise Yes.
AG | Number of Quantity Discount Tiers. | Number of Quantity Discount Tiers. Enter "1" or greater unless N/A (corresponding # of tier information cells appear with data entry) (#) | Number (1-10) | Not if column "AD" is "Neither", otherwise Yes. | "3" | Enter "1" if only one quantity discount level (tier) is offered.  Tiered discounts should be in accordance with commercial practices.  Specific tier threshold and discount information is prompted after entering a number in this field (up to 10 tiers).
Tiered Discount Information for up to Ten (10) Tiers, as applicable.  Tiers become visible after offeror enters "#" (1-10) into Column "AG".
AH | Tier 1 Discount Range Start | Tier 1 Discount Range Start ($ or #, depending on basis identified in column "AE") | Number | Only as applicable | "$100,000.00"
AI | Tier 1 Discount Range End | Tier 1 Discount Range End ($ or #, depending on basis identified in column "AE") | Number | Only as applicable | "$250,000.00"
AJ | Standard Commercial Price Discount | Standard Commercial Price Discount (%) note: discount taken off of Standard Commercial Price or Market Price (column "R") | Number (%) | Only as applicable | "0.00%"
AK | Standard Commercial Price with Discount Applied | Standard Commercial Price with Discount Applied ($) note: self-calculating against  Standard Comm. or Market price, column  "R") | Number (USD$) | No | no input required
AL | [NAME] | [NAME] (%) note: discount taken off of MFC Price (column "H") | Number (%) | Only as applicable | "0.00%"
AM | MFC Price with Discount Applied | MFC Price with Discount Applied ($) note: self-calculating against  [NAME], (column "H") | Number (USD$) | No | no input required
AN | [NAME] | [NAME] (%) note: discount taken off of proposed GSA price excluding IFF (column "U") | Number (%) | Only as applicable | "2.00%"
AO | GSA Price with Discount Applied | GSA Price ($) note: self calculating against Proposed GSA Price (column "U") | Number (USD$) | No | no input required