Free Essay

Computerized Inventory System Not Complete

In:

Submitted By knycereinn
Words 2373
Pages 10
Chapter I
INTRODUCTION

Background of the Study

Technology advances as it changes through the times. However, despite this advancement in technology, Ding-Dong Hardware in Glan, Sarangani Province still uses the manual process in their inventory. The Ding-Dong Hardware finds it hard; hence, the database of a systematic inventory was conceived. The researcher conducted interviews and surveys in developing a database computerized inventory system. Using the System Development Life Cycle (SDLC) Method, this Ding-Dong Hardware Computerized Inventory System was successfully attained. It could generate the derived data that would greatly help the personnel in preparing inventory and to speed up the process.

Objectives of the Study

Generally, this study aimed to create a database system for the Ding-Dong Hardware in Poblacion, Glan, Sarangani Province. Specifically, this was geared to: 1. Lessen the time spent in preparing inventory; 2. Ensured hardware records of data and information; and 3. Improve track of information about the business status.

Significance of the Study

The study was conceptualized to solve problems occurring in preparing inventory (daily, monthly and yearly inventory), keeping records of information and in keeping track of the business status in Ding-Dong Hardware in Glan, Sarangani Province. The researcher computerized the manual process to provide assistance to the personnel in charge of generating, regulating and ensuring data and record with lesser time and effort.

Scope and Delimitation The researcher conducted this study in Ding-Dong Hardware in Glan, Sarangani Province. It mainly focused on the product inventory and handling of records. It could generate report and provide an organized, secured records, and accurate reports. In its operational functions, only the manager and cashier can update the current files inventory

Operational Definition of Terms

Cashier- A person responsible for receiving payments for goods and services
Coding – refers to the transforming data and logic from design specification into a programming language.
Computer – is an electronic programmable device which can store, process and retrieve data.
Computerized – is an organized collection of data for one or more purposes in digital form. Computerized Inventory System – the system comprises central computerized database. Hardware – Instrumentalities (tools or implements) made of metal Inventory– A detailed list of all the items in stock
Manager –Someone who controls resources and expenditures
Program – a list of instructions, written in a programming language tells the computer what to do.
Personnel – Group of people willing to obey orders
System – is a computerized program.

Conceptual Framework Figure 1: Computerized
Computerized
SDLC
SDLC
Manual
Manual

Manual System

In this process, the personnel in-charge performs manual inventory of products in Ding-Dong Hardware. This involves recordkeeping of every transaction specifically on sold products and remaining products. SDLC

This shows the conversion of a manual operation into a computerized system. This process involved the System Development Life Cycle (SDLC). This consists of the Planning Phase, Analysis Phase, Design Phase, Development Phase, and Implementation Phase. The researcher utilized the process of SDLC to develop the study. Computerized System

Involving the SDLC process, the computerized scheduling system was made. Transactions for schedules per request were achieved in lesser time and effort reducing the burden on the part of the personnel in-charge
Chapter II
REVIEW OF RELATED LITERATURE

In doing and completing this study, “ Ding-Dong Hardware Computerized Inventory System “ the researcher collected information through other research studies such as the in
. The data gathered served as one of the components in creating a database computerized scheduling system in Ding-Dong Hardware in Glan, Sarangani Province.

Chapter III
METHODOLOGY

Methodology deals how a system is conceptualized and developed using the System Development Life Cycle (SDLC). In this study, the researcher went through the planning phase which deals with the identification of the problem and title development; analysis phase that involves the formation of the flow of the system; development phase that involves the coding of the program, debugging and testing; and implementation phase of the system where it was designed to be installed or be used.

Figure 2. The SDLC (System Development Life Cycle)
Analyzing Phase
Analyzing Phase
Implementation Phase
Implementation Phase
Planning Phase
Planning Phase
Development Phase
Development Phase
Designing Phase
Designing Phase

Planning Phase

In the planning phase, the researcher had identified and determined the problem, objectives and the scope and delimitation of the study to assure cost and duration. The researcher consulted persons for the needed theoretical and technical help.

Analysis Phase

In the Analysis Phase, the researcher sought for possible techniques and alternative actions through interviews and consultations in the gathering of data and information related to this study. The researcher analyzed the data and made comparisons between the existing manual system and the proposed computerized system.

Design Phase

In this phase, the researcher formulated the flow of the system and possible data only in entry based on the previous phase which is the researcher stated. They had used a different tool necessary to the system, Context Diagram, Data Flow Diagram, and File Structure and program flowchart tool place. To meet the information needed, the researcher designed an output based on the following:
Context Diagram – which shows the entire view of proposing a system;
Data Flow Diagram – an illustration of the flowchart of data and the operations to be performed in the system.;
Data Structure – that shows a detailed description of the data components;
File Structure – the collection of elements names, addresses, or sequences of Schedules and treated as a unit.; and
Program Flowchart - which refers to the step – by - step process of performing the computer program.

