Attachment 5 - DLS and TDWS - Tyndall AFB.XLS

XLS spreadsheet 64 KB Posted Jun 24, 2021

Attached to: Tyndall AFB Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations
Solicitation number: HDEC08-21-R-0005
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains instructions and templates for a Direct Labor Summary and Typical Daily Work Schedule pertaining to a solicitation for Shelf Stocking, Receiving/Storage/Holding Area, and Custodial Operations services at Tyndall Air Force Base Commissary. Offerors are required to provide productivity rates and total direct labor hours for shelf stocking of various product categories on a yearly basis. For custodial services, offerors must specify productivity rates for cleaning various facility areas based on square footage. The Typical Daily Work Schedule template requires offerors to demonstrate their understanding of required staffing levels by job title, daily work shifts, number of employees, and scheduled versus break hours across management, stocking, receiving, and cleaning functions.

View the file

Other files

File	Type	Posted
Amendment 0006 - Tyndall AFB Solicitation HDEC0821R0005.pdf	PDF	Aug 27, 2021
PIEE_Solicitation_Module_Vendor_Access_Instructions.pdf	PDF	Aug 27, 2021
Amendment 0005 - Attachment 4 - Volume II - Technical Capability and Personnel - Tyndall AFB.doc	DOC document	Aug 26, 2021
Amendment 0005 - Tyndall AFB Solicitation HDEC0821R0005.pdf	PDF	Aug 26, 2021
Tyndall Solicitaton HDEC08-21-R-0005 Amendment 0004 Response to Questions.pdf	PDF	Aug 17, 2021
Tyndall Solicitation HDEC08-21-R-0005 Amendment 0003.pdf	PDF	Aug 17, 2021
Amendment 0003 - Attachment 4 - Volume II - Technical Capability and Personnel - Tyndall AFB.doc	DOC document	Aug 17, 2021
AMENDMENT 0002 - Attachment 3 Volume I - Cost Breakout - Tyndall AFB.XLS	XLS spreadsheet	Aug 3, 2021
Tyndall Solicitation HDEC08-21-R-0005 Amendment 0002.pdf	PDF	Aug 3, 2021
HDEC08-21-R-0005 Amendment 0001.pdf	PDF	Jul 30, 2021
Tyndall Solicitation HDEC08-21-R-0005.pdf	PDF	Jun 24, 2021
Attachment 4 - Volume II - Techical Capability and Personnel - Tyndall A....doc	DOC document	Jun 24, 2021
Attachment 6 - Volume III - Past Performance - Tyndall AFB.DOC	DOC document	Jun 24, 2021
Attachment 2 Wage Determination 2015-0037 Rev 8 dtd 3.17.2021.pdf	PDF	Jun 24, 2021
Attachment 3 Volume I - Cost Breakout - Tyndall AFB.XLS	XLS spreadsheet	Jun 24, 2021
Attachment 1 - Tyndall AFB PWS Dated 12.4.2020.doc	DOC document	Jun 24, 2021

Show all 16

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.

DLS Instructions

	DIRECT LABOR SUMMARY
		INSTRUCTIONS
1. Offeror. Use the name shown on the SF 33, block 15A.
2. Solicitation. HDEC08-21-R-0005.
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.
For residual grocery, enter the productivity rates in terms of cases per year;
surveys per year; signs per year; coupons per year; ocassions per year; linear feet
per year, etc.
5. Coverage and Supervision. Input direct hours proposed only.
6. Total Productive Hours. Equals the total direct hours for shelf stocking,
RSHA, residual grocery 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.)

Direct Labor Summary

DIRECT LABOR		Commissary: Tyndall AFB, FL
(Identify only those hours used exclusively for doing these tasks - DO NOT include hours spent exclusively supervisory in nature)
(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)
276,000	0	0
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
36,000	0	0
Display Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)	Total Cases
16,500	0	0	328,500
Shelf Stocking Direct Labor Subtotal		Direct Productive Hrs Required
		0
Receiving/Storage/Holding Area Direct Labor
Offload
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
330,468	0	0
Transport
108,372	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	0	0
Segregate
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
328,512	0	0
Store
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
28,236	0	0
Pull
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
28,236	0	0
RSHA Coverage, if required		Direct Productive Hrs Required
		0
Receiving/Storage/Holding Area Direct Labor Subtotal		Direct Productive Hrs Required
		- 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)
