Attachment_4_-_Volume_I_Cost_Breakout_for_Whiteman_AFB_Commissary.xls

XLS spreadsheet 336 KB Posted Aug 23, 2016

Attached to: Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations for the Whiteman AFB Commissary, located at Whiteman AFB, MO
Solicitation number: HDEC08-16-R-0007
Issued by: Defense Commissary Agency

About this file

From the source

Attachment 4 Volume I Cost Breakout

View the file

Other files

File	Type	Posted
Attachment_2_-_Revised_PWS_dated_10-18-16_posted_Fedbizopps_2-6-2017.pdf	PDF	Feb 6, 2017
Amendment_0002_-_Whiteman_AFB_Commissary_posted_Fedbizopps_2-6-2017.pdf	PDF	Feb 6, 2017
PD2-Whiteman_AFB_Solicitation_Amendment_HDEC08-16-R-0007-0001.pdf	PDF	Oct 6, 2016
Attachment_6_-_Volume_II_Typical_Daily_Work_Schedule__Direct_Labor_Summary_for_Whiteman_AFB_Commissary.xls	XLS spreadsheet	Aug 23, 2016
Attachment_8_-_Bereavement_Leave_Certification_for_Whiteman_AFB_Commissary.doc	DOC document	Aug 23, 2016
Attachment_7_-_Volume_III_Past_Performance_Information_for_Whiteman_AFB_Commissary.doc	DOC document	Aug 23, 2016
Attachment_2_-_Performance_Work_Statement_(PWS)_dated_July_21_2016_for_Whiteman_AFB_Commissary.pdf	PDF	Aug 23, 2016
Attachment_1_-_DD_1707_Information_to_Offerors_or_Quoters_for_Whiteman_AFB_Commissary.doc	DOC document	Aug 23, 2016
Solicitation_HDEC08-16-R-0007_for_Whiteman_AFB_Commissary.pdf	PDF	Aug 23, 2016
Attachment_5_-_Volume_II_Technical_Capability__Personnel_Proposal_for_Whiteman_AFB_Commissary.doc	DOC document	Aug 23, 2016
Attachment_3_-_Collective_Bargaining_Agreement_(CBA)_effective_Feb_1_2016-_Jan_31_2017_for_Whiteman_AFB_Commissary.pdf	PDF	Aug 23, 2016

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-16-R-0007

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-16-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	Direct Labor, Health & Welfare Sheet
RS_PAGE2	Fit Columns to Page	E:A1..E:A8	Portrait	Holidays & Vacations Sheet
RS_PAGE3	Fit Columns to Page	E:A1..E:A8	Portrait	Fringe Calculations Sheet
RS_PAGE4	Fit Columns to Page	E:I1..E:I19	Portrait	Supplies & Equipment Sheet
RS_PAGE5	Fit Columns to Page	None	Portrait	Grocery Summary Sheet
GRANDS	Fit Columns to Page	None	Portrait	Totals of Shelf Stocking, Custodial and RSH
GRAND_TOTALS	Fit Columns to Page	None	Landscape	5 year totals of Shelf Stocking, Custodial and RSH
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-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007
COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman 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		(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)						(The elements listed below are SAMPLES and are not considered
=	=	=	=	=								a requirement of the solicitation.)
Stocker		0	$16.70	$0														COST ELEMENT				DOLLARS
Project Manager		0	0.00	$0														=				=
		0	0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
		0	0.00	$0		Labor Categories					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
-	-	-		-		Project Manager			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							0		$0.00	Cart, Bushel			0	0.00	0.00
		=							0		$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	$4.27	$0											0	0.00	0.00
Project Manager		0	$4.27	$0								=	=	=	=	=	=	PROFIT	0.00%			$0
		0	$4.27	$0								TOTALS			0	0.00	$0.00
		0	$4.27	$0								=	=	=	=	=		=				=
		0	$4.27	$0														GRAND TOTAL				$0
		0	$4.27	$0														=		=	=	=
-	-	-		-																ANNUAL CASES		307,320
TOTALS		0		$0																=	=	=
=	=	=		=																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-
Project Manager		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	$4.27	$0
Project Manager		0	$4.27	$0
		0	$4.27	$0
		0	$4.27	$0
		0	$4.27	$0
		0	$4.27	$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-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007
COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman 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		(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)						(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Forklift Operator		0	$22.77	$0														COST ELEMENT				DOLLARS
Material Handler Laborer		0	$19.17	$0														=				=
Project Manager		0	$0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
		0	$0.00	$0		Labor Categories					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
-	-	-		-		Material Handler Laborer			0		$0.00	Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0		Project Manager			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							0		$0.00	Cart, Bushel			0	0.00	0.00
		=							0		$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	$4.27	$0											0	0.00	0.00
Material Handler Laborer		0	$4.27	$0											0	0.00	0.00	PROFIT	0.00%			$0
Project Manager		0	$4.27	$0											0	0.00	0.00
		0	$4.27	$0											0	0.00	0.00	=				=
		0	$4.27	$0											0	0.00	0.00	GRAND TOTAL				$0
		0	$4.27	$0											0	0.00	0.00	=		=	=	=
-	-	-		-											0	0.00	0.00			=	=	=
TOTALS		0		$0											0	0.00	0.00			MO. PRICE		$0
=	=	=		=											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
Forklift Operator		10	0	$0.00	(Work hours divided by ((2080 hours-										0	0.00	0.00
Material Handler Laborer		10	0	$0.00	(Holidays/Sick+ Vacations)8)))							=	=	=	=		=
Project Manager		10	0	$0.00	((Closed Holidays8Hourly rate)+							TOTALS			0		$0.00
		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	$4.27	$0
Material Handler Laborer		0	$4.27	$0
Project Manager		0	$4.27	$0
		0	$4.27	$0
		0	$4.27	$0
		0	$4.27	$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-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007					SOLICITATION NUMBER:	HDEC08-16-R-0007
COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman AFB					COMMISSARY:	Whiteman 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		(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)						(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=								a requirement of the solicitation.)
Janitor (Custodian)		0	$15.91	$0														COST ELEMENT				DOLLARS
Meatroom Custodian		0	$15.91	$0														=				=
Project Manager		0	$0.00	$0					# of Employees		Extended				Qty.	Unit/	Extended	DIRECT LABOR				$0
		0	$0.00	$0		Labor Categories					Price	Elements			Yearly	Price	Price	DIRECT LABOR HEALTH & WELFARE				$0
		0	$0.00	$0		=	=	=	=	=	=	=	=	=	=	=	=	=				=
		0	$0.00	$0		Janitor (Custodian)			0		$0.00	Bowl, Cleaner			0	0.00	$0.00	SUB-TOTAL				$0
-	-	-		-		Meatroom Custodian			0		$0.00	Cartridges			0	0.00	$0.00
TOTALS		0		$0		Project Manager			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							0		$0.00	Disinfectant			0	0.00	0.00
		=							0		$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
Janitor (Custodian)		0	$4.27	$0								Masks			0	0.00	0.00
Meatroom Custodian		0	$4.27	$0								Mop Head, Wet			0	0.00	0.00	PROFIT	0.00%			$0
Project Manager		0	$4.27	$0								Neutralizer			0	0.00	0.00
		0	$4.27	$0								Pads, Aqua 27"			0	0.00	0.00	=				=
		0	$4.27	$0								Pads, Buffing			0	0.00	0.00	GRAND TOTAL				$0
		0	$4.27	$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 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
Janitor (Custodian)		10	10	$0.00	(Work hours divided by ((2080 hours-							Sponges			0	0.00	0.00
Meatroom Custodian		10	10	$0.00	(Holidays/Sick+ Vacations)8)))							Spray Bottle			0	0.00	0.00
Project Manager		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
Janitor (Custodian)		0	$4.27	$0								Carpet Extractor			0	0.00	0.00
Meatroom Custodian		0	$4.27	$0								Floor Scrubber, Low Speed			0	0.00	0.00
		0	$4.27	$0								Scrubber, 20"			0	0.00	0.00
		0	$4.27	$0								Scrubber, Auto			0	0.00	0.00
		0	$4.27	$0								Vacuum, Wet/Dry			0	0.00	0.00
		0	$4.27	$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-16-R-0007
COMMISSARY:	Whiteman AFB
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
=		=

Click Here to Print

5 Yr. Totals

	Attachment 4
SOLICITATION NUMBER:	HDEC08-16-R-0007
COMMISSARY:	Whiteman 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	0	0	0	0	0
=	=	=	=	=	=	=
	Attachment 4
SOLICITATION NUMBER:	HDEC08-16-R-0007
COMMISSARY:	Whiteman 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

Stocker Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman 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

(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)

(The elements listed below are SAMPLES and are not considered

a requirement of the solicitation.)

Stocker

$16.70

COST ELEMENT

DOLLARS

# of Employees

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$16.70

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$4.27

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Stocker

$0.00

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$20.97

are not included in the loaded

0.00

$0.00

TOTALS

$16.70

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$0.90

0.00

HOL & VAC. HEALTH & WELFARE

$0.17

Indirect Labor Hours (Non-Working)

0.00

SUB-TOTAL

$1.07

Direct Labor Hours (Productive/Working)

0.00

FRINGES

$1.69

0.00

PENSION

$0.00

TOTALS

$0.00

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$23.73

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Stocker

$4.27

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$23.73

TOTALS

$4.27

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Stocker

$0.90

(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.90

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Stocker

$4.27

$0.17

TOTALS

$0.17

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$16.70

DIRECT HEALTH & WELFARE COSTS

$4.27

HOLIDAYS/SICK/VACATION

$0.90

PENSION

$0.00

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.17

SUBTOTAL

$22.04

FICA

7.65%

$1.69

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.69

Click Here to Print

FO Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman 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

(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)

(The elements listed below are SAMPLES and are not considered

a requirement of the solicitation.)

Forklift Operator

$22.77

COST ELEMENT

DOLLARS

# of Employees

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$22.77

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$4.27

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Forklift Operator

$0.00

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$27.04

$0.00

are not included in the loaded

0.00

$0.00

TOTALS

$22.77

$0.00

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$1.23

$0.00

0.00

HOL & VAC. HEALTH & WELFARE

$0.17

Indirect Labor Hours (Non-Working)

$0.00

0.00

$0.00

0.00

SUB-TOTAL

$1.40

Direct Labor Hours (Productive/Working)

$0.00

0.00

$0.00

0.00

FRINGES

$2.18

0.00

PENSION

$0.00

TOTALS

$0.00

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$30.62

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Forklift Operator

$4.27

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$30.62

TOTALS

$4.27

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Forklift Operator

$1.23

(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.23

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Forklift Operator

$4.27

$0.17

TOTALS

$0.17

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$22.77

DIRECT HEALTH & WELFARE COSTS

$4.27

HOLIDAYS/SICK/VACATION

$1.23

PENSION

$0.00

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.17

SUBTOTAL

$28.44

FICA

7.65%

$2.18

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.18

Click Here to Print

Material Handler Loaded Wage

Attachment 4

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman 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

(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)

(The elements listed below are SAMPLES and are not considered

a requirement of the solicitation.)

Material Handling Laborer

$19.17

COST ELEMENT

DOLLARS

# of Employees

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$19.17

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$4.27

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Material Handling Laborer

$0.00

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$23.44

$0.00

are not included in the loaded

0.00

$0.00

TOTALS

$19.17

$0.00

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$1.04

$0.00

0.00

HOL & VAC. HEALTH & WELFARE

$0.17

Indirect Labor Hours (Non-Working)

$0.00

0.00

$0.00

0.00

SUB-TOTAL

$1.21

Direct Labor Hours (Productive/Working)

$0.00

0.00

$0.00

0.00

FRINGES

$1.89

0.00

PENSION

$0.00

TOTALS

$0.00

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$26.53

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Material Handling Laborer

$4.27

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$26.53

TOTALS

$4.27

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Material Handling Laborer

$1.04

(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.04

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Material Handling Laborer

$4.27

$0.17

TOTALS

$0.17

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$19.17

DIRECT HEALTH & WELFARE COSTS

$4.27

HOLIDAYS/SICK/VACATION

$1.04

PENSION

$0.00

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.17

SUBTOTAL

$24.65

FICA

7.65%

$1.89

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.89

Click Here to Print

Custodian Loaded Wage Rate

Attachment 4

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

SOLICITATION NUMBER:

HDEC08-16-R-0007

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

COMMISSARY:

Whiteman AFB

CONTRACTOR NAME:

Janitor 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

(Article 42 - $70.00/week per Bargaining Union Employee working more than 20 hours/week)

(The elements listed below are SAMPLES and are not considered

a requirement of the solicitation.)

Custodian

$15.91

COST ELEMENT

DOLLARS

# of Employees

Extended

Qty.

Unit/

Extended

DIRECT LABOR

$15.91

NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO

Labor Categories

Price

Elements

Yearly

Price

DIRECT LABOR HEALTH & WELFARE

$4.27

CALCULATE THE LOADED HOURLY RATE. PROCEED

TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES

Custodian

$0.00

Supplies and Equipment Costs

0.00

$0.00

SUB-TOTAL

$20.18

$0.00

are not included in the loaded

0.00

$0.00

TOTALS

$15.91

$0.00

rate for Store Worker I

0.00

HOLIDAYS/SICK/VACATIONS

$0.86

$0.00

0.00

HOL & VAC. HEALTH & WELFARE

$0.17

Indirect Labor Hours (Non-Working)

$0.00

0.00

$0.00

0.00

SUB-TOTAL

$1.03

Direct Labor Hours (Productive/Working)

$0.00

0.00

$0.00

0.00

FRINGES

$1.62

0.00

PENSION

$0.00

TOTALS

$0.00

0.00

Direct Labor Health and Welfare

0.00

EQUIPMENT & SUPPLIES

$0.00

0.00

H&W

0.00

SUB-TOTAL

$22.83

COST ELEMENT

Hours

Rates

Cost

0.00

G&A

0.00%

$0.00

Custodian

$4.27

0.00

PROFIT

0.00%

$0.00

TOTALS

0.00

$0.00

GRAND TOTAL

$22.83

TOTALS

$4.27

Holidays, Sick and Vacations

Holidays, Sick,

Sick/

Vacations

COST ELEMENT

Holidays

Vacations

Dollars

Custodian

$0.86

(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.86

Holidays and Vacations Health & Welfare

Holidays/Sick/

H&W

COST ELEMENT

Vacations

Rates

Cost

Custodian

$4.27

$0.17

TOTALS

$0.17

FRINGE CALCULATIONS

COST ELEMENT

DOLLARS

DIRECT LABOR COST

$15.91

DIRECT HEALTH & WELFARE COSTS

$4.27

HOLIDAYS/SICK/VACATION

$0.86

PENSION

$0.00

HOLIDAYS AND VACATIONS HEALTH & WELFARE

$0.17

SUBTOTAL

$21.21

FICA

7.65%

$1.62

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.62

Click Here to Print

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