CBA_Cost_Breakout.xls

XLS spreadsheet 288 KB Posted Nov 27, 2012

Attached to: Perform Shelf Stocking, Receiving/Storage/Holding Area, and Custodial Operations
Solicitation number: HDEC08-12-R-0006
Issued by: Defense Commissary Agency

About this file

From the source

Amendment 3 CBA Cost Breakout

View the file

Other files

File	Type	Posted
Amendment__3_Dover_AFB.doc	DOC document	Nov 27, 2012
Amendment__2_Dover_AFB.doc	DOC document	Nov 9, 2012
Bereavement_Leave_Certification.rtf	RTF text file	Nov 9, 2012
Collective_Bargaining_Agreement.pdf	PDF	Nov 9, 2012
CBA_Cost_Breakout.xls	XLS spreadsheet	Nov 9, 2012
TDWS_DLS.xls	XLS spreadsheet	Nov 9, 2012
Amendment__1.doc	DOC document	Nov 6, 2012
Attch_3_-_Wage_Determination.rtf	RTF text file	Sep 25, 2012
Attch_2_-_Performance_Work_Statement.rtf	RTF text file	Sep 25, 2012
Attch_6_-_TDWS_DLS.xls	XLS spreadsheet	Sep 25, 2012
HDEC08-12-R-0006_Dover_AFB_Solicitation.doc	DOC document	Sep 25, 2012
Attch_5_-_Technical_Capability_and_Personnel.rtf	RTF text file	Sep 25, 2012
Attch_4_-_Cost_Breakout.xls	XLS spreadsheet	Sep 25, 2012
Attch_1_-_Information_to_Offerors.rtf	RTF text file	Sep 25, 2012
Attch_7_-_Past_Performance.rtf	RTF text file	Sep 25, 2012

Show all 15

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cost Breakout

ATTACHMENT 4

HDEC08-12-R-0006-0003

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

					Attachment 4
BASIC INSTRUCTIONS					HDEC08-12-R-0006
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 Names	Size	Titles	Orientation	Topics
SS_PAGE1	Fit Columns to Page	B:A1..B:A8	Portrait	Shelf Stocking Direct Labor, Health & Welfare Sheet
SS_PAGE2	Fit Columns to Page	B:A1..B:A8	Portrait	Shelf Stocking Holidays & Vacations Sheet
SS_PAGE3	Fit Columns to Page	B:A1..B:A8	Portrait	Shelf Stocking Fringe Calculations Sheet
SS_PAGE4	Fit Columns to Page	B:I1..B:I19	Portrait	Shelf Stocking Supplies & Equipment Sheet
SS_PAGE5	Fit Columns to Page	None	Portrait	Shelf Stocking Summary Sheet
CS_PAGE1	Fit Columns to Page	C:A1..C:A8	Portrait	Custodial Direct Labor, Health & Welfare Sheet
CS_PAGE2	Fit Columns to Page	C:A1..C:A8	Portrait	Custodial Holidays & Vacations Sheet
CS_PAGE3	Fit Columns to Page	C:A1..C:A8	Portrait	Custodial Fringe Calculations Sheet
CS_PAGE4	Fit Columns to Page	C:I1..C:I19	Portrait	Custodial Supplies & Equipment Sheet
CS_PAGE5	Fit Columns to Page	None	Portrait	Custodial Summary Sheet
WH_PAGE1	Fit Columns to Page	D:A1..D:A8	Portrait	RSH Direct Labor, Health & Welfare Sheet
WH_PAGE2	Fit Columns to Page	D:A1..D:A8	Portrait	RSH Holidays & Vacations Sheet
WH_PAGE3	Fit Columns to Page	D:A1..D:A8	Portrait	RSH Fringe Calculations Sheet
WH_PAGE4	Fit Columns to Page	D:I1..D:I19	Portrait	RSH Supplies & Equipment Sheet
WH_PAGE5	Fit Columns to Page	None	Portrait	RSH Summary Sheet
RS_PAGE1	Fit Columns to Page	E:A1..E:A8	Portrait	Residual Grocery Direct Labor, Health & Welfare Sheet
RS_PAGE2	Fit Columns to Page	E:A1..E:A8	Portrait	Residual Grocery Holidays & Vacations Sheet
RS_PAGE3	Fit Columns to Page	E:A1..E:A8	Portrait	Residual Grocery Fringe Calculations Sheet
RS_PAGE4	Fit Columns to Page	E:I1..E:I19	Portrait	Residual Grocery Supplies & Equipment Sheet
RS_PAGE5	Fit Columns to Page	None	Portrait	Residual Grocery Summary Sheet
GRANDS	Fit Columns to Page	None	Portrait	Totals of Shelf Stocking , Custodial,RSH and Residual Grocery
GRAND_TOTALS	Fit Columns to Page	None	Landscape	5 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 4						Attachment 4						Attachment 4						Attachment 4
SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003
COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB
CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:
Shelf Stocking Operations Work Sheet						Shelf Stocking Operations Work Sheet						Shelf Stocking Operations Work Sheet						Shelf Stocking Operations Work Sheet
Direct Labor						Contractor Proposed Pension						Contractor Proposed							DOLLAR TOTALS
						(The labor categories below are SAMPLES)						Shelf Stocking Supplies & Equipment							================
			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		Schedule "A"					$2.20	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=		Per Bargaining Unit Employee including Sick Leave /Vacation						a requirement of the solicitation.)
