Attachment 5 - Estimated Workload Data.pdf

173 KB Posted

Attached to
Automatic Door Maintenance and Repair Services
Solicitation number
W911S826RA010
Issued by

About this file

Written by GovTribe AI ·

This document is a preventive maintenance (PM) scheduling chart for door systems across multiple military installations, specifically tracking planned maintenance activities for various building types at Lewis-McChord (a combined military installation) and related facilities over a 12-month period from April through March.

The spreadsheet identifies 98+ buildings across both McChord Field (MF) and Lewis (L) locations requiring door maintenance services. Buildings are categorized by function including barracks, offices, dining facilities, gyms, child development centers, shopettes, and administrative spaces. Each building entry specifies the door type (Single Swing, Dual Swing, Single Slide, or Dual Slide) and door location (Main Entry, rear entries, side entries, or interior restroom doors). The maintenance schedule uses "1" entries to indicate scheduled PM completion during specific months, with color-coding to track status: red for PM completed, orange for missed services, yellow for new entries, and gray for deleted buildings. Monthly totals range from 40-49 scheduled maintenance tasks, with an annual total of 558 door maintenance services. Two additional buildings (J01177 and J01179) at the Twin Centers Complex (TWCF) at McChord Field are tracked separately with 0-4 monthly entries. The document appears to be a planning tool for operations and maintenance (O&M) personnel to manage preventive door maintenance across the installation portfolio.

View the file

Other files

File Type Posted
Solicitation Amendment - W911S826RA010-0002.pdf PDF
Questions and Answers version 2.pdf PDF
Conformed Solicitation - W911S826RA010.pdf PDF
Solicitation Amendment - W911S826RA010-0001.pdf PDF
Conformed Solicitation - W911S826RA010.pdf PDF
Consolidated Questions and Answers.pdf PDF
Attachment 7 - Long Term Badge Application.pdf PDF
Attachment 8 - Technical Experience Form.docx DOCX document
Attachment 1 - Revised 1 PWS Auto Door Services.pdf PDF
WD 2015-5539 (Revision No. 30).pdf PDF
Attachment 4 - McChord Field Map.pdf PDF
Attachment 7 - Technical Experience Form.docx DOCX document
Attachment 1 - PWS Auto Door Services.pdf PDF
Solicitation - W911S826RA010 Professional Appearance.pdf PDF
Attachment 6 - Door Inventory.pdf PDF
Attachment 2 - Lewis Main Map.pdf PDF
Attachment 3 - Lewis North Map.pdf PDF
Show all 17

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.

Bldg # Building

Function/Location Type

Door Location Ap ril

M ay

Ju ne

Ju ly

Au gu st

Se pt em be r

O ct ob er

N ov em be r

De ce m be r

Ja nu ar y

Fe br ua ry

M ar ch

Food Court 1 1 1 1 Food Court 1 1 1 1 Food Court 1 1 1 1 Food Court 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1

J00551 WIC (MF) Single Swing Main Entry 1 1 Single Swing Main Entry 1 1 Single Swing Main Entry 1 1

J00580 CDC (MF) Dual Slide Main Entry 1 1 1 1 Main Entry 1 1 Main Entry 1 1

J00729 Gym (MF) Single Swing Entry 1 1 J01145 Ops/Maint. (MF) Dual Slide Main Entry 1 1 1 1

Single Swing Main Entry 1 1 1 1 Single Swing Main Entry 1 1 1 1

J01182 OPS Gp (MF) Dual Slide Side Entry 1 1 1 1 NW Entry 1 1 1st flr ♀ RR 1 1 1st flr ♂ RR 1 1 2nd flr ♀ RR 1 1 3rd flr ♂ RR 1 1

2007 Office/Admin (L) Single Swing NE Entry 1 1 2008 Office/Admin (L) Single Swing West Entry 1 1

NW Entry 1 1 NE Entry 1 1 2nd flr ♀ RR 1 1 2nd flr ♂ RR 1 1 3rd flr ♀ RR 1 1 3rd flr ♂ RR 1 1 NE Entry 1 1 SE Entry 1 1 2nd flr ♀ RR 1 1 2nd flr ♂ RR 1 1 3rd flr ♀ RR 1 1 3rd flr ♂ RR 1 1 West Entry 1 1 2nd flr ♀ RR 1 1 2nd flr ♂ RR 1 1 3rd flr ♀ RR 1 1 3rd flr ♂ RR 1 1 North Entry 1 1

2015 Office/Admin (L) Single Swing

Dual Swing

2012 Office/Admin (L) Single Swing

2013 Office/Admin (L) Single Swing

J00726 Fitness Center- Annex (MF)

Dual Swing

J01180 Admin/Whse (MF)

2006 Office/Admin (L) Single Swing

J00545 Shoppette (MF) Single Swing

J00560 CDC (MF)

J00504 BX (MF)

Single Slide

Dual Slide

North Entry 1 1 1st flr ♀ RR 1 1 1st flr ♂ RR 1 1 North Entry 1 1 East Entry 1 1 SW Entry 1 1 West Entry 1 1 NW Entry 1 1 1st flr ♀ RR 1 1 1st flr ♀ RR 1 1

Dual Swing Main Entry 1 1 SE Entry 1 1 East Entry 1 1

2072 BSC (L) Single Slide Entry 1 1 1 1 2095 Clarkmoor CDC (L) Single Swing Main Entry 1 1

Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1

SW ♀ RR 1 1

SW ♀ RR 1 1

SW ♂ RR 1 1

SW ♂ RR 1 1

Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 ID office 1 1 ID office 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Hallway 1 1

