Abstract
The paper aims to develop an intelligent modeling system using Microsoft Excel spreadsheet interface through mathematical language, mathematical reasoning and algorithms flow chart technique for manufacturing system optimization without human involvement. The paper begins to search for a mathematical theorem which is arithmetic series to represent a dynamic manufacturing system in a production floor using production time variable through numerical analysis and is validated using software simulation. The mathematical theorem is modeled with Industrial Engineering (IE) variables into spreadsheet to perform intelligent decision making. The model sets inventory target variable to be achieved with automated computation through the data input from users. Manual analysis from human can be transposed to mathematical language in order automate the system intelligently. The building of intelligent modeling system into spreadsheet using mathematical language sets a new platform for researchers to promote the next generation of modeling technique in the manufacturing field.
Original language  English 

Title of host publication  Manufacturing Science and Technology 
Pages  66746678 
Number of pages  5 
DOIs  
Publication status  Published  2012 
Externally published  Yes 
Event  International Conference on Manufacturing Science and Technology 2011  Singapore, Singapore Duration: 16 Sept 2011 → 18 Sept 2011 https://www.scientific.net/AMR.383390 (Proceedings) 
Publication series
Name  Advanced Materials Research 

Volume  383390 
ISSN (Print)  10226680 
Conference
Conference  International Conference on Manufacturing Science and Technology 2011 

Abbreviated title  ICMST 2011 
Country/Territory  Singapore 
City  Singapore 
Period  16/09/11 → 18/09/11 
Internet address 

Keywords
 Arithmetic theorem
 Dynamic manufacturing
 Intelligent modeling
 Mathematical language
 Mathematical modeling