Development Phase

In this phase, the researcher converted the existing manual system into a computerized system by using a Visual Basic Programming Language to present and execute a running program.

Implementation Phase

This Ding-Dong Hardware Computerized Inventory System was implemented and tried in Ding-Dong Hardware - Glan, Sarangani Province wherein the Manager and the system user was instructed and oriented how to operate and consolidate a system.

Project Duration The study covered up the whole duration of the academic year 2014-2015. The earlier months were spent for documentation and designing process. The remaining months, on the other hand, were spared in developing and in coding system.

Table 2. Gantt Chart Activities | June | July | August | September | October | Planning Phase | W1 | W2 | W3 | W4 | W1 | W2 | W3 | W4 | W1 | W2 | W3 | W4 | W1 | W2 | W3 | W4 | W1 | W2 | W3 | W4 | Gather Information | | | | | | | | | | | | | | | | | | | Research | | | | | | | | | | | | | | | | | | | Analyzing Phase | | | | | | | | | | | | | | | | | | | | | Study Problem Gather | | | | | | | | | | | | | | | | | | | Designing Phase | | | | | | | | | | | | | | | | | | | | | Create User Interface | | | | | | | | | | | | | | | | | | | Implementation Phase | | | | | | | | | | | | | | | | | | | | | Testing | | | | | | | | | | | | | | | | | | | | | Proving | | | | | | | | | | | | | | | | | | | | | Dry Run | | | | | | | | | | | | | | | | | | | | Implementation Phase | | | | | | | | | | | | | | | | | |

Project Requirement and Cost

It refers to the table for the distributions of expenses.
Table 1 Quality | Description | Unit Price | Amounts | 1 unit1 pc1 pc1 pc1 pc1 pc1 pc1 pc | Desktop ComputerSpecificationComputer Monitor (300x300/17’LCD)80GB Hard Disk Drive2GB DDR3Asus P5KPL-AM Desktop Motherboard-Intel – Socket T LGA-775Intel Celeron 430 1.8ghzLG22x IDE Super Multi DVD WriterA4Tech USB MouseGenius Keyboard KB 100 PS2Microsoft Windows XP Professional SP3 (32 bit) | Php 15, 810.00 | Php 15, 810.00 | 1 pc | Computer AccessoriesUSB 4GB Flash Drive | Php 700.00 | Php 700.00 | 2 rm | Bond Paper (short) | Php 150.00 | Php 300.00 | | Contingencies | Php 2,000.00 | Php 2,000.00 | Total Cost Php 18,810.00 |

Get fill-up Baptism form
Get fill-up Baptism form
CONTEXT DIAGRAM

Get fill-up Request form (Blessing/Thanksgiving Mass)
Get fill-up Request form (Blessing/Thanksgiving Mass)

Get fill-up Baptism Form
Get fill-up Baptism Form
Get fill-up Wedding Form
Get fill-up Wedding Form

Client

Client

Get fill-up Fiesta Form
Get fill-up Fiesta Form
Get fill-up Wedding form
Get fill-up Wedding form

Get fill-up Funeral Form
Get fill-up Funeral Form

Get fill-up Permit Form
Get fill-up Permit Form

Generate Request Form
Generate Request Form

Generate Baptism Form
Generate Baptism Form
Generate Wedding Form
Generate Wedding Form

Glan Parish Scheduling System
Glan Parish Scheduling System
Generate Fiesta Form
Generate Fiesta Form

Generate Permit Form
Generate Permit Form
Generate Funeral Form
Generate Funeral Form

Update All
Information Form
Update All
Information Form

Generate Client Report/Schedule
Generate Client Report/Schedule

Secretary

Secretary

Request Form
Request Form
Client
Client
Fill-up Request Form
Record
1
Fill-up Request Form
Record
1
Request Schedule
D1
Request Schedule
D1
Data Flow Diagram
Data Flow Diagram

Fill-up Baptism Form
Record
2
Fill-up Baptism Form
Record
2

Baptism Form
Baptism Form
Baptism Schedule
D2
Baptism Schedule
D2

Fill-up Wedding Form
Record
3
Fill-up Wedding Form
Record
3

Wedding Form
Wedding Form
Wedding Schedule
D3
Wedding Schedule
D3

Fill-up Fiesta Form
Record
4
Fill-up Fiesta Form
Record
4

Fiesta Form
Fiesta Form
Fiesta Schedule
D4
Fiesta Schedule
D4

Fill-up Funeral/Burial
Record
5
Fill-up Funeral/Burial
Record
5

Burial Schedule
D5
Burial Schedule
D5
Blessing Form
Blessing Form

