Attachment 3 Volume I Cost Breakout with CBA Fort Belvoir 20R0003.xls

XLS spreadsheet 287 KB Posted

Attached to
Shelf Stocking and Custodial Operations at the Fort Belvoir Commissary
Solicitation number
HDE0820R0003
Issued by

About this file

This document contains cost breakout templates and instructions for submitting proposals in response to solicitation number HDE0820R0003 for shelf stocking and custodial operations at the Fort Belvoir Commissary. Relevant details include the required cost elements of direct labor, health and welfare, holidays and vacations, fringes, supplies and equipment. Templates provide sample occupational titles and wage rates for shelf stockers and custodians and include spaces for offerors to input their own pricing details. Instructions specify printing parameters and named ranges for submitting cost breakouts in the required format.

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
HDEC0820R0003
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 and Custodial Operations
Yearly Totals, and 3 Year totals as well as Printing Instructions for these worksheets.
The worksheets for Shelf Stocking and Custodial Operations
contain "sample" occupational titles and the applicable minimum wage rates.

&C

Printing Instructions

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

Shelf Stocking

SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
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.)
Stocker (Store Worker I)0$15.32$0.00COST ELEMENTDOLLARS
Lead Stocker0$17.32$0.00==
Project Manager00.00$0.00Qty.Unit/Extended`DIRECT LABOR$0.00
00.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE$0.00
00.00$0.00========
00.00$0.00Blades, Carton Cutter00.00$0.00SUB-TOTAL$0.00
----Cutter, Carton00.00$0.00
TOTALS0$0Dispenser, Tape00.00$0.00HOLIDAYS, SICK & VACATIONS$0.00
====Safety Shoes00.00$0.00HOL, SICK & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0Tape Masking00.00$0.00==
=Back Brace00.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Cart, Bushel00.00$0.00
=Cardboard Bins00.00$0.00FRINGES$0.00
Pallet Jacks00.00$0.00
Direct Labor Health & Welfare00.00$0.00EQUIPMENT & SUPPLIES$0.00
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.00$0.00-
H&W/Benefit Fund/H&W/Benefit Fund/00.00$0.00SUB-TOTAL$0.00
COST ELEMENTHours XPension Rates =Pension Cost00.00$0.00=
=====00.00$0.00G&A0.00%$0.00
Stocker (Store Worker I)0$7.17$0.0000.00$0.00
Lead Stocker0$7.17$0.0000.00$0.00PROFIT0.00%$0.00
0$0.00$0.0000.00$0.00
0$0.00$0.0000.00$0.00==
0$0.00$0.0000.00$0.00GRAND TOTAL$0.00
0$0.00$0.0000.00$0.00====
----00.00$0.00ANNUAL CASES3,102,396
TOTALS0$000.00$0.00===
====00.00$0.00CASE PRICE0.0000
Holidays, Sick, and Vacations00.00$0.00===
00.00$0.00
Holidays/00.00$0.00
Sick/Sick/Vacations00.00$0.00
COST ELEMENTHolidaysVacationsDollars00.00$0.00
=====00.00$0.00
Stocker (Store Worker I)120$0.00( (Holidays + Vacations) * 8)00.00$0.00
Lead Stocker120$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
----
TOTALS24$0
====
Holidays and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick/
VacationsH&W/Benefit Fund/H&W/Benefit Fund/
COST ELEMENTHours XPension Rates =Pension Cost
=====
Stocker (Store Worker I)0$7.17$0.00
Lead Stocker0$7.17$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
0$0.00$0.00
----
TOTALS0$0.00
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE$0.00
HOLIDAYS, SICK, AND VACATIONS$0.00
HOLIDAYS, SICK, 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

SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
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.)
Janitor0$14.97$0.00COST ELEMENTDOLLARS
Lead Janitor0$16.97$0.00==
Project Manager0$0.00$0.00Qty.Unit/ExtendedDIRECT LABOR0.00
0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE0.00
0$0.00$0.00========
0$0.00$0.00Bowl, Cleaner00.00$0.00SUB-TOTAL0.00
----Cartridges00.00$0.00
TOTALS0$0.00Cleaner, Carpet00.000.00HOLIDAYS, SICK & VACATIONS0.00
====Cleaner, Compound00.000.00HOL, SICK & VAC. HEALTH & WELFARE0.00
Indirect Labor Hours (Non-Working)0Cleaner, Glass00.000.00==
=Cleaner, Neutral00.000.00SUB-TOTAL0.00
Direct Labor Hours (Productive/Working)0Disinfectant00.000.00
=Dust Cloths00.000.00FRINGES0.00
Dust Mop Heads00.000.00
Direct Labor Health & WelfareFloor Finish00.000.00EQUIPMENT & SUPPLIES0.00
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.Floor Sealer00.000.00-
H&W/PensionH&W/PensionFloor Stripper00.000.00SUB-TOTAL0.00
COST ELEMENTHours XRates =CostGloves00.000.00=
=====Gloves, Latex00.000.00G&A0.00%0.00
Janitor0$7.17$0.00Kintowel Wiper00.000.00
Lead Janitor0$7.17$0.00LiquidLive00.000.00PROFIT0.00%0.00
Project Manager0$0.00$0.00Masks00.000.00
0$0.00$0.00Mop Head, Wet00.000.00==
0$0.00$0.00Neutralizer00.000.00GRAND TOTAL0.00
0$0.00$0.00Pads, Aqua 27"00.000.00====
----Pads, Buffing00.000.00MONTHLY PRICE0.00
TOTALS0$0.00Pads, 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
Janitor120$0.00( (Holidays + Vacations) * 8)Sanitizer, Compound D200.000.00
Lead Janitor120$0.00times Work HoursSoap, Hand, Liquid00.000.00
Project Manager00$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
TOTALS24$0Towels, Pop-Up00.000.00
====Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays, Sick, and Vacations Health & WelfareVaccuum Belts00.000.00
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.Visors00.000.00
Holidays/Sick/Battery Charger00.000.00
VacationsH&W/Benefit Fund/H&W/Benefit Fund/Buffer, High Speed00.000.00
COST ELEMENTHours XPension Rates =Pension CostBurnisher High Speed00.000.00
=====Burnisher, 21" Propane00.000.00
Janitor0$7.17$0.00Caddy, Maid00.000.00
Lead Janitor0$7.17$0.00Carpet Extractor00.000.00
Project Manager0$0.00$0.00Floor Scrubber, Low Speed00.000.00
0$0.00$0.00Scrubber, 20"00.000.00
0$0.00$0.00Scrubber, Auto00.000.00
0$0.00$0.00Vacuum, Wet/Dry00.000.00
----Washer, Pressure00.000.00
TOTALS0$0.0000.000.00
====00.000.00
======
TOTALS$0.00
FRINGE CALCULATIONS======
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE$0.00
HOLIDAYS, SICK, AND VACATIONS$0.00
HOLIDAYS, SICK, 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

SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort Belvoir
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR0.00
DIRECT LABOR HEALTH & WELFARE0.00
==
TOTAL0.00
HOLIDAYS, SICK & VACATIONS0.00
HOL, SICK & VAC. HEALTH & WELFARE0.00
==
TOTAL0.00
FRINGE CALCULATIONS0.00
SUPPLIES & EQUIPMENT0.00
SUB-TOTAL0.00
G&A0.00
PROFIT0.00
==
GRAND TOTAL0.00
==

Click Here to Print

3 Yr. Totals

SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort Belvoir
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSTOTALS
=====
DIRECT LABOR0.000.000.000.00
DIRECT LABOR HEALTH & WELFARE0.000.000.000.00
=====
TOTAL0.000.000.000.00
HOLIDAYS, SICK & VACATIONS0.000.000.000.00
HOL, SICK & VAC. HEALTH & WELFARE0.000.000.000.00
=====
TOTAL0.000.000.000.00
FRINGE CALCULATIONS0.000.000.000.00
SUPPLIES & EQUIPMENT0.000.000.000.00
SUB-TOTAL0.000.000.000.00
G&A0.000.000.000.00
PROFIT0.000.000.000.00
=====
GRAND TOTAL0.000.000.000.00
=====
SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort Belvoir
CONTRACTOR NAME:
ESCALATION FACTORS
OPTION 1OPTION 2
COST ELEMENTDOLLARSDOLLARS
====
DIRECT LABOR0.00%0.00%
DIRECT LABOR HEALTH & WELFARE0.00%0.00%
====
TOTAL
HOLIDAYS AND VACATIONS0.00%0.00%
HOLIDAYS AND VACATIONS. HEALTH & WELFARE0.00%0.00%
====
TOTAL
FRINGE CALCULATIONS0.00%0.00%
SUPPLIES & EQUIPMENT0.00%0.00%
SUB-TOTAL
G&A0.00%0.00%
PROFIT0.00%0.00%
====
GRAND TOTAL
====

Click Here to Print

Stocker (SWI) Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Stocker (Store Worker I) Loaded Wage Rate Work SheetStocker (Store Worker I) Loaded Wage Rate Work SheetStocker (Store Worker I) Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Store Worker I1$15.32$15.32COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$15.32
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE$7.17
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$22.49
----ElementsYearlyPricePrice
TOTALS1$15.32======HOLIDAYS, SICK & VACATIONS$0.83
====Supplies and Equipment Costs00.00$0.00HOL, SICK & VAC. HEALTH & WELFARE$0.35
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker/FDS00.000.00SUB-TOTAL$1.18
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.81
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.000.00SUB-TOTAL$25.48
H&W/Benefit Fund/H&W/Benefit Fund/00.000.00=
COST ELEMENTHoursPension Rates =Pension Cost00.000.00G&A0.00%$0.00
=====00.000.00
Store Worker I1$7.17$7.1700.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$25.48
00.000.00====
======
----TOTALS$0.00
TOTALS1$7.17=====
====
Holidays, Sick and Vacations
Holidays/
Sick/Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I120$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)
TOTALS12$0.83
====
Holidays, Sick, and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick
COST ELEMENTVacationsH&W/Benefit Fund/H&W/Benefit Fund/
Hours XPension Rates =Pension Cost
=====
Store Worker I0.05$7.17$0.35
----
TOTALS0$0.35
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$15.32
DIRECT HEALTH & WELFARE COSTS$7.17
HOLIDAYS, SICK, AND VACATIONS$0.83
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0.35
------
SUBTOTAL$23.67
======
FICAX7.65%=$1.81
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.81
======

Click Here to Print

Lead Stocker Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Lead Stocker Loaded Wage Rate Work SheetLead Stocker Loaded Wage Rate Work SheetLead Stocker Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Shelf Stocking Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Lead Stocker1$17.32$17.32COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$17.32
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE$7.17
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$24.49
----ElementsYearlyPricePrice
TOTALS1$17.32======HOLIDAYS, SICK & VACATIONS$0.94
====Supplies and Equipment Costs00.00$0.00HOL, SICK & VAC. HEALTH & WELFARE$0.35
Indirect Labor Hours (Non-Working)are not included in the loaded00.00$0.00==
=rate for Store Worker/FDS00.000.00SUB-TOTAL$1.29
Direct Labor Hours (Productive/Working)100.000.00
=00.000.00FRINGES$1.97
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.000.00SUB-TOTAL$27.75
H&W/Benefit Fund/H&W/Benefit Fund/00.000.00=
COST ELEMENTHoursPension Rates =Pension Cost00.000.00G&A0.00%$0.00
=====00.000.00
Lead Stocker1$7.17$7.1700.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$27.75
00.000.00====
======
----TOTALS$0.00
TOTALS1$7.17=====
====
Holidays, Sick and Vacations
Holidays/Sick/
Vacations
COST ELEMENTHolidaysSick/VacationsDollars
=====
Lead Stocker120$0.94
(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)
TOTALS12$0.94
====
Holidays, Sick, and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick/
COST ELEMENTVacationsH&W/Benefit Fund/H&W/Benefit Fund/
Hours XPension Rates =Pension Cost
=====
Lead Stocker0.05$7.17$0.35
----
TOTALS0$0.35
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$17.32
DIRECT HEALTH & WELFARE COSTS$7.17
HOLIDAYS, SICK, AND VACATIONS$0.94
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0.35
------
SUBTOTAL$25.78
======
FICAX7.65%=$1.97
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.97
======

Click Here to Print

Janitor Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
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
R/S/H Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Janitor1$14.97$14.97COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$14.97
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE$7.17
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$22.14
----Qty.Unit/Extended
TOTALS1$14.97ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.81
==========HOL, SICK & VAC. HEALTH & WELFARE$0.35
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$1.16
Direct Labor Hours (Productive/Working)1rate for Forklift Operator00.000.00
=00.000.00FRINGES$1.78
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.000.00SUB-TOTAL$25.08
H&W/Benefit Fund/H&W/Benefit Fund/00.000.00=
COST ELEMENTHoursPension Rates =Pension Cost00.000.00G&A0.00%$0.00
=====00.000.00
Janitor1$7.17$7.1700.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$25.08
00.000.00====
00.000.00
----======
TOTALS1$7.17TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays/Sick/
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Janitor120$0.81
(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)
TOTALS12$0.81
====
Holidays, Sick, and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick/
COST ELEMENTVacationsH&W/Benefit Fund/H&W/Benefit Fund/
Hours XPension Rates =Pension Cost
=====
Janitor0.05$7.17$0.35
----
TOTALS0$0.35
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$14.97
DIRECT HEALTH & WELFARE COSTS$7.17
HOLIDAYS, SICK, AND VACATIONS$0.81
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0.35
------
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

Lead Janitor Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Lead Janitor Loaded Wage Rate Work SheetLead Janitor Loaded Wage Rate Work SheetLead Janitor Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Lead Janitor1$16.97$16.97COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$16.97
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE$7.17
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$24.14
----Qty.Unit/Extended
TOTALS1$16.97ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.92
==========HOL, SICK & VAC. HEALTH & WELFARE$0.35
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$1.27
Direct Labor Hours (Productive/Working)1rate for Custodian00.000.00
=00.000.00FRINGES$1.94
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.000.00SUB-TOTAL$27.35
H&W/Benefit Fund/H&W/Benefit Fund/00.000.00=
COST ELEMENTHoursPension Rates =Pension Cost00.000.00G&A0.00%$0.00
=====00.000.00
Lead Janitor1$7.17$7.1700.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$27.35
00.000.00====
00.000.00
---======
TOTALS1$7.17TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays
Vacations
COST ELEMENTHolidaysSick/VacationsDollars
=====
Lead Janitor120$0.92
(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)
TOTALS12$0.92
====
Holidays, Sick, and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick/
COST ELEMENTVacationsH&W/Benefit Fund/H&W/Benefit Fund/
Hours XPension Rates =Pension Cost
=====
Lead Janitor0$7.17$0.35
----
TOTALS0$0.35
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$16.97
DIRECT HEALTH & WELFARE COSTS$7.17
HOLIDAYS, SICK, AND VACATIONS$0.92
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0.35
------
SUBTOTAL$25.41
======
FICAX7.65%=$1.94
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.94
======

Click Here to Print

Order Filler Loaded Wage Rate

Attachment 3Attachment 3Attachment 3
SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003SOLICITATION NUMBER:HDEC0820R0003
COMMISSARY:Fort BelvoirCOMMISSARY:Fort BelvoirCOMMISSARY:Fort Belvoir
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Order Filler Loaded Wage Rate Work SheetOrder Filler Loaded Wage Rate Work SheetOrder Filler Loaded Wage Rate Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
WD
COST ELEMENTHours XRates =Labor Cost
=====
Order Filler1$15.09$15.09COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$15.09
CALCULATE THE LOADED HOURLY RATE. PROCEEDHEALTH & WELFARE$7.17
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$22.26
----Qty.Unit/Extended
TOTALS1$15.09ElementsYearlyPricePriceHOLIDAYS, SICK & VACATIONS$0.82
==========HOL, SICK & VAC. HEALTH & WELFARE$0.35
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs00.00$0.00==
=are not included in the loaded00.00$0.00SUB-TOTAL$1.17
Direct Labor Hours (Productive/Working)1rate for Custodian00.000.00
=00.000.00FRINGES$1.79
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.00.000.00SUB-TOTAL$25.22
H&W/Benefit Fund/H&W/Benefit Fund/00.000.00=
COST ELEMENTHoursPension Rates =Pension Cost00.000.00G&A0.00%$0.00
=====00.000.00
Order Filler1$7.17$7.1700.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$25.22
00.000.00====
00.000.00
---======
TOTALS1$7.17TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays
Vacations
COST ELEMENTHolidaysSick/VacationsDollars
=====
Order Filler120$0.82
(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)
TOTALS12$0.82
====
Holidays, Sick, and Vacations Health & Welfare
NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA.
Holidays/Sick/
COST ELEMENTVacationsH&W/Benefit Fund/H&W/Benefit Fund/
Hours XPension Rates =Pension Cost
=====
Order Filler0$7.17$0.35
----
TOTALS0$0.35
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$15.09
DIRECT HEALTH & WELFARE COSTS$7.17
HOLIDAYS, SICK, AND VACATIONS$0.82
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE$0.35
------
SUBTOTAL$23.43
======
FICAX7.65%=$1.79
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.79
======

Click Here to Print

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