Worksheet
Monthly and Growth Metrics
What this is: A monthly calculator for the seven metrics that reveal whether the business is becoming more efficient, not just bigger.
Month:
Trend updates automatically once This Month and Last Month are both filled in.
| Metric | Formula | This Month | Last Month | Trend |
|---|---|---|---|---|
| Monthly revenue | Total sales this month | — | ||
| Customer acquisition cost | Marketing + sales spend ÷ new customers | — | ||
| Average order value | Total revenue ÷ number of orders | — | ||
| Employee productivity | Revenue ÷ number of employees | — | ||
| Machine utilization | Running time ÷ available time | — | ||
| Profit per employee | Net profit ÷ number of employees | — | ||
| Profit per machine | Net profit ÷ number of machines | — |
Anything moving the wrong direction, and why:
Sticky Note Tip
Read customer acquisition cost and average order value together, see Chapter 3, Section 3.