Attachment_4,_Cost_Breakout.xlsx

XLSX spreadsheet 157 KB Posted Sep 12, 2017

Attached to: Shelf stocking, receiving/storage/holding area (RSHA), and custodial operation for the Holloman Air Force Base (AFB) Commissary-HDEC08-17-R-0014
Solicitation number: HDEC08-17-R-0014
Issued by: Defense Commissary Agency

About this file

From the source

Attachment 4, Cost Breakout

View the file

Other files

File	Type	Posted
Attachment_2,_PWS_dated_08.03.2017.docx	DOCX document	Sep 12, 2017
Attachment_7,_Past_Performance.doc	DOC document	Sep 12, 2017
Attachment_3,_CBA-Oct_1,_2016_to_Jul_31,_2022.pdf	PDF	Sep 12, 2017
Attachment_5,_Technical_Capability_and_Personnel.docx	DOCX document	Sep 12, 2017
Attachment_1,_DD_Form_1707_Instructions_to_Offerors.doc	DOC document	Sep 12, 2017
HDEC08-17-R-0014.doc	DOC document	Sep 12, 2017
Attachment_6,_TDWS-DLS.xls	XLS spreadsheet	Sep 12, 2017

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-17-R-0014

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					Attachment 4
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
GRANDS	Fit Columns to Page	None	Portrait	Totals of Shelf Stocking , RSHA, and Custodial
GRAND_TOTALS	Fit Columns to Page	None	Landscape	5 year totals of Shelf Stocking , RSHA, and Custoidal
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-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
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
(Leads will receive $1.00/per hour above the wage rates for the classification of the employees						(The labor categories below are SAMPLES)						Shelf Stocking Supplies & Equipment							================
that they lead)			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		(Schedule A - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=								a requirement of the solicitation.)
Stocker		0	$17.26	$0														COST ELEMENT				DOLLARS
Lead Worker		0	$18.26	$0														=				=
Project Manager (Non-Bargaining Unit Employee)		0	$0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
		0	0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0
		0	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	0.00	$0		Stocker			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				$0
-	-	-		-		Lead Worker			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
=	=	=		=					0		$0.00	Safety Shoes			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0
Indirect Labor Hours (Non-Working)									0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=							0		$0.00	Back Brace			0	0.00	0.00	SUB-TOTAL				$0
Direct Labor Hours (Productive/Working)		0										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				$0
												Pallet Jacks			0	0.00	0.00
						=	=	=	=	=	=				0	0.00	0.00	PENSION				$0
						TOTALS			0		$0.00				0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				$0
															0	0.00	0.00					-
			H&W	H&W											0	0.00	0.00	SUB-TOTAL				$0
COST ELEMENT		Hours	Rates	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			$0
Stocker		0	$3.00	$0											0	0.00	0.00
Lead Worker		0	$3.00	$0								=	=	=	=	=	=	PROFIT	0.00%			$0
		0	$3.00	$0								TOTALS			0	0.00	$0.00
		0	$3.00	$0								=	=	=	=	=
		0	$3.00	$0														=				=
		0	$3.00	$0														GRAND TOTAL				$0
-	-	-		-														=		=	=	=
TOTALS		0		$0																ANNUAL CASES		210,672
=	=	=		=																=	=	=
																				CASE PRICE		$0.0000
