Attachment 5 - Volume II - Direct and Indirect Labor Summary.xlsx

XLSX spreadsheet 60 KB Posted Sep 22, 2022

Attached to: FORT CARSON COMMISSARY, COLORADO SHELF STOCKING, RECEIVING/STORAGE/HOLDING AREA (RSHA), RESIDUAL GROCERY, AND CUSTODIAL OPERATIONS Federal contract opportunity
Solicitation number: HQC00822R0027
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a direct labor summary template and instructions for a federal contract solicitation to provide shelf stocking, receiving/storage/holding area, residual grocery, and custodial operations services at the Fort Carson Commissary in Colorado Springs, Colorado. The solicitation is issued by the Defense Commissary Agency and identifies the required yearly workloads in cases and square feet for shelf stocking, RSHA, and custodial services. Offerors are to insert their proposed productivity rates in cases or square feet per person per hour and the resulting total direct labor hours for each service function. Instructions specify that indirect supervision hours and the total direct and indirect labor hours must match those shown on the offeror's cost worksheets.

View the file

Other files for this federal contract opportunity

Other files attached to FORT CARSON COMMISSARY, COLORADO SHELF STOCKING, RECEIVING/STORAGE/HOLDING AREA (RSHA), RESIDUAL GROCERY, AND CUSTODIAL OPERATIONS, newest first.
File	Type	Posted
Fort_Carson_Solicitation_HQC00822R0027_Amendment_0004.pdf	PDF	Nov 14, 2022
AMENDMENT 0004 - Attachment 4 - Volume II - Technical Capability and Personnel.doc	DOC document	Nov 14, 2022
Fort Carson_Solicitation_HQC00822R0027_Amendment 0003.pdf	PDF	Oct 28, 2022
Amendment 0003 Attachment 3 - Volume I - Price Schedule-Cost Breakout.xls	XLS spreadsheet	Oct 28, 2022
Attachment 3 - Volume I - Price Schedule-Cost Breakout r1 - Revised.xls	XLS spreadsheet	Oct 27, 2022
Attachment 2 Collective Bargaining Agreement July 1 2022 through June 30 2025.pdf	PDF	Oct 27, 2022
Fort Carson - Solicitation HQC00822R0027 - Amendment 0002.pdf	PDF	Oct 27, 2022
HQC00822R0027_FORT_CARSON_SOLICITATION_Amendment_0001.pdf	PDF	Oct 25, 2022
Attachment 2 - Collective Bargaing Agreement.pdf	PDF	Sep 22, 2022
Attachment 4 - Volume II - Technical Capability and Personnel.doc	DOC document	Sep 22, 2022
Attachment 7 - Bereavement Leave Certification.doc	DOC document	Sep 22, 2022
Attachment 3 - Volume I - Price Schedule-Cost Breakout.xls	XLS spreadsheet	Sep 22, 2022
Attachment 6 - Past Performance Information.docx	DOCX document	Sep 22, 2022
Attachment 1 - Fort Carson - PWS 3.10.2022.docx	DOCX document	Sep 22, 2022
HQC00822R0027 (FORT CARSON) SOLICITATION.pdf	PDF	Sep 22, 2022

Show all 15

On GovTribe

Work with this file on GovTribe

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.

Direct Labor Summary (DLS)

(Enter data in cells with red font only.)
	Shelf Stocking Direct Labor
Night Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
722,412	0.00	ERROR:#DIV/0!
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
154,584	0.00	ERROR:#DIV/0!
Display Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
65,292	0.00	ERROR:#DIV/0!
Shelf Stocking Direct Labor Subtotal		Direct Productive Hrs Required	Total Annual Cases
		ERROR:#DIV/0!	942,288

Receiving/Storage/Holding Area Direct Labor
Offload for Government Receipt
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
942,288	0	ERROR:#DIV/0!
Transport
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
296,100	0	ERROR:#DIV/0!
Segregate and Sort
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
942,288	0	ERROR:#DIV/0!
Store
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
75,384	0	ERROR:#DIV/0!
Pull
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
75,384	0	ERROR:#DIV/0!
Receiving/Storage/Holding Area Direct Labor Subtotal		Direct Productive Hrs Required
		ERROR:#DIV/0!

	Custodial Direct Labor
Administrative/Store/Patron Area
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
19,024,552	0	ERROR:#DIV/0!
Receiving/Storage/Holding Area
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
7,615,032	0	ERROR:#DIV/0!
Meat Processing Area
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
906,448	0	ERROR:#DIV/0!
Outside Areas
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
12,473,434	0	ERROR:#DIV/0!
Day Custodial Requirements		Direct Productive Hrs Required
		0
