Attachment_4_cost_breakout.xls

XLS spreadsheet 387 KB Posted

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

About this file

Cost Breakout

View the file

Other files

File Type Posted
Attachment_7_(Amendment_0002).xls XLS spreadsheet
Fort_Leavenworth_PWS_dated_4_11_13(Amendment_0002).doc DOC document
Amendment_0002.doc DOC document
Solicitation_Amendment_0001.pdf PDF
Corrected_Solicitation.pdf PDF
Corrected_Attachment_2_PWS.pdf PDF
Attachment_2__PWS.doc DOC document
Attachment_6__DLS_ _TDWS.xls XLS spreadsheet
solicitation.doc DOC document
Attachment_7__PPI.doc DOC document
Attachment_5__Technical.doc DOC document
Attachment_3_WD.doc DOC document
Attachment_1__DD1707.doc DOC document
Show all 13

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cost Breakout

Attachment 4
HDEC08-13-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.

&C

Printing Instructions

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

&RATTACHMENT 4

Shelf Stocking

ATTACHMENT 4ATTACHMENT 4ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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 I0$13.27$0.00COST ELEMENTDOLLARS
Project Manager0$0.00$0.00==
0$0.00$0.00Qty.Unit/Extended`DIRECT LABOR$0.00
0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE$0.00
0$0.00$0.00========
0$0.00$0.00Blades, Carton Cutter0$0.00$0.00SUB-TOTAL$0.00
----Cutter, Carton0$0.00$0.00
TOTALS0$0Dispenser, Tape0$0.00$0.00HOLIDAYS & VACATIONS$0.00
====Safety Shoes0$0.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0Tape Masking0$0.00$0.00==
=Back Brace0$0.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Cart, Bushel0$0.00$0.00
=Cart, Stocking0$0.00$0.00FRINGES$0.00
Pallet Jacks0$0.00$0.00
Direct Labor Health & Welfare0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
0$0.00$0.00-
H&WH&W0$0.00$0.00SUB-TOTAL$0.00
COST ELEMENTHours XRates =Cost0$0.00$0.00=
=====0$0.00$0.00G&A0.00%$0.00
Store Worker I0$3.71$0.000$0.00$0.00
Project Manager0$3.71$0.000$0.00$0.00PROFIT0.00%$0.00
0$0.00$0.000$0.00$0.00
0$0.00$0.000$0.00$0.00==
0$0.00$0.000$0.00$0.00GRAND TOTAL$0.00
0$0.00$0.000$0.00$0.00====
----0$0.00$0.00ANNUAL CASES569,976
TOTALS0$00$0.00$0.00===
====0$0.00$0.00CASE PRICE$0.00
Holidays and Vacations0$0.00$0.00===
0$0.00$0.00
Holidays0$0.00$0.00
Vacations0$0.00$0.00
COST ELEMENTHolidaysVacationsDollars0$0.00$0.00
=====0$0.00$0.00
Store Worker I100$0.00( (Holidays + Vacations) * 8)0$0.00$0.00
Project Manager100$0.00times Work Hours======
100$0.00divided by ( 2080 hours -TOTALS0$0.00
100$0.00( (Holidays + Vacations) * 8) )======
100$0.00times the hourly rate
100$0.00in each category
----
TOTALS60$0
====
Holidays and Vacations Health & Welfare
Holidays
VacationsH&WH&W
COST ELEMENTHours XRates =Cost
=====
Store Worker I0$3.71$0.00
Project Manager0$3.71$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 AND VACATIONS$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 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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 Handler0$16.19$0.00COST ELEMENTDOLLARS
Forklift Operator0$19.24$0.00==
Warehouse Specialist0$19.24$0.00Qty.Unit/ExtendedDIRECT LABOR$0.00
Project Manager0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE$0.00
0$0.00$0.00========
0$0.00$0.00Blades, Carton Cutter0$0.00$0.00SUB-TOTAL$0.00
----Cutter, Carton0$0.00$0.00
TOTALS0$0.00Dispenser, Tape0$0.00$0.00HOLIDAYS & VACATIONS$0.00
====Safety Shoes0$0.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0Tape Masking0$0.00$0.00==
=Back Brace0$0.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Cart, Bushel0$0.00$0.00
=Cart, Stocking0$0.00$0.00FRINGES$0.00
Pallet Jacks0$0.00$0.00
Direct Labor Health & Welfare0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
0$0.00$0.00-
H&WH&W0$0.00$0.00SUB-TOTAL$0.00
COST ELEMENTHours XRates =Cost0$0.00$0.00=
=====0$0.00$0.00G&A0.00%$0.00
Material Handler0$3.71$0.000$0.00$0.00
Forklift Operator0$3.71$0.000$0.00$0.00PROFIT0.00%$0.00
Warehouse Specialist0$3.71$0.000$0.00$0.00
Project Manager0$3.71$0.000$0.00$0.00==
0$0.00$0.000$0.00$0.00GRAND TOTAL$0.00
0$0.00$0.000$0.00$0.00====
----0$0.00$0.00MO. PRICE$0.00
TOTALS0$0.000$0.00$0.00===
====0$0.00$0.00
Holidays and Vacations0$0.00$0.00
0$0.00$0.00
Holidays0$0.00$0.00
Vacations0$0.00$0.00
COST ELEMENTHolidaysVacationsDollars0$0.00$0.00
=====0$0.00$0.00
Material Handler100$0.00( (Holidays + Vacations) * 8)0$0.00$0.00
Forklift Operator100$0.00times Work Hours=====
Warehouse Specialist100$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 and Vacations Health & Welfare
Holidays
VacationsH&WH&W
COST ELEMENTHours XRates =Cost
=====
Material Handler0$3.71$0.00
Forklift Operator0$3.71$0.00
Warehouse Specialist0$3.71$0.00
Project Manager0$3.71$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 AND VACATIONS$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 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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.)
Janitor (Excluding RSHA, Meat Custodial & Outside Areas)0$12.93$0.00COST ELEMENTDOLLARS
Janitor, Meat Custodial Operations0$12.93$0.00==
Janitor, RSHA Custodial Operations (Including Outside Areas)0$12.93$0.00Qty.Unit/ExtendedDIRECT LABOR$0.00
Project Manager0$0.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE$0.00
0$0.00$0.00========
0$0.00$0.00Bowl, Cleaner0$0.00$0.00SUB-TOTAL$0.00
----Cartridges0$0.00$0.00
TOTALS0$0.00Cleaner, Carpet0$0.00$0.00HOLIDAYS & VACATIONS$0.00
====Cleaner, Compound0$0.00$0.00HOL & VAC. HEALTH & WELFARE$0.00
Indirect Labor Hours (Non-Working)0Cleaner, Glass0$0.00$0.00==
=Cleaner, Neutral0$0.00$0.00SUB-TOTAL$0.00
Direct Labor Hours (Productive/Working)0Disinfectant0$0.00$0.00
=Dust Cloths0$0.00$0.00FRINGES$0.00
Dust Mop Heads0$0.00$0.00
Direct Labor Health & WelfareFloor Finish0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
Floor Sealer0$0.00$0.00-
H&WH&WFloor Stripper0$0.00$0.00SUB-TOTAL$0.00
COST ELEMENTHours XRates =CostGloves0$0.00$0.00=
=====Gloves, Latex0$0.00$0.00G&A0.00%$0.00
Janitor (Excluding RSHA, Meat Custodial & Outside Areas)0$3.71$0.00Kintowel Wiper0$0.00$0.00
Janitor, Meat Custodial Operations0$3.71$0.00LiquidLive0$0.00$0.00PROFIT0.00%$0.00
Janitor, RSHA Custodial Operations (Including Outside Areas)0$3.71$0.00Masks0$0.00$0.00
Project Manager0$3.71$0.00Mop Head, Wet0$0.00$0.00==
0$0.00$0.00Neutralizer0$0.00$0.00GRAND TOTAL$0.00
0$0.00$0.00Pads, Aqua 27"0$0.00$0.00====
----Pads, Buffing0$0.00$0.00MONTHLY PRICE$0.00
TOTALS0$0.00Pads, Doodle Bug0$0.00$0.00===
====Polish, Furniture0$0.00$0.00
Holidays and VacationsPolish, Metal0$0.00$0.00
Propane0$0.00$0.00
HolidaysRain Suit0$0.00$0.00
VacationsRespirators0$0.00$0.00
COST ELEMENTHolidaysVacationsDollarsRetainer0$0.00$0.00
=====Safety Shoes0$0.00$0.00
Janitor (Excluding RSHA, Meat Custodial & Outside Areas)100$0.00( (Holidays + Vacations) * 8)Sanitizer, Compound D20$0.00$0.00
Janitor, Meat Custodial Operations100$0.00times Work HoursSoap, Hand, Liquid0$0.00$0.00
Janitor, RSHA Custodial Operations (Including Outside Areas)100$0.00divided by ( 2080 hours -Sponges0$0.00$0.00
Project Manager100$0.00( (Holidays + Vacations) * 8) )Spray Bottle0$0.00$0.00
100$0.00times the hourly rateSpray Bottle Trigger0$0.00$0.00
100$0.00in each categorySpray Buff0$0.00$0.00
----Toilet Tissue, 96rl0$0.00$0.00
TOTALS60$0Towels, Pop-Up0$0.00$0.00
====Trash Liners, Lg0$0.00$0.00
Trash Liners, Sm0$0.00$0.00
Holidays and Vacations Health & WelfareVaccuum Belts0$0.00$0.00
Visors0$0.00$0.00
HolidaysBattery Charger0$0.00$0.00
VacationsH&WH&WBuffer, High Speed0$0.00$0.00
COST ELEMENTHours XRates =CostBurnisher High Speed0$0.00$0.00
=====Burnisher, 21" Propane0$0.00$0.00
Janitor (Excluding RSHA, Meat Custodial & Outside Areas)0$3.71$0.00Caddy, Maid0$0.00$0.00
Janitor, Meat Custodial Operations0$3.71$0.00Carpet Extractor0$0.00$0.00
Janitor, RSHA Custodial Operations (Including Outside Areas)0$3.71$0.00Floor Scrubber, Low Speed0$0.00$0.00
Project Manager0$3.71$0.00Scrubber, 20"0$0.00$0.00
0$0.00$0.00Scrubber, Auto0$0.00$0.00
0$0.00$0.00Vacuum, Wet/Dry0$0.00$0.00
----Washer, Pressure0$0.00$0.00
TOTALS0$0.000$0.00$0.00
====0$0.00$0.00
======
TOTALS$0.00
FRINGE CALCULATIONS======
COST ELEMENTDOLLARS
======
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE$0.00
HOLIDAYS AND VACATIONS$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-13-R-0007
COMMISSARY:Fort Leavenworth
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR$0.00
DIRECT LABOR HEALTH & WELFARE$0.00
==
TOTAL$0.00
HOLIDAYS AND VACATIONS$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.00
==
TOTAL$0.00
FRINGE CALCULATIONS$0.00
SUPPLIES & EQUIPMENT$0.00
SUB-TOTAL$0.00
G&A$0.00
PROFIT$0.00
==
GRAND TOTAL$0.00
==

Click Here to Print

5 Yr. Totals

ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort Leavenworth
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR$0.00$0.00$0.00$0.00$0.00$0.00
DIRECT LABOR HEALTH & WELFARE$0.00$0.00$0.00$0.00$0.00$0.00
=======
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
HOLIDAYS AND VACATIONS$0.00$0.00$0.00$0.00$0.00$0.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.00$0.00$0.00$0.00$0.00$0.00
=======
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
FRINGE CALCULATIONS$0.00$0.00$0.00$0.00$0.00$0.00
SUPPLIES & EQUIPMENT$0.00$0.00$0.00$0.00$0.00$0.00
SUB-TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
G&A$0.00$0.00$0.00$0.00$0.00$0.00
PROFIT$0.00$0.00$0.00$0.00$0.00$0.00
=======
GRAND TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
=======
ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort Leavenworth
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 4ATTACHMENT 4ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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$13.27$13.27COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$13.27
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$3.71
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
Qty.Unit/ExtendedSUB-TOTAL$16.98
----ElementsYearlyPricePrice
TOTALS1$13.27======HOLIDAYS/SICK/VACATIONS$0.72
====Supplies and Equipment Costs0$0.00$0.00HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)are not included in the loaded0$0.00$0.00==
=rate for Store Worker I0$0.00$0.00SUB-TOTAL$0.86
Direct Labor Hours (Productive/Working)10$0.00$0.00
=0$0.00$0.00FRINGES$1.37
0$0.00$0.00
0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare0$0.00$0.00-
0$0.00$0.00SUB-TOTAL$19.21
H&WH&W0$0.00$0.00=
COST ELEMENTHoursRatesCost0$0.00$0.00G&A0.00%$0.00
=====0$0.00$0.00
Store Worker I1$3.71$3.710$0.00$0.00PROFIT0.00%$0.00
0$0.00$0.00
0$0.00$0.00==
0$0.00$0.00GRAND TOTAL$19.21
0$0.00$0.00====
0======
----TOTALS$0.00
TOTALS1$3.71=====
====
Holidays, and Vacations
Holidays,
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Store Worker I100$0.72
(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.72
====
Holidays and Vacations Health & Welfare
Holidays/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Store Worker I0.0$3.71$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$13.27
DIRECT HEALTH & WELFARE COSTS$3.71
HOLIDAYS/SICK/VACATION$0.72
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$17.84
======
FICAX7.65%=$1.37
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.37
======

Click Here to Print

WS & FO Loaded Wage Rate

ATTACHMENT 4ATTACHMENT 4ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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$19.24$19.24COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$19.24
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$3.71
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$22.95
----Qty.Unit/Extended
TOTALS1$19.24ElementsYearlyPricePriceHOLIDAYS/SICK/VACATIONS$1.04
==========HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs0$0.00$0.00==
=are not included in the loaded0$0.00$0.00SUB-TOTAL$1.19
Direct Labor Hours (Productive/Working)1rate for Forklift Operator and/or Warehouse Specialist0$0.00$0.00
=0$0.00$0.00FRINGES$1.85
0$0.00$0.00
0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare0$0.00$0.00-
0$0.00$0.00SUB-TOTAL$25.98
H&WH&W0$0.00$0.00=
COST ELEMENTHoursRatesCost0$0.00$0.00G&A0.00%$0.00
=====0$0.00$0.00
Forklift Operator/Warehouse Specialist1$3.71$3.710$0.00$0.00PROFIT0.00%$0.00
0$0.00$0.00
0$0.00$0.00==
0$0.00$0.00GRAND TOTAL$25.98
0$0.00$0.00====
0$0.00$0.00
----======
TOTALS1$3.71TOTALS$0.00
=========
Holidays, and Vacations
Holidays
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Forklift Operator/Warehouse Specialist100$1.04
(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$1.04
====
Holidays and Vacations Health & Welfare
Holidays/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Forklift Operator/Warehouse Specialist0$3.71$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$19.24
DIRECT HEALTH & WELFARE COSTS$3.71
HOLIDAYS/SICK/VACATION$1.04
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$24.14
======
FICAX7.65%=$1.85
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.85
======

Click Here to Print

Material Handler Loaded Wage

ATTACHMENT 4ATTACHMENT 4ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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$16.19$16.19COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$16.19
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$3.71
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$19.90
----Qty.Unit/Extended
TOTALS1$16.19ElementsYearlyPricePriceHOLIDAYS/SICK/VACATIONS$0.87
==========HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs0$0.00$0.00==
=are not included in the loaded0$0.00$0.00SUB-TOTAL$1.02
Direct Labor Hours (Productive/Working)1rate for Material Handler0$0.00$0.00
=0$0.00$0.00FRINGES$1.60
0$0.00$0.00
0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare0$0.00$0.00-
0$0.00$0.00SUB-TOTAL$22.52
H&WH&W0$0.00$0.00=
COST ELEMENTHoursRatesCost0$0.00$0.00G&A0.00%$0.00
=====0$0.00$0.00
Material Handler1$3.71$3.710$0.00$0.00PROFIT0.00%$0.00
0$0.00$0.00
0$0.00$0.00==
0$0.00$0.00GRAND TOTAL$22.52
0$0.00$0.00====
0$0.00$0.00
----======
TOTALS1$3.71TOTALS$0.00
=========
Holidays, and Vacations
Holidays,
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Material Handler100$0.87
$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.87
====
Holidays and Vacations Health & Welfare
Holidays/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Material Handler0$3.71$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$16.19
DIRECT HEALTH & WELFARE COSTS$3.71
HOLIDAYS/SICK/VACATION$0.87
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$20.92
======
FICAX7.65%=$1.60
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.60
======

Click Here to Print

Janitor Loaded Wage Rate

ATTACHMENT 4ATTACHMENT 4ATTACHMENT 4
SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007SOLICITATION NUMBER:HDEC08-13-R-0007
COMMISSARY:Fort LeavenworthCOMMISSARY:Fort LeavenworthCOMMISSARY:Fort Leavenworth
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$12.93$12.93COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$12.93
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$3.71
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$16.64
----Qty.Unit/Extended
TOTALS1$12.93ElementsYearlyPricePriceHOLIDAYS/SICK/VACATIONS$0.70
==========HOL & VAC. HEALTH & WELFARE$0.15
Indirect Labor Hours (Non-Working)Supplies and Equipment Costs0$0.00$0.00==
=are not included in the loaded0$0.00$0.00SUB-TOTAL$0.85
Direct Labor Hours (Productive/Working)1rate for Janitor0$0.00$0.00
=0$0.00$0.00FRINGES$1.34
0$0.00$0.00
0$0.00$0.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare0$0.00$0.00-
0$0.00$0.00SUB-TOTAL$18.82
H&WH&W0$0.00$0.00=
COST ELEMENTHoursRatesCost0$0.00$0.00G&A0.00%$0.00
=====0$0.00$0.00
Janitor1$3.71$3.710$0.00$0.00PROFIT0.00%$0.00
0$0.00$0.00
0$0.00$0.00==
0$0.00$0.00GRAND TOTAL$18.82
0$0.00$0.00====
0$0.00$0.00
----======
TOTALS1$3.71TOTALS$0.00
=========
Holidays, and Vacations
Holidays,
Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Janitor100$0.70
(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.70
====
Holidays and Vacations Health & Welfare
Holidays/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Janitor0$3.71$0.15
----
TOTALS0$0.15
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$12.93
DIRECT HEALTH & WELFARE COSTS$3.71
HOLIDAYS/SICK/VACATION$0.70
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.15
------
SUBTOTAL$17.49
======
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

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