ATTACHMENT 6 Typical Daily Work Schedule and Direct Labor Summary.xlsx

XLSX spreadsheet 134 KB Posted Apr 28, 2020

Attached to: Fort Carson Commissary Shelf Stocking, Receiving/Storage/Holding Area (RSHA), Custodial Operations, and Residual Grocery
Solicitation number: HDEC0820R0010
Issued by: Defense Commissary Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This solicitation is for shelf stocking, receiving/storage/holding area operations, custodial services, and residual grocery services for the Fort Carson Commissary located in Colorado. The contract includes a base year and four option years, and is set aside for Service-Disabled Veteran-Owned Small Businesses. The North American Industry Classification System code is 561990 with a business size standard of $12 million. Offerors must submit proposals by May 26, 2020 to be considered for the contract to be awarded by the Defense Commissary Agency. A pre-proposal site visit will be held on April 28, 2020. The solicitation and attachments will be available on FedBizOpps starting April 7, 2020. Paper copies can be requested by contacting the Defense Commissary Agency Store Services Support Division. The required services include stocking shelves, receiving and storing inventory, custodial services, and additional residual grocery tasks outlined in the performance work statement.

View the file

Other files

File	Type	Posted
ATTACHMENT 4 Volume I Cost Breakout - 6.22.2020.xls	XLS spreadsheet	Jun 22, 2020
Fort Carson Solicitation HDEC0820R0010 Amendment 2.pdf	PDF	Jun 22, 2020
Fort Carson Solicitation HDEC0820R0010 Amendment 1.pdf	PDF	Jun 9, 2020
ATTACHMENT 2 Collective Bargaining Agreement.pdf	PDF	Apr 28, 2020
ATTACHMENT 7 Past Performance Information.doc	DOC document	Apr 28, 2020
ATTACHMENT 3 Bereavement Leave Certification.doc	DOC document	Apr 28, 2020
ATTACHMENT 5 Volume II Technical Capability and Personnel.doc	DOC document	Apr 28, 2020
HDEC0820R0010.pdf	PDF	Apr 28, 2020
ATTACHMENT 1 Performance Work Statement.docx	DOCX document	Apr 28, 2020
ATTACHMENT 4 Volume I Cost Breakout.xls	XLS spreadsheet	Apr 28, 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.

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 6

HDEC08-20-R-0010

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
Stock Clerk
Other
Other
Other
Other
Night Shelf Stocking Subtotals																									0	0	0	0	0	0	0	0	0
Receiving/Storage/Holding Area
Warehouse Specialist
Other
Other
Other
Other
Receiving/Storage/Holding Area Subtotals																									0	0	0	0	0	0	0	0	0
Night Custodial
Custodian (Sales/Admin)
Custodian (Meat)
Custodian (RSHA)
Custodian (Outside)
Other
Other
Night Custodial Subtotals																									0	0	0	0	0	0	0	0	0
Residual Grocery
Stock Clerk
Warehouse Specialist
Custodian
Other
Residual Grocery Subtotals																									0	0	0	0	0	0	0	0	0
Day Requirements
Stock Clerk
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 6 HDEC08-20-R-0010&"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-0010

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.

For Residual Grocery, please refer to item decription in the DLS for productive unit.

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 6

Direct Labor Summary (DLS) (Offeror's Name) ATTACHMENT 6

HDEC08-20-R-0010

DIRECT LABOR		Commissary: Fort Carson
(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)
699,348	0.00	ERROR:#DIV/0!
Day Shelf Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
30,696	0.00	ERROR:#DIV/0!
Display Stocking
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
77,568	0.00	ERROR:#DIV/0!
Shelf Stocking Direct Labor Subtotal		Direct Productive Hrs Required
		ERROR:#DIV/0!

Receiving/Storage/Holding Area Direct Labor
Offload for Government Receipt
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
1,189,872	0	ERROR:#DIV/0!
Transport
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
385,440	0	ERROR:#DIV/0!
Segregate and Sort
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
1,182,792	0	ERROR:#DIV/0!
Store
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
240,120	0	ERROR:#DIV/0!
Pull
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
240,120	0	ERROR:#DIV/0!
Receiving/Storage/Holding Area Direct Labor Subtotal		Direct Productive Hrs Required
		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)
