Free Essay


In: Computers and Technology

Submitted By capstonetrio2016
Words 1078
Pages 5
This chapter gives an overview on the background of the study and problems encountered by the business in their existing sales, inventory, and payment monitoring system.
Project Context MMTEE Agricultural Supply starts from a small family business of shoe store named Golden Bazaar. The said store was started by Mr. Manuel Tee’s mother in the late 1960’s. During those time the store did not deemed to achieve success and lead to loss of profit. So the family decided to start a new business which sells fried peanuts in the market and again it is not enough to sustain the family’s daily needs. Mr. Manuel Tee’s mother shifted the business into a rice retailing store in the year 1970’s with a Php. 60,000 capital. Later on the business was passed to Mr. Tee and decided to add agricultural feeds.
On the present day Mr. Tee’s business focuses on agricultural supplies and is located at Guadalupe Subd., Lipa City that supplies products such as flour, rice, chicken and pig feeds and other business’ products to different areas in the Province of Batangas. MMTEE Agricultural Supply has formed contracts with multi-national companies to supply his business with products such as Purina and the likes of Thunderbird. The business has a monthly revenue not smaller than 10 million pesos and has uncollected debts worth of 1 million pesos. Having four other stores around Batangas province it is very hard to supervise the transaction of each store.
But despite of all the huge numbers the business is earning, there’s also instances of shortcomings such as unmonitored report of sales and bad debts, unorganized billing of bulk orders and unsecured storage of data.
Data is gold when it comes to business, every future of businesses rely on the data especially in decision making process. Some businesses operate in the same way that they always have and some businesses now collect and examine the data that are available. Huge industries are now integrating data-driven algorithmic recommendations into their decision-making processes and this is called business analytics.
Analytics is defined as the extensive use of data, statistical and quantitative analysis, explanatory and predictive modeling, and fact-based management to drive decision making. It is all about providing business users with better insights, particularly from operational data stored in transactional systems. With analytics data collected and stored can be used effectively by analyzing and integrating all information gathered to formulate fact-based smart decisions for the better forthcoming of the business.
Purpose and Description MMTEE Agricultural Supply encountered problems on keeping track of inventory and monitoring customer debts which reflects greatly in their income. The proponents come up with a purpose on making an inventory system that shall view a complete list of items such as available products in stock, pending orders from the business suppliers and out of stock products. The inventory system will accurately be counted and valued at the end of each accounting period to determine a company's profit or loss. The purpose of this study is to provide a solution by developing a computer-based system that will assist in managing and tracking the inventory and monitoring customer debts which reflects greatly in their financial breakdown. The computer-based system involves recording the current stock of items or merchandise of the business. By enhancing and utilizing the transaction system, all data gathered are stored inside a database where previous business operations and sales are monitored and with the data congregated and analyzed by the system, it generates a summary report for future reference to make proper business decisions and strategies.
Objectives of the study
This project aims to develop a Supply and Demand Analytics System for MMTEE Agricultural supply. In order to accomplish the general objective of this study, the following specific objectives were followed: 1. To create a computerized inventory system and to monitor product shelf life. 2. To generate monthly and annual reports of business transactions. 3. To consolidate the management of business data.
Scope and Limitations
This study covers the MMTEE Agricultural Supply business’ transactions, product’s inventory and sales report that includes expenses to compute the profit. With this, the problems on stocks, sales and unrecognized debts shall be monitored and the time consumed in using manual process such as keeping track of the inventory, billing and book keeping the business is currently suffering from will be reduced. Time consuming process includes report generation and manually writing data entries on products, stocks and unpaid debts. The system shall enable the user to add and update records on product inventory needed in the operations. Other processes like the business’ transactions are entered directly into the database and shall be brought into the sales report. Using business analytics in this study, reports generated from the sales and transactions are recorded like which products are mostly brought within a particular season or date, this would lead to a predictive analytics. The business encounters problems on its suppliers because when a particular season comes, number of products can get out of stock and leads to loss of the business. Descriptive analytics would help the business to strategically raise the number of stocks when that particular season or date hit the calendar. Monitoring this shall make the business decide on futuristic outcomes and would enable the business to gain more profit.
Definition of Terms
To further understand the study, some important terms are conceptually and operationally defined.
Computer system administrator. A person whose job is to manage a company, school, and other organizations. The job of computer system administrator is to install, maintain, and support an organization's information technology systems.
Database. A database is a large collection of data organized especially for rapid search and retrieval. Most databases contain multiple tables, which includes several different fields.
Inventory. A detailed, itemized list, report or record of things in one’s possession, specially a periodic survey of all goods and materials in stocks. In this study the inventory is the record of agricultural supplies on hand that are stored in a place.
Profit. A financial gain, especially the difference between the amount earned and the amount spent in buying, operating, or producing something.
Loss. The fact or process of losing something or someone. In this study, it is an amount of money lost by a business or organization.
Sales. A transaction between two parties where the buyer receives goods (tangible or intangible), services and/or assets in exchange for money.…...

