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 — Page 2
Choose a tool. The method, example and assumptions are included.
Showing 25–48 of 49 tools
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.
Business & selling
Gross up a price for processing fees
Gross up a price for processing fees: Required charge = (target net + fixed fee) ÷ (1 − percentage fee).
Business & selling
Stacked platform fees and net payout
Stacked platform fees and net payout: Net payout = sale − sale × platform rate − sale × processing rate − fixed fee.
Business & selling
Sale price for a target net profit
Sale price for a target net profit: Required price = (cost + target profit + fixed fees) ÷ (1 − percentage fees).
Business & selling
True ecommerce order profit
True ecommerce order profit: Profit = item price × (1 − discount) + shipping charged − COGS − shipping paid − fees and ads.
Business & selling
Merchant processing rate comparison
Merchant processing rate comparison: Monthly saving from B = cost of A − cost of B, where each cost is sales × rate + transactions × fixed fee.
Business & selling
Short-term rental break-even occupancy
Short-term rental break-even occupancy: Break-even occupancy = fixed costs ÷ contribution per booked night ÷ available nights × 100.
Business & selling
Imported inventory landed unit cost
Imported inventory landed unit cost: Landed cost per saleable unit = all landed costs ÷ units × (1 − defect rate).
Business & selling
Wholesale to retail margin
Wholesale to retail margin: Net margin percentage = (retail − wholesale − selling fee − shipping) ÷ retail × 100.
Business & selling
Bulk discount profit impact
Bulk discount profit impact: Bulk profit = discounted unit revenue × quantity − unit cost × quantity − extra handling.
Business & selling
Break-even ROAS after product costs
Break-even ROAS after product costs: Break-even ROAS = revenue ÷ contribution before advertising.