Attachment 5 - TDWS DLS - McGuire AFB.XLS

XLS spreadsheet 277 KB Posted Jan 27, 2021

Attached to: McGuire AFB Shelf Stocking, Receiving/Storage/Holding Area (RSHA), Custodial, and CLICK2GO Services
Solicitation number: HDEC08-20-R-0013
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains instructions and templates for a federal solicitation seeking shelf stocking, receiving, storage, holding area, custodial, and click-and-go services at McGuire Air Force Base. Offerors are required to provide a typical daily work schedule outlining proposed staffing and labor hours by job title and shift. The direct labor summary template requires offerors to input productivity rates and estimated direct labor hours for shelf stocking, receiving, storage, holding area, and custodial functions based on annual workload quantities. The solicitation number is HDEC08-20-R-0013 issued by the Defense Commissary Agency. Offerors must submit their completed templates to demonstrate understanding of requirements and labor needs.

View the file

Other files

File	Type	Posted
HDEC08-20-R-0013 AMEND 0001.pdf	PDF	Mar 8, 2021
Attachment 1 - McGuire AFB PWS Dated 12.16.2020 Addendum - CLICK2GO.DOCX	DOCX document	Jan 27, 2021
Attachment 3 - Volume I - Cost Breakout - CBA.XLS	XLS spreadsheet	Jan 27, 2021
Attachment 2 - WD 2020-0244 Revison 2 dated 12.3.2020 (CBA).pdf	PDF	Jan 27, 2021
Attachment 7 - Bereavement Leave Certification.doc	DOC document	Jan 27, 2021
Attachment 4 - Volume II Technical Capability and Personnel.doc	DOC document	Jan 27, 2021
Attachment 6 - Volume III Past Performance Information.doc	DOC document	Jan 27, 2021
HDEC08.20.R.0013.pdf	PDF	Jan 27, 2021
Attachment 1 - McGuire AFB PWS Dated 12.16.2020.doc	DOC document	Jan 27, 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.

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.

&R&"Arial,Bold"&8HDEC08-20-R-0013

ATTACHMENT 5

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	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 I
Other
Other
																								Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Warehouse
Material Handler
Forklift Operator
Other
																								Receiving/Storage/Holding Area Subtotals	0	0	0	0	0	0	0	0	0
Night Custodial
Custodian
Other
Other
Other
Other
Other
																								Night Custodial Subtotals	0	0	0	0	0	0	0	0	0
Day Requirements
Store Worker I
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

&LOfferor: ________________________&C&"Arial,Bold"&12&E TYPICAL DAILY WORK SCHEDULE (TDWS)&"Arial,Regular"&10&E &R&"Arial,Bold"&8HDEC08-20-R-0013

ATTACHMENT 5&10

&"Arial,Regular"

DLS Instructions

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

&R&"Arial,Bold"&8HDEC08-20-R-0013

ATTACHMENT 5

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)
1,125,600	0	0
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
85,656	0	0
Displays Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)	Total Cases
228,000	0	0	1,439,256
Shelf Stocking Direct Labor		Direct Productive Hrs Required
Subtotal		0
D
Receiving/Storage/Holding Area Direct Labor
Offload Trucks
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
1,447,728	0	0
Transport Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
452,472	0	0
Segregate Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
1,439,256	0	0
Store Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
143,472	0	0
Pull Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
143,472	0	0
RSHA Coverage (if required)		Direct Productive Hrs Required
		0
Receiving/Storage/Holding Area Direct Labor		Direct Productive Hrs Required
Subtotal		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)
20,357,746	0	0
Meat Processing Room
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
1,182,654	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)
7,309,142	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)
6,009,200	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" &8HDEC08-20-R-0013

ATTACHMENT 5

Page &P of &N

File details come from the government source that posted it. Updated Jan 27, 2021.