Apparel Search › Downloadable Templates › Free Production Order Summary Worksheet (Excel)
Apparel Search Templates
A clear size-by-color order grid with totals, plus an estimate of cartons, CBM and weight.
This worksheet summarizes a production order on one sheet. You list each style and color with the quantity for every size, a unit price and the sheet totals the units and the value. A packing section estimates the cartons, cubic meters and gross weight from your carton size, so you can plan shipping. It also records the order reference, factory, price terms, delivery date and payment terms. It is a worksheet to record order details. It is not a contract or a legal purchase order.
Enter the order reference, date, buyer, factory, ship-to, price terms (FOB, EXW, CIF, DDP or other), requested delivery date and payment terms. The price terms tell the factory where its responsibility ends, so choose them carefully and confirm them in writing.
Use one row for each style and color. Edit the size labels in the header if you use different sizes, and type the quantity for each size. The sheet totals each row and the whole order.
Not sure how many of each size? Build the grid with the Size Curve & Order Splitter.
Enter the agreed unit price for each row. The line total and the order total calculate automatically. Use the prices from your approved quote.
Enter the units per carton, the carton length, width and height in centimeters and the gross weight per carton. The sheet rounds the carton count up, then calculates CBM per carton, total CBM and total gross weight. This assumes one carton size for the whole order.
For mixed carton sizes, use the Carton & Container Load Calculator.
Check the totals against your quote, add notes on packing, labels and special instructions, and send it as a PDF or Excel file. Keep a copy and agree the final terms in writing.
Yes. It is free to use in your own business. Please do not sell or republish the file as your own.
No. It is a worksheet that records order details. Terms of sale may have legal effect, so have formal terms and purchase orders reviewed by a qualified professional.
Cartons needed = total units divided by units per carton, rounded up. CBM per carton = length x width x height in meters, and total CBM is cartons times CBM per carton.
Yes. Edit the size labels in the dark header row of the size columns.
Price terms such as FOB, EXW, CIF and DDP say where the seller's responsibility ends and who pays for freight, insurance and duty. Confirm them in writing.