ProMill Projects & InvestmentMill Risk

Raw Material Cover & Price Exposure Sheet

Three months of cotton is not a position. Cover measured against what you will spin says nothing about the yarn whose price you have already agreed.

The Mill

What it consumes and what a kilogram of yarn takes

At the running mix and current utilisation

Yarn out of cotton in. A kilogram of yarn takes more than a kilogram of cotton

The Scenario

A movement to test the position against, not a forecast

The market you would buy or sell the gap at today

Applied against the exposure in whichever direction hurts

Cotton Held and Contracted

Everything the mill owns or has committed to buy. The priced column is the whole point: cotton contracted at an open price is tonnage secured and money not secured, and it counts toward volume cover while counting for nothing against a fixed sale.

Lot or ContractQuantity tPrice Fixed 0/1Price if Fixed cost/kgDays of Consumption daysPriced tPrice Open tValue Committed costRow actions
————
————
————

Add line opens a form. Cells in the sheet stay directly editable.

Yarn Sold Forward

Only the rows with a fixed price create exposure, because only those have a selling price that can no longer move when the cotton does. Yarn sold on an open or formula price carries its own risk and is not cover, but it is not exposure either.

Order or CustomerYarn Quantity tPrice Fixed 0/1Yarn Price if Fixed cost/kgCotton It Needs tDays of Production daysFixed tValue Committed costRow actions
————
————
————

Add line opens a form. Cells in the sheet stay directly editable.

How to read this sheet

Exposure is cotton required by firm sales less cotton whose price is fixed, and the sign is the whole message: positive is short, where the selling price is agreed and the buying price is not, so a rise lands on margin with nothing to pass it to; negative is long, where cotton is priced and not yet matched to a firm sale, which a falling market devalues and which has ruined mills after a good harvest. Volume cover and price cover are reported separately because cotton contracted at an open price secures tonnage and secures no money, and a mill quoting days of cotton is usually quoting the first. Cotton required is yarn divided by realisation and never multiplied by it: a kilogram of yarn takes more than a kilogram of cotton, and the difference at 85% is a sixth of the requirement. Realisation is taken as a single mill-wide figure, so a mill running counts with materially different realisations should run this per count group or use a weighted figure. Yarn sold on an open or formula price is neither cover nor exposure here and is excluded from both sides; it carries a different risk, which is that the formula moves against you. Nothing in this sheet forecasts a price, recommends a position, or constitutes advice on whether to hedge: the movement is a scenario the user enters, and the answer is what that movement would do to a position the user has described. Timing is not modelled - cotton arriving after the yarn ships is not cover however it is priced - so a position that nets out here can still fail on delivery dates.

Textile SchoolRaw Material Cover & Price Exposure Sheetwww.textileschool.com

Raw Material Cover & Price Exposure Sheet — free while in preview, with every line item and the download, at Textile School.