Attachment_5_Volume_II_TDWS__DLS_Worksheets_Barstow.xls

XLS spreadsheet 424 KB Posted Jan 23, 2019

Attached to: Barstow MCLB Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations
Solicitation number: HDEC08-18-R-0024
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a federal contract opportunity and related attachments for shelf stocking, receiving, storage, and custodial operations services. The solicitation is for the Defense Commissary Agency located at Barstow Marine Corps Logistics Base in California, and includes a base period from May 2019 to April 2020 plus four one-year option periods. The North American Industry Classification System code is 561990 and the business size standard is $11 million. This opportunity is set aside 100% for women-owned small businesses. The attachments include instructions for completing a typical daily work schedule and direct labor summary to demonstrate understanding of staffing and labor requirements. Offerors should submit proposals in response to solicitation number HDEC08-18-R-0024, which is anticipated to be posted on November 9, 2018 with a closing date of December 21, 2018.

From the source

Attachment 5 Volume II TDWS DLS Worksheets Barstow MCLB

View the file

Other files

File	Type	Posted
Attachment_6_Past_Performance_Barstow_MCLB.DOC	DOC document	Jan 23, 2019
Attachment_3_Vol_I__Cost_Breakout_Barstow_MCLB.XLS	XLS spreadsheet	Jan 23, 2019
Barstow_-_HDEC08.18.R.0024_Solicitation.pdf	PDF	Jan 23, 2019
Attachment_1_Barstow_MCLB_Private_Label_PWS_dtd_01.16.19.doc	DOC document	Jan 23, 2019
Attachment_2_WD_2015-5629_Rev__9_dtd_12.26.18.doc	DOC document	Jan 23, 2019
Attachment_4_Volume_II_Technical_Capability_Barstow_MCLB.DOC	DOC document	Jan 23, 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.

TDWS Instructions

		Attachment 5
	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.

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
Stock Clerk
Other
																								Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Warehouse Specialist
Forklift Operator
Material Handler
Other
																								Receiving/Storage/Holding Area Subtotals	0	0	0	0	0	0	0	0	0
Night Custodial
Janitor
Other
Other
																								Night Custodial Subtotals	0	0	0	0	0	0	0	0	0
Day Requirements
Store Worker I
Janitor
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"ATTACHMENT 5

HDEC08-18-R-0024

DLS Instructions

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

Direct Labor Summary

DIRECT LABOR		Commissary:Bartstow MCLB
(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)
37,740	0.00	0
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
300	0.00	0
Display Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
600	0.00	0
Shelf Stock Replenishment		Direct Productive Hrs Required
		0
Shelf Stocking Direct Labor Subtotal		Direct Productive Hrs Required
		0
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)
74,160	0.00	- 0
Transport Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
21,960	0.00	- 0
Segregate Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
74,100	0.00	- 0
Store Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
10,800	0.00	- 0
Pull Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
10,800	0.00	- 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)
2,260,454	0.00	- 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)
537,672	0.00	- 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)
171,828	0.00	- 0
Outside Areas
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
1,321,218	0.00	- 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

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

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