About this file

Attachment 3, Volume I, Cost Breakout for Camp Lejeune Commissary

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 3
HDEC08-18-R-0004
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, Residual Grocery, Custodial and
Receiving/Storage/Holding Area, Yearly Totals, and 5 Year totals as well as Printing
Instructions for these worksheets. The worksheets for Shelf Stocking, Residual Grocery,
Custodial and Receiving/Storage/Holding Area contain "sample" occupational titles and
the applicable minimum wage rates.

&LRevised 04 Sep 2007

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
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 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Shelf Stocking Operations Work SheetShelf Stocking Operations Work SheetShelf Stocking Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WDR
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Store Worker I012.14$0COST ELEMENTDOLLARS
Project Manager00.00$0==
00.00$0Qty.Unit/ExtendedDIRECT LABOR0
00.00$0ElementsYearlyPricePriceHEALTH & WELFARE0
00.00$0========
00.00$0Blades, Carton Cutter00.00$0.00SUB-TOTAL0
----Cutter, Carton00.00$0.00
TOTALS0$0Dispenser, Tape00.000.00HOLIDAYS, SICK & VACATIONS0
====Safety Shoes00.000.00HOL, SICK & VAC. HEALTH & WELFARE0
Indirect Labor Hours (Non-Working)0Tape Masking00.000.00==
=Back Brace00.000.00SUB-TOTAL0
Direct Labor Hours (Productive/Working)0Cart, Bushel00.000.00
=Cart, Stocking00.000.00FRINGES0
Pallet Jacks00.000.00
Direct Labor Health & Welfare00.000.00EQUIPMENT & SUPPLIES0
00.000.00-
H&WH&W00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =Cost00.000.00=
=====00.000.00G&A0.00%0
Store Worker I04.48$000.000.00
Project Manager04.48$000.000.00PROFIT0.00%0
00.00$000.000.00
00.00$000.000.00==
00.00$000.000.00GRAND TOTAL0
00.00$000.000.00====
----00.000.00ANNUAL CASES969,912
TOTALS0$000.000.00===
====00.000.00CASE PRICE0
Holidays, Sick and Vacations00.000.00===
00.000.00
Holidays,00.000.00
Sick,Sick, Vacations00.000.00
COST ELEMENTHolidaysVacationsDollars00.000.00
=====00.000.00
Store Worker I100$0.00( (Holidays + Vacations) * 8)00.000.00
Project Manager100$0.00times Work Hours======
00$0.00divided by ( 2080 hours -TOTALS0$0.00
00$0.00( (Holidays + Vacations) * 8) )======
00$0.00times the hourly rate
00$0.00in each category
----
TOTALS20$0
====
Holidays, Sick, and Vacations Health & Welfare
Holidays, Sick,
VacationsH&WH&W
COST ELEMENTHours XRates =Cost
=====
Store Worker I04.48$0
Project Manager04.48$0
00.00$0
00.00$0
00.00$0
00.00$0
----
TOTALS0$0
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE$0
HOLIDAYS, SICK & VACATIONS$0
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$0
======
FICAX7.65%=$0
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$0
======

Click Here to Print