9,736,146	0	- 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)
5,736,550	0	- 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)
871,720	0	- 0
Outside Areas
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
3,491,220	0	- 0
Day Custodial Requirements		Direct Productive Hrs Required
		0
Custodial Direct Labor Subtotal		Direct Productive Hrs Required
		- 0
Total Direct Productive Hours (ADDENDUM)	TOTAL DIRECT LABOR HOURS
		Direct Productive Hrs Required
		0

&C&"Arial,Bold"&12&EDirect and Indirect Labor Summary Page &P of &N

TDWS Instructions

	TYPICAL DAILY WORK SCHEDULE
	INSTRUCTIONS
The purpose of this form is allow offerors to demonstrate their understanding of
labor and staffing needed to fulfill contract requirements. The form shows
the mix of job titles, tours of duty, no. of workers, and anticipated work hours in a
"typical" day. Offerors must provide a narrative that explains how the
“Typical Daily Work Schedule” will vary in response to question II.A.2. of the
Technical Capability and Personnel Proposal. NOTE: Operations with blocks
filled-in in black are not applicable to this solicitation.
1. Offeror. Use the name shown at SF 33, block 15A.
2. Solicitation. Enter the no. from SF 33, block 3.
3. Job Title. List each Job Title, from the contract wage determination,
proposed for a “typical” work day under the associated functions of
Management and Administration; Night Shelf Stocking;
Receiving/Storage/Holding Area; Residual Grocery, Night Custodial; and
Day Requirements Repeat Job Titles if workers with the same Job Title will
be working a different Tour of Duty (e.g., different starting and/or stopping times).
4. Tour of Duty. Fill-in or draw an arrow from the starting time to the
stopping time for each Job Title Tour of Duty. Time span shown must
include unpaid breaks during the Tour of Duty.
5. No. of Employees. Enter the No. of Employees proposed for each
Job Title Tour of Duty. Subtotal each function.
6. Scheduled Hours. Enter the total no. of Scheduled Hours proposed
for all employees in each Job Title Tour of Duty. Scheduled Hours must
include both paid and unpaid breaks during the Tour of Duty and equal
the no. of hours shown for Tour of Duty X No. of Employees (e.g., 4
employees scheduled for 9 hours each = 36 hours). Subtotal each
function.
7. Unpaid Breaks. Enter the total no. of hours for Unpaid Breaks
proposed for all employees in each Job Title Tour of Duty. Unpaid
Breaks are non-work periods where employees are in a non-pay status,
such as "lunch" (e.g., 4 employees X 1 hour lunch each = 4 hours
Unpaid Break). Subtotal each function.

Typical Daily Work Schedule

Tour of Duty																													Productive Hours Breakout
																														Direct Hours
Job Title	8:00 am	9:00	10:00	11:00	Noon	1:00 pm	2:00	3:00	4:00	5:00	6:00	7:00	8:00	9:00	10:00	11:00	Midnight	1:00 am	2:00	3:00	4:00	5:00	6:00	7:00 am	No. of Employees	Scheduled Hours	Unpaid Breaks (e.g., Lunch)	Productive Hours	Indirect Hours (Management)	Shelf Stocking	Receiving/ Storage/ Holding Area	Custodial	Total Direct Hours
Management and Administration
(Place an x in the hour when tour of duty begins and then number each hour scheduled)
EXAMPLE	x	1	2	3	4	5	6	7	8	9		(Shift equals 9 hours from 8:00 to 5:00)													1	9	1	8	8	0	0	0	0
Project Manager
Alternate Project Manager
																								Management and Administration Subtotals	0	0	0	0	0	0	0	0	0
Night Shelf Stocking
Store Worker/FDS
Lead Store Worker
Other
Other
Other
																								Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Store Worker/FDS
Forklift Operator
lead Forklift Operator
Other
Other
																								Receiving/Storage/Holding Area Subtotals	0	0	0	0	0	0	0	0	0
Night Custodial
Custodian
Lean Custodial
Other
Other
Other
Other
																								Night Custodial Subtotals	0	0	0	0	0	0	0	0	0
Day Requirements
Store Worker/FDS
Custodian
Other
Other
																								Day Shelf Replenishment and Custodial Subtotals	0	0	0	0	0	0	0	0	0
Totals
																									0	0	0	0	0	0	0	0	0

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