Attachment H - Staffing Matrix - 14Aug23.xlsx

XLSX spreadsheet 98 KB Posted Aug 17, 2023

Attached to: Ft. Sill, OK Full Food Services
Solicitation number: W5168W23R0007
Issued by: Department of the Army

About this file

Written by GovTribe AI · Dec 21, 2023

This document is a staffing matrix template for a federal food services contract opportunity with the Department of the Army at Fort Sill, Oklahoma. The staffing matrix includes templates for multiple dining facilities and field service locations requiring food services support. Labor categories and estimated full-time equivalents are to be provided for each meal period for the base contract period of performance. Templates are also included for additional services such as extended hours of operation, periodic deep cleaning, and dining facility opening and closing support. Offerors are to complete the templates by specifying the number of FTEs by labor category to support each location and service period. This staffing matrix is an attachment to solicitation number W5168W23R0007 for full food services at Fort Sill, with responses to be provided by the solicitation due date and contract award anticipated shortly thereafter.

View the file

Other files

File	Type	Posted
Attachment Q - Ft. Sill FFS RFP Q and A -W5168W23R0007 15AUG23_Final.xlsx	XLSX spreadsheet	Aug 18, 2023
Attachment I - Ft. Sill-Collective Bargaining Agreement 01.01.23-12.31.23.pdf	PDF	Aug 17, 2023
Attachment Q - Ft. Sill FFS RFP Q and A -W5168W23R0007 15AUG23_Final.xlsx	XLSX spreadsheet	Aug 17, 2023
Modified - Ft. Sill Solicitation Amendment W5168W23R0007 0001_17AUG23.pdf	PDF	Aug 17, 2023
Attachment F - Estimated Workload Data - Capabilities - 14AUG23.docx	DOCX document	Aug 17, 2023
Fort Sill Site Visit Slides .pptx	PPTX presentation	Aug 7, 2023
Site Visit Roster - Fort Sill.pdf	PDF	Aug 7, 2023
Attachment D2 - Real Property.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment B - Ft. Sill - AFMIS FY22_FY21_FY20.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment D3 - Durable Property.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment H - Ft. Sill Staffing Matrix 1Feb23.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment O - Performance Work Statement 16 June 2023_Final.docx	DOCX document	Jul 21, 2023
Attachment F - Estimated Workload 8Dec22.docx	DOCX document	Jul 21, 2023
Attachment E - Sample Materials List.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment I - Ft. Sill-Collective Bargaining Agreement eff 15 May 2022.pdf	PDF	Jul 21, 2023
Schedule B-1 Pricing Matrix.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment J - Ft. Sill Pictures of Facilities.pdf	PDF	Jul 21, 2023
Attachment L - Specific Relevant Contracts Reference Sheet 08-2019.docx	DOCX document	Jul 21, 2023
Attachment D1 - GFP.xlsx	XLSX spreadsheet	Jul 21, 2023
Attachment K - Consent Forms for Release of Past Performance Info.docx	DOCX document	Jul 21, 2023
Attachment N- Ft. Sill, OK FFS DOL Wage Determination.pdf	PDF	Jul 21, 2023
Attachment P - PIEE Solicitation Vendor Posting Offer Training.pdf	PDF	Jul 21, 2023
Attachment A- Ft. Sill DFAC Location Map.pdf	PDF	Jul 21, 2023
Attachment C - Ft. Sill Building Plans.pdf	PDF	Jul 21, 2023
Attachment M - Past Performance Questionnaire - 20210920.docx	DOCX document	Jul 21, 2023
Ft. Sill Solicitation W5168W-23-R-0007_21 July 23.pdf	PDF	Jul 21, 2023

Show all 26

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.

PMO Staff

Project Management Office (incl Q/C, HR, etc.)

Instructions:

List each labor category only once.

PMO labor categories and FTEs should only be listed on this tab.

Labor Category	FTEs	Prod Hrs per FTE	Total Prod Hrs
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
			0.00
TOTAL	0.000		0.00

Instructions

These instructions apply to each subCLIN listed in each building tab within the Staffing Matrix.
1. Column A: Enter the labor categories included in the proposal in the area highlighted in green starting under "Position" (i.e., Cook I, Cook II, etc.)
NOTE: Enter all supervisory positions below the grey line in each
2. Columns B through AJ: Enter the quantity of people in each labor category listed scheduled to support the contract during the hours listed.
In the example below, the Breakfast serving period highlighted is from 0730 to 0900; assuming staffing is for 3 "Cook I" positions to work from 0700 to 0900, 3 would be input in columns D - H.
					Breakfast
Position	6:00	6:30	7:00	7:30	8:00	8:30	9:00	9:30	10:00
Cook I			3.00	3.00	3.00	3.00	3.00

3. Column AK: Do not enter any information as this column contains formulas and will calculate the total number of hours for each position (labor category listed).

Using example above, column AK would calculate a total of 7.5 hours.

4. Bldg 5965 CLIN 0005 and Bldg 5966 CLIN 0006): The serving hours for Bldgs 5965 & 5966 vary, per Attachment F, but the serving periods are all 90 minutes. The Staffing Matrix uses serving hours for each meal for Monday - Saturday hours.

5. Field Svc (Reimb) CLIN 0008: This requirement can be for Breakfast, Lunch, or Dinner, the serving times for each meal vary but the serving periods are all 90 minutes. The Staffing Matrix only uses serving hours for Breakfast.