Holidays, Sick and Vacations																				=	=	=
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Stocker		10	0	$0.00	(Work hours divided by ((2080 hours-
Lead Worker		10	0	$0.00	(Holidays/Sick+ Vacations)8)))
		0	0	$0.00	((Closed Holidays8Hourly rate)+
		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		0	$3.00	$0
Lead Worker		0	$3.00	$0
		0	$3.00	$0
		0	$3.00	$0
		0	$3.00	$0
		0	$3.00	$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
=	=	=	=	=	=

RSH

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
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
(Leads will receive $1.00/per hour above the wage rates for the classification of the employees						(The labor categories below are SAMPLES)						R/S/H Supplies & Equipment						================
that they lead)			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		(Schedule A - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Forklift Operator		0	$20.25	$0														COST ELEMENT				DOLLARS
Warehouse FDS		0	$19.69	$0														=				=
Lead Worker		0	$0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
Project Manager (Non-Bargaining Unit Employee)		0	$0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0
		0	$0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	$0.00	$0		Forklift Operator			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				$0
-	-	-		-		Warehouse FDS			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0		Lead Worker			0		$0.00	Dispenser, Tape			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS				$0
=	=	=		=					0		$0.00	Safety Shoes			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0
Indirect Labor Hours (Non-Working)		0							0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=							0		$0.00	Back Brace			0	0.00	0.00	SUB-TOTAL				$0
Direct Labor Hours (Productive/Working)		0										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				$0
												Pallet Jacks			0	0.00	0.00
															0	0.00	0.00	PENSION				$0
															0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				$0
						TOTALS			0		$0.00				0	0.00	0.00					-
			H&W	H&W		=	=	=	=	=	=				0	0.00	0.00	SUB-TOTAL				$0
COST ELEMENT		Hours	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			$0
Forklift Operator		0	$3.00	$0											0	0.00	0.00
Warehouse FDS		0	$3.00	$0											0	0.00	0.00	PROFIT	0.00%			$0
Lead Worker		0	$3.00	$0											0	0.00	0.00
Project Manager (Non-Bargaining Unit Employee)		0	$3.00	$0											0	0.00	0.00
		0	$3.00	$0											0	0.00	0.00	=				=
		0	$3.00	$0											0	0.00	0.00	GRAND TOTAL				$0
-	-	-		-											0	0.00	0.00	=		=	=	=
TOTALS		0		$0											0	0.00	0.00			=	=	=
=	=	=		=											0	0.00	0.00			MO. PRICE		$0
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
Forklift Operator		10	0	$0.00	(Work hours divided by ((2080 hours-										0	0.00	0.00
Warehouse FDS		10	0	$0.00	(Holidays/Sick+ Vacations)8)))							=	=	=	=		=
Lead Worker		10	0	$0.00	((Closed Holidays8Hourly rate)+							TOTALS			0		$0.00
Project Manager (Non-Bargaining Unit Employee)		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		30		$0
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Forklift Operator		0	$3.00	$0
Warehouse FDS		0	$3.00	$0
Lead Worker		0	$3.00	$0
Project Manager (Non-Bargaining Unit Employee)		0	$3.00	$0
		0	$3.00	$0
		0	$3.00	$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
=	=	=	=	=	=

Custodial

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
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
(Leads will receive $1.00/per hour above the wage rates for the classification of the employees						(The labor categories below are SAMPLES)						Custodial Supplies & Equipment						================
that they lead)			CBA
COST ELEMENT		Hours X	Rates =	Labor Cost		(Schedule A - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Custodian		0	$15.10	$0														COST ELEMENT				DOLLARS
Lead Worker		0	$16.10	$0														=				=
Project Manager (Non-Bargaining Unit Employee)		0	$0.00	$0					Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
		0	$0.00	$0		Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0
		0	$0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	$0.00	$0		Custodian			0		$0.00	Bowl, Cleaner			0	0.00	$0.00	SUB-TOTAL				$0
-	-	-		-		Lead Worker			0		$0.00	Cartridges			0	0.00	$0.00
TOTALS		0		$0					0		$0.00	Cleaner, Carpet			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS				$0
=	=	=		=					0		$0.00	Cleaner, Compound			0	0.00	0.00	HOL & VAC. HEALTH & WELFARE				$0
Indirect Labor Hours (Non-Working)		0							0		$0.00	Cleaner, Glass			0	0.00	0.00	=				=
		=							0		$0.00	Cleaner, Neutral			0	0.00	0.00	SUB-TOTAL				$0
Direct Labor Hours (Productive/Working)		0										Disinfectant			0	0.00	0.00
		=										Dust Cloths			0	0.00	0.00	FRINGES				$0
												Dust Mop Heads			0	0.00	0.00
												Floor Finish			0	0.00	0.00	PENSION				$0
												Floor Sealer			0	0.00	0.00
Direct Labor Health and Welfare						=	=	=	=	=	=	Floor Stripper			0	0.00	0.00	EQUIPMENT & SUPPLIES				$0
						TOTALS			0		$0.00	Gloves			0	0.00	0.00					-
			H&W	H&W		=	=	=	=	=	=	Gloves, Latex			0	0.00	0.00	SUB-TOTAL				$0
COST ELEMENT		Hours	Rates =	Cost								Kintowel Wiper			0	0.00	0.00					=
=	=	=	=	=								LiquidLive			0	0.00	0.00	G&A	0.00%			$0
Custodian		0	$3.00	$0								Masks			0	0.00	0.00
Lead Worker		0	$3.00	$0								Mop Head, Wet			0	0.00	0.00	PROFIT	0.00%			$0
Project Manager (Non-Bargaining Unit Employee)		0	$3.00	$0								Neutralizer			0	0.00	0.00
		0	$3.00	$0								Pads, Aqua 27"			0	0.00	0.00
		0	$3.00	$0								Pads, Buffing			0	0.00	0.00	=				=
		0	$3.00	$0								Pads, Doodle Bug			0	0.00	0.00	GRAND TOTAL				$0
-	-	-		-								Polish, Furniture			0	0.00	0.00	=		=	=	=
TOTALS		0		$0								Polish, Metal			0	0.00	0.00			MONTHLY PRICE		$0
=	=	=		=								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
Lead Worker		10	0	$0.00	(Holidays/Sick+ Vacations)8)))							Spray Bottle			0	0.00	0.00
Project Manager (Non-Bargaining Unit Employee)		0	0	$0.00	((Closed Holidays8Hourly rate)+							Spray Bottle Trigger			0	0.00	0.00
		0	0	$0.00	(Holidays worked8Hourly rate* time & half))+							Spray Buff			0	0.00	0.00
		0	0	$0.00	(Work Hours divided by(2080-((Holidays/Sick+							Toilet Tissue, 96rl			0	0.00	0.00
		0	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		20		$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.00	$0								Carpet Extractor			0	0.00	0.00
Lead Worker		0	$3.00	$0								Floor Scrubber, Low Speed			0	0.00	0.00
Project Manager (Non-Bargaining Unit Employee)		0	$3.00	$0								Scrubber, 20"			0	0.00	0.00
		0	$3.00	$0								Scrubber, Auto			0	0.00	0.00
		0	$3.00	$0								Vacuum, Wet/Dry			0	0.00	0.00
		0	$3.00	$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
=	=	=	=	=	=

Year Totals

	Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS

DOLLAR TOTALS

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

COST ELEMENT	DOLLARS
=	=
DIRECT LABOR	$0
DIRECT HEALTH & WELFARE	$0
=	=
TOTAL	$0

HOLIDAYS/SICK/VACATIONS	$0
HOL & VAC. HEALTH & WELFARE	$0
=	=
TOTAL	$0
FRINGES CALCULATIONS	$0

PENSION $0

SUPPLIES & EQUIPMENT	$0
SUB-TOTAL	$0
G&A	$0

PROFIT $0

=	=
GRAND TOTAL	$0
=	=

5 Yr. Totals

	Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico
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	0	0	0	0	0
=	=	=	=	=	=	=

	Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico
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%

GROSS RECEIPT TAX		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
GRAND TOTAL
=	=	=	=	=	=

Shelf Stocker Loaded Wage Rate

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Stocker Loaded Wage Rate Sheets Stocker Loaded Wage Rate Sheets Stocker Loaded Wage Rate Sheets Stocker Loaded Wage Rate Sheets

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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Stocker		1	$17.26	$17.26													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$17.26
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Stocker			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$20.26
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$17.26							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$0.93
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$1.05
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$1.91
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$26.86
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Stocker		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$26.86
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Stocker		10	0	$0.93	(Work hours divided by ((2080 hours-
				$0.00	(Holidays/Sick+ Vacations)8)))
				$0.00	((Closed Holidays8Hourly rate)+
				$0.00	(Holidays worked8Hourly rate* time & half))+
				$0.00	(Work Hours divided by(2080-((Holidays/Sick+
				$0.00	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$0.93
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Stocker		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$17.26
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$0.93
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$24.95
=	=	=	=	=	=

FICA	X	7.65%		=	$1.91
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$1.91
=	=	=	=	=	=

Lead Stocker Loaded Wage Lead

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Stocker Lead Loaded Wage Rate Sheets Stocker Lead Loaded Wage Rate Sheets Stocker Lead Loaded Wage Rate Sheets Stocker Lead Loaded Wage Rate Sheets

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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Shelf Stocker (Lead)		1	$18.26	$18.26													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$18.26
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Shelf Stocker (Lead)			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$21.26
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$18.26							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$0.99
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$1.11
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$1.99
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$28.00
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Shelf Stocker (Lead)		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$28.00
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Shelf Stocker (Lead)		10	0	$0.99	(Work hours divided by ((2080 hours-
				$0.00	(Holidays/Sick+ Vacations)8)))
				$0.00	((Closed Holidays8Hourly rate)+
				$0.00	(Holidays worked8Hourly rate* time & half))+
				$0.00	(Work Hours divided by(2080-((Holidays/Sick+
				$0.00	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$0.99
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Shelf Stocker (Lead)		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$18.26
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$0.99
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$26.01
=	=	=	=	=	=

FICA	X	7.65%		=	$1.99
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$1.99
=	=	=	=	=	=

Fork Lift Op Loaded Wage Rate

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet 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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Forklift Operator		1	$20.25	$20.25													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$20.25
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Forklift Operator			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$23.25
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$20.25							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$1.09
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$1.21
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$2.15
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$30.25
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Forklift Operator		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$30.25
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Forklift Operator		10	0	$1.09	(Work hours divided by ((2080 hours-
					(Holidays/Sick+ Vacations)8)))
					((Closed Holidays8Hourly rate)+
					(Holidays worked8Hourly rate* time & half))+
					(Work Hours divided by(2080-((Holidays/Sick+
					Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$1.09
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Forklift Operator		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$20.25
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$1.09
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$28.10
=	=	=	=	=	=

FICA	X	7.65%		=	$2.15
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$2.15
=	=	=	=	=	=

Warehouse FDS Loaded Wage

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Warehouse FDS Loaded Wage Rate Work Sheet Warehouse FDS Loaded Wage Rate Work Sheet Warehouse FDS Loaded Wage Rate Work Sheet Warehouse FDS 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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Warehouse FDS		1	$19.69	$19.69													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$19.69
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Warehouse FDS			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$22.69
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$19.69							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$1.06
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$1.18
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$2.10
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$29.62
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Warehouse FDS		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$29.62
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Warehouse FDS		10	0	$1.06	(Work hours divided by ((2080 hours-
					(Holidays/Sick+ Vacations)8)))
					((Closed Holidays8Hourly rate)+
					(Holidays worked8Hourly rate* time & half))+
					(Work Hours divided by(2080-((Holidays/Sick+
					Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$1.06
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Warehouse FDS		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$19.69
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$1.06
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$27.51
=	=	=	=	=	=

FICA	X	7.65%		=	$2.10
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$2.10
=	=	=	=	=	=

RSHA Lead Loaded Wage Lead

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

RSHA Lead Loaded Wage Rate Work Sheet RSHA Lead Loaded Wage Rate Work Sheet RSHA Lead Loaded Wage Rate Work Sheet RSHA Lead 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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
RSHA Lead		1	$21.76	$21.76													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$21.76
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					RSHA Lead			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$24.76
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$21.76							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$1.18
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$1.30
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$2.27
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$31.97
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
RSHA Lead		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$31.97
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
RSHA Lead		10	0	$1.18	(Work hours divided by ((2080 hours-
					(Holidays/Sick+ Vacations)8)))
					((Closed Holidays8Hourly rate)+
					(Holidays worked8Hourly rate* time & half))+
					(Work Hours divided by(2080-((Holidays/Sick+
					Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$1.18
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
RSHA Lead		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$21.76
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$1.18
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$29.70
=	=	=	=	=	=

FICA	X	7.65%		=	$2.27
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$2.27
=	=	=	=	=	=

Custodian Loaded Wage Rate

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Custodian Loaded Wage Rate Work Sheet Custodian Loaded Wage Rate Work Sheet Custodian Loaded Wage Rate Work Sheet 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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Custodian		1	$15.10	$15.10													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$15.10
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Custodian			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$18.10
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$15.10							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$0.82
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$0.94
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$1.73
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$24.41
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Custodian		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$24.41
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Custodian		10	0	$0.82	(Work hours divided by ((2080 hours-
					(Holidays/Sick+ Vacations)8)))
					((Closed Holidays8Hourly rate)+
					(Holidays worked8Hourly rate* time & half))+
					(Work Hours divided by(2080-((Holidays/Sick+
					Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$0.82
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Custodian		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$15.10
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$0.82
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$22.68
=	=	=	=	=	=

FICA	X	7.65%		=	$1.73
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$1.73
=	=	=	=	=	=

Custodian Lead Loaded Wage Rate

	Attachment 4		Attachment 4		Attachment 4		Attachment 4
SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014	SOLICITATION NUMBER:	HDEC08-17-R-0014
COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico	COMMISSARY:	Holloman AFB, New Mexico
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Custodian Lead Loaded Wage Rate Work Sheet Custodian Lead Loaded Wage Rate Work Sheet Custodian Lead Loaded Wage Rate Work Sheet Custodian Lead 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 - $3.50/hour per Bargaining Union Employee)					$3.50	(The elements listed below are SAMPLES and are not considered
=	=	=	=	=							a requirement of the solicitation.)
Custodian Lead		1	$16.10	$16.10													COST ELEMENT			DOLLARS
																	=			=
								Hours +		Extended				Qty.	Unit/	Extended	DIRECT LABOR			$16.10
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO					Labor Categories			Sick/Vacation		Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE			$3.00
CALCULATE THE LOADED HOURLY RATE. PROCEED					=	=	=	=	=	=	=	=	=	=	=	=	=			=
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES					Custodian Lead			1		$3.64	Supplies and Equipment Costs			0	0.00	$0.00	SUB-TOTAL			$19.10
-	-	-		-							are not included in the loaded			0	0.00	$0.00
TOTALS		1		$16.10							rate for Store Worker I			0	0.00	0.00	HOLIDAYS/SICK/VACATIONS			$0.87
=	=	=		=										0	0.00	0.00	HOL & VAC. HEALTH & WELFARE			$0.12
Indirect Labor Hours (Non-Working)														0	0.00	0.00	=			=
		=												0	0.00	0.00	SUB-TOTAL			$0.99
Direct Labor Hours (Productive/Working)		1												0	0.00	0.00
		=												0	0.00	0.00	FRINGES			$1.82
														0	0.00	0.00
					=	=	=	=	=	=				0	0.00	0.00	PENSION			$3.64
					TOTALS			$1.04		$3.64				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			$25.54
COST ELEMENT		Hours	Rates	Cost										0	0.00	0.00				=
=	=	=	=	=										0	0.00	0.00	G&A	0.00%		$0.00
Custodian Lead		1	$3.00	$3.00										0	0.00	0.00
											=	=	=	=	=	=	PROFIT	0.00%		$0.00
											TOTALS			0	0.00	$0.00
											=	=	=	=	=
																	=			=
																	GRAND TOTAL			$25.54
-	-	-		-													=		=	=
TOTALS		1		$3.00
=	=	=		=

Holidays, Sick and Vacations
				Holidays, Sick,
			Sick/	Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Custodian Lead		10	0	$0.87	(Work hours divided by ((2080 hours-
					(Holidays/Sick+ Vacations)8)))
					((Closed Holidays8Hourly rate)+
					(Holidays worked8Hourly rate* time & half))+
					(Work Hours divided by(2080-((Holidays/Sick+
					Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		10		$0.87
=	=	=		=

Holidays and Vacations Health & Welfare

		Holidays/Sick/	H&W	H&W
COST ELEMENT		Vacations	Rates	Cost
=	=	=	=	=
Custodian Lead		0	$3.00	$0.12

-	-	-	-
TOTALS		0	$0.12
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$16.10
DIRECT HEALTH & WELFARE COSTS					$3.00
HOLIDAYS/SICK/VACATION					$0.87
PENSION					$3.64
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.12
-	-	-	-	-	-
SUBTOTAL					$23.73
=	=	=	=	=	=

FICA	X	7.65%		=	$1.82
FUTA	X	0.00%		=	$0.00
SUTA	X	0.00%		=	$0.00
Workman's Compensation	X	0.00%		=	$0.00
Employer's Liability	X	0.00%		=	$0.00
Comprehensive General Liability	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
Other	X	0.00%		=	$0.00
-	-	-	-	-	-
TOTAL FRINGES					$1.82
=	=	=	=	=	=

Sheet1

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