SYSTEM ANALYSIS AND DESIGN PROPOSAL Name of Proponents:Geraldine S. Balmeo, Juan Miguel S. Gilbuena School Year/ Trimester: 2011-2012 / 2nd Trimester Proposed Title: Wyeth Key Account Managers Inventory Monitoring System Area of Investigation: Wyeth Philippines is a dynamic organization that currently employs more than 700 people in its local operations. The Wyeth story began in 1860 when brothers John and Frank Wyeth opened a drugstore in Walnut Street, Philadelphia. Then in 1932, the brothers sold their business to American Home Products Corporation of New York (AHP).
On March 11, 2002, AHP changed its name to Wyeth to reflect its vision of becoming the world leader in research-driven pharmaceuticals. In 1958, AHP collaborated with A. T. Suaco and Co. to establish the first Filipino-American joint venture in the pharmaceutical industry. That operation started inside a single story building along Rizal Avenue. Eventually Wyeth-Suaco Laboratories, Inc. (Wyeth-Suaco) built its first nutritionals plant in 1964 along Chino Roces Avenue in Makati which today houses the main office of Wyeth Philippines Inc. Currently, Wyeth Philippines Inc. s one of the leading companies in producing pharmaceutical and nutritional products. The proponents chose the company because the proposed system will be very beneficial to the sales managers of the nutritional division in monitoring their individual accounts’ inventory and sales off take. Upon running the system, it will ask for password input, then you will be directed to the homepage wherein there will be four primary buttons to choose from. The first one is labeled Beginning inventory, the second one will be the Purchases and the third one will be the Ending inventory and lastly is the Generate Report button.
Clicking the Beginning button will redirect you to a new window wherein there will be command buttons to choose from and these are the Upload from Data button, Edit button and Delete button. On the other hand, clicking Purchases button will redirect you to a new window wherein there will be another command buttons to choose from where to Upload From Data button, Edit button and Delete button. The same goes with the Purchases button and lastly, the Generate Report button will open a window that has new options for the users hether to generate report for the sales off take, purchases, ending inventory and to download report. Reasons for the Choice of Project: The project is made to design, develop and implement a system that will make the user’s job easier and less time consuming as request by the client. The Key Account Managers are often approaching sales information staffs to request for some sales report which should be done by them alone, thus taking some of the staff’s time. Through the proposed system, the managers will be able to monitor their stocks easily as well as generate the reports on their own.
Importance of the Study: The proposed system will help the Key Account Managers of Wyeth Philippines Inc. to be more efficient and effective in monitoring their accounts. The inventory and stocks will be easily updated and managed on the system, thus giving them an idea whether to order stocks for their accounts, whether the products are not sold, and many more. Target Users/Beneficiaries: The course System Analysis and Design is specialized to convert business problems using Information Technology solutions. The proposed system will be beneficial to different users.
The Key Account Managers of the Wyeth Philippines Inc. are the main beneficiaries of the proposed system; they handle the major accounts such as SM, Robinsons, Puregold and Rustans. The Special Distributor Managers of the Wyeth Philippines Inc. are the minor beneficiaries; they handle the product’s special distributor companies which distribute the products on small and medium enterprise. The Wyeth Philippines Inc, as a whole will benefit because its employees will be more productive and more efficient in the field of business and marketing strategies. Similarities with any Previous Study/Project:
The study entitled “Golden Inventory System (2011)”, is an advanced inventory software designed for wholesale and manufacture businesses. It is developed by Quartex LLC software development company. The system is made for any business that desires a complete control over stock levels and inventory tracking. This inventory software can be used either as a simple inventory control system or a complete manufacturing solution. This is similar to our proposed system because they are both designed to have a complete control over stock levels and inventory tracking.
Our system has an advantage because it can provide report for the users the Golden Inventory cannot do so. Computerized Sales And Inventory With the use of the Computerized Sales and Inventory System, it can manage the process of the business as well as the daily transactions. It helps the personnel to do their jobs at the right time. It is much easier to do their reports and other communication for their customer. Having computers in the workplace has enabled the business to more efficiently. Sales and Inventory control systems maintain information about activities within firms that ensure the delivery of products to customers.
Software Development Tool/s to be used: Visual Studio 2010. Visual Studio supports different programming languages by means of language services, which allow the code editor and debugger to support (to varying degrees) nearly any programming language, provided a language-specific service exists. Built-in languages include C/C++ (via Visual C++), VB. NET (via Visual Basic . NET), C# (via Visual C#), and F# (as of Visual Studio 2010). It has been chosen by the proponents because the proposed system will be developed using Visual Basic .
NET. Adobe Photoshop CS5. The proponents will use this application for editing graphics that will be used in the proposed system. Photoshop and derivatives such as Photoshopped (or just Shopped) have become verbs that are sometimes used to refer to images edited by Photoshop, or any image manipulating program. “Photoshop” is also used as a noun to refer to image editing programs in general. Scope and Limitations Separate page Proponents: Approved by Committee: Adviser Committee Member Committee Member College Dean