Residual Grocery

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Residual Grocery Operations Work SheetResidual Grocery Operations Work SheetResidual Grocery Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Residual Grocery Supplies & Equipment================
WDR
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Store Worker I-Residual Grocery012.14$0COST ELEMENTDOLLARS
Stock Clerk (Uses RF-HHT)-Residual Grocery017.09$0==
Janitor-Residual Grocery010.80$0Qty.Unit/ExtendedDIRECT LABOR0
Warehouse Specialist-Residual Grocery013.70$0ElementsYearlyPricePriceHEALTH & WELFARE0
Material Handling Laborer-Residual Grocery011.48$0========
Forklift Operator-Residual Grocery013.70$0Blades, Carton Cutter00.00$0.00SUB-TOTAL0
Project Manager00.00$0Cutter, Carton00.00$0.00
----Dispenser, Tape00.000.00HOLIDAYS, SICK & VACATIONS0
TOTALS0$0Safety Shoes00.000.00HOL, SICK & VAC. HEALTH & WELFARE0
====Tape Masking00.000.00==
Indirect Labor Hours (Non-Working)0Back Brace00.000.00SUB-TOTAL0
=Cart, Bushel00.000.00
Direct Labor Hours (Productive/Working)0Cart, Stocking00.000.00FRINGES0
=Pallet Jacks00.000.00
Bowl, Cleaner00.000.00EQUIPMENT & SUPPLIES0
Direct Labor Health & WelfareCartridges00.000.00-
Cleaner, Carpet00.000.00SUB-TOTAL0
H&WH&WCleaner, Compound00.000.00=
COST ELEMENTHours XRates =CostCleaner, Glass00.000.00G&A0.00%0
=====Cleaner, Neutral00.000.00
Store Worker I-Residual Grocery04.48$0Disinfectant00.000.00PROFIT0.00%0
Stock Clerk (Uses RF-HHT)-Residual Grocery04.48$0Dust Cloths00.000.00
Janitor-Residual Grocery04.48$0Dust Mop Heads00.000.00==
Warehouse Specialist-Residual Grocery04.48$0Gloves00.000.00GRAND TOTAL0
Material Handling Laborer-Residual Grocery04.48$0Gloves, Latex00.000.00====
Forklift Operator-Residual Grocery04.48$0Kintowel Wiper00.000.00MONTHS12
Project Manager04.48$0LiquidLive00.000.00===
----Masks00.000.00MONTHLY PRICE0
TOTALS0$0Mop Head, Wet00.000.00===
====Neutralizer00.000.00
Holidays, Sick and VacationsPolish, Furniture00.000.00
Polish, Metal00.000.00
Holidays,Propane00.000.00
Sick,Sick, VacationsRain Suit00.000.00
COST ELEMENTHolidaysVacationsDollarsRespirators00.000.00
=====Retainer00.000.00
Store Worker I-Residual Grocery100$0.00( (Holidays + Vacations) * 8)Safety Shoes00.000.00
Stock Clerk (Uses RF-HHT)-Residual Grocery100$0.00times Work HoursSanitizer, Compound D200.000.00
Janitor-Residual Grocery100$0.00divided by ( 2080 hours -Soap, Hand, Liquid00.000.00
Warehouse Specialist-Residual Grocery100$0.00( (Holidays + Vacations) * 8) )Sponges00.000.00
Material Handling Laborer-Residual Grocery100$0.00Spray Bottle00.000.00
Forklift Operator-Residual Grocery100$0.00times the hourly rateSpray Bottle Trigger00.000.00
Project Manager100$0.00in each categorySpray Buff00.000.00
----Toilet Tissue, 96rl00.000.00
TOTALS70$0Towels, Pop-Up00.000.00
====Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays, Sick, and Vacations Health & WelfareVaccuum Belts00.000.00
Visors00.000.00
Holidays, Sick,Battery Charger00.000.00
VacationsH&WH&WCaddy, Maid00.000.00
COST ELEMENTHours XRates =CostFloor Scrubber, Low Speed00.000.00
=====Scrubber, 20"00.000.00
Store Worker I-Residual Grocery04.48$0Scrubber, Auto00.000.00
Stock Clerk (Uses RF-HHT)-Residual Grocery04.48$0Vacuum, Wet/Dry00.000.00
Janitor-Residual Grocery04.48$0Washer, Pressure00.000.00
Warehouse Specialist-Residual Grocery04.48$0
Material Handling Laborer-Residual Grocery04.48$0======
Forklift Operator-Residual Grocery04.48$0TOTALS$0$0
Project Manager04.48$0======
----
TOTALS0$0
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE$0
HOLIDAYS, SICK, AND VACATIONS$0
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$0
======
FICAX7.65%=$0
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$0
======

Click Here to Print

