621I-R4_03_ProposedPricingAndCSP_20211001.xlsx
XLSX spreadsheet 288 KB Posted
- Solicitation number
- RFP797FSS000115R4
View the file
Other files
Show all 21
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
1- ProposedPricing&BillingDiscl
| The Government expects you to provide information that is, to the best of your knowledge and belief, current, accurate, and complete as of 60 calendar days prior to its submission. The data provided in the Proposed Pricing and Billing Disclosures tab is current, accurate, and complete as of (enter date in cell to the right). | Enter date in this cell based on instructions to the left. |
| Provide the date range which represents the start and end date of the transactional data and commercial agreements used to populate the most frequently billed, lowest billed, and highest billed prices below (enter date in cell to the right). | Enter date range (start and end date) in this cell based on instructions to the left. |
| Special Item Number (SIN) |
Choose the SIN from the drop-down list. For a list of SINs and their corresponding labor categories, see the Continuation of SF1449 located within Vendor Response Document 02. Labor Category Description (Job Title) Including Subcategory & Level, As Applicable Enter the labor category which corresponds to the SIN in Column A. For a list of SINs and their corresponding labor categories, see the Continuation of SF1449 located in Vendor Response Document 02. The offeror shall identify and clearly define each labor category and/or subcategory as provided in generic terms in the Continuation of SF1449. Proposed FSS Ceiling Price without IFF Department of Veterans Affairs:
Enter the “fully loaded” proposed price (i.e. hourly rate) to the Government not including the Industrial Funding Fee (IFF) of 1%. The “fully loaded” price/rate shall include direct labor, fringe benefits, overhead, general and administrative expenses, profit or fee, payroll taxes and applicable required insurance. This price must match the fully loaded price/rate listed on the “Pricing Validation - Cost Buildup” tab of the spreadsheet.
Note: This price excludes per diem, transportation and housing, shift differentials, holiday differentials, non-guaranteed differential, and malpractice insurance. Proposed FSS Ceiling Price with 1% IFF Shawn Davis:
This cell will automatically add the 1% Industrial Funding Fee (IFF) to the proposed price in Column C via the following calculation: Proposed price without IFF divided by 0.99.
Most Frequently Billed (MFB) Commercial Price Shawn Davis:
Enter the price/rate the you most frequently bill to all commercial customers. Note: This is not the average billed price/rate but the price/rate that you have billed most often. % Difference between Proposed FSS Price & MFB Shawn Davis:
This cell will automatically calculate the difference between proposed FSS price without IFF in column C and the most frequently billed (MFB) commercial price in column E. MFC Price (Commercial Lowest Billed Price) Enter the lowest “fully loaded” price/rate currently being billed to/paid by any commercial customer under an active agreement or within 30 days of this submission, consistent with the “Proposed Pricing” directions provided in the General Information for Submission of Pricing. If your firm does not have substantial commercial sales, then provide this disclosure for any customer, including government customers, with whom you are currently doing business.
In the event that your firm does not have a current/recent placement for an individual labor category, provide the most recent contract price billed. It may be necessary to factor out travel costs in your disclosure so a meaningful comparison can be conducted. The Government may request copies of invoices to validate disclosures. % Difference between Proposed FSS Price w/out IFF & MFC Price This cell will automatically calculate the difference between proposed FSS price without IFF in column C and the Most Favored Customer (MFC) price (i.e. the commercial lowest billed price) in column H. MFC Price (Commercial Lowest Billed Price) Location
OA&MM:
Enter the location (city and state) of the lowest price currently being billed (listed in column H). If the MFC is a government customer, provide the agency, city, and state. Commercial Highest Billed Price Enter the highest “fully loaded” price/rate currently being billed to/paid by any commercial customer under an active agreement or within 30 days of this submission, consistent with the “Proposed Pricing” directions provided in the General Information for Submission of Pricing. If your firm does not have substantial commercial sales, then provide this disclosure for any customer, including government customers, with whom you are currently doing business.
In the event that your firm does not have a current/recent placement for an individual labor category, provide the most recent contract price billed and the date of the invoice. It may be necessary to factor out travel costs in your disclosure so a meaningful comparison can be conducted. The Government may request copies of invoices to validate disclosures.
Highest Billed Location
OA&MM:
Enter the location (city and state) of the highest price currently being billed (listed in column K). If the highest price was billed to a government customer, provide the agency, city, and state. Average Annual Personnel Placements McKay, Lydia L:
Enter the average annual number of personnel placements made for each SIN/Labor Category.
| 621-001 | |
| 621-002 | 621-001 |
| 621-003 | 621-002 |
| 621-004 | 621-003 |
| 621-005 | 621-004 |
| 621-006 | 621-005 |
| 621-007 | 621-006 |
| 621-008 | 621-007 |
| 621-009 | 621-008 |
| 621-010 | 621-009 |
| 621-011 | 621-010 |
| 621-011 | 621-011 |
| 621-012 | 621-012 |
| 621-013 | 621-013 |
| 621-014 | 621-014 |
| 621-015 | 621-015 |
| 621-016 | 621-016 |
| 621-017 | 621-017 |
| 621-018 | 621-018 |
| 621-024 | 621-019 |
| 621-025 | 621-020 |
| 621-026 | 621-021 |
| 621-027 | 621-022 |
| 621-030 | 621-023 |
| 621-031 | 621-024 |
| 621-032 | 621-025 |
| 621-033 | 621-026 |
| 621-034 | 621-027 |
| 621-035 | 621-030 |
| 621-037 | 621-031 |
| 621-038 | 621-032 |
| 621-039 | 621-033 |
| 621-040 | 621-034 |
| 621-041 | 621-035 |
| 621-042 | 621-036 |
| 621-043 | 621-037 |
| 621-044 | 621-038 |
| 621-045 | 621-039 |
| 621-046 | 621-040 |
| 621-047 | 621-041 |
| 621-048 | 621-042 |
| 621-049 | 621-043 |
| 621-050 | 621-044 |
| 621-051 | 621-045 |
| 621-053 | 621-046 |
| 621-054 | 621-047 |
| 621-055 | 621-048 |
| 621-056 | 621-049 |
| 621-062 | 621-050 |
| 621-051 | |
| 621-053 | |
| 621-054 | |
| 621-055 | |
| 621-056 | |
| 621-057 | |
| 621-058 | |
| 621-059 | |
| 621-060 | |
| 621-061 | |
| 621-099 |
Version: Oct 2021 Proposed Pricing and Billing Disclosures &P of &N
2-PricingValidation-CostBldUp
| In the yellow-highlighted cells in Columns E-Q, Row 4, enter requested information in the format requested (i.e. percentage, number of days, etc.). Information for these columns in rows 5 and down must be expressed in dollars ($) as a portion of the "fully loaded" hourly rate. | ||
| SIN | Labor Category Description (Job Title) |
Including Subcategory and Level,
| As Applicable | EARNINGS/INCOME | EMPLOYER PAID FRINGE | Total Direct Costs | ||||||||||
| (D - M) | Overhead / G&A Costs | Total Direct & Indirect Costs | |||||||||||
| (N+O) | Profit Margin | Proposed FSS Price w/out IFF (i.e. "Fully Loaded" Ceiling Hourly Rate without IFF) | |||||||||||
| (P+Q) | Proposed FSS Price with IFF (i.e. "Fully Loaded" Ceiling Hourly Rate with 1% IFF) | Does Proposed FSS Price w/out IFF Match Tab 1? | |||||||||||
| Base Annual Wages | Base Hourly Rate | FICA | FUTA | SUTA | Workers Comp | Health & Welfare | Health Insurance | Misc Cost | Sick Leave | Vacation/Holiday | |||
| Enter % in this cell | Enter % in this cell | Enter % in this cell | Enter % in this cell | Enter required DOL $ rate | Enter $ per month | Enter cost ($) | Enter | ||||||
| # Hours or Days | Enter | ||||||||||||
| # Hours or Days | Enter % in this cell | Enter % in this cell |
Pricing Validation - Cost Buildup Page &P of &N
3- Sales Disclosures 12-Month Time Frame upon which the below disclosures are based.
(either your last fiscal year or a more recent 12-month period)
| : This should be reflective of your most recent 12 month accounting period leading to this offer. | Enter start and end date of 12-month period. (e.g. 1/1/2020 - 12/31/2020) | ||||
| Explanation of methodology used to provide projected annual government sales disclosed in column D below: | Enter methodology for projected sales. | ||||
| SIN | Actual Annual Government Sales ($) by SIN | Actual Annual Commercial Sales ($) by SIN | Projected Annual Sales ($) under This Contract by SIN | List additional comments here or in an attachment |
| Sales Totals: | $0 | $0 | $0 |
| Total Actual Sales (Gov't & Comm): | $0 | ||
| % of Total Actual Sales: |
Sales Disclosures &P of &N
4- LaborCategoryDescriptions
SIN Labor Category Description (Job Title) Including Subcategory and Level,
| As Applicable | Education / Minimum Training | Experience | ||
| (# of years) | Licences | Certifications | CPR | Other |
Labor Category Descriptions Page &P of &N
Tracking Customer
SIN Labor Category TC Name / NTE Location (City) TC Rate Proposed Rate without IFF Awarded Rate without IFF TC Ratio Rationale for TC & TC Ratio (Note: Choose rationale from dropdown)
Offeror has prior placements in NTE City location.
Therefore, TC Rate & Ratio is based upon offeror's CSP Offeror has not had prior placements in NTE City location.
Therefore, TC Rate & Ratio is equal to the Awarded Rate.
Tracking Customer &P of &N
Award
| SIN | Labor Category Description (Job Title) | |||||
| Including Subcategory, If Applicable | Tracking Customer (TC) Name & Basis of Award Location (City) | TC Ratio | FSS Ceiling Price without IFF | (Calculate FSS Price with IFF) | FSS Ceiling Price with IFF | Red "A" = Awarded |
&"Calibri,Regular"Awarded Pricing &"Calibri,Regular"&P of &N
File details come from the government source that posted it. Updated .