Attachment 5 - Volume II TDWS and DLS.xlsx

XLSX spreadsheet 111 KB Posted Aug 10, 2021

Attached to: Saratoga Springs Commissary: Shelf Stocking, Receiving Storage Holding Area (RSHA), Custodial Operations
Solicitation number: HDEC08-21-R-0014
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a Typical Daily Work Schedule (TDWS) template and instructions as well as a Direct Labor Summary (DLS) template and instructions related to the Saratoga Springs Commissary: Shelf Stocking, Receiving Storage Holding Area (RSHA), Custodial Operations opportunity. The TDWS template is to be used by offerors to demonstrate their understanding of labor and staffing needs to fulfill contract requirements by showing proposed job titles, tours of duty, number of workers, and anticipated work hours in a typical day. The DLS template requires offerors to input proposed productivity rates and total direct labor hours for shelf stocking, RSHA, and custodial services based on the provided yearly workloads and facility sizes. The related federal contract opportunity is for furnishing supervision, personnel, equipment, and supplies for shelf stocking, RSHA, and custodial operations at the Saratoga Springs, New York Defense Commissary Agency commissary, with a base period of January 1, 2022 through December 31, 2022 and four one-year option periods. The NAICS code is 561990 and size standard is $12 million. The solicitation and attachments will be available on or around August 10, 2021, with a closing date on or around September 28, 2021.

View the file

Other files

File	Type	Posted
Amendment 1 Solicitation Offer and Award HDEC0821R0014.pdf	PDF	Sep 20, 2021
Attachment 3 - Volume I Schedule B and Cost Breakout.xls	XLS spreadsheet	Sep 20, 2021
Solicitation Document Saratoga Springs HDEC0821R0014.pdf	PDF	Aug 10, 2021
Attachment 1 - Saratoga Springs PWS dated May .doc	DOC document	Aug 10, 2021
Attachment 4 - Volume II Technical Capability.doc	DOC document	Aug 10, 2021
Attachment 3 - Volume I Cost Breakout.xls	XLS spreadsheet	Aug 10, 2021
Attachment 2 - Wage Determination 2015-4143.docx	DOCX document	Aug 10, 2021
Attachment 6 - Volume III Past Performance.doc	DOC document	Aug 10, 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.

Attachment 5

HDEC0821R0014

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

(Shift equals 9 hours from 8:00 to 5:00)

Project Manager

Alternate Project Manager

Management and Administration Subtotals

Night Shelf Stocking

Store Worker I

Other

	Night Shelf Stocking Subtotals	0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Store Worker I
Warehouse Specialist
Forklift Operator
Other

	Receiving/Storage/Holding Area Subtotals	0	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	0
Day Requirements
Store Worker I
Janitor
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

Offeror: ________________________ &"Arial,Bold"&12&E TYPICAL DAILY WORK SCHEDULE (TDWS)&"Arial,Regular"&10&E &"Arial,Bold"ATTACHMENT 5 HDEC08-21-R-0014&"Arial,Regular"

DLS Instructions

DIRECT LABOR SUMMARY
	INSTRUCTIONS

1. Offeror. Use the name shown on the SF 33, block 15A.

2. Solicitation. HDEC0821R0014.

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.)

Attachment 5

HDEC0821R0014

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)
72,648	0	ERROR:#DIV/0!
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
600	0	ERROR:#DIV/0!
Displays (includes 100% of displays)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
18,000	0	ERROR:#DIV/0!
Shelf Stocking Direct Labor		Direct Productive Hrs Required	Total Annual Cases
Subtotal		ERROR:#DIV/0!	91,248
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)
91,368	0	ERROR:#DIV/0!
Transport Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
28,404	0	ERROR:#DIV/0!
Segregate Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
91,248	0	ERROR:#DIV/0!
Store Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
6,840	0	ERROR:#DIV/0!
Pull Merchandise
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
6,840	0	ERROR:#DIV/0!
RSHA Coverage for Contractor Work Schedule		Direct Productive Hrs Required
		0
Receiving/Storage/Holding Area Direct Labor		Direct Productive Hrs Required
Subtotal		ERROR:#DIV/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,753,848	0	ERROR:#DIV/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)
135,708	0	ERROR:#DIV/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)
963,372	0	ERROR:#DIV/0!
Outside Areas
Square Feet per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required (sq ft/productivity rate)
7,008,312	0	ERROR:#DIV/0!
Day Custodial Requirements		Direct Productive Hrs Required
		0
Custodial Direct Labor		Direct Productive Hrs Required
Subtotal		ERROR:#DIV/0!

Total Direct Productive Hours
	Direct Productive Hrs Required
	ERROR:#DIV/0!

Offeror Name: _________________	&"Arial,Bold"&12&E
Direct Labor Summary	&"Arial,Bold"ATTACHMENT 5

HDEC08-21-R-0014&"Arial,Regular"

File details come from the government source that posted it. Updated Aug 10, 2021.