Custodial Direct Labor Subtotal		Direct Productive Hrs Required
		ERROR:#DIV/0!

	Residual Grocery (Sections C4.3, C4.4, and C4.6)
	Shelf Stocking RG
	Shelf Stocking Fresh Eggs (Para 4.3.2.6.2)
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hours Required
	18,000	0	ERROR:#DIV/0!
	Special Promotional Sales (Para. 4.3.3.7.3.)
	Pallets per Year	Productivity Rate (pallets per person per productive hour)	Direct Productive Hrs Required
	3,000	0	ERROR:#DIV/0!
	Stock Availability Surveys (Para. 4.3.3.19.)
	Surveys per Year	Productivity Rate (surveys per person per productive hour)	Direct Productive Hours Required
	724	0	ERROR:#DIV/0!
	Review Signs Displayed at Off-Shelf Locations (Para. 4.3.3.21.1)
	Signs per Year	Productivity Rate (signs per person per productive hour)	Direct Productive Hrs Required
	868,800	0	ERROR:#DIV/0!
	Review Signs Displayed at Shelf Locations (Para. 4.3.3.21.2)
	Signs per Year	Productivity Rate (signs per person per productive hour)	Direct Productive Hrs Required
	6,000	0	ERROR:#DIV/0!
	Review Coupons (Para. 4.3.3.22.)
	Coupons per Year	Productivity Rate (reviews per person per productive hour)	Direct Productive Hrs Required
	6,000	0	ERROR:#DIV/0!
	Temperature Checks/Refrigeration Alarm System (Para. 4.3.3.24.)
	Occasions per year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required
	1,086	0	ERROR:#DIV/0!
	Returning Carts to Appropriate Locations (Para. 4.3.3.26.)
	Carts per year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required
	42,000	0	ERROR:#DIV/0!
	Receiving/Storage/Holding Area RG
	Transport Merchandise for Sidewalk Sales (Para. 4.4.2.4.)
	Cases per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required
	12,000	0	ERROR:#DIV/0!
	Transport Merchandise for Truckload Sales (Para 4.4.2.4)
	Cases per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required
	6,000	0	ERROR:#DIV/0!
	Pulling Special Orders (Para. 4.4.2.8.1.1.)
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	6,000	0	ERROR:#DIV/0!
	Pull Bags (Para 4.4.2.8.2)
	Bales/Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	7,440	0	ERROR:#DIV/0!
	Custodial RG
	Refrigerated Display Cases Cleaning/Sanitizing (Para. 16)
	Linear Feet per Year	Productivity Rate (linear ft per crew per productive hour)	Direct Productive Hrs Required (linear ft/productivity rate)
	8,308	0	ERROR:#DIV/0!
	Backup/Holding/Storage Areas Cleaning/Sanitizing (Para. 17)
	Square Feet per Year	Productivity Rate (square ft per crew per productive hour)	Direct Productive Hrs Required (linear ft/productivity rate)
	3,088,946	0	ERROR:#DIV/0!
	Residual Grocery Direct Labor Subtotal		Direct Productive Hrs Required
			ERROR:#DIV/0!
	Total Direct Productive Hours
			Direct Productive Hrs Required
			ERROR:#DIV/0!
	SUPERVISION HOURS (Indirect Labor)
	(Identify only those hours used exclusively in a supervisory capacity-DO NOT include hours spent performing direct labor tasks)
	Indirect Labor Requirements
(MUST match total indirect hours shown in the Volume I, Cost Breakout)	Indirect Hrs Required
			0

TOTAL SUPERVISION (Indirect Labor AND DIRECT HOURS
Direct/Indirect Labor Requirements
Direct/Indirect Hrs Required
	ERROR:#DIV/0!

&"Arial,Bold"&12&E Direct Labor Summary ATTACHMENT 4

HQC008-22-R-0027

DLS Instructions

DIRECT AND INDIRECT LABOR SUMMARY
	INSTRUCTIONS

1. Offeror. Use the name shown on the SF 33, block 15A.

2. Solicitation. HQC008-22-R-0027

3. Work Load. The yearly workload quantities are already shown on the form in

the left-handed column. Do not make any adjustments to the quantities shown.

Offerors are to insert their productivity rates and total direct labor hours for each

function only.

4. Productivity Rate. For shelf stocking and RSHA services, enter the

productivity rate in terms of cases per person per productive hour. For custodial,

enter the productivity rate in terms of square feet per crew per productive hour.

5. Coverage and Supervision. Input direct hours proposed only.

6. Total Productive Hours. Equals the total direct hours for shelf stocking,

RSHA, and custodial services combined.

7. Direct Productive Hours Proposed. Enter the total number of hours

shown for each function on your cost worksheets in this block. (Note: The

numbers shown in this block should match exactly the direct productive hours

shown on your cost worksheets.)

File details come from the government source that posted it. Updated Sep 22, 2022.