Similar Documents

Premium Essay

Export Documentation

...EXPORT PROCESS FLOW, PROCEDURE AND DOCUMENTATION Revised on November 10, 2005 Prepared By: Policy & Planning Small and Medium Enterprise Development Authority Ministry of Industries, Production & Special Initiatives Government of Pakistan HEAD OFFICE LAHORE REGIONAL OFFICE SINDH REGIONAL OFFICE NWFP REGIONAL OFFICE BALOCHISTAN 6th Floor, L.D.A Plaza, Egerton Road Lahore-54792 Tel: 111-111-456 Fax: (042) 6304926 5th Floor, Bahria Complex 2, M.T.Khan Road, Karachi Tel: (021) 111-111-456 Fax: (021) 5610572 Ground floor State Life Building The Mall, Peshawar Tel: (091) 9213046-47 Fax: (091) 286908 Bungalow No. 15-A Chaman Housing Scheme Airport Road, Quetta. Tel: (081) 2831702/2831623 Fax: (081) 2831922 Export Process Flow, Procedure & Documentation Policy & Planning INDEX 1. Introduction to SMEDA 02 2. Role of Policy and Planning 02 3. Flow Chart 03 4. Introduction 05 5. Selection of a Product 05 6. Opening of an Office 05 7. Registration for Export 05 8. Selection of Market 05 9. Quoting a Price 06 10.Signing of a Contract 06 11.Terms of Delivery 06 12.Financing for Exports 07 13.Packing 07 14.Transport 07 15.Insurance 07 16.Documentation 07 17.Post Shipment Documents 08 18.How to Claim Duty...

Words: 5503 - Pages: 23

Premium Essay

Loan Documentation

... NCC BANK LTD. ANNEXUR- ‘A’ Loan Documentation Checklist |Borrower : |M/S.Chandra Spinning Mills Ltd. CD A/C# 0210008345 | |Registered Address : |240 Tejgao Industrial Area, Dhaka-1208 | |Status : |Private Limited Company | |Loan A/c. No.: |SOD(G) -0140000771, LTR, PAD,LFS. | |Sl No. |Nature of Facilities |Amount |Validity | |01 |LC/PAD |750.00 lac |30.06.2012 | |02 |LTR |700.00 lac |30.06.2012 | |03 |SOD(G) |50.00 lac |30.06.2012 | |04 |LDBP/FDBP |1000.00 lac |30.06.2012 | 01. General Documents: |Sl No. |Description ...

Words: 1738 - Pages: 7

Free Essay

Documentation Techniques

...------------------------------------------------- Documentation Techniques Five documentation techniques include data flow diagrams, entity relationship diagrams, system flowcharts, program flowcharts, and record layout diagrams. Data Flow Diagrams and Entity Relationship Diagrams * Data flow diagrams – Data flow diagrams (DFD) use symbols to represent the entities, processes, data flows, and data stores that pertain to a system. * Entities – Entities in a DFD are objects that lie at the boundary of the system being modeled. They are the sources of and destinations for data and can be other interfacing systems or entities external to the organization. Entities are labeled as singular nouns on a DFD. Data stores represent the accounting files and records used in each process, and the labeled arrows represent data flows between processes, data stores, and entities. * Processes – Processes are labeled with a descriptive verb. Process objects should not be represented as nouns. The arrows connecting objects should be labeled to represent specific flows of data. Also, each data flow label should be unique. The same label should not be attached to two different flow lines in the same DFD. * Usage – Systems analysts use DFDs extensively to represent the logical elements of the system. It does not depict the physical system. * Entity relationship diagrams – An entity relationship diagram is used to represent the relationship between business...

Words: 735 - Pages: 3

Premium Essay

