Supplier Reorder List from Low Stock and Weekly Sales

Takes your current stock counts and last week's sales and works out what to order from your supplier and how many, rounded to the case sizes your supplier sells.

Pet storeRetail✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

ok its Ryan Monroe at Timberwell Pet Supply, 5998 Starwell Ave, Slatehollow. need the weekly order for Wheatwell Pet Distribution, my rep is Sally Olsen 402-555-0104. Samuel Phan counted the shelves this morning. lead time is 1 week, their minimum is $500. I want 4 weeks of stock on hand. Tundra Pup Salmon and Pumpkin 12 lb: have 6, sold 5, nothing on order, cases of 4, I pay 38.50 Mossback pine pellet litter 20 lb: have 2, sold 6, nothing on order, cases of 3, pay 11.20 Gecko Gourmet dubia roach tins: have 9, sold 3, 12 already on order, cases of 12, pay 2.10 Quillfeather millet spray 10 pack: have 0, sold 4 before we ran out, nothing on order, cases of 6, pay 4.75 Reefback turtle basking dock large: have 1, sold 1, nothing on order Whiskerbottom catnip mist: have 5, sold 0, nothing on order, cases of 6, pay 3.30

AFTER · what the skill produced

Reorder list for Timberwell Pet Supply, 5998 Starwell Ave, Slatehollow
Supplier: Wheatwell Pet Distribution, rep Sally Olsen, 402-555-0104
Prepared for Ryan Monroe. Stock counted by Samuel Phan. Target: 4 weeks of sales on hand. Supplier lead time: 1 week.

Out of stock or runs out before delivery

Quillfeather millet spray 10 pack: on hand 0, sold 4, weeks of cover 0.0. Target 16 units, need 16. Order 3 cases of 6 = 18 units at $4.75 = $85.50.
Mossback pine pellet litter 20 lb: on hand 2, sold 6, weeks of cover 0.3. Target 24 units, need 22. Order 8 cases of 3 = 24 units at $11.20 = $268.80.

Reorder

Tundra Pup Salmon and Pumpkin 12 lb: on hand 6, sold 5, weeks of cover 1.2. Target 20 units, need 14. Order 4 cases of 4 = 16 units at $38.50 = $616.00.
Reefback turtle basking dock large: on hand 1, sold 1, weeks of cover 1.0. Target 4 units, need 3. Case pack and cost not given, so the line is pending and not in the total.

Not on this order

Gecko Gourmet dubia roach tins: on hand 9, 12 already on order, sold 3, weeks of cover 3.0. Target 12 units, and 21 are on hand or on order, so nothing is needed.
Whiskerbottom catnip mist: on hand 5, no sales last week, so no quantity was calculated.

Order total (priced items): $85.50 + $268.80 + $616.00 = $970.30
This meets the $500 minimum you gave. The turtle dock is not included in this total.

Questions for the owner

Reefback turtle basking dock large: what is the case pack and your cost per unit? We need 3 units to reach your 4 week target.
Whiskerbottom catnip mist had no sales last week. Do you want it left off the order, or is there a reason to look at it again?
Please confirm the $500 minimum and the 1 week lead time with Sally Olsen before sending.

What it does

Takes your current stock counts and last week's sales and works out what to order from your supplier and how many, rounded to the case sizes your supplier sells. Gives you a clear list you can check and send.

Use it when: Use when a pet store owner has stock counts and last week's sales and needs a supplier reorder list, such as "what do I need to order," "build my reorder," "we're low on stuff," or "make the weekly supplier order."