Custodial

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Custodial Operations Work SheetCustodial Operations Work SheetCustodial Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
WDR
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Janitor010.80$0COST ELEMENTDOLLARS
Project Manager00.00$0==
00.00$0Qty.Unit/ExtendedDIRECT LABOR0
00.00$0ElementsYearlyPricePriceHEALTH & WELFARE0
00.00$0========
00.00$0Bowl, Cleaner00.00$0.00SUB-TOTAL0
----Cartridges00.00$0.00
TOTALS0$0Cleaner, Carpet00.000.00HOLIDAYS, SICK & VACATIONS0
====Cleaner, Compound00.000.00HOL, SICK & VAC. HEALTH & WELFARE0
Indirect Labor Hours (Non-Working)0Cleaner, Glass00.000.00==
=Cleaner, Neutral00.000.00SUB-TOTAL0
Direct Labor Hours (Productive/Working)0Disinfectant00.000.00
=Dust Cloths00.000.00FRINGES0
Dust Mop Heads00.000.00
Direct Labor Health & WelfareFloor Finish00.000.00EQUIPMENT & SUPPLIES0
Floor Sealer00.000.00-
H&WH&WFloor Stripper00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =CostGloves00.000.00=
=====Gloves, Latex00.000.00G&A0.00%0
Janitor04.48$0Kintowel Wiper00.000.00
Project Manager04.48$0LiquidLive00.000.00PROFIT0.00%0
00.00$0Masks00.000.00
00.00$0Mop Head, Wet00.000.00==
00.00$0Neutralizer00.000.00GRAND TOTAL0
00.00$0Pads, Aqua 27"00.000.00====
----Pads, Buffing00.000.00MONTHLY PRICE0
TOTALS0$0Pads, Doodle Bug00.000.00===
====Polish, Furniture00.000.00
Holidays, Sick and VacationsPolish, Metal00.000.00
Propane00.000.00
Holidays,Rain Suit00.000.00
Sick,Sick, VacationsRespirators00.000.00
COST ELEMENTHolidaysVacationsDollarsRetainer00.000.00
=====Safety Shoes00.000.00
Janitor100$0.00( (Holidays + Vacations) * 8)Sanitizer, Compound D200.000.00
Project Manager100$0.00times Work HoursSoap, Hand, Liquid00.000.00
00$0.00divided by ( 2080 hours -Sponges00.000.00
00$0.00( (Holidays + Vacations) * 8) )Spray Bottle00.000.00
00$0.00times the hourly rateSpray Bottle Trigger00.000.00
00$0.00in each categorySpray Buff00.000.00
----Toilet Tissue, 96rl00.000.00
TOTALS20$0Towels, Pop-Up00.000.00
====Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays, Sick, and Vacations Health & WelfareVaccuum Belts00.000.00
Visors00.000.00
Holidays, Sick,Battery Charger00.000.00
VacationsH&WH&WBuffer, High Speed00.000.00
COST ELEMENTHours XRates =CostBurnisher High Speed00.000.00
=====Burnisher, 21" Propane00.000.00
Janitor04.48$0Caddy, Maid00.000.00
Project Manager04.48$0Carpet Extractor00.000.00
00.00$0Floor Scrubber, Low Speed00.000.00
00.00$0Scrubber, 20"00.000.00
00.00$0Scrubber, Auto00.000.00
00.00$0Vacuum, Wet/Dry00.000.00
----Washer, Pressure00.000.00
TOTALS0$000.000.00
====00.000.00
======
TOTALS0$0
FRINGE CALCULATIONS======
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE$0
HOLIDAYS, SICK, AND VACATIONS$0
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$0
======
FICAX7.65%=$0
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$0
======

Click Here to Print

