Coffee Roastery Economics: Green Coffee Landed Cost, Roast Loss & Yield, Batch Planning, Blend Costing, Packaging, Channel Pricing, Green Stock Cover and Break-Even

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn four green coffee lots into a landed cost per green kilo: goods and freight converted at a given FX rate, a fictional duty, warehousing per bag, and the uplift over the contract price.
• Read a roast log: weight loss per batch, a pooled loss % per roast level, the spread of the loss with STDEV.S and the cost of one roasted kilo for each roast level.
• Turn a week of roast orders into green kilos, whole batches on one roaster, the total number of batches and how full the roast days are.
• Cost a three-origin blend with SUMPRODUCT, find the green kilos one component needs for a production run and test two ways to bring the blend down to a target cost.
• Cost a filled 250 g and 1 kg bag including bag, valve, label and packing time, find the shipping band of a web order, add up its fulfilment cost and plan next week's packing hours.
• Price six cafés from a volume-tier list, check the gross margin per café, set a web price from a target margin and keep a subscription discount above a price floor.
• Measure the weeks of cover per origin, set reorder points from lead time and safety stock, flag older lots for a taste check and track what is still to call off on two contracts.
• Combine the course into one monthly view: contribution per roasted kg across the channel mix after energy, the break-even kilos per month, a scenario with more wholesale and a chart that compares the channels.