APPENDIX_D__WORKLOAD_DATA.pdf

APPENDIX D

KIRTLAND SUPPLY WORKLOAD DATA

The following workload data is the governments best estimate of the volume of work shown for each item listed. This is not intended to cover all the workload items, but lists the major categories of work. Unless payments or deductions for variations in one or more of these workloads are addressed in a Special Provision or other portion of this contract, payments or deductions will not be made for any variation in the estimated quantities listed.

# DESCRIPTION Jul 15 Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun 16 Avg/Mo

TRANSACTION

SUMMARY "TOTAL

TRANS - THIS SD" B/E

ACCOUNT

40,022 37,617 50,320 53,446 40,684 50,320 42,542 40,266 61,495 49,824 41,792 59,503 47,319

1a PRINTABLE TRANSACTIONS 32,470 32,138 39,817 41,108 29,506 40,388 27,287 26,976 45,211 28,479 29,117 41,278 34,481

2 TOTAL TRANSACTIONS

"SUPPLIES" 38,204 34,938 48,747 50,309 38,859 54,288 40,016 37,152 59,952 41,718 39,658 58,353 45,183

3 TOTAL TRANSACTIONS

"EQUIPMENT" 1,818 2,979 1,573 3,137 1,825 1,945 2,526 3,114 1,543 8,106 2,134 1,150 2,654

REQUISITIONS

SUBMITTED "TOTAL -

NBR"

2,350 2,528 3,379 2,281 2,335 3,385 2,291 2,103 3,778 2,030 2,617 3,977 2,755

TOTAL ISSUES

PROCESSED "L/I

REQUESTED" DIFM, EOQ,

EQUIPMENT, BENCH

STOCK

3,055 3,016 2,781 2,963 3,182 2,685 3,470 2,528 3,235 3,023 3,141 3,422 3,042

5a.

TOTAL LINE ITEMS

ISSUED DIFM, EOQ,

EQUIPMENT, BENCH

STOCK

2,485 2,423 2,228 2,466 2,644 2,176 2,866 2,069 2,681 2,501 2,629 2,794 2,497

5b.

TOTAL UNITS ISSUED

DIFM, EOQ, EQUIPMENT,

BENCH STOCK

30,323 24,127 22,866 25,999 21,781 20,691 50,355 14,344 29,231 25,199 28,883 21,521 26,277

6 ISSUE EXCEPTION CODE

8 "IEX 8 HEALTH HAZ" 0 0 0 0 0 0 0 0 0 0 0 0 0

7 ISSUE EXCEPTION CODE

9 "IEX 9 HEALTH HAZ" 262 284 305 268 266 288 244 229 257 205 215 244 256

EXPEDITE/ROUTINE D/O

ESTABLISHED "TOTAL

DUE-OUT"

1,018 1,036 845 829 779 637 880 743 829 726 870 892 840

DUE-OUT

CANCELLATIONS

"TOTAL L/I"

33 0 31 1 5 40 33 62 53 30 49 74 34

TOTAL RECEIPTS

PROCESSED "TOTAL

RECEIPTS"

2,041 2,150 2,719 1,786 2,148 2,919 1,683 1,766 2,992 1,564 2,190 2,841 2,233

10a. TOTAL UNITS

PROCESSED 15,496 39,982 48,465 14,337 19,729 34,216 28,704

TOTAL SHIPMENTS

PROCESSED ("RDO" +

"TOTAL SHIPMENTS")

914 670 1,175 837 667 1,622 738 773 1,262 820 836 1,380 975

11a. TOTAL UNITS

PROCESSED 5,008 5,645 12,137 5,828 4,450 15,566 8,106

12 TOTAL DUE-OUT REL 1,005 1,126 970 741 957 829 772 834 899 659 986 872 888

12a. TOTAL UNITS

PROCESSED 5,122 12,203 6,027 4,787 4,622 8,161 6,820

13 TOTAL RECORD

REVERSES 23 13 17 17 5 21 7 12 11 8 10 23 14

TOTAL INVENTORY

ADJUSTMENTS "TOTAL

INV ADJ"

