Attachment_6_-_TDWS_DLS_Amendment_0001.xls

XLS spreadsheet 272 KB Posted Jun 12, 2015

Attached to: Shelf Stocking, Custodial and RSHA OPerations at the McChord AFB Commissary
Solicitation number: HDEC08-15-R-0020
Issued by: Defense Commissary Agency

About this file

From the source

Attachment 6 - TDWS/ DLS Amendment 0001

View the file

Other files

File	Type	Posted
Revised_Amend_0004_Attachment_4_Vol_I_Cost_Breakout_-_Loaded_Hourly_Rates.xls	XLS spreadsheet	Jun 18, 2015
HDEC08-15-R-0020_0004.pdf	PDF	Jun 18, 2015
Revised_Amend_0003_Attachment_4_Vol_I_Cost_Breakout_-_Loaded_Hourly_Rates.xls	XLS spreadsheet	Jun 17, 2015
HDEC08-15-R-0020.pdf	PDF	Jun 17, 2015
Revised_Attachment_6_-_TDWS_DLS_Amendment_0002.xls	XLS spreadsheet	Jun 16, 2015
HDEC08-15-R-0020_Amend_0002.pdf	PDF	Jun 16, 2015
HDEC08-15-R-0020_Amend_0001.pdf	PDF	Jun 12, 2015
Solicitation_HDEC08-15-R-0020.doc	DOC document	May 19, 2015
Attachment_2_McChord_AFB_PWS_dated_05.01.15.pdf	PDF	May 19, 2015
Attachment_7_-_Past_Performance_Information.doc	DOC document	May 19, 2015
Attachment_3_CBA_DOL_No._2006-0628_Rev_6_dtd_Sept_8_2014.pdf	PDF	May 19, 2015
Attachment_6_-_TDWS_DLS.xls	XLS spreadsheet	May 19, 2015
Attachment_4_Vol_I_Cost_Breakout_-_Loaded_Hourly_Rates.xls	XLS spreadsheet	May 19, 2015
Attachment_1_DD_Form_1707_(3).pdf	PDF	May 19, 2015
Attachment_5_Vol_II_-_Technical_Proposal.doc	DOC document	May 19, 2015

Show all 15

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	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
Shelf Stocker
Store Worker
Lead Stocker
Other
																								Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Warehouseman
Warehouse Supervisor
Other
																								Receiving/Storage/Holding Area Subtotals	0	0	0	0	0	0	0	0	0
Night Custodial
Janitor
Janitor II
Other
																								Night Custodial Subtotals	0	0	0	0	0	0	0	0	0
Day Requirements
Shelf Stocker
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 6 HDEC08-15-R-0020&"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.

&RATTACHMENT 6

HDEC08-15-R-0020

Direct Labor Summary (DLS)

(Enter data in cells with red font only.)			Amendment 0001
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)
798,648	0	0
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
18,156	0	0
Displays (includes 100% of displays)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
51,852	0	0
Shelf Stocking Direct Labor		Direct Productive Hrs Required
Subtotal		0
D
	Club Pack Savings Area/ClubPack Stocking
Removal/Replace Pallets of Single Items to Club Pack Savings Area
Pallets per Year	Productivity Rate (pallets per person per productive hour)	Direct Productive Hrs Required (pallets/productivity rate)
336	0	0	(Note this is for Pallets)
Removal and Replacement of Pallets

To Club Pack Savings Area Direct Labor

Subtotal	Direct Productive Hrs Required	Separate Pricing Tab
	Subtotal		0	See Cost Breakout
	Club Pack Cases Stocked to Racks in Club Pack Savings Area
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	33,408	0	0	(Note this is for Pallets)
	Stocking Club Packs Direct Labor		Direct Productive Hrs Required	Separate Pricing Tab
	Subtotal		0	See Cost Breakout
	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,721,220	0	0
	Offload Pallets for Club Pack Savings Area and Future Displays
	Pallets per Year	Productivity Rate (pallets per person per productive hour)	Direct Productive Hrs Required (pallets/productivity rate)
	17,772	0	0	(Note this is for Pallets)
	Transport Merchandise
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	38,593	0	0
	Transport Pallets for Club Pack Savings Area
	Pallets per Year	Productivity Rate (pallets per person per productive hour)	Direct Productive Hrs Required (pallets/productivity rate)
	17,772	0	0	(Note this is for Pallets)
	Segregate Merchandise
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	1,258,104	0	0
	Store Merchandise
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	38,412	0	0
	Pull Merchandise
	Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
	38,412	0	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)
	19,800,084	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,215,958	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)
	10,463,972	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)
	10,463,972	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 6 HDEC08-15-R-0020&"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-15-R-0020.
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 Nov 14, 2017.