Attachment 5 Vol I Cost Breakout.xls

XLS spreadsheet 248 KB Posted Apr 12, 2010

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

About this file

From the source

Attachment 5

View the file

Other files

File	Type	Posted
Amendment 0002 Solicitation HDEC08-10-R-0007	—	May 26, 2010
HDEC08-10-R-0007 Amendment 1.doc	DOC document	Apr 14, 2010
Attachment 1 DD 1707.doc	DOC document	Apr 14, 2010
HDEC08-10-R-0007.doc	DOC document	Apr 12, 2010
Attachment 8 Vol III - Past Performance Information.rtf	RTF text file	Apr 12, 2010
Attachment 7 TDWS DLS.xls	XLS spreadsheet	Apr 12, 2010
Attachment 4 Bereavement Leave Certificate.doc	DOC document	Apr 12, 2010
Attachment 2 Performance Work Statement dated 11.30.09.pdf	PDF	Apr 12, 2010
Attachment 1 DD 1707.doc	DOC document	Apr 12, 2010
Attachment 6 Vol II - Technical Capability Personnel Proposal.rtf	RTF text file	Apr 12, 2010
Attachment 3 WD Collective Bargaining Agreement.pdf	PDF	Apr 12, 2010

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

Try for free Login

Text version

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

Cost Breakout

ATTACHMENT 4

HDEC08-05-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

					Attachment 4
