A cost per wear spreadsheet is simply a way to compare what you paid for clothing with how often you actually wear it. That sounds tidy and sensible, but I know the phrase can make a perfectly nice Tuesday morning feel like an accounting exam. It doesn't have to. Used properly, this little tool helps you stop buying the $18 shirt that sits untouched while the $96 cardigan carries your entire fall wardrobe.
I started using this method after years in Von Maur dressing rooms, where women would apologize for wanting a good coat or hesitate over a pair of pants they needed for work. The question isn't whether an item is cheap. The question is whether it earns its place in your real life. A cost per wear spreadsheet gives you a clearer answer than a sale sticker ever will.
What to Put in Your Cost Per Wear Spreadsheet
Open Google Sheets, Excel, or a notebook if that's what you have handy. Create columns for the item, purchase price, estimated wears, actual wears, and current cost per wear. You can add brand, size, color, season, and notes about fit if those details help you spot patterns.
The basic calculation is easy: divide the purchase price by the number of times you've worn the item. A $120 pair of leather loafers worn 40 times costs $3 per wear. A $25 blouse worn twice costs $12.50 per wear. The blouse was cheaper at the register, but it was the expensive mistake.
For a new purchase, use a realistic estimate rather than a hopeful fantasy. If you work in an office three days a week, you might wear a washable jacket 30 times in a year. If you attend two weddings annually, don't pretend the special-occasion dress will get 25 wears unless you already have a plan for using it differently.
I also recommend adding a notes column. Write down things such as “waistband rolls after lunch,” “needs a camisole,” or “works with black and denim.” Six months later, those notes tell you more than a product description does.
The Numbers That Actually Matter
A cost per wear spreadsheet becomes useful when you record actual behavior, not just your shopping intentions. Start with the clothes you already own. Pick 15 pieces from your closet: jeans, shoes, sweaters, work pants, coats, and the dress you keep saving for something important.
Look at your calendar or laundry habits and make reasonable estimates. The $70 jeans you bought last fall might already have 35 wears, bringing the current cost to $2 per wear. The $45 trousers that pinch when you sit might have only three wears, putting them at $15 per wear. That isn't a failure of discipline. It is information about fit.
Don't punish yourself for an expensive item. A $200 winter coat worn 80 times over four Iowa winters costs $2.50 per wear, which is excellent value. A $35 coat worn four times because the sleeves are too short costs $8.75 per wear. Price alone cannot tell that story.
You can also track laundry and repair costs when they are meaningful. A dry-clean-only jacket might need $8 cleaning after several wears. A sturdy cotton shirt that goes through the washer at home has a different ownership cost. You don't need to calculate every penny, but adding a repair or alteration note can explain why one garment keeps winning.
A Realistic Example From a Real Closet
Here is a simple example from the kind of closet I see during wardrobe appointments. A woman buys a $110 navy cardigan because she wants an easy layer for school meetings, grocery runs, and casual workdays. In the first month, she wears it eight times with jeans, black pants, and a striped T-shirt. Her starting cost per wear is $13.75.
After six months, she reaches 30 wears. The cost drops to $3.67 per wear, and the cardigan is still in good shape because the fabric doesn't pill and the buttons stay put. That is a strong purchase, even though $110 felt high in the fitting room.
Now compare it with a $29 trendy sweater bought during an online sale. It looks fine in the package but rides up, feels scratchy, and only works with one skirt. After three wears, the cost is $9.67. The cheaper item is costing more every time she puts it on.
This is why I don't want you using a spreadsheet to shame yourself. Use it to notice what makes clothing useful: comfortable fabric, dependable fit, colors that work with your shoes, and enough structure for the places you actually go. The navy cardigan didn't need to be exciting. It needed to cooperate.
How to Set Up a Cost Per Wear Spreadsheet for New Shopping
Before buying anything over $40, add a possible purchase to your cost per wear spreadsheet. Enter the price, then answer five practical questions. Where will I wear it? What three items already in my closet will work with it? Can I sit, bend, drive, and carry a bag in it? How often will I realistically wear it this season? What will happen when it needs washing?
Suppose you're considering $85 ankle boots. You work at a desk, walk through a parking lot, and spend weekends running errands. If the boots are comfortable and work with four pairs of pants, you might wear them 50 times in a year. That gives you an estimated cost of $1.70 per wear. If they pinch after ten minutes and only work with one outfit, the honest estimate might be eight wears, or $10.63 each time.
Try a 30-day pause for items that require special shoes, unusual undergarments, or a separate trip to the tailor. Put the item in your sheet, but don't buy it immediately. If you can name several outfits after looking through your closet, you're thinking clearly. If you keep writing “maybe,” leave it at the store.
What Your Spreadsheet Can Teach You About Your Style
After a few months, patterns start showing up. Maybe your highest-wear clothes are soft pull-on pants, washable button-downs, and lightweight cardigans. Maybe your formal dresses barely move, while your simple black trousers appear every week. This isn't boring. It's your actual life speaking plainly.
Sort the sheet by current cost per wear and look for the surprises. You may find that a $12 thrifted denim jacket is a champion, but you may also discover that your favorite $150 work pants need a second pair. Rebuying a dependable shape isn't a lack of imagination. It is a practical response to evidence.
The spreadsheet can also show where alterations make sense. A $90 pair of pants with a $20 hem may become a frequent winner. A $25 pair that needs a $35 waistband alteration probably deserves a pass. Before spending money, check whether the fabric, zipper, and seams are worth the work.
Don't use the numbers to force yourself to wear something you dislike. If a garment makes you tug, adjust, or hold your breath, the low purchase price does not rescue it. Clothing is supposed to support your day, not become another household task.
My Simple Monthly Check-In
On the first Sunday of each month, update your cost per wear spreadsheet for five minutes. Add wears to the pieces you've reached for, mark anything that needs repair, and note one item you ignored. The ignored item may need a better hanger, a different styling idea, or an honest goodbye.
Then make a short shopping list based on gaps, not mood. If your sheet shows 40 wears for one pair of black pants and almost none for three fussy skirts, you probably need another reliable pair of pants before another skirt. Bring your list when you shop in Des Moines, browse online, or walk through a local secondhand store.
The goal isn't a closet full of perfect numbers. It is a closet that helps you get dressed on a Wednesday when the laundry is late, your child needs a permission slip, and you have ten minutes before leaving. A cost per wear spreadsheet is just a tool for seeing value clearly. The better measure is whether your clothes let you move through your real life with less fuss. Dressed for your real life.
No comments yet — be the first to share a thought.