RSH

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
R/S/H Operations Work SheetR/S/H Operations Work SheetR/S/H Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WDR
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Material Handling Laborer011.48$0COST ELEMENTDOLLARS
Warehouse Specialist013.70$0==
Forklift Operator013.70$0Qty.Unit/ExtendedDIRECT LABOR0
Project Manager00.00$0ElementsYearlyPricePriceHEALTH & WELFARE0
00.00$0========
00.00$0Blades, Carton Cutter00.00$0.00SUB-TOTAL0
----Cutter, Carton00.00$0.00
TOTALS0$0Dispenser, Tape00.000.00HOLIDAYS, SICK & VACATIONS0
====Safety Shoes00.000.00HOL, SICK & VAC. HEALTH & WELFARE0
Indirect Labor Hours (Non-Working)0Tape Masking00.000.00==
=Back Brace00.000.00SUB-TOTAL0
Direct Labor Hours (Productive/Working)0Cart, Bushel00.000.00
=Cart, Stocking00.000.00FRINGES0
Pallet Jacks00.000.00
Direct Labor Health & Welfare00.000.00EQUIPMENT & SUPPLIES0
00.000.00-
H&WH&W00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =Cost00.000.00=
=====00.000.00G&A0.00%0
Material Handling Laborer04.48$000.000.00
Warehouse Specialist04.48$000.000.00PROFIT0.00%0
Forklift Operator04.48$000.000.00
Project Manager04.48$000.000.00==
00.00$000.000.00GRAND TOTAL0
00.00$000.000.00====
----00.000.00MO. PRICE0
TOTALS0$000.000.00===
====00.000.00
Holidays, Sick and Vacations00.000.00
00.000.00
Holidays,00.000.00
Sick,Sick, Vacations00.000.00
COST ELEMENTHolidaysVacationsDollars00.000.00
=====00.000.00
Material Handling Laborer100$0.00( (Holidays + Vacations) * 8)00.000.00
Warehouse Specialist100$0.00times Work Hours=====
Forklift Operator100$0.00divided by ( 2080 hours -TOTALS0$0.00
Project Manager100$0.00( (Holidays + Vacations) * 8) )======
100$0.00times the hourly rate
100$0.00in each category
----
TOTALS60$0
====
Holidays, Sick, and Vacations Health & Welfare
Holidays, Sick,
VacationsH&WH&W
COST ELEMENTHours XRates =Cost
=====
Material Handling Laborer04.48$0
Warehouse Specialist04.48$0
Forklift Operator04.48$0
Project Manager04.48$0
00.00$0
00.00$0
----
TOTALS0$0
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE$0
HOLIDAYS, SICK, AND VACATIONS$0
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0
------
SUBTOTAL$0
======
FICAX7.65%=$0
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$0
======

Click Here to Print

Year Totals

Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR0
DIRECT LABOR HEALTH & WELFARE0
==
TOTAL0
HOLIDAYS, SICK & VACATIONS0
HOL, SICK & VAC. HEALTH & WELFARE0
==
TOTAL0
FRINGE CALCULATIONS0
SUPPLIES & EQUIPMENT0
SUB-TOTAL0
G&A0
PROFIT0
==
GRAND TOTAL0
==

Click Here to Print

5 Yr. Totals

Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR000000
DIRECT LABOR HEALTH & WELFARE000000
=======
TOTAL000000
HOLIDAYS, SICK & VACATIONS000000
HOL, SICK & VAC. HEALTH & WELFARE000000
=======
TOTAL000000
FRINGE CALCULATIONS000000
SUPPLIES & EQUIPMENT000000
SUB-TOTAL000000
G&A000000
PROFIT000000
=======
GRAND TOTAL000000
=======
SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCB
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%
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