19,024,552	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)
7,615,032	0	ERROR:#DIV/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)
906,448	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)
12,473,434	0	ERROR:#DIV/0!
Day Custodial Requirements		Direct Productive Hrs Required
		0
Custodial Direct Labor Subtotal		Direct Productive Hrs Required
		ERROR:#DIV/0!

Residual Grocery (Sections C4.3, C4.4, and C4.6)
Shelf Stocking RG
Shelf Stocking Fresh Eggs (Para 4.3.2.6.2)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hours Required
18,000	0	ERROR:#DIV/0!
Special Promotional Sales (Para. 4.3.3.7.3.)
Pallets per Year	Productivity Rate (pallets per person per productive hour)	Direct Productive Hrs Required
3,000	0	ERROR:#DIV/0!
Stock Availability Surveys (Para. 4.3.3.19.)
Surveys per Year	Productivity Rate (surveys per person per productive hour)	Direct Productive Hours Required
724	0	ERROR:#DIV/0!
Review Signs Displayed at Off-Shelf Locations (Para. 4.3.3.21.1)
Signs per Year	Productivity Rate (signs per person per productive hour)	Direct Productive Hrs Required
868,800	0	ERROR:#DIV/0!
Review Signs Displayed at Shelf Locations (Para. 4.3.3.21.2)
Signs per Year	Productivity Rate (signs per person per productive hour)	Direct Productive Hrs Required
6,000	0	ERROR:#DIV/0!
Review Coupons (Para. 4.3.3.22.)
Coupons per Year	Productivity Rate (reviews per person per productive hour)	Direct Productive Hrs Required
6,000	0	ERROR:#DIV/0!
Conduct Price Verifications Off Shelf Locations (Para. 4.3.3.23. and 4.3.3.23.2.)
Prices Verified per year	Productivity Rate (rverifications per person per productive hour)	Direct Productive Hrs Required
501,888	0	ERROR:#DIV/0!
Temperature Checks/Refrigeration Alarm System (Para. 4.3.3.24.)
Occasions per year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required
1,086	0	ERROR:#DIV/0!
Returning Carts to Appropriate Locations (Para. 4.3.3.26.)
Carts per year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required
42,000	0	ERROR:#DIV/0!
Receiving/Storage/Holding Area RG
Transport Merchandise for Sidewalk Sales (Para. 4.4.2.4.)
Cases per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required
12,000	0	ERROR:#DIV/0!
Transport Merchandise for Truckload Sales (Para 4.4.2.4)
Cases per Year	Productivity Rate (sq ft per crew per productive hour)	Direct Productive Hrs Required
6,000	0	ERROR:#DIV/0!
Separating Perishable Cases (Para. 4.4.2.4.1.)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
378,360	0	ERROR:#DIV/0!
Storing Perishable Cases (Para. 4.4.2.4.2.)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
144,000	0	ERROR:#DIV/0!
Pulling Special Orders (Para. 4.4.2.8.1.1.)
Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
6,000	0	ERROR:#DIV/0!
Pull Bags (Para 4.4.2.8.2)
Bales/Cases per Year	Productivity Rate (cases per person per productive hour)	Direct Productive Hrs Required (cases/productivity rate)
7,440	0	ERROR:#DIV/0!
Custodial RG
Refrigerated Display Cases Cleaning/Sanitizing (Para. 16)
Linear Feet per Year	Productivity Rate (linear ft per crew per productive hour)	Direct Productive Hrs Required (linear ft/productivity rate)	ERROR:#DIV/0!
8,308	0.0	ERROR:#DIV/0!
Backup/Holding/Storage Areas Cleaning/Sanitizing (Para. 17)
Square Feet per Year	Productivity Rate (square ft per crew per productive hour)	Direct Productive Hrs Required (linear ft/productivity rate)
3,088,946	0	ERROR:#DIV/0!
Residual Grocery Direct Labor Subtotal		Direct Productive Hrs Required
		ERROR:#DIV/0!

TOTAL DIRECT LABOR HOURS
	Direct Productive Hrs Required
	ERROR:#DIV/0!

&"Arial,Bold"&12&E Direct Labor Summary ATTACHMENT 6

File details come from the government source that posted it. Updated Apr 28, 2020.