Development of an aggregate planning model for the Assam Bell Metal Co-Operative Society

  IJETT-book-cover  International Journal of Engineering Trends and Technology (IJETT)          
© 2015 by IJETT Journal
Volume-27 Number-5
Year of Publication : 2015
Authors : Sajjad Hussain, Thuleshwar Nath, Mafidur Rahman


Sajjad Hussain, Thuleshwar Nath, Mafidur Rahman"Development of an aggregate planning model for the Assam Bell Metal Co-Operative Society", International Journal of Engineering Trends and Technology (IJETT), V27(5),261-268 September 2015. ISSN:2231-5381. published by seventh sense research group

With the advent of technological advancements in production, many traditionally manpower oriented industries like the bell metal industry strive for survival. Although its infrastructural pattern, techniques of manufacture and types of product has undergone extensive changes, it is still industrially unorganized. For the traditional bell metal industry in Sarthebari to survive in the present market it is necessary that the industry be handled from the industrial engineering perspective. A planned approach is essential to fulfill the demand forecasts for the upcoming period. Demand forecasts form the basis of all supply chain planning. Obtaining forecasting information frequently means using sophisticated techniques to estimate future sales or market conditions. Aggregate planning transforms forecasts into plans of activity to satisfy the projected demand. A key decision managers’ face is how to collaborate on aggregate planning throughout the entire supply chain. To accomplish aggregate planning, MSEXCEL 2010 spreadsheet application is used which helps us to formulate the planning for the upcoming financial year. The optimized total cost incurred is determined against decision variables which cumulatively the total cost for the next financial year. The aggregate plan becomes a critical piece of information to be shared across the supply chain because it affects both the demand on a firm's suppliers and the supply to its customers. To be effective, it requires inputs from throughout the supply chain, and its results have a tremendous impact on supply chain performance.


[1] Chopra, S., Meindl, P., Supply chain management: strategy, planning, and operation 3rd edition, ISBN: 0-13-208608-5, 2007;.pp. 01-121.
[2] Kalita, B., ‘The Bell Metal industry of Sarthebari’, XVIII no edition, 2008, Assam State Museum bulletin board, pp. 37-47.
[3] Goswami, B., ‘Traditional crafts of Assam and their role in employment generation- A study in lower Assam (with focus on some special crafts.)’, 398-GOS, 2007, pp. 93-111.
[4] Guillermo, G., ‘IEOR 4000: Production Management’, Lecture 5, October 2000.
[5] Kleiner, B. H and Pan Lin., ‘Aggregate planning today’, Vol. 44 No. 3, 1995, pp. 4-7, © MCB University Press, 0043- 8022, May/ June 1995.
[6] Sankaranarayanan, T, Khound P.K.., Sellathurai, G, ‘Productivity studies in Bell metal industry at Sarthebari(Assam)’, Prepared by National productivity Council,Guwahati-24;sponsored by IDBI in the library of AIDC office, Guwahati.
[7] Sultana, N., Shohan, S., Sufian. F., ‘Aggregate planning using transportation method: a case study in cable industry’, International Journal of Managing Value and Supply Chains (IJMVSC), Vol.5, No. 3, September 2014.
[8] Johnny, C. Ho., Francisco J. L, David Ang,, ‘Teaching aggregate planning in operations management’, ISSN: 2163- 9280; Spring, 2015; Volume 14, Number 1.
[9] Techawiboonwong, A. and Yenradee, P., ‘Aggregate Production Planning Using Spreadsheet Solver: Model and Case Study’, Industrial Engineering Program, Science Asia, pp. 291-300, 2002.
[10] Correa, F.A., Garrido N. P., ‘Excel Model for Aggregate Planning’; Second World Conference on POM and 15th Annual POM Conference; Cancun, Mexico; April 30-May 3, 2004.

Bell metal industry, Industrial engineering, Forecasting, Aggregate planning, Supply chain, Planning Horizon.