Attachment_3-Volume_1-Cost_Breakout_3_22_19.xlsx

XLSX spreadsheet 142 KB Posted Apr 30, 2019

Attached to: Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations for the Lemoore NAS, CA Commissary
Solicitation number: HDEC08-19-R-0004
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document provides details for a federal contract opportunity to provide shelf stocking, receiving/storage/holding area (RSHA), and custodial operations services at the Defense Commissary Agency Lemoore Naval Air Station Commissary in Lemoore, California. The base period of performance is from May 1, 2019 through April 30, 2020 with four one-year option periods. This is a 100% set-aside for women-owned small businesses with a NAICS code of 561990 and $11 million business size standard. The solicitation and attachments will be available on February 25, 2019 on FedBizOpps with a closing date of around April 29, 2019. A site visit is tentatively scheduled for March 18, 2019. Offerors without the capability to download files can request a paper copy. Requests must be sent to the specified Defense Commissary Agency contact by the stated means. All responsible sources may submit a proposal which will be considered.

From the source

Attachment 3-Cost Breakout

View the file

Other files

File	Type	Posted
HDEC08.19.R.0004_Solicitation.pdf	PDF	Apr 30, 2019
Attachment_1-_Performance_Work_Statement_(PWS)_Dated_1.16.2019.docx	DOCX document	Apr 30, 2019
Attachment_6_Past_Performance_-_Volume_III.DOC	DOC document	Apr 30, 2019
Attachment_5_-Volume_II_TDWS__DLS_-_Lemoore.xls	XLS spreadsheet	Apr 30, 2019
Attachment_4_Volume_II_Technical_Capability.doc	DOC document	Apr 30, 2019
Attachment_2-_Wage_Determination_2015-5609_Revision_8_dated_12-26-2018.docx	DOCX document	Apr 30, 2019

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-19-R-0004

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

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

SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:	0	CONTRACTOR NAME:	0

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.)
Store Worker I		0	12.21	$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 & WELFARE				$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 & WELFARE				$0.00
Indirect Labor Hours (Non-Working)		0				Tape Masking			0	0.00	$0.00		=				=
		=				Back Brace			0	0.00	$0.00		SUB-TOTAL				$0.00
Direct Labor Hours (Productive/Working)		0				Cart, Bushel			0	0.00	$0.00
		=				Cart, Stocking			0	0.00	$0.00		FRINGES				$0.00
						Pallet Jacks			0	0.00	$0.00
Direct Labor Health & Welfare									0	0.00	$0.00		EQUIPMENT & SUPPLIES				$0.00
									0	0.00	$0.00						-
			H&W	H&W					0	0.00	$0.00		SUB-TOTAL				$0.00
COST ELEMENT		Hours X	Rates =	Cost					0	0.00	$0.00						=
=	=	=	=	=					0	0.00	$0.00		G&A	0.00%			$0.00
Store Worker I		0	4.18	$0.00					0	0.00	$0.00
Project Manager		0	4.18	$0.00					0	0.00	$0.00		PROFIT	0.00%			$0.00
		0	4.18	$0.00					0	0.00	$0.00
		0	4.18	$0.00					0	0.00	$0.00		=				=
		0	4.18	$0.00					0	0.00	$0.00		GRAND TOTAL				$0.00
		0	4.18	$0.00					0	0.00	$0.00		=		=	=	=
-	-	-		-					0	0.00	$0.00				ANNUAL CASES		251,028
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
Store Worker I		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 & Welfare

		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Store Worker I		0	4.18	$0.00
Project Manager		0	4.18	$0.00
		0	4.18	$0.00
		0	4.18	$0.00
		0	4.18	$0.00
		0	4.18	$0.00
-	-	-		-
TOTALS		0		$0.00
=	=	=		=
FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$0.00
DIRECT LABOR HEALTH & WELFARE					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$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
=	=	=	=	=	=

Click Here to Print

RSH

SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:	0	CONTRACTOR NAME:	0	CONTRACTOR NAME:	0
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.)
Material Handling Laborer		0	12.07	$0.00								COST ELEMENT				DOLLARS
Forklift Operator		0	13.60	$0.00								=				=
Warehouse Specialist		0	13.60	$0.00					Qty.	Unit/	Extended	DIRECT LABOR				0.00
Project Manager		0	0.00	$0.00		Elements			Yearly	Price	Price	HEALTH & WELFARE				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 & WELFARE				0.00
Indirect Labor Hours (Non-Working)		0				Tape Masking			0	0.00	0.00	=				=
		=				Back Brace			0	0.00	0.00	SUB-TOTAL				0.00
Direct Labor Hours (Productive/Working)		0				Cart, Bushel			0	0.00	0.00
		=				Cart, Stocking			0	0.00	0.00	FRINGES				0.00
						Pallet Jacks			0	0.00	0.00
Direct Labor Health & Welfare									0	0.00	0.00	EQUIPMENT & SUPPLIES				0.00
									0	0.00	0.00					-
			H&W	H&W					0	0.00	0.00	SUB-TOTAL				0.00
COST ELEMENT		Hours X	Rates =	Cost					0	0.00	0.00					=
=	=	=	=	=					0	0.00	0.00	G&A	0.00%			0.00
Material Handling Laborer		0	4.18	$0.00					0	0.00	0.00
Forklift Operator		0	4.18	$0.00					0	0.00	0.00	PROFIT	0.00%			0.00
Warehouse Specialist		0	4.18	$0.00					0	0.00	0.00
Project Manager		0	4.18	$0.00					0	0.00	0.00	=				=
		0	4.18	$0.00					0	0.00	0.00	GRAND TOTAL				0.00
		0	4.18	$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
Material Handling Laborer		10	0	$0.00	( (Holidays + Vacations) * 8)				0	0.00	0.00
Forklift Operator		10	0	$0.00	times Work Hours	=	=	=	=		=
Warehouse Specialist		10	0	$0.00	divided by ( 2080 hours -	TOTALS			0		$0.00
Project Manager		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 & Welfare

		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates =	Cost
=	=	=	=	=
Material Handling Laborer		0	4.18	$0.00
Forklift Operator		0	4.18	$0.00
Warehouse Specialist		0	4.18	$0.00
Project Manager		0	4.18	$0.00
		0	4.18	$0.00
		0	4.18	$0.00
-	-	-		-
TOTALS		0		$0.00
=	=	=		=
FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR					$0.00
DIRECT LABOR HEALTH & WELFARE					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$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-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:	0	CONTRACTOR NAME:	0	CONTRACTOR NAME:	0
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.)
Janitor		0	12.46	$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 & WELFARE				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 & WELFARE				0.00
Indirect Labor Hours (Non-Working)		0				Cleaner, Glass			0	0.00	0.00	=				=
		=				Cleaner, Neutral			0	0.00	0.00	SUB-TOTAL				0.00
Direct Labor Hours (Productive/Working)		0				Disinfectant			0	0.00	0.00
		=				Dust Cloths			0	0.00	0.00	FRINGES				0.00
						Dust Mop Heads			0	0.00	0.00
Direct Labor Health & Welfare						Floor Finish			0	0.00	0.00	EQUIPMENT & SUPPLIES				0.00
						Floor Sealer			0	0.00	0.00					-
			H&W	H&W		Floor Stripper			0	0.00	0.00	SUB-TOTAL				0.00
COST ELEMENT		Hours X	Rates =	Cost		Gloves			0	0.00	0.00					=
=	=	=	=	=		Gloves, Latex			0	0.00	0.00	G&A	0.00%			0.00
Janitor		0	4.18	$0.00		Kintowel Wiper			0	0.00	0.00
Project Manager		0	4.18	$0.00		LiquidLive			0	0.00	0.00	PROFIT	0.00%			0.00
		0	4.18	$0.00		Masks			0	0.00	0.00
		0	4.18	$0.00		Mop Head, Wet			0	0.00	0.00	=				=
		0	4.18	$0.00		Neutralizer			0	0.00	0.00	GRAND TOTAL				0.00
		0	4.18	$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
