Attachment 4 Vol I - Cost Breakout.xls

XLS spreadsheet 427 KB Posted

Attached to
Utilities and Housekeeping Services Federal contract opportunity
Solicitation number
HDEC08-11-R-0007
Issued by
Defense Commissary Agency

About this file

Attachment 4 Vol I - Cost Breakout

View the file

Other files for this federal contract opportunity

Other files attached to Utilities and Housekeeping Services, newest first.
File Type Posted
Ft Meade award LEAP Posting —
Attachment 5 Volume II.doc DOC document
Attachment 3 Collective Bargaining Agreement.pdf PDF
HDEC08-11-R-0007.doc DOC document
Attachment 2 Performance Work Statement.doc DOC document
Attachment 7 Volume III Past Performance Information.doc DOC document
Attachment 1 DD1707 Information to Offerors.doc DOC document
Attachment 6 - Vol II TDWS DLS.xls XLS spreadsheet
Attachment 8 Bereavement Leave Certification.doc DOC document

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

Cost Breakout

Attachment 4
HDEC08-11-R-0007
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; however,
it is ultimately the contractors responsibility to ensure that all information submitted is
correct in accordance with the applicable Wage Determination and/or Collective
Bargaining Agreement.

Printing Instructions

Attachment 4
BASIC INSTRUCTIONSHDEC08-11-R-0007
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
RS_PAGE1Fit Columns to PageE:A1..E:A8PortraitResidual Grocery Direct Labor, Health & Welfare Sheet
RS_PAGE2Fit Columns to PageE:A1..E:A8PortraitResidual Grocery Holidays & Vacations Sheet
RS_PAGE3Fit Columns to PageE:A1..E:A8PortraitResidual Grocery Fringe Calculations Sheet
RS_PAGE4Fit Columns to PageE:I1..E:I19PortraitResidual Grocery Supplies & Equipment Sheet
RS_PAGE5Fit Columns to PageNonePortraitResidual Grocery 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, RSH and Residual Grocery
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 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
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" Paragraph B $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Store Worker I0$17.15$0.00COST ELEMENTDOLLARS
0$0.00$0.00==
0$0.00$0.00HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Store Worker I0$ 1.50$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----0$ 1.50$0.00Cutter, Carton00.00$0.00
TOTALS0$0.000$ 1.50$0.00Dispenser, Tape00.000.00HOLIDAYS/SICK/VACATIONS$0.00
====0$ 1.50$0.00Safety Shoes00.000.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)- 00$ 1.50$0.00Tape Masking00.000.00==
=0$ 1.50$0.00Back Brace00.000.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)- 0Cart, Bushel00.000.00
=Cart, Stocking00.000.00FRINGES$0.00
Pallet Jacks00.000.00
======00.000.00PENSION$0.00
TOTALS0$0.0000.000.00
Direct Labor Health and Welfare======00.000.00EQUIPMENT & SUPPLIES$0.00
00.000.00-
H&WH&W00.000.00SUB-TOTAL$0.00
COST ELEMENTHoursRatesCost00.000.00=
=====00.000.00G&A (Amount Fixed)0.00%$0.00
Store Worker I0$3.50$0.0000.000.00
0$3.50$0.00======PROFIT (Amount Fixed)0.00%$0.00
0$3.50$0.00TOTALS0$0.00
0$0.00$0.00=======
0$0.00$0.00GRAND TOTAL$0.00
0$0.00$0.00====
----ANNUAL CASES1,232,928
TOTALS0$0.00===
====CASE PRICE$0.00000
===
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I1016$0.00( (Holidays + Vacations) * 8)
100$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
----
TOTALS20$0.00
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Store Worker I0$3.50$0.00
0$3.50$0.00
0$3.50$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
----
TOTALS0$0.00$ - 0
====
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 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
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" Paragraph B - $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Material Handling Laboror0$15.91$0.00COST ELEMENTDOLLARS
Warehouse Specialist/Forklift Operator0$20.40$0.00==
0$0.00$0.00HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Material Handling Laboror0$ 1.50$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----Warehouse Specialist/Forklift Operator0$ 1.50$0.00Cutter, Carton00.00$0.00
TOTALS0$0.000$ - 0$0.00Dispenser, Tape00.00$0.00HOLIDAYS/SICK/VACATIONS$0.00
====0$ - 0$0.00Safety Shoes00.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)- 00$ - 0$0.00Tape Masking00.00$0.00==
=0$ - 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
0.00.00$0.00-
H&WH&W00.00$0.00SUB-TOTAL$0.00
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Material Handling Laboror0$3.50$0.0000.00$0.00
Warehouse Specialist/Forklift Operator0$3.50$0.00======PROFIT (Amount Fixed)0.00%$0.00
0$3.50$0.00TOTALS00.00$0.00
0$3.50$0.00=======
0$0.00$0.00GRAND TOTAL$0.00
0$0.00$0.00====
----===
TOTALS0$0.00
====MO PRICE$0.00
===
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handling Laboror1016$0.00( (Holidays + Vacations) * 8)
Warehouse Specialist/Forklift Operator1016$0.00times Work Hours
100$0.00divided by ( 2080 hours -
100$0.00( (Holidays + Vacations) * 8) )
00$0.00times the hourly rate
00$0.00in each category
----
TOTALS40$0.00
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Material Handling Laboror0$3.50$0.00
Warehouse Specialist/Forklift Operator0$3.50$0.00
0$3.50$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 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 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
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" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Janitor0$13.76$0.00COST ELEMENTDOLLARS
0$0.00$0.00==
0$0.00$0.00HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$0.00
0$0.00$0.00Labor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$0.00
0$0.00$0.00==============
0$0.00$0.00Janitor0$ 1.50$0.00Bowl, Cleaner00.00$0.00SUB-TOTAL$0.00
----0$ 1.50$0.00Cartridges00.00$0.00
TOTALS0$0.000$ 1.50$0.00Cleaner, Carpet00.000.00HOLIDAYS/SICK/VACATIONS$0.00
====0$ 1.50$0.00Cleaner, Compound00.000.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)- 00$ 1.50$0.00Cleaner, Glass00.000.00==
=0$ 1.50$0.00Cleaner, Neutral00.000.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)- 0Disinfectant00.000.00
=Dust Cloths00.000.00FRINGES$0.00
Dust Mop Heads00.000.00
Floor Finish00.000.00PENSION$0.00
Floor Sealer00.000.00
Direct Labor Health and Welfare======Floor Stripper00.000.00EQUIPMENT & SUPPLIES$0.00
TOTALS0$0.00Gloves00.000.00-
H&WH&W======Gloves, Latex00.000.00SUB-TOTAL$0.00
COST ELEMENTHoursRates =CostKintowel Wiper00.000.00=
=====LiquidLive00.000.00G&A (Amount Fixed)0.00%$0.00
Janitor0$3.50$0.00Masks00.000.00
0$3.50$0.00Mop Head, Wet00.000.00PROFIT (Amount Fixed)0.00%$0.00
0$3.50$0.00Neutralizer00.000.00
0$0.00$0.00Pads, Aqua 27"00.000.00==
0$0.00$0.00Pads, Buffing00.000.00GRAND TOTAL$0.00
0$0.00$0.00Pads, Doodle Bug00.000.00====
----Polish, Furniture00.000.00MONTHLY PRICE$0.00
TOTALS0$0.00Polish, Metal00.000.00===
====Propane00.000.00
Rain Suit00.000.00
Holidays and VacationsRespirators00.000.00
Holidays, Sick,Retainer00.000.00
Sick/VacationsSafety Shoes00.000.00
COST ELEMENTHolidaysVacationsDollarsSanitizer, Compound D200.000.00
=====Soap, Hand, Liquid00.000.00
Janitor1016$0.00( (Holidays + Vacations) * 8)Sponges00.000.00
100$0.00times Work HoursSpray Bottle00.000.00
100$0.00divided by ( 2080 hours -Spray Bottle Trigger00.000.00
00$0.00( (Holidays + Vacations) * 8) )Spray Buff0.00.000.00
00$0.00times the hourly rateToilet Tissue, 96rl0.00.000.00
00$0.00in each categoryTowels, Pop-Up0.00.000.00
----Trash Liners, Lg0.00.000.00
TOTALS30$0.00Trash Liners, Sm0.00.000.00
====Vaccuum Belts0.00.000.00
Visors0.00.000.00
Holidays and Vacations Health & WelfareBattery Charger0.00.000.00
Buffer, High Speed00.000.00
Holidays/Sick/H&WH&WBurnisher High Speed00.000.00
COST ELEMENTVacationsRatesCostBurnisher, 21" Propane0.00.000.00
=====Caddy, Maid0.00.000.00
Janitor0$3.50$0.00Carpet Extractor00.000.00
0$3.50$0.00Floor Scrubber, Low Speed0.00.000.00
0$3.50$0.00Scrubber, 20"00.000.00
0$0.00$0.00Scrubber, Auto00.000.00
0$0.00$0.00Vacuum, Wet/Dry00.000.00
0$0.00$0.00Washer, Pressure00.000.00
----00.000.00
TOTALS0$0.0000.000.00
==========
TOTALS0.0$0.00
FRINGE CALCULATIONS======
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$0.00
DIRECT HEALTH & WELFARE COST$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 4
SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADE
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

SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADESelect File, then Print from Excel
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR0.000.000.000.000.000.00
DIRECT LABOR HEALTH & WELFARE0.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 & WELFARE0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
FRINGE 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
=======
SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADE
CONTRACTOR NAME:
ESCALATION FACTORS
OPTION 1OPTION 2OPTION 3OPTION 4
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARS
======
DIRECT LABOR0.00%0.00%0.00%0.00%
DIRECT LABOR HEALTH & WELFARE0.00%0.00%0.00%0.00%
======
TOTAL
HOLIDAYS AND VACATIONS0.00%0.00%0.00%0.00%
HOLIDAYS AND VACATIONS. HEALTH & WELFARE0.00%0.00%0.00%0.00%
======
TOTAL
FRINGE CALCULATIONS0.00%0.00%0.00%0.00%
PENSION0.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
======

Shelf Stocker Loaded Wage Rate

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Shelf Stocker Loaded Wage Rate Work SheetShelf Stocker Loaded Wage Rate Work SheetShelf Stocker Loaded Wage Rate Work SheetShelf Stocker Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Store Worker I (Stocker)1$17.15$17.15COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$17.15
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESStore Worker I (Stocker)1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$20.65
----are not included in the loaded00.00$0.00
TOTALS1$17.15rate for Store Worker I00.00$0.00HOLIDAYS/SICK/VACATIONS$1.91
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$2.29
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$1.87
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$26.31
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Store Worker I (Stocker)1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$26.31
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I (Stocker)1016$1.91( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$1.91
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Store Worker I (Stocker)0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$17
DIRECT HEALTH & WELFARE COSTS$4
HOLIDAYS/SICK/VACATION$2
PENSION$2
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$24
======
FICAX7.65%=$2
FUTAX0.00%=$0
SUTAX0.00%=$0
Workman's CompensationX0.00%=$0
Employer's LiabilityX0.00%=$0
Comprehensive General LiabilityX0.00%=$0
OtherX0.00%=$0
OtherX0.00%=$0
------
TOTAL FRINGES$2
======

Click Here to Print

SStocker (Lead) Loaded Wage R

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Store Worker (Lead) Loaded Wage Rate Work SheetStore Worker (Lead) Loaded Wage Rate Work SheetStore Worker (Lead) Loaded Wage Rate Work SheetStore Worker (Lead) Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Store Worker I (Lead) (Stocker)1$17.65$17.65COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$17.65
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESStore Worker I (Lead) (Stocker)1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$21.15
----are not included in the loaded00.00$0.00
TOTALS1$17.65rate for Store Worker I00.00$0.00HOLIDAYS/SICK/VACATIONS$1.96
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$2.35
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$1.91
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$26.91
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Store Worker I (Lead) (Stocker)1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$26.91
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I (Lead) (Stocker)1016$1.96( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$1.96
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Store Worker I (Lead) (Stocker)0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$18
DIRECT HEALTH & WELFARE COSTS$4
HOLIDAYS/SICK/VACATION$2
PENSION$2
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$25
======
FICAX7.65%=$2
FUTAX0.00%=$0
SUTAX0.00%=$0
Workman's CompensationX0.00%=$0
Employer's LiabilityX0.00%=$0
Comprehensive General LiabilityX0.00%=$0
OtherX0.00%=$0
OtherX0.00%=$0
------
TOTAL FRINGES$2
======

Click Here to Print

WHS-FLO Loaded Wage Rate

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
WHS/Forklift Op Loaded Wage Rate Work SheetWHS/Forklift Op Loaded Wage Rate Work SheetWHS/Forklift Op Loaded Wage Rate Work SheetWHS/Forklift Op Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Warehouse Spec/Forklift Operator1$20.40$20.40COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$20.40
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESWarehouse Spec/Forklift Operator1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$23.90
----are not included in the loaded00.00$0.00
TOTALS1$20.40rate for Forklift Operator00.00$0.00HOLIDAYS/SICK/VACATIONS$2.27
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$2.66
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$2.15
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$30.20
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Warehouse Spec/Forklift Operator1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$30.20
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Warehouse Spec/Forklift Operator1016$2.27( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$2.27
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Warehouse Spec/Forklift Operator0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$20.40
DIRECT HEALTH & WELFARE COSTS$3.50
HOLIDAYS/SICK/VACATION$2.27
PENSION$1.50
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.39
------
SUBTOTAL$28.06
======
FICAX7.65%=$2.15
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$2.15
======

Click Here to Print

Material Handling Loaded Wage

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Material Handling LaborerMaterial Handling LaborerMaterial Handling LaborerMaterial Handling Laborer
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Material Handling Laborer1$15.91$15.91COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$15.91
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESMaterial Handling Laborer1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$19.41
----are not included in the loaded00.00$0.00
TOTALS1$15.91rate for Forklift Operator00.00$0.00HOLIDAYS/SICK/VACATIONS$1.77
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$2.16
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$1.76
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$24.83
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Material Handling Laborer1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$24.83
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handling Laborer1016$1.77( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$1.77
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Material Handling Laborer0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$15.91
DIRECT HEALTH & WELFARE COSTS$3.50
HOLIDAYS/SICK/VACATION$1.77
PENSION$1.50
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.39
------
SUBTOTAL$23.07
======
FICAX7.65%=$1.76
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.76
======

Click Here to Print

RSHA (Lead) Loaded Wage

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
RSHA (Lead) LaborerRSHA (Lead) LaborerRSHA (Lead) LaborerRSHA (Lead) Laborer
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
RSHA (Lead) Laborer1$20.90$20.90COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$20.90
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESRSHA (Lead) Laborer1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$24.40
----are not included in the loaded00.00$0.00
TOTALS1$20.90rate for Forklift Operator00.00$0.00HOLIDAYS/SICK/VACATIONS$2.32
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$2.71
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$2.19
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$30.80
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
RSHA (Lead) Laborer1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$30.80
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
RSHA (Lead) Laborer1016$2.32( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$2.32
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
RSHA (Lead) Laborer0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$20.90
DIRECT HEALTH & WELFARE COSTS$3.50
HOLIDAYS/SICK/VACATION$2.32
PENSION$1.50
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.39
------
SUBTOTAL$28.61
======
FICAX7.65%=$2.19
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$2.19
======

Click Here to Print

Janitor Loaded Wage Rate

Attachment 4Attachment 4Attachment 4Attachment 4
SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007SOLICITATION NUMBER:HDEC08-11-R-0007
COMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADECOMMISSARY:FORT MEADE
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Janitor Loaded Wage Rate Work SheetJanitor Loaded Wage Rate Work SheetJanitor Loaded Wage Rate Work SheetJanitor Loaded Wage Rate Work Sheet
Direct LaborContractor Proposed PensionContractor ProposedDOLLAR TOTALS
(The labor categories below are SAMPLES)Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(Schedule "A" Paragraph B- $1.50/hour per Bargaining Union Employee)(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Janitor1$13.76$13.76COST ELEMENTDOLLARS
==
HoursRateExtendedQty.Unit/ExtendedDIRECT LABOR$13.76
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TOLabor CategoriesPriceElementsYearlyPricePriceDIRECT LABOR HEALTH & WELFARE$3.50
CALCULATE THE LOADED HOURLY RATE. PROCEED==============
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGESJanitor1$ 1.50$1.50Supplies and Equipment Costs00.00$0.00SUB-TOTAL$17.26
----are not included in the loaded00.00$0.00
TOTALS1$13.76rate for Janitor00.00$0.00HOLIDAYS/SICK/VACATIONS$1.53
====00.00$0.00HOL & VAC. HEALTH & WELFARE$0.39
Indirect Labor Hours (Non-Working)000.00$0.00==
=00.00$0.00SUB-TOTAL$1.92
Direct Labor Hours (Productive/Working)100.00$0.00
=00.00$0.00FRINGES$1.58
00.00$0.00
======00.00$0.00PENSION$1.50
TOTALS1$1.5000.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$22.26
COST ELEMENTHoursRatesCost00.00$0.00=
=====00.00$0.00G&A (Amount Fixed)0.00%$0.00
Janitor1$3.50$3.5000.00$0.00
======PROFIT (Amount Fixed)0.00%$0.00
TOTALS00.00$0.00
=======
GRAND TOTAL$22.26
====
----
TOTALS1$3.50
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Janitor1016$1.53( (Holidays + Vacations) * 8)
times Work Hours
divided by ( 2080 hours -
( (Holidays + Vacations) * 8) )
times the hourly rate
in each category
----
TOTALS10$1.53
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Janitor0$3.50$0.39
----
TOTALS0$0.39
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$13.76
DIRECT HEALTH & WELFARE COSTS$3.50
HOLIDAYS/SICK/VACATION$1.53
PENSION$1.50
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.39
------

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 .