36 3 3 4 10 45 21 20 17 20 32 7 18

TOTAL TURN-INS

PROCESSED "TOTAL

TURN-IN

365 530 641 423 359 477 379 312 392 368 389 407 420

15a. TOTAL UNITS

PROCESSED 1,386 379 537 661 936 2,651 1,092

16 EAID TURN-INS 22 82 16 53 17 8 32 32 40 58 53 19 36

DIFM TURNED INTO

SUPPLY "TURN-IN

CAMS"

296 345 285 298 270 290 235 218 255 195 256 287 269

CONDITION CODE

CHANGES "TOTAL COND

CHANGE"

49 39 33 79 80 51 36 52 49 42 52 45 51

19 MICAP START

"OVERALL SUMMARY" 151 150 173 152 121 139 93 165 156 102 168 151 143

MICAP TERMINATIONS

"DELETE CODE

OVERALL SUMMARY"

151 154 162 134 138 145 96 146 181 117 172 147 145

21 ORG RECORDS

MAINTAINED OCCR 545 546 547 547 547 547 562 564 564 565 565 567 556

ITEM RECORDS

MAINTAINED "I/R B/E

ACCT (101)"

35,236 35,331 35,639 35,242 35,342 35,687 35,421 35,417 35,804 35,343 35,371 35,751 35,465

SPECIAL LEVELS

MAINTAINED "SPECIAL

LEVEL DET (216)"

43,609 43,981 44,298 44,023 44,290 44,519 44,443 44,526 45,072 44,760 44,800 45,170 44,458

ITEMS RECORDS ADDED

TO ACCT "ITEM RCD -

ADD"

516 343 410 314 366 389 376 315 462 310 407 439 387

ITEM RECORDS

DELETED FROM ACCT.

"ITEM RCD DEL" P

634 246 99 708 264 41 641 317 74 771 375 58 352

26 NON-LISTED LINE ITEMS

"LOC ASG NSN" 173 173 172 170 170 170 169 169 169 168 167 167 170

EAID DETAILS

MAINTAINED "AUTH IN-

USE DET (201)"

8,084 8,087 8,116 8,083 8,044 8,043 8,050 8,048 8,043 8,015 7,997 7,999 8,051

27a

TOTAL EQUIPMENT

ACCOUNTS (PRIME AND

SUB - R14)

221 221 221 221 221 221 214 213 213 214 214 215 217

27b

TOTAL UNITS

AUTHORIZED

(R14) 18,099 18,114 18,154 18,102 18,137 17,876 18,080

27c TOTAL UNITS IN-USE (R14) 17,733 17,749 17,991 17,678 17,652 17,591 17,732

LINE ITEMS AUTH

BENCHSTOCK "MASTER

B/S DET (217)"

7,010 6,921 6,920 6,924 7,090 7,095 6,870 6,731 6,740 6,744 6,758 6,772 6,881

LINE ITEMS AUTH

SUPPLY POINT "Supply Point Det (218)

50 50 50 50 50 50 51 50 50 50 50 49 50

SUPPLY POINT

TRANSACTIONS "TOTAL

SUPPLY POINT"

50 75 67 33 47 73 36 78 64 71 54 57 59

31 IEU ISS/DUO/DOR/TIN

TOTAL UNIT Transactions 2,495 12,305 2,215 1,038 968 812 1,317 1,345 1,502 829 1,197 1,587 2,301

32 IEU LINE ITEMS

MANAGED 392 433 454 451 449 467 480 504 532 510 529 551 479

FCS Total WHSE LOC

Changes "TOTAL WHSE

LOC CHANGES"

241 383 590 1,198 225 1,805 243 273 782 153 225 443 547

DOCUMENT CONTROL

IMAGES "DCC

PRODUCED"

1,658 2,004 1,632 2,126 2,002 1,777 1,813 1,427 2,065 2,049 2,470 1,811 1,903

DELINQUENT SHIPMENT

SUSPENSE DETAILS B38

"SSC PROCESSED"

913 866 1,148 792 663 932 915 827 1,282 1,066 821 1,389 968

COMPLETE

INVENTORY/COUNTED

