DEVELOPMENT OF PRODUCTION PLANNING SYSTEM IN A MANUFACTURING ORGANISATION

Abstract

Production planning, scheduling, monitoring & controlling plays an important role in accomplishment of
the organizational objectives of manufacturing companies. A well designed rule, with an information
system that keeps track of the current situation of the shop in a real time manner, is a very effective tool for exercising
management control over the job-shop. These are especially necessary in very large job shops.
A practitioner would like a production plan meeting all the due dates while keeping overtimes and sub contracting costs to
minimum, because failure to meet due dates may result into customer dissatisfaction, bad reputation and such other
undesirable consequences.
In production planning the jobs that exist on the job shop at the time of scheduling are considered and a schedule is prepared.
In real situation, these schedules become obsolete as new jobs arrive. To manage such a changing environment, a rolling
schedule is required.
Most of the productions planning problems are dynamic in nature, i.e. new orders are received continuously during the
production process. The created production schedule may be changed to cope the changes of production orders and
manufacturing conditions during production process.
For production planning I have used Microsoft EXCEL spreadsheet. This approach is sometimes the practical solution for a
small project in a big organization. I've experimented here using the EXCEL spreadsheet format.
I have used lot of logic and formulas to make the production planning Excel sheet which is of great use in the shop oor
production environment. I've tried to keep it simple and have not used
any macros or VB, so it should be straight forward.