RFP-Att9 -Pricing-Workbook.xlsx
XLSX spreadsheet 54 KB Posted
- Attached to
- Foreign Affairs Counter Threat Training Federal contract opportunity
- Solicitation number
- W900KK-21-R-0056
View the file
Other files for this federal contract opportunity
Show all 21
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
Instructions Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTIONS
Enter Offerors Name:
| STEPS | DIRECTIONS |
| #1 | Enter your company name at the top of each worksheet of the Pricing Workbook in the place provided. |
| #2 | For "1 - Range Pricing" tab, the Offeror shall enter only the cost and profit. The Total Price will automatically be calculated. The below table, "Range Priced CLINs - Planned Ordering Schedule (POS)" will automatically be calculated with all the information from the above table. Cell F32 will sum the total and will be used in "8 - Total Contract Price" tab. The "Range Pricing" table will be incorporated into the contract upon contract award of the winning Offeror. |
| #3 | For "2 - Unburden Labor Rates" tab, the Offeror shall enter the unburden labor rates for all proposed labor categories for all specified years. |
| #4 | For "3 - Indirect Rates" tab, the Offeror shall enter all applicable indirect rates. Additional instructions are provided within the worksheet for the definition, allocation base, what to do if the rate does not apply, and if an additional rate is required. |
| #5 | For "4 - :Labor Rate Buildup" tab, the direct unburden rates from "2 - Unburden Labor Rates" tab and the indirect rates from the "3 - Indirect Rates" tab will be automatically inserted into this worksheet. Formulas have already been constructed to compute the fully burden rate. The Cost of Money rate has been provided; however, no calculation is provided as it is unknown how an Offeror may apply this rate if applied at all. If this rate does apply to the Offeror, the Offeror must insert the formula and update the "Burdened Labor Rate" column to incorporate this additional cost. If an additional rate applies, the offer should have inserted it in the "5 - Indirect Rates" tab as well as in this worksheet. A reminder to also include the addition of this cost into the "Burdened Labor Rate" column. |
| #6 | For "5 - Labor Hours" tab, the information from "4 - Labor Rate Buildup" tab will automatically insert into the appropriate cells for this worksheet and compute itself. Each year will automatically be summed up. The Offeror shall enter only the number of hours for each labor category. |
| #7 | For "6 - Cost Breakdown," the Offeror shall enter the costs for each breakdown area for both sections (Per Training Cost and Per Student Cost). The Total Price will automatically be calculated. |
| #8 | For "7 - Sample Task Order," the Offeror shall enter the costs required by the cells shaded in grey. The direct unburden rates from "2 - Unburden Labor Rates" tab and the indirect rates from the "3 - Indirect Rates" tab will be automatically inserted into this worksheet. Formulas have already been constructed to compute the total price. If the structure of the this worksheet differs from the Offeror's pricing structure, the Offeror may add to the worksheet to make the worksheet complete and accurate. However, any additions should not degrade the overall objective of this worksheet. |
| #9 | For "8 - Non-Consumable Materials," the Offeror shall enter the description, quantity, unit cost, and all formulas to calculate total cost for all non-consumable materials included in the proposal. Non-consumable is defined as those materials that are able to be used more than once. |
| DO NOT CHANGE OR MODIFY THE FORMULAS OR NUMBERS WITHIN THE SPREADSHEETS. The only sections which may be altered are those sections allowing for additional indirect rates to be applied (to include Cost of Money), Cost Breakdown worksheet, and specified areas of the Sample Task Order worksheet. | |
| *** Pricing Workbook submissions must be consistent within your proposal and must strictly conform to the requirements of the Pricing Workbook. Failure to adhere to these requirements may deem the Offeror as non-responsive at the sole discretion of the Procuring Contracting Officer (PCO).*** |
It is the Government's intent to include all proposed direct and indirect rates for each applicable year into the contract as 'Ceiling Rates' at time of award. The proposed rates will be incorporated into the contract and shall be used as fixed rates (for all contract types) for proposing/negotiating orders (as applicable) and contract modifications for the life of the contract. The only exception is if DCMA were to negotiate a FPRA that contains lower rates. If there is a FPRA in effect during the life of the contract, and those rates are lower than the fixed rates and factors described above, the lower FPRA rates will be used to propose/negotiate orders and modifications so long as the FPRA remains in effect.
1 - Range Pricing Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #2
Offeror's Name:
| Range Pricing (To Be Included in Contract) | ||||||
| CLIN | TYPE | Desription | Student | |||
| Qty Range | Cost/ | |||||
| Student | Profit ($) | Total Price/Student | ||||
| 0001 | ||||||
| (Year 1) | FFP | FACT Training | 8-15 | $0.00 | $0.00 | |
| 0001 | ||||||
| (Year 1) | FFP | FACT Training | 16-22 | $0.00 | $0.00 | |
| 0001 | ||||||
| (Year 1) | FFP | FACT Training | 22-30 | $0.00 | $0.00 | |
| 1001 | ||||||
| (Year 2) | FFP | FACT Training | 8-15 | $0.00 | $0.00 | |
| 1001 | ||||||
| (Year 2) | FFP | FACT Training | 16-22 | $0.00 | $0.00 | |
| 1001 | ||||||
| (Year 2) | FFP | FACT Training | 22-30 | $0.00 | $0.00 | |
| 2001 | ||||||
| (Year 3) | FFP | FACT Training | 8-15 | $0.00 | $0.00 | |
| 2001 | ||||||
| (Year 3) | FFP | FACT Training | 16-22 | $0.00 | $0.00 | |
| 2001 | ||||||
| (Year 3) | FFP | FACT Training | 22-30 | $0.00 | $0.00 | |
| 3001 | ||||||
| (Year 4) | FFP | FACT Training | 8-15 | $0.00 | $0.00 | |
| 3001 | ||||||
| (Year 4) | FFP | FACT Training | 16-22 | $0.00 | $0.00 | |
| 3001 | ||||||
| (Year 4) | FFP | FACT Training | 22-30 | $0.00 | $0.00 | |
| 4001 | ||||||
| (Year 5) | FFP | FACT Training | 8-15 | $0.00 | $0.00 | |
| 4001 | ||||||
| (Year 5) | FFP | FACT Training | 16-22 | $0.00 | $0.00 | |
| 4001 | ||||||
| (Year 5) | FFP | FACT Training | 22-30 | $0.00 | $0.00 |
Range Priced CLINs - Planned Ordering Schedule (POS) (For Evaluation Purposes ONLY)
| CLIN | TYPE | Desription | Qty Range | |||
| (Average) | POS | Year Ext Price | ||||
| 0001 | ||||||
| Year 1 | FFP | FACT Training | 20 | 14 | $0.00 | |
| 1001 | ||||||
| Year 2 | FFP | FACT Training | 14 | 14 | $0.00 | |
| 2001 | ||||||
| Year 3 | FFP | FACT Training | 25 | 14 | $0.00 | |
| 3001 | ||||||
| Year 4 | FFP | FACT Training | 18 | 14 | $0.00 | |
| 4001 | ||||||
| Year 5 | FFP | FACT Training | 27 | 14 | $0.00 | |
| Total | $0.00 |
2 - Unburden Labor Rates Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #3
Offeror's Name:
| UNBURDEN LABOR RATES | Labor Rates - UNBURDEN | ||||
| Labor Category | Base Year Labor Rate | Year 2 Labor Rate | Year 3 Labor Rate | Year 4 Labor Rate | Year 5 Labor Rate |
3 - Indirect Rates Attachment 9 - INSTRUCTION #4
Offeror's Name:
Offeror's Name:
| Rates (and FCCM Factors) | Base Yr | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Definition and Allocation Base |
| Labor Fringes | ||||||
| Overhead | ||||||
| Material Handing | ||||||
| G&A Expenses | ||||||
| Cost of Money | ||||||
| Proposed Profit |
| Instructions: | |
| 1. If any of the rates/factors are not used in your estimating/accounting systems, leave the yearly blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base." | |
| 2. If your fiscal year is not computed as 1 October to 31 September, please provide calendar year 2021 through 2026 direct labor rates and show how the proposed Calendar Year rates were developed (either below on elsewhere in your Price/Cost Volume). | |
| 3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment such as (for G&A expenses): Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ). | |
| 4. If an offeror has an additional overhead/indirect rate not included above, you may adjust the worksheet to include that rate. |
4 - Labor Rate Buildup Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #5
Offeror's Name:
The Cost of Money column has been provided; however, a formula is not constructed within the subtotal column. If Cost of Money is proposed, you must input the formula in all cells of the column. If more than one Cost of Money rate is proposed, you must insert an additional column and update the burden rate column to sum the additional rate.
| DIRECT LABOR RATES | Labor Rate Buildup - *Fully Burdened* Year 1 (Base) | |||||||||||
| Labor Category | Yr 1 Labor Rate | Fringe Rate | Subtotal | Overhead Rate | Subtotal | G&A Rate | Subtotal | Profit | Subtotal | Cost of Money | Subtotal (Cost of Money) | Burdened Labor Rate |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 |
| DIRECT LABOR RATES | Labor Rate Buildup - *Fully Burdened* Year 2 | |||||||||||
| Labor Category | Yr 1 Labor Rate | Fringe Rate | Subtotal | Overhead Rate | Subtotal | G&A Rate | Subtotal | Profit | Subtotal | Cost of Money | Subtotal (Cost of Money) | Burdened Labor Rate |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 |
| DIRECT LABOR RATES | Labor Rate Buildup - *Fully Burdened* Year 3 | |||||||||||
| Labor Category | Yr 1 Labor Rate | Fringe Rate | Subtotal | Overhead Rate | Subtotal | G&A Rate | Subtotal | Profit | Subtotal | Cost of Money | Subtotal (Cost of Money) | Burdened Labor Rate |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 |
| DIRECT LABOR RATES | Labor Rate Buildup - *Fully Burdened* Year 4 | |||||||||||
| Labor Category | Yr 1 Labor Rate | Fringe Rate | Subtotal | Overhead Rate | Subtotal | G&A Rate | Subtotal | Profit | Subtotal | Cost of Money | Subtotal (Cost of Money) | Burdened Labor Rate |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 |
| DIRECT LABOR RATES | Labor Rate Buildup - *Fully Burdened* Year 5 | |||||||||||
| Labor Category | Yr 1 Labor Rate | Fringe Rate | Subtotal | Overhead Rate | Subtotal | G&A Rate | Subtotal | Profit | Subtotal | Cost of Money | Subtotal (Cost of Money) | Burdened Labor Rate |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 | |
| $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | $0.00 |
5 - Labor Hours Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #6
Offeror's Name:
| Labor Hours | ||||||||||||||||||
| Year 1 (Base) | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||
| Labor Category | Company Name: (Prime/Subcontractor) | Cage | ||||||||||||||||
| Code | Hourly Rate | Hours | Ext. Price | Hourly Rate | Hours | Ext. Price | Hourly Rate | Hours | Ext. Price | Hourly Rate | Hours | Ext. Price | Hourly Rate | Hours | Ext. Price | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| Totals hours | 0 | 0 | 0 | 0 | 0 |
6 - Cost Breakdown Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #7
Offeror's Name:
| Per Training Cost | 8-15 | 16-22 | 22-30 |
| Training Aid Cost (Consumables: | |||
| Training Aid Cost (non-Consumables): | |||
| Facilities: | |||
| Labor: | |||
| Total Price: | $0.00 | $0.00 | $0.00 |
| Per Student Cost | 8-15 | 16-22 | 22-30 |
| Training Aid Cost (Consumables: | |||
| Training Aid Cost (non-Consumables): | |||
| Facilities: | |||
| Labor: | |||
| Total Price: | $0.00 | $0.00 | $0.00 |
7 - Sample Task Order Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #8
| Offeror's Name: | ||||
| Sample Task Proposal Summary | ||||
| Labor Category | Labor Rate | Labor Hours | Total | |
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | Sample FACT Training Task Order | |
| 0.0 | 0.00 | $0 | 25 Participants | |
| 0.0 | 0.00 | $0 | 3 Days | |
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| 0.0 | 0.00 | $0 | ||
| Total | 0 | $0 | ||
| Rate | ||||
| Fringe | $0 | 0.00% | ||
| Overhead | $0 | 0.00% | ||
| Total | $0 | |||
| Sub-Total Labor | $0 |
| G&A (Labor) | $0 | 0.00% |
| Total Labor | $0 |
| Other Direct Costs | |
| Subcontracts | |
| Consumables Material | |
| Non-Consumables Materials | |
| ODC | |
| Total ODC | $0 |
Total Labor and ODC $0
G&A $0 0.00%
Total Cost without Profit $0
Profit $0 0.00%
Total Cost with Profit $0
Total Task Price $0
8 - Non-Consumables Materials Attachment 9 - TOTAL CONTRACT PRICE EXCEL WORKBOOK INSTRUCTION #9
| Offeror's Name: | |||
| Item Description | Quantity | Unit Cost | Total Cost |
File details come from the government source that posted it. Updated .