The hidden cost of running a labour camp on spreadsheets

Almost every labour camp starts the same way. A spreadsheet of residents, a printed floor plan on the wall, a notebook by the phone for maintenance complaints, and one person who knows how it all fits together. For fifty beds, this works.

At five hundred it does not — but the failure is quiet. Nothing collapses. Costs simply appear in places nobody is looking.

The empty beds you are paying for

The most expensive problem in manual camp management is the bed nobody knows is free. A resident leaves, the checkout is recorded a few days later, and in the meantime the spreadsheet says occupied. Multiply that by normal turnover and a camp routinely runs several percent below its real capacity while management believes it is full.

The consequence is not a small inefficiency. It is renting overflow accommodation, or delaying an intake of workers, while beds you already pay for sit empty. Nobody ever sees this cost, because the report that would show it does not exist.

Allocation arguments at intake

Twenty workers arrive on a Sunday evening. The person allocating beds is working from a spreadsheet last updated on Thursday, and two of the rooms marked free were filled on Friday. Now there are workers standing in a corridor while someone walks the building to check.

This is the visible symptom of an invisible cause: the record and the reality have drifted apart. Everything else — double allocations, disputes, workers moved twice in a week — follows from that one gap.

Maintenance that disappears

A resident reports a broken water heater. It is written in a notebook, or mentioned to a supervisor in passing. Some of these get fixed the same day. Some are still unfixed a month later, and nobody can say which — because there is no list, no priority, no assignment and no closure.

The costs compound in three directions. Small repairs become large ones. Residents stop reporting problems at all, because reporting achieved nothing last time. And when a client or auditor asks how quickly maintenance issues are resolved, there is no answer that can be evidenced.

Security you cannot prove

Most camps control access reasonably well in practice. The problem arrives when something goes wrong and you need to demonstrate it: who entered on Tuesday night, which visitor was authorised by whom, when a lost card was deactivated.

A paper gate register can technically answer these questions, if someone is willing to read six months of handwriting. In an incident review, that is the same as having no answer.

Assets that quietly leave

Air conditioners, beds, mattresses, kitchen equipment. Bought in bulk, distributed across buildings, and then untracked. Shrinkage in camp environments is normal and largely undetected, because nobody knows what was in room 214 to begin with. The first real audit of a manually managed camp almost always finds a gap.

The question you cannot answer

Here is the test. Right now, without making a phone call: how many beds are occupied, how many maintenance tickets are open and how long has the oldest been waiting, and who is inside the camp who does not live there?

In a manually managed camp, none of these have immediate answers. Every one of them is a decision you are making blind — about capacity, about staffing, about safety.

What changes with a system

Not the work itself. Beds still get allocated and heaters still get fixed. What changes is that the record updates as the work happens, rather than afterwards from memory.

A check-out frees the bed the moment it is recorded, so the next intake sees it. A maintenance request becomes a ticket with an owner, a priority and a clock. A visitor is registered and passed out again. An access card is issued and revoked with a log behind it. And the occupancy figure on the dashboard is the actual occupancy figure, not a number someone reconstructed on Thursday.

The saving that pays for it first is almost always the empty beds — capacity you already own and were not using. Everything after that is faster resolution, fewer disputes, and being able to answer questions with evidence instead of assurance.