Exhibit B - Price Table Workbook (updated 20NOV24) W911RX24R0011.xlsx

XLSX spreadsheet 104 KB Posted

Attached to
Amendment 7, III Armored Corps Agricultural Sanitation Services
Solicitation number
W911RX24R0011
Issued by

About this file

This is a pricing workbook template for a contract opportunity at Fort Hood for Agricultural Sanitation (AGSAN) Services. The workbook contains CLIN structures for a base year and four option years, with each period having three CLINs: Mobilization-Demobilization, AGSAN Services, and Equipment & ODCs. The template includes detailed worksheets for labor calculations, staffing plans, major/minor equipment costs, parts and supplies, vehicle costs, rental and insurance, and training and subcontracts.

The workbook incorporates weighted guidelines calculations for profit determination and includes sections for G&A costs (set at 14%), labor fringe benefits, and direct/indirect labor costs. The template appears to be designed for a firm-fixed-price contract structure, with provisions for calculating monthly invoice amounts. While the workbook structure is complete, no actual pricing data is filled in, with most cells showing $0.00 or blank values.

View the file

Other files

Show all 17

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

CLIN Schedule

III Armored Corps, FT Cavazos
BASE 12 Months

CLINS: Level of Service Est. QTY (Monthly) Unit Unit Price Total Annual Cost

0001 Mobilization-Demobilization 1 JOB $0.00

0002 AGSAN Services 1 JOB $0.00

0003 Equipment & ODCs 1 JOB $0.00

Total $0.00

III Armored Corps, FT Cavazos
1st Option. 12 Months
CLINS:Level of ServiceEst. QTY (Monthly)UnitUnit PriceTotal Annual Cost
1001Mobilization-Demobilization1JOB$0.00

1002 AGSAN Services 1 JOB $0.00

1003 Equipment & ODCs 1 JOB $0.00

Total $0.00

III Armored Corps, FT Cavazos
2nd Option. 12 Months
CLINS:Level of ServiceEst. QTY (Monthly)UnitUnit PriceTotal Annual Cost
2001Mobilization-Demobilization1JOB$0.00

2002 AGSAN Services 1 JOB $0.00

2003 Equipment & ODCs 1 JOB $0.00

Total $0.00

III Armored Corps, FT Cavazos
3rd Option. 12 Months
CLINS:Level of ServiceEst. QTY (Monthly)UnitUnit PriceTotal Annual Cost
3001Mobilization-Demobilization1JOB$0.00

3002 AGSAN Services 1 JOB $0.00

3003 Equipment & ODCs 1 JOB $0.00

Total $0.00

III Armored Corps, FT Cavazos
4th Option. 12 Months
CLINS:Level of ServiceEst. QTY (Monthly)UnitUnit PriceTotal Annual Cost
4001Mobilization-Demobilization1JOB$0.00

4002 AGSAN Services 1 JOB $0.00

4003 Equipment & ODCs 1 JOB $0.00

Total $0.00

Total Contract Value ERROR:#NAME?

Weighted Guidelines

RECORD OF WEIGHTED GUIDELINES APPLICATION REPORT CONTROL SYMBOL

