1 AIT Asian Institute of Technology

Material consumption forecasting for the batch process industry : a case study

AuthorSirimon Ubonpong
Call NumberAIT Thesis no.ISE-99-49
Subject(s)Material requirements planning

NoteA thesis submitted in partial fulfillment of the requirements for the degree of Master of Engineering, School of Advanced Technologies
PublisherAsian Institute of Technology
Series StatementThesis ; no. ISE-99-49
AbstractThis study presents a simple, effective way to plan for material consumption for a small batch process factory. The work started with the procedure to forecast the monthly sales values for the next year. This forecast sales values are then converted into production quantities required to meet the sales targets. Net production requirements are then calculated. The net production requirements for the next three months are used to calculate the raw material consumption over the same period. This is the common input for the purchasing and the financial departments. The procedures are implemented using Microsoft Excel Spreadsheet. Although the user interface is quite rudimentary, the procedure helps the company under studied to have a more effective raw material procurement plan as well as a better basis for the planning and control of the weekly or monthly production schedule.
Year1999
Corresponding Series Added EntryAsian Institute of Technology. Thesis ; no. ISE-99-49
TypeThesis
SchoolSchool of Advanced Technologies (SAT)
DepartmentDepartment of Industrial Systems Engineering (DISE)
Academic Program/FoSIndustrial Systems Engineering (ISE)
Chairperson(s)Voratas Kachitvichyanukul;
Examination Committee(s)Nagarnr, N. N.;Hasin, Md. A. A.;
Scholarship Donor(s)Material requirements planning;
DegreeThesis (M.Eng.) - Asian Institute of Technology


Usage Metrics
View Detail0
Read PDF0
Download PDF0