Tire Wholesale Reorder List

Takes your recent tire sales and your current stock counts and builds a ready-to-send reorder list for your wholesale supplier.

Tire shopAuto and Transport✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

need to do the order for Antonio Schmidt at Skywood Tire Distributing, his number is 402-555-0167 and they're at 3554 Reedwood Ave in Riverhurst. our shop is Sagewood Tire & Wheel, 3175 Quailwood St, Riverhurst, 402-555-0166. Andrei Rivas counted stock this morning. Annette Roth here, I'm the owner. sales are the last 8 weeks. Lead time is 1 week, I want 3 weeks of cover after it lands. They ship in multiples of 4 and the min order is 24 tires. Vantrex Ridgeback 225/65R17 sold 48, have 10, none on order, cost 98 Vantrex Ridgeback 235/60R18 sold 30, have 20, none on order, cost 115 Orlin Quietway 215/55R17 sold 64, have 12, 8 on order, cost 84 Orlin Quietway 225/60R18 sold 22, have 4, none on order, cost 102 Orlin Quietway 205/65R16 sold 40, have 18, none on order, cost 71 Kelvane Hauler LT265/70R17 sold 18, have 6, none on order Kelvane Hauler LT245/75R16 sold 0, have 8, none on order, cost 139 Brandt Frostline 225/65R17 sold 6, have 16, none on order, dont reorder winter til September

AFTER · what the skill produced

Reorder list for Skywood Tire Distributing
Attn: Antonio Schmidt, 402-555-0167, 3554 Reedwood Ave, Riverhurst
From: Sagewood Tire & Wheel, 3175 Quailwood St, Riverhurst, 402-555-0166 (Annette Roth, owner)
Stock counted by Andrei Rivas. Sales period: last 8 weeks. Lead time 1 week plus 3 weeks of cover, so target stock is 4 weeks of average sales. Ships in multiples of 4. Minimum order 24 tires.

| Tire | Sold | Avg/wk | On hand | On order | Target | Need | Order | Cost each | Line total |
|---|---|---|---|---|---|---|---|---|---|
| Vantrex Ridgeback 225/65R17 | 48 | 6 | 10 | 0 | 24 | 14 | 16 | $98 | $1,568 |
| Orlin Quietway 215/55R17 | 64 | 8 | 12 | 8 | 32 | 12 | 12 | $84 | $1,008 |
| Orlin Quietway 225/60R18 | 22 | 2.75 | 4 | 0 | 11 | 7 | 8 | $102 | $816 |
| Orlin Quietway 205/65R16 | 40 | 5 | 18 | 0 | 20 | 2 | 4 | $71 | $284 |
| Kelvane Hauler LT265/70R17 | 18 | 2.25 | 6 | 0 | 9 | 3 | 4 | not given | unpriced |

Quantities are rounded up to multiples of 4. For example, the Ridgeback 225/65R17 need of 14 becomes 16.

Not ordering this time

Vantrex Ridgeback 235/60R18: target 15, on hand 20, so no need.
Kelvane Hauler LT245/75R16: no sales in 8 weeks, target 0, 8 on hand.
Brandt Frostline 225/65R17: you said not to reorder winter tires until September. Target would be 3 with 16 on hand anyway.

Totals

Total tires ordered: 44 (meets the 24 tire minimum)
Cost of priced lines: $3,676 for 40 tires
Unpriced: 4 tires (Kelvane Hauler LT265/70R17)

Questions for the owner

What is your cost per tire on the Kelvane Hauler LT265/70R17? It is left out of the cost total until you tell me.
The Kelvane Hauler LT245/75R16 had no sales in 8 weeks. Do you want to keep it in your regular stock list?
Are any of the counted tires already sold or held for customers? If so, tell me how many per line and I will redo the math.

What it does

Takes your recent tire sales and your current stock counts and builds a ready-to-send reorder list for your wholesale supplier. It shows how many of each tire to order, why, and what the order costs when you give prices.

Use it when: Use when a tire shop owner or counter person needs a wholesale reorder list built from recent sales and current stock counts, such as: what do I need to order, build my tire order for the supplier, figure out reorder quantities, or what are we running low on.