Fill-up Permit Record
6
Fill-up Permit Record
6

Permit Form
Permit Form
Permit Schedule
D6
Permit Schedule
D6

Secretary Secretary

7
7
Update Permit Schedule Update Permit Schedule Update Schedule Record
Update Schedule Record Update Funeral/ Schedule Update Funeral/ Schedule Update Fiesta Schedule Update Fiesta Schedule

Update Client Schedule Record
Update Client Schedule Record Update Wedding Schedule Update Wedding Schedule Update Request Schedule Update Request Schedule Update Baptism Schedule Update Baptism Schedule

7.1
7.1

Generate Baptism Schedule
Generate Baptism Schedule
Generate Request Schedule
Generate Request Schedule
1
1
2
2

Generate Fiesta Schedule
Generate Fiesta Schedule
Generate Wedding Schedule
Generate Wedding Schedule Generate Client Schedule/Report Generate Client Schedule/Report
Generate Schedule
Record
Generate Schedule
Record
3
3

Generate Funeral Schedule Generate Funeral Schedule
4
4
5
5 Generate Permit Schedule
Generate Permit Schedule

6
6

DATA STRUCTURE

Request Form Column Name | Data Type | Length | Request_ID | String/Integer | 10 | Request_for | Varchar | 50 | Requested_by | Varchar | 50 | Date | String/Integer | 20 | Time | String/Integer | 10 | Venue | Varchar | 50 | Contact_No | String/Integer | 15 | Celebrant | Varchar | 50 | Approved_by | Varchar | 50 | Date_Applied | String/Integer | 20 |

Fiesta Column Name | Data Type | Length | Fiesta_ID | String/Integer | 10 | Requested_by | Varchar | 50 | Patron/GKK | Varchar | 50 | Address | Varchar | 50 | Date_of_Fiesta | String/Integer | 20 | Time | String/Integer | 10 | Celebrant | Varchar | 50 | Approved_by | Varchar | 50 | Date_Applied | String/Integer | 20 |

Baptism Column Name | Data Type | Length | Baptism_ID | String/Integer | 10 | Name_of_Child | Varchar | 50 | Date_of_Birth | String/Integer | 10 | Place_of_Birth | Varchar | 50 | Father | Varchar | 50 | Mother | Varchar | 50 | Address | Varchar | 50 | Contact_No. | String/Integer | 15 | Date_of_Baptism | String/Integer | 20 | Time | String/Integer | 10 | Celebrant | Varchar | 50 | Approved_by | Varchar | 50 | Date_Applied | String/Integer | 20 |

Wedding Column Name | Data Type | Length | Wedding_ID | String/Integer | 10 | Groom | Varchar | 50 | Date_of_Birth | String/Integer | 50 | Age | String/Integer | 10 | Religion | Varchar | 20 | Nationality | Varchar | 20 | Address | Varchar | 50 | GKK | Varchar | 50 | Contact_No. | String/Integer | 15 | Bride | Varchar | 50 | Date_of_Birth | String/Integer | 20 | Age | String/Integer | 10 | Religion | Varchar | 20 | Nationality | Varchar | 20 | Address | Varchar | 50 | GKK | Varchar | 50 | Contact_No. | String/Integer | 15 | Date_of_Marriage | String/Integer | 20 | Time | String/Integer | 10 | Celebrant | Varchar | 50 | Approved_by | Varchar | 50 | Date_Applied | String/Integer | 20 |

Burial Column Name | Data Type | Length | Burial_ID | String/Integer | 10 | Requested | Varchar | 50 | Deceased | Varchar | 50 | Age | String/Integer | 10 | Father | Varchar | 50 | Mother | Varchar | 50 | Status | Varchar | 15 | Spouse | Varchar | 50 | No_of_Children | String/Integer | 10 | Last_Sacrament | Varchar | 30 | Date_Applied | String/Integer | 20 | Cause_of_Death | Varchar | 50 | Date_of_Mass | String/Integer | 20 | Time_of_Mass | Varchar | 10 | Place_of_Mass | Varchar | 50 | Place_of_Burial | Varchar | 50 | Celebrant | Varchar | 50 | Approved_by | Varchar | 50 | Date_Applied | String/Integer | 20 |

Permit Column Name | Data Type | Length | Permit_ID | String/Integer | 10 | Permission | Varchar | 50 | To_request | Varchar | 50 | To_Officiate | Varchar | 50 | Date | String/Integer | 20 | Venue | Varchar | 50 | Requested_by | Varchar | 50 | Approved_by | Varchar | 50 |

FILE STRUCTURE

Request Form

Request_ID | Request_for | Requested_by | Date | Time | 0001 | Store Blessing | Boy Ventolero | 9/30/2011 | 1:00 PM | 0002 | House Blessing | Daisy Alido | 9/30/2011 | 1:00 PM |

