Excel vs ERP for packaging and printing: where spreadsheets stop coping

In most print and packaging units the spreadsheets grew up around the job card. The owner kept a costing sheet for quotes, the planner kept a press schedule, stores kept a reel register, and the job card went round the floor and came back with numbers on it, some of them written at the end of the shift from memory.

None of that is wrong. Excel is quick, everyone can use it, and the costing sheet often encodes years of experience about ups, wastage and rates. The useful question is when the unit has grown past what separate files and paper job cards can keep accurate.

Where Excel works well in a print unit

• Quotation sheets, where one person builds the cost per thousand from board, ink, make-ready allowance and machine rates.
• One-off studies: which clients ordered most this year, whether a second die-cutter would pay for itself.
• A small unit with one press, a handful of regular clients and items that rarely change.
• Client-wise or press-wise reports made from exports of data already held in a system.

Where do spreadsheets become difficult?

Artwork revisions

A client sends a revised artwork by email. The prepress operator knows. The planner's sheet still shows the old revision against the repeat order, and the old plate set is still on the rack. A spreadsheet cannot stop the wrong set going to the press; it can only record afterwards that it did.

Reels and part reels

A reel register works while reels are issued whole. Once part reels come back from the press or the laminator, someone has to weigh them, write the weight down and update the sheet. When that step is missed, the register shows reels that are not on the rack, or misses ones that are.

Make-ready and running waste

Most job cards have one box for waste. The sheets spent getting colour and register right on a short run, and the sheets lost to a web break halfway through a long one, end up as one number. That number cannot tell you whether to group jobs differently, look at a press, or change the make-ready allowance in your quotes.

Conversion and job work

Lamination, die-cutting, stripping and folding-gluing each lose some sheets, and some of these steps happen at vendors. In spreadsheets the count is usually checked only at the start and the end, so a loss at one step, or a short return from a vendor, shows up as a short delivery to the client.

Job costing against the quote

The quote sheet says what the job should cost. The actual cost needs the board and ink issued, the waste, the machine hours and the job work charges for that job, gathered from stores, the floor and the vendor bills. It is rarely done, so the quote rate for a client is never corrected.

Client complaints and traces

When a client reports a colour shift or a weak lamination on one batch, the unit has to find the job, the board or film lot, the ink batch, the machine and the checks made. With job cards in a file and a reel register in Excel, that takes a search through paper.

Spreadsheets and ERP compared, task by task

An ERP is an operational system, not a bigger spreadsheet

What changes is the moment the job card's numbers get written. A spreadsheet is updated after the work, from job cards and phone calls. A manufacturing ERP with floor recording is updated as the work happens: stores issues a reel by lot, the press operator logs make-ready sheets and good sheets against the job, the die-cutter operator logs the same, QC records the check against the approved sample. Reports read those records instead of being assembled.

This is why moving from Excel to an ERP that covers only the office often disappoints a print unit. The files that cause the most trouble are the job card, the reel register and the waste figures, and those are floor records.

When should a packaging or print unit move from Excel to ERP?

There is no size at which spreadsheets have to go. The practical test is how often the files fail to give a current, trustworthy answer. These are the triggers units most often describe.

• Several people edit the files. Planning, stores and prepress each keep their own copy, and one of them is always out of date.
• More than one press or line runs at once. One sheet can follow one press; with presses, laminators and die-cutters all running, nobody sees the whole floor.
• Artwork changes often. Clients revise artwork every few orders, and keeping the right revision and plate set on each job becomes someone's full-time worry.
• Reel stock does not match the rack. The register shows reels that are not there, or a job waits for film that was marked available.
• Floor updates arrive late. Counts and waste come back on the job card at the end of the shift, so the office plans on yesterday's position.
• Quality checks are on paper. Colour and lamination checks are written on the job card or a separate sheet, not linked to the substrate lot.
• A complaint takes more than an hour to trace. Finding the lots and checks behind one delivery means opening files and registers.
• Reprints and rework are invisible. Nobody can say how many jobs were reprinted last month, or why.
• Clients ask for more. A new FMCG or pharma client wants artwork control, lot records or inspection history that cannot be produced quickly.
• Nobody knows current WIP. Finding how many printed sheets are waiting for lamination, or sitting at a vendor, needs a walk round the floor.

None of these means Excel has failed. They mean the unit has grown past what separate files can hold. When two or three apply at once, the files are usually costing more time than a system would. The guide to implementing ERP in a packaging and printing unit covers what the move involves.

Keeping what works

A print unit's quotation sheet is often its most trusted file, and there is no reason to retire it. That sheet, client analysis and one-off studies can stay in spreadsheets, fed by exports. What moves is the operational record: jobs, substrate by lot, waste, checks, job work and dispatch. In FleekERP that record sits on the work order, with inventory and lot traceability for reels and sheets, and cost per job from manufacturing intelligence, while the books stay in Tally or Zoho.

For how artwork revisions, reel lots and waste run on one record, see FleekERP for packaging and printing.