How to create a clothing cost table (2023)

An ideal cost sheet should be simple but comprehensive enough to include all the necessary information about the garment you are producing. Techpacker helps you create a clear, organized expense list that keeps track of all expenses and you can also save it for your records.

First, let's discuss -

Why Excel spreadsheets aren't ideal for apparel costing

Many companies still rely on Excel spreadsheets for their cost accounting.They are confusing, difficult to read and more prone to miscalculations. For example, take this spreadsheet created in Excel:

How to create a clothing cost table (1)

At first glance, it makes a clean and tidy impression. On closer inspection, however, it gets tricky:

  1. In Excel, all the details for the BOM must be manually entered one at a time. It is necessary to format the table and introduce the correct formula for calculating the cost.
  2. Usually these formulas and formats are copied to other tech packs to have a consistent template. It doesn't take much thought to see why this method can easily go wrong!
  3. All of this is especially impractical when product prices are updated during product development. As you know, these are constantly changing and it takes a lot of time to manually re-enter everything, not to mention the risk of making mistakes.
Techpacker vs Excel: Creating Techpacks the Easy WayDo you use Excel to create techpacks? You can create them much faster and easier with Techpacker.Techpacker BlogSayam kochar

Spreadsheet examples

Each product type has different specifics and therefore a different spreadsheet. Each has essential items that you don't want to miss. We've prepared some visual examples to help you create a detailed and easy-to-read cost table in Techpacker for your specific product.

The number of details always depends on the complexity of the garments. In order to calculate the final cost of the garment, you must detail each piece that will be made. For example: main fabric, lining, interlinings, trimmings, buttons, zippers, embellishments, appliqués, etc. All these details must be included in the cost table. The quantities of each item must be listed, ideally in a different column for ease of visualization and calculation.

There are parts that are commonly used for all types of products. Things like tags, labels, sewing thread, and packaging materials will be part of every spreadsheet no matter what type of product you are creating. So make sure to add those as well.

(Video) Retail clothing display table

Top:Add the supplier's name to each material that goes into your spreadsheet, saving you time in the future if you run out of one of the parts and need to order more. It's also useful to track the status of each order - whether it's in stock or needs to be put on backorder.


Let's start with an example spreadsheet for a shirt. In our example it is a men's shirt with a button closure. As with any other type of shirt, the essential element is the main fabric, the interlining for the collar, collar stand and cuffs, the yarn and of course the buttons for the placket, pockets and cuffs. As you can see, all of these items are added to our cost table.

How to create a clothing cost table (4)
How to create a clothing cost table (5)


There are different types of bottoms that can be made, such as tailored pants, elastic waist pants, leggings, denim pants, etc. The number of details depends on the complexity. Our example is a pair of jeans. Apart from essential elements such as the main fabric, thread, zippers, buttons, do not forget to include the metal rivets and the contrasting orange thread that distinguishes a pair of jeans from a classic pair of trousers.

How to create a clothing cost table (6)
How to create a clothing cost table (7)


Whether you are creating a casual dress or a dress for a special occasion, the amount of detail depends on your style. Our next example is a casual jersey knit wrap dress. This style features a tie belt at the waist, so there are no buttons or other types of closures. For this dress, the essential elements that we include in the spreadsheet are the main fabric, the thread, the fusible interfacing and the packaging material. You can calculate the amount of main fabric needed at the sample making stage of your product development.

How to create a clothing cost table (8)
How to create a clothing cost table (9)


Complex styles like jumpsuits usually have more pieces like extra zippers, buttons, and other fasteners. Our example here also has a decorative detail - white crochet lace.

How to create a clothing cost table (10)
How to create a clothing cost table (11)


Outerwear is technically the most time-consuming garment to manufacture. It is often fully lined and requires a specific type of padding to hold its shape. For example, if you want a tailored, more textured look, you might want to go for a woven fusible hair canvas. If you're looking for a softer look, you can choose a woven, non-fusible, mid-weight pad.

How to create a clothing cost table (12)
How to create a clothing cost table (13)


Although swimwear doesn't appear to have as many pieces as other types of clothing, it does have certain distinctive features that are different. Swimwear and activewear fabrics are mostly made from a special type of fabric that is stretchy and non-water absorbing, typically nylon containing a significant amount of lycra or spandex. Please note that women's swimsuits often have bra cups. If your style has these, don't forget to add them to your spreadsheet.

(Video) Changing the clothing store table . #combine #display #scarf #shawl#visualmerchandising

How to create a clothing cost table (14)
How to create a clothing cost table (15)


Spreadsheets for handbags and other accessories are slightly different than those for clothing, they also require different types of machines to make them. The leather used for a handbag is often heavier than that used for clothing, the lining is more durable and the hardware is specific to this type of product. It may include sliders, metal rivets, internal wire frames to create a specific shape, rings, metal tags, locks, screws, chains, clips, or snaps.

How to create a clothing cost table (16)
How to create a clothing cost table (17)


