Attachment 5 TDWS-DLS.XLS

XLS spreadsheet 275 KB Posted May 27, 2020

Attached to: Fort Knox Commissary - Shelf Stocking and Custodial Operations
Solicitation number: HDEC0820R0009
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a Typical Daily Work Schedule template and Direct Labor Summary template for a federal contract solicitation to provide shelf stocking and custodial operations at the Fort Knox Commissary. The solicitation seeks to furnish supervision, personnel, equipment, and supplies for shelf stocking, involving approximately 581,640 annual direct labor hours for stocking approximately 490,848 cases of night shelf stocking, 66,792 cases of day shelf stocking, and 24,000 cases of displays. For custodial services, the solicitation involves approximately 18,067,528 annual square feet for administrative/store/patron areas, 209,560 square feet for contractor's office areas, and 2,518,130 square feet for outside areas, totaling over 20 million square feet requiring an unknown number of annual direct labor hours. Offerors must complete the templates to demonstrate staffing plans and productivity rates for evaluation. The Defense Commissary Agency at Fort Knox is the contracting agency.

View the file

Other files

File	Type	Posted
Amendment 0001 - HDEC08-20-R-0009.pdf	PDF	Jul 7, 2020
Attachment 6 Past Performance.doc	DOC document	May 27, 2020
Attachment 2 WD 2015-4681 Rev 9 dated 12.23.2019.pdf	PDF	May 27, 2020
HDEC08-20-R-0009 Solicitation .pdf	PDF	May 27, 2020
Attachment 1 Performance Work Statement dated 04.07.2020.docx	DOCX document	May 27, 2020
Attachment 3 Cost Breakout - Loaded Hourly Rates.xlsx	XLSX spreadsheet	May 27, 2020
Attachment 4 Technical Capability and Personnel.doc	DOC document	May 27, 2020

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.

Typical Daily Work Sched

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	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
Project Manager
Alternate Project Manager
																								Management and Administration Subtotals	0	0	0	0	0	0	0	0
Night Shelf Stocking
Store Worker I
Other
Other
																								Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0
Night Custodial
Janitor
Other
Other
Other
Other
Other
																								Night Custodial Subtotals	0	0	0	0	0	0	0	0
Day Requirements
Store Worker I
Janitor
Other
Other
																								Day Shelf Replenishment and Custodial Subtotals	0	0	0	0	0	0	0	0
Totals
																									0	0	0	0	0	0	0	0

&LOfferor: ________________________&C&"Arial,Bold"&12&E

TYPICAL DAILY WORK SCHEDULE (TDWS)

&"Arial,Regular"&10&E &R&"Arial,Bold"ATTACHMENT 4 HDEC08-20-R-0009&"Arial,Regular"

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; 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.
8. Productive Hours. Enter the total no. of Productive Hours for each
Job Title Tour of Duty. Total Productive Hours must equal
Scheduled Hours minus Unpaid Breaks. Subtotal each function.
9. Productive Hours Breakout. (Note: The total of Indirect Hours
and Total Direct Hours must equal the Productive Hours for each Job
Title Tour of Duty.)
a. Indirect Hours. Enter the no. of productive hours proposed for
all employees in each Job Title Tour of Duty used to perform
administrative duties (e.g., preparing work schedules, completing
reports, attending meetings with the commissary officer). Generally
only administrative personnel (e.g., project manager, supervisors)
perform Indirect Hours. Subtotal each function.
b. Direct Hours.
(1) For Management and Administration, break the direct
productive hours down into the appropriate columns (e.g., Shelf
Stocking, Receiving/Storage/Holding Area, Custodial) for each Job Title
Tour of Duty. Subtotal each column for Management and
Administration.
(2) For Night Shelf Stocking, Receiving/Storage/Holding
Area, and Night Custodial functions, enter the direct productive hours
for each Job Title Tour of Duty needed to fulfill contract requirements
(e.g., custodial, shelf stocking). Subtotal the Direct Hours column for
each function.
(3) For Day Shelf Stocking and Custodial, break down the
direct productive hours into the appropriate columns of either Shelf
Stocking or Custodial for each Job Title Tour of Duty. Subtotal the
Shelf Stocking, and Custodial columns.
(4) Show the Total Direct Hours for each Job Title Tour of Duty.
10. Totals. Enter the totals for No. of Employees, Scheduled Hours,
Unpaid Breaks, Productive Hours, Indirect Hours, and each Direct
Hours column including the Total Direct Hours column.

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)
490,848	0	0
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
66,792	0	0
Displays
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
24,000	0	0
Shelf Stocking Direct Labor		Direct Productive Hrs Required	581,640
Subtotal		0
D
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)
18,067,528	0	0
Contractor's Overwrite Area
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
209,560	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)
2,518,130	0	0
Day Custodial Requirements		Direct Productive Hrs Required
		0
Custodial Direct Labor		Direct Productive Hrs Required
Subtotal		- 0
Total Direct Productive Hours
		Direct Productive Hrs Required
		0

&L Offeror Name: _________________&C&"Arial,Bold"&12&E Direct Labor Summary&R&"Arial,Bold"ATTACHMENT 5 HDEC08-20-R-0009&"Arial,Regular" Page &P of &N

DLS Instructions

	DIRECT LABOR SUMMARY
		INSTRUCTIONS
1. Offeror. Use the name shown on the SF 33, block 15A.
2. Solicitation. HDEC08-20-R-0009
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 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 May 27, 2020.