Resource Allocation: Cable Demands to Stocked LengthsSupplying cable from a stock consisting of more than one drum requires decisions to be made about from which drum each required length should be supplied...
The author has developed a Visual Basic for Applications (VBA) programme operating in MSExcel to solve this using a cost-based approach. This article deals with the situation where cable is supplied from stock because insufficient notice of demand can be given to meet orders by the ‘make to order’ route or it is uneconomic to do so...