Use the DTC tab for direct-order profit checks. Use Retail / Distribution to model mixed-SKU partner orders, landed costs, FX, advertising support, terms, and the unit volume needed to make the relationship worthwhile.
Scenario Workspace
Scenario Name
New unsaved scenario
Select Product
True COGS / unit
—
Batch size
—
Order Parameters
Units / order
Retail price / unit ($)
Payment fee (%)
e.g. Stripe 2.9%
Payment fixed ($)
per transaction
Pick & pack ($)
per unit
Shipping ($)
per order
Supplies ($)
boxes, tissue etc.
CAC ($)
customer acquisition
Return rate (%)
P&L Summary
Break-Even Analysis
Scenario Setup
Terms, Support, and Landed Cost
Order Mix
Product
Units
Sell Price
COGS
Revenue
Profit / Unit
Line Profit
Partnership Scorecard
Volume and Profit Thresholds
Volume Ladder
Saved Scenarios
Compare Scenarios
Operations Inputs
Supplies
Manage ingredient costs, packaging stock, and compound inventory with the same operating view used across the rest of the app.
Items
—
Avg Cost
—
Max Cost
—
🔐 Secret Compounds
Password-protected compound formulas and derived $/g
👤 Team Access
Role permissions and action history
Current User
Logged in from app start code
—
Role
Admin, Partner, Viewer
—
Batch Module Access Policy
Admin-only now, can be relaxed later without code changes
🛡️ Week 1 Safety
Undo and archive restore controls
Archived Products0
Archived CRM Accounts0
Archived To-Dos0
Archived Compounds0
⚙️ Global Assumptions
Applied to all COGS calculations
Waste %
Applied to all ingredient costs
Labor Rate ($/hr)
Hourly cost for production labor
Overhead %
% of ingredient cost
Freight %
% of ingredient cost
Batch Capacity / Day (units)
Planner warning threshold for today
Batch Capacity / Week (units)
Planner warning threshold for this week
📐 COGS Formula
How true cost is calculated per unit
① Ingredient Cost
Σ(g/unit × $/g) × (1 + waste%)
② Packaging Cost
Σ(qty × $/unit per item)
③ Labor Cost
hours × $/hr ÷ batch units
④ Inbound Freight
ingredient cost × freight%
⑤ Overhead
ingredient cost × overhead%
∑ TRUE COGS
① + ② + ③ + ④ + ⑤
🔐 Secret Compounds Password
Controls access to the Secret Compounds module
🔄 Cross-Device Sync
Keep all your devices in sync
Last saved—
Last Backup—
Push Status—
Pull Status—
Last Push—
Last Pull—
Payload—
Server Version—
Last Error—
Auto sync is active. Admin edits push automatically; all devices pull in background.
Server Snapshots
Automatic rollback points saved on each successful sync write.
🛍️ Shopify Inventory Sync
One-way finished-goods inventory sync from Shopify into the app
ℹ️ About
AppPapichulo Style COGS
Version3.0.0
Build Date2026-03-06
SourceExcel Master Workbook
SKUs21 products + 3 compounds
🏭 Batch Planner
Scale ingredients to any production run
Product
Units to Produce
🎯 Price Sensitivity
Find your optimal retail price point
Product
Target Margin %
📦 Amazon FBA
Calculate true Amazon landed cost & net margin
Product
Retail Price ($)
Weight (oz)
Length (in)
Width (in)
Height (in)
Monthly Units Sold
PPC ACoS (%)
🏪 Retail Stack
Visualize margin layers from MSRP to your pocket
Product
MSRP ($)
Retailer Margin %
Distributor Margin %
Broker Fee %
📉 Break-Even
Find the volume you need to cover fixed costs
Monthly Fixed Costs
Rent / Facility ($)
Salaries ($)
Software / Tools ($)
Marketing Fixed ($)
Insurance ($)
Other ($)
Uses each product's retail price from its product page.
🎁 Bundle Builder
Design product bundles and calculate combined margins
Saved Bundles
Supplier Intelligence
Vendor Tracker
Track ingredient vendors, lead times, websites, and pricing signals in the same cleaner operating view used across the rest of the app.
Sort By
Shopify-Controlled Stock
Inventory
Units sync from Shopify. Use this board to monitor coverage, reorder pressure, and sync health while keeping operating thresholds local to the app.
Units On Hand
—
Across finished goods
Critical SKUs
—
Out of stock now
Reorder Soon
—
At or below threshold
Sync Coverage
—
Shopify-managed SKUs
Critical Now
Out-of-stock SKUs that need immediate action.
0
No critical SKUs.
Reorder Soon
SKUs at or below threshold, sorted by risk.
0
No SKUs currently below reorder point.
Unsynced / Needs Mapping
SKUs not fully protected by Shopify sync.
0
All visible SKUs are mapped and healthy.
SKU Directory
Read-only stock visibility with local reorder thresholds and weekly velocity inputs.
0 SKUs
Wholesale CRM
My accounts
Business Intelligence
Analytics
Partner-safe economics, channel health, and forward-looking operating signals.
🧾 Ops Audit
Source
Rows
Product Filter
Account Filter
From
To
💡 ROI Projector
Product Inputs
Product Name
Ingredient $/unit
Packaging $/unit
Labor Hours
Batch Size
Channel Prices
DTC Retail
Amazon
Wholesale
Saved Projections
Execution Calendar
To-Do List
Plan the month, keep daily priorities visible, and separate open work from completed history in one cleaner operating view.
—
Today Priorities
Keep the top 3 tasks for today visible across the app.
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Add Task
Task *
Category
Due Date
Notes (optional)
Set Today's 3 Priorities
Select up to 3 tasks to pin as today's priorities:
Tools
Products
Batch Planner
Price Sensitivity
Amazon FBA
Retail Stack
Break-Even
Bundle Builder
Vendor Tracker
ROI Projector
Inventory
CRM
Analytics
Ops Audit
Simulator
Supplies
Secret Compounds
To-Do List
Settings
🔒 Enter Password
This compound is protected. Enter the password to view its formula.