Stocker/FDS		0	$15.32	$0														COST ELEMENT				DOLLARS
		0	0.00	$0														=				=
		0	0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0.00
Project Manager		0	0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0.00
		0	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	0.00	$0		Stocker/FDS			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				$0.00
-	-	-		-					0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0					0		$0.00	Dispenser, Tape			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS				$0.00
=	=	=		=								Safety Shoes			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0.00
Indirect Labor Hours (Non-Working)												Tape Masking			0	0.00	0.00	=				=
		=										Back Brace			0	0.00	0.00	SUB-TOTAL				$0.00
Direct Labor Hours (Productive/Working)		0										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				$0.00
												Pallet Jacks			0	0.00	0.00
						=	=	=	=	=	=				0	0.00	0.00	PENSION				$0.00
						TOTALS			0		$0.00				0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
															0	0.00	0.00					-
			H&W	H&W											0	0.00	0.00	SUB-TOTAL				$0.00
COST ELEMENT		Hours	Rates	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			$0.00
Stocker/FDS		0	$3.24	$0											0	0.00	0.00
		0	$3.24	$0								=	=	=	=	=	=	PROFIT	0.00%			$0.00
		0	$3.24	$0								TOTALS			0	0.00	$0.00
Project Manager		0	$3.24	$0								=	=	=	=	=		=				=
		0	$3.24	$0														GRAND TOTAL				$0.00
		0	$3.24	$0														=		=	=	=