The main difference between sportswear and casual wear is the type of fabric used. Make sure it has plenty of stretch to allow for easy movement. The thread is also different. Most sports tops contain the bra cups for a comfortable fit. If you plan to add lining, make sure the cost is added to your table.

In Techpacker you can calculate the total price per piece as well as the total price for the whole order. In our leggings spreadsheet, we calculate the total cost for a pair.

How to create a clothing cost table (18)
How to create a clothing cost table (19)


Usually, lingerie consists of many small details such as elastic bands, underwires, hooks and eyes, knit interlinings, ribbons and laces for decorations, hardware for adjusting straps, and stretchable main fabric. Your final cost will depend on how many pieces you add. So be sure to add the correct quantity and final cost for each part.

How to create a clothing cost table (20)
How to create a clothing cost table (21)

children's clothing

The spreadsheet for the children's clothing will be very similar to the adult's clothing. However, some brands would set themselves apart by making a quality children's product, for example by making it out of flame retardant fabric or using snaps over buttons to reduce the risk of choking.

How to create a clothing cost table (22)
How to create a clothing cost table (23)


Do you dream of creating your own bedding? No problem! Include the type and cost of the main fabric (the most common for bedding are cotton, linen or silk), lining (optional) and fasteners such as zippers or buttons. And don't forget the labels and packaging.

How to create a clothing cost table (24)
How to create a clothing cost table (25)

How to create spreadsheets on Techpacker

Benefits of using Techpacker to create spreadsheets

  1. FAST:Techpacker simplifies the costing process by providing the templates to calculate your material costs. At the same time, you still have the option to create onecustom table.
  2. CLEVER:Techpacker's template extracts the names of your existing material information in the BOM table and lists them all in that table along with formula presets to calculate the cost. This saves you the hassle of compiling spreadsheets in Excel and going back and forth between spreadsheets.
  3. COLLABORATIVE:In Techpacker, you can make changes at any time and keep your entire team updated with real-time information.
  4. EFFICIENT:In Techpacker you can share spreadsheets with vendors and brands and generate multiple PDF versions directly from the platform. This makes it super easy to compare and analyze them and make the necessary adjustments before sending them to production.

Step-by-step instructions

On Techpacker, all style-related information such as sketches, materials, dimensions, etc. are combined in a single viewTechpack-Board.

(Video) How To Make Your First $10K With Your Clothing Brand

How to create a clothing cost table (26)

Step 1:On your techpack board, list all your materials in it and don't forget to name them. Learn more about how to track your costs through the bill of materialsHere.

How to create a clothing cost table (27)

Step 2:Add a new section at the bottom of your techpack board and select itcalculationPresentation.

How to create a clothing cost table (28)

Step 3:A spreadsheet will be created with all your product materials automatically listed in the description column. Just enter yoursconsumption unitsAndCost per unit. The formulas are preset like thisin totalwill be automatically calculated for you.

How to create a clothing cost table (29)

Step 6:Enter your consumption units and cost per unit. The grand total will be automatically calculated for you.

Check out our full guidehow to create a spreadsheet here.

Wondering what exactly goes into the cost of the garment and how to set the right price for your specific product? Cash -

The Ultimate guide to Bill Of Materials in FashionA comprehensive guide to bill of materials in fashion, why they are important and what to include to create an effective tech pack.Techpacker BlogOleksandra Baukh

Ready to create your spreadsheet?



Login to your account now

Easily manage your product development to production workflow with factories. Try Techpacker.

(Video) Adam Savage's One Day Builds: Laundry Folding Table!

(Video) THE SECRET ROOM | Family Comedy Challenge | Surprise Gift | Aayu and Pihu Show


1. Need Wide Boards? How to make panels by edge joining lumber | STEP IT UP Woodworking
(Steve Ramsey - Woodworking for Mere Mortals)
2. DIY: How to make industrial style #clothes hanger and table at no cost? 自己动手做免费好用又美观的#工业风#衣架和#桌子
(kittens' garden)
3. Changing Display window Table , #layout #clothing #clothes #visualmerchandising
(Ali montazerii)
4. A Simple DIY Way to Waterproof Anything
5. Table layout of clothing store #wardrobe #visualmerchandising #fashion #fashionstore #designer
(Ali montazerii)
6. 7 Signs You’re Dealing With an Evil Person
Top Articles
Latest Posts
Article information

Author: Msgr. Benton Quitzon

Last Updated: 03/15/2023

Views: 5684

Rating: 4.2 / 5 (43 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Msgr. Benton Quitzon

Birthday: 2001-08-13

Address: 96487 Kris Cliff, Teresiafurt, WI 95201

Phone: +9418513585781

Job: Senior Designer

Hobby: Calligraphy, Rowing, Vacation, Geocaching, Web surfing, Electronics, Electronics

Introduction: My name is Msgr. Benton Quitzon, I am a comfortable, charming, thankful, happy, adventurous, handsome, precious person who loves writing and wants to share my knowledge and understanding with you.