Janitor		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 & Welfare						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	H&W		Buffer, High Speed			0	0.00	0.00
COST ELEMENT		Hours X	Rates =	Cost		Burnisher High Speed			0	0.00	0.00
=	=	=	=	=		Burnisher, 21" Propane			0	0.00	0.00
Janitor		0	4.18	$0.00		Caddy, Maid			0	0.00	0.00
Project Manager		0	4.18	$0.00		Carpet Extractor			0	0.00	0.00
		0	4.18	$0.00		Floor Scrubber, Low Speed			0	0.00	0.00
		0	4.18	$0.00		Scrubber, 20"			0	0.00	0.00
		0	4.18	$0.00		Scrubber, Auto			0	0.00	0.00
		0	4.18	$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 & WELFARE					$0.00
HOLIDAYS, SICK, AND VACATIONS					$0.00
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$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-19-R-0004
COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:	0
BASE YEAR GRAND TOTALS

DOLLAR TOTALS

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

COST ELEMENT	DOLLARS
=	=
DIRECT LABOR	0.00
DIRECT LABOR HEALTH & WELFARE	0.00
=	=
TOTAL	0.00

HOLIDAYS, SICK & VACATIONS	0.00
HOL, SICK & VAC. HEALTH & WELFARE	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
=	=

5 Yr. Totals

SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:	0
	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
DIRECT LABOR HEALTH & WELFARE	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

HOLIDAYS, SICK & VACATIONS	0.00	0.00	0.00	0.00	0.00	0.00
HOL, SICK & VAC. HEALTH & WELFARE	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-19-R-0004
COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:	0
	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
=	=	=	=	=	=

Click Here to Print

Shelf Stocker Loaded Wage Rate

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:
Shelf Stocker Loaded Wage Rate Work Sheet		Shelf Stocker Loaded Wage Rate Work Sheet		Shelf Stocker Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					Shelf Stocking Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Store Worker I		1	12.21	$12.21							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$12.21
CALCULATE THE LOADED HOURLY RATE. PROCEED											DIRECT LABOR HEALTH & WELFARE				$4.18
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
								Qty.	Unit/	Extended	SUB-TOTAL				$16.39
-	-	-		-	Elements			Yearly	Price	Price
TOTALS		1		$12.21	=	=	=	=	=	=	HOLIDAYS, SICK & VACATIONS				$0.66
=	=	=		=	Supplies and Equipment Costs			0	0.00	$0.00	HOL, SICK & VAC. HEALTH & WELFARE				$0.17
Indirect Labor Hours (Non-Working)					are not included in the loaded			0	0.00	$0.00	=				=
		=			rate for Store Worker I			0	0.00	0.00	SUB-TOTAL				$0.83
Direct Labor Hours (Productive/Working)		1						0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.32
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health and Welfare								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$18.53
			H&W	H&W				0	0.00	0.00					=
COST ELEMENT		Hours	Rates	Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Store Worker I		1	4.18	$4.18				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				$18.53
								0	0.00	0.00	=		=	=	=
0					=	=	=	=	=	=
-	-	-		-	TOTALS					$0.00
TOTALS		1		$4.18	=	=	=	=	=
=	=	=		=