1. REPORT NO.2. BASIC PROCUREMENT INSTRUMENT IDENTIFICATION NO.3. SPIIN4. DATE OF ACTION
a. PURCHASING OFFICEb. FYc. TYPE PROC INST CODEd. PRISNTBD2024JUNE
W911RX2025
5. CONTRACTING OFFICE CODEITEMCOST CATEGORYOBJECTIVE
6. NAME OF CONTRACTOR13.MATERIAL
14.SUBCONTRACTS
7. DUNS NUMBER8. FEDERAL SUPPLY CODE15.DIRECT LABOR$ - 0
16.INDIRECT EXPENSES$ - 0
9. DOD CLAIMANT PROGRAM10. CONTRACT TYPE CODE17.OTHER DIRECT CHARGES$ - 0
18.SUBTOTAL COSTS (13 thru 17)$ - 0
11. TYPE EFFORT12. USE CODE19.GENERAL AND ADMINISTRATIVE$ - 0
20.TOTAL COSTS (18 + 19)$ - 0
WEIGHTED GUIDELINES PROFIT FACTORS
ITEMCONTRACTOR RISK FACTORSASSIGNED WEIGHTINGASSIGNED VALUEBASE (Item 20)PROFIT OBJECTIVE
21.TECHNICAL
22.MANAGEMENT/COST CONTROL
23.PERFORMANCE RISK (COMPOSITE)$ - 0
24.CONTRACT TYPE RISK$ - 0$ - 0
25.WORKING CAPITALCOSTS FINANCEDLENGTH FACTORINTEREST RATE
$ - 0
CONTRACTOR FACILITIES CAPITAL FINANCEDAMOUNT EMPLOYED
26.LAND$ - 0
27.BUILDINGS$ - 0
28.EQUIPMENT0.0%$ - 0$ - 0
29.COST EFFICIENCY FACTORASSIGNED VALUEBASE (Item 20)
$ - 0$ - 0
30.TOTAL PROFIT OBJECTIVE
NEGOTIATED SUMMARY
PROPOSEDOBJECTIVENEGOTIATED
31.TOTAL COSTS$ - 0
32.FACILITIES CAPITAL COST OF MONEY (DD Form 1861)
33.PROFITERROR:#VALUE!
34.TOTAL PRICE (Line 31 + 32 + 33)$ - 0$ - 0$ - 0
35.MARKUP RATE (Line 32 + 33 divided by 31)0.000%0.000%0.000%
CONTRACTING OFFICER APPROVAL
36.TYPED/PRINTED NAME OF CONTRACTING OFFICER (Last, First, Middle Initial)
37.SIGNATURE OF CONTRACTING OFFICER38. TELEPHONE NO.39.DATE SUBMITTED

(YYYYMMDD)

Richie, Christopher A.520-944-0622
OPTIONAL USE
96.97.98.99.
DD FORM 1547, JUL 2002PREVIOUS EDITION IS OBSOLETE.
215.404-72 Modified weighted guidelines method for nonprofit organizations other than FFRDCs.
(a) Definition. As used in this subpart, a nonprofit organization is a business entity—
(1) That operates exclusively for charitable, scientific, or educational purposes;
(2) Whose earnings do not benefit any private shareholder or individual;
(3) Whose activities do not involve influencing legislation or political campaigning for any candidate for public office; and
(4) That is exempted from Federal income taxation under section 501 of the Internal Revenue Code.
(b) For nonprofit organizations that are entities that have been identified by the Secretary of Defense or a Secretary of a Department as receiving sustaining support on a cost-plus-fixed-fee basis from a particular DoD department or agency, compute a fee objective for covered actions using the weighted guidelines method in 215.404-71, with the following modifications:
(1) Modifications to performance risk (Blocks 21-23 of the DD Form 1547).
(i) If the contracting officer assigns a value from the standard designated range (see 215.404-71-2(c)), reduce the fee objective by an amount equal to 1 percent of the costs in Block 20 of the DD Form 1547. Show the net (reduced) amount on the DD Form 1547.
(ii) Do not assign a value from the technology incentive designated range.
(2) Modifications to contract type risk (Block 24 of the DD Form 1547). Use a designated range of –1 percent to 0 percent instead of the values in 215.404-71-3. There is no normal value.
(c) For all other nonprofit organizations except FFRDCs, compute a fee objective for covered actions using the weighted guidelines method in 215.404-71, modified as described in paragraph (b)(1) of this subsection.

Cost Breakdown

