Business & selling
3D printing material and running cost
Budget an FDM print’s filament, waste, electricity and hands-on labor using your measured or entered costs.
Home / Categories / Business & selling
Business & selling
Choose a tool. The method, example and assumptions are included.
Business & selling
A/B conversion difference and z-test
A/B conversion difference and z-test: Compute conversion rates, their difference and a pooled two-proportion z statistic.
Business & selling
Break-even units
Break-even units: Whole units = ceil(fixed costs ÷ (price − variable cost))
Business & selling
Business cash runway
Estimate how many months your business cash lasts at a constant monthly net burn rate.
Business & selling
Cash conversion cycle
Cash conversion cycle: enter your own figures, see the result and calculation method, and check the model’s assumptions.
Business & selling
Commission
Commission: Commission = sales × rate/100
Business & selling
Compare two payment fee quotes
Compare two payment-processing quotes with percentage and fixed charges, showing fees and the cheaper option.
Business & selling
Custom processing fee
Custom processing fee: Fee = gross × percentage/100 + fixed fee
Business & selling
Customer acquisition cost (CAC)
Calculate acquisition cost per new customer from the sales and marketing spending for a consistent period.
Business & selling
Customer lifetime value — simple model
Estimate gross-profit customer lifetime value and net contribution after acquisition cost using your assumptions.
Business & selling
Customer retention and recurring revenue cohort
Customer retention and recurring revenue cohort: At the start of each month record the active cohort and its revenue, then reduce customers by the churn fraction.
Business & selling
Dimensional shipping weight
Dimensional shipping weight: Dimensional weight (kg) = length × width × height ÷ divisor
Business & selling
Early-payment discount annualized cost
Early-payment discount annualized cost: Period cost of foregoing discount = d/(1−d).
Business & selling
Ecommerce contribution per order
Ecommerce contribution per order: Expected contribution = revenue × (1−refund share) − goods − fulfillment − payment fees − refund share × additional loss − advertising cost.
Business & selling
Economic order quantity (EOQ)
Economic order quantity (EOQ): enter your own figures, see the result and calculation method, and check the model’s assumptions.
Business & selling
Inventory reorder point
Inventory reorder point: Reorder point = mean daily demand × replenishment lead time + safety stock; round upward to a whole unit.
Business & selling
Inventory turnover and days inventory
Measure annual inventory turnover and average days in inventory using opening and closing stock at cost.
Business & selling
Invoice aging report
Invoice aging report: Compare each due date with the as-of date.
Business & selling
Invoice payment due date
Invoice payment due date: Add the entered number of calendar days, treating the invoice date as day zero.
Business & selling
Invoice simple interest from an entered rate
Invoice simple interest from an entered rate: Simple interest = unpaid principal × annual rate / 100 × overdue days / selected year-day basis.
Business & selling
Invoice total
Invoice total: Total = subtotal × (1−discount/100) × (1+tax/100)
Business & selling
Marketing funnel conversion worksheet
Marketing funnel conversion worksheet: Leads = visits × lead conversion; sales = leads × sales conversion.
Business & selling
Markup
Markup: Markup (%) = (price − cost) ÷ cost × 100
Business & selling
Mixed-rate sales tax basket
Mixed-rate sales tax basket: For each line calculate net × quantity, round its tax to cents, then sum line net, tax and gross amounts.
Business & selling
Monthly sales growth scenario
Monthly sales growth scenario: Month one uses the starting units; each later month multiplies the previous units by (1+growth).
Business & selling
Profit margin
Profit margin: Margin (%) = (revenue − cost) ÷ revenue × 100
Business & selling
Project critical path and slack
Project critical path and slack: Validate an acyclic dependency graph.
Business & selling
Reconcile two ledgers by reference
Reconcile two ledgers by reference: Aggregate signed amounts by exact reference on each side; list each reference with its two totals and difference.
Business & selling
Reverse processing fee
Reverse processing fee: Required gross = (target net + fixed fee) ÷ (1 − percentage/100), rounded up to the next cent
Business & selling
ROAS and advertising break-even
ROAS and advertising break-even: ROAS = attributed revenue / ad spend.
Business & selling
Safety stock with fixed lead time
Safety stock with fixed lead time: Safety stock = z × daily demand standard deviation × √lead-time days, rounded upward.
Business & selling
Sales-mix break-even batches
Sales-mix break-even batches: Contribution per mix batch = Σ mix quantity × (selling price − variable cost).
Business & selling
Selling price for target margin after fees
Selling price for target margin after fees: Price = (non-fee cost + fixed fee) / (1 − fee fraction − target margin).
Business & selling
Tiered marginal commission plan
Tiered marginal commission plan: Apply each rate only to the sales slice inside that cumulative band.
Business & selling
Unit price
Unit price: Price per unit = total price ÷ quantity
Business & selling
Weekly hours and overtime payroll worksheet
Weekly hours and overtime payroll worksheet: Split each person’s entered weekly hours at the chosen threshold.
Business & selling
Weighted supplier scorecard
Weighted supplier scorecard: Require a weight for every score column and a total weight of 100%.
Business & selling
Working capital and current ratio
Working capital and current ratio: enter your own figures, see the result and calculation method, and check the model’s assumptions.