Dispensary Documentation program that accesses a database to update data and retrieve sales summary at the end of every trading day. FEASIBILITY STUDY. This is a phase of software development process in which investigation is done on the viability of the project. The main types of feasibility carried out are: TECHNICAL FEASIBILITY. The project was considered from the technical perspective. It was ascertained that the requirements and infrastructure as well as the human factor was adequate to handle the automation of the stock control aspect of solutions pharmacy business. It was also found that the staff could handle automation with ease after well-structured training sessions and regular reference to the user guide provided together with this documentation. ECONOMICAL FEASIBILITY. The expected benefits of this project outweigh its development and long term development cost. This conclusion was arrived at after considering all project expenses with the increased sales volume and fraud elimination financial implications. The following table shows the project expenses. Item | Quantity | EACH@ | Cost in Kshs | Analysis | 1 | 15000 | 15000 | transport | 1 | 1800 | 1800 | In-house coding | 1 | 7500 | 7500 | Training | | 20000 | 20000 | TOTAL | | TOTAL | 44300 | SOCIAL FEASIBILITY. The social factor of the project was also put into consideration. It was concluded that with the ICT demystification conducted and training offered, the social impact of the project was......

Words: 1288 - Pages: 6

Free Essay

Installation and Training Documentation

...(Originally in APA Format) Installation and Training Documentation Installing windows is a fairly straightforward process that requires simple instruction from the installation wizard. We need, however, an idea for the specific use of the system and how the OS will be used. So on top of an installation of the OS there needs to be an implementation of a filing system that is organized and easy to use. Also a user based system to ensure that those with the proper permissions can make the necessary changes and those without expertise cannot make significant changes and potentially ruin the system. First we need to install windows. When we insert the CD be sure to boot from the CD. The following screen should appear, prompting you if you wish to install Windows 7. Click Install now. Next a screen will show what is currently being installed. The computer will restart a few times as different sections are installed. When the installation is complete it changing screens prompting you for more information. This screen is asking for a name for the Primary User which will be defaulted as the Admin and also a name for the system itself. In this case this will be the first computer to have Windows installed on it at the ABC Hospital, so to be able to recognize it on the network it will be given a easy to remember name so you know exactly which system you are working with. ...

Words: 1190 - Pages: 5

Premium Essay

Visa Documentation

...received my Student visa, when should I travel? Students (F1 or M1) may travel within 30 days of the commencement of the course of study as stated on your I-20 regardless of how early your visa was issued. I have taken a loan from a bank to cover my tuition. Do I still need to show other financial documents? In such a case, please bring official documents, which verify the loan approval and not just the application. You must prove that funds are immediately available to cover the first year' costs, s and show evidence that funds will be available for all subsequent years. Also since Indian banks ordinarily give educational loans of relatively modest amounts, the application must still demonstrate additional liquid assets and any financial documentation you provide should be in support of this. This applies to all student visa applicants. Can I work on a student Visa? An F-1 Visa holder may accept employment on-campus, but working off-campus during the first year of study is rarely permitted. In certain cases, INS may grant permission to accept off-campus employment after one year. Except for temporary practical training, an M-1 Visa holder may not accept employment at all. Neither the spouse nor children of the student may accept employment at any time. What if I receive an I-20 from a better university after getting F1 visa? If you have obtained your visa and need to change the name of the university on your visa, you have to go through the complete process once again by......

Words: 5706 - Pages: 23

Free Essay

Export Documentation

...Export Documentation 1. When you are ready to ship, secure from the Authorized Agent Bank (AAB) an Export Declaration (ED) form with Foreign Exchange Proceeds form which you will accomplish and file at the same bank. 2. After processing the ED, the AAB releases to the exporter the original and, other copies of ED, except ED3. 3. Secure an export commodity clearance/export permit from the proper government commodity office, if your product is included in the list of regulated products for exportation or if the buyer requires. 4. With the required supporting documents, submit the accomplished ED form to the BOC Processing Unit for the approval of the Authority to Load (AL). Sending Sample Shipments Secure and accomplish an Export Declaration (ED) without Foreign Exchange Proceeds from the AAB. Follow steps 1, 2, and 3 of Export Documentation. Loading in Manila Cargos to be transported by air are inspected by the Bureau of Customs (BoC) at the Ninoy Aquino International Airport (NAIA). Conventional cargo, whether containerized or non-containerized, to be transported by ship are inspected by the Customs Container Control Division and the Piers and Inspection division, respectively, after payment of the wharfage fee and arrastre charges. Wharfage fee and arrastre services may be paid at South Harbor or MICP Loading at Provincial Ports Documentation (steps 1-3) may be done in Manila. After approval of the Authority to Load, the BoC sends message to BoC staff at the...

Words: 612 - Pages: 3

Premium Essay

Clinical Documentation