Venue | Contact_No. | Celebrant | Approved_by | Pob. Glan | 09066666350 | Fr. Rodrigo Gegone, Jr. | Fr. Ricky Legario | Ilaya, Glan | 09193221277 | Fr. Ricky Legario | Fr. Ricky Legario |

Fiesta

Fiesta_ID | Requested_by | Patron/GKK | Address | Date_of_Fiesta | 0001 | Alice Cuico | Sto. Niño | Padidu, Glan | 10/15/2011 | 0002 | Jocel Rondario | Holy Spirit | Poblacion, Glan | 10/15/2011 |

Time | Celebrant | Approved_by | Date_Applied | 10:00 AM | Fr. Ricky Legario | Fr. Ricky D. Legario | 1/02/2011 | 10:00 AM | Fr. Fortunato Ferolino | Fr. Ricky D. Legario | 11/20/2011 |

Baptism

Baptism_ID | Name_of_Child | Date_of_Birth | Place_of_Birth | 0001 | Shenie A. Carcueva | May 21, 2004 | Sufatubo, Glan | 0002 | Cherrry Mae R. Lanoy | March 23, 2011 | Poblacion, Glan |

Father | Mother | Address | Contact_No. | Ronie C. Carcueva | Lanie Mae Acollador | Sufatubo, GSP | 09092545638 | Pablo G. Lanoy | Aniana Z. Reducto | Poblacion, Glan | 09275454121 |

Date_of_Baptism | Time | Celebrant | Approved_by | Date_Applied | May 19, 2010 | 9:30 AM | Fr. Cristito M. Joloro | Fr. Romeo Subaldo | May 4, 2010 | May 19, 2010 | 9:30 AM | Fr. Sinon C. Alcarde | Fr. Romeo Subaldo | September 1, 2011 |

Wedding

Wedding_ID | Groom | Date_of_Birth | Age | Religion | 0001 | Yoyoy A. Villorente | February 19, 1984 | 24 | Roman Catholic | 0002 | Marchejun Alegado | March 14, 1989 | 22 | Roman Catholic |

Nationality | Address | GKK | Contact_No. | Bride | Filipino | Sufatubo, Glan | San Francisco | 09092545638 | Janette S. Kilat | Filipino | Kiogam, Glan | San Roque | 09055436188 | Jomarie Noval |

Date_of_Birth | Age | Religion | Nationality | Address | GKK | April 26, 1987 | 20 | Roman Catholic | Filipino | New Aklan, Glan | Sto. Niño | April 10, 1991 | 20 | Roman Catholic | Filipino | Tango, Glan | B. sa Lourdes |

Contact_No. | Date_of_Marriage | Time | Celebrant | Approved_by | Date_Applied | 09092545638 | April 28, 2008 | 10:00 AM | Fr. Romeo Subaldo | Fr. Romeo Subaldo | February 5, 2008 | 09262541421 | August 2, 2011 | 10:00 AM | Fr. Tito Joloro | Fr. Romeo Subaldo | March 15, 2011 |

Burial

Burial_ID | Requested_by | Deceased | Age | Father | 0001 | Monteza Family | Raymondo Monteza | 54 | N/A | 0002 | Lara Family | George Lara | 56 | Dionisio Lara |

Mother | Status | Spouse | No_Child | Last_Sacrament | N/A | Married | Tita Monteza | 11 | Baptism | Anie Lara | Single | N/A | N/A | Annointed |

Date_Died | Cause_of_Death | Date_of_Mass | Time_of_Mass | Place_of_Mass | 10/05/2011 | Bone Cancer | 10/14/2011 | 1:00 PM | Pob. Glan | 11/6/2011 | Old Age | 10/14/2011 | 1:00 PM | Kiogam, Ilaya |

Place_of_Burial | Celebrant | Approved_by | Date_Applied | Pob. Glan | Fr. Fortunato Ferolino | Fr. Ricky Legario | 10/05/2011 | Kiogam, Ilaya | Fr. Ricky legario | Fr. Ricky Legario | 11/6/2011 |

Permit

Permit_ID | Permission | To_Request | To_Officiate | 0001 | Monteza Family | Cablalan, Glan | Fr. Rodrigo Gegone | 0002 | Lara Family | Kiogam, Glan | Fr. Fortunato Ferolino |

Date | Venue | Requested_by | Approved_by | 10/10/11 | Cablalan, Glan | Lilia Monteza | Fr. Ricky D. Legario | 10/10/11 | Kiogam, Glan | Florencia Sentillas | Fr. Ricky D. Legario |

Similar Documents

Premium Essay

Capstone

