Film roll inventory planning

Translate net reel contents into usable length and the number of rolls needed for a job.

Work through the task

  1. Record actual width, GSM and running length. If weighing the reel, identify core and wrapping tare separately.
  2. Estimate the usable contents of a partly used roll with the appropriate measurement. Diameter models require actual thickness and winding assumptions.
  3. Calculate whole rolls for the job and retain surplus separately from a stated unusable fraction. Value the purchased contents using the supplier price.

Tools for this job

A worked example

A 0.8 m wide roll with 5,000 m at 60 GSM contains 4,000 m² and 240 kg net film. A job requiring 12,000 usable metres needs three such complete rolls with no assumed loss, leaving 3,000 m nominal surplus.

Use your supplier specification and quotation. These numbers demonstrate the arithmetic; they are not market prices or a packaging suitability assessment.

Checks before you decide

  • Net contents versus gross reel weight
  • Usable length and declared loss convention
  • Whole-roll purchasing and leftover stock