Inventory Reorder Planner.

Build an inventory reorder planner for Harbor Lane Candle Co., a 12-person candle maker in Portland, Maine that buys packaging, parts, and consumables from six suppliers. Layout: a top row of four stat cards: Total SKUs (60), Items Below Reorder Point (7), Open Purchase Orders (5), and Inventory Value on Hand (about $48,200). Below, two tabs. The first tab, Items, is the main view: a sortable, searchable table of all 60 SKUs with columns for item name, category (Packaging, Parts, Consumables), supplier, on-hand quantity, average weekly usage, lead time in days, unit cost, computed reorder point, computed days of cover, and a status badge. Above the table sit filters for category and supplier plus a Show Only Items to Reorder toggle. To the right of the table on wide screens, a compact Order This Week panel lists the flagged items ranked by days of cover, each with a suggested order quantity of four weeks of usage rounded up to the supplier pack size. The second tab, Purchase Orders, shows a table of POs with PO number, supplier, item count, total value, placed date, expected date, and a stage badge (Placed, Confirmed, Shipped, Received), topped by a small area chart of weekly usage value over the last 12 weeks split by category. Data: seed 60 SKUs: 24 packaging items like 8 oz amber jars, jar lids, 4-pack shipper boxes, and labels; 18 parts like wick clips and pump assemblies; 18 consumables like soy wax, fragrance oil, and glue sticks. Suppliers are Pinebrook Packaging, Coastal Container, Meridian Parts, Bright Chemical, Atlas Labels, and Downeast Wholesale. Unit costs run $0.04 to $18.50, lead times 3 to 21 days, on-hand 0 to 2,400 units. Seed 36 weekly usage records (12 weeks by category) and 8 purchase orders in mixed stages, 5 of them not yet received. Plant the story: packaging is the risk. Seven items sit below reorder point, and the worst three, 8 oz amber jars, jar lids, and 4-pack shippers, all come from Pinebrook Packaging with its 21 day lead time, leaving the jars at just 6 days of cover. Behavior: reorder point equals average weekly usage times lead time in weeks plus a two week safety buffer, computed live, never typed in. Status badges: green Healthy when cover exceeds lead time plus 14 days, amber Watch when within that window, red Reorder Now when below reorder point. Default sort is days of cover ascending. Add Item and Add PO forms open in dialogs; read-only visitors must see everything fully populated without them. Visual identity: use an emerald accent for primary actions, chart emphasis, and active states on a clean light neutral base, with a calm, tidy supply-room feel.