Skip to main content
Log in

A decision support system framework to process customer order enquiries in SMEs

  • ORIGINAL ARTICLE
  • Published:
The International Journal of Advanced Manufacturing Technology Aims and scope Submit manuscript

Abstract

Research carried out here describes order processing especially with constraints of due date at the customer enquiry stage in a highly competitive global market. It highlights problems faced by small- and medium-sized enterprises (SMEs) in a make-to-order environment with particular reference to quality and speed of delivery at this critical stage. While commercial software such as manufacturing resource planning and enterprise resource planning can be used at this enquiry stage for SMEs, they may be unaffordable especially due to high maintenance running costs. This study recognizes this challenge facing SMEs during enquiry management and justifies the need that an effective decision support system (DSS) is crucial even if SMEs have some planning and control systems in place. A flow chart is presented to highlight the influence of negotiation on customer due dates to serve as a basis for forward or backward planning, and a case example illustrates the fundamental construction and applicability of the proposed DSS approach with a resultant profit maximization outcome if the strategy is carefully implemented.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

References

  1. CBI (2000) SME Trends Report. London, July, 10–12

  2. Kingsman BG, Hendry L, Mercer A, De Souza A (1996) Responding to customer enquiries in make-to-order companies—problems and solutions. Int J Prod Econ 46/47:219–231 doi:10.1016/0925-5273(95)00199-9

  3. Hendry LC, Kingsman BG (1993) Customer enquiry management: part of a hierarchical system to control lead times in make-to-order companies. J Oper Res 44(1):61–70 doi:10.1057/palgrave.jors.0440107

    Article  MATH  Google Scholar 

  4. Kingsman BG, Lee W, Hendry LC, Alan M, Elaine W (1993) Integrating marketing and production planning in make-to-order companies. Int J Prod Econ 30/31:53–66 doi:10.1016/0925-5273(93)90081-U

    Article  Google Scholar 

  5. Hendry LC (1992) COPP: a decision support system for managing customer enquiries. Int J Oper Prod Manage 12(11):53–64 doi:10.1108/01443579210017501

    Article  Google Scholar 

  6. Ulusoy G, Yazgac T (1995) Joint decision making for production and marketing. Int J Prod Res 33(8):2277–2293 doi:10.1080/00207549508904815

    Article  MATH  Google Scholar 

  7. Halsall DN, Price DHR (1999) A DSS approach to developing systems to support production planning control in small companies. Int J Prod Res 37(7):1645–1660 doi:10.1080/002075499191175

    Article  MATH  Google Scholar 

  8. Olumolade M, Norrie D (1996) A decision-support system for scheduling in a customer-oriented manufacturing environment. Integrated Manuf Syst 7(3):38–46 doi:10.1108/09576069610116922

    Article  Google Scholar 

  9. Xiong MH, Tor SB, Khoo LP, Bhatnagar R, Venkat S (2003) Framework to managing customer enquirers for SMEs. Singapore-MIT Alliance Symposium 2003, Singapore

  10. Yen DC, Chou DC, Chang J (2002) A synergic analysis for Web-based enterprise resource planning systems. Comput Stand Interfaces 24(4):337–346 doi:10.1016/S0920-5489(01)00105-2

    Article  Google Scholar 

  11. Xiong MH, Tor SB, Bhatnagar R, Khoo LP, Venkat S (2006) A DSS approach to managing customer enquiries for SMEs at the customer enquiry stage. Int J Prod Econ 103:332–346 doi:10.1016/j.ijpe.2005.08.008

    Article  Google Scholar 

  12. Gebert H, Geib M, Kolbe L, Brenner W (2003) Knowledge-enabled customer relationship management: integrating customer relationship management and knowledge management concepts. J Knowl Manage 7(5):107–123 doi:10.1108/13673270310505421

    Article  Google Scholar 

  13. Sheikh K (2003)Manufacturing Resource Planning (MRPII) with an introduction to ERP, SCM, and CRM. McGraw-Hill

  14. Parente DH, Pegels CC, Nallan S (2002) An exploratory study of the sales-production relationship and customer satisfaction. Int J Oper Prod Manage 22(9):997–1013 doi:10.1108/01443570210440500

    Article  Google Scholar 

  15. Xu Y, Yen DC, Lin B, Chou DC (2002) Adopting customer relationship management technology. Ind Manage Data Syst 102(8):442–452 doi:10.1108/02635570210445871

    Article  Google Scholar 

  16. Stadtler H, Kilger C (2000) Supply chain management and advanced planning—concepts, models, software and case studies. Springer, New York

    Google Scholar 

  17. Xiong MH, Tor SB, Khoo LP, Chen C-H (2003) A web-enhanced dynamic BOM-based Available-To-Promise System. Int J Prod Econ 84(2):133–147 doi:10.1016/S0925-5273(02)00414-0

    Article  Google Scholar 

  18. Tor SB, Xiong MH, Bhatnagar R, Khoo LP, Venkat S, Extended dynamic BOM: a new approach for handling multilevel BOM. Submitted to Production planning and control.

  19. Framinan JM, Leisten R (2007) A note on “A DSS approach to managing customer enquiries for SMEs at the customer level enquiry stage” (A short communication). Int J Prod Econ Vol 109:254–255. Available On line at WWW.Sciencedirect.com, doi:10.1016/j.ijpe.2007.03.009

  20. Oliviera C, Antunes CH (2007) Multiple objective linear programming models with interval coefficients—an illustrated overview. Eur J Oper Res 181:1434–1463 doi:10.1016/j.ejor.2005.12.042

    Article  Google Scholar 

  21. Polacek M, Doerner KF, Harti RF, Kieche G, Reimann M (2007) Scheduling periodic customer visits for a traveling salesperson. Eur J Oper Res 179:823–837 doi:10.1016/j.ejor.2005.03.056

    Article  MATH  Google Scholar 

  22. Klashner R, Sabet S (2007) A DSS design model for complex systems; lessons from mission critical infrastructure. Decis Support Syst 43:990–1013 doi:10.1016/j.dss.2005.05.027

    Article  Google Scholar 

  23. Power DJ, Sharda R (2007) Model-driven decision support systems: concepts and research directions. Decision Support Systems 43:1044–1061

    Article  Google Scholar 

  24. Zorzini M, Corti D, Pozzetti A (2008) Due date (DD) quotation and capacity planning in make-to-order companies: results from an empirical analysis. Int J Prod Econ 112:919–933

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Chike F. Oduoza.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Oduoza, C.F., Xiong, M.H. A decision support system framework to process customer order enquiries in SMEs. Int J Adv Manuf Technol 42, 398–407 (2009). https://doi.org/10.1007/s00170-008-1596-0

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00170-008-1596-0

Keywords

Navigation