Design for manufacturing: use of a spreadsheet model of manufacturability to optimize product design and development

Product design typically precedes factory implementation and requires an understanding of factory logistics to achieve optimized design for manufacturing. We developed a spreadsheet-based model of a future factory at the very earliest stages of design of an advanced range of medical products. The algorithms have since been applied to a wide range of product designs and manufacturing operations. The model was used to optimize product design for manufacturability, develop cost-effective manufacturing processes, and design and optimize the new factory. The model incorporates cost, inventory, and factory responsiveness, and can be applied to find the optimum solution between cost and cycle time reduction. Design changes initiated as a result of analysis using the model reduced subsequent manufacturing costs significantly and reduced the launch program by two years, because confidence in the model justified the commissioning of full-scale manufacturing equipment when the product was still only at the concept stage.

[1]  R. M. Bhatkal,et al.  Economic analysis of jet deposition through technical cost modeling , 1997 .

[2]  C. F. Murphy.  Known Good Die Selection Tradeoffs: A Cost Model , 1994, Proceedings of the International Conference on Multichip Modules.

[3]  Timothy G. Gutowski,et al.  Development of a theoretical cost model for advanced composite fabrication , 1994 .

[4]  Robert S. Kaplan,et al.  The design of cost management systems : text, cases, and readings , 1991 .

[5]  Cecil Bozarth,et al.  A Conceptual Model of Manufacturing Focus , 1993 .

[6]  M. Larry Shillito,et al.  Advanced QFD: Linking Technology to Market and Company Needs , 1994 .

[7]  Dradjad Irianto.  Inspection and correction policies in setting economic product tolerance , 1996 .

[8]  A. Jeang.  An approach of tolerance design for quality improvement and cost reduction , 1997 .

[9]  D. Wild.  The Immunoassay Handbook , 2001 .

[10]  R. Kaplan,et al.  Cost & Effect: Using Integrated Cost Systems to Drive Profitability and Performance , 1997 .

[11]  Cecil C. Bozarth,et al.  The impact of market requirements focus and manufacturing characteristics focus on plant performance , 1997 .

[12]  Duncan McFarlane,et al.  Assessing the responsiveness of existing production operations , 1999 .

[13]  Gary P. Pisano,et al.  The Development Factory: Unlocking the Potential of Process Innovation , 1996 .

[14]  Steven M. Domer,et al.  Component level yield/cost model for predicting VLSI manufacturability on designs using mixed technologies, circuitry, and redundancy , 1994, Proceedings of IEEE Custom Integrated Circuits Conference - CICC '94.