ATTACHMENT 4 - Volume I Cost Breakout.xls

XLS spreadsheet 379 KB Posted

Attached to
Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial for the Peterson AFB Commissary -HDEC08-21-R-0003
Solicitation number
HDEC0821R0003
Issued by

About this file

This solicitation seeks proposals for shelf stocking, receiving/storage/holding area (RSHA), and custodial services at the Peterson Air Force Base Commissary in Colorado Springs, Colorado. The services include a base period from August 1, 2021 through July 31, 2022 with three one-year option periods. This is a 100% set-aside for Service-Disabled Veteran-Owned Small Businesses with a North American Industry Classification System code of 561990 and business size standard of $12 million. Proposals are due by April 19, 2021. A site visit is scheduled for March 22, 2021. The solicitation and attachments will be available on FedBizOpps on or about March 1, 2021. Paper copies may be requested by March 15, 2021 by writing to the specified Defense Commissary Agency address.

View the file

Other files

Show all 13

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

Cost Breakout

Attachment 4
HDEC08-21-R-0003
VOLUME I
COST BREAKOUT
Offerors are required to submit their cost breakout in accordance with provision
52.215-4509, "Proposal Submission," paragraph (b)(4), located in Section L of the
solicitation.
The tabs below contain worksheets for Shelf Stocking, Custodial, Receiving/Storage Holding
Area, Residual Grocery, Yearly Totals, 5-Year totals, Snow & Ice Removal and Loaded Wage
Rates, as well as Printing Instructions for these worksheets.
The worksheets for Shelf Stocking, Custodial, and Receiving/Storage/Holding Area
contain "sample" occupational titles and the applicable minimum wage rates.

&C

Printing Instructions

BASIC INSTRUCTIONS
This icon and/or disk contains the required forms and formats for submitting proposals in response to the
solicitation. Some of the forms have protected formats and cells, however the necessary inputs are "unprotected"
and may be changed as needed to adequately reflect your proposal. Formulas are included where appropriate
to automatically generate various computations. The offer is ultimately responsible for the accuracy of all calculations.
If there are calculation differences between the hard copy and the computer files, the hard copy shall take precedence.
PRINTING PARAMETERS
In order to print these spreadsheets you must use print ranges and titles as they are described in your
software manual. The ranges have been defined and named. The range names are listed below.
Range NamesSizeTitlesOrientationTopics
SS_PAGE1Fit Columns to PageB:A1..B:A8PortraitShelf Stocking Direct Labor, Health & Welfare Sheet
SS_PAGE2Fit Columns to PageB:A1..B:A8PortraitShelf Stocking Holidays & Vacations Sheet
SS_PAGE3Fit Columns to PageB:A1..B:A8PortraitShelf Stocking Fringe Calculations Sheet
SS_PAGE4Fit Columns to PageB:I1..B:I19PortraitShelf Stocking Supplies & Equipment Sheet
SS_PAGE5Fit Columns to PageNonePortraitShelf Stocking Summary Sheet
CS_PAGE1Fit Columns to PageC:A1..C:A8PortraitCustodial Direct Labor, Health & Welfare Sheet
CS_PAGE2Fit Columns to PageC:A1..C:A8PortraitCustodial Holidays & Vacations Sheet
CS_PAGE3Fit Columns to PageC:A1..C:A8PortraitCustodial Fringe Calculations Sheet
CS_PAGE4Fit Columns to PageC:I1..C:I19PortraitCustodial Supplies & Equipment Sheet
CS_PAGE5Fit Columns to PageNonePortraitCustodial Summary Sheet
WH_PAGE1Fit Columns to PageD:A1..D:A8PortraitRSH Direct Labor, Health & Welfare Sheet
WH_PAGE2Fit Columns to PageD:A1..D:A8PortraitRSH Holidays & Vacations Sheet
WH_PAGE3Fit Columns to PageD:A1..D:A8PortraitRSH Fringe Calculations Sheet
WH_PAGE4Fit Columns to PageD:I1..D:I19PortraitRSH Supplies & Equipment Sheet
WH_PAGE5Fit Columns to PageNonePortraitRSH Summary Sheet
GRANDSFit Columns to PageNonePortraitTotals of Shelf Stocking , Custodial,RSH and Residual Grocery
GRAND_TOTALSFit Columns to PageNoneLandscape5 year totals of Shelf Stocking , Custodial, and RSHA
You may also use the macro "Print1" to print a group of pages. Make the sheet you wish to print active. Run the macro and it will print
the group of spreadsheets for you. This macro currently works only in Excel. The macro can also be activated by pressing the Print
button on each sheet.

