On_Site_Briefing_Slides.pptx
PPTX presentation 863 KB Posted
- Attached to
- 88TH RSC MECS, OGDEN, UT Federal contract opportunity
- Solicitation number
- W912DY-17-R-0066
About this file
Briefing Slides Powerpoint
View the file
Other files for this federal contract opportunity
Show all 23
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
MEDICAL EQUIPMENT CONCENTRATION SITE 88TH RSC
| PROJECT | TEAM |
| Title: Medical Equipment Maintenance |
Scope: Provide Stand Alone Contract for Maintenance, Supply, Storage, parts Procurement, Surge Support Capability and Training Support to the 88th RSC MECS USACE PM: Mr. Frank Brown Onsite: W01 Jeff Franklin, SSG Kelly Chartier USACE KO: Mr. Jeff Roberts (Chris Shepard) 88th RSC POC: Mr. Stephen Rivera
| STATUS | GREEN | ISSUES |
| Contract: |
Growth of facility is expected to continue Improvements and expansion of facility are in the works Monthly credit card limit of at least $25,000 to accommodate parts ordering New software for tracking medical maintenance will be implemented in last week of September Success of current workforce has caused the MECS to out-grow its current contract.
Hands On Training (HOT) Mission on Site:
50 Soldiers performed Annual training here last FY Only 2 Soldiers so far this year We can handle up to 6 Soldiers a week. GCSS-Army:
MECS cannot build or order Class VIII (84/85) parts in G-Army (CASCOM directive: wait for DA G4 and MEDCOM guidance). Have not received guidance on process to create NSN’s for parts not in G-ARMY.
G-Army property scrub findings: 89% complete
Other:
Gap Analysis: Growth of workload due to initial storage (equipment severely delinquent on services), external work orders, and being undermanned to complete just the annual PM services (hidden in the past by TPU support, 3840 hrs. last FY), has created a large backlog that is steadily increasing.
196 external repair work orders this FY.
F2N units are high priority and take precedence over scheduled PM’s.
70 items scheduled to be gained this month.
WORK ORDERS
>90 average= -110 days
Total Equipment stored here: 5,577 Equipment requiring maintenance gained this FY: 761
Repair Returns for this FY: 196 Code H this FY: 229
| STATUS | 0-30 days | 31-60 days | 61-90 days | Over 90 days | Total |
| 1 - Awaiting NMCS Parts. | 1 | 1 | 0 | 7 | 9 |
| B - In Shop. | 18 | 6 | 6 | 19 | 49 |
| C - Awaiting Shop (if not started). | 199 | 21 | 519 | 567 | 1306 |
| E - In/Awaiting QC/QA Maintenance Final Inspe | 3 | 3 | 19 | 15 | 40 |
| K - Awaiting Parts (Not NMCS). | 0 | 3 | 9 | 16 | 28 |
| M - Evacuated for Repair and Return. | 4 | 2 | 0 | 0 | 6 |
| TOTAL | 225 | 36 | 553 | 624 | 1438 |
| Last Week Numbers | 163 | 31 | 743 | 467 | 1404 |
Thirty nine last month. Total of seven with six of those being TMDE
TOTAL [CELLRANGE]
[CELLRANGE]
[CELLRANGE]
[CELLRANGE]
225 36 553 624 225 36 553 624
WORK LOAD
196 External Work Orders and 761 items being added to inventory have accounted for 32% of our annual workload. These two types of work orders put a strain on our regularly scheduled work and are the most difficult to plan for since most of them need repairs.
[CATEGORY NAME]
[PERCENTAGE]
Scheduled PM WO's Completed Initial Receipt WO's External WO's 2004 761 196
BACKLOG HISTORY
31-60 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 146 82 65 11 47 387 253 759 505 870 31 36 61-90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 0 38 2 116 50 52 311 84 486 289 743 553 Over 90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 19 3 2 4 8 85 27 298 467 624 TMDE 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 7 1 0 0 1 0 0 0 0 0
Monthly WO Completion
Scheduled 42720 42751 42782 42810 42841 42871 42902 158 215 210 462 295 571 281 Repair and return 42720 42751 42782 42810 42841 42871 42902 15 81 80 8 0 0 12
OUTLOOK
Units with equipment currently stored at the MECS
-59 units tagged to store Equipment at the MECS 88 by original OPORD.
-24 units have not started -31 of the Units are storing Medical Equipment at the MECS (36 Total= 5 not directed by command) -4 units are scheduled to store equipment at the MECS. A co. 328th CSH, 437th AMB(rescheduled), 444th MCD, Bco 452nd CSH
Scheduled to store equipment
Authorized by OPORD but NOT STARTED
VENT ROOM
Break Room
TMDE & PARTS
Contractor Office Military Office and Conference Vent Room
GASES
Server Tools
BULK
PARTS
Awaiting QA
X-RAY
Complete Awaiting Shop Awaiting Parts ISO Shelters Warehouse
WET AREA
971st MED LOG Medical Maintenance Shop
GASES
BAY 7
971st MED LOG CLASS VIII Warehouse 971 MLC Office
ISO Shelters Warehouse
STAGING AREA / UNIT LAYOUT
BAY 6
807th Office /Break Room F2N / AERF Storage ISO Shelters / Dry Storage Warehouse
Deans Office
BAY 5
Conex Storage
MEDICAL EQUIPMENT CONCENTRATION SITE 88TH RSC
Questions or Comments?
image1.png image2.wmf
Microsoft_Excel_Worksheet1.xlsx Charts
STATUS 0-30 days 31-60 days 61-90 days Over 90 days Total
1 - Awaiting NMCS Parts. 1 1 0 7 9
B - In Shop. 18 6 6 19 49
C - Awaiting Shop (if not started). 199 21 519 567 1306 31-60 days 61-90 days Over 90 days TMDE
E - In/Awaiting QC/QA Maintenance Final Inspe 3 3 19 15 40 Dec-15 241 60 39 5
K - Awaiting Parts (Not NMCS). 0 3 9 16 28 Jan-16 83 23 7 6
M - Evacuated for Repair and Return. 4 2 0 0 6 Feb-16 45 15 16 13
TOTAL 225 36 553 624 1438 Mar-16 35 17 8 7
Last Week Numbers 163 31 743 467 1404 Apr-16 79 1 11 11
May-16 1090 38 5 5
Jun-16 51 505 5 3
Jul-16 10 21 70 1
Aug-16 146 0 1 1 ````````````````````````````````````````````````````
Sep-16 82 38 1 1
Oct-16 65 2 19 7
Nov-16 11 116 3 1
Dec-16 47 50 2 0
Jan-17 387 52 4 0
Feb-17 253 311 8 1
Mar-17 759 84 85 0
Apr-17 505 486 27 0
May-17 870 289 298 0
Jun-17 31 743 467 0
Jul-17 36 553 624 0
TOTAL [CELLRANGE]
[CELLRANGE]
225 36 553 624 225 36 553 624
31-60 days 42782 42810 42841 42871 42902 42932 253 759 505 870 31 36 61-90 days 42782 42810 42841 42871 42902 42932 311 84 486 289 743 553 Over 90 days 42782 42810 42841 42871 42902 42932 8 85 27 298 467 624 TMDE 42782 42810 42841 42871 42902 42932 1 0 0 0 0 0 scrub
DATABASE OF 5637 Items
Missing in SLOC Need Removed from SLOC NON-Maintenance SYNCED NIIN Incorrect SN Change SN incorrect
579 72 526 4093 36 269 62
SYNCED 4093
SYNCED but need SN updated 331
In SLOC but not Maintenance Significant 526
Missing from SLOC 579
Built under incorrect Material# 36
Need Removed from SLOC 72
TOTAL 5637
DATABASE OF 5637 Items SN ISSUES
[PERCENTAGE]
Missing in SLOC Need Removed from SLOC NON-Maintenance SYNCED NIIN Incorrect SN Change SN incorrect 579 72 526 4093 36 269 62 image3.png image4.jpg image5.png
Microsoft_Excel_Worksheet2.xlsx
STATUS 0-30 days 31-60 days 61-90 days Over 90 days Total
1 - Awaiting NMCS Parts. 2 3 19 2 26
A - Awaiting Initial Inspection. 0 0 0 0 0
B - In Shop. 3 16 10 0 29 31-60 days 61-90 days Over 90 days TMDE
C - Awaiting Shop (if not started). 547 6 6 0 559 Dec-15 241 60 39 5
E - In/Awaiting QC/QA Maintenance Final Inspe 14 6 9 0 29 Jan-16 83 23 7 6
K - Awaiting Parts (Not NMCS). 0 9 5 0 14 Feb-16 45 15 16 13
M - Evacuated for Repair and Return. 1 7 1 0 9 Mar-16 35 17 8 7
TOTAL 567 47 50 2 FY total Apr-16 79 1 11 11
External Maintenance Request 3 0 0 0 52 May-16 1090 38 5 5
Jun-16 51 505 5 3
Jul-16 10 21 70 1 ````````````````````````````````````````````````````
Aug-16 146 0 1 1
Sep-16 82 38 1 1
Oct-16 65 2 19 7
Nov-16 11 116 3 1
Dec-16 47 50 2 0
TOTAL [CELLRANGE]
567 47 50 2 0 567 47 50 2
31-60 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 241 83 45 35 79 1090 51 10 146 82 65 11 47 61-90 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 60 23 15 17 1 38 505 21 0 38 2 116 50 Over 90 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 39 7 16 8 11 5 5 70 1 1 19 3 2 TMDE 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 5 6 13 7 11 5 3 1 1 1 7 1 0
G-ARMY WO
Admin No. Main work center Priority Order Type Order System Condition Material Description Description System status Entered by DAYS OLD Created on Material Serial Number Equipment Sort field Project Code Fund Code
W6KG01 4 PM06 6000059215 K 5411-01-295-3433 SN USAU0709719 REL MSPT PRC SETC 1152892477 424 13-May-2016 NK
W6KG01-BFZ567 W6KG01 PM02 2000180810 N CALIBRATOR SET,X-RAY CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015897774 176061 1009915604 OK96525 NK
W6KG01-BFZ573 W6KG01 PM02 2000180809 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1800028 1009917822 9BU6515 NK
W6KG01-BFZ578 W6KG01 PM02 2000180808 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1789034 1009917066 9BU6515 NK
W6KG01-BFZ615 W6KG01 PM02 2000180807 N METER ILLUMINATION CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015748935 259409 1009891929 0GD6695 NK
W6KG01 1 PM06 6000050401 1 SERIAL NUMBER 102220804 SAMS WO L601457 REL CSER MACM PPRT PRC SETC 1152892477 433 4-May-2016 NK
W6KG01-BFZ597 W6KG01 PM02 2000171491 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783008 1009924459 8ZH6515 NK
W6KG01-BFZ601 W6KG01 PM02 2000171490 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783006 1009924453 8ZH6515 NK
W6KG01-BFZ599 W6KG01 PM02 2000171489 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1782013 1009924438 8ZH6515 NK
W6KG01-BFZ649 W6KG01 PM02 2000171488 N METER ULTRASOUND PWR CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015938218 8032291049 1009907626 0K86695 NK
W6KG01-BFZ631 W6KG01 PM02 2000171487 N SIMULATOR CARDIAC CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015483352 163724 1009904080 9ZB6625 NK
W6KG01-BFZ628 W6KG01 PM02 2000171486 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14616 1009923847 8Z36515 NK
W6KG01-BFZ627 W6KG01 PM02 2000171484 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14626 1009923862 8Z36515 NK
W6KG01-BFZ637 W6KG01 4 PM01 1000487740 N TESTER SAFETY ELECT CALIBRATION DUE REL NMAT PRC SETC 1152892477 434 3-May-2016 015776744 1703009 1009901301 0GG6625 NK
W6KG01-BFZ624 W6KG01 PM02 2000158993 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060075ES 1009901894 8Z56630 NK
W6KG01-BFZ605 W6KG01 PM02 2000158988 N TESTER PULSE OXIMETER CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015410432 1798004 1009902487 9ZC6515 NK
W6KG01-BFZ600 W6KG01 PM02 2000158987 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1783005 1009924445 8ZH6515 NK
W6KG01-BFZ598 W6KG01 PM02 2000158986 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1785020 1009924467 8ZH6515 NK
W6KG01-BFZ623 W6KG01 PM02 2000158985 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060076ES 1009901910 8Z56630 NK
W6KG01-BFZ590 W6KG01 PM02 2000158961 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1572062 1009922444 0GE6515 NK
W6KG01-BFZ595 W6KG01 PM02 2000158960 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1573002 1009922468 0GE6515 NK
W6KG01-BFZ592 W6KG01 PM02 2000158455 M ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1571025 1009922433 0GE6515 NK
W6KG01-BFZ645 W6KG01 2 PM01 1000471618 N TESTER VENTILATOR PTB REPAIR LEAK PEEP TEST REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491421 SL01599 1009920222 8ZR6515 NK
W6KG01 2 PM06 6000039281 AIR CONDITIONER SN 2038 L601644 REL MSPT PRC SETC 1152892477 453 14-Apr-2016
Sheet1
Scheduled PM WO's Completed 2004 68%
Initial Receipt WO's 761 26%
External WO's 196 7%
Scheduled PM WO's Completed Initial Receipt WO's External WO's 2004 761 196
Microsoft_Excel_Worksheet3.xlsx
STATUS 0-30 days 31-60 days 61-90 days Over 90 days Total
1 - Awaiting NMCS Parts. 2 3 19 2 26
A - Awaiting Initial Inspection. 0 0 0 0 0
B - In Shop. 3 16 10 0 29 31-60 days 61-90 days Over 90 days TMDE
C - Awaiting Shop (if not started). 547 6 6 0 559 Dec-15 241 60 39 5
E - In/Awaiting QC/QA Maintenance Final Inspe 14 6 9 0 29 Jan-16 83 23 7 6
K - Awaiting Parts (Not NMCS). 0 9 5 0 14 Feb-16 45 15 16 13
M - Evacuated for Repair and Return. 1 7 1 0 9 Mar-16 35 17 8 7
TOTAL 567 47 50 2 FY total Apr-16 79 1 11 11
External Maintenance Request 3 0 0 0 52 May-16 1090 38 5 5
Jun-16 51 505 5 3
Jul-16 10 21 70 1 ````````````````````````````````````````````````````
Aug-16 146 0 1 1
Sep-16 82 38 1 1
Oct-16 65 2 19 7
Nov-16 11 116 3 1
Dec-16 47 50 2 0
TOTAL [CELLRANGE]
567 47 50 2 0 567 47 50 2
31-60 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 241 83 45 35 79 1090 51 10 146 82 65 11 47 61-90 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 60 23 15 17 1 38 505 21 0 38 2 116 50 Over 90 days 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 39 7 16 8 11 5 5 70 1 1 19 3 2 TMDE 42339 42370 42401 42430 42461 42506 42537 42567 42598 42629 42659 42690 42720 5 6 13 7 11 5 3 1 1 1 7 1 0
Admin No. Main work center Priority Order Type Order System Condition Material Description Description System status Entered by DAYS OLD Created on Material Serial Number Equipment Sort field Project Code Fund Code
W6KG01 4 PM06 6000059215 K 5411-01-295-3433 SN USAU0709719 REL MSPT PRC SETC 1152892477 424 13-May-2016 NK
W6KG01-BFZ567 W6KG01 PM02 2000180810 N CALIBRATOR SET,X-RAY CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015897774 176061 1009915604 OK96525 NK
W6KG01-BFZ573 W6KG01 PM02 2000180809 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1800028 1009917822 9BU6515 NK
W6KG01-BFZ578 W6KG01 PM02 2000180808 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1789034 1009917066 9BU6515 NK
W6KG01-BFZ615 W6KG01 PM02 2000180807 N METER ILLUMINATION CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015748935 259409 1009891929 0GD6695 NK
W6KG01 1 PM06 6000050401 1 SERIAL NUMBER 102220804 SAMS WO L601457 REL CSER MACM PPRT PRC SETC 1152892477 433 4-May-2016 NK
W6KG01-BFZ597 W6KG01 PM02 2000171491 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783008 1009924459 8ZH6515 NK
W6KG01-BFZ601 W6KG01 PM02 2000171490 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783006 1009924453 8ZH6515 NK
W6KG01-BFZ599 W6KG01 PM02 2000171489 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1782013 1009924438 8ZH6515 NK
W6KG01-BFZ649 W6KG01 PM02 2000171488 N METER ULTRASOUND PWR CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015938218 8032291049 1009907626 0K86695 NK
W6KG01-BFZ631 W6KG01 PM02 2000171487 N SIMULATOR CARDIAC CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015483352 163724 1009904080 9ZB6625 NK
W6KG01-BFZ628 W6KG01 PM02 2000171486 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14616 1009923847 8Z36515 NK
W6KG01-BFZ627 W6KG01 PM02 2000171484 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14626 1009923862 8Z36515 NK
W6KG01-BFZ637 W6KG01 4 PM01 1000487740 N TESTER SAFETY ELECT CALIBRATION DUE REL NMAT PRC SETC 1152892477 434 3-May-2016 015776744 1703009 1009901301 0GG6625 NK
W6KG01-BFZ624 W6KG01 PM02 2000158993 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060075ES 1009901894 8Z56630 NK
W6KG01-BFZ605 W6KG01 PM02 2000158988 N TESTER PULSE OXIMETER CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015410432 1798004 1009902487 9ZC6515 NK
W6KG01-BFZ600 W6KG01 PM02 2000158987 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1783005 1009924445 8ZH6515 NK
W6KG01-BFZ598 W6KG01 PM02 2000158986 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1785020 1009924467 8ZH6515 NK
W6KG01-BFZ623 W6KG01 PM02 2000158985 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060076ES 1009901910 8Z56630 NK
W6KG01-BFZ590 W6KG01 PM02 2000158961 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1572062 1009922444 0GE6515 NK
W6KG01-BFZ595 W6KG01 PM02 2000158960 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1573002 1009922468 0GE6515 NK
W6KG01-BFZ592 W6KG01 PM02 2000158455 M ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1571025 1009922433 0GE6515 NK
W6KG01-BFZ645 W6KG01 2 PM01 1000471618 N TESTER VENTILATOR PTB REPAIR LEAK PEEP TEST REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491421 SL01599 1009920222 8ZR6515 NK
W6KG01 2 PM06 6000039281 AIR CONDITIONER SN 2038 L601644 REL MSPT PRC SETC 1152892477 453 14-Apr-2016
Sheet1
Scheduled PM WO's Completed 2004 68%
Initial Receipt WO's 761 26%
External WO's 196 7%
Scheduled PM WO's Completed Initial Receipt WO's External WO's 2004 761 196
Microsoft_Excel_Worksheet4.xlsx
STATUS 0-30 days 31-60 days 61-90 days Over 90 days Total
1 - Awaiting NMCS Parts. 2 3 19 2 26
A - Awaiting Initial Inspection. 0 0 0 0 0
B - In Shop. 3 16 10 0 29 31-60 days 61-90 days Over 90 days TMDE
C - Awaiting Shop (if not started). 547 6 6 0 559 Dec-15 241 60 39 5
E - In/Awaiting QC/QA Maintenance Final Inspe 14 6 9 0 29 Jan-16 83 23 7 6
K - Awaiting Parts (Not NMCS). 0 9 5 0 14 Feb-16 45 15 16 13
M - Evacuated for Repair and Return. 1 7 1 0 9 Mar-16 35 17 8 7
TOTAL 567 47 50 2 FY total Apr-16 79 1 11 11
External Maintenance Request 3 0 0 0 52 May-16 1090 38 5 5
Jun-16 51 505 5 3
Jul-16 10 21 70 1 ````````````````````````````````````````````````````
Aug-16 146 0 1 1
Sep-16 82 38 1 1
Oct-16 65 2 19 7
Nov-16 11 116 3 1
Dec-16 47 50 2 0
Jan-17 387 52 4 0
Feb-17 253 311 8 1
Mar-17 759 84 85 0
Apr-17 505 486 27 0
May-17 870 289 298 0
Jun-17 31 743 467 0
Jul-17 36 553 624 0
TOTAL [CELLRANGE]
567 47 50 2 0 567 47 50 2
31-60 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 146 82 65 11 47 387 253 759 505 870 31 36 61-90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 0 38 2 116 50 52 311 84 486 289 743 553 Over 90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 19 3 2 4 8 85 27 298 467 624 TMDE 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 7 1 0 0 1 0 0 0 0 0
Admin No. Main work center Priority Order Type Order System Condition Material Description Description System status Entered by DAYS OLD Created on Material Serial Number Equipment Sort field Project Code Fund Code
W6KG01 4 PM06 6000059215 K 5411-01-295-3433 SN USAU0709719 REL MSPT PRC SETC 1152892477 424 13-May-2016 NK
W6KG01-BFZ567 W6KG01 PM02 2000180810 N CALIBRATOR SET,X-RAY CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015897774 176061 1009915604 OK96525 NK
W6KG01-BFZ573 W6KG01 PM02 2000180809 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1800028 1009917822 9BU6515 NK
W6KG01-BFZ578 W6KG01 PM02 2000180808 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1789034 1009917066 9BU6515 NK
W6KG01-BFZ615 W6KG01 PM02 2000180807 N METER ILLUMINATION CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015748935 259409 1009891929 0GD6695 NK
W6KG01 1 PM06 6000050401 1 SERIAL NUMBER 102220804 SAMS WO L601457 REL CSER MACM PPRT PRC SETC 1152892477 433 4-May-2016 NK
W6KG01-BFZ597 W6KG01 PM02 2000171491 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783008 1009924459 8ZH6515 NK
W6KG01-BFZ601 W6KG01 PM02 2000171490 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783006 1009924453 8ZH6515 NK
W6KG01-BFZ599 W6KG01 PM02 2000171489 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1782013 1009924438 8ZH6515 NK
W6KG01-BFZ649 W6KG01 PM02 2000171488 N METER ULTRASOUND PWR CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015938218 8032291049 1009907626 0K86695 NK
W6KG01-BFZ631 W6KG01 PM02 2000171487 N SIMULATOR CARDIAC CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015483352 163724 1009904080 9ZB6625 NK
W6KG01-BFZ628 W6KG01 PM02 2000171486 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14616 1009923847 8Z36515 NK
W6KG01-BFZ627 W6KG01 PM02 2000171484 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14626 1009923862 8Z36515 NK
W6KG01-BFZ637 W6KG01 4 PM01 1000487740 N TESTER SAFETY ELECT CALIBRATION DUE REL NMAT PRC SETC 1152892477 434 3-May-2016 015776744 1703009 1009901301 0GG6625 NK
W6KG01-BFZ624 W6KG01 PM02 2000158993 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060075ES 1009901894 8Z56630 NK
W6KG01-BFZ605 W6KG01 PM02 2000158988 N TESTER PULSE OXIMETER CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015410432 1798004 1009902487 9ZC6515 NK
W6KG01-BFZ600 W6KG01 PM02 2000158987 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1783005 1009924445 8ZH6515 NK
W6KG01-BFZ598 W6KG01 PM02 2000158986 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1785020 1009924467 8ZH6515 NK
W6KG01-BFZ623 W6KG01 PM02 2000158985 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060076ES 1009901910 8Z56630 NK
W6KG01-BFZ590 W6KG01 PM02 2000158961 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1572062 1009922444 0GE6515 NK
W6KG01-BFZ595 W6KG01 PM02 2000158960 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1573002 1009922468 0GE6515 NK
W6KG01-BFZ592 W6KG01 PM02 2000158455 M ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1571025 1009922433 0GE6515 NK
W6KG01-BFZ645 W6KG01 2 PM01 1000471618 N TESTER VENTILATOR PTB REPAIR LEAK PEEP TEST REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491421 SL01599 1009920222 8ZR6515 NK
W6KG01 2 PM06 6000039281 AIR CONDITIONER SN 2038 L601644 REL MSPT PRC SETC 1152892477 453 14-Apr-2016
Microsoft_Excel_Worksheet5.xlsx
STATUS 0-30 days 31-60 days 61-90 days Over 90 days Total
1 - Awaiting NMCS Parts. 2 3 19 2 26
A - Awaiting Initial Inspection. 0 0 0 0 0
B - In Shop. 3 16 10 0 29 31-60 days 61-90 days Over 90 days TMDE
C - Awaiting Shop (if not started). 547 6 6 0 559 Dec-15 241 60 39 5
E - In/Awaiting QC/QA Maintenance Final Inspe 14 6 9 0 29 Jan-16 83 23 7 6
K - Awaiting Parts (Not NMCS). 0 9 5 0 14 Feb-16 45 15 16 13
M - Evacuated for Repair and Return. 1 7 1 0 9 Mar-16 35 17 8 7
TOTAL 567 47 50 2 FY total Apr-16 79 1 11 11
External Maintenance Request 3 0 0 0 52 May-16 1090 38 5 5
Jun-16 51 505 5 3
Jul-16 10 21 70 1 ````````````````````````````````````````````````````
Aug-16 146 0 1 1
Sep-16 82 38 1 1
Oct-16 65 2 19 7
Nov-16 11 116 3 1
Dec-16 47 50 2 0
Jan-17 387 52 4 0
Feb-17 253 311 8 1
Mar-17 759 84 85 0
Apr-17 505 486 27 0
May-17 870 289 298 0
Jun-17 31 743 467 0
Jul-17 36 553 624 0
TOTAL [CELLRANGE]
567 47 50 2 0 567 47 50 2
31-60 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 146 82 65 11 47 387 253 759 505 870 31 36 61-90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 0 38 2 116 50 52 311 84 486 289 743 553 Over 90 days 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 19 3 2 4 8 85 27 298 467 624 TMDE 42598 42629 42659 42690 42720 42751 42782 42810 42841 42871 42902 42932 1 1 7 1 0 0 1 0 0 0 0 0
Completion
Scheduled Repair and return
Dec-16 158 15 15
Jan-17 215 81 96 81
Feb-17 210 80 176 80
Mar-17 462 8 184 8
Apr-17 295 0 184 0
May-17 571 0 184 0
Jun-17 281 12 196 12
Jul-17
Scheduled 42720 42751 42782 42810 42841 42871 42902 158 215 210 462 295 571 281 Repair and return 42720 42751 42782 42810 42841 42871 42902 15 81 80 8 0 0 12
Admin No. Main work center Priority Order Type Order System Condition Material Description Description System status Entered by DAYS OLD Created on Material Serial Number Equipment Sort field Project Code Fund Code
W6KG01 4 PM06 6000059215 K 5411-01-295-3433 SN USAU0709719 REL MSPT PRC SETC 1152892477 424 13-May-2016 NK
W6KG01-BFZ567 W6KG01 PM02 2000180810 N CALIBRATOR SET,X-RAY CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015897774 176061 1009915604 OK96525 NK
W6KG01-BFZ573 W6KG01 PM02 2000180809 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1800028 1009917822 9BU6515 NK
W6KG01-BFZ578 W6KG01 PM02 2000180808 N ANALYZER GAS FLOW CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015412864 1789034 1009917066 9BU6515 NK
W6KG01-BFZ615 W6KG01 PM02 2000180807 N METER ILLUMINATION CALIBRATION DUE REL PCNF PRT NMAT PRC SETC 1152892477 424 13-May-2016 015748935 259409 1009891929 0GD6695 NK
W6KG01 1 PM06 6000050401 1 SERIAL NUMBER 102220804 SAMS WO L601457 REL CSER MACM PPRT PRC SETC 1152892477 433 4-May-2016 NK
W6KG01-BFZ597 W6KG01 PM02 2000171491 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783008 1009924459 8ZH6515 NK
W6KG01-BFZ601 W6KG01 PM02 2000171490 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1783006 1009924453 8ZH6515 NK
W6KG01-BFZ599 W6KG01 PM02 2000171489 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 014491423 1782013 1009924438 8ZH6515 NK
W6KG01-BFZ649 W6KG01 PM02 2000171488 N METER ULTRASOUND PWR CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015938218 8032291049 1009907626 0K86695 NK
W6KG01-BFZ631 W6KG01 PM02 2000171487 N SIMULATOR CARDIAC CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015483352 163724 1009904080 9ZB6625 NK
W6KG01-BFZ628 W6KG01 PM02 2000171486 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14616 1009923847 8Z36515 NK
W6KG01-BFZ627 W6KG01 PM02 2000171484 N ANALYZ IV INFU PUMP CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 433 4-May-2016 015362122 14626 1009923862 8Z36515 NK
W6KG01-BFZ637 W6KG01 4 PM01 1000487740 N TESTER SAFETY ELECT CALIBRATION DUE REL NMAT PRC SETC 1152892477 434 3-May-2016 015776744 1703009 1009901301 0GG6625 NK
W6KG01-BFZ624 W6KG01 PM02 2000158993 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060075ES 1009901894 8Z56630 NK
W6KG01-BFZ605 W6KG01 PM02 2000158988 N TESTER PULSE OXIMETER CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015410432 1798004 1009902487 9ZC6515 NK
W6KG01-BFZ600 W6KG01 PM02 2000158987 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1783005 1009924445 8ZH6515 NK
W6KG01-BFZ598 W6KG01 PM02 2000158986 N ANALYZER NONINVAS BLD CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491423 1785020 1009924467 8ZH6515 NK
W6KG01-BFZ623 W6KG01 PM02 2000158985 N ANALYZER GAS PRTBLE CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015307959 145060076ES 1009901910 8Z56630 NK
W6KG01-BFZ590 W6KG01 PM02 2000158961 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1572062 1009922444 0GE6515 NK
W6KG01-BFZ595 W6KG01 PM02 2000158960 N ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1573002 1009922468 0GE6515 NK
W6KG01-BFZ592 W6KG01 PM02 2000158455 M ANALYZER DEFIB EKG CALIBRATION DUE REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 015752825 1571025 1009922433 0GE6515 NK
W6KG01-BFZ645 W6KG01 2 PM01 1000471618 N TESTER VENTILATOR PTB REPAIR LEAK PEEP TEST REL PRT NMAT PRC SETC 1152892477 445 22-Apr-2016 014491421 SL01599 1009920222 8ZR6515 NK
W6KG01 2 PM06 6000039281 AIR CONDITIONER SN 2038 L601644 REL MSPT PRC SETC 1152892477 453 14-Apr-2016 image6.jpg
File details come from the government source that posted it. Updated .