Labor EstimateBase YearFOY1FOY2FOY3FOY4FOY5TOTAL
Start Date: 09/01/2023
LaborCalculator
Exempt Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Non Exempt Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Fringe Benefits
Exempt Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Non Exempt Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Total Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Other Direct Charges
*Major Equipment4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
*Minor Equipment4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
*Vehicle Operation4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
*Rental4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
*Training & Subcontracts4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Parts and Supplies for P&P4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
*IT Support Costs4% Esc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Other Direct Charges$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Direct Costs (01+02+03)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A14.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Through G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Profit (based on Weighted Guidelines) ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

Total Through Profit ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

(reserved for taxes)0.000%ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Base PriceAnnualERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Invoice Per Month / Divided by 12MonthlyERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Assumptions:
Hourly median wage referenced from Bureau Labor Statistics (BLS) website.
Staffing levels and supervisor to worker ratios determined by current staffing levels, current custodial contract.
City, State tax rate of X.XX% utilized for parts and supplies.
Signatures:

&"Arial,Bold"&12&A

Staffing Plan

FILL IN THIS PAGE FIRST
Direct Labor
Position / Job #FTEsLabor HoursWage RateLabor CostFringe CostLabor + FringeWage Determination / Labor Category Translation
Planning & Work ControlContractor wagesHourly Wage Rate
Base OperationsFILL IN THIS PAGE FIRST
SCA #PositionQty
On-Site Manager- 0- 0- 0- 0
Foreman- 0- 0- 0- 0
Technicians- 0- 0- 0- 0O1113General Clerk III9$ 16.8201113 - General Clerk III
HAZMAT Supervisor- 0- 0- 0- 0
Tractor Operator- 0- 0- 0- 0IndirectLead3$ 25.14
Total0.00- 0- 0- 0- 0
Exempt LaborERROR:#NAME?ERROR:#REF!- 0- 0- 0
Non Exempt LaborERROR:#NAME?ERROR:#REF!- 0- 0- 0
Total Labor (check)ERROR:#NAME?ERROR:#REF!$ - 0$ - 0$ - 0- 0

Part time employee FTE calculations:

Calculated FTE as a whole. Not calculating PTE for contractor

Changes V - V:FTES
Added more Custodial, FT

Added more Grounds FT

Added more Tractor Operator FT

Planning and Work Control Total Direct Staff (FTES) 0.00 Hours - 0

