In this study, a specific decision support system is designed and developed for Production Planning and Marketing Department of an apparel company. The developed system involves two modules with user friendly interface or data input and query. The system is designed to provide support in the following fields of decision making / pre cost estimation, capacity planning, master production planning and production scheduling. A detailed analysis of the existing system is conducted and Microsoft Access is used for the development of software. The cost and benefits of the implementing the system are also discussed in addition to basics, sample reports and the user interface of the developed program.