Revised Worksheet in Cost Breakout.xls

XLS spreadsheet 200 KB Posted

Attached to
Shelf Stocking, Receiving/Storage/Holding Area and Custodial Operations
Solicitation number
HDEC08-10-R-0010
Issued by

About this file

See Attached

View the file

Other files

File Type Posted
Edwards PWS MAR172010.doc DOC document
Edwards CBA 31 Mar 10.pdf PDF
A001.doc DOC document
Attachment 2 Performance Work Statement dated 01.10.10.doc DOC document
Attachment 7 Past Performance Information.doc DOC document
Attachment 4 CBA Cost Breakout at time and a half for holidays1.xls XLS spreadsheet
Attachment 5 Techical Capability and Personnel.doc DOC document
Attachment 3 Union Agreement with DOL Coversheet.pdf PDF
Attachment 6 TDWS DLS.xls XLS spreadsheet
Edwards Solicitation HDEC08-10-R-0010.doc DOC document
Attachment 1 DD Form 1707.doc DOC document
Show all 11

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-10-R-0010
VOLUME I
COST BREAKOUT
Offerors are required to submit their cost breakout in accordance with provision
52.215-4509, "Proposal Submission," paragraph (b)(4), located in Section L of the
solicitation.
The tabs below contain worksheets for Shelf Stocking, Custodial, Receiving/Storage Holding
Area, Yearly Totals, and 5 Year totals as well as Printing Instructions for these worksheets.
The worksheets for Shelf Stocking, Custodial, and Receiving/Storage/Holding Area
contain "sample" occupational titles and the applicable minimum wage rates.

Printing Instructions

BASIC 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

SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CA
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================
CBA
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not considered
=====a requirement of the solicitation.)
Stocking015.93$0COST ELEMENTDOLLARS
Pull Crew015.93$0==
Project Manager00.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, VACATIONS AND SICK LEAVE0
====Safety Shoes00.000.00HOL & VAC. HEALTH & WELFARE AND RETIREMENT0
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
H&W &H&W &00.000.00-
RetirementRetirement00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =Cost00.000.00=
=====00.000.00G&A0.00%0
Stocking04.09$000.000.00
Pull Crew04.09$000.000.00PROFIT0.00%0
Project Manager04.09$000.000.00
04.09$000.000.00==
04.09$000.000.00GRAND TOTAL0
04.09$000.000.00====
----00.000.00ANNUAL CASES288,396
TOTALS0$000.000.00===
====00.000.00CASE PRICE0.0000
Holidays and Vacations00.000.00===
00.000.00
Holidays, Sick Leave &00.000.00
HolidaysSick Leave &Vacations00.000.00
COST ELEMENTVacationsDollars00.000.00
=====00.000.00
Stocking110$0.00(Holidays + Sick/Vacation)*800.000.00
Pull Crew110$0.00times Work Hours divided by=====
Project Manager110$0.00(2080 hours-((Holidays +Sick/0$0.00
00$0.00Vacations)*8 times hourly rate=====
00$0.00for each labor category
00$0.00(# of holidays derived from
----3 holidays store is closed +
TOTALS33$08 holidays store is open
====times 1.5)
Holidays and Vacations Health & Welfare
Holidays, Sick LeaveH&W &H&W &
& VacationsRetirementRetirement
COST ELEMENTHours XRates =Cost
=====
Stocking04.09$0
Pull Crew04.09$0
Project Manager04.09$0
04.09$0
04.09$0
04.09$0
----
TOTALS0$0
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE AND RETIREMENT COST$0
HOLIDAYS AND VACATIONS AND SICK LEAVE$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND SICK LEAVE$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

SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CA
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================
CBA
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Warehouse015.93$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 & VACATIONS AND SICK LEAVE0
====Safety Shoes00.000.00HOL & VAC. HEALTH & WELFARE AND RETIREMENT0
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
H&W &H&W &00.000.00-
RetirementRetirement00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =Cost00.000.00=
=====00.000.00G&A0.00%0
Warehouse04.09$000.000.00
Project Manager04.09$000.000.00PROFIT0.00%0
004.09$000.000.00
04.09$000.000.00==
04.09$000.000.00GRAND TOTAL0
04.09$000.000.00====
----00.000.000
TOTALS0$000.000.00===
====00.000.00
Holidays and Vacations00.000.00===
00.000.00MO. PRICE0
Holidays, Sick Leave &00.000.00===
HolidaysSick LeaveVacations00.000.00
COST ELEMENT& VacationsDollars00.000.00
=====00.000.00
Warehouse110$0.00(Holidays + Sick/Vacation)*800.000.00
Project Manager110$0.00times Work Hours divided by====
0110$0.00(2080 hours-((Holidays +Sick/0$0.00
00$0.00Vacations)*8 times hourly rate=====
00$0.00for each labor category
00$0.00(# of holidays derived from
----3 holidays store is closed +
TOTALS33$08 holidays store is open
====times 1.5)
Holidays and Vacations Health & Welfare
Holidays, Sick LeaveH&W &H&W &
& VacationsRetirementRetirement
COST ELEMENTHours XRates =Cost
=====
Warehouse04.09$0
Project Manager04.09$0
004.09$0
04.09$0
04.09$0
04.09$0
----
TOTALS0$0
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR$0
DIRECT LABOR HEALTH & WELFARE AND RETIREMENT COST$0
HOLIDAYS AND VACATIONS AND SICK LEAVE$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND SICK LEAVE$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

SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CACOMMISSARY:Edwards AFB, CA
CONTRACTOR NAME:CONTRACTOR NAME:CONTRACTOR NAME:
Custodial Operations Work SheetCustodial Operations Work SheetCustodial Operations Work Sheet
Direct LaborContractor ProposedDOLLAR TOTALS
Custodial Supplies & Equipment================
CBA
COST ELEMENTHours XRates =Labor Cost(The elements listed below are SAMPLES and are not to be considered
=====a requirement of the solicitation.)
Janitor (Night)014.00$0COST ELEMENTDOLLARS
Janitor (Day)014.00$0==
Janitor (Meat Room)014.00$0Qty.Unit/ExtendedDIRECT LABOR0
Janitor, RSHA Custodial Operations014.00$0ElementsYearlyPricePriceHEALTH & WELFARE0
Janitor, RSHA, for Outside Areas014.00$0========
Project Manager00.00$0Bowl, Cleaner00.00$0.00SUB-TOTAL0
----Cartridges00.00$0.00
TOTALS0$0Cleaner, Carpet00.000.00HOLIDAYS & VACATIONS AND SICK LEAVE0
====Cleaner, Compound00.000.00HOL & VAC. HEALTH & WELFARE AND RETIREMENT0
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
H&W &H&W &Floor Sealer00.000.00-
RetirementRetirementFloor Stripper00.000.00SUB-TOTAL0
COST ELEMENTHours XRates =CostGloves00.000.00=
=====Gloves, Latex00.000.00G&A0.00%0
Janitor (Night)04.09$0Kintowel Wiper00.000.00
Janitor (Day)04.09$0LiquidLive00.000.00PROFIT0.00%0
Janitor (Meat Room)04.09$0Masks00.000.00
Janitor, RSHA Custodial Operations04.09$0Mop Head, Wet00.000.00==
Janitor, RSHA, for Outside Areas04.09$0Neutralizer00.000.00GRAND TOTAL0
Project Manager04.09$0Pads, Aqua 27"00.000.00====
----Pads, Buffing00.000.00MONTHLY PRICE0
TOTALS0$0Pads, Doodle Bug00.000.00===
====Polish, Furniture00.000.00
Holidays and VacationsPolish, Metal00.000.00
Propane00.000.00===
Holidays, Sick Leave &Rain Suit00.000.00
HolidaysSick LeaveVacationsRespirators00.000.00
COST ELEMENT& VacationsDollarsRetainer00.000.00
=====Safety Shoes00.000.00
Janitor (Night)110$0.00(Holidays + Sick/Vacation)*800.000.00
Janitor (Day)110$0.00times Work Hours divided by00.000.00
Janitor (Meat Room)110$0.00(2080 hours-((Holidays +Sick/00.000.00
Janitor, RSHA Custodial Operations110$0.00Vacations)*8 times hourly rate00.000.00
Janitor, RSHA, for Outside Areas110$0.00for each labor category00.000.00
Project Manager00$0.00(# of holidays derived from00.000.00
----3 holidays store is closed +00.000.00
TOTALS55$08 holidays store is openTowels, Pop-Up00.000.00
====times 1.5)Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays and Vacations Health & WelfareVaccuum Belts00.000.00
Visors00.000.00
Holidays, Sick LeaveH&W &H&W &Battery Charger00.000.00
& VacationsRetirementRetirementBuffer, High Speed00.000.00
COST ELEMENTHours XRates =CostBurnisher High Speed00.000.00
=====Burnisher, 21" Propane00.000.00
Janitor (Night)04.09$0Caddy, Maid00.000.00
Janitor (Day)04.09$0Carpet Extractor00.000.00
Janitor (Meat Room)04.09$0Floor Scrubber, Low Speed00.000.00
Janitor, RSHA Custodial Operations04.09$0Scrubber, 20"00.000.00
Janitor, RSHA, for Outside Areas04.09$0Scrubber, Auto00.000.00
Project Manager04.09$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 AND RETIREMENT COST$0
HOLIDAYS AND VACATIONS AND SICK LEAVE$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND SICK LEAVE$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

SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CA
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR0
DIRECT LABOR HEALTH & WELFARE0
==
TOTAL0
HOLIDAYS AND VACATIONS AND SICK LEAVE0
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND RETIREMENT0
==
TOTAL0
FRINGE CALCULATIONS0
SUPPLIES & EQUIPMENT0
SUB-TOTAL0
G&A0
PROFIT0
==
GRAND TOTAL0
==

Click Here to Print

5 Yr. Totals

SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CA
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR000000
DIRECT LABOR HEALTH & WELFARE000000
=======
TOTAL000000
HOLIDAYS AND VACATIONS AND SICK LEAVE000000
HOLIDAYS AND VACATIONS HEALTH & WELFARE AND RETIREMENT000000
=======
TOTAL000000
FRINGE CALCULATIONS000000
SUPPLIES & EQUIPMENT000000
SUB-TOTAL000000
G&A000000
PROFIT000000
=======
GRAND TOTAL000000
=======
SOLICITATION NUMBER:HDEC08-10-R-0010
COMMISSARY:Edwards AFB, CA
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 VACATIONS AND SICK LEAVE0.00%0.00%0.00%0.00%
HOLIDAYS AND VACATIONS. HEALTH & WELFARE & RETIREMENT0.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

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