A record shop sells two different businesses from the same crates. New vinyl is bought from a distributor at a set cost and sold near a list price everyone can look up: in the made-up shop below, a new LP at $29.98 keeps 32.0%. Used vinyl is bought in collections for what the seller will take, then graded, cleaned and priced by the shop: a used LP at $14.00 keeps 59.5%. In this shop, new records bring people in and used records pay the rent. A shop that reads its sales total without splitting the two can have its best month for sales and lose money. Below are six lines, a month, what moves the number, and a calculator. Every figure is this shop's own.
The short version
- A new LP keeps 32.0% of its price. A used one keeps 59.5%.
- The bargain bin keeps 75.3% of three dollars: $2.26.
- A collectible sold online keeps 49.3% after the marketplace's fee and postage.
- A turntable keeps 25.5%, and sells sleeves and records after it.
- This month sells $21,866 and has $1,923 left after rent and wages.
- Used stock is only cheap if what you buy sells. Dead crates are cash.
- TaroStack values the bins and shows what each kind of stock earns. More below.
Six lines
| Product | Sold where | Price | Cost | Left | Margin |
|---|---|---|---|---|---|
| New LP | Shop | $29.98 | $20.40 | $9.58 | 32.0% |
| Used LP, graded and cleaned | Shop | $14.00 | $5.67 | $8.33 | 59.5% |
| Used LP, bargain bin | Shop | $3.00 | $0.74 | $2.26 | 75.3% |
| Used LP, collectible | Online marketplace | $60.00 | $30.40 | $29.60 | 49.3% |
| Inner and outer sleeves, pack | Shop | $9.00 | $4.47 | $4.53 | 50.3% |
| Turntable, entry level | Shop | $179.00 | $133.37 | $45.63 | 25.5% |
Cost is what the shop paid for the record or the goods, sleeves and mailers, the time to grade, clean, list and pack, and the fee a card processor or marketplace takes.
New. $19.50 in, $29.98 out, and 90 cents to the card processor. What's left is $9.58. The shop can't mark it up: the price is on the internet.
Used. A record from a bought collection costs this shop about $3.50, with $1.50 of time to grade and clean it and a new inner sleeve. It keeps $8.33, nearly as much as the new LP's $9.58, on less than half the price and a fraction of the cash.
The collectible. Sold online at $60.00, it loses 11% to the marketplace and $4.00 to listing and packing time, and still keeps $29.60. A few of these a month matter.
A month
| Product, sold where | Sold | Sales | Left after its own costs |
|---|---|---|---|
| New LP, shop | 420 | $12,592 | $4,024 |
| Used LP, graded and cleaned, shop | 380 | $5,320 | $3,165 |
| Used LP, bargain bin, shop | 300 | $900 | $678 |
| Used LP, collectible, online marketplace | 24 | $1,440 | $710 |
| Inner and outer sleeves, pack, shop | 60 | $540 | $272 |
| Turntable, entry level, shop | 6 | $1,074 | $274 |
| Total | $21,866 | $9,123 | |
| Fixed costs | −$7,200 | ||
| Left | $1,923 |
Fixed costs here are rent, wages, utilities, insurance and the card terminal: $7,200 a month. At this mix the shop needs about $17,256 of sales to cover them.
New LPs are the biggest line by sales, $12,592, and leave $4,024. Used LPs sell less, $5,320, and leave $3,165. Swap 100 used sales for 100 new ones and sales rise $1,598 while what's left rises $125, with $1,950 more owed to the distributor.
What moves the number
- The buy. A used record's margin is made when the collection is bought. Paying $3.50 a record for a crate that's half unsellable is paying $7.00 for the half that sells.
- Dead stock. A used LP that sits for two years has kept nothing. Move it down to the bin on a schedule.
- New release orders. New vinyl is paid for on terms and may not be returnable. Twenty copies of a record that sells eight is twelve times $19.50 on the wall.
- Grading time. A dollar fifty a record is this shop's time. A collection of a thousand is a week.
Counting it all is in vinyl inventory spreadsheet. How fast stock turns is in inventory turnover example, and markup against margin in markup vs margin.
Get the calculator
Download the record shop profit margin calculator. One sheet and a read-me: a row for each line, with price, cost, sleeves, time and fees, and the cost, gross profit, margin and markup worked out. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator knows what a used LP keeps when it sells. It doesn't know that the shop has 4,000 of them, bought over six years, and which 600 have been in the same crate since they were priced. Margin by line is the easy half. The hard half is what's on the floor, what it cost, and how long it's been there.
How TaroStack does it
TaroStack works the margin out from what you actually paid.
Receiving records each delivery at what it cost, freight included, so a price rise shows up the week it happens.
Margins by product, on real cost. New and used are seen side by side, as different stock.
A price-creep report by supplier shows what went up and by how much.
Counting works on a phone, and a count shows what each difference is worth.
A reorder list in days of cover, with each supplier's lead time and minimum.
| The question | A sheet typed once | In TaroStack |
|---|---|---|
| What a record costs today | The price from the last time you typed it | From the last delivery |
| Which product earns the most | Last quarter's guess | Margins by product |
| What went up | Compare invoices | Price creep, by supplier |
| What's on hand, and what it's worth | Count and multiply | Stock value |
TaroStack doesn't run the till or list records on a marketplace. It connects to Square. Stock, receiving, counts and margins are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
