ATTACHMENT 5 Volume I Cost Breakout Amendment 0001.xls

XLS spreadsheet 415 KB Posted

Attached to
Shelf Stocking, Receiving/Storage/Holding Area and Custodial Operations
Solicitation number
HDEC0812R0002
Issued by

About this file

ATTACHMENT 5 Volume I Cost Breakout Amendment 0001

View the file

Other files

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 5
HDEC08-12-R-0002 Amend 0001
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, Yearly Totals, and 5 Year totals 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.

Printing Instructions

BASIC INSTRUCTIONSAttachment 5
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 , RSHA, and Custodial
GRAND_TOTALSFit Columns to PageNoneLandscape5 year totals of Shelf Stocking , RSHA, and Custoidal
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

ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Shelf Stocking Operations Work SheetShelf Stocking Operations Work SheetShelf Stocking Operations Work SheetShelf Stocking Operations Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Shelf Stocking Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Stocker & Stock Clerk0$16.11$0.00NOTE: PM - ALT PM - SUPERVISOR's are NOT Bargaining Unit EmployeesCOST ELEMENTDOLLARS
0$0.00$0.00==
0$0.00$0.00Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Stocker & Stock Clerk0$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----00$0.00Cutter, Carton00.00$0.00
TOTALS0$0.000$0.00Dispenser, Tape00.00$0.00HOLIDAYS/SICK/VACATIONS$0.00
====0$0.00Safety Shoes00.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0$0.00Tape Masking00.00$0.00==
=0$0.00Back 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
======00.00$0.00PENSION$0.00
TOTALS0$0.0000.00$0.00
Direct Labor Health and Welfare======00.00$0.00EQUIPMENT & SUPPLIES$0.00
00.00$0.00==
H&WH&W00.00$0.00SUB-TOTAL$0.00
COST ELEMENTHoursRatesCost00.00$0.00
=====00.00$0.00G&A0.00%$0.00
Stocker & Stock Clerk0$3.80$0.0000.00$0.00
00$0.00$0.00======PROFIT0.00%$0.00
00$0.00$0.00
00$0.00$0.00TOTALS00.00$0.00====
00$0.00$0.00=====GRAND TOTAL$0.00
00$0.00$0.00====
----ANNUAL CASES1,203,636
TOTALS0$0.00===
====CASE PRICE$0.0000
===
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Stocker & Stock Clerk100$0.00(Work hours divided by ((2080 hours-
000$0.00(Holidays/Sick+ Vacations)*8))) *
000$0.00((Closed Holidays*8*Hourly rate)+
000$0.00(Holidays worked*8*Hourly rate* time & half))+
000$0.00(Work Hours divided by(2080-((Holidays/Sick+
000$0.00Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.00
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Stocker & Stock Clerk0$3.80$0.00
00$0.00$0.00
00$0.00$0.00
00$0.00$0.00
00$0.00$0.00
00$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$0.00
DIRECT HEALTH & WELFARE COSTS$0.00
HOLIDAYS/SICK/VACATION$0.00
PENSION$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$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
Comprehensive General LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

RSH

ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
R/S/H Operations Work SheetR/S/H Operations Work SheetR/S/H Operations Work SheetR/S/H Operations Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)R/S/H Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Forklift Operator0$16.46$0.00NOTE: PM - ALT PM - SUPERVISOR's are NOT Bargaining Unit EmployeesCOST ELEMENTDOLLARS
Warehouse Specialist0$16.46$0.00==
Material Handler0$15.36$0.00Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Forklift Operator0$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----Warehouse Specialist0$0.00Cutter, Carton00.00$0.00
TOTALS0$0.00Material Handler0$0.00Dispenser, Tape00.00$0.00HOLIDAYS/SICK/VACATIONS$0.00
====00$0.00Safety Shoes00.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)00$0.00Tape Masking00.00$0.00==
=00$0.00Back 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
======00.00$0.00PENSION$0.00
TOTALS0$0.0000.00$0.00
Direct Labor Health and Welfare======00.00$0.00EQUIPMENT & SUPPLIES$0.00
00.00$0.00==
H&WH&W00.00$0.00SUB-TOTAL$0.00
COST ELEMENTHoursRatesCost00.00$0.00
=====00.00$0.00G&A0.00%$0.00
Forklift Operator0$3.80$0.0000.00$0.00
Warehouse Specialist0$3.80$0.0000.00$0.00PROFIT0.00%$0.00
Material Handler0$3.80$0.0000.00$0.00
00$0.00$0.0000.00$0.00====
00$0.00$0.0000.00$0.00GRAND TOTAL$0.00
00$0.00$0.0000.00$0.00====
----00.00$0.00MO. PRICE$0.00
TOTALS0$0.0000.00$0.00===
====00.00$0.00
00.00$0.00
Holidays, Sick and Vacations00.00$0.00
Holidays, Sick,00.00$0.00
Sick/Vacations00.00$0.00
COST ELEMENTHolidaysVacationsDollars00.00$0.00
=====00.00$0.00
Forklift Operator100$0.00(Work hours divided by ((2080 hours-00.00$0.00
Warehouse Specialist100$0.00(Holidays/Sick+ Vacations)*8))) *00.00$0.00
Material Handler100$0.00((Closed Holidays*8*Hourly rate)+00.00$0.00
000$0.00(Holidays worked*8*Hourly rate* time & half))+=====
000$0.00(Work Hours divided by(2080-((Holidays/Sick+TOTALS0$0.00
000$0.00Vacations)*8)))*(Vacations *8*Hourly rate)======
----
TOTALS30$0.00
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Forklift Operator0$3.80$0.00
Warehouse Specialist0$3.80$0.00
Material Handler0$3.80$0.00
00$0.00$0.00
00$0.00$0.00
00$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$0.00
DIRECT HEALTH & WELFARE COSTS$0.00
HOLIDAYS/SICK/VACATION$0.00
PENSION$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$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
Comprehensive General LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Custodial

ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Custodial Operations Work SheetCustodial Operations Work SheetCustodial Operations Work SheetCustodial Operations Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Custodial Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Custodian - Janitor0$15.36$0.00NOTE: PM - ALT PM - SUPERVISOR's are NOT Bargaining Unit EmployeesCOST ELEMENTDOLLARS
Custodian - Meat0$15.36$0.00==
0$0.00$0.00Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Custodian - Janitor0$0.00Bowl, Cleaner00.00$0.00SUB-TOTAL$0.00
----Custodian - Meat0$0.00Cartridges00.00$0.00
TOTALS0$0.000$0.00Cleaner, Carpet00.00$0.00HOLIDAYS/SICK/VACATIONS$0.00
====0$0.00Cleaner, Compound00.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0$0.00Cleaner, Glass00.00$0.00==
=0$0.00Cleaner, Neutral00.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Disinfectant00.00$0.00
=Dust Cloths00.00$0.00FRINGES$0.00
Dust Mop Heads00.00$0.00
======Floor Finish00.00$0.00PENSION$0.00
TOTALS0$0.00Floor Sealer00.00$0.00
Direct Labor Health and Welfare======Floor Stripper00.00$0.00EQUIPMENT & SUPPLIES$0.00
Gloves00.00$0.00==
H&WH&WGloves, Latex00.00$0.00SUB-TOTAL$0.00
COST ELEMENTHoursRatesCostKintowel Wiper00.00$0.00
=====LiquidLive00.00$0.00G&A0.00%$0.00
Custodian - Janitor0$3.80$0.00Masks00.00$0.00
Custodian - Meat0$3.80$0.00Mop Head, Wet00.00$0.00PROFIT0.00%$0.00
0$0.00$0.00Neutralizer00.00$0.00
0$0.00$0.00Pads, Aqua 27"00.00$0.00====
0$0.00$0.00Pads, Buffing00.00$0.00GRAND TOTAL$0.00
0$0.00$0.00Pads, Doodle Bug00.00$0.00====
----Polish, Furniture00.00$0.00MO. PRICE$0.00
TOTALS0$0.00Polish, Metal00.00$0.00===
====Propane00.00$0.00
Rain Suit00.00$0.00
Holidays, Sick and VacationsRespirators00.00$0.00
Holidays, Sick,Retainer00.00$0.00
Sick/VacationsSafety Shoes00.00$0.00
COST ELEMENTHolidaysVacationsDollarsSanitizer, Compound D200.00$0.00
=====Soap, Hand, Liquid00.00$0.00
Custodian - Janitor100$0.00(Work hours divided by ((2080 hours-Sponges00.00$0.00
Custodian - Meat100$0.00(Holidays/Sick+ Vacations)*8))) *Spray Bottle00.00$0.00
00$0.00((Closed Holidays*8*Hourly rate)+Spray Bottle Trigger00.00$0.00
00$0.00(Holidays worked*8*Hourly rate* time & half))+Spray Buff00.00$0.00
00$0.00(Work Hours divided by(2080-((Holidays/Sick+Toilet Tissue, 96rl00.00$0.00
00$0.00Vacations)*8)))*(Vacations *8*Hourly rate)Towels, Pop-Up00.00$0.00
----Trash Liners, Lg00.00$0.00
TOTALS20$0.00Trash Liners, Sm00.00$0.00
====Vaccuum Belts00.00$0.00
Visors00.00$0.00
Holidays and Vacations Health & WelfareBattery Charger00.00$0.00
Buffer, High Speed00.00$0.00
Holidays/Sick/H&WH&WBurnisher High Speed00.00$0.00
COST ELEMENTVacationsRatesCostBurnisher, 21" Propane00.00$0.00
=====Caddy, Maid00.00$0.00
Custodian - Janitor0$3.80$0.00Carpet Extractor00.00$0.00
Custodian - Meat0$3.80$0.00Floor Scrubber, Low Speed00.00$0.00
0$0.00$0.00Scrubber, 20"00.00$0.00
0$0.00$0.00Scrubber, Auto00.00$0.00
0$0.00$0.00Vacuum, Wet/Dry00.00$0.00
0$0.00$0.00Washer, Pressure00.00$0.00
----00.00$0.00
TOTALS0$0.0000.00$0.00
====00.00$0.00
00.00$0.00
00.00$0.00
00.00$0.00
FRINGE CALCULATIONS======
TOTALS0$0.00
======
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$0.00
DIRECT HEALTH & WELFARE COSTS$0.00
HOLIDAYS/SICK/VACATION$0.00
PENSION$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$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
Comprehensive General LiabilityX0.00%=$0.00
OtherX0.00%=$0.00
OtherX0.00%=$0.00
------
TOTAL FRINGES$0.00
======

Click Here to Print

Year Totals

ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR$0.00
DIRECT HEALTH & WELFARE$0.00
==
TOTAL$0.00
HOLIDAYS/SICK/VACATIONS$0.00
HOL & VAC. HEALTH & WELFARE$0.00
==
TOTAL$0.00
FRINGES CALCULATIONS$0.00
PENSION$0.00
SUPPLIES & EQUIPMENT$0.00
==
SUB-TOTAL$0.00
G&A$0.00
PROFIT$0.00
==
GRAND TOTAL$0.00
==

Click Here to Print

5 Yr. Totals

ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR0.000.000.000.000.000.00
DIRECT HEALTH & WELFARE0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
HOLIDAYS/SICK/VACATIONS0.000.000.000.000.000.00
HOL & VAC. HEALTH & WELFARE0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
FRINGES CALCULATIONS0.000.000.000.000.000.00
PENSION0.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
=======
ATTACHMENT 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:
ESCALATION FACTORS
OPTION 1OPTION 2OPTION 3OPTION 4
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARS
======
DIRECT LABOR0.00%0.00%0.00%0.00%
DIRECT HEALTH & WELFARE0.00%0.00%0.00%0.00%
======
TOTAL
HOLIDAYS & VACATIONS0.00%0.00%0.00%0.00%
HOL & VAC. HEALTH & WELFARE0.00%0.00%0.00%0.00%
======
TOTAL
FRINGES0.00%0.00%0.00%0.00%
PENSION0.00%0.00%0.00%0.00%
EQUIPMENT & SUPPLIES0.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

Shelf Stocker Loaded Wage Rate

Attachment 5Attachment 5Attachment 5Attachment 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Stocker Loaded Wage Rate SheetsStocker Loaded Wage Rate SheetsStocker Loaded Wage Rate SheetsStocker Loaded Wage Rate Sheets
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00Supplies and Equipment Costs are NOT included in the loaded hourly rates
=====
Stocker & Stock Clerk1$16.11$16.11COST ELEMENTDOLLARS
==
Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$16.11
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.80
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESStocker & Stock Clerk1$2.0000.00$0.00SUB-TOTAL$19.91
----00.00$0.00
TOTALS1$16.1100.000.00HOLIDAYS/SICK/VACATIONS$0.87
====00.000.00HOL & VAC. HEALTH & WELFARE$0.11
Indirect Labor Hours (Non-Working)00.000.00==
=00.000.00SUB-TOTAL$0.98
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.75
00.000.00
======00.000.00PENSION$2.00
TOTALS1.00$2.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00==
H&WH&W00.000.00SUB-TOTAL$24.64
COST ELEMENTHoursRatesCost00.000.00
=====00.000.00G&A0.00%$0.00
Stocker & Stock Clerk1$3.80$3.8000.000.00
======PROFIT0.00%$0.00
==
TOTALS00.00$0.00SUB-TOTAL$24.64
----=====
TOTALS1$3.80====
====RATE PER HOUR$24.64
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Stocker & Stock Clerk100$0.87(Work hours divided by ((2080 hours-
$0.00(Holidays/Sick+ Vacations)*8))) *
0$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+
$0.00Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.87
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Stocker & Stock Clerk0$2.75$0.11
----
TOTALS0$0.11
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$16.11
DIRECT HEALTH & WELFARE COSTS$3.80
HOLIDAYS/SICK/VACATION$0.87
PENSION$2.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.11
------
SUBTOTAL$22.89
======
FICAX7.65%=$1.75
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$1.75
======

Click Here to Print

Fork Lift Op Loaded Wage Rate

Attachment 5Attachment 5Attachment 5Attachment 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Forklift Operator Loaded Wage Rate Work SheetForklift Operator Loaded Wage Rate Work SheetForklift Operator Loaded Wage Rate Work SheetForklift Operator Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
RSHA Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00Supplies and Equipment Costs are NOT included in the loaded hourly rates
=====
Forklift Operator1$16.46$16.46COST ELEMENTDOLLARS
==
Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$16.46
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.80
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESForklift Operator1$2.0000.00$0.00SUB-TOTAL$20.26
----00.00$0.00
TOTALS1$16.4600.000.00HOLIDAYS/SICK/VACATIONS$0.89
====00.000.00HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)00.000.00==
=00.000.00SUB-TOTAL$1.04
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.78
00.000.00
======00.000.00PENSION$2.00
TOTALS1$2.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00==
H&WH&W00.000.00SUB-TOTAL$25.08
COST ELEMENTHoursRatesCost00.000.00
=====00.000.00G&A0.00%$0.00
Forklift Operator1$3.80$3.8000.000.00
======PROFIT0.00%$0.00
==
TOTALS00.00$0.00SUB-TOTAL$25.08
----=====
TOTALS1$3.80====
====RATE PER HOUR$25.08
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Forklift Operator100$0.89(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
(Work Hours divided by(2080-((Holidays/Sick+
Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.89
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Forklift Operator0$3.80$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$16.46
DIRECT HEALTH & WELFARE COSTS$3.80
HOLIDAYS/SICK/VACATION$0.89
PENSION$2.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$23.30
======
FICAX7.65%=$1.78
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$1.78
======

Click Here to Print

Warehouse Spec Loaded Wage

Attachment 5Attachment 5Attachment 5Attachment 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Warehouse Specialist Loaded Wage Rate Work SheetWarehouse Specialist Loaded Wage Rate Work SheetWarehouse Specialist Loaded Wage Rate Work SheetWarehouse Specialist Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
RSHA Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00Supplies and Equipment Costs are NOT included in the loaded hourly rates
=====
Warehouse Specialist1$16.46$16.46COST ELEMENTDOLLARS
==
Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$16.46
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.80
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESWarehouse Specialist1$2.0000.00$0.00SUB-TOTAL$20.26
----00.00$0.00
TOTALS1$16.4600.000.00HOLIDAYS/SICK/VACATIONS$0.89
====00.000.00HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)00.000.00==
=00.000.00SUB-TOTAL$1.04
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.78
00.000.00
======00.000.00PENSION$2.00
TOTALS1$2.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00==
H&WH&W00.000.00SUB-TOTAL$25.08
COST ELEMENTHoursRatesCost00.000.00
=====00.000.00G&A0.00%$0.00
Warehouse Specialist1$3.80$3.8000.000.00
======PROFIT0.00%$0.00
==
TOTALS00.00$0.00SUB-TOTAL$25.08
----=====
TOTALS1$3.80====
====RATE PER HOUR$25.08
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Warehouse Specialist100$0.89(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
0((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
(Work Hours divided by(2080-((Holidays/Sick+
Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.89
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Warehouse Specialist0$3.80$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$16.46
DIRECT HEALTH & WELFARE COSTS$3.80
HOLIDAYS/SICK/VACATION$0.89
PENSION$2.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$23.30
======
FICAX7.65%=$1.78
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$1.78
======

Click Here to Print

Material Handler Load Wage Lead

Attachment 5Attachment 5Attachment 5Attachment 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Material Handler Loaded Wage Rate Work SheetMaterial Handler Loaded Wage Rate Work SheetMaterial Handler Loaded Wage Rate Work SheetMaterial Handler Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
RSHA Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00Supplies and Equipment Costs are NOT included in the loaded hourly rates
=====
Material Handler1$15.36$15.36COST ELEMENTDOLLARS
==
Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$15.36
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.80
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESMaterial Handler1$2.0000.00$0.00SUB-TOTAL$19.16
----00.00$0.00
TOTALS1$15.3600.000.00HOLIDAYS/SICK/VACATIONS$0.83
====00.000.00HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)00.000.00==
=00.000.00SUB-TOTAL$0.98
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.69
00.000.00
======00.000.00PENSION$2.00
TOTALS1$2.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00==
H&WH&W00.000.00SUB-TOTAL$23.84
COST ELEMENTHoursRatesCost00.000.00
=====00.000.00G&A0.00%$0.00
Material Handler1$3.80$3.8000.000.00
======PROFIT0.00%$0.00
==
TOTALS00.00$0.00SUB-TOTAL$23.84
----=====
TOTALS1$3.80====
====RATE PER HOUR$23.84
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handler100$0.83(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
(Work Hours divided by(2080-((Holidays/Sick+
Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.83
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Material Handler0$3.80$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$15.36
DIRECT HEALTH & WELFARE COSTS$3.80
HOLIDAYS/SICK/VACATION$0.83
PENSION$2.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$22.14
======
FICAX7.65%=$1.69
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$1.69
======

Click Here to Print

Custodians Loaded Wage Rate

Attachment 5Attachment 5Attachment 5Attachment 5
SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001SOLICITATION NUMBER:HDEC08-12-R-0002 Amend 0001
COMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, ColoradoCOMMISSARY:Peterson AFB, Colorado
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Custodian Janitor Loaded Wage Rate Work SheetCustodian Janitor Loaded Wage Rate Work SheetCustodian Janitor Loaded Wage Rate Work SheetCustodian Janitor Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule A - $2.00/hour per Bargaining Unit Employee)$2.00Supplies and Equipment Costs are NOT included in the loaded hourly rates
=====
Custodian (Janitor & Meat)1$15.36$15.36COST ELEMENTDOLLARS
==
Hours +ExtendedQty.Unit/ExtendedDIRECT LABOR$15.36
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesSick/VacationPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.80
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESCustodian (Janitor & Meat)1$2.0000.00$0.00SUB-TOTAL$19.16
----00.00$0.00
TOTALS1$15.3600.000.00HOLIDAYS/SICK/VACATIONS$0.83
====00.000.00HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)00.000.00==
=00.000.00SUB-TOTAL$0.98
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.69
00.000.00
======00.000.00PENSION$2.00
TOTALS1$2.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00==
H&WH&W00.000.00SUB-TOTAL$23.84
COST ELEMENTHoursRatesCost00.000.00
=====00.000.00G&A0.00%$0.00
Custodian (Janitor & Meat)1$3.80$3.8000.000.00
======PROFIT0.00%$0.00
==
TOTALS00.00$0.00SUB-TOTAL$23.84
----=====
TOTALS1$3.80====
====RATE PER HOUR$23.84
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Custodian (Janitor & Meat)100$0.83(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
0((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
(Work Hours divided by(2080-((Holidays/Sick+
Vacations)*8)))*(Vacations *8*Hourly rate)
----
TOTALS10$0.83
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Custodian (Janitor & Meat)0$3.80$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$15.36
DIRECT HEALTH & WELFARE COSTS$3.80
HOLIDAYS/SICK/VACATION$0.83
PENSION$2.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$22.14
======
FICAX7.65%=$1.69
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$1.69
======

Click Here to Print

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