Abstract
While manufacturing different grades of steel in an alloy and special steel plant, it is practically impossible to allocate the cost of major operational materials such as refractories, electrodes and nipples, ingot moulds etc. to each grade of steel. Conventionally, cost allocation of operational materials is done based on the time taken for processing a particular grade of steel. A more accurate picture of the utilization levels of these operational materials by different grades of steel can be obtained if one factors in the differences in the rate of consumption, in view of the variations in temperature and intensity of chemical reactions. Earlier quadratic model with a non-linear objective function and linear constraints has been envisaged to estimate the consumption pattern for each grade manufactured, so that a realistic grade-wise cost can be arrived at. In this paper, use of Excel Solver has been demonstrated based on the quadratic model envisaged earlier. The same has been validated with results obtained using examples, which the managers will be able to use for obtaining the results immediately for scaled-up scenarios.
IBRAHIM ABDULLAH ALJASSER, BADRI TOPPUR, BOKKASAM SASIDHAR. (2014) Cost Allocation of Operational Materials for an Alloy and Special Steel Plant using Excel Solver, International Review of Management and Business Research, Volume 3, Issue 2.
-
Views
403 -
Downloads
39
Article Details
Volume
Issue
Type
Language