Shelf Stocker Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Shelf Stocker Loaded Wage Rate Work SheetShelf Stocker Loaded Wage Rate Work SheetShelf Stocker Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Store Worker I1$12.14$12.14COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$12.14
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.48
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$16.62
----ElementsYearlyPricePrice
TOTALS1$12.14======HOLIDAYS, SICK & VACATIONS$0.66
====Supplies and Equipment Costs00.00$0.00HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$0.83
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.34
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$18.79
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Store Worker I1$4.48$4.4800.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$18.79
00.000.00====
0======
----TOTALS$0.00
TOTALS1$4.48=====
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I100$0.66
(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
0(Work Hours divided by(2080-((Holidays/Sick+
----Vacations)*8)))*(Vacations *8*Hourly rate)
TOTALS10$0.66
====
Holidays, Sick, and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Store Worker I0.0$4.48$0.18
----
TOTALS0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$12.14
DIRECT HEALTH & WELFARE COSTS$4.48
HOLIDAYS, SICK & VACATIONS$0.66
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$17.45
======
FICAX7.65%=$1.34
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.34
======

Click Here to Print Click Here to Print

Shelf Clerk Loaded Wage

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Stock Clerk Loaded Wage Rate Work SheetStock Clerk Loaded Wage Rate Work SheetStock Clerk Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Stock Clerk1$17.09$17.09COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$17.09
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.48
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$21.57
----ElementsYearlyPricePrice
TOTALS1$17.09======HOLIDAYS, SICK & VACATIONS$0.92
====Supplies and Equipment Costs00.00$0.00HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker I00.000.00SUB-TOTAL$1.10
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.73
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$24.41
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Stock Clerk1$4.48$4.4800.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$24.41
00.000.00====
0======
----TOTALS$0.00
TOTALS1$4.48=====
====
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Stock Clerk100$0.92
(Work hours divided by ((2080 hours-
(Holidays/Sick+ Vacations)*8))) *
((Closed Holidays*8*Hourly rate)+
(Holidays worked*8*Hourly rate* time & half))+
0(Work Hours divided by(2080-((Holidays/Sick+
----Vacations)*8)))*(Vacations *8*Hourly rate)
TOTALS10$0.92
====
Holidays, Sick, and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Stock Clerk0.0$4.48$0.18
----
TOTALS0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$17.09
DIRECT HEALTH & WELFARE COSTS$4.48
HOLIDAYS, SICK & VACATIONS$0.92
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$22.67
======
FICAX7.65%=$1.73
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.73
======

Click Here to Print Click Here to Print

WS & FO Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Warehouse Specialist/Forklift Operator Loaded Wage Rate Work SheetWarehouse Specialist/Forklift Operator Loaded Wage Rate Work SheetWarehouse Specialist/Forklift Operator Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Forklift Operator/Warehouse Specialist1$13.70$13.70COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$13.70
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.48
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$18.18
----Qty.Unit/Extended
TOTALS1$13.70ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.74
==========HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$0.92
Direct Labor Hours (Productive/Working)1rate for Forklift Operator and/or Warehouse Specialist00.000.00
=00.000.00FRINGES$1.46
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$20.56
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Forklift Operator/Warehouse Specialist1$4.48$4.4800.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$20.56
00.000.00====
00.000.00
----======
TOTALS1$4.48TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Forklift Operator/Warehouse Specialist100$0.74
(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.74
====
Holidays, Sick, and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Forklift Operator/Warehouse Specialist0$4.48$0.18
----
TOTALS0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$13.70
DIRECT HEALTH & WELFARE COSTS$4.48
HOLIDAYS, SICK & VACATIONS$0.74
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$19.10
======
FICAX7.65%=$1.46
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.46
======

Click Here to Print Click Here to Print

Material Handler Loaded Wage

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
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$11.48$11.48COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$11.48
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.48
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$15.96
----Qty.Unit/Extended
TOTALS1$11.48ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.62
==========HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$0.80
Direct Labor Hours (Productive/Working)1rate for Material Handler00.000.00
=00.000.00FRINGES$1.28
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$18.04
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Material Handler1$4.48$4.4800.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$18.04
00.000.00====
00.000.00
----======
TOTALS1$4.48TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handler100$0.62
$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$0.62
====
Holidays, Sick, and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Material Handler0$4.48$0.18
----
TOTALS0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$11.48
DIRECT HEALTH & WELFARE COSTS$4.48
HOLIDAYS, SICK & VACATIONS$0.62
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$16.76
======
FICAX7.65%=$1.28
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.28
======

Click Here to Print Click Here to Print

Janitor Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004SOLICITATION NUMBER:HDEC08-18-R-0004
COMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCBCOMMISSARY:CAMP LEJEUNE MCB
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Janitor Loaded Wage Rate Work SheetJanitor Loaded Wage Rate Work SheetJanitor Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Janitor1$10.80$10.80COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$10.80
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.48
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$15.28
----Qty.Unit/Extended
TOTALS1$10.80ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.58
==========HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$0.76
Direct Labor Hours (Productive/Working)1rate for Janitor00.000.00
=00.000.00FRINGES$1.23
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$17.27
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Janitor1$4.48$4.4800.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$17.27
00.000.00====
00.000.00
----======
TOTALS1$4.48TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Janitor100$0.58
(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.58
====
Holidays, Sick, and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Janitor0$4.48$0.18
----
TOTALS0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$10.80
DIRECT HEALTH & WELFARE COSTS$4.48
HOLIDAYS, SICK & VACATIONS$0.58
HOLIDAYS, SICK AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$16.04
======
FICAX7.65%=$1.23
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.23
======

Click Here to Print Click Here to Print

File details come from the government source that posted it.