Holidays, Sick, and Vacations
				Holidays/
			Sick/	Sick/Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Store Worker I		10	0	$0.66
					(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		$0.66
=	=	=		=

Holidays, Sick, and Vacations Health & Welfare
		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates	Cost
=	=	=	=	=
Store Worker I		0.0	4.18	$0.17

-	-	-	-
TOTALS		0	$0.17
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$12.21
DIRECT HEALTH & WELFARE COSTS					$4.18
HOLIDAYS, SICK, AND VACATIONS					$0.66
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$0.17
-	-	-	-	-	-
SUBTOTAL					$17.22
=	=	=	=	=	=

FICA	X	7.65%		=	$1.32
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.32
=	=	=	=	=	=

Material Handler Loaded Wage

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

MATERIAL HANDLER LOADED WAGE RATE WORK SHEET MATERIAL HANDLER LOADED WAGE RATE WORK SHEET MATERIAL HANDLER LOADED WAGE RATE WORK SHEET

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					R/S/H Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Material Handler		1	12.07	$12.07							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$12.07
CALCULATE THE LOADED HOURLY RATE. PROCEED											DIRECT LABOR HEALTH & WELFARE				$4.18
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$16.25
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$12.07	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$0.65
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH & WELFARE				$0.17
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.82
Direct Labor Hours (Productive/Working)		1			rate for Material Handler			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.31
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health and Welfare								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$18.37
			H&W	H&W				0	0.00	0.00					=
COST ELEMENT		Hours	Rates	Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Material Handler		1	4.18	$4.18				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				$18.37
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$4.18	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

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

Holidays, Sick, and Vacations Health & Welfare
		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates	Cost
=	=	=	=	=
Material Handler		0	4.18	$0.17

-	-	-	-
TOTALS		0	$0.17
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$12.07
DIRECT HEALTH & WELFARE COSTS					$4.18
HOLIDAYS, SICK, AND VACATIONS					$0.65
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$0.17
-	-	-	-	-	-
SUBTOTAL					$17.07
=	=	=	=	=	=

FICA	X	7.65%		=	$1.31
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.31
=	=	=	=	=	=

Forklift Operator Loaded Wage

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					R/S/H Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Forklift Operator		1	13.60	$13.60							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$13.60
CALCULATE THE LOADED HOURLY RATE. PROCEED											DIRECT LABOR HEALTH & WELFARE				$4.18
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$17.78
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$13.60	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$0.73
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH & WELFARE				$0.17
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.90
Direct Labor Hours (Productive/Working)		1			rate for Forklift Operator			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.43
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health and Welfare								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$20.11
			H&W	H&W				0	0.00	0.00					=
COST ELEMENT		Hours	Rates	Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Forklift Operator		1	4.18	$4.18				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				$20.11
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$4.18	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

Holidays, Sick, and Vacations
				Holidays/
			Sick/	Sick/Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Forklift Operator		10	0	$0.73
					(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.73
=	=	=		=

Holidays, Sick, and Vacations Health & Welfare
		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates	Cost
=	=	=	=	=
Forklift Operator		0	4.18	$0.17

-	-	-	-
TOTALS		0	$0.17
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$13.60
DIRECT HEALTH & WELFARE COSTS					$4.18
HOLIDAYS, SICK, AND VACATIONS					$0.73
HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE					$0.17
-	-	-	-	-	-
SUBTOTAL					$18.68
=	=	=	=	=	=

FICA	X	7.65%		=	$1.43
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.43
=	=	=	=	=	=

Warehouse Spec Loaded Wage Rate

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Warehouse Specialist Loaded Wage Rate Work Sheet Warehouse Specialist Loaded Wage Rate Work Sheet 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
=	=	=	=	=
Warehouse Specialist		1	13.60	$13.60							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$13.60
CALCULATE THE LOADED HOURLY RATE. PROCEED											DIRECT LABOR HEALTH & WELFARE				$4.18
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$17.78
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$13.60	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$0.73
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH & WELFARE				$0.17
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.90
Direct Labor Hours (Productive/Working)		1			rate for Forklift Operator			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.43
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health and Welfare								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$20.11
			H&W	H&W				0	0.00	0.00					=
COST ELEMENT		Hours	Rates	Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Warehouse Specialist		1	4.18	$4.18				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				$20.11
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$4.18	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

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

Holidays, Sick, and Vacations Health & Welfare
		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates	Cost
=	=	=	=	=
Warehouse Specialist		0	4.18	$0.17

-	-	-	-
TOTALS		0	$0.17
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$13.60
DIRECT HEALTH & WELFARE COSTS					$4.18
HOLIDAYS/SICK/VACATION					$0.73
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.17
-	-	-	-	-	-
SUBTOTAL					$18.68
=	=	=	=	=	=

FICA	X	7.65%		=	$1.43
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.43
=	=	=	=	=	=

Janitor Loaded Wage Rate

	Attachment 3		Attachment 3		Attachment 3
SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004	SOLICITATION NUMBER:	HDEC08-19-R-0004
COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS	COMMISSARY:	Lemoore NAS
CONTRACTOR NAME:		CONTRACTOR NAME:		CONTRACTOR NAME:

Janitor Loaded Wage Rate Work Sheet Janitor Loaded Wage Rate Work Sheet Janitor Loaded Wage Rate Work Sheet

Direct Labor					Contractor Proposed							DOLLAR TOTALS
					Custodial Supplies & Equipment							================
			WD
COST ELEMENT		Hours X	Rates =	Labor Cost
=	=	=	=	=
Janitor		1	12.46	$12.46							COST ELEMENT				DOLLARS
											=				=
NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO											DIRECT LABOR				$12.46
CALCULATE THE LOADED HOURLY RATE. PROCEED											DIRECT LABOR HEALTH & WELFARE				$4.18
TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES											=				=
											SUB-TOTAL				$16.64
-	-	-		-				Qty.	Unit/	Extended
TOTALS		1		$12.46	Elements			Yearly	Price	Price	HOLIDAYS, SICK & VACATIONS				$0.67
=	=	=		=	=	=	=	=	=	=	HOL, SICK & VAC. HEALTH & WELFARE				$0.17
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.84
Direct Labor Hours (Productive/Working)		1			rate for Janitor			0	0.00	0.00
		=						0	0.00	0.00	FRINGES				$1.34
								0	0.00	0.00
								0	0.00	0.00	EQUIPMENT & SUPPLIES				$0.00
Direct Labor Health and Welfare								0	0.00	0.00					-
								0	0.00	0.00	SUB-TOTAL				$18.82
			H&W	H&W				0	0.00	0.00					=
COST ELEMENT		Hours	Rates	Cost				0	0.00	0.00	G&A	0.00%			$0.00
=	=	=	=	=				0	0.00	0.00
Janitor		1	4.18	$4.18				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				$18.82
								0	0.00	0.00	=		=	=	=
								0	0.00	0.00
-	-	-		-	=	=	=	=	=	=
TOTALS		1		$4.18	TOTALS					$0.00
=	=	=		=	=	=	=	=	=

Holidays, Sick, and Vacations
				Holidays/
			Sick/	Sick/Vacations
COST ELEMENT		Holidays	Vacations	Dollars
=	=	=	=	=
Janitor		10	0	$0.67
					(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.67
=	=	=		=

Holidays, Sick, and Vacations Health & Welfare
		Holidays/Sick/
		Vacations	H&W	H&W
COST ELEMENT		Hours X	Rates	Cost
=	=	=	=	=
Janitor		0	4.18	$0.17

-	-	-	-
TOTALS		0	$0.17
=	=	=	=

FRINGE CALCULATIONS

COST ELEMENT					DOLLARS
=	=	=	=	=	=
DIRECT LABOR COST					$12.46
DIRECT HEALTH & WELFARE COSTS					$4.18
HOLIDAYS/SICK/VACATION					$0.67
HOLIDAYS AND VACATIONS HEALTH & WELFARE					$0.17
-	-	-	-	-	-
SUBTOTAL					$17.48
=	=	=	=	=	=

FICA	X	7.65%		=	$1.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					$1.34
=	=	=	=	=	=

Sheet1

File details come from the government source that posted it. Updated Dec 27, 2023.