On-Site ManagerForemanTechniciansHAZMAT SupervisorERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!Tractor Operator
LineERROR:#REF!
No.DescriptionFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposedFTEProposed
1Nondisabled Labor Hours
2Total Labor Hours Worked to Produce Service
(Average Productivity 100.00% (Whole %) Precentage
3Average Wage
4Total Labor Costs
(Multiply Line 1 by line 3)
5Average Hourly Earnings
(Divide Line 1 by Line 2 and Multiply by Line 3)
6Number of Holiday and Vacation and Sick Leave Hours
(Multiply Total of H-V-S Days by 8 Hours)
Holiday
Vacation
Sick
PTO
Breavement
7Average Work Years
(Divide Line 2 by 1920 Hours)
(Line 2(2080-((Holi+Vac.+Sick+Bereave) x8))
8Health and Welfare Rate ($/Hour)
9Hourly Earnings plus Health and Welfare
(Add Lines 5 and 8)
10Payroll-Based Expense Rates
a. FICA
b. Unemployment
c. Accident Insurance
d. Workers Compensation Rate
e. Total Payroll Expense Rates
11Total Health and Welfare Benefits
(Multiply Line 2 by Line 8)
12Holiday and Vacation and Sick Pay Benefits
(Multiply Line 6 by Line 7 by Line 9)
13Payroll Taxes
a. On Pay (Multiply Line 4 by Line 10e)
b. On Holidays Vacations Sick
(Multiply Lines 5 by 6 by 7 by 10e)
c. Total Payroll Taxes (Add Lines 13a and 13b)
14Other (See Attached Addendum if line 14 is >0)
15TOTAL FRINGE BENEFITS (ADD 11,12,13c)
Total Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16Labor Rate / HR
Fringe Rate % (Check Value):ERROR:#DIV/0!

&"Arial,Bold"&A

Major Equipment

Major Equipment5
Line NumberItem DiscriptionFY put in ServiceUseful LifeQuantityUnit PriceTotal PriceSalvage Value3%Salvage Value% Used on ServiceBase YearFOY1FOY2FOY3FOY45 Year CostAverage Annual Cost
Quantity1st Replacement Cost Less 50% SalvageAnnual Cost
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
$ - 0
- 0- 0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total Cost:$ - 0
Total$ - 0

Minor Equipment

Planned Expenditure
MINOR EQUIPMENT5
Item DescriptionSource NameYRQtyCost PriceAmount% Used on ServiceBase YearFOY1FOY2FOY3FOY45 Year CostAverage Annual Cost
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0- 0- 0- 0- 0- 0$ - 0
- 0$ - 0
- 0$ - 0
Taxes=$ - 0- 0- 0$ - 0
TOTAL$ - 0$ - 0$ - 0

&"Arial,Bold"&A

Parts and Supplies

NoteDescriptionQtyUnit PriceSubtotal% Used on ServiceTotal for Srvice
1$ - 0$ - 0
2$ - 0$ - 0
3$ - 0$ - 0
4$ - 0$ - 0
5$ - 0$ - 0
6$ - 0$ - 0
7$ - 0$ - 0
8$ - 0$ - 0
9$ - 0$ - 0
10$ - 0$ - 0
11$ - 0$ - 0
12$ - 0$ - 0
13$ - 0$ - 0
14$ - 0$ - 0
15$ - 0$ - 0
16$ - 0$ - 0
Subtotal$ - 0
State Sales Tax$ - 0
Total$ - 0

Vehicle Costs

Vehicles Major EquipmentVehicle Operation
#DescriptionUseful Life (years)QuantityUnit PriceTotal PriceSalvage Value0%% Used on ServiceBase YearFOY1FOY2FOY3FOY4Total CostAverage Annual CostNo.Vehicle DescriptionFuelRegistration/InsuranceTotal
1st Replacement Cost Less 10% SalvageQuantityMileage per YearMPGGallons/YearCost/Gallon% Used for ServiceTotal Fuel CostYearly Main. Cost% Used for ServiceTotal Maint. CostYearly Registration Cost/VehicleYearly Registration CostYearly Insurance Cost/VehicleYearly Insurance Cost% Used for ServiceTotal Ins./Reg. CostTotal Cost/VehicleTotal Vehicle Cost
years
1$ - 0$ - 0$ - 0ERROR:#DIV/0!1- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
2$ - 0$ - 0$ - 0ERROR:#DIV/0!2- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
3$ - 0$ - 0$ - 0ERROR:#DIV/0!3- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
4$ - 0$ - 0$ - 0ERROR:#DIV/0!4- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
5$ - 0$ - 0$ - 0ERROR:#DIV/0!5- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
6$ - 0$ - 0$ - 0ERROR:#DIV/0!6- 0- 0- 0- 0- 0ERROR:#DIV/0!- 0
7$ - 0$ - 0$ - 0ERROR:#DIV/0!7- 0- 0- 0- 0ERROR:#DIV/0!- 0
8$ - 0$ - 0$ - 0ERROR:#DIV/0!8- 0- 0- 0- 0ERROR:#DIV/0!- 0
9$ - 0$ - 0$ - 0ERROR:#DIV/0!9- 0- 0- 0- 0ERROR:#DIV/0!- 0
Total Cost:$ - 0
ERROR:#DIV/0!Total Annual Fuel Cost$ - 0$ - 0$ - 0Total Cost for Vehicle Maintenance$ - 0
Note 1:
Note 2:
Note 3:

Rental & Insurance

RENTAL
DescriptionQuantityUnitUnit CostRate/YearNOTES

Total Costs for Rental

&"Arial,Bold"&U&A

Training & Subcontracts

Subcontracts
DescriptionQuantityUnit PriceRate/YearNOTES

Total Costs Training & Subcontracts $ - 0

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