♀ RR 1 1

♂ RR 1 1

Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1

♂ RR 1 1

♀ RR 1 1

3236 Gym (L) Single Swing

3145 Shopette (L) Dual Slide

3201 DPTMS Training Single Slide

2402 CDC (L) Single Swing

3082 Office/Admin (L)

Dual Swing

Single Swing

2202 AAFES-Mini Mall (L) Single Slide

2295 Youth Center (L) Single Swing

2109 Library (L) Single Swing

2140 Waller Hall (L) Single Swing

2022 Gym (L) Single Swing

2026 Office/Admin (L) Single Swing

2020 Barracks (L) Single Swing

2021 Barracks (L) Single Swing

2019 Office/Admin (L)

Dual Swing

Single Swing

3400 Motorpool Single Swing Main Entry 1 1 Single Swing Main Entry 1 1 Single Swing Main Entry 1 1 Single Swing Rear Entry 1 1 Single Swing Rear Entry 1 1

4170 Post Office Single Slide Main Entry 1 1 1 1 4174 Office/Admin (L) Single Swing Rear Entry 1 1

Bsmt Entry 1 1 2nd flr ♀ RR 1 1 2nd flr ♂ RR 1 1 Side Entry 1 1

♀ RR 1 1

♀ RR 1 1

♂ RR 1 1

♂ RR 1 1

Main Entry 1 1 1 1 Main Entry 1 1 1 1

Dual Slide Main Entry 1 1 1 1 East Entry 1 1 West Entry 1 1 2nd flr 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Side entry 1 1 Side entry 1 1

6995 Madigan CDC (L) single swing Main Entry 1 1 Front Entry 1 1 Front Entry 1 1

Dual Slide Rear Entry 1 1 8085 Conference Ctr (L) Dual Slide Main Entry 1 1 8300 CDC (L) Single Swing Main Entry 1 1

Single Swing Main Entry 1 1 Single Swing Main Entry 1 1

9052 Madigan Xpress (L) Single Slide Main Entry 1 1 1 1 NW Entry 1 1 NW Entry 1 1 SW Entry 1 1 NW Entry 1 1 NW Entry 1 1 SW Entry 1 1 SW Entry 1 1 Mens RR 1 1 Wmns RR 1 1 SW Entry 1 1 SW Entry 1 1 SW Entry 1 1 SW Entry 1 1 NW Entry 1 1 NW Entry 1 1

Warrior Transition

Barracks (L)

Single Swing

Dual Swing

Warrior Transition Barracks (L)

Single Swing

Warrior Transition Barracks (L)

Single Swing

NW Adventure Center (L)

Single Swing

8584 Youth Center (L)

6254 Barracks (L) Single Swing

6397 CDC (L) Dual Swing

Stone Education Center (L)

Single Swing

6251 Barracks (L) Single Swing

Shopette, Liberty gate (L)

Single Swing

Vehicle Maintenance Facility (L)

Single Swing

4290 Office/Admin (L) Single Swing

5164 Office/Admin (L) Single Swing

3685 Barracks (L)

Next Rm

1 1

Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Side entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 To Go Exit 1 1 To Go Exit 1 1

Single Swing Main Entry 1 1 Single Swing Main Entry 1 1 Single Swing RR 1 1 Single Swing RR 1 1

9993 Madigan Pool (L) Dual Swing Pool Entry 1 1 SW Entry 1 1 1 1 Ctr Entry 1 1 1 1 NE Entry 1 1 1 1 Main Entry 1 1 Main Entry 1 1

Single Slide Main Entry 1 1 1 1 Single Slide Main Entry 1 1 1 1 Dual Slide Main Entry 1 1 1 1

Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1

31301 Barracks (L) Dual Swing

31303 Barracks (L) Dual Swing

13633 Barracks (L) Single Swing

12690 Food Court

13631 Barracks (L) Single Swing

11566 Shopette (L) Dual Slide

12670 Shopette (L) Single Swing

Courage Dining

Facility Single Swing

9580 DOL Warehouse (L)

9665 DOL Warehouse (L)

Barracks (L) Single Swing

9126 Barracks (L) Single Swing

Barracks (L) Single Swing

9124 Barracks (L) Single Swing

Barracks (L) Single Swing

9121 Barracks (L) Single Swing

9123 Barracks (L) Single Swing

4 Chaplains

Memorial Chapel

Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1

Single Swing Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Back Entry 1 1 Back Entry 1 1 Back Entry 1 1

46 48 47 45 40 45 46 48 46 46 40 45 Main Entry 1 1 1 1 Main Entry 1 1 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1 Main Entry 1 1

0 0 2 0 4 2 0 0 2 0 4 2

46 48 49 45 44 47 46 48 48 46 44 47 Formula created

- PM completed MF - McChord Field

- Missed L - Lewis

- New

- DELETED

Ja nu ar y

Fe br ua ry

M ar chJu ly

Au gu st

Se pt em be r

O ct ob er

N ov em be r

De ce m be r

( Buildings 1177 & 1179) TWCF Total

Total per Month

Ap ril

M ay

Ju ne

O&M Total

J01177 Admin, Maint shop

(MF-TWCF)

Dual Slide

J01179 Air Passenger Terminal (MF-

TWCF)

Dual Swing

31341 Barracks (L) Single Swing

31370 DFAC (L) Single Swing

31322 Barracks (L) Single Swing

31340 Barracks (L) Dual Swing

31320 Barracks (L) Single Swing

31321 Barracks (L) Single Swing

Monthly Schedule

File details come from the government source that posted it. Updated .