...Clinical Documentation System Excelsior College October 6, 2013 Clinical Documentation System Clinical information system (CIS) collects patient data in real time, stores healthcare data and information using secure access to the healthcare team.  (McGonigle & Garver Mastrian, 2012, p. 554).  The CIS that is used at Texas Health Dallas is CareConnect.  CareConnect is used by all of the Texas Health Resources (THR) encompassing 25 hospitals, affiliated physician offices, and ancillary facilities.  CareConnect allows physicians and management to access the system on their mobile devices and home computer for real time data.  The shift for CIS is set for implementation throughout the United States by 2015.  The clients served are those in the community that THR provides healthcare services to.  The electronic health record is shared amongst the healthcare team and other affiliates. Data collection can be continuously updated, used for “statistical evaluation for purposes of quality improvement, outcome reporting, resource management, and public health surveillance.”(Yamada, 2008, p. 5). Data collection is generally initiated in the ER, and other times when the patient is at the physician's office or in the outpatient service line.   To reference inpatient services, data collection begins in the ER.  The patient's allergies, current medications, medical history, vital signs, immunizations, suicide screening and domestic violence screening are all......

Words: 2727 - Pages: 11

Premium Essay

Export Documentation

...exporters should keep in mind that banks pay only the amount specified in the letter of credit - even if higher charges for shipping, insurance, or other factors are documented. Upon receiving a letter of credit, the exporter should carefully compare the letter's terms with the terms of the exporter's pro forma quotation. This point is extremely important, since the terms must be precisely met or the letter of credit may be invalid and the exporter may not be paid. If meeting the terms of the letter of credit is impossible or any of the information is incorrect or misspelled, the exporter should get in touch with the customer immediately and ask for an amendment to the letter of credit to correct the problem. The exporter must provide documentation showing that the goods were shipped by the date specified in the letter of credit or the exporter may not be paid. Exporters should check with their freight forwarders to make sure that no unusual conditions may arise that would delay shipment. Similarly, documents must be presented by the date specified for the letter of credit to be paid. Exporters should verify with their international bankers that sufficient time will be available for timely presentation. Exporters should always request that the letter of credit specify that partial shipments and transshipment will be allowed. Doing so prevents unforeseen problems at the last minute. Drafts A draft, sometimes also called a bill of exchange, is analogous to a foreign......

Words: 7147 - Pages: 29

Premium Essay

Documentation Guidelines