Please note that although Dining Facility Managers (and Assistant Dining Facility Managers) may be priced as part of PMO, for the Staffing Matrix, those positions should be included in the Bldg subCLINs.

Bldg 2755 CLIN 0003

1240 Capacity
							Three meals per day, 1 - 2400
									BREAKFAST								LUNCH											DINNER
Position	3:30	4:00	4:30	5:00	5:30	6:00	6:30	7:00	7:30	8:00	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30	13:00	13:30	14:00	14:30	15:00	15:30	16:00	16:30	17:00	17:30	18:00	18:30	19:00	19:30	20:00	20:30	Daily Hours
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
Supervisory
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
TOTAL STAFF	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	- 0

							Three meals per day, 2401 - 4800
									BREAKFAST								LUNCH											DINNER
Position	3:30	4:00	4:30	5:00	5:30	6:00	7:00	7:30	8:00	8:30	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30	13:00	13:30	14:00	14:30	15:00	15:30	16:00	16:30	17:00	17:30	18:00	18:30	19:00	19:30	20:00	20:30	Daily Hours
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
Supervisory
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
TOTAL STAFF	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	- 0

Bldg 3720 CLIN 0004

1300 Seating Capacity
						Three meals per day, 1 - 1950
								BREAKFAST								LUNCH											DINNER
Position	4:00	4:30	5:00	5:30	6:00	6:30	7:00	7:30	8:00	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30	13:00	13:30	14:00	14:30	15:00	15:30	16:00	16:30	17:00	17:30	18:00	18:30	19:00	19:30	20:00	20:30	Daily Hours
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
Supervisory
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
TOTAL STAFF During meals	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	- 0

						Three meals per day, 1951 - 3900
								BREAKFAST								LUNCH											DINNER
Position	4:00	4:30	5:00	5:30	6:00	6:30	7:00	7:30	8:00	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30	13:00	13:30	14:00	14:30	15:00	15:30	16:00	16:30	17:00	17:30	18:00	18:30	19:00	19:30	20:00	20:30	Daily Hours
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00	- 0
																																			0.00
																																			0.00
Supervisory
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
																																			0.00
TOTAL STAFF During meals	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	- 0

Bldg 5965 CLIN 0005

2600 Design Capacity

Kitchen + One Quad (2400 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Two Quads (4800 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Three Quads (7200 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Four Quads

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen Mermites Only (Breakfast & Dinner 9 Battery maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Bldg 5966 CLIN 0006

2600 Design Capacity

Kitchen + One Quad (2400 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Two Quads (4800 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Three Quads (7200 meals maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen + Four Quads

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Kitchen Mermites Only (Breakfast & Dinner 9 Battery maximum)

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Bldg 3443 DFA CLIN 0007

800 Design Capacity

Three meals per day, 1 - 1500

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Three meals per day, 1501 - 2500

BREAKFAST

LUNCH

DINNER

Position

3:30

4:00

4:30

5:00

5:30

6:00

6:30

7:00

7:30

8:00

8:30

9:00

9:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30

15:00

15:30

16:00

16:30

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

Daily Hours

0.00

Supervisory

0.00

TOTAL STAFF During meals

- 0

Field Svc (Reimb) CLIN 0008

Reimbursable Customer								Field Service Meal Period (Breakfast, Lunch or Dinner) PWS 4.5.5
									BREAKFAST
Position	3:30	4:00	4:30	5:00	5:30	6:00	6:30	7:00	7:30	8:00	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30	13:00	13:30	14:00	14:30	15:00	15:30	16:00	16:30	17:00	17:30	18:00	18:30	19:00	19:30	20:00	20:30	Daily Hours
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
Supervisory																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
																																				0.00
TOTAL STAFF During meals	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	- 0

Extended Svc Note: Other Services will be ordered under the applicable Building CLIN

IAW PWS 1.6.1.1

Complete the yellow boxes below for each service area:

Extended Hours:

1. Input the Labor Category beginning in A11.

2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.

3. Please note these are based on quarter hour (15 mins) increments (see below example - entering a quantity of 1 in cell C11 reflects 1 "Cook I" is proposed for an additional 15 mins of DFAC serving time).

Extended Hours PWS 1.6.1.1	Staffing for Bldg 2755 (FFS)	Staffing for Bldg 3720 (FFS)	Staffing for Bldg 5965 (FFS)	Staffing for Bldg 5966 (FFS)	Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I	1	1	1	1	1

TOTAL FTEs per Quarter Hour 0 0 0 0 0

IAW PWS 4.2

Complete the yellow boxes below for each service area:

Periodic In-Depth Cleaning

1. Input the Labor Category beginning in A35.

2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.

Periodic In-Depth Cleaning PWS 4.2	Staffing for Bldg 2755 (FFS)	Staffing for Bldg 3720 (FFS)	Staffing for Bldg 5965 (FFS)	Staffing for Bldg 5966 (FFS)	Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I	1	1	1	1	1

TOTAL FTEs 0 0 0 0 0

IAW PWS 4.3

Complete the yellow boxes below for each service area:

Dining Facility Opening and Closing

1. Input the Labor Category beginning in A57.

2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.

Dining Facility Opening and Closing PWS 4.3	Staffing for Bldg 2755 (FFS)	Staffing for Bldg 3720 (FFS)	Staffing for Bldg 5965 (FFS)	Staffing for Bldg 5966 (FFS)	Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I	1	1	1	1	1

TOTAL FTEs 0 0 0 0 0

File details come from the government source that posted it. Updated Aug 17, 2023.