Presented at the DLSU Research Congress 2016
De La Salle University,Manila,Philippines
March 7-9,2016
在2016年DLSU研究大会上发布
德拉萨尔大学，菲律宾马尼拉
3月7日至9日
Design,Development and Implementation of Purchasing
Management System
一个采购管理系统的设计，开发和实现
Jonel JozefB. Catapang , Lourdes Carurucan , Rionel Belen Caldo
Computer Engineering Department
Purchasing Deparment
Lyceum of the Philippines University-Laguna(LPU-L),Laguna,Philippines
Abstract: In this work,the proponents created a purchasing management system using Excel VBA macro program in assisting the purchasing department of Lyceum of the Philippines Univessity - Laguna(LPU-L). The program shall be able to help the client in getting inputs and sending items virtually to the administrator. The program responds to the requested items of the clients. The admin shall then input the prices of requested items and it will be sent to the client for the notice of payment. These specifications were all done in the Microsoft Excel(as its main repository)with realized that the program created was able to help the client and admin of purchasing department in the requisition and approval of items. The developed program was able to simplify their tasks. The program was able to provide them a tangible monitoring and recording system of essential data and information. The system was tested for requisition and approval of items as evidenced in different screen shouts. Indeed,the systemrsquo;s work is successful.
摘要：在这项工作中，支持者使用Excel VBA宏程序创建了一个采购管理系统，以协助菲律宾Univessity - Laguna（LPU-L）的Lyceum采购部门。该程序应能够帮助客户获得输入并将物品虚拟发送给管理员。该程序响应客户请求的项目。然后管理员应输入所需物品的价格，并将其发送给客户以获取付款通知。这些规范都是在Microsoft Excel（作为其主要存储库）中完成的，意识到创建的程序能够帮助采购部门的客户和管理员申请和批准物料。开发的程序能够简化他们的任务。该计划能够为他们提供有关重要数据和信息的有形监测和记录系统。该系统已经过测试，可以在不同的屏幕呼叫中得到证实。事实上，该系统的工作是成功的。
Key Words: Purchasing management; VBA macro program,Microsoft Excel,Repository
关键词：采购管理; VBA宏程序，Microsoft Excel，Repository
- INTRODUCTION
-
简介
- Background of the Study
1.1研究背景
The acquisition of goods and products nowadays have been more convenient then before. Technology has already taken part in the lives of every human; from the light bulb we often use everyday up to the computers. Combined with the system and technology,the proponents will make use of high-level programming language in the implementation of the purchasing system. The proponents will automate the manual purchasing processes using Excel Visual Basic macro program. The proponents will establish a Graphical User which will serve as the central repository of the entire system. With the use of this software, the proponents will be able to monitor and control the vital information needed and maintained by purchasing department of the institution.
现在人们购买商品和产品比以前更方便了。从我们经常使用的灯泡到电脑，技术已经渗入了每个人的生活。 结合系统和技术，支持者将采用高级编程语言实施采购系统。 支持者将使用Excel Visual Basic宏程序自动完成手动采购流程。 支持者将建立一个图形用户，它将作为整个系统的中央存储库。 通过使用这个软件，支持者将能够监控和控制机构采购部门所需要和维护的重要信息。
The core responsibility of the purchasing department is to purchase the required goods and services in running LYCEUM OF THE PHILIPPINES - LAGUNA. As its viable objective, the department is responsible for implementing cost-cutting measures. It is also responsible for negotiating competitive price and obtaining quality products. Ergo, it assures on-time delivery. Supplier selection and management are other key objectives. The principles of Purchasing Management include the following: 1.buying the Material at right PRICE, 2.Buying the Material at right QUALITY, 3.in the right QUANTITY, 4.at the right TIME, 5.from the right SOURCE, 6.at the right PLACE, and 7.with right mode of TRANSPORT.
采购部门的核心职责是采购菲律宾柚子 - 拉古娜的所需商品和服务。 作为其可行的目标，该部门负责实施削减成本措施。 它还负责谈判竞争力的价格和获得优质的产品。 埃尔戈，它确保准时交货。 供应商选择和管理是其他关键目标。 采购管理的原则包括以下内容：1、以正确的价格购买材料；2、以正确的质量购买材料；3、以正确的数量；4、在正确的时间；5、从正确的源；6、在正确的地点；7、正确的运输方式。
It was observed and analyzed that one big problem encountered by the purchasing department is that the clients often request items with lacking specifications, thereby delaying the approval of such items. The person in-charge will have to coordinate again to the client and ask for further specification. Also, speed and efficiency is a big problem when it comes to manual labor because there are many activities to be done in order to organize each elements in the inventory. With this proposed system, the proponent is confident to mitigate the problems encountered through tangible purchasing management system. And with this system, there will be minimized human errors since the system will do all the required task in purchasing for a certain department or faculty. The admin needs only to click the right buttons in order to make the system do its functionality.
据观察和分析，采购部门遇到的一个大问题是，客户经常在不提供特定规格说明的情况下要求购买某个物品，从而延误了这些物品的批准。 负责人将不得不再次协调客户并要求进一步说明。 另外， 在体力劳动方面速度和效率是一个大问题，因为要组织清单中的每个要素都有很多活动要做。 通过本文提出的系统，我们能通过有形的采购管理系统来缓解遇到的问题。 并且，通过这个系统，系统将为特定部门或教职员完成所有购买任务，从而最大限度地减少人为错误。 管理员只需要点击正确的按钮以使系统实现其功能。
The proponents took advantage of the Visual Basic Programming functionality of Microsoft Excel in the implementation of the system. Visual Basic is a programming environment from Microsoft in which a programmer uses a graphical user interface to choose and modify preselected sections of code written in the BASIC programming language. Microsoft Excel is a software developed and manufacture by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. With the use of this IDE, the programmers came up with a virtual Purchasing System that will assess the needs of clients and the admin in a much faster and easier way compared to the manual way[1][2][3](Caldo,2012).
支持者利
全文共13786字，剩余内容已隐藏，支付完成后下载完整资料
英语原文共 6 页，剩余内容已隐藏，支付完成后下载完整资料
资料编号：[12513]，资料为PDF文档或Word文档，PDF文档可免费转换为Word
以上是毕业论文外文翻译，课题毕业论文、任务书、文献综述、开题报告、程序设计、图纸设计等资料可联系客服协助查找。