...Computerized Book Inventory System Golden Success College 1297 V. Rama Ave. Corner Singson St. Guadalupe, Cebu City A Project Implementation Report Presented to The Faculty of Information Technology Golden Success College, Inc. In Partial Fulfillment of the Requirement for Capstone Project Proponents Dave Oficiar Barabat Catherine Rule Benlot Mark Jayson Jarina Cueva Mia Mangyao Labonite Ms. Lenny B. Yamilo Adviser October 2014 Table of Contents Page No. Acknowledgement Report Summary Project Proposal Introduction Rationale of the Study Background of the Study Statement of the Problem General Problem Specific Problem Objectives of the Problem General Objectives Specific Objectives Scope and Limitation Scope of the Study Limitation of the Study Significance of the Study System Design Specification System Design Review of Related Literature Methodology of the Study Theoretical Framework Appendices Appendix A Appendix B Appendix C Curriculum Vitae Glossary Bibliography Acknowledgement The proponents would like to express the deepest appreciation to Ms. Leny B. Yamilo, who has the attitude and the substance of a genius; she continually and convincingly conveyed a spirit of adventure in regard to research and an excitement in regarding to teaching. Without her guidance and persistent help this dissertation would not have been possible. Special thanks also to my co-proponents, who stood and determinedly joined...

Words: 4229 - Pages: 17

Free Essay

Sales

...transaction process system also known as (TPS) it is information processing system for business transactions an information scheme for the collection, modification and retrieval of all transactions. Additionally transaction processing system has three characteristics it includes performance, reliability and consistency. An example of a transaction processing system commonly used in business by major credit card companies found in almost every retail store. Nowadays, using of transaction processing system in companies and other establishments in transacting with their clients is a big factor or help for them. Some of the companies or stores are still using the manual way in running their business. By using the manual way, they consume more time and energy just to finish their work. So, companies now are making their system computerized because this can help them minimize the time and efforts consumed by using manual-system. So, we decided to create a sales and inventory system. A sale is an activity involved in the selling of products or services in return for money or other compensation. It is an act of completion of a commercial activity while inventory A list of what you have in company accounts. Inventory usually refers to the value of stocks, as distinct from fixed assets. An inventory would include items which are held for sale in the ordinary course of business or which are in the process of production for the purpose of sale. Sales and Inventory System is designed for...

Words: 377 - Pages: 2

Premium Essay

System for Pizza Ingredients

...Effective Management of Inventory System for Pizza Ingredients Feb 21, 2014 Abstract It used to be a problem for companies to handle their inventory. Thanks to technology, it saved thousands of hours of labor work. Inventory system is very imperative for organization because most of their strategic decisions are rooted here. Marketing gets sales information to generate sales forecast. On the other hand, Manufacturers are able to accurately define their stock and prevent unpleasant events such as stock-out and overstock. In order to expound more on the capability of this system, this study will provide sufficient information regarding its use, weaknesses and maintenance. By the use of local and foreign text, the study was able to relate its objective to the actual prototype.The proponents will demonstrate actual working system that will cater the products of the imaginary pizza shop. It is only limited for employee usage and will not cover the point of sale system. However, it will provide critical stocks that will determine products that need to be delivered. Moreover, it will show how to exactly manage and navigate a warehouse information system by providing a simple management of inventory. It used MySQL database and Microsoft studio’s c-sharp language to fulfill the objective and purpose of the paper. The main purpose of the study is to create a simple inventory system so that future researchers may get resources from this and improve the results. Chapter 1 Introduction ...

Words: 4707 - Pages: 19

Premium Essay

Physical Inventory

...MR1) In observing the client’s annual physical inventory, the auditor’s primary objectives include; * To see to it that all inventory movements (physically or logically) are authorized. * That inventory included in the statement of financial position physically exists. * Ensure that the inventory records only include items that belong to the entity. * And that the inventory quantities have been accurately determined. * Check to see that all purchases and sales of inventory have been recorded in the accounting system. * That disclosures relating to classification and valuation are sufficient. * Inventory is properly stated at the lower of cost and net realizable value. * All purchases and sales of inventory are recorded in the correct accounting period. * That inventory transaction and balance are properly identified and classified in the financial statement Key audit procedure that an auditor would typically perform during and after the client’s physical inventory; The two major steps in the observation of a physical inventory are as follows : * Planning the physical inventory * Taking the physical inventory Planning the physical inventory before conducting the physical count is essential. The auditor should review or prepare the client instructions and should work closely with the client in the planning stage. The inventory should be taken at a time when operations are suspended or minimal. The client has primary responsibility...

Words: 902 - Pages: 4

Free Essay

Tangna

