Cost Estimation Model Based on Improved Spreadsheet Algorithm for Assembly Line Manufacturing Systems

Abstract:

Traditionally assembly cost models are established through static spreadsheet algorithms. However, there are some inherent problems in using spreadsheets for the estimation of manufacturing cost. Among these is the lack of accounting for dynamic effects caused by stochastic variation such as inventory fluctuation, downtimes, supply interruptions, and system failures. Therefore, a dynamic cost estimation model is proposed which can be seen as an integration method between spreadsheet modeling and the virtual plant concept, which maintained the accessibility and flexibility of the spreadsheet model, and did not require a significant increase in the effort level to build a simulation. However, it still includes the effects of interaction between machines, along with simulating random failures, maintenance dispatch and repair. A case study is also tested and the results verify that the methodology demonstrates the feasibility of dynamic cost model based on a number of improvements on static spreadsheet algorithms

• Periodical: Advanced Materials Research (Volumes 490-495)
• Pages: 2173-2177
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.490-495.2173
• Online since: March 2012
• Authors: Bin Zeng, Rui Wang, Chao Yang Ma
• Keywords: Assembly Cost Model, Cost Estimation Model, Flexible Manufacturing Systems, Spreadsheet Simulation Algorithm

References

[1] M. Braglia, S. Zanoni and L. Zavanell: International Journal of Production Research. Vol. 41(2003), pp.995-1016.

[2] M.L. Emiliani: The TQM Magazine. Vol. 13(2001), pp.34-51.

[3] S.A. Irani and H. Huang: IEEE Transactions on Robotics and Automation. Vol. 16(2000), pp.259-267.

[4] G. Koenigsaecker: Manufacturing Engineering. Vol. 132(2004), pp.134-145.

[5] S. Kulturel-Konak: Journal of Intelligent Manufacturing. Vol. 18(2007), p.273–284.

[6] N. Suresh Kumar and R. Sridharan:. Robotics and Computer Integrated Manufacturing. Vol. 25 (2009), p.829–838.

[7] I.A. Rawabdeh: International Journal of Operations & Production Management. Vol. 25(2005), pp.800-822.