About this file

Volume I Cost Break Out

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 4
Solicitation: HDEC08-15-R-0001
Commissary: Fort Buchanan, PR
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 the Custodial Area, Yearly Totals, and 5 Year
totals as well as Printing Instructions for these worksheets. The worksheet for Custodial
contains a "sample" occupational titles and the applicable minimum wage rate.

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
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 Custodial
GRAND_TOTALSFit Columns to PageNoneLandscape5 year total of Custodial
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.

Custodial

SOLICITATION NUMBER:HDEC08-15-R-0001SOLICITATION NUMBER:HDEC08-15-R-0001SOLICITATION NUMBER:HDEC08-15-R-0001
COMMISSARY:Fort BuchananCOMMISSARY:Fort BuchananCOMMISSARY:Fort Buchanan
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.)
Janitor07.79$0.00COST ELEMENTDOLLARS
Project Manager00.00$0.00==
00.00$0.00Qty.Unit/ExtendedDIRECT LABOR0.00
00.00$0.00ElementsYearlyPricePriceHEALTH & WELFARE0.00
00.00$0.00========
00.00$0.00Bowl, Cleaner00.00$0.00SUB-TOTAL0.00
----Cartridges00.00$0.00
TOTALS0$0.00Cleaner, Carpet00.000.00HOLIDAYS & VACATIONS0.00
====Cleaner, Compound00.000.00HOL & 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
Floor Sealer00.000.00-
H&WH&WFloor Stripper00.000.00SUB-TOTAL0.00
COST ELEMENTHours XRates =CostGloves00.000.00=
=====Gloves, Latex00.000.00G&A0.00%0.00
Janitor04.02$0.00Kintowel Wiper00.000.00
Project Manager04.02$0.00LiquidLive00.000.00PROFIT0.00%0.00
04.02$0.00Masks00.000.00
04.02$0.00Mop Head, Wet00.000.00==
04.02$0.00Neutralizer00.000.00GRAND TOTAL0.00
04.02$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 and VacationsPolish, Metal00.000.00
Propane00.000.00
HolidaysRain Suit00.000.00
VacationsRespirators00.000.00
COST ELEMENTHolidaysVacationsDollarsRetainer00.000.00
=====Safety Shoes00.000.00
Janitor110$0.00( (Holidays + Vacations) * 8)Sanitizer, Compound D200.000.00
Project Manager110$0.00times Work HoursSoap, Hand, Liquid00.000.00
110$0.00divided by ( 2080 hours -Sponges00.000.00
110$0.00( (Holidays + Vacations) * 8) )Spray Bottle00.000.00
110$0.00times the hourly rateSpray Bottle Trigger00.000.00
110$0.00in each categorySpray Buff00.000.00
----Toilet Tissue, 96rl00.000.00
TOTALS66$0Towels, Pop-Up00.000.00
====Trash Liners, Lg00.000.00
Trash Liners, Sm00.000.00
Holidays and Vacations Health & WelfareVaccuum Belts00.000.00
Visors00.000.00
HolidaysBattery Charger00.000.00
VacationsH&WH&WBuffer, High Speed00.000.00
COST ELEMENTHours XRates =CostBurnisher High Speed00.000.00
=====Burnisher, 21" Propane00.000.00
Janitor04.02$0.00Caddy, Maid00.000.00
Project Manager04.02$0.00Carpet Extractor00.000.00
04.02$0.00Floor Scrubber, Low Speed00.000.00
04.02$0.00Scrubber, 20"00.000.00
00.00$0.00Scrubber, Auto00.000.00
00.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 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

SOLICITATION NUMBER:HDEC08-15-R-0001
COMMISSARY:Fort Buchanan
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENTDOLLARS
==
DIRECT LABOR0.00
DIRECT LABOR HEALTH & WELFARE0.00
==
TOTAL0.00
HOLIDAYS AND VACATIONS0.00
HOLIDAYS AND VACATIONS 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

5 Yr. Totals

SOLICITATION NUMBER:HDEC08-15-R-0001
COMMISSARY:Fort Buchanan
CONTRACTOR NAME:
GRAND TOTALS
BASE YEAROPTION 1OPTION 2OPTION 3OPTION 4GRAND
COST ELEMENTDOLLARSDOLLARSDOLLARSDOLLARSDOLLARSTOTALS
=======
DIRECT LABOR0.000.000.000.000.000.00
DIRECT LABOR HEALTH & WELFARE0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
HOLIDAYS AND VACATIONS0.000.000.000.000.000.00
HOLIDAYS AND VACATIONS HEALTH & WELFARE0.000.000.000.000.000.00
=======
TOTAL0.000.000.000.000.000.00
FRINGE CALCULATIONS0.000.000.000.000.000.00
SUPPLIES & EQUIPMENT0.000.000.000.000.000.00
SUB-TOTAL0.000.000.000.000.000.00
G&A0.000.000.000.000.000.00
PROFIT0.000.000.000.000.000.00
=======
GRAND TOTAL0.000.000.000.000.000.00
=======
SOLICITATION NUMBER:HDEC08-15-R-0001
COMMISSARY:Fort Buchanan
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

Janitor Loaded Wage

SOLICITATION NUMBER:HDEC08-15-R-0001SOLICITATION NUMBER:HDEC08-15-R-0001SOLICITATION NUMBER:HDEC08-15-R-0001
COMMISSARY:Fort BuchananCOMMISSARY:Fort BuchananCOMMISSARY:Fort Buchanan
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$7.79$7.79COST ELEMENTDOLLARS
==
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TODIRECT LABOR$7.79
CALCULATE THE LOADED HOURLY RATE. PROCEEDDIRECT LABOR HEALTH & WELFARE$4.02
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES==
SUB-TOTAL$11.81
----Qty.Unit/Extended
TOTALS1$7.79ElementsYearlyPricePriceHOLIDAYS/SICK/VACATIONS$0.42
==========HOL & VAC. 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.60
Direct Labor Hours (Productive/Working)1rate for Janitor00.000.00
=00.000.00FRINGES$0.95
00.000.00
00.000.00EQUIPMENT & SUPPLIES$0.00
Direct Labor Health and Welfare00.000.00-
00.000.00SUB-TOTAL$13.36
H&WH&W00.000.00=
COST ELEMENTHoursRatesCost00.000.00G&A0.00%$0.00
=====00.000.00
Janitor1$4.02$4.0200.000.00PROFIT0.00%$0.00
00.000.00
00.000.00==
00.000.00GRAND TOTAL$13.36
00.000.00====
00.000.00
----======
TOTALS1$4.02TOTALS$0.00
=========
Holidays, Sick and Vacations
Holidays, Sick,
Sick/Vacations
COST ELEMENTHolidaysVacationsDollars
=====
Janitor110$0.42
(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)
TOTALS11$0.42
====
Holidays and Vacations Health & Welfare
Holidays/Sick/H&WH&W
COST ELEMENTVacationsRatesCost
=====
Janitor0.0$4.02$0.18
----
TOTALS0.0$0.18
====
FRINGE CALCULATIONS
COST ELEMENTDOLLARS
======
DIRECT LABOR COST$7.79
DIRECT HEALTH & WELFARE COSTS$4.02
HOLIDAYS/SICK/VACATION$0.42
HOLIDAYS AND VACATIONS HEALTH & WELFARE$0.18
------
SUBTOTAL$12.41
======
FICAX7.65%=$0.95
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.95
======

Click Here to Print

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