Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Industry guides

Coffee roasting purchases: convert roasted demand back to green weight

Build green-coffee orders from measured roasting yield, whole purchase bags and the finished blend's required weights, while separating expected output from actual weighing.

By Institution5 minute readPublished View sources
In this guide

Roasted demand and green purchases use different quantities

A customer order for 1,000 kilograms of roasted coffee does not imply a purchase of 1,000 kilograms of green coffee. Use the supported yield of the approved roasting profile to convert the finished requirement back to input weight. Then apply the actual purchasing and production constraints.

Cropster's weight-loss guidance distinguishes a recorded end weight from an expected weight calculated from a profile. That distinction matters for both purchasing and inventory: an expected result helps plan the next roast, while actual weighing establishes the output of the completed batch.

This calculation concerns bulk roasted output before any separate packing allowance. Do not use it to change a product's roast profile or customer specification. The roasting and quality team determines acceptable production conditions; finance uses the resulting supported yield to plan cost and cash.

References: Cropster: Recorded and expected roasting weight loss

Divide by the remaining yield rather than adding the loss percentage

Assume a hypothetical approved profile has a planning weight loss of 16% of green input. The remaining roasted yield is 84%. Producing 1,000 kilograms of bulk roasted coffee therefore requires approximately 1,190.48 kilograms of green input: 1,000 divided by 0.84.

Simply adding 16% to the finished requirement gives 1,160 kilograms, which is insufficient under the same assumption. Multiplying 1,160 by 84% produces only 974.4 kilograms of roasted output, leaving a 25.6-kilogram shortage. The error comes from applying the percentage to a different starting quantity.

At an invented green-coffee price of $8 per kilogram, the modeled input cost for the required output is approximately $9,523.81. That is about $9.52 per roasted kilogram before roasting labor, energy, packaging and other costs. The green purchase price of $8 cannot be used unchanged as the material cost per roasted kilogram.

Divide by the remaining yield rather than adding the loss percentage
Illustrative planning stepCalculationResult
Roasted output requiredCustomer bulk requirement1,000 kg
Remaining roasted yield100% - 16% loss84%
Green input required1,000 ÷ 0.841,190.48 kg approximately
Modeled green input cost1,190.47619 × $8$9,523.81 approximately
Incorrect add-on approach1,000 × 1.16 × 0.84974.4 kg roasted, short by 25.6 kg

Round the purchase without losing the remaining stock

Suppose the supplier sells only complete sixty-kilogram bags and there is no suitable opening green inventory. The required purchase is twenty bags, or 1,200 kilograms, costing $9,600. That purchase is larger than the modeled consumption required for the order.

If production uses only the calculated 1,190.48 kilograms under this simplified plan, roughly 9.52 kilograms of green coffee remains. If production instead roasts all 1,200 kilograms at the assumed yield, it produces 1,008 kilograms of roasted coffee, leaving eight kilograms beyond the bulk order. Those are alternative plans, not two simultaneous leftovers.

Choose the feasible batch plan with the production team and preserve the resulting inventory state. The additional purchase payment is not automatically a loss: some material can remain usable. Its condition, future use and accounting treatment require the appropriate review rather than disappearing into an unexplained order variance.

Calculate post-roast blend inputs component by component

Consider a separate hypothetical 1,000-kilogram finished blend made after roasting, with 600 kilograms of component A and 400 of B. Suppose A's approved planning yield is 85% and B's is 80%. Each component needs its own conversion because the finished blend proportions are defined in roasted weight.

A requires approximately 705.88 kilograms of green input, calculated as 600 divided by 0.85. B requires 500 kilograms, calculated as 400 divided by 0.80. Total modeled green input is approximately 1,205.88 kilograms before any other stated losses or purchase rounding.

Applying the finished 60:40 ratio directly to that green total would allocate about 723.53 kilograms to A and 482.35 to B. Under the assumed yields, those amounts produce 615 and 385 roasted kilograms. Total output still equals 1,000, but its composition is 61.5:38.5, which differs from the intended finished blend.

Do not mistake a prefilled expectation for measured inventory

Suppose a completed roast used 1,000 kilograms of green input across the relevant batch records. The profile's expected output is 840 kilograms, but the actual recorded weighing totals 818 kilograms. The measured loss is 18.2%, and the output is twenty-two kilograms below the expectation.

Leaving the expected 840 in inventory would overstate the available roasted quantity by twenty-two kilograms in this example. Record the supported actual output through the established process and investigate the difference with production. Do not force the actual weight to match a standard simply to keep the order plan balanced.

Keep separate events separate. Roasting loss, a later sample, a blending movement and a packing discrepancy are not interchangeable explanations for a stock adjustment. Their timing and purpose determine which operating assumption needs attention, even when they ultimately reduce the same roasted inventory balance.

Use representative profile evidence for the next commitment

Review yield by the relevant coffee, profile and production conditions rather than averaging every roast into one percentage. A change in the mix of products can move the business-wide average even if each individual profile remains consistent. The next order needs the assumptions for the products it actually contains.

Show the consequence of a supported lower-yield scenario when the commitment is sensitive to it. Translate that scenario into additional green input, purchase bags and production time. An uncertainty allowance should be visible in the plan rather than embedded in a supposedly exact standard with no explanation.

Account for existing stock by its actual state and suitability. Green coffee already available can reduce the next purchase, while suitable roasted inventory can reduce the next production requirement. Do not subtract the same material from both sides or assume every available lot meets the ordered product specification.

Give purchasing and production one reconciled requirement

The release record should show the finished bulk requirement, yield by component, usable opening stock, green consumption, whole-bag purchase and planned remaining inventory. Keep packing quantities in a separate subsequent step so the same loss allowance is not applied twice.

After fulfillment, reconcile actual green usage to roasted output and the completed order. That evidence improves the next purchase forecast and explains material cost per roasted kilogram without confusing expected weight, purchased stock and the finished blend customers were promised.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.