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

MRPII 62

Sajjad Hussain#1, Thuleshwar Nath*2, Mafidur Rahman#3

1M.E. Student,

2Associate Professor,

3Assistant Professor  

#Department of Mechanical Engineering, Jorhat Engineering College, Jorhat, Assam, India 

Abstract—

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.

Keywords—

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