How to use this command center
Same engine as the Arctik Ops workbook. Data lives in this browser so it works on a Cloudflare subdomain with no database. Export a backup from the header before you switch devices.
Input vs calculated
Editable cells are the inputs — drop lines, sales, cash-flow months, assumptions.
Totals, margins, inventory remaining, customer spend, and the dashboard never need typing.
Backup & deploy
Use Export in the header to download a JSON backup. Import restores it.
Reset restores the original DROP1MT / DROP2BJJ / DROP3 / DROP4 seed from the workbook.
When you put this on a subdomain, each browser keeps its own copy unless you import a backup.
Drops
Enter drop name, season, and date. Fill product rows with item details, quantities, costs, and selling price. Promo units per SKU are deducted from sellable stock. Totals calculate automatically. Duplicate a drop to start the next run.
Sales log
Log in-person (Cash), Square, and website orders. Order numbers (AO-0001) and line totals (qty × price − discount) are automatic. SKU lookup fills product, size, color, and price from the drop catalog.
Customers
Contact fields are yours to edit. First/last purchase, order count, spend, AOV, and New vs Repeat roll up from the sales log by customer name.
Inventory
Read-only live stock. Sellable units come from each drop. Units sold sum the sales log by SKU. Status is IN STOCK, LOW STOCK (≤ 3), or SOLD OUT.
Financials
Auto-pulls revenue, COGS, and units from every drop. Operating expenses are the annual totals from the cash-flow grid. Reorder tracker and the P&L summary live here.
Cash flow
Enter drop COGS in the month the factory is paid. Monthly op-ex (owed to the investor) and estimated revenue produce net cash and a running cumulative. The investor tracker adds loan + funded COGS + funded op-ex, minus repaid.
Ledger
Line-level investor expense tracking. Investor-funded lines become amount owed; repaid reduces the balance owing.
Projections
Five assumptions: monthly revenue growth, COGS %, op-ex growth, base monthly revenue, base monthly op-ex. Monthly, quarterly, and 3-year outlooks update immediately.
Dashboard
Read-only command center. KPIs, money flow, drop performance, cash chart, quarterly snapshot, and 3-year outlook all pull from financials and projections. Executive notes at the bottom.