BuiltByEstradaBook a call

Inventory and Reorder Workbook

Retail and Auto line

A workbook that tells you what to order and how much. Type what you have, what it costs and how many you sell in a week. It works out margin, days of stock, the reorder point with your supplier's lead time and a safety cushion, ranks every item A, B or C, and builds the order for each supplier.

Excel and Google Sheets file, English and Spanish

Fare

$19

founding price until January 31, 2027 · then $30

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Inventory-and-Reorder-Workbook.zipSCREENSHOTS · full version
Inventory and Reorder Workbook: the Items tab, with EXAMPLE data
Items: tab with EXAMPLE data See the whole tab
Inventory and Reorder Workbook: the Reorder list tab, with EXAMPLE data
Reorder list: tab with EXAMPLE data See the whole tab
Inventory and Reorder Workbook: the ABC and categories tab, with EXAMPLE data
ABC and categories: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

What you do, what the sheet does

YOUTHE SHEET
You type units sold per weekIt works out days of stock and the reorder point
You pick a supplierIt builds that supplier's order with quantities and cost
You type cost and priceIt shows the margin on every item
You open ABC and categoriesYour best sellers and slow movers are already ranked

What the full version has

  • Items tab: room for 200 items with margin, days of stock, reorder point, order quantity, ABC class and status
  • Reorder list tab: what to order by supplier, ready to print or send as PDF
  • ABC and categories tab: sales and stock by class and by category, plus your top 10 sellers
  • Settings tab: lead time by supplier, safety days, days each order covers, overstock limit, ABC cutoffs
  • Start here page with the formulas in plain words
  • English file and Spanish file

Who it is for

Independent stores in the Rio Grande Valley and beyond that count stock by hand and reorder by memory.

The items and suppliers already in the file say EXAMPLE. Type your own over them; they are not real products or companies.

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.