-	-	-		-																ANNUAL CASES		455,592
TOTALS		0		$0																=	=	=
=	=	=		=																CASE PRICE		$0.0000
																				=	=	=
Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Stocker/FDS		10	0	$0.00	(Work hours divided by ((2080 hours-
		10	0	$0.00	(Holidays/Sick+ Vacations)8)))
		0	0	$0.00	((Closed Holidays8Hourly rate)+
Project Manager		0	0	$0.00	(Holidays worked8Hourly rate* time & half))+
		0	0	$0.00	(Work Hours divided by(2080-((Holidays/Sick+
		0	0	$0.00	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		20		$0
=	=	=		=
Holidays and Vacations Health & Welfare
		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Stocker/FDS		0	$3.24	$0
		0	$3.24	$0
		0	$3.24	$0
Project Manager		0	$3.24	$0
		0	$3.24	$0
		0	$3.24	$0
-	-	-		-
TOTALS		0		$0
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT HEALTH & WELFARE COSTS					$0
HOLIDAYS/SICK/VACATION					$0
PENSION					$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0
-	-	-	-	-	-
SUBTOTAL					$0
=	=	=	=	=	=
FICA	X	7.65%		=	$0
FUTA	X	0.00%		=	$0
SUTA	X	0.00%		=	$0
Workman's Compensation	X	0.00%		=	$0
Employer's Liability	X	0.00%		=	$0
Comprehensive General Liability	X	0.00%		=	$0
Other	X	0.00%		=	$0
Other	X	0.00%		=	$0
-	-	-	-	-	-
TOTAL FRINGES					$0
=	=	=	=	=	=

Click Here to Print

RSH

	Attachment 4						Attachment 4						Attachment 4						Attachment 4
SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003
COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB
CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:
R/S/H Operations Work Sheet						R/S/H Operations Work Sheet						R/S/H Operations Work Sheet						R/S/H Operations Work Sheet
Direct Labor						Contractor Proposed Pension							Contractor Proposed					DOLLAR TOTALS
						(The labor categories below are SAMPLES)						R/S/H Supplies & Equipment						================
			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		Schedule "A"					$2.20	(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=		Per Bargaining Unit Employee including Sick Leave /Vacation						a requirement of the solicitation.)
Material Handling Laborer		0	$15.24	$0														COST ELEMENT				DOLLARS
Forklist Operator		0	$21.98	$0														=				=
		0	$0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0.00
Project Manager		0	$0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0.00
		0	$0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	$0.00	$0		Material Handling Laborer			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				$0.00
-	-	-		-		Forklist Operator			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0					0		$0.00	Dispenser, Tape			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS				$0.00
=	=	=		=								Safety Shoes			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0.00
Indirect Labor Hours (Non-Working)		0										Tape Masking			0	0.00	0.00	=				=
		=										Back Brace			0	0.00	0.00	SUB-TOTAL				$0.00
Direct Labor Hours (Productive/Working)		0										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				$0.00
												Pallet Jacks			0	0.00	0.00
															0	0.00	0.00	PENSION				$0.00
															0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
						TOTALS			0		$0.00				0	0.00	0.00					-
			H&W	H&W		=	=	=	=	=	=				0	0.00	0.00	SUB-TOTAL				$0.00
COST ELEMENT		Hours	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			$0.00
Material Handling Laborer		0	$3.24	$0											0	0.00	0.00
Forklist Operator		0	$3.24	$0											0	0.00	0.00	PROFIT	0.00%			$0.00
		0	$3.24	$0											0	0.00	0.00
Project Manager		0	$3.24	$0											0	0.00	0.00	=				=
		0	$3.24	$0											0	0.00	0.00	GRAND TOTAL				$0.00
		0	$3.24	$0											0	0.00	0.00	=		=	=	=
-	-	-		-											0	0.00	0.00			=	=	=
TOTALS		0		$0											0	0.00	0.00			MO. PRICE		$0.00
=	=	=		=											0	0.00	0.00			=	=	=
Holidays and Vacations															0	0.00	0.00
															0	0.00	0.00
				Holidays, Sick,											0	0.00	0.00
			Sick/	Vacations											0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars											0	0.00	0.00
=	=	=	=	=											0	0.00	0.00
Material Handling Laborer		10	0	$0.00	(Work hours divided by ((2080 hours-										0	0.00	0.00
Forklist Operator		10	0	$0.00	(Holidays/Sick+ Vacations)8)))							=	=	=	=		=
		10	0	$0.00	((Closed Holidays8Hourly rate)+							TOTALS			0		$0.00
Project Manager		10	0	$0.00	(Holidays worked8Hourly rate* time & half))+							=	=	=	=	=	=
		10	0	$0.00	(Work Hours divided by(2080-((Holidays/Sick+
		10	0	$0.00	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		60		$0
=	=	=		=
Holidays and Vacations Health & Welfare
		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Material Handling Laborer		0	$3.24	$0
Forklist Operator		0	$3.24	$0
		0	$3.24	$0
Project Manager		0	$3.24	$0
		0	$3.24	$0
		0	$3.24	$0
-	-	-		-
TOTALS		0		$0
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT HEALTH & WELFARE COSTS					$0
HOLIDAYS/SICK/VACATION					$0
PENSION					$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0
-	-	-	-	-	-
SUBTOTAL					$0
=	=	=	=	=	=
FICA	X	7.65%		=	$0
FUTA	X	0.00%		=	$0
SUTA	X	0.00%		=	$0
Workman's Compensation	X	0.00%		=	$0
Employer's Liability	X	0.00%		=	$0
Comprehensive General Liability	X	0.00%		=	$0
Other	X	0.00%		=	$0
Other	X	0.00%		=	$0
-	-	-	-	-	-
TOTAL FRINGES					$0
=	=	=	=	=	=

Click Here to Print

Custodial

	Attachment 4						Attachment 4						Attachment 4						Attachment 4
SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003					SOLICITATION NUMBER:	HDEC08-12-R-0006-0003
COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB					COMMISSARY:	Dover AFB
CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:
Custodial Operations Work Sheet						Custodial Operations Work Sheet						Custodial Operations Work Sheet						Custodial Operations Work Sheet
Direct Labor						Contractor Proposed Pension						Contractor Proposed						DOLLAR TOTALS
						(The labor categories below are SAMPLES)						Custodial Supplies & Equipment						================
			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		Schedule "A"					$2.20	(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=		Per Bargaining Unit Employee including Sick Leave /Vacation						a requirement of the solicitation.)
Custodian		0	$15.03	$0														COST ELEMENT				DOLLARS
		0	$0.00	$0														=				=
Project Manager		0	$0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0.00
		0	$0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0.00
		0	$0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	$0.00	$0		Custodian			0		$0.00	Bowl, Cleaner			0	0.00	$0.00	SUB-TOTAL				$0.00
-	-	-		-					0		$0.00	Cartridges			0	0.00	$0.00
TOTALS		0		$0								Cleaner, Carpet			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS				$0.00
=	=	=		=								Cleaner, Compound			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0.00
Indirect Labor Hours (Non-Working)		0										Cleaner, Glass			0	0.00	0.00	=				=
		=										Cleaner, Neutral			0	0.00	0.00	SUB-TOTAL				$0.00
Direct Labor Hours (Productive/Working)		0										Disinfectant			0	0.00	0.00
		=										Dust Cloths			0	0.00	0.00	FRINGES				$0.00
												Dust Mop Heads			0	0.00	0.00
												Floor Finish			0	0.00	0.00	PENSION				$0.00
												Floor Sealer			0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=	Floor Stripper			0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
						TOTALS			0		$0.00	Gloves			0	0.00	0.00					-
			H&W	H&W		=	=	=	=	=	=	Gloves, Latex			0	0.00	0.00	SUB-TOTAL				$0.00
COST ELEMENT		Hours	Rates =	Cost								Kintowel Wiper			0	0.00	0.00					=
=	=	=	=	=								LiquidLive			0	0.00	0.00	G&A	0.00%			$0.00
Custodian		0	$3.24	$0								Masks			0	0.00	0.00
		0	$3.24	$0								Mop Head, Wet			0	0.00	0.00	PROFIT	0.00%			$0.00
Project Manager		0	$3.24	$0								Neutralizer			0	0.00	0.00
		0	$3.24	$0								Pads, Aqua 27"			0	0.00	0.00	=				=
		0	$3.24	$0								Pads, Buffing			0	0.00	0.00	GRAND TOTAL				$0.00
		0	$3.24	$0								Pads, Doodle Bug			0	0.00	0.00	=		=	=	=
-	-	-		-								Polish, Furniture			0	0.00	0.00			MONTHLY PRICE		$0.00
TOTALS		0		$0								Polish, Metal			0	0.00	0.00			=	=	=
=	=	=		=								Propane			0	0.00	0.00
												Rain Suit			0	0.00	0.00
Holidays and Vacations												Respirators			0	0.00	0.00
				Holidays, Sick,								Retainer			0	0.00	0.00
			Sick/	Vacations								Safety Shoes			0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars								Sanitizer, Compound D2			0	0.00	0.00
=	=	=	=	=								Soap, Hand, Liquid			0	0.00	0.00
Custodian		10	0	$0.00	(Work hours divided by ((2080 hours-							Sponges			0	0.00	0.00
		10	0	$0.00	(Holidays/Sick+ Vacations)8)))							Spray Bottle			0	0.00	0.00
Project Manager		10	0	$0.00	((Closed Holidays8Hourly rate)+							Spray Bottle Trigger			0	0.00	0.00
		10	0	$0.00	(Holidays worked8Hourly rate* time & half))+							Spray Buff			0	0.00	0.00
		10	0	$0.00	(Work Hours divided by(2080-((Holidays/Sick+							Toilet Tissue, 96rl			0	0.00	0.00
		10	0	$0.00	Vacations)8)))(Vacations 8Hourly rate)							Towels, Pop-Up			0	0.00	0.00
-	-	-		-								Trash Liners, Lg			0	0.00	0.00
TOTALS		60		$0								Trash Liners, Sm			0	0.00	0.00
=	=	=		=								Vaccuum Belts			0	0.00	0.00
												Visors			0	0.00	0.00
Holidays and Vacations Health & Welfare												Battery Charger			0	0.00	0.00
												Buffer, High Speed			0	0.00	0.00
		Holidays/Sick/	H&W	H&W								Burnisher High Speed			0	0.00	0.00
COST ELEMENT		Vacations	Rates	Cost								Burnisher, 21" Propane			0	0.00	0.00
=	=	=	=	=								Caddy, Maid			0	0.00	0.00
Custodian		0	$3.24	$0								Carpet Extractor			0	0.00	0.00
		0	$3.24	$0								Floor Scrubber, Low Speed			0	0.00	0.00
Project Manager		0	$3.24	$0								Scrubber, 20"			0	0.00	0.00
		0	$3.24	$0								Scrubber, Auto			0	0.00	0.00
		0	$3.24	$0								Vacuum, Wet/Dry			0	0.00	0.00
		0	$3.24	$0								Washer, Pressure			0	0.00	0.00
-	-	-		-											0	0.00	0.00
TOTALS		0		$0											0	0.00	0.00
=	=	=		=											0	0.00	0.00
															0	0.00	0.00
FRINGE CALCULATIONS												=	=	=	=	=	=
												TOTALS			0		$0
COST ELEMENT					DOLLARS							=	=	=	=	=	=
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT HEALTH & WELFARE COST					$0
HOLIDAYS/SICK/VACATION					$0
PENSION					$0
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0
-	-	-	-	-	-
SUBTOTAL					$0
=	=	=	=	=	=
FICA	X	7.65%		=	$0
FUTA	X	0.00%		=	$0
SUTA	X	0.00%		=	$0
Workman's Compensation	X	0.00%		=	$0
Employer's Liability	X	0.00%		=	$0
Comprehensive General Liability	X	0.00%		=	$0
Other	X	0.00%		=	$0
Other	X	0.00%		=	$0
-	-	-	-	-	-
TOTAL FRINGES					$0
=	=	=	=	=	=

Click Here to Print

Year Totals

	Attachment 4
SOLICITATION NUMBER:	HDEC08-12-R-0006-0003
COMMISSARY:	Dover AFB
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENT		DOLLARS
=		=
DIRECT LABOR		$0.00
DIRECT HEALTH & WELFARE		$0.00
=		=
TOTAL		$0.00
HOLIDAYS/SICK/VACATIONS		$0.00
HOL & VAC. HEALTH & WELFARE		$0.00
=		=
TOTAL		$0.00
FRINGES CALCULATIONS		$0.00
PENSION		$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-12-R-0006-0003
COMMISSARY:	Dover AFB
CONTRACTOR NAME:
	GRAND TOTALS
	BASE YEAR	OPTION 1	OPTION 2	OPTION 3	OPTION 4	GRAND
COST ELEMENT	DOLLARS	DOLLARS	DOLLARS	DOLLARS	DOLLARS	TOTALS
=	=	=	=	=	=	=
DIRECT LABOR	0	0	0	0	0	0
DIRECT HEALTH & WELFARE	0	0	0	0	0	0
=	=	=	=	=	=	=
TOTAL	0	0	0	0	0	0
HOLIDAYS/SICK/VACATIONS	0	0	0	0	0	0
HOL & VAC. HEALTH & WELFARE	0	0	0	0	0	0
=	=	=	=	=	=	=
TOTAL	0	0	0	0	0	0
FRINGES CALCULATIONS	0	0	0	0	0	0
PENSION	0	0	0	0	0	0
SUPPLIES & EQUIPMENT	0	0	0	0	0	0
SUB-TOTAL	0	0	0	0	0	0
G&A	0	0	0	0	0	0
PROFIT	0	0	0	0	0	0
=	=	=	=	=	=	=
GRAND TOTAL	0.00	0.00	0.00	0.00	0.00	0.00
=	=	=	=	=	=	=
	Attachment 4
SOLICITATION NUMBER:	HDEC08-12-R-0006-0003
COMMISSARY:	Dover AFB
CONTRACTOR NAME:
	ESCALATION FACTORS
		OPTION 1	OPTION 2	OPTION 3	OPTION 4
COST ELEMENT		DOLLARS	DOLLARS	DOLLARS	DOLLARS
=	=	=	=	=	=
DIRECT LABOR		0.00%	0.00%	0.00%	0.00%
DIRECT HEALTH & WELFARE		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
TOTAL
HOLIDAYS & VACATIONS		0.00%	0.00%	0.00%	0.00%
HOL & VAC. HEALTH & WELFARE		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
TOTAL
FRINGES		0.00%	0.00%	0.00%	0.00%
PENSION		0.00%	0.00%	0.00%	0.00%
EQUIPMENT & SUPPLIES		0.00%	0.00%	0.00%	0.00%
SUB-TOTAL
G&A		0.00%	0.00%	0.00%	0.00%
PROFIT		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
GRAND TOTAL
=	=	=	=	=	=

Click Here to Print

StockerFDS Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

CONTRACTOR NAME:

Shelf Stocking Operations Work Sheet

Direct Labor

Contractor Proposed Pension

Contractor Proposed

DOLLAR TOTALS

(The labor categories below are SAMPLES)

Shelf Stocking Supplies & Equipment

================

CBA

COST ELEMENT

Hours X

Rates =

Labor Cost

Schedule "A"

$2.20

(The elements listed below are SAMPLES and are not considered

Per Bargaining Unit Employee including Sick Leave /Vacation

a requirement of the solicitation.)

Stocker/FDS

$15.32

COST ELEMENT

DOLLARS

Hours +

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$15.32

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Sick/Vacation

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$3.24

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Stocker/FDS

$2.20

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$18.56

are not included in the loaded

0.00

$0.00

TOTALS

$15.32

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$0.83

0.00

HOL & VAC. HEALTH & WELFARE

$0.00

Indirect Labor Hours (Non-Working)

0.00

SUB-TOTAL

$0.83

Direct Labor Hours (Productive/Working)

0.00

FRINGES

$1.65

0.00

PENSION

$2.20

TOTALS

$2.20

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$23.24

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Stocker/FDS

$3.24

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$23.24

TOTALS

$3.24

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Stocker/FDS

$0.83

(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+

$0.00

Vacations)*8)))*(Vacations *8*Hourly rate)

TOTALS

$0.83

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Stocker/FDS

$3.24

$0.00

TOTALS

$0.00

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$15.32

DIRECT HEALTH & WELFARE COSTS

$3.24

HOLIDAYS/SICK/VACATION

$0.83

PENSION

$2.20

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.00

SUBTOTAL

$21.59

FICA

7.65%

$1.65

FUTA

0.00%

$0.00

SUTA

0.00%

$0.00

Workman's Compensation

0.00%

$0.00

Employer's Liability

0.00%

$0.00

Comprehensive General Liability

0.00%

$0.00

Other

0.00%

$0.00

Other

0.00%

$0.00

TOTAL FRINGES

$1.65

Click Here to Print

FO Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

CONTRACTOR NAME:

Forklift Operator Loaded Wage Rate Work Sheet

Direct Labor

Contractor Proposed Pension

Contractor Proposed

DOLLAR TOTALS

(The labor categories below are SAMPLES)

Shelf Stocking Supplies & Equipment

================

CBA

COST ELEMENT

Hours X

Rates =

Labor Cost

Schedule "A"

$2.20

(The elements listed below are SAMPLES and are not considered

Per Bargaining Unit Employee including Sick Leave /Vacation

a requirement of the solicitation.)

Forklift Operator

$21.98

COST ELEMENT

DOLLARS

Hours +

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$21.98

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Sick/Vacation

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$3.24

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Forklift Operator

$2.20

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$25.22

are not included in the loaded

0.00

$0.00

TOTALS

$21.98

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$1.19

0.00

HOL & VAC. HEALTH & WELFARE

$0.00

Indirect Labor Hours (Non-Working)

0.00

SUB-TOTAL

$1.19

Direct Labor Hours (Productive/Working)

0.00

FRINGES

$2.19

0.00

PENSION

$2.20

TOTALS

$2.20

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$30.80

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Forklift Operator

$3.24

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$30.80

TOTALS

$3.24

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Forklift Operator

$1.19

(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)

TOTALS

$1.19

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Forklift Operator

$3.24

$0.00

TOTALS

$0.00

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$21.98

DIRECT HEALTH & WELFARE COSTS

$3.24

HOLIDAYS/SICK/VACATION

$1.19

PENSION

$2.20

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.00

SUBTOTAL

$28.61

FICA

7.65%

$2.19

FUTA

0.00%

$0.00

SUTA

0.00%

$0.00

Workman's Compensation

0.00%

$0.00

Employer's Liability

0.00%

$0.00

Comprehensive General Liability

0.00%

$0.00

Other

0.00%

$0.00

Other

0.00%

$0.00

TOTAL FRINGES

$2.19

Click Here to Print

Material Handler Loaded Wage

Attachment 4

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

CONTRACTOR NAME:

Material Handler Loaded Wage Rate Work Sheet

Direct Labor

Contractor Proposed Pension

Contractor Proposed

DOLLAR TOTALS

(The labor categories below are SAMPLES)

Shelf Stocking Supplies & Equipment

================

CBA

COST ELEMENT

Hours X

Rates =

Labor Cost

Schedule "A"

$2.20

(The elements listed below are SAMPLES and are not considered

Per Bargaining Unit Employee including Sick Leave /Vacation

a requirement of the solicitation.)

Material Handling Laborer

$15.24

COST ELEMENT

DOLLARS

Hours +

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$15.24

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Sick/Vacation

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$3.24

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Material Handling Laborer

$2.20

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$18.48

are not included in the loaded

0.00

$0.00

TOTALS

$15.24

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$0.82

0.00

HOL & VAC. HEALTH & WELFARE

$0.00

Indirect Labor Hours (Non-Working)

0.00

SUB-TOTAL

$0.82

Direct Labor Hours (Productive/Working)

0.00

FRINGES

$1.64

0.00

PENSION

$2.20

TOTALS

$2.20

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$23.14

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Material Handling Laborer

$3.24

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$23.14

TOTALS

$3.24

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Material Handling Laborer

$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)

TOTALS

$0.82

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Material Handling Laborer

$3.24

$0.00

TOTALS

$0.00

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$15.24

DIRECT HEALTH & WELFARE COSTS

$3.24

HOLIDAYS/SICK/VACATION

$0.82

PENSION

$2.20

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.00

SUBTOTAL

$21.50

FICA

7.65%

$1.64

FUTA

0.00%

$0.00

SUTA

0.00%

$0.00

Workman's Compensation

0.00%

$0.00

Employer's Liability

0.00%

$0.00

Comprehensive General Liability

0.00%

$0.00

Other

0.00%

$0.00

Other

0.00%

$0.00

TOTAL FRINGES

$1.64

Click Here to Print

Custodian Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

SOLICITATION NUMBER:

HDEC08-12-R-0006-0003

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

COMMISSARY:

Dover AFB

CONTRACTOR NAME:

Custodian Loaded Wage Rate Work Sheet

Direct Labor

Contractor Proposed Pension

Contractor Proposed

DOLLAR TOTALS

(The labor categories below are SAMPLES)

Shelf Stocking Supplies & Equipment

================

CBA

COST ELEMENT

Hours X

Rates =

Labor Cost

Schedule "A"

$2.20

(The elements listed below are SAMPLES and are not considered

Per Bargaining Unit Employee including Sick Leave /Vacation

a requirement of the solicitation.)

Custodian

$15.03

COST ELEMENT

DOLLARS

Hours +

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$15.03

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Sick/Vacation

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$3.24

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Custodian

$2.20

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$18.27

are not included in the loaded

0.00

$0.00

TOTALS

$15.03

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$0.81

0.00

HOL & VAC. HEALTH & WELFARE

$0.00

Indirect Labor Hours (Non-Working)

0.00

SUB-TOTAL

$0.81

Direct Labor Hours (Productive/Working)

0.00

FRINGES

$1.63

0.00

PENSION

$2.20

TOTALS

$2.20

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$22.91

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Custodian

$3.24

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$22.91

TOTALS

$3.24

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Custodian

$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)

TOTALS

$0.81

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Custodian

$3.24

$0.00

TOTALS

$0.00

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$15.03

DIRECT HEALTH & WELFARE COSTS

$3.24

HOLIDAYS/SICK/VACATION

$0.81

PENSION

$2.20

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.00

SUBTOTAL

$21.28

FICA

7.65%

$1.63

FUTA

0.00%

$0.00

SUTA

0.00%

$0.00

Workman's Compensation

0.00%

$0.00

Employer's Liability

0.00%

$0.00

Comprehensive General Liability

0.00%

$0.00

Other

0.00%

$0.00

Other

0.00%

$0.00

TOTAL FRINGES

$1.63

Click Here to Print

File details come from the government source that posted it. Updated Nov 14, 2017.