...00 NAVAL POSTGRADUATE SCHOOL Monterey, California VV STATE I V E DTI 'AN! 30,19911 THESIS COMPUTERIZED POINT-OF-SALES SYSTEM MORALE, WELFARE, AND RECREATION DEPARTMENT LONG BfACH, CALIFORNIA by James J. Coltellaro June, 1990 Leslie J. Zambo Glenn 1i-01r- Thesis Advisor: Second Reader: fi-yr n Eberling Airr l 43 m te- 049 Unclassified SECURITY CLASSiICATION OF TRIS PAGE REPORT DOCUMENTATION PAGE la REOR SEUIYCASFCTO b RESTRICTIVE MARKINGS 3 DISTRIBUTION; AVAILAILITY 01- REPORT 2a. SECURITY CLASSIFICATION AUTHORITh IForm Approved OMBNci. 0704.0188 2bDECLASSFICATION 2b DWNGADIG SHEDLEDistribution ECLSSIICAION Approved for public release-;__DOWNGRADIGSCHEDUL is unlimited, 5 MONITORING ORGANIZATION REPORT NIMBER(S) 4 PERFORMING ORGANIZATION REPORT NUMBER(S) 6a NAME OF PERFORMING ORGANIZATION Naval Postgraduat e School f(if j 6b OFFICE SYMBOL '7a, NAME OF MONITORING ORGANIZATION Naval__Postgraduate___School applicable) NalPotrdteShl __ 361 6c. ADDRESf (Ct), State, and ZIP Code) 7b ADDRESS (City, State, and ZIP Code) Monterey, Ca. 93943-5000 6a NA~ME OF ;W'.DINGI-SPONSORNIC ORGANIZATION -8c ADDRESS(Cit, Bb 0--FIC, SYMBO, Monterey, Ca. 93943-5000 0 applicaole)INS-TU (if 9 PROC ,REMET NSTUET-N~jAO ETDNi!C 10 SO,CE PROGRAM, CF FUNDING NUMBERS PROJECT ~ME ,fIBZ StaeadZICdr ELEMENT NO NO ITASK NO __v"ORW UtiiT ACCESSiONI NO IiT.TLE (include...

Words: 7527 - Pages: 31

Free Essay

Wal-Mart's Purchasing Process

...AC 550 Accounting Information Systems Date: October 10, 2011 Introduction Wal-Mart was founded by Sam Walton in 1962 with the first Wal-Mart discount store opening in Rogers, Arkansas. The company was officially incorporated as Wal-Mart Stores Inc. on October 31, 1969. Currently, Wal-Mart has stores in 50 states in America and 15 countries worldwide, including Argentina, Brazil, Canada, Chile, Costa Rica, El Salvador, Guatemala, Honduras, India, Japan, Mexico, Nicaragua, Puerto Rico, and the United Kingdom. The growth of Wal-Mart over a period of 49 years is remarkable and has lead Wal-Mart to become the biggest retailer in the world. Wal-Mart also has a strong community presence in the areas the stores are located. Wal-Mart’s purpose is to save people money and to help them live better. In 2007, Wal-Mart changed its slogan from “Always low prices” to “Save money. Live better.” This slogan is demonstrated in the products that Wal-Mart sells. Wal-Mart will not be undersold. Wal-Mart caters to the low income and middle income people by offering goods at low prices. These low prices are demonstrated in the products Wal-Mart sells. The products include: food, drink, clothing, jewelry, electronics, automobile supplies, sporting goods, toys, and furniture. Basically, Wal-Mart offers customers a one stop shopping experience. In order to provide this variety of goods to customers at the lowest price, Wal-Mart sets up a huge supply system worldwide and has evolved into...

Words: 5069 - Pages: 21

Premium Essay

Accounts Computers in Acounting

...applications became main stream, this keeping of the books Accountants do, has gradually migrated into computerized spreadsheets. Gradually, Accounting systems dedicated to this function were developed and the term Computerized Accounting was born ADVANTAGES * Faster and efficient in processing of information; * Automatic generation of accounting documents like invoices, cheques and statement of account; * With the larger reductions in the cost of hardware and software and availability of user-friendly accounting software package, it is relatively cheaper like maintaining a manual accounting system; * More timely information can be produced; * No more manual processing of the data- all automatically been posted to the various ledgers/accounts and * Many types of useful reports can be generated for management to make decisions 12.3 NEED AND REQUIREMENTS OF COMPUTERSIED ACCOUNTING The need for computerised accounting arises from advantages of speed, accuracy and lower cost of handling the business transactions. l Numerous Transactions The computerised accounting system is capable of handling large number of transactions with speed and accuracy. l Instant Reporting The computerised accounting system is capable of offering quick and quality reporting because of its speed and accuracy. l Reduction in paper work A manual accounting system requires large physical storage space to keep accounting records/books and vouchers/ documents. The requirement...

Words: 1703 - Pages: 7

Premium Essay

Accounting Cycle

