Smoked and Dried Fish Plant Financial Model

Description

The model captures a complete industrial facility transforming raw fish into a wide portfolio of smoked and dried products, covering both cold-smoking (up to 24‑hour cycles) and hot-smoking (full cook) lines, as well as controlled traditional drying. It is built for entrepreneurs planning an operation that sources multiple species seasonally and needs a single, rigorous tool to reflect the true complexity of fish processing, from whole fish intake to branded retail packs.

Raw material procurement reflects real industry volatility: a monthly species‑specific calendar manages seasonal windows, frozen inventory build‑up, and draw‑down. Each species carries its own yield curve, brining uptake, and processing loss matrix—transforming a generic assumption into a precise bridge between purchased whole fish and sellable output. By‑product streams (heads, frames, skins) are modelled as a separate revenue line sold to fish‑meal or pet‑food producers, not as waste.

Production cost drivers are split by process: cold smoking (wood chips, electricity, refrigeration), hot smoking (gas, cooking), and drying (air circulation, moisture reduction) each consume resources differently. The model also embeds HACCP‑driven overheads—sanitation downtime, lab tests, compliance staff—that shrink effective capacity. Working capital tied to maturation stock and frozen inventory is explicitly tracked, showing the true cash conversion cycle that generic templates overlook.

All financial statements are integrated. The investor‑ready output shows the order of magnitude of total capital expenditure, not a final valuation, but yields a disciplined view of return generation, debt service, and liquidity pressures unique to a multi‑species smoked‑and‑dried business.

Modeling specifics

• Multi‑species yield & shrinkage engine: each raw material species has its own matrix of yield factors by finished product form (whole, fillet, portion), accounting for weight loss during thawing, brining, smoking, drying, and trimming.
• Seasonal inventory build‑up logic: purchases are scheduled by user‑defined availability windows; excess is frozen, stored, and drawn down off‑season, automatically accruing storage cost, financing, and stock‑out risk.
• Process‑specific cost metering: cold smoking absorption, hot smoking gas, and drying kiln electricity carry separate, batch‑size‑driven cost lines that aggregate into a true per‑kg production cost by SKU.
• By‑product revenue allocation: heads, bones, and skins are valued, with handling/freezing costs deducted, revealing a profitability uplift that conventional models omit.
• Maturation working capital: cold‑smoked finished goods that require resting before dispatch are held in a modelled inventory buffer, creating a cash‑flow lag that reduces apparent IRR if ignored.
• HACCP & QA overhead modelling: a dedicated block applies fixed and variable costs for compliance staff, external lab tests, and mandatory sanitation periods that reduce gross available production hours by up to 10–15%.

What's included in the base version

• Raw material inventory & procurement planner (by species, by month)
• Multi‑line production schedule (cold smoking, hot smoking, drying)
• Direct materials & consumables calculator (salt, brine, wood chips, packaging, etc.)
• Direct & indirect labour allocation (shift‑based)
• Complete energy consumption model (electricity, gas, fuel) per process step
• Capital expenditure builder (smoking chambers, kilns, blast freezers, cold storage)
• Operating expenditure / SG&A with equipment maintenance contracts
• Automated debt schedule & multiple loan tranches
• Integrated Financial Statements (P&L, Cash Flow, Balance Sheet)
• Scenario Manager (3 user‑defined scenarios)
• Executive dashboard with key metrics & investor summary

Common modeling mistakes

• Assuming one average yield for all species — overestimates finished product output by 15–25%, distorting revenue and raw material cost lines.
• Ignoring seasonal raw‑fish price volatility — miscalculates annual purchase cost, shrinking gross margin by 8–12 percentage points.
• Treating cold storage as a simple warehouse without blast‑freezing and holding energy — underestimates total utility costs by 20–30%.
• Not modelling the weight loss during drying as a function of target moisture content — overstates final product weight by 30–40%.
• Overlooking cash locked in maturation stock (cold‑smoked items resting before packing) — delays payback by 4–8 months in the cash flow projection.