BASIC INSTRUCTIONS					HDEC08-10-R-0007
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 5						Attachment 5						Attachment 5						Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom 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						Health and Welfare Benefit						Contractor Proposed							DOLLAR TOTALS
Hours worked between 6:00 pm. and 6:00 a.m. receive $.30 per hour Shift Differential.						(The labor categories below are SAMPLES)						Shelf Stocking Supplies & Equipment							================
						(Article 28 - Effective October 1, 2004, the employer will pay the sum of $380.98 per month for
COST ELEMENT		Hours X	Rates =	Labor Cost		each eligible employee.						(The elements listed below are SAMPLES and are not considered
=	=	=	=	=								a requirement of the solicitation.)
Day Stocker (Indicate Step)		0	0.00	$0														COST ELEMENT				DOLLARS
Day Stocker (Indicate Step)		0	0.00	$0														=				=
Night Stocker (Indicate Step)		0	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				0
Night Stocker (Indicate Step)		0	0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	HEALTH & WELFARE				0
Lead Stocker (Indicate Step)		0	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
Project Manger		0	0.00	$0		Day Stocker (Indicate Step)			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				0
-	-	-		-		Day Stocker (Indicate Step)			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0		Night Stocker (Indicate Step)			0		$0.00	Dispenser, Tape			0	0.00	0.00	SICK LEAVE				0
=	=	=		=		Night Stocker (Indicate Step)			0		$0.00	Safety Shoes			0	0.00	0.00	HOLIDAYS/VACATIONS				0
Indirect Labor Hours (Non-Working)		0				Lead Stocker (Indicate Step)			0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=				Project Manger			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
Sick Leave						=	=	=	=	=	=				0	0.00	0.00	PENSION				0
						TOTALS			0		$0.00				0	0.00	0.00
(Article 31 - Effective January 31, 1999, the employer agrrees to pay $.70 per hour						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				0
for each employee.)															0	0.00	0.00					-
			Sick	Sick											0	0.00	0.00	SUB-TOTAL				0
COST ELEMENT		Hours X	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			0
Day Stocker (Indicate Step)		0	0.70	$0											0	0.00	0.00
Day Stocker (Indicate Step)		0	0.70	$0								=	=	=	=	=	=	PROFIT	0.00%			0
Night Stocker (Indicate Step)		0	0.70	$0								TOTALS			0	0.00	$0.00
Night Stocker (Indicate Step)		0	0.70	$0								=	=	=	=	=		=				=
Lead Stocker (Indicate Step)		0	0.70	$0														GRAND TOTAL				0
Project Manger		0	0.70	$0														=		=	=	=
-	-	-		-																ANNUAL CASES		216,648
TOTALS		0		$0																=	=	=
=	=	=		=																CASE PRICE		0.0000
																				=	=	=
Holidays/Vacations
				Holidays/
				Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Day Stocker (Indicate Step)		11	10	$0	(Work hours divided by ((2080 hours-
Day Stocker (Indicate Step)		11	10	$0	(Holidays/Sick+ Vacations)8)))
Night Stocker (Indicate Step)		11	10	$0	((Closed Holidays8Hourly rate)+
Night Stocker (Indicate Step)		11	10	$0	(Holidays worked8Hourly rate* time & half))+
Lead Stocker (Indicate Step)		11	10	$0	(Work Hours divided by(2080-((Holidays/Sick+
Project Manger		11	10	$0	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		66		$0
=	=	=		=
Pension
(Article 48 - Effective October 1, 2001, the employer agrrees to pay $.80 per hour
for each employee.)
		Pension	Pension	Pension
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Day Stocker (Indicate Step)		0	0.80	$0
Day Stocker (Indicate Step)		0	0.80	$0
Night Stocker (Indicate Step)		0	0.80	$0
Night Stocker (Indicate Step)		0	0.80	$0
Lead Stocker (Indicate Step)		0	0.80	$0
Project Manger		0	0.80	$0
-	-	-		-
TOTALS		0		$0
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT LABOR HEALTH & WELFARE COST					$0
HOLIDAYS/VACATION					$0
SICK LEAVE					$0
PENSION					$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

Inventory Preparation

	Attachment 5						Attachment 5						Attachment 5						Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB
CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:
The Offeror must provide a proposal for the applicable labor category.
Inventory Preparation Work Sheet						Inventory Preparation Work Sheet						Inventory Preparation Work Sheet						Inventory Preparation Work Sheet
Direct Labor						Health and Welfare Benefit						Contractor Proposed							DOLLAR TOTALS
Hours worked between 6:00 pm. and 6:00 a.m. receive $.30 per hour Shift Differential.						(The labor categories below are SAMPLES)						Shelf Stocking Supplies & Equipment							================
						(Article 28 - Effective October 1, 2004, the employer will pay the sum of $380.98 per month for
COST ELEMENT		Hours X	Rates =	Labor Cost		each eligible employee.						(The elements listed below are SAMPLES and are not considered
=	=	=	=	=								a requirement of the solicitation.)
Day Stocker (Indicate Step)		1	0.00	$0														COST ELEMENT				DOLLARS
Day Stocker (Indicate Step)		1	0.00	$0														=				=
Night Stocker (Indicate Step)		1	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				0
Night Stocker (Indicate Step)		1	0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	HEALTH & WELFARE				0
Lead Stocker (Indicate Step)		1	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
Project Manger		1	0.00	$0		Day Stocker (Indicate Step)			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				0
-	-	-		-		Day Stocker (Indicate Step)			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		6		$0		Night Stocker (Indicate Step)			0		$0.00	Dispenser, Tape			0	0.00	0.00	SICK LEAVE				4
=	=	=		=		Night Stocker (Indicate Step)			0		$0.00	Safety Shoes			0	0.00	0.00	HOLIDAYS/VACATIONS				0
Indirect Labor Hours (Non-Working)		0				Lead Stocker (Indicate Step)			0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=				Project Manger			0		$0.00	Back Brace			0	0.00	0.00	SUB-TOTAL				4
Direct Labor Hours (Productive/Working)		6										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				1
												Pallet Jacks			0	0.00	0.00
Sick Leave						=	=	=	=	=	=				0	0.00	0.00	PENSION				5
						TOTALS			0		$0.00				0	0.00	0.00
(Article 31 - Effective January 31, 1999, the employer agrees to pay $.70 per hour						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLIES				0
for each employee.)															0	0.00	0.00					-
			Sick	Sick											0	0.00	0.00	SUB-TOTAL				10
COST ELEMENT		Hours X	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			0
Day Stocker (Indicate Step)		1	0.70	$1											0	0.00	0.00
Day Stocker (Indicate Step)		1	0.70	$1								=	=	=	=	=	=	PROFIT	0.00%			0
Night Stocker (Indicate Step)		1	0.70	$1								TOTALS			0	0.00	$0.00
Night Stocker (Indicate Step)		1	0.70	$1								=	=	=	=	=		=				=
Lead Stocker (Indicate Step)		1	0.70	$1														GRAND TOTAL				10
Project Manger		1	0.70	$1														=		=	=	=
-	-	-		-																ANNUAL CASES		216,648
TOTALS		6		$4																=	=	=
=	=	=		=																CASE PRICE		0.0000
																				=	=	=
Holidays/Vacations
				Holidays/
				Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Day Stocker (Indicate Step)		11	10	$0	(Work hours divided by ((2080 hours-
Day Stocker (Indicate Step)		11	10	$0	(Holidays/Sick+ Vacations)8)))
Night Stocker (Indicate Step)		11	10	$0	((Closed Holidays8Hourly rate)+
Night Stocker (Indicate Step)		11	10	$0	(Holidays worked8Hourly rate* time & half))+
Lead Stocker (Indicate Step)		11	10	$0	(Work Hours divided by(2080-((Holidays/Sick+
Project Manger		11	10	$0	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		66		$0
=	=	=		=
Pension
(Article 48 - Effective October 1, 2001, the employer agrrees to pay $.80 per hour
for each employee.)
		Pension	Pension	Pension
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Day Stocker (Indicate Step)		1	0.80	$1
Day Stocker (Indicate Step)		1	0.80	$1
Night Stocker (Indicate Step)		1	0.80	$1
Night Stocker (Indicate Step)		1	0.80	$1
Lead Stocker (Indicate Step)		1	0.80	$1
Project Manger		1	0.80	$1
-	-	-		-
TOTALS		6		$5
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT LABOR HEALTH & WELFARE COST					$0
HOLIDAYS/VACATION					$0
SICK LEAVE					$4
PENSION					$5
-	-	-	-	-	-
SUBTOTAL					$9
=	=	=	=	=	=
FICA	X	7.65%		=	$1
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					$1
=	=	=	=	=	=

Click Here to Print

RSH

	Attachment 5						Attachment 5						Attachment 5						Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom 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						Health and Welfare Benefit							Contractor Proposed					DOLLAR TOTALS
Employees who work in the freezer receive a $.30 per hour Freezer Differential for each						(The labor categories below are SAMPLES)						R/S/H Supplies & Equipment						================
hour worked.						(Article 28 - Effective October 1, 2004, the employer will pay the sum of $290.50 per month for
COST ELEMENT		Hours X	Rates =	Labor Cost		each eligible employee.						(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Warehouse Worker (Indicate Step)		0	0.00	$0														COST ELEMENT				DOLLARS
Warehouse Worker (Indicate Step)		0	0.00	$0														=				=
Warehouse Worker (Indicate Step)		0	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				0
Warehouse Worker (FREEZER) (Indicate Step)		0	0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	HEALTH & WELFARE				0
Lead Warehouse Worker		0	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
Project Manager		0	0.00	$0		Warehouse Worker (Indicate Step)			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				0
-	-	-		-		Warehouse Worker (Indicate Step)			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0		Warehouse Worker (Indicate Step)			0		$0.00	Dispenser, Tape			0	0.00	0.00	SICK LEAVE				0
=	=	=		=		Warehouse Worker (FREEZER) (Indicate Step)			0		$0.00	Safety Shoes			0	0.00	0.00	HOLIDAYS/VACATIONS				0
Indirect Labor Hours (Non-Working)		0				Lead Warehouse Worker			0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=				Project Manager			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
Sick Leave															0	0.00	0.00	PENSION				0
															0	0.00	0.00
(Article 31 - Effective January 31, 1999, the employer agrrees to pay $.70 per hour						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLY				0
for each employee.)						TOTALS			0		$0.00				0	0.00	0.00					-
			Sick	Sick		=	=	=	=	=	=				0	0.00	0.00	SUB-TOTAL				0
COST ELEMENT		Hours X	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			0
Warehouse Worker (Indicate Step)		0	0.70	$0											0	0.00	0.00
Warehouse Worker (Indicate Step)		0	0.70	$0											0	0.00	0.00	PROFIT	0.00%			0
Warehouse Worker (Indicate Step)		0	0.70	$0											0	0.00	0.00
Warehouse Worker (FREEZER) (Indicate Step)		0	0.70	$0											0	0.00	0.00	=				=
Lead Warehouse Worker		0	0.70	$0											0	0.00	0.00	GRAND TOTAL				0
Project Manager		0	0.70	$0											0	0.00	0.00	=		=	=	=
-	-	-		-											0	0.00	0.00
TOTALS		0		$0											0	0.00	0.00			=	=	=
=	=	=		=											0	0.00	0.00			MO. PRICE		0
															0	0.00	0.00			=	=	=
Holidays/Vacations															0	0.00	0.00
				Holidays											0	0.00	0.00
				Vacations											0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars											0	0.00	0.00
=	=	=	=	=											0	0.00	0.00
Warehouse Worker (Indicate Step)		11	10	$0	(Work hours divided by ((2080 hours-										0	0.00	0.00
Warehouse Worker (Indicate Step)		11	10	$0	(Holidays/Sick+ Vacations)8)))							=	=	=	=		=
Warehouse Worker (Indicate Step)		11	10	$0	((Closed Holidays8Hourly rate)+							TOTALS			0		$0.00
Warehouse Worker (FREEZER) (Indicate Step)		11	10	$0	(Holidays worked8Hourly rate* time & half))+							=	=	=	=	=	=
Lead Warehouse Worker		11	10	$0	(Work Hours divided by(2080-((Holidays/Sick+
Project Manager		11	10	$0	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		66		$0
=	=	=		=
Pension
(Article 48 - Effective October 1, 2001, the employer agrrees to pay $.80 per hour
for each employee.)
		Pension	Pension	Pension
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Warehouse Worker (Indicate Step)		0	0.80	$0
Warehouse Worker (Indicate Step)		0	0.80	$0
Warehouse Worker (Indicate Step)		0	0.80	$0
Warehouse Worker (FREEZER) (Indicate Step)		0	0.80	$0
Lead Warehouse Worker		0	0.80	$0
Project Manager		0	0.80	$0
-	-	-		-
TOTALS		0		$0
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT LABOR HEALTH & WELFARE COST					$0
HOLIDAYS/VACATION					$0
SICK LEAVE					$0
PENSION					$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

MHE Support for Inventory

	Attachment 5						Attachment 5						Attachment 5						Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB
CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:						CONTRACTOR NAME:
The Offeror must provide a proposal for the applicable labor category.
MHE Support of Inventory Work Sheet						MHE Support of Inventory Work Sheet						MHE Support of Inventory Work Sheet						MHE Support of Inventory Work Sheet
Direct Labor						Health and Welfare Benefit							Contractor Proposed					DOLLAR TOTALS
Employees who work in the freezer receive a $.30 per hour Freezer Differential for each						(The labor categories below are SAMPLES)						R/S/H Supplies & Equipment						================
hour worked.						(Article 28 - Effective October 1, 2004, the employer will pay the sum of $290.50 per month for
COST ELEMENT		Hours X	Rates =	Labor Cost		each eligible employee.						(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Warehouse Worker (Indicate Step)		1	0.00	$0														COST ELEMENT				DOLLARS
Warehouse Worker (Indicate Step)		1	0.00	$0														=				=
Warehouse Worker (Indicate Step)		1	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				0
Warehouse Worker (FREEZER) (Indicate Step)		1	0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	HEALTH & WELFARE				0
Lead Warehouse Worker		1	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
Project Manager		1	0.00	$0		Warehouse Worker (Indicate Step)			0		$0.00	Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				0
-	-	-		-		Warehouse Worker (Indicate Step)			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		6		$0		Warehouse Worker (Indicate Step)			0		$0.00	Dispenser, Tape			0	0.00	0.00	SICK LEAVE				4
=	=	=		=		Warehouse Worker (FREEZER) (Indicate Step)			0		$0.00	Safety Shoes			0	0.00	0.00	HOLIDAYS/VACATIONS				0
Indirect Labor Hours (Non-Working)		0				Lead Warehouse Worker			0		$0.00	Tape Masking			0	0.00	0.00	=				=
		=				Project Manager			0		$0.00	Back Brace			0	0.00	0.00	SUB-TOTAL				4
Direct Labor Hours (Productive/Working)		6										Cart, Bushel			0	0.00	0.00
		=										Cart, Stocking			0	0.00	0.00	FRINGES				1
												Pallet Jacks			0	0.00	0.00
Sick Leave															0	0.00	0.00	PENSION				5
															0	0.00	0.00
(Article 31 - Effective January 31, 1999, the employer agrrees to pay $.70 per hour						=	=	=	=	=	=				0	0.00	0.00	EQUIPMENT & SUPPLY				0
for each employee.)						TOTALS			0		$0.00				0	0.00	0.00					-
			Sick	Sick		=	=	=	=	=	=				0	0.00	0.00	SUB-TOTAL				10
COST ELEMENT		Hours X	Rates =	Cost											0	0.00	0.00					=
=	=	=	=	=											0	0.00	0.00	G&A	0.00%			0
Warehouse Worker (Indicate Step)		1	0.70	$1											0	0.00	0.00
Warehouse Worker (Indicate Step)		1	0.70	$1											0	0.00	0.00	PROFIT	0.00%			0
Warehouse Worker (Indicate Step)		1	0.70	$1											0	0.00	0.00
Warehouse Worker (FREEZER) (Indicate Step)		1	0.70	$1											0	0.00	0.00	=				=
Lead Warehouse Worker		1	0.70	$1											0	0.00	0.00	GRAND TOTAL				10
Project Manager		1	0.70	$1											0	0.00	0.00	=		=	=	=
-	-	-		-											0	0.00	0.00
TOTALS		6		$4											0	0.00	0.00			=	=	=
=	=	=		=											0	0.00	0.00			MO. PRICE		1
															0	0.00	0.00			=	=	=
Holidays/Vacations															0	0.00	0.00
				Holidays											0	0.00	0.00
				Vacations											0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars											0	0.00	0.00
=	=	=	=	=											0	0.00	0.00
Warehouse Worker (Indicate Step)		11	10	$0	(Work hours divided by ((2080 hours-										0	0.00	0.00
Warehouse Worker (Indicate Step)		11	10	$0	(Holidays/Sick+ Vacations)8)))							=	=	=	=		=
Warehouse Worker (Indicate Step)		11	10	$0	((Closed Holidays8Hourly rate)+							TOTALS			0		$0.00
Warehouse Worker (FREEZER) (Indicate Step)		11	10	$0	(Holidays worked8Hourly rate* time & half))+							=	=	=	=	=	=
Lead Warehouse Worker		11	10	$0	(Work Hours divided by(2080-((Holidays/Sick+
Project Manager		11	10	$0	Vacations)8)))(Vacations 8Hourly rate)
-	-	-		-
TOTALS		66		$0
=	=	=		=
Pension
(Article 48 - Effective October 1, 2001, the employer agrrees to pay $.80 per hour
for each employee.)
		Pension	Pension	Pension
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Warehouse Worker (Indicate Step)		1	0.80	$1
Warehouse Worker (Indicate Step)		1	0.80	$1
Warehouse Worker (Indicate Step)		1	0.80	$1
Warehouse Worker (FREEZER) (Indicate Step)		1	0.80	$1
Lead Warehouse Worker		1	0.80	$1
Project Manager		1	0.80	$1
-	-	-		-
TOTALS		6		$5
=	=	=		=
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT LABOR HEALTH & WELFARE COST					$0
HOLIDAYS/VACATION					$0
SICK LEAVE					$4
PENSION					$5
-	-	-	-	-	-
SUBTOTAL					$9
=	=	=	=	=	=
FICA	X	7.65%		=	$1
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					$1
=	=	=	=	=	=

Click Here to Print

Custodial

	Attachment 5						Attachment 5						Attachment 5						Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007					SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom AFB					COMMISSARY:	Malmstrom 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						Health and Welfare Benefit						Contractor Proposed						DOLLAR TOTALS
Hours worked between 6:00 pm. and 6:00 a.m. receive $.30 per hour Shift Differential.						(The labor categories below are SAMPLES)						Custodial Supplies & Equipment						================
						(Article 28 - Effective October 1, 2004, the employer will pay the sum of $380.98 per month for
COST ELEMENT		Hours X	Rates =	Labor Cost		each eligible employee.						(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Day Janitor (Indicate Step)		0	0.00	$0														COST ELEMENT				DOLLARS
Day Janitor (Indicate Step)		0	0.00	$0														=				=
Night Janitor (Indicate Step)		0	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				0
Night Janitor (Indicate Step)		0	0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	HEALTH & WELFARE				0
Lead Janitor		0	0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
Project Manager		0	0.00	$0		Day Janitor (Indicate Step)			0		$0.00	Bowl, Cleaner			0	0.00	$0.00	SUB-TOTAL				0
-	-	-		-		Day Janitor (Indicate Step)			0		$0.00	Cartridges			0	0.00	$0.00
TOTALS		0		$0		Night Janitor (Indicate Step)			0		$0.00	Cleaner, Carpet			0	0.00	0.00	SICK LEAVE				0
=	=	=		=		Night Janitor (Indicate Step)			0		$0.00	Cleaner, Compound			0	0.00	0.00	HOLIDAYS/VACATIONS				0
Indirect Labor Hours (Non-Working)		0				Lead Janitor			0		$0.00	Cleaner, Glass			0	0.00	0.00	=				=
		=				Project Manager			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
Sick Leave												Floor Sealer			0	0.00	0.00
(Article 31 - Effective January 31, 1999, the employer agrrees to pay $.70 per hour						=	=	=	=	=	=	Floor Stripper			0	0.00	0.00	EQUIPMENT & SUPPLIES				0
for each employee.)						TOTALS			0		$0.00	Gloves			0	0.00	0.00					-
			Sick	Sick		=	=	=	=	=	=	Gloves, Latex			0	0.00	0.00	SUB-TOTAL				0
COST ELEMENT		Hours X	Rates =	Cost								Kintowel Wiper			0	0.00	0.00					=
=	=	=	=	=								LiquidLive			0	0.00	0.00	G&A	0.00%			0
Day Janitor (Indicate Step)		0	0.70	$0								Masks			0	0.00	0.00
Day Janitor (Indicate Step)		0	0.70	$0								Mop Head, Wet			0	0.00	0.00	PROFIT	0.00%			0
Night Janitor (Indicate Step)		0	0.70	$0								Neutralizer			0	0.00	0.00
Night Janitor (Indicate Step)		0	0.70	$0								Pads, Aqua 27"			0	0.00	0.00	=				=
Lead Janitor		0	0.70	$0								Pads, Buffing			0	0.00	0.00	GRAND TOTAL				0
Project Manager		0	0.70	$0								Pads, Doodle Bug			0	0.00	0.00	=		=	=	=
-	-	-		-								Polish, Furniture			0	0.00	0.00			MONTHLY PRICE		0
TOTALS		0		$0								Polish, Metal			0	0.00	0.00			=	=	=
=	=	=		=								Propane			0	0.00	0.00
												Rain Suit			0	0.00	0.00
Holidays/Vacations												Respirators			0	0.00	0.00
				Holidays/								Retainer			0	0.00	0.00
				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
Day Janitor (Indicate Step)		11	10	$0	(Work hours divided by ((2080 hours-							Sponges			0	0.00	0.00
Day Janitor (Indicate Step)		11	10	$0	(Holidays/Sick+ Vacations)8)))							Spray Bottle			0	0.00	0.00
Night Janitor (Indicate Step)		11	10	$0	((Closed Holidays8Hourly rate)+							Spray Bottle Trigger			0	0.00	0.00
Night Janitor (Indicate Step)		11	10	$0	(Holidays worked8Hourly rate* time & half))+							Spray Buff			0	0.00	0.00
Lead Janitor		11	10	$0	(Work Hours divided by(2080-((Holidays/Sick+							Toilet Tissue, 96rl			0	0.00	0.00
Project Manager		11	10	$0	Vacations)8)))(Vacations 8Hourly rate)							Towels, Pop-Up			0	0.00	0.00
-	-	-		-								Trash Liners, Lg			0	0.00	0.00
TOTALS		66		$0								Trash Liners, Sm			0	0.00	0.00
=	=	=		=								Vaccuum Belts			0	0.00	0.00
												Visors			0	0.00	0.00
Pension												Battery Charger			0	0.00	0.00
(Article 48 - Effective October 1, 2001, the employer agrrees to pay $.80 per hour												Buffer, High Speed			0	0.00	0.00
for each employee.)												Burnisher High Speed			0	0.00	0.00
		Pension	Pension	Pension								Burnisher, 21" Propane			0	0.00	0.00
COST ELEMENT		Hours X	Rates =	Cost								Caddy, Maid			0	0.00	0.00
=	=	=	=	=								Carpet Extractor			0	0.00	0.00
Day Janitor (Indicate Step)		0	0.80	$0								Floor Scrubber, Low Speed			0	0.00	0.00
Day Janitor (Indicate Step)		0	0.80	$0								Scrubber, 20"			0	0.00	0.00
Night Janitor (Indicate Step)		0	0.80	$0								Scrubber, Auto			0	0.00	0.00
Night Janitor (Indicate Step)		0	0.80	$0								Vacuum, Wet/Dry			0	0.00	0.00
Lead Janitor		0	0.80	$0								Washer, Pressure			0	0.00	0.00
Project Manager		0	0.80	$0											0	0.00	0.00
-	-	-		-											0	0.00	0.00
TOTALS		0		$0											0	0.00	0.00
=	=	=		=											0	0.00	0.00
												=	=	=	=	=	=
												TOTALS			0		$0
FRINGE CALCULATIONS
COST ELEMENT					DOLLARS							=	=	=	=	=	=
=	=	=	=	=	=
DIRECT LABOR COST					$0
DIRECT LABOR HEALTH & WELFARE COST					$0
HOLIDAYS/VACATION					$0
SICK LEAVE					$0
PENSION					$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 5
SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom AFB
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS
DOLLAR TOTALS
================
COST ELEMENT		DOLLARS
=		=
DIRECT LABOR		0
HEALTH & WELFARE		0
=		=
TOTAL		0
SICK LEAVE		0
HOLIDAYS/VACATIONS		0
=		=
TOTAL		0
FRINGE CALCULATIONS		0
PENSION		0
SUPPLIES & EQUIPMENT		0
SUB-TOTAL		0
G&A		0
PROFIT		0
=		=
GRAND TOTAL		0
=		=

Click Here to Print

5 Yr. Totals

	Attachment 5
SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom 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
HEALTH & WELFARE	0	0	0	0	0	0
=	=	=	=	=	=	=
TOTAL	0	0	0	0	0	0
SICK LEAVE	0	0	0	0	0	0
HOLIDAYS/VACATIONS	0	0	0	0	0	0
=	=	=	=	=	=	=
TOTAL	0	0	0	0	0	0
FRINGE 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 5
SOLICITATION NUMBER:	HDEC08-10-R-0007
COMMISSARY:	Malmstrom 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 LABOR HEALTH & WELFARE		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
TOTAL
HOLIDAYS/SICK/VACATIONS		0.00%	0.00%	0.00%	0.00%
HOL, SICK, VAC HEALTH & WELFARE		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
TOTAL
FRINGE CALCULATIONS		0.00%	0.00%	0.00%	0.00%
PENSION		0.00%	0.00%	0.00%	0.00%
SUPPLIES & EQUIPMENT		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

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