Shelf Stocking

SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)
Shelf Stocking Operations Work SheetShelf Stocking Operations Work SheetShelf Stocking Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Stock Clerks0$19.32$0.00COST ELEMENTDOLLARS
Lead Stock Clerks0$20.82$0.00==
Project Manager (Not a member of CBA)0$0.00$0.00Qty.Unit/Extended`DIRECT LABOR$0.00
0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE AND PENSION$0.00
0$0.00$0.00========
0$0.00$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----Cutter, Carton00.00$0.00
TOTALS0$0Dispenser, Tape00.00$0.00HOLIDAYS & VACATIONS$0.00
====Safety Shoes00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
Indirect Labor Hours (Non-Working)0Tape Masking00.00$0.00==
=Back Brace00.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Cart, Bushel00.00$0.00
=Cart, Stocking00.00$0.00FRINGES$0.00
Pallet Jacks00.00$0.00
NOTE: Insert the appropriate H&W/Pension Rate for all employees not covered by the CBA.00.00$0.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.00$0.00-
CBA H&W $3.7800.00$0.00SUB-TOTAL$0.00
andH&W00.00$0.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.00$0.00G&A0.00%$0.00
=====00.00$0.00
Stock Clerks0$7.78$0.0000.00$0.00PROFIT0.00%$0.00
Lead Stock Clerks0$7.78$0.0000.00$0.00
Project Manager (Not a member of CBA)0$0.00$0.0000.00$0.00==
0$0.00$0.0000.00$0.00GRAND TOTAL$0.00
0$0.00$0.0000.00$0.00====
0$0.00$0.0000.00$0.00ANNUAL CASES1,320,000
----00.00$0.00===
TOTALS0$000.00$0.00CASE PRICE0.0000
====00.00$0.00===
Holidays, Sick, and Vacations00.00$0.00
Holidays and Vacations00.00$0.00
Holidays00.00$0.00
Vacations00.00$0.00
COST ELEMENTHolidaysVacationsDollars00.00$0.00
=====00.00$0.00
Stock Clerks100$0.00( (Holidays + Vacations) * 8)======
Lead Stock Clerks100$0.00times Work HoursTOTALS0$0.00
Project Manager (Not a member of CBA)100$0.00divided by ( 2080 hours -======
100$0.00( (Holidays + Vacations) * 8) )
100$0.00times the hourly rate
100$0.00in each category
----
TOTALS60$0
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Stock Clerks0$7.78$0.00
Lead Stock Clerks0$7.78$0.00
Project Manager (Not a member of CBA)0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE AND PENSION$0.00
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
------
SUBTOTAL$0.00
======
FICAX7.65%=$0.00
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

RSHA

SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)
RSHA Operations Work SheetRSHA Operations Work SheetRSHA Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Warehouse Specialist/Forklift Operator019.76$0.00COST ELEMENTDOLLARS
Lead Warehouse Specialist021.26$0.00==
Material Handler018.45$0.00Qty.Unit/ExtendedDIRECT LABOR$0.00
Project Manager (Not a member of CBA)00.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE AND PENSION$0.00
00.00$0.00========
00.00$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----Cutter, Carton00.00$0.00
TOTALS0$0.00Dispenser, Tape00.000.00HOLIDAYS & VACATIONS$0.00
====Safety Shoes00.000.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
Indirect Labor Hours (Non-Working)0Tape Masking00.000.00==
=Back Brace00.000.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Cart, Bushel00.000.00
=Cart, Stocking00.000.00FRINGES$0.00
NOTE: Insert the appropriate H&W/Pension Rate for all employees not covered by the CBA.Pallet Jacks00.000.00
Direct Labor Health & Welfare and Pension00.000.00EQUIPMENT & SUPPLIES$0.00
CBA H&W $3.7800.000.00-
andH&W00.000.00SUB-TOTAL$0.00
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00=
=====00.000.00G&A0.00%$0.00
Warehouse Specialist/Forklift Operator0$7.78$0.0000.000.00
Lead Warehouse Specialist0$7.78$0.0000.000.00PROFIT0.00%$0.00
Material Handler0$7.78$0.0000.000.00
Project Manager (Not a member of CBA)0$0.00$0.0000.000.00==
0$0.00$0.0000.000.00GRAND TOTAL$0.00
0$0.00$0.0000.000.00====
----00.000.00MO. PRICE$0.00
TOTALS0$000.000.00===
====00.000.00
Holidays, Sick, and Vacations00.000.00
Holidays and Vacations00.000.00
Holidays00.000.00
Vacations00.000.00
COST ELEMENTHolidaysVacationsDollars00.000.00
=====00.000.00
Warehouse Specialist/Forklift Operator100$0.00( (Holidays + Vacations) * 8)00.000.00
Lead Warehouse Specialist100$0.00times Work Hours=====
Material Handler100$0.00divided by ( 2080 hours -TOTALS0$0.00
Project Manager (Not a member of CBA)100$0.00( (Holidays + Vacations) * 8) )======
100$0.00times the hourly rate
100$0.00in each category
----
TOTALS60$0
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Warehouse Specialist/Forklift Operator0$7.78$0.00
Lead Warehouse Specialist0$7.78$0.00
Material Handler0$7.78$0.00
Project Manager (Not a member of CBA)0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE AND PENSION$0.00
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
------
SUBTOTAL$0.00
======
FICAX7.65%=$0.00
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Custodial

SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)
Custodial Operations Work SheetCustodial Operations Work SheetCustodial Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Custodian (Excluding RSHA, Meat Custodial & Outside Areas)0$18.45$0.00COST ELEMENTDOLLARS
Custodian, Meat Custodial Operations0$18.45$0.00==
Custodian, RSHA Custodial Operations (Including Outside Areas)0$18.45$0.00Qty.Unit/ExtendedDIRECT LABOR0.00
Lead Custodian0$19.95$0.00ElementsYearlyPricePriceHEALTH & WELFARE AND PENSION0.00
Project Manager (Not a member of CBA)0$0.00$0.00========
0$0.00$0.00Bowl, Cleaner00.00$0.00SUB-TOTAL0.00
----Cartridges00.00$0.00
TOTALS0$0.00Cleaner, Carpet00.000.00HOLIDAYS & VACATIONS0.00
====Cleaner, Compound00.000.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION0.00
Indirect Labor Hours (Non-Working)0Cleaner, Glass00.000.00==
=Cleaner, Neutral00.000.00SUB-TOTAL0.00
Direct Labor Hours (Productive/Working)0Disinfectant00.000.00
=Dust Cloths00.000.00FRINGES0.00
Dust Mop Heads00.000.00
Direct Labor Health & Welfare and PensionFloor Finish00.000.00EQUIPMENT & SUPPLIES0.00
CBA H&W $3.78Floor Sealer00.000.00-
andH&WFloor Stripper00.000.00SUB-TOTAL0.00
COST ELEMENTHours XCBA Pension $4.00CostGloves00.000.00=
=====Gloves, Latex00.000.00G&A0.00%0.00
Custodian (Excluding RSHA, Meat Custodial & Outside Areas)0$7.78$0.00Kintowel Wiper00.000.00
Custodian, Meat Custodial Operations0$7.78$0.00LiquidLive00.000.00PROFIT0.00%0.00
Custodian, RSHA Custodial Operations (Including Outside Areas)0$7.78$0.00Masks00.000.00
Lead Custodian0$7.78$0.00Mop Head, Wet00.000.00==
Project Manager (Not a member of CBA)0$0.00$0.00Neutralizer00.000.00GRAND TOTAL0.00
0$0.00$0.00Pads, Aqua 27"00.000.00====
----Pads, Buffing00.000.00MONTHLY PRICE0.00
TOTALS0$0Pads, Doodle Bug00.000.00===
====Polish, Furniture00.000.00
Polish, Metal00.000.00
Holidays and VacationsPropane00.000.00
HolidaysRain Suit00.000.00
VacationsRespirators00.000.00
COST ELEMENTHolidaysVacationsDollarsRetainer00.000.00
=====Safety Shoes00.000.00
Custodian (Excluding RSHA, Meat Custodial & Outside Areas)100$0.00( (Holidays + Vacations) * 8)Sanitizer, Compound D200.000.00
Custodian, Meat Custodial Operations100$0.00times Work HoursSoap, Hand, Liquid00.000.00
Custodian, RSHA Custodial Operations (Including Outside Areas)100$0.00divided by ( 2080 hours -Sponges00.000.00
Lead Custodian100$0.00( (Holidays + Vacations) * 8) )Spray Bottle00.000.00
Project Manager (Not a member of CBA)100$0.00times the hourly rateSpray Bottle Trigger00.000.00
100$0.00in each categorySpray Buff00.000.00
----Toilet Tissue, 96rl00.000.00
TOTALS60$0Towels, Pop-Up00.000.00
====Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays and Vacations Health & Welfare and PensionVaccuum Belts00.000.00
Visors00.000.00
HolidaysCBA H&W $3.78Battery Charger00.000.00
VacationsandH&WBuffer, High Speed00.000.00
COST ELEMENTHours XCBA Pension $4.00CostBurnisher High Speed00.000.00
=====Burnisher, 21" Propane00.000.00
Custodian (Excluding RSHA, Meat Custodial & Outside Areas)0$7.78$0.00Caddy, Maid00.000.00
Custodian, Meat Custodial Operations0$7.78$0.00Carpet Extractor00.000.00
Custodian, RSHA Custodial Operations (Including Outside Areas)0$7.78$0.00Floor Scrubber, Low Speed00.000.00
Lead Custodian0$7.78$0.00Scrubber, 20"00.000.00
Project Manager (Not a member of CBA)0$0.00$0.00Scrubber, Auto00.000.00
0$0.00$0.00Vacuum, Wet/Dry00.000.00
----Washer, Pressure00.000.00
TOTALS0$0.0000.000.00
====00.000.00
======
TOTALS$0.00
FRINGE CALCULATIONS======
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE AND PENSION$0.00
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
------
SUBTOTAL$0.00
======
FICAX7.65%=$0.00
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Year Totals

SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR0.00
DIRECT LABOR HEALTH & WELFARE AND PENSION0.00
==
TOTAL0.00
HOLIDAYS AND VACATIONS0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION0.00
==
TOTAL0.00
FRINGE CALCULATIONS0.00
SUPPLIES & EQUIPMENT0.00
SUB-TOTAL0.00
G&A0.00
PROFIT0.00
==
GRAND TOTAL0.00
==

Click Here to Print

5 Yr. Totals

SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR0.000.000.000.000.000.00
DIRECT LABOR HEALTH & WELFARE AND PENSION0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
HOLIDAYS AND VACATIONS0.000.000.000.000.000.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
FRINGE CALCULATIONS0.000.000.000.000.000.00
SUPPLIES & EQUIPMENT0.000.000.000.000.000.00
SUB-TOTAL0.000.000.000.000.000.00
G&A0.000.000.000.000.000.00
PROFIT0.000.000.000.000.000.00
=======
GRAND TOTAL0.000.000.000.000.000.00
=======
SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)
ESCALATION FACTORS
OPTION 1OPTION 2OPTION 3OPTION 4
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARS
======
DIRECT LABOR0.00%0.00%0.00%0.00%
DIRECT LABOR HEALTH & WELFARE AND PENSION0.00%0.00%0.00%0.00%
======
TOTAL
HOLIDAYS AND VACATIONS0.00%0.00%0.00%0.00%
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION0.00%0.00%0.00%0.00%
======
TOTAL
FRINGE CALCULATIONS0.00%0.00%0.00%0.00%
SUPPLIES & EQUIPMENT0.00%0.00%0.00%0.00%
SUB-TOTAL
G&A0.00%0.00%0.00%0.00%
PROFIT0.00%0.00%0.00%0.00%
======
GRAND TOTAL
======

Click Here to Print

Snow & Ice Removal

SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)CONTRACTOR NAME:(Enter Contractor Name)
Snow and Ice Removal Work SheetSnow and Ice Removal Work SheetSnow and Ice Removal Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Snow & Ice Removal Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Custodian (Snow & Ice Removal)0$18.45$0.00COST ELEMENTDOLLARS
0$0.00$0.00==
0$0.00$0.00Qty.Unit/ExtendedDIRECT LABOR0.00
0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE AND PENSION0.00
0$0.00$0.00========
0$0.00$0.00Snow Melt00.00$0.00SUB-TOTAL0.00
----Shovel00.00$0.00
TOTALS0$0.00Snow Blower00.00$0.00HOLIDAYS & VACATIONS0.00
====Cold Weather Clothing00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION0.00
Indirect Labor Hours (Non-Working)0Gloves00.00$0.00==
=Rain Suit00.00$0.00SUB-TOTAL0.00
Direct Labor Hours (Productive/Working)000.00$0.00
=00.00$0.00FRINGES0.00
======
Direct Labor Health & Welfare and PensionTOTALS$0.00EQUIPMENT & SUPPLIES0.00
CBA H&W $3.78======-
andH&WSUB-TOTAL0.00
COST ELEMENTHours XCBA Pension $4.00Cost=
=====G&A0.00%0.00
Custodian (Snow & Ice Removal)0$7.78$0.00
0$0.00$0.00PROFIT0.00%0.00
0$0.00$0.00
0$0.00$0.00==
0$0.00$0.00GRAND TOTAL0.00
0$0.00$0.00====
----OCTOBER THROUGH APRILMONTHLY PRICE0.00
TOTALS0$0===
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Custodian (Snow & Ice Removal)100$0.00( (Holidays + Vacations) * 8)
00$0.00times Work Hours
00$0.00divided by ( 2080 hours -
00$0.00( (Holidays + Vacations) * 8) )
00$0.00times the hourly rate
00$0.00in each category
----
TOTALS10$0
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Custodian (Snow & Ice Removal)0$7.78$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE AND PENSION$0.00
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.00
------
SUBTOTAL$0.00
======
FICAX7.65%=$0.00
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Stock Clerks Loaded Wage Rate

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Stock Clerks Loaded Wage Rate Work SheetStock Clerks Loaded Wage Rate Work SheetStock Clerks Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost
=====
Stock Clerks1$19.32$19.32COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$19.32
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE AND PENSION$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$27.10
----ElementsYearlyPricePrice
TOTALS1$19.32======HOLIDAYS & VACATIONS$0.00
====Supplies and Equipment Costs00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.31
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$0.31
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$2.10
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.000.00-
CBA H&W $3.7800.000.00SUB-TOTAL$29.51
andH&W00.000.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00G&A0.00%$0.00
=====00.000.00
Stock Clerks1$7.78$7.7800.000.00PROFIT0.00%$0.00
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO$0.00$0.0000.000.00
CALCULATE THE LOADED HOURLY RATE. PROCEED$0.00$0.0000.000.00==
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES$0.00$0.0000.000.00GRAND TOTAL$29.51
$0.00$0.0000.000.00====
--$0.00$0.00======
----TOTALS$0.00
TOTALS1$7.78=====
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Stock Clerks100$0.00( (Holidays + Vacations) * 8)
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO00$0.00times Work Hours
CALCULATE THE LOADED HOURLY RATE. PROCEED00$0.00divided by ( 2080 hours -
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES00$0.00( (Holidays + Vacations) * 8) )
00$0.00times the hourly rate
-00$0.00in each category
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Stock Clerks0$7.78$0.31
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO0$0.00$0.00
CALCULATE THE LOADED HOURLY RATE. PROCEED0$0.00$0.00
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES0$0.00$0.00
0$0.00$0.00
-0$0.00$0.00
----
TOTALS0$0.31
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$19.32
DIRECT LABOR HEALTH & WELFARE AND PENSION$7.78
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$0.31
------
SUBTOTAL$27.41
======
FICAX7.65%=$2.10
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$2.10
======

Click Here to Print

Lead Stock Clerk Loaded Rate

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Lead Stock Clerks Loaded Wage Rate Work SheetLead Stock Clerks Loaded Wage Rate Work SheetLead Stock Clerks Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Lead Stock Clerks1$20.82$20.82COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$20.82
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE AND PENSION$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$28.60
----ElementsYearlyPricePrice
TOTALS1$20.82======HOLIDAYS & VACATIONS$0.00
====Supplies and Equipment Costs00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$7.78
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$2.78
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.000.00-
CBA H&W $3.7800.000.00SUB-TOTAL$39.16
andH&W00.000.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00G&A0.00%$0.00
=====00.000.00
Lead Stock Clerks1$7.78$7.7800.000.00PROFIT0.00%$0.00
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO$0.00$0.0000.000.00
CALCULATE THE LOADED HOURLY RATE. PROCEED$0.00$0.0000.000.00==
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES$0.00$0.0000.000.00GRAND TOTAL$39.16
$0.00$0.0000.000.00====
--$0.00$0.00======
----TOTALS$0.00
TOTALS1$7.78=====
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Lead Stock Clerks100$0.00( (Holidays + Vacations) * 8)
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO00$0.00times Work Hours
CALCULATE THE LOADED HOURLY RATE. PROCEED00$0.00divided by ( 2080 hours -
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES00$0.00( (Holidays + Vacations) * 8) )
000$0.00times the hourly rate
-00$0.00in each category
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Lead Stock Clerks1$7.78$7.78
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO0$0.00$0.00
CALCULATE THE LOADED HOURLY RATE. PROCEED0$0.00$0.00
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES0$0.00$0.00
00$0.00$0.00
-0$0.00$0.00
----
TOTALS1$7.78
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$20.82
DIRECT LABOR HEALTH & WELFARE AND PENSION$7.78
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
------
SUBTOTAL$36.38
======
FICAX7.65%=$2.78
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$2.78
======

Click Here to Print

Warehouse Loaded Wage Rate

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Warehouse Specialist Loaded Wage Rate Work SheetWarehouse Specialist Loaded Wage Rate Work SheetWarehouse Specialist Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Warehouse Specialist/Forklift Operator1$19.76$19.76COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$19.76
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE AND PENSION$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$27.54
----ElementsYearlyPricePrice
TOTALS1$19.76======HOLIDAYS & VACATIONS$0.00
====Supplies and Equipment Costs00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$7.78
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$2.70
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.000.00-
CBA H&W $3.7800.000.00SUB-TOTAL$38.02
andH&W00.000.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00G&A0.00%$0.00
=====00.000.00
Warehouse Specialist/Forklift Operator1$7.78$7.7800.000.00PROFIT0.00%$0.00
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO$0.00$0.0000.000.00
CALCULATE THE LOADED HOURLY RATE. PROCEED$0.00$0.0000.000.00==
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES$0.00$0.0000.000.00GRAND TOTAL$38.02
$0.00$0.0000.000.00====
-$0.00$0.00======
----TOTALS$0.00
TOTALS1$7.78=====
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Warehouse Specialist/Forklift Operator100$0.00( (Holidays + Vacations) * 8)
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO00$0.00times Work Hours
CALCULATE THE LOADED HOURLY RATE. PROCEED00$0.00divided by ( 2080 hours -
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES00$0.00( (Holidays + Vacations) * 8) )
00$0.00times the hourly rate
-00$0.00in each category
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Warehouse Specialist/Forklift Operator1$7.78$7.78
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO0$0.00$0.00
CALCULATE THE LOADED HOURLY RATE. PROCEED0$0.00$0.00
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES0$0.00$0.00
0$0.00$0.00
-0$0.00$0.00
----
TOTALS1$7.78
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$19.76
DIRECT LABOR HEALTH & WELFARE AND PENSION$7.78
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
------
SUBTOTAL$35.32
======
FICAX7.65%=$2.70
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$2.70
======

Click Here to Print

Lead Warehouse Loaded Rate

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Lead Warehouse Specialist Loaded Wage Rate Work SheetLead Warehouse Specialist Loaded Wage Rate Work SheetLead Warehouse Specialist Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Lead Warehouse Specialist1$21.26$21.26COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$21.26
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE AND PENSION$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$29.04
----ElementsYearlyPricePrice
TOTALS1$21.26======HOLIDAYS & VACATIONS$0.00
====Supplies and Equipment Costs00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$7.78
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$2.82
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.000.00-
CBA H&W $3.7800.000.00SUB-TOTAL$39.64
andH&W00.000.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00G&A0.00%$0.00
=====00.000.00
Lead Warehouse Specialist1$7.78$7.7800.000.00PROFIT0.00%$0.00
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO$0.00$0.0000.000.00
CALCULATE THE LOADED HOURLY RATE. PROCEED$0.00$0.0000.000.00==
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES$0.00$0.0000.000.00GRAND TOTAL$39.64
$0.00$0.0000.000.00====
--$0.00$0.00======
----TOTALS$0.00
TOTALS1$7.78=====
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Lead Warehouse Specialist100$0.00( (Holidays + Vacations) * 8)
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO00$0.00times Work Hours
CALCULATE THE LOADED HOURLY RATE. PROCEED00$0.00divided by ( 2080 hours -
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES00$0.00( (Holidays + Vacations) * 8) )
000$0.00times the hourly rate
-00$0.00in each category
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Lead Warehouse Specialist1$7.78$7.78
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO0$0.00$0.00
CALCULATE THE LOADED HOURLY RATE. PROCEED0$0.00$0.00
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES0$0.00$0.00
00$0.00$0.00
-0$0.00$0.00
----
TOTALS1$7.78
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$21.26
DIRECT LABOR HEALTH & WELFARE AND PENSION$7.78
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
------
SUBTOTAL$36.82
======
FICAX7.65%=$2.82
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$2.82
======

Click Here to Print

Material Handler Loaded Wage

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:TBDCONTRACTOR NAME:TBDCONTRACTOR NAME:TBD
Base Year Pricing
MATERIAL HANDLER LOADED WAGE RATE WORK SHEETMATERIAL HANDLER LOADED WAGE RATE WORK SHEETMATERIAL HANDLER LOADED WAGE RATE WORK SHEET
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Material Handler1$18.45$18.45COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$18.45
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$26.23
----Qty.Unit/Extended
TOTALS1$18.45ElementsYearlyPricePriceHOLIDAYS/SICK/VACATIONS$1.81
==========HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs==
=are not included in the loadedSUB-TOTAL$1.81
Direct Labor Hours (Productive/Working)1rate for Material Handler
=FRINGES$0.00
EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare-
CBA H&W $3.78SUB-TOTAL$28.04
andH&W=
COST ELEMENTHoursCBA Pension $4.00CostG&A0.00%$0.00
=====
Material Handler1$7.78$7.78PROFIT0.00%$0.00
==
GRAND TOTAL$28.04
====
----======
TOTALS1$7.78TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handler1010$1.81
$0.00(Work hours divided by ((2080 hours-
$0.00(Holidays/Sick+ Vacations)*8))) *
$0.00((Closed Holidays*8*Hourly rate)+
$0.00(Holidays worked*8*Hourly rate* time & half))+
$0.00(Work Hours divided by(2080-((Holidays/Sick+
----Vacations)*8)))*(Vacations *8*Hourly rate)
TOTALS10$1.81
====
Holidays and Vacations Health & Welfare
CBA H&W $3.78
Holidays/Sick/andH&W
COST ELEMENTVacationsCBA Pension $4.00Cost
=====
Material Handler0$7.78$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$18.45
DIRECT HEALTH & WELFARE COSTS$7.78
HOLIDAYS/SICK/VACATION$1.81
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.00
------
SUBTOTAL$28.04
======
FICAX0.00%=$0.00
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
Comprehensive General LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Custodian Loaded Wage Rate

Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003SOLICITATION NUMBER:HDEC08-21-R-0003
COMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, COCOMMISSARY:Peterson AFB, CO
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Custodian Loaded Wage Rate Work SheetCustodian Loaded Wage Rate Work SheetCustodian Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Custodian1$18.45$18.45COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$18.45
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE AND PENSION$7.78
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$26.23
----ElementsYearlyPricePrice
TOTALS1$18.45======HOLIDAYS & VACATIONS$0.00
====Supplies and Equipment Costs00.00$0.00HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$7.78
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$2.60
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health & Welfare and Pension00.000.00-
CBA H&W $3.7800.000.00SUB-TOTAL$36.61
andH&W00.000.00=
COST ELEMENTHours XCBA Pension $4.00Cost00.000.00G&A0.00%$0.00
=====00.000.00
Custodian1$7.78$7.7800.000.00PROFIT0.00%$0.00
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO$0.00$0.0000.000.00
CALCULATE THE LOADED HOURLY RATE. PROCEED$0.00$0.0000.000.00==
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES$0.00$0.0000.000.00GRAND TOTAL$36.61
$0.00$0.0000.000.00====
--$0.00$0.00======
----TOTALS$0.00
TOTALS1$7.78=====
====
Holidays and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Custodian100$0.00( (Holidays + Vacations) * 8)
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO00$0.00times Work Hours
CALCULATE THE LOADED HOURLY RATE. PROCEED00$0.00divided by ( 2080 hours -
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES00$0.00( (Holidays + Vacations) * 8) )
000$0.00times the hourly rate
-00$0.00in each category
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare and Pension
HolidaysCBA H&W $3.78
VacationsandH&W
COST ELEMENTHours XCBA Pension $4.00Cost
=====
Custodian1$7.78$7.78
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO0$0.00$0.00
CALCULATE THE LOADED HOURLY RATE. PROCEED0$0.00$0.00
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES0$0.00$0.00
00$0.00$0.00
-0$0.00$0.00
----
TOTALS1$7.78
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$18.45
DIRECT LABOR HEALTH & WELFARE AND PENSION$7.78
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND PENSION$7.78
------
SUBTOTAL$34.01
======
FICAX7.65%=$2.60
FUTAX0.00%=$0.00
SUTAX0.00%=$0.00
Workman's CompensationX0.00%=$0.00
Employer's LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00

This is the start of the file's text. The full file is on GovTribe.

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