Rate the likelihood each estimate closes — this adjusts the available inventory calculation in real time.
Manage factories, minimum order quantities, lead times, and average daily sales. These drive all reorder calculations.
Choose from the list to edit details and per-SKU settings.
Auto-generated from safety stock, reorder points, and days of cover calculations.
Reorder points use a monthly batch model suited for your uniform business: avg monthly sales (24-month lookback) × lead time in months × batch safety multiplier. Status is shown as Months of Cover — how many months your current stock will last compared to your lead time.
How much each signal contributes to predicted daily demand. Must sum to 100%.
YoY growth is calculated automatically from your invoice history (last 12 months vs prior 12 months, capped at ±50%). No manual input needed.
Your ROP is calculated as: avg monthly sales × lead time (months) × safety multiplier. The multiplier acts as your buffer — it means you hold that many times the demand expected during your lead time, so a sudden program order won't catch you short.
Controls how much extra safety stock is added to absorb demand spikes. Higher = more buffer, fewer stockouts, but more capital tied up. Applied as Z × σ (monthly std dev) × √lead time.
🔴 Critical — months of cover < lead time in months (you'll run out before the order arrives)
🟡 Warning — months of cover < lead time × multiplier (inside your safety buffer)
🟢 Healthy — months of cover ≥ lead time × multiplier
Total units sold in the last 24 months divided by 24. This is your overall average — used as a fallback for calendar months with no historical data. Items under 0.5 units/month are flagged as slow movers.
Instead of projecting a flat average, we look at which specific calendar months fall within your lead time window and use what has historically sold in those months. This means ordering in February (heading into spring peak) produces a higher ROP than ordering in September (heading into slow season).
Automatically detected from your actual sales data. Compares the last 12 months against the prior 12 months. If your business is growing, the projection scales up; if declining, it scales down.
Because you place large batch orders and customers can drop big program orders at any time, your ROP includes structural buffer. The multiplier means you aim to hold that many times the projected lead-time demand before you need to reorder.
Protects against lumpy, unpredictable demand — a single month of 40 units when the average is 10. Measures how variable your monthly sales actually are and adds a buffer proportional to that volatility.
The final trigger. When Net Available drops to or below ROP, you need to order.
QuickBooks Web Connector automatically syncs inventory, open purchase orders, and 5-year sales history on its schedule. Use this page to monitor sync health and configure credentials.
The QBWC password is stored in GCP Secret Manager as
QBWC_PASS
and is never exposed to the dashboard or Firestore.
Username: lana_sync ·
To rotate the password, update the secret in
Secret Manager
then re-enter it in QBWC.
LANA-inventory.qwc from this project folder.
The SOAP endpoint is: https://us-central1-lana-bda40.cloudfunctions.net/qbwcSoap
The first sync pulls 5 years of invoice & sales receipt history — it may take a few minutes.
Export three reports from QuickBooks, save as CSV, then upload here. Each import overwrites the previous data for that report type.
Assign category and supplier to each product group. All SKUs in the group inherit these settings. Lead time comes from the supplier's default.
| Customer / Boat | Due Date | Tasks | Items | Fulfillment |
|---|
Track artwork creation, mockups, and client approvals across all active orders.
Manage work orders and route jobs to in-house embroidery or external vendors.
Package completed orders and manage shipment or in-store pickup.