Coffee Roastery Economics: Green Coffee Landed Cost, Roast Loss & Yield, Batch Planning, Blend Costing, Packaging, Channel Pricing, Green Stock Cover and Break-Even
Cost and plan a small coffee roastery from green bean to bag. You will build a landed cost per green kilo, turn roast loss into cost per roasted kilo, plan batches on one roaster, cost blends, price bags by channel, keep green stock in balance and find the kilos a month that cover the fixed costs, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course shows how a small coffee roastery works with numbers, one spreadsheet cell at a time. You build a landed cost per green kilo from price, freight, a fictional duty, a given FX rate and warehousing. You turn a roast log into weight loss, pooled loss per roast level and the cost of one roasted kilo, then plan whole batches on one roaster and measure its utilisation. You cost a blend with SUMPRODUCT and test two ways to hit a target cost, price bags with packaging, packing time and shipping bands, set wholesale tiers, margins and a price floor, track weeks of cover and reorder points, and finish with break-even kilos and a channel-mix scenario.
Lessons
- Green Coffee Landed Cost: Price, Freight, Duty, FX and Warehousing per Kilo Pro
- Roast Loss and Yield: From Green Kilos to the Cost per Roasted Kilo Pro
- Batch Planning: Green Kilos per Order, Batches per Roaster and Roast-Day Utilisation Pro
- Blend Costing: Weighted Cost, Green Kilos per Component and a Swap to Hit the Target Pro
- Packaging and Fulfilment: Cost per Bag, Shipping Bands and Packing Hours Pro
- Channel Pricing: Wholesale Tiers, Margin vs Markup, Web Prices and a Price Floor Pro
- Green Stock Cover: Weeks of Cover, Reorder Points, a Quality Flag and Contract Call-Offs Pro
- Capstone: Monthly P&L, Break-Even Kilos and a Channel-Mix Scenario Pro