"LINE ITEMS COUNTED"

1,952 854 12 3,755 2,267 2,842 2,461 3,061 1,807 8,195 3,034 2,031 2,689

COMPLETE/SPECIAL

UNITS

INVENTORIED/COUNTED

"TOTAL-RECORD

BALANCE"

24,878 6,798 324 86,589 43,161 72,575 44,280 31,623 32,775 49,685 46,974 58,593 41,521

38 SPR OFF-LINE 524 567 962 494 630 917 548 600 1,126 509 673 1,120 723

39 TOTAL DRMS 98 206 99 261 114 120 152 112 151 194 157 136 150

# Workload Not Reported on M32

1 BENCH STOCK

ACCOUNTS 28 28 28 28 28 28 27 27 27 27 27 29 28

2 AF FORM 601

PROCESSED 24 16 46 43 78 52 85 22 53 88 44 24 48

MANDATORY ADPE

REPORTS & LISTINGS

END OF DAY

699 733 730 667 632 634 601 664 763 625 667 730 679

REPORTS & LISTINGS

END OF MONTH

20 26 22 20 19 20 19 18 19 20 19 20 20

REPORTS & LISTINGS

END OF QTR

0 0 2 1 0 3 0 0 4 0 0 7 1

REPORTS & LISTINGS

SEMIANNUAL

0 0 0 1 0 0 0 0 1 0 0 0 0

CUSTOMER AS

REQUIRED REPORTS

DAILY

630 613 651 618 618 589 562 490 565 501 487 539 572

SUPPLY CUSTOMERS

TRAINING

REQUIREMENTS

12 23 18 21 11 18 15 28 29 34 39 23 23

COMMANDERS

RESPONSIBILITY

BRIEFING

30 30 10 5 7 6 2 2 2 2 2 2 15

10 IT/SYSTEMS SUPPORT

REMEDY TICKETS 85 58 50 36 35 29 35 47 54 43 63 32 47

AVG SHELF LIFE ITEMS

Maintained in stock 0 0 0 0 0 0 0 0 0 0 0 0 800

12 BASE EXERCISES 1 0 1 0 0 1 0 0 1 0 0 0 4

13 Average Year Supply Discrepancies (SDR) 150

14 Analysis Average SDR 150

15 Average Customer Assistance Visit per Quarter 40

16 Average Precious Metal Recovery Program Accounts 63

17 Average Work centers visited 40

Average Number of

Maintenance units with

DIFM

19 Locally assigned ERRCD 0

Equipment Management

Code changes 50

Quarter AVG/Update unit o issue/price changes for Local

Purchase only

AF Form 86 Action 1

22 Annual/AVG

23 Annual Update repair cycle records(FRR) 890

24 Semi-Annual/ Maintain Exception Control File 250

25 Monthly review of Exception Control File 250

26 Average Annual plus TIN 25

27 Qtr review of R02 changes 163

28 Average Number of Accounts with Capital Assets 289

29 Average Year/Concept Briefings 4

30 Year Average number of 1ED Transactions 120

31 Year Average Return 1ED Transactions 120

32 Yearly Number of Trained Deployed Custodian 10

33 AVG Hours to Train Deployed Custodian 3HOURS

34 Average Number of Initial Issues 3

35 CANN Actions 50

36 AVG AWP per month 5 37 Reset Passwords/ Year 20

38 Add/Delete ES-S Group/Capability 25

39 Yearly/FIX Action 3

Monthly Average

Process/Maintain/Update MDR & QDR Exhibits 10

41 AVG Monthly DIFM Details 232

42 Monthly Organizational Refusals 5

43 Functional Checks Items 35

44 Maintain Degraded Operation Logs 5

45 AVG Year Credit Code Y Turn-ins 3

46 MICT Questions 250 47 MICT Stage 1 Areas 1 48 Hazardous Waste Shipment 6 49 Fire Extinguishers 20 50 Emergency& Exit Lights 15

51 Familiarization Training Hours 20

There is currently 389 equipment items at offsite locations. This number constantly changes as equipment is turned in or added to offsite equipment accounts.