Tea Shop Financial Model

Description

The model reflects a specialty tea shop selling loose leaf teas, packaged blends, tea bags, accessories, and on-site prepared beverages. Revenue is segmented by channel: in-store retail, e-commerce, wholesale to cafés and offices, subscription boxes, and paid tea tasting events. Light food accompaniments may be included, but tea remains the core driver.

Inventory management is central: hundreds of SKUs are tracked by tea type (green, black, oolong, white, herbal, flavoured) with distinct seasonality, shelf life, and lead times from domestic and international suppliers. Bulk purchasing discounts, blend rotation, and spoilage are built in. Staffing flexes for peak hours and event days, and equipment (espresso machines, water systems, POS) can be leased or purchased. The model captures seasonal demand shifts, rotating seasonal blends, and the assembly costs of subscription boxes.

Modeling specifics

• Multi-channel revenue decomposition (in-store, online B2C, wholesale B2B, subscriptions, tasting events), each driven by independent traffic, conversion, and seasonal assumptions.
• Dynamic inventory engine with SKU-level reorder logic, accounting for international supplier lead times, bulk discount tiers, and harvest-linked seasonal availability (e.g., first-flush Darjeeling).
• Tea-specific spoilage and quality degradation: differentiated shelf-life curves for green vs black teas, with blend rotation that phases out aging stock and introduces new seasonal blends.
• Subscription box economics: subscriber acquisition, cohort-based churn, and variable assembly costs reflecting tea curation, packaging materials, and fulfilment.
• Flexible labour model distinguishing barista/tea master, retail floor, packaging/fulfilment, and management, with surge scheduling for events and peak days.
• Scenario-based equipment financing: lease-vs-buy analysis for major assets, straight-line depreciation, and maintenance contracts as a percentage of equipment cost.

What's included in the base version

• Multi-channel revenue build-up (in-store, e-commerce, wholesale, subscription boxes, events) with driver-based projections and adjustable seasonality curves.
• SKU-level inventory model tracking tea types, shelf lives, reorder points, bulk purchase tiers, spoilage, and blend rotation.
• Staffing module with role-based scheduling, flexible for peak/off-peak hours, weekends, and event days.
• CapEx and equipment financing block: lease vs. buy toggle, straight-line depreciation, and maintenance cost estimation.
• Detailed COGS calculation per product line (raw tea, teaware, packaging, complementary food), plus subscription box assembly and shipping costs.
• Fully integrated financial statements (income statement, cash flow, balance sheet) and dashboard with channel contribution margins, inventory turnover, and revenue per labour hour.

Common modeling mistakes

• Modeling tea sales without seasonal demand curves — leads to revenue misallocation, distorting monthly cash flow and overstating working capital needs by 10–15%.
• Ignoring tea leaf spoilage and quality degradation — COGS is understated by 7–12%, hiding inventory write-offs and tying up cash in expired stock.
• Omitting subscription box assembly labour and packaging costs — overstates subscription contribution margin by 15–25%, making unprofitable plans appear viable.
• Treating staffing as fixed regardless of events and peak days — understates labour cost by 10–20% and underestimates service quality risks, delaying realistic staff adjustments.