Farming and greenhouses
Select a workbook for sample calculations and steps for using your own data.
20 workbooks
- Plot or crop · Unit costing
Calculate direct input and labour cost per unit. Compare unit cost against target and contribution against net sales.
- Plot or crop · Pricing and break-even
Measure unit contribution after discounts and fees. Find the sales volume needed to cover fixed costs and the target price.
- Plot or crop · Capacity and bottlenecks
Combine cycle time, setup and downtime to find workload and the hours still uncovered after overtime.
- Plot or crop · Backlog and throughput
Reconcile new, completed and cancelled work. Find open workload and records at risk of missing deadlines.
- Plot or crop · Stock and replenishment
Find stock position from physical, inbound and reserved units. Round the replenishment order to full cases.
- Plot or crop · Scenario planning
Change volume, income and cost drivers. Compare base and alternative outcomes under loss and capacity constraints.
- Plot or crop · Contribution mix
Track returns, channel fees and allocated costs together. See which records contribute to the operating result.
- Plot or crop · Budget and commitments
Forecast closing spend from the approved budget, actuals and commitments. Stress-test the uncommitted forecast.
- Plot or crop · Loss and rework
Separate first-pass yield, scrap and rework. Compare the cost of corrections and returns.
- Plot or crop · Receivables aging
Group outstanding balances using due dates and offsets. Identify priority records past the follow-up threshold.
- Plot or crop · Staffing and coverage
Find the gap between required and staffed hours. Review shift cost including breaks and added staffing costs.
- Plot or crop · Maintenance schedule
Track maintenance using calendar and meter thresholds. Review overdue assets and planned downtime costs.
- Plot or crop · Utilisation and yield
Read available capacity, utilisation and revenue per capacity unit together. Quantify unused capacity.
- Plot or crop · Energy and demand
Combine day, peak and night use with tariff rates and demand overage. Estimate the impact of load shifting.
- Plot or crop · Conversion funnel
Track enquiries, offers and wins for the same cohort. Compare the weighted value of open offers.
- Plot or crop · Retention and renewals
Separate churn, expansion and contraction in the existing base. Read closing revenue alongside retention.
- Plot or crop · Supplier comparison
Compare total acquisition cost, delivery and quality rates. Find records below the weighted-score threshold.
- Plot or crop · Service and delivery SLA
Measure first response and resolution against separate targets. Review elapsed time and the amount at risk at the reporting cut-off.
- Plot or crop · Cash flow calendar
Roll closing cash into each following week. See cash flow excluding financing and any reserve shortfall.
- Plot or crop · Investment appraisal
Discount cash benefits, residual value and working capital. Compare investments using net present value.