...Documentation Guidelines Respiratory Problems Respiratory rate, pattern, lung sounds, presence of cough or congestion, sputum, sternal retractions, unequal chest expansion, nasal flaring Skin color: color of lips and nail beds, cyanosis Use of O2, rate, delivery method, frequency of use,SPO2 (on RA on O2, after exertion, at rest) Weaning off O2 Use of Brochial Dialators and other respiratory medications, response to medications, Neb Tx, suctioning, IPPB Activity tolerance Causes of onset of SOB, how long does it take for relief use of high fowlers position Goals set by resident and staff teaching performed, to resident and or family Orthopedic surgery/fracture ADL: describe what they cannot do Assistance needed with what? Bathing, dressing, shaving, oral care, bed mobility, toileting (continent, incontinent, foley, bladder retraining, constipation. Transfer (lift 1-2 assist) Ambulation w/wo devices (walker, cane, w/c, distance in feet) Attending PT, OT - frequency and time, check therapy progress notes and compare to progress on the unit (tolerance) Incision: Intact, well approximated, sign of infection, treatment Cast, splint care: neuro/ vascular checks Presence of PAIN, if present what time of day, durning what activity, relief measures (medications/effectiveness) Abductor pillow, hip precations, CPM, polar ice, ted hose, PAS stockings, Goals set by resident and staff Teaching performed to resident and or family, ability to learn Diabetes Doctor...

Words: 799 - Pages: 4

Premium Essay

Export Documentations

...Export Documentation Exporters should seriously consider having the freight forwarder handle the formidable amount of documentation that exporting requires as forwarders are specialists in this process. The following documents are commonly used in exporting; but which of them are necessary in a particular transaction depends on the requirements of the U.S. government and the government of the importing country. • Air freight shipments are handled by air waybills, which can never be made in negotiable form • A bill of lading is a contract between the owner of the goods and the carrier (as with domestic shipments). For vessels, there are two types: a straight bill of lading which is nonnegotiable and a negotiable or shipper's order bill of lading. The latter can be bought, sold, or traded while the goods are in transit. The customer usually needs an original as proof of ownership to take possession of the goods • A commercial invoice is a bill for the goods from the seller to the buyer. These invoices are often used by governments to determine the true value of goods when assessing customs duties. Governments that use the commercial invoice to control imports will often specify its form, content, number of copies, language to be used, and other characteristics. • A consular invoice is a document that is required in some countries. It describes the shipment of goods and shows information such as the consignor, consignee, and value of the shipment. Certified......

Words: 910 - Pages: 4

Free Essay

Writing About Literature: Documentation

...Writing about Literature: Documentation Documentation It means acknowledging and referring to the sources from which a writer has taken information and materials from while writing a research paper. The source might be a primary one when the paper is dealing with a specific literary work or works be a certain author or it might be a secondary source when the materials referred to are of other authors who wrote on the same subject/author that the writer is writing his/her paper on. This documentation is important for two reasons: (a) to give the readers an opportunity of checking any information that he may doubt of been misinterpreted, (b) to avoid plagiarism by announcing the statements that are not of his own and are taken from other people. Documentation could be done through one of the following ways: • Textual documentation Almost all the literary papers by nature are dealing with one or more literary works which means certain text or texts are been studied. Titles like "Symbolism in William Blake's Tiger" indicate that the material that is used in the paper will a poem with the mentioned title. Essays and most of the newspaper articles that deal with one single short work without suing secondary sources are using this kind of documentation which is also called informal documentation. The name of the author and the title of the work on which the paper focus on are mentioned near the beginning of the essay as well as some other references like " in the......

Words: 1403 - Pages: 6

Premium Essay

Electronic Documentation

...Electronic Documentation Nursing is a fast changing profession that has been vital to providing care in the medical setting. Throughout the past several years one of the most recognizable changes in the medical field is the transformation from paper charting to electronic forms of documentation. This has led to a decrease in the amount of paper charting by allowing nurses to use check boxes, cell formatting, and computer databases to keep patients records more accessible and organized. As new forms of technology become available we find that there are often flaws that need to be assessed and corrected to properly implement an optimal computing system. The clinical integration paper examines the positive and negative aspects of electronic documentation in the nursing field as it pertains to time management, patient safety and its efficacy. It was found that nurses spend the largest proportion of their time at the nurses station documenting and coordinating patient’s care with twenty five to fifty percent, which results in less time spent on patient care (Blair & Smith, 2012). This is alarming knowing that approximately a quarter to half of a nurse’s shift is done sitting in front of a computer documenting the day’s events. At Central Baptist Hospital I believe that more than half a day could be taken up by computer charting. From what I have experienced, a nurse may begin their shift with anywhere between four to six patients. These patients require a general...

Words: 2776 - Pages: 12

Free Essay

Documentation for Exportation

...Documentation for exports Like the merchandise or product should be embargoed with transporters, the exporter need to make sure of follow all the steps and requirements to embargoed and to make that the merchandise finds: -Correctly packed and labeled to make sure that the merchandise be release properly and that can get on time to their final place. -Correctly documented to meet customer requirements while also complying with the regulations of the country of destination, and also regulations that apply in charge destination. -Properly insured against all risks, damage, total loss and theft, and in some cases if deemed necessary, delays. Due to the variety of considerations involved in the physics export process, most of the exporters, shippers have agents to perform these services. - Commercial Invoice. Private document issued by the seller, which contains all information relating to the sales contract for international merchandise. The bill serves as a base document for the withdrawal of the merchandise in the country of destination. The Commercial Invoice is the property of that merchandise at the level of international trade. It is one of the main documents prepared by the exporter and is often used as a basis for the development of the Letter of Credit or any other form of payment chosen by the seller and buyer. In case of the commercial invoice, as defined previously, it may obviate the drafting of the international Pro forma bill. • Form Single...

Words: 309 - Pages: 2

Free Essay

Documentation and Analysis

...Leon van der Berg & Christiaan Dotze Leon van der Berg & Christiaan Dotze Documentation, Analysis and Design Damelin Vaal (Group Assignment) Documentation, Analysis and Design Damelin Vaal (Group Assignment) Index: Page | Content | 1 | Index (this page) | 2 | Question 1 | 3 | Question 1 (continued) | 4 | Question 1 (continued) | 5 | Question 1 (continued) | 6 | Question 1 (continued) | 7 | Question 1 (continued) | 8 | Question 1 (continued) | 9 | Question 1 (continued) | 10 | Question 1 (continued) & Question 2 | 11 | Question 2 (continued) | 12 | Question 2 (continued) | 13 | References | | | Question 1 Explain the following phases of the SDLC: [50] An overview of the SDLC: a) Analysis * Systems analysis is a process of collecting factual data, understand the processes involved, identifying problems and recommending feasible suggestions for improving the system functioning. * Systems analysis involves studying the business processes, gathering operational data, understand the information flow, finding out bottlenecks and evolving solutions for overcoming the weaknesses of the system so as to achieve the organizational goals. * System Analysis also includes subdividing of complex process involving the entire system, identification of data store and manual processes. * During the analysis stage the project team determines the end-user requirements. Often this is done with...

Words: 2262 - Pages: 10