Attachment 3 - Volume I - Cost Breakout.xlsx

XLSX spreadsheet 90 KB Posted Jun 10, 2021

Attached to: Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations at the Davis-Monthan Air Force Base (AFB) Commissary
Solicitation number: HDEC08-21-R-0009
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 28, 2023

This document package includes a solicitation for shelf stocking, receiving/storage/holding area, and custodial operations services at the Davis-Monthan Air Force Base Commissary near Tucson, Arizona. The base period of performance is from March 1, 2022 through February 28, 2023 with four one-year option periods. This is a 100% set-aside for Service-Disabled Veteran-Owned Small Businesses as determined by the Small Business Administration. Services required include supervision, personnel, equipment, and supplies to perform shelf stocking, receiving, storage, holding area operations, and custodial services. A site visit is tentatively scheduled for June 17, 2021 at 10:00 a.m. at the commissary location. The solicitation number is HDEC08-21-R-0009 and will be posted to sam.gov on or around June 10, 2021. Interested parties should contact the points of contact listed for information on installation access for the site visit.

View the file

Other files

File	Type	Posted
Amendment 0002 - HDEC08-21-R-0009.pdf	PDF	Jun 25, 2021
Amendment 0001 - HDEC08-21-R-0009.pdf	PDF	Jun 10, 2021
SF33 - HDEC08-21-R-0009.pdf	PDF	Jun 10, 2021
Attachment 1 - Performance Work Statement - 5-7-2021.pdf	PDF	Jun 10, 2021
Attachment 6 - Volume III - Past Performance Information.docx	DOCX document	Jun 10, 2021
Attachment 2 - Collective Bargaining Agreement.pdf	PDF	Jun 10, 2021
Attachment 4 - Volume II-Techical Capability and Personnel Proposal.docx	DOCX document	Jun 10, 2021
Attachment 5 - Volume II-Typical Daily Work Schedule and Direct Labor Summ....xlsx	XLSX spreadsheet	Jun 10, 2021
Attachment 7 - Bereavement Leave Certification Form.docx	DOCX document	Jun 10, 2021

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 3

HDEC08-21-R-0009

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
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 , Custodial, and RSHA
GRAND_TOTALS	Fit Columns to Page	None	Landscape	5 year totals of Shelf Stocking , Custodial, and RSHA

Shelf Stocking

SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Shelf Stocking Operations Work Sheet Shelf Stocking Operations Work Sheet Shelf Stocking Operations Work Sheet

Direct Labor						Contractor Proposed								DOLLAR TOTALS
						Shelf Stocking Supplies & Equipment								================
			WDR
