Computerised Costing and pricing lingerie sheet
Computerised Costing and pricing lingerie sheet
All you need to cost a bra and brief, simply enter the fabric and elastic amounts and this Excel sheet works out exactly how much the piece of lingerie will cost, will give you two different ways to wholesale your lingerie and three different points of selling.
It will also generate the amount of fabric and components you need to buy if you were manufacturing 10, 20 or one hundred pieces of lingerie.
There is also a section if you are working with a manufacturers full price, or if you are having to buy full rolls of fabrics because of minimums, the cost sheet will calculate how many you need to sell to break even.
You will receive two different types of costs sheet, one is designed so you can print it out the other is just digital (ie it’s too big to print on A4).
LINGERIE COST SHEET
Before you go any further this cost sheet is a “base point price cost sheet” what does that mean? It means it’s only taking into consideration the actual costs it takes to produce your lingerie, like materials and manufacturing. You need to know the bottom line cost of how much something costs so you don’t lose money. It doesn’t cover costs like overheads or your time, though there is space to add these in.
So there are three ways this Excel sheet provides you with your cost, the first one adds a wholesale price at a percentage and then a selling point on top of that. This is great if you want to see how much mark up you are making.
The second way shows you in money terms, so if you need to make the minimum of £7 per item at wholesale then it shows you want the selling point would be. All these figures can be changed in the spread sheet. The advantage with this is it lets you play around with numbers, showing you instantly what you would sell something at if you were to alter the profit higher or lower.
The third way shows you the selling point if you were to sell direct to customers, so the selling point is set at a higher percentage than the wholesale. This exercise can show you straight off if you can afford to do wholesale or what you need to alter in your figures to be able to do it.
Also on the cost sheet it works out how much fabric or trims you would need if you wanted to produce 10, 20, or 100 pieces, which is invaluable if you need to quickly place an order, and have all your costs and fabric ordering in one place.
There are two version of this cost sheet on so you can print out to A4 size so if you need to store a hard copy in a folder, and the other is digital, so has more conversion such as working out how many you need to sell before you break even, and also a chart indicating what is taking most of your money in the produciton.
Getting organised in the costing area, will save time, save money and get you to starting your own brand that but quicker.
DETAILS
Contains a ‘How to page’ and a fully working cost sheet for bras and briefs (although any type of lingerie can be costed on this)
This cost sheet is an instant downloadable excel file, before you type anything I recommend you save a master copy on the file.
There is also a costing page, explaining how each part works, an example of a cost sheet for a brief, a blank sheet filled with formulas ready to enter your details. A example of a bra cost sheet and a blank one ready for you to fill out and it work out your costs.
On the digital version the how-to clearly states what boxes you should fill in.