...ensure the accuracy and conformity of financial statements to GAAP. This set of procedures includes: (1) identifying and measuring transactions; (2) journalizing; (3) posting; (4) preparing an unadjusted trial balance; (5) making adjusting entries; (6) preparing an adjusted trial balance; (7) preparing financial statements; and (8) closing (Kieso, Weygandt, & Warfield, 2012) . This paper will summarize the overall accounting cycle for the inventory department at Sunrise Growers. Nowadays with the help of computerized accounting system, mathematical errors have been reduced tremendously when recording accounting transactions. In addition, computerized accounting system has minimized the workload and increased productivity. Although Sunrise Growers uses a computerized accounting system to record transactions, this paper will assume the accounting cycle done is manually. Identifying and Measuring transactions This step is to analyze the transactions and determine what to record. On October 10, Sunrise Growers purchases $50,000 worth of inventory from company A on account. This is an external event which describes “external events involve interaction between an entity and its environment, such as a transaction with another entity, a change in the price of a good or service that an entity buys or sells...” (Kieso, Weygandt, & Warfield, 2012). The word ‘on account’ means that it is to pay on a...

Words: 1126 - Pages: 5

Free Essay

Quantitative Reasoning for Business Week 2

...Inventory Systems Summary Christine Burns, Felicia Cobbs, Carolina Martinez, Paula Williams QRB 501 Quantitative Reasoning for Business Professor Jim Easley April 25, 2012 Inventory Systems Summary The team will introduce several factors to summarize the functions descriptions and the advantages and disadvantages of inventory systems. The descriptions of inventory systems will show how one relates to many organizations. The advantages and disadvantages will show collaboration from the team of how the inventory systems can give a good cause or show the effects as a setback. Warehouse Inventory System Transferring information inventory can be used by a public school district or a university as a barcode to scan physical records of information from a particular inventory. This process can be done as a third party software to download a particular file which holds information in inventory from one`s personal computer to a high performance data system (Ruiz-Torres, Mahmoodi, 2010). Transferring barcode data from one file to another is called warehouse inventory physical file. This process has to be done by ensuring to upload data, which is scanned from one computer to the high compatible system. Physically entering inventory allows company data history for stored input. The process involves entering information in the district demonstration field of system. The stock item of quantity has to be entered with capability of information to be displayed. The advantage...

Words: 1501 - Pages: 7

Premium Essay

Inventory System

...located in Pulang Lupa, Las Piňas and Marikina. The advent of new technology, most company nowadays is using computers in their transactions. Pharmacies in particular, are now making their systems computerized since that helps them minimize the time and efforts consumed by using manual system. Point-of-Sale Inventory System is one of the essential components of a successful business. It is a modern replacement for cash register in retail applications. It can help to record securely all the sales and customer’s orders and track products. A sale refers to the exchange of product or services for an amount of money or its equivalent while inventory, on the other hand, is the total amount of items and the act of counting them. A pharmacy owner must know the precise number of items in their storage areas in order to place orders and control losses up to date. Hence, computerizing both Sales and Inventory System will make an easier and faster transaction among the customers as well as monitoring the stocks of the products. Furthermore, the system also gives the person up-to-the-minute and detailed information on each item in your inventory. He/she will know exactly how much inventory comes in; is on-hand now, and where it goes. In fact, most entrepreneurs these days find that computerizing a system gives them a far wider range of information with less effort....

Words: 16309 - Pages: 66

Free Essay

Event & Facility Management

...& Facility Management Ch. 9 case study Mrs. Etzkorn CMMS is an abbreviated term for computerized maintenance management systems and are a type of management software program that perform functions in support of the operations and maintenance (O&M) programs. The software automates and streamlines most of the logistical functions done by O&M staff (U.S. Department of Energy). “Typical CMMS functions depend on the complexity of the system chosen. Examples include: * Work order generation, prioritization, and tracking by equipment and/or component. Work orders often can be sorted by equipment, date, person responding, etc. * Tracking scheduled and unscheduled maintenance activities. * Storing technical documentation and maintenance procedures by component, as well as equipment warranty information. * Real-time reports of ongoing work activity. * Calendar- or run-time-based preventive maintenance work order generation. * Capital and labor cost tracking by component, as well as shortest, median, and longest times to close a work order by component. * Complete parts and materials inventory control with automated reorder capability” (U.S. Department of Energy). The best CMMS benefit is that it eliminates paperwork and manual tracking of activities and saves time and allows the staff to remain productive. Computerized maintenance management system would allow the school to detect problems before a failure occurs, resulting in fewer failures...

Words: 724 - Pages: 3

Premium Essay

Project Management Final Paper

...Pizzaderia Inventory Management System 1.2 Project Context On March 27, 2007, the friends and neighbors of Alberto Biaño in Cebu City were treated to the first serving of Mr. Biaño's famous pizza.  This core group became his first loyal customers, as news spread far and wide of the pizza with the great homemade taste that everyone could afford.  Inspired by the resounding success of his initial offering, Alberto Biaño continued to develop his recipes to improve his pizzas' quality and taste until a perfect blend of crispy dough and aromatic sauce was achieved for everyone to enjoy. Another innovation was the concept of the “pizzaderia”, which  combined the words “pizza” and “carenderia”, to describe the little streetside eateries where Biaño’’s delicious but affordable pizzas were enjoyed by  people from all walks of life. Whether for birthdays, anniversaries, celebrations and get-togethers, everyone wanted to make a Biaño’s pizza part of their special treat. From that little pizzaderia in Mabolo, Mr. Biaño soon branched out to Capitol, Tabunok, USC Main, Mandaue and Mactan, making Biaño's pizza a truly well-loved snack in Cebu.  Realizing the potential for such great value in an affordable price, many franchisers from different places all over the country such as Cagayan de Oro, Oroquieta City, Butuan soon became part of the Biaño's Pizzaderia family 1.3 Statement of the Problem As of now, Biano’s Pizzaderia only does their inventory manually, and as manual inventory system...

Words: 3731 - Pages: 15

Premium Essay

Lala

...------------------------------------------------- ------------------------------------------------- ------------------------------------------------- ------------------------------------------------- In Partial Fulfillment To the Requirements in Technical Documentation ------------------------------------------------- Submitted to Associate Professor Domingo, Vivien, DBA Submitted by Edward A. Almerol Zharmaine C. Cruz July 14, 2014 Part 1 PROPOSAL SUMMARY * BS1 General Ledger * Keywords General Ledger System, Income Statement, Balance Sheet, Trial Balance Report, General Ledger Report. * Abstract The General Ledger has been the basic bookkeeping tool of double-entry accounting since the Green Eyeshade days. It records financial transactions as both Credits and Debits in balance sheets, which before the advent of software were bound together in huge volumes like something out of a Dickens novel. BS1 General Ledger from Davis Business Systems brings the General Ledger up to cyber speed with a variety of easy-to-use accounting tools that can track budgets and financial data and generate income statements, balance sheets, and other reports. It's freeware, a good start, accountancy-wise. BS1 General Ledger proves just how much high-quality business software is available for free, though it's also available in a paid version that adds technical support and free updates. However, many businesspeople, entrepreneurs, treasurers, and others will appreciate what...

Words: 3603 - Pages: 15

Premium Essay

Goodner Brothers, Inc. Internal Control Issues

...padlock and other some security are used as a physical protection of Goodner’s inventory from stolen by unauthorized person. 2. Authorization of Transaction       Goodner’s policy said that the new customer required an approval of the sale manager for the credit sale. The objective of this policy is to control the authorization of employee by using an approval from the senior manager to determine the credit term of new customer. 3. Top-level reviews       Annual review by the internal audit is used in order to inspire the operation and compare the performance with a plan of the business, so that the company can find out that there are any problems or fraud or not. 4. Human Resource Policies and Practices Goodner’s policy about hiring an employee is relied on honesty and integrity of the employee which is required 3 strong as references and preferably from reputable individual with some connection to Goodner Brother. 5. Adequate Document and Records The computerized accounting system is used at each Goodner sales outlet. The system will record the sale and purchase transactions which were recorded by the bookkeeper and sales representative. So the company can record all transaction from each sale outlet. 2. List the key internal control weaknesses that were evident in the Huntington unit’s operations. Internal control weaknesses: 1. Unrestricted access to the accounting system, cause the large volume of sales and purchase transaction often swamped (possible...

Words: 1499 - Pages: 6

Premium Essay

Database Environment

...traced as far back as the mid-19th century. The number 146, located on the face of the painting, appeared to be an inventory number (the Getty Research Institute, 2012). A search in the Provenance Index's Archival Inventories database retrieved a single record in which the artist name (Rubens) and item number (146) matched. The search lead to a 1651 inventory preserved in the Archivo de la Casa de Alba, Palacio de Liria in Madrid, which lists this Rubens painting. Possibly its first owner was Gaspar de Haro y Guzmán Carpio (1629–1687)”. Other Institutions are not as lucky some. Some Museums are not so fortunate to find the item number associated with the picture. When it is time to introduce the collections into a database, curators of small museums find themselves in a little bit of trouble. The features and capabilities offered by the newer commercial and professional collection systems are more than they will ever need, more than they can support and more than they can afford all together. Their own database management skills may not be up to par to address their problems effectively. Discussions of databases for small collections barely focus on building data systems. Database management tools that are successful in business may not be successful for a museum. Structures, internal controls, and strategies that are useful for building small systems...

Words: 1164 - Pages: 5