A feed store sells a lot of feed and makes its money on everything else. Livestock feed keeps about 18.0% of its price, because ranchers know what a bag costs and will drive for a dollar. Pet food and supplies keep 38.0%, fencing and hardware 40.0%, and garden and seed 45.0%. In the made-up store below, feed is 44% of sales and a quarter of the gross profit. In a full-speed month the store sells $57,000, keeps $17,370, and after $14,700 of wages, rent and trucks has $2,670 left, before the owner's pay. Its first year ends behind. Below are the four departments, the month, the break-even, and a calculator.
The short version
- Feed keeps 18.0% of each dollar. Garden and seed keep 45.0%.
- Feed is 44% of sales and 26% of the gross profit.
- Pet food brings the most gross profit of any department: $5,320.
- Fixed costs are $14,700 a month. Break-even is about $48,238 of sales.
- Shrink is torn bags, mice, and plants that wilt. Count it.
- TaroStack counts bags by lot and date, and shows what shrink costs. More below.
What $100 of sales costs
For each department: the goods, card fees and shrink in $100 of sales.
| Of $100 sold | Goods | Card fees | Shrink | Cost | Kept |
|---|---|---|---|---|---|
| Livestock feed | $79 | $2 | $1 | $82 | $18 |
| Pet food and supplies | $58 | $2 | $2 | $62 | $38 |
| Fencing and hardware | $57 | $2 | $1 | $60 | $40 |
| Garden and seed | $50 | $2 | $3 | $55 | $45 |
Feed's shrink is torn bags and the odd pallet the mice found. Garden's is plants that don't sell before they wilt. Feed also has dates: medicated and high-fat feeds go stale, and a customer who gets an old bag doesn't come back.
Margins by product
| Product | Sold | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Livestock feed | By the bag and the pallet | $100.00 | $82.00 | $18.00 | 18.0% |
| Pet food and supplies | Shelves | $100.00 | $62.00 | $38.00 | 38.0% |
| Fencing and hardware | Yard and shelves | $100.00 | $60.00 | $40.00 | 40.0% |
| Garden and seed | Seasonal | $100.00 | $55.00 | $45.00 | 45.0% |
The table is by $100 of sales. Feed is why the truck pulls in. A customer buying six bags of layer pellets walks past the dog food, the fence staples and the seed rack on the way to the counter, and those are where the store earns.
A month at full speed
| Product | Hundreds of dollars sold | Sales | Gross profit |
|---|---|---|---|
| Livestock feed, by the bag and the pallet | 250 | $25,000 | $4,500 |
| Pet food and supplies, shelves | 140 | $14,000 | $5,320 |
| Fencing and hardware, yard and shelves | 110 | $11,000 | $4,400 |
| Garden and seed, seasonal | 70 | $7,000 | $3,150 |
| Month | $57,000 | $17,370 | |
| Fixed costs | −$14,700 | ||
| Left | $2,670 |
Fixed costs are $14,700 every month: wages ($7,500), rent and the warehouse ($4,500), utilities ($900), forklift and truck upkeep ($600), insurance ($500), and the register and other costs ($700).
Break-even
| Fixed costs a month | $14,700 |
| Gross profit on each dollar of sales | 30 cents |
| Sales needed to cover fixed costs | $48,238 |
| As a share of a full-speed month | 85% |
Below about $48,238 of sales a month the store loses money. In the plan this example comes from, that's reached in the seventh month, and the first year ends about $10,800 behind before the owner's pay.
What moves it
| Change | Effect on a month |
|---|---|
| A competitor cuts feed prices, and matching them costs 3 points of feed margin | −$750 |
| Pet food and supplies up a fifth | +$1,064 |
| A wet spring: garden shrink doubles | −$210 |
| $3,000 of sales moves from feed to fencing | +$660 |
Don't chase feed margin. Three points on feed is worth less than a fifth more pet food. Price feed to bring people in, and put effort into what they buy beside it.
Deliveries. A pallet of feed delivered to a ranch is a sale a box store can't make. Charge for the truck, and it's a margin of its own.
The first year, month by month, is in feed store business plan. A pet supply shop's counts are in pet store inventory, and selling from a farm in farm store business plan. Whether growing the hay pays is in is selling hay profitable.
Get the calculator
Download the feed store profit margin calculator. One line for each product and where it sells: price, materials, packaging, labor and fees. It works out the cost, the gross profit, the margin and markup, and the price a target margin would need. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A customer says the last bag of calf starter was stale. Which delivery was it from, how many bags of that delivery are still on the floor, and how many have gone out? The margin table says feed keeps 18%. One pallet of returned bags takes a month of that.
How TaroStack does it
TaroStack keeps the warehouse counted by lot and date.
Each delivery of feed is a lot, with the mill's lot number and date, scanned from the bag or pallet label where it has one.
Oldest first: stock goes out first-expired-first-out by default, with an alert before a date arrives.
If the mill recalls a lot, one report shows what's still on the floor and which account customers got it.
Every adjustment carries a reason: torn, wet, wilted. Shrink is a number, by department.
Counting on a phone, with no signal. A count shows what a variance is worth.
| The job | Calculator | In TaroStack |
|---|---|---|
| Which delivery a bag came from | The pallet tag, if it's still there | The lot |
| Old feed on the floor | Read the tags | The expiry alert |
| A recalled lot | Check every pallet | One report, and on hold |
| What shrink cost | A feeling | Adjustments by reason |
TaroStack doesn't run the register. It connects to Square. Stock, lots, counts and recalls are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
