A feed store's stock is heavy, cheap by the pound and sold by the pallet, and half of it has a date. A feed store inventory template has a row for each product, counted in bags and bales, with what's on hand, what one cost and a level to reorder at. Bagged feed gets one thing more: the date it was milled, from the tag sewn into the bag. Feed loses quality as it sits, and the pallet at the back of the row is always older than the one at the front. The rest of the store, hay, bedding, pet food, salt blocks, fencing, is ordinary counting, with reorder levels that follow the season. Below is a sheet for a made-up feed store, the mill dates, and the file.
The short version
- Count in bags and bales. Count full pallets first, then the loose bags.
- Write each delivery's mill date. Sell the oldest first.
- Bagged feed is about half the value on the floor, at the thinnest margin.
- Reorder levels move with the season: chick starter in spring, hay in winter.
- Torn bags, mice and spoiled hay are shrink. Write them off with a reason.
- Keep feed with a drug in it apart, and labeled.
- TaroStack keeps feed by lot and date, counted on a phone. More below.
An example sheet
Counted on a Saturday after closing.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Layer pellets, 50 lb | bag | 140 | 120 | $15.20 | $2,128.00 | OK |
| All-stock sweet feed, 50 lb | bag | 96 | 80 | $13.40 | $1,286.40 | OK |
| Senior horse feed, 50 lb | bag | 62 | 60 | $22.50 | $1,395.00 | OK |
| Scratch grains, 50 lb | bag | 44 | 60 | $12.10 | $532.40 | REORDER |
| Alfalfa hay | bale | 85 | 100 | $14.00 | $1,190.00 | REORDER |
| Field fence, 330 ft roll | roll | 7 | 6 | $189.00 | $1,323.00 | OK |
Ten rows in all, $10,357.00 at cost, with two to reorder: scratch grains and alfalfa hay. Bagged feed is $5,341.80 of it, a little over half.
Counting pallets. This store's pallets hold 40 bags of 50 lb when they're full. Count the full pallets, multiply, and add the loose bags on the open one. Three full pallets and twenty bags is 140.
Unit cost is what a bag cost you delivered, freight included. On feed the margin is a few dollars a bag, so a freight bill left out of the cost is most of the profit left out of the sum.
Mill dates
| Received | Item | Milled | Bags | Sell by | Note |
|---|---|---|---|---|---|
| Oct 14 | Layer pellets | Oct 12 | 80 | Jan 12 | Sell these first |
| Nov 5 | Layer pellets | Nov 3 | 60 | Feb 3 | |
| Oct 22 | Senior horse feed | Oct 20 | 62 | Jan 20 | |
| Sep 30 | Dog food, 40 lb | 38 | Aug 15 next year | Best by on the bag |
The 140 bags of layer pellets are two deliveries, three weeks apart. The older 80 go out first, and they will only if they're in front. New pallets go behind or beside the old ones, never in front of them. That's the whole of stock rotation, and it's the first thing to slip on a busy delivery day.
The "sell by" here is this store's own rule, three months from milling. Ask your mill what it advises for each feed: pellets, sweet feeds with molasses and feeds with added fat don't keep alike, and heat and damp shorten all of them. Read the tag when the pallet arrives. A pallet that was already two months old at the mill's warehouse is a conversation to have that day, not in January.
Medicated feed. Feed with a drug in it has its own label and its own rules. Keep it on its own pallet, clearly marked, and never refill an open bin from a bag without reading the tag. Check the rules that apply to you with your mill and your state's feed program.
Shrink
| What happens | Where it shows |
|---|---|
| A bag torn by the forklift | Loose feed on the floor, a bag short |
| Mice and birds | Chewed corners; bags that weigh light |
| Hay that got wet | Bales that can't be sold |
| A bag loaded and not rung up | Nothing, until the count |
Write each one off when it happens, with the reason. A torn bag sold at half price is a sale and a write-off of the other half. At the count, what's still missing after the write-offs is the part to worry about. The department margins and what shrink costs are in feed store profit margin, and the business in feed store business plan.
Get the template
Download the feed store inventory template. Four sheets: inventory with value and REORDER, deliveries with mill dates and days left, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A feed store carries a few hundred items, and every sale changes one of them. The register knows what was rung up. The spreadsheet knows what was counted three Saturdays ago. Between them is everything that happened in the warehouse: the pallet that came in, the six bags loaded for a delivery, the bale that got rained on. And nobody at the register can see that the pellets on the front pallet were milled in July.
How TaroStack does it
TaroStack keeps each delivery of feed as its own lot, with its date.
Receiving records each delivery's lot and date, with or without a purchase order.
Oldest first. Stock goes out first-expired-first-out by default, with an alert before a date arrives.
Counting works on a phone with no signal, in the warehouse or the hay barn. A count shows what a difference is worth.
Every adjustment carries a reason: torn, spoiled, missing.
A reorder list in days of cover, with each supplier's lead time and minimum, such as a full truck from the mill.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which pellets are oldest | Read the tags | Lots by date |
| Feed near its date | Found by a customer | An alert |
| What shrink cost this month | Unknown | Adjustments by reason |
| When to order the next truck | When a row looks empty | Days of cover, with the mill's minimum |
TaroStack doesn't run the register. It connects to Square. Stock, lots, counts and reordering are on every plan. A store with a few hundred items fits Growth at $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.
