Skip to content
BoxQuote

Corrugated box costing sheet in Excel

Ready Excel sheet, formula ke saath

Stop rebuilding the same costing sheet. Download one with live formulas, filled with your own box from the calculator.

Download the costing sheet

.xlsx, about 30 KB. Opens in Excel, WPS Office, Google Sheets and LibreOffice.

What's inside

Read me
How to use it, in English and Hinglish. Units and version.
Rates
Your kraft rates by grade, conversion, wastage, printing, glue, freight, margin and GST. Yellow cells are yours.
Box costing
One box: size and paper per layer at the top, every calculation below.
Price breaks
Price at 1,000, 2,500, 5,000, 10,000 and any quantity you type.
Kraft impact
Kraft change from −₹4 to +₹4 per kg, against your new cost and price.
Quote register
50 rows to log every quote: buyer, spec, price, status and why you lost it. Win rate at the top.

The formulas in the sheet

Every rate has a name, so formulas read like sentences:

Plants differ on glue flap, flute take-up and wastage. The sheet shows each one as an input instead of hiding it, so you can match it to your own corrugator.

Questions

Will it work on my phone?

Yes. It uses only plain formulas (SUM, SUMPRODUCT, MROUND, IF, INDEX and MATCH), so it works in WPS Office and Google Sheets on Android as well as Excel.

Why are some cells locked?

Formula cells are locked so they don't get typed over by mistake. There's no password: use Review > Unprotect sheet if you want to see or change a formula.

Are there macros?

No. No macros, no security warnings.

Does it match the online calculator?

Yes. The sheet and the calculator use the same formulas, and we test that they agree to the paisa.

More free tools

Email par baat karein