Projected Net Income Builder · seeded with 2023-2026 actuals · edit anything · accuracy-first
Committed across all shipment rows vs. what each commodity can supply, and what's left.
One row per shipment. Add the same destination more than once for different modes. Margins shown are gross (before company overhead).
| Commodity | Destination | Volume | Price | Mode | Delivered Cost | Margin | Margin % | Annual Margin | |
|---|---|---|---|---|---|---|---|---|---|
| Totals / Averages (gross) |
Company-wide costs, allocated across all commodities. Subtracted below the gross line in the net income build. Untick to exclude.
From revenue through to net operating income, with EBITDA highlighted. Shown as totals and per pound.
Each plant's potato demand — annual and monthly — so you can see the ceiling when committing volume.
Delivered freight by destination and mode (rail includes railcar lease). The builder pulls from here. Blank = not offered. Units follow the toggle.
| Destination | Rail | Bulk Truck | LTL | Van | FTL |
|---|
Only potato-production costs (company overhead is on the Net Income Builder tab). Each line shows Total per year and Per-unit — edit either and the other recalculates from annual production.
Actual spend from the P&L ÷ finished pounds made that year. 2027 is the plan. Toggle per-unit vs total.
Actual monthly raw-potato intake from the ticket trackers. Click a year to show or hide it. Finished pounds MADE per Sean: 2023 ~36M (288 run days, ~127,878/day), 2024 ~28M (bad year — oil issues, breakdowns, Lamb Weston short), 2025 ~16M. Monthly finished totals live in the "2023 monthly production" workbook (Tote/Bin), moving to Ignition before startup.
Same structure as potato. On-hand carrot is already produced, so its cost is sunk — default variable cost is $0 and it is sold FOB.