期刊名称：International Review of Management and Business Research
印刷版ISSN：2307-5953
电子版ISSN：2306-9007
出版年度：2014
卷号：3
期号：2Part 4
页码：1145-1150
出版社：Academy of IRMBR
摘要：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.
