Report Library

Twelve months of despatched sales rolled up to the five classes the board sees.

“Board pack, by class”

The same sales cut twice: class down the side, region across the top.

“The two identical reports, chopped differently”

Australia, New Zealand, Fiji, Singapore, South Africa and Saudi Arabia.

“Regional office reporting”

Revenue, kilograms and margin month by month across the year.

Every account by revenue, with the cost and margin behind it.

Grade by grade, largest first, with tonnes alongside the money.

Where the gross margin actually comes from, by class.

Email, phone, portal, rep and EDI, which is how the orders arrive.

Who took the order, and what it was worth.

How much of the book is sold on an agreement rather than at list.

“Customer-specific pricing matrix”

How much of what is sold is manufactured here and how much is bought in.

“Two thirds are products we don't make”

The AUD, USD and euro split of the book.

500 kg bulk bags against 20 kg sacks, drums and the specials.

Everything on the book now, as a board you can drag.

The quotation book with its status and the order raised against it.

Every opportunity the sales desk is working, weighted.

Five control accounts, each agreeing to the item codes behind it.

“Raw materials, work in progress and finished goods, split”

What is on the shelf, by product class.

Whose material is sitting on our floor.

Finished, traded, raw and packaging, side by side.

Average lead time by class, which is the risk in the safety stock.

Everything under its minimum, classified make or buy.

Six months pushed backwards through the bills of material.

“Explode the BOM in reverse”

Section, rack, level and pallet space, with the quarantine bay.

Every batch, what went into it and where it went.

One code across five modules: on hand, committed, on order, in production.

Production kilograms divided by labour hours, month by month.

“Divide the production kilos over the labour hours”

Kilograms released and batches made, month by month.

What each of the ten work centres put out.

Average yield on each centre, against the kilograms behind it.

Which grades run to standard and which do not.

Kilograms and hours per operator, and the yield they ran at.

What was impounded into work in process, month by month.

“By law you have to impound that value in”

How the plant splits between the popular lines and the rest.

The floor now, draggable through its stages.

The electronic batch card at each station.

Fusion time and torque against the tolerance, week against two months.

“How close they get to that 3% line”

Any test, any grade, plotted against its specification limits.

“Map that over time”

Releases against failures, month by month.

Fusion time, torque and yield averaged per grade.

Where the rejects are actually coming from.

Which plan each release was run against.

Two process readings tracked together over the year.

Where the raw material money goes.

The sourcing map, with the average lead time it comes with.

“80% from Southeast Asia, the subcontinent and the Middle East”

Committed purchase value month by month.

AUD, USD and euro exposure on the purchase side.

RFQ, blanket call-off and call for tender.

Who is quick and who needs four months of notice.

Containers in motion, with the A/B/C order groups.

“123A goods, 123B customs, 123C freight”

Every live order by approval stage.

Aged on each account's own terms, tying to 1100.

“The bottom of that report must equal the control account”

Twelve months of invoicing, by reporting region.

How much of the book sits on which terms.

“60-day accounts pay more; early payers get a settlement discount”

Paid, sent and overdue, by month.

The invoicing run rate across the year.

Allocate what came in against what is owed.

Every invoice raised, with its terms and chase history.

Supplier bills unpaid, aged, tying to 2100.

Every subsidiary ledger against its control account.

“Prove the balance sheet by connecting it to the module”

Every account, debits against credits.

“The very first thing the auditors ask for”

With inventory split three ways on the face of it.

Every correction and close, with the figure before and after.

The valuation pack as the auditors ask for it.

Three accounts, three currencies, statement to ledger.

Cost less accumulated depreciation, tying to the balance sheet.

Megajoules and carbon off the utility bills, scope 1, 2 and 3.

“Strip them for the megajoules”

ISO registers, maintenance schedule and contractor permits.

Fifteen tables, straight out of any module, as a spreadsheet.

“Every so often there's a requirement to just data dump”

Production against sales, and the two sales cuts side by side.