COST ELEMENT		Hours X	Rates =	Labor Cost		(The elements listed below are SAMPLES and are not considered
=	=	=	=	=		a requirement of the solicitation.)
Stock Clerk		0	20.83	$0.00									COST ELEMENT				DOLLARS
Project Manager		0	0.00	$0.00									=				=
		0	0.00	$0.00					Qty.	Unit/	Extended	`	DIRECT LABOR				$0.00
		0	0.00	$0.00		Elements			Yearly	Price	Price		HEALTH FUND & PENSION				$0.00
		0	0.00	$0.00		=	=	=	=	=	=		=				=
		0	0.00	$0.00		Blades, Carton Cutter			0	0.00	$0.00		SUB-TOTAL				$0.00
-	-	-		-		Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0		Dispenser, Tape			0	0.00	$0.00		HOLIDAYS, SICK & VACATIONS				$0.00
=	=	=		=		Safety Shoes			0	0.00	$0.00		HOL, SICK & VAC. HEALTH FUND & PENSION				$0.00
Indirect Labor Hours (Non-Working)		0				Tape Masking			0	0.00	$0.00		=				=
		=				Back Brace			0	0.00	$0.00		SUB-TOTAL				$0.00
Direct Labor Hours (Productive/Working)		0				Cart, Bushel			0	0.00	$0.00
		=				Cart, Stocking			0	0.00	$0.00		FRINGES				$0.00
						Pallet Jacks			0	0.00	$0.00
Direct Labor Health Fund & Pension									0	0.00	$0.00		EQUIPMENT & SUPPLIES				$0.00
									0	0.00	$0.00						-
			H&W $4.60	Health Fund/					0	0.00	$0.00		SUB-TOTAL				$0.00
COST ELEMENT		Hours X	Pension $4.10	Pension Cost					0	0.00	$0.00						=
=	=	=	=	=					0	0.00	$0.00		G&A	0.00%			$0.00
Stock Clerk		0	8.70	$0.00					0	0.00	$0.00
Project Manager		0	8.70	$0.00					0	0.00	$0.00		PROFIT	0.00%			$0.00
		0	8.70	$0.00					0	0.00	$0.00
		0	8.70	$0.00					0	0.00	$0.00		=				=
		0	8.70	$0.00					0	0.00	$0.00		GRAND TOTAL				$0.00
		0	8.70	$0.00					0	0.00	$0.00		=		=	=	=
-	-	-		-					0	0.00	$0.00				ANNUAL CASES		864,624
TOTALS		0		$0					0	0.00	$0.00				=	=	=
=	=	=		=					0	0.00	$0.00				CASE PRICE		0.0000
Holidays, Sick, and Vacations									0	0.00	$0.00				=	=	=
									0	0.00	$0.00
				Holidays/					0	0.00	$0.00
			Sick/	Sick/Vacations					0	0.00	$0.00
COST ELEMENT		Holidays	Vacations	Dollars					0	0.00	$0.00
=	=	=	=	=					0	0.00	$0.00
Stock Clerk		10	0	$0.00	( (Holidays + Vacations) * 8)				0	0.00	$0.00
Project Manager		10	0	$0.00	times Work Hours	=	=	=	=	=	=
		10	0	$0.00	divided by ( 2080 hours -	TOTALS			0		$0.00
		10	0	$0.00	( (Holidays + Vacations) * 8) )	=	=	=	=	=	=
		10	0	$0.00	times the hourly rate
		10	0	$0.00	in each category
-	-	-		-
TOTALS		60		$0
=	=	=		=
Holidays, Sick, and Vacations Health Fund & Pension

		Holidays/Sick/
		Vacations	H&W $4.60	Health Fund/
COST ELEMENT		Hours X	Pension $4.10	Pension Cost
=	=	=	=	=
Stock Clerk		0	8.70	$0.00
Project Manager		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
-	-	-		-
TOTALS		0		$0.00
=	=	=		=
FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$0.00
DIRECT LABOR HEALTH FUND & PENSION					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00

-	-	-	-	-	-
SUBTOTAL					$0.00
=	=	=	=	=	=

FICA	X	7.65%		=	$0.00
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					$0.00
=	=	=	=	=	=

RSH

SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:
R/S/H Operations Work Sheet		R/S/H Operations Work Sheet		R/S/H Operations Work Sheet

Direct Labor							Contractor Proposed					DOLLAR TOTALS
						R/S/H Supplies & Equipment						================
			WDR
COST ELEMENT		Hours X	Rates =	Labor Cost		(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=		a requirement of the solicitation.)
Forklift/Warehouse Specialist		0	19.45	$0.00								COST ELEMENT				DOLLARS
Project Manager		0	0.00	$0.00								=				=
		0	0.00	$0.00					Qty.	Unit/	Extended	DIRECT LABOR				0.00
		0	0.00	$0.00		Elements			Yearly	Price	Price	HEALTH FUND & PENSION				0.00
		0	0.00	$0.00		=	=	=	=	=	=	=				=
		0	0.00	$0.00		Blades, Carton Cutter			0	0.00	$0.00	SUB-TOTAL				0.00
-	-	-		-		Cutter, Carton			0	0.00	$0.00
TOTALS		0		$0.00		Dispenser, Tape			0	0.00	0.00	HOLIDAYS, SICK & VACATIONS				0.00
=	=	=		=		Safety Shoes			0	0.00	0.00	HOL, SICK & VAC. HEALTH FUND & PENSION				0.00
Indirect Labor Hours (Non-Working)		0				Tape Masking			0	0.00	0.00	=				=
		=				Back Brace			0	0.00	0.00	SUB-TOTAL				0.00
Direct Labor Hours (Productive/Working)		0				Cart, Bushel			0	0.00	0.00
		=				Cart, Stocking			0	0.00	0.00	FRINGES				0.00
						Pallet Jacks			0	0.00	0.00
Direct Labor Health Fund & Pension									0	0.00	0.00	EQUIPMENT & SUPPLIES				0.00
									0	0.00	0.00					-
			H&W $4.60	Health Fund/					0	0.00	0.00	SUB-TOTAL				0.00
COST ELEMENT		Hours X	Pension $4.10	Pension Cost					0	0.00	0.00					=
=	=	=	=	=					0	0.00	0.00	G&A	0.00%			0.00
Forklift/Warehouse Specialist		0	8.70	$0.00					0	0.00	0.00
Project Manager		0	8.70	$0.00					0	0.00	0.00	PROFIT	0.00%			0.00
		0	8.70	$0.00					0	0.00	0.00
		0	8.70	$0.00					0	0.00	0.00	=				=
		0	8.70	$0.00					0	0.00	0.00	GRAND TOTAL				0.00
		0	8.70	$0.00					0	0.00	0.00	=		=	=	=
-	-	-		-					0	0.00	0.00			MO. PRICE		0.00
TOTALS		0		$0.00					0	0.00	0.00			=	=	=
=	=	=		=					0	0.00	0.00
Holidays, Sick, and Vacations									0	0.00	0.00
									0	0.00	0.00
				Holidays/					0	0.00	0.00
			Sick/	Sick/Vacations					0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars					0	0.00	0.00
=	=	=	=	=					0	0.00	0.00
Forklift/Warehouse Specialist		10	0	$0.00	( (Holidays + Vacations) * 8)				0	0.00	0.00
Project Manager		10	0	$0.00	times Work Hours	=	=	=	=		=
		10	0	$0.00	divided by ( 2080 hours -	TOTALS			0		$0.00
		10	0	$0.00	( (Holidays + Vacations) * 8) )	=	=	=	=	=	=
		10	0	$0.00	times the hourly rate
		10	0	$0.00	in each category
-	-	-		-
TOTALS		60		$0
=	=	=		=
Holidays, Sick, and Vacations Health Fund & Pension

		Holidays/Sick/
		Vacations	H&W $4.60	Health Fund/
COST ELEMENT		Hours X	Pension $4.10	Pension Cost
=	=	=	=	=
Forklift/Warehouse Specialist		0	8.70	$0.00
Project Manager		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
		0	8.70	$0.00
-	-	-		-
TOTALS		0		$0.00
=	=	=		=
FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$0.00
DIRECT LABOR HEALTH FUND & PENSION					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00

-	-	-	-	-	-
SUBTOTAL					$0.00
=	=	=	=	=	=

FICA	X	7.65%		=	$0.00
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					$0.00
=	=	=	=	=	=

Custodial

SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:
Custodial Operations Work Sheet		Custodial Operations Work Sheet		Custodial Operations Work Sheet

Direct Labor						Contractor Proposed						DOLLAR TOTALS
						Custodial Supplies & Equipment						================
			WDR
COST ELEMENT		Hours X	Rates =	Labor Cost		(The elements listed below are SAMPLES and are not to be considered
=	=	=	=	=		a requirement of the solicitation.)
Custodian		0	17.00	$0.00								COST ELEMENT				DOLLARS
Project Manager		0	0.00	$0.00								=				=
		0	0.00	$0.00					Qty.	Unit/	Extended	DIRECT LABOR				0.00
		0	0.00	$0.00		Elements			Yearly	Price	Price	HEALTH FUND & PENSION				0.00
		0	0.00	$0.00		=	=	=	=	=	=	=				=
		0	0.00	$0.00		Bowl, Cleaner			0	0.00	$0.00	SUB-TOTAL				0.00
-	-	-		-		Cartridges			0	0.00	$0.00
TOTALS		0		$0.00		Cleaner, Carpet			0	0.00	0.00	HOLIDAYS, SICK & VACATIONS				0.00
=	=	=		=		Cleaner, Compound			0	0.00	0.00	HOL, SICK & VAC. HEALTH FUND & PENSION				0.00
Indirect Labor Hours (Non-Working)		0				Cleaner, Glass			0	0.00	0.00	=				=
		=				Cleaner, Neutral			0	0.00	0.00	SUB-TOTAL				0.00
Direct Labor Hours (Productive/Working)		0				Disinfectant			0	0.00	0.00
		=				Dust Cloths			0	0.00	0.00	FRINGES				0.00
						Dust Mop Heads			0	0.00	0.00
Direct Labor Health Fund & Pension						Floor Finish			0	0.00	0.00	EQUIPMENT & SUPPLIES				0.00
						Floor Sealer			0	0.00	0.00					-
			H&W $4.60	Health Fund/		Floor Stripper			0	0.00	0.00	SUB-TOTAL				0.00
COST ELEMENT		Hours X	Pension $4.10	Pension Cost		Gloves			0	0.00	0.00					=
=	=	=	=	=		Gloves, Latex			0	0.00	0.00	G&A	0.00%			0.00
Custodian		0	8.70	$0.00		Kintowel Wiper			0	0.00	0.00
Project Manager		0	8.70	$0.00		LiquidLive			0	0.00	0.00	PROFIT	0.00%			0.00
		0	8.70	$0.00		Masks			0	0.00	0.00
		0	8.70	$0.00		Mop Head, Wet			0	0.00	0.00	=				=
		0	8.70	$0.00		Neutralizer			0	0.00	0.00	GRAND TOTAL				0.00
		0	8.70	$0.00		Pads, Aqua 27"			0	0.00	0.00	=		=	=	=
-	-	-		-		Pads, Buffing			0	0.00	0.00			MONTHLY PRICE		0.00
TOTALS		0		$0.00		Pads, Doodle Bug			0	0.00	0.00			=	=	=
=	=	=		=		Polish, Furniture			0	0.00	0.00
Holidays, Sick, and Vacations						Polish, Metal			0	0.00	0.00
						Propane			0	0.00	0.00
				Holidays/		Rain Suit			0	0.00	0.00
			Sick/	Sick/Vacations		Respirators			0	0.00	0.00
COST ELEMENT		Holidays	Vacations	Dollars		Retainer			0	0.00	0.00
=	=	=	=	=		Safety Shoes			0	0.00	0.00
Custodian		10	0	$0.00	( (Holidays + Vacations) * 8)	Sanitizer, Compound D2			0	0.00	0.00
Project Manager		10	0	$0.00	times Work Hours	Soap, Hand, Liquid			0	0.00	0.00
		10	0	$0.00	divided by ( 2080 hours -	Sponges			0	0.00	0.00
		10	0	$0.00	( (Holidays + Vacations) * 8) )	Spray Bottle			0	0.00	0.00
		10	0	$0.00	times the hourly rate	Spray Bottle Trigger			0	0.00	0.00
		10	0	$0.00	in each category	Spray Buff			0	0.00	0.00
-	-	-		-		Toilet Tissue, 96rl			0	0.00	0.00
TOTALS		60		$0		Towels, Pop-Up			0	0.00	0.00
=	=	=		=		Trash Liners, Lg			0	0.00	0.00
						Trash Liners, Sm			0	0.00	0.00
Holidays, Sick, and Vacations Health Fund & Pension						Vaccuum Belts			0	0.00	0.00
						Visors			0	0.00	0.00
		Holidays/Sick/				Battery Charger			0	0.00	0.00
		Vacations	H&W $4.60	Health Fund/		Buffer, High Speed			0	0.00	0.00
COST ELEMENT		Hours X	Pension $4.10	Pension Cost		Burnisher High Speed			0	0.00	0.00
=	=	=	=	=		Burnisher, 21" Propane			0	0.00	0.00
Custodian		0	8.70	$0.00		Caddy, Maid			0	0.00	0.00
Project Manager		0	8.70	$0.00		Carpet Extractor			0	0.00	0.00
		0	8.70	$0.00		Floor Scrubber, Low Speed			0	0.00	0.00
		0	8.70	$0.00		Scrubber, 20"			0	0.00	0.00
		0	8.70	$0.00		Scrubber, Auto			0	0.00	0.00
		0	8.70	$0.00		Vacuum, Wet/Dry			0	0.00	0.00
-	-	-		-		Washer, Pressure			0	0.00	0.00
TOTALS		0		$0.00					0	0.00	0.00
=	=	=		=					0	0.00	0.00
						=	=	=	=	=	=
						TOTALS					$0.00
FRINGE CALCULATIONS						=	=	=	=	=	=

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$0.00
DIRECT LABOR HEALTH FUND & PENSION					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00

-	-	-	-	-	-
SUBTOTAL					$0.00
=	=	=	=	=	=

FICA	X	7.65%		=	$0.00
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					$0.00
=	=	=	=	=	=

Year Totals

SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:
BASE YEAR GRAND TOTALS

DOLLAR TOTALS

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

COST ELEMENT	DOLLARS
=	=
DIRECT LABOR	0.00
HEALTH FUND & PENSION	0.00
=	=
SUB-TOTAL	0.00

HOLIDAYS, SICK & VACATIONS	0.00
HOL, SICK & VAC. HEALTH FUND & PENSION	0.00
=	=
TOTAL	0.00

FRINGE CALCULATIONS 0.00

SUPPLIES & EQUIPMENT 0.00

SUB-TOTAL 0.00

G&A 0.00

PROFIT 0.00

=	=
GRAND TOTAL	0.00
=	=

Five Year Totals

SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary
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.00	0.00	0.00	0.00	0.00	0.00
HEALTH FUND & PENSION	0.00	0.00	0.00	0.00	0.00	0.00
=	=	=	=	=	=	=
SUB-TOTAL	0.00	0.00	0.00	0.00	0.00	0.00

HOLIDAYS, SICK & VACATIONS	0.00	0.00	0.00	0.00	0.00	0.00
HOL, SICK & VAC. HEALTH FUND & PENSION	0.00	0.00	0.00	0.00	0.00	0.00
=	=	=	=	=	=	=
TOTAL	0.00	0.00	0.00	0.00	0.00	0.00

FRINGE CALCULATIONS 0.00 0.00 0.00 0.00 0.00 0.00

SUPPLIES & EQUIPMENT 0.00 0.00 0.00 0.00 0.00 0.00

SUB-TOTAL 0.00 0.00 0.00 0.00 0.00 0.00

G&A 0.00 0.00 0.00 0.00 0.00 0.00

PROFIT 0.00 0.00 0.00 0.00 0.00 0.00

=	=	=	=	=	=	=
GRAND TOTAL	0.00	0.00	0.00	0.00	0.00	0.00
=	=	=	=	=	=	=

SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary
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 AND VACATIONS		0.00%	0.00%	0.00%	0.00%
HOLIDAYS AND VACATIONS. HEALTH & WELFARE		0.00%	0.00%	0.00%	0.00%
=	=	=	=	=	=
TOTAL
FRINGE CALCULATIONS		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
=	=	=	=	=	=

Stock Clerk Loaded Wage Rate

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:
Stock Clerk Loaded Wage Rate Work Sheet		Stock Clerk Loaded Wage Rate Work Sheet		Stock Clerk Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					Shelf Stocking Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Stock Clerk		1	20.83	$20.83							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$20.83
CALCULATE THE LOADED HOURLY RATE. PROCEED											HEALTH FUND & PENSION				$8.70
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
								Qty.	Unit/	Extended	SUB-TOTAL				$29.53
-	-	-		-	Elements			Yearly	Price	Price
TOTALS		1		$20.83	=	=	=	=	=	=	HOLIDAYS, SICK & VACATIONS				$1.12
=	=	=		=	Supplies and Equipment Costs			0	0.00	$0.00	HOL, SICK & VAC. HEALTH FUND & PENSION				$0.00
Indirect Labor Hours (Non-Working)					are not included in the loaded			0	0.00	$0.00	=				=
		=			rate for Stock Clerk			0	0.00	0.00	SUB-TOTAL				$1.12
Direct Labor Hours (Productive/Working)		1						0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$2.34
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health Fund & Pension								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$32.99
			H&W $4.60	Health Fund/				0	0.00	0.00					=
COST ELEMENT		Hours X	Pension $4.10	Pension Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Stock Clerk		1	8.70	$8.70				0	0.00	0.00	PROFIT	0.00%			$0.00
								0	0.00	0.00
								0	0.00	0.00	=				=
								0	0.00	0.00	GRAND TOTAL				$32.99
								0	0.00	0.00	=		=	=	=
0					=	=	=	=	=	=
-	-	-		-	TOTALS					$0.00
TOTALS		1		$8.70	=	=	=	=	=
=	=	=		=

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

Holidays, Sick, and Vacations Health Fund & Pension

		Holidays/Sick/
		Vacations	H&W $4.60	Health Fund/
COST ELEMENT		Hours X	Pension $4.10	Pension Cost
=	=	=	=	=
Stock Clerk		0.0	8.70	$0.00

-	-	-	-
TOTALS		0	$0.00
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$20.83
DIRECT LABOR HEALTH FUND & PENSION					$8.70
HOLIDAYS, SICK, AND VACATIONS					$1.12
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00
-	-	-	-	-	-
SUBTOTAL					$30.65
=	=	=	=	=	=

FICA	X	7.65%		=	$2.34
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.34
=	=	=	=	=	=

FO-Warehouse Loaded Wage

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Forklift/Warehouse Specialist Loaded Wage Rate Work Sheet Forklift/Warehouse Specialist Loaded Wage Rate Work Sheet Forklift/Warehouse Specialist Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					R/S/H Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Forklift/Warehouse Specialist		1	19.45	$19.45							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$19.45
CALCULATE THE LOADED HOURLY RATE. PROCEED											HEALTH FUND & PENSION				$8.70
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$28.15
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$19.45	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$1.05
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH FUND & PENSION				$0.00
Indirect Labor Hours (Non-Working)					Supplies and Equipment Costs			0	0.00	$0.00	=				=
		=			are not included in the loaded			0	0.00	$0.00	SUB-TOTAL				$1.05
Direct Labor Hours (Productive/Working)		1			rate for Forklift/Warehouse Specialist			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.89
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health Fund & Pension								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$31.09
			H&W $4.60	Health Fund/				0	0.00	0.00					=
COST ELEMENT		Hours X	Pension $4.10	Pension Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Forklift/Warehouse Specialist		1	8.70	$8.70				0	0.00	0.00	PROFIT	0.00%			$0.00
								0	0.00	0.00
								0	0.00	0.00	=				=
								0	0.00	0.00	GRAND TOTAL				$31.09
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$8.70	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

Holidays, Sick, and Vacations
				Holidays/
			Sick/	Sick/Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Forklift/Warehouse Specialist		10	0	$1.05
					(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.05
=	=	=		=

Holidays, Sick, and Vacations Health Fund & Pension

		Holidays/Sick/
		Vacations	H&W $4.60	Health Fund/
COST ELEMENT		Hours X	Pension $4.10	Pension Cost
=	=	=	=	=
Forklift/Warehouse Specialist		0	8.70	$0.00

-	-	-	-
TOTALS		0	$0.00
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$19.45
DIRECT LABOR HEALTH FUND & PENSION					$4.22
HOLIDAYS, SICK, AND VACATIONS					$1.05
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00
-	-	-	-	-	-
SUBTOTAL					$24.72
=	=	=	=	=	=

FICA	X	7.65%		=	$1.89
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.89
=	=	=	=	=	=

Custodian Loaded Wage Rate

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009	SOLICITATION NUMBER:	HDEC08-21-R-0009
COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary	COMMISSARY:	Davis-Monthan AFB Commissary
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Custodian Loaded Wage Rate Work Sheet Custodian Loaded Wage Rate Work Sheet Custodian Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					Custodial Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Custodian		1	17.00	$17.00							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$17.00
CALCULATE THE LOADED HOURLY RATE. PROCEED											HEALTH FUND & PENSION				$8.70
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$25.70
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$17.00	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$0.92
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH FUND & PENSION				$0.00
Indirect Labor Hours (Non-Working)					Supplies and Equipment Costs			0	0.00	$0.00	=				=
		=			are not included in the loaded			0	0.00	$0.00	SUB-TOTAL				$0.92
Direct Labor Hours (Productive/Working)		1			rate for Custodian			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$2.04
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health Fund & Pension								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$28.66
			H&W $4.60	Health Fund/				0	0.00	0.00					=
COST ELEMENT		Hours X	Pension $4.10	Pension Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Custodian		1	8.70	$8.70				0	0.00	0.00	PROFIT	0.00%			$0.00
								0	0.00	0.00
								0	0.00	0.00	=				=
								0	0.00	0.00	GRAND TOTAL				$28.66
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$8.70	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

Holidays, Sick, and Vacations
				Holidays/
			Sick/	Sick/Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Custodian		10	0	$0.92
					(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.92
=	=	=		=

Holidays, Sick, and Vacations Health Fund & Pension

		Holidays/Sick/
		Vacations	H&W $4.60	Health Fund/
COST ELEMENT		Hours X	Pension $4.10	Pension Cost
=	=	=	=	=
Custodian		0	8.70	$0.00

-	-	-	-
TOTALS		0	$0.00
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$17.00
DIRECT LABOR HEALTH FUND & PENSION					$8.70
HOLIDAYS, SICK, AND VACATIONS					$0.92
HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION					$0.00
-	-	-	-	-	-
SUBTOTAL					$26.62
=	=	=	=	=	=

FICA	X	7.65%		=	$2.04
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.04
=	=	=	=	=	=

File details come from the government source that posted it. Updated Jun 10, 2021.