Alphabetical Filing Under Strain at a District Cooperative Union
The Cuttack District Cooperative Union maintains about 14,000 active member and loan files. Filing is alphabetical by member surname, and six clerks have worked this way for years. A sample check by the newly posted office superintendent found 31 of 100 files not in their correct place, and the average time to retrieve a file was 18 minutes. Three members with the surname Mohapatra, two of them sharing the same first name, have had documents posted to the wrong file. New files are added at roughly 250 a month, and the union's auditor has fixed an inspection in 45 days. The superintendent has proposed a numeric filing system with a card index, but estimates Rs 42,000 for card cabinets, index cards and overtime, and the clerks argue that alphabetical filing has always worked. Work cannot stop during the change.
1. Should the union move from alphabetical to numeric filing? Recommend a decision and justify it from the evidence in the setup.
Read the worked answer
Recommendation: adopt numeric filing for active files, but as a hybrid, not a total conversion.
The evidence points to a system failure, not a staff failure. Alphabetical filing works while volumes are small and names are distinct; at 14,000 files with 250 added monthly, and with genuinely identical names in the membership, collisions are structural. A 31 per cent misfile rate and 18-minute retrieval are the predictable result of surnames clustering under M and of an arrangement where a misplaced file gives no visible signal. Numeric filing gives every file a unique number, so similar names cannot collide, filing is by sequence (a gap shows immediately), and the index card can carry several names per file, which suits loan files where member and guarantor both matter.
The cost must be weighed honestly. Rs 42,000 against six clerks losing 18 minutes per retrieval is recoverable within weeks, and the auditor will examine traceability. The real weakness of numeric filing is the index: if the index is lost, nothing can be found. Insist on duplicate indexing (card index plus a typed list) and physical backup.
The decision is therefore conditional: convert only active and current-year files, leave inactive files in the old order with a location note, and keep both sequences visible for six months.
2. Prepare a transition plan that changes the system without stopping daily work. State what you will convert first and what you will leave alone.
Read the worked answer
1. Fix a cut-off date. From that date every new file is created with a number and an index card typed at the moment of creation. This alone stops the problem growing.
2. Convert selectively. Convert only files in current use (those called for in the last two years) and all live loan files. Do not attempt 14,000 files. Inactive and closed files stay in alphabetical order, but a marker card is placed at the old position recording the number and location of any file later moved. This respects the clerks' point that wholesale change is disruptive.
3. Sequence the work. Label cabinets and pre-print number labels in advance; one clerk is named index custodian and is the only person who allocates numbers; conversion is done in a low-peak window with the sanctioned overtime; existing numbers are never reallocated.
4. Train briefly and in place. Two hours with each clerk, using their own files, is more effective than a circular.
5. Test weekly. Retrieve 50 files at random each Friday; log misses and correct them before the backlog builds.
6. Protect against failure. Keep a duplicate index list in a second location, and a conversion register showing old name and new number, so a doubtful search can be resolved either way. Report progress to the head of office before the auditor's visit.
3. State two measures that would tell you within three months whether the change has worked, and explain what each would show.
Read the worked answer
Measure 1: misfile rate from a monthly random sample of 100 files. Baseline is 31 per cent out of place. A target above 95 per cent correctly placed within three months would show that the numeric sequence is being used correctly. This measure is chosen because it tests the actual purpose of filing, not effort: a system can be installed and still fail if numbers are written carelessly.
Measure 2: average retrieval time for a standard sample of 20 files, including at least five older alphabetical files. Baseline is 18 minutes. A fall to under five minutes for converted files would show the index is usable in practice. Including old files matters, because a hybrid system only works if staff can still find what was left behind; if retrieval of old files becomes slower, the conversion has simply moved the problem.
Supporting indicators can be logged cheaply: number of auditor objections on missing documents, and days of backlog in creating index cards for new files. A rising card backlog is an early warning that the index custodian is overloaded and the whole scheme will fail quietly.