SALES VS COSTS (SVC) REPORT GENERATION SYSTEM

Sale Versus Cost (SVC) Report Generation is a standalone application developed by
using Microsoft Visual Basic 2005 to generate Sale and Cost report for MITCO in
order to solve the current problem of using Lotus Approach. Currently, Generating
the SVC report is monthly work of Financial Department of the company which they
have been facing the difficulties. Once data has downloaded from SAP database,
they are still required to do "massaging" to get the usable information and good
report format. This massaging makes them spend more time and effort, and they still
meet difficulties of matching the actual cost with actual in the following month,
controlling exchange rate difference between SAP and Maybank and calculating
subtotal export/domestic/international sales and so on. It means Lotus approach has
been used currently is unstable and there are many steps to follow complicatedly.
That why, SVC Report Generation is proposed and developed in order help the daily
work of Finance department to increase their performance in generating the SVC
report by reducing time of massaging original data from SAP (Lotusl23). This
document will also describe the process of development life cycle with Prototype
methodology in order to understand the process and method of developing this
system. Prototype methodology is one popular and effective methodology used to
develop, both small and big system, to ensure the system can meet the user
requirements and satisfy the user. In this meaning, the user could take more
advantages from this system in order to generate the Sale Vs Cost report easily and
effectively.