Preview

Sad Inventory System (Gilmore Wines and Spirits)

Good Essays
Open Document
Open Document
3865 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sad Inventory System (Gilmore Wines and Spirits)
THE PROBLEM AND ITS BACKGROUND I. Introduction This study shall focus on how to improve the system of records for the inventory and sales of the company. This may help in creating a better system to avoid mistakes in recording data that may contribute to loss of income. The study shall provide us an opportunity to experience on how to handle similar problems and to create a solution for future companies. Gilmore Wines and Spirits, was founded by Messrs. Magnus Villafuerte and Marcus Morales. The business started about 3 years ago in the present location which serves as a showroom. Initially, they were only selling wines but through a program in De La Salle University, they were able to get funds and expand the business which now includes a wide variety of beer. In the first few weeks of operation, income was low since costumers are only limited. Very few knew that it was a liquor store and already open for business.

It is their goal to deliver a wide variety of beer in the Philippines since the local market in ruled by San Miguel which produces limited variety. It is their passion for beer that is driving them to push on and proceed to share their knowledge about unique beers from around the world.

1
COMPANY ORGANIZATIONAL CHART
HEAD
HEAD

ALL- AROUND
STAFF

ALL- AROUND
STAFF

ALL- AROUND
STAFF

ALL- AROUND
STAFF

ALL- AROUND
STAFF

ALL- AROUND
STAFF

Figure 1: Organizational Chart

The two heads, Messrs. Villafuerte and Morales, share the 6 employees. The employees have no specific position since the heads believe in equal distribution of responsibilities among employees. Each employee is authorized to do any task that is available, e.g., as a cashier or updating the records of the inventory.

The problem of their business is the recoding of sales and inventory. They are currently using manual labor in recoding product transactions and in listing stocks that c are delivered in the store. The business is in

You May Also Find These Documents Helpful

  • Good Essays

    Gordon Biersch Case Study

    • 5471 Words
    • 22 Pages

    The masterminds behind Gordon Biersch were two individuals, Dan Gordon; a qualified brewing engineer from the esteemed University of Munich, Germany, and Dean Biersch; who had a passion for food service and a vast experience in the food and beverage sector. Their unique idea of a microbrewery and fine dining restaurant stemmed from a law amendment of California in 1983 which allowed brewing and serving of beer in the same locale. They envisioned the concept of providing high quality fine dining with outstanding service in an attractive ambiance featuring exceptional German-style lagers in on-site breweries. Their target market was the fairly sophisticated, yet not so young natives of Palo Alto as well as the Stanford University faculty, staff and graduate student body.…

    • 5471 Words
    • 22 Pages
    Good Essays
  • Good Essays

    Paper

    • 552 Words
    • 3 Pages

    Kudler Fine Foods business thrives on quality of inventory product. It is essential to establish the proper guidelines to track and store inventory. If not followed properly Kudler's Food can be tainted and perish away in storage. Kudler's Fine Food can't allow this process to be overlook and infect the Fine Food Brand. This paper will evaluate the design elements from an accounting perspective of the data tables. With the existing data tables a entity relationship diagram will be illustrated. Also, recommendations will be addressed to improve the data tables. Finally, an example pivot table will be demonstrated to help improve decision making for management.…

    • 552 Words
    • 3 Pages
    Good Essays
  • Good Essays

    With any database design infrastructure data tables will provide the accounting elements to evaluate the accounting viewpoint. For Kudler to have success, information provided by the analysis of the data tables will determine how much inventory should be available and to establish a restocking point for the end user. Database design will look at certain aspects of the companies financial data that will be tracked by department, general ledger code, items, location, and transaction totals. Kudler’s objective is to maximize the presentation of financial data that can be visualized by the company and consumers. The use of data tables to store information if created properly can give the user information that can be useful to determine certain cost related to location, department, and inventory items. Inventory can be accounted by presenting the cost of the item, on hand quantity, and calculating average cost.…

    • 762 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Inventory often is one of the largest amounts listed under assets on the balance sheet which means that it represents a significant amount of the resources available to the business. The inventory may be excessive in amount, which is a needless waste of resources; alternatively it may be too low, which may result in lost sales. Therefore, for internal users inventory control is very important. On the income statement, inventory exerts a direct impact on the amount of income. Therefore, statement users are interested particularly in the amount of this effect and the way in which inventory is measured. Because of its impact on both the balance sheet and the income statement, it is of particular interest to all statement users.…

    • 10337 Words
    • 42 Pages
    Powerful Essays
  • Better Essays

    Yuengling

    • 2372 Words
    • 6 Pages

    Now this craft beer company started off slow. The first year of production yielded only 600 barrels. Once the owners’ son stepped up and took ownership of the business, he slowly made it into what it is known as today, America’s best-selling craft beer brand.…

    • 2372 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Inventory Turnover

    • 1081 Words
    • 5 Pages

    Inventory turnover is considered a key measure of management efficiency. It is a measure of how often, during a course of a year, a company sells and replaces its inventory of component parts, materials and final products. As a general rule, the higher the inventory turnover rate the better it’s for the business. For Kudler Fine Foods the perished goods used in their stores had a high inventory turnover. Management makes sure to monitor all products, to make sure that all unsalable products were pulled from the shelves. The problem affecting kundler foods was that Kathy was the only appoint person to order their inventory, in her absence the company can suffered from managing their inventory. In the vision of keeping all goods fresh, inventory accounting can play a big factor in the company’s success. Inventory is a current asset on the balance sheet, therefore inventory’s valuation can directly affect kundler foods total current asset and in general their total asset balances. A company’s inventory valuation can cause a ripple effect throughout its financial picture.…

    • 1081 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Robin Hood Case Study

    • 1645 Words
    • 6 Pages

    1) What are the goals and objectives of Robin Hood and his band? What is it that they are trying to accomplish?…

    • 1645 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Since 1925, this traditional and regional family owned brewery has cultivated its brand loyalty by sticking to its core customer base, offering to them an attractive product and offering them a brand building product with great price, tradition, local authenticity, quality, and a unique taste.…

    • 1842 Words
    • 8 Pages
    Powerful Essays
  • Better Essays

    Corporate Sales Paper

    • 3277 Words
    • 14 Pages

    Hops & Grain is a local brewery located in the historic East 6th street district of Austin, Texas. We pride ourself in providing our hometown with quality craft beers that embrace the local characteristics, personalities, and values of the community with every sip; We are the representation of what this city is all about. In every sip our customers taste the fresh and natural ingredients that fill their cans or glass.…

    • 3277 Words
    • 14 Pages
    Better Essays
  • Good Essays

    Wolfgang Keller

    • 656 Words
    • 3 Pages

    The industry is a very challenging environment as the company produces premium beers and the local people are accustomed to vodka and low-end or home-made beers. The company had to adopt strategies which focused on distributors who have the power to reach the direct consumer outlets and influence major portion of the sales. And hence it requires the company sales persons and officials to have good personal contacts with the distributors and have more informal gatherings.…

    • 656 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    RLM Drugstore, using manual system according to our interview to the owner of the drugstore, they cannot specify the exact amount of sales and item sold, they have complications on sales and Inventory due to human errors and also laboriousness and time consuming when it comes to generating sales and inventory reports, for obvious reasons that it is done manually. Manual inventory systems turned out to be slow and inaccurate resulting to problems like running out of stocks and slow computations of product prices being bought by the customers. List of files, and papers in these files are difficult to document and maintain, thus prone to risk of loss or damage, making the system inefficient. The owner of RLM Drugstore want a computerized system to hasten their work for the inventory, so the developer makes computerized sales and inventory system to solve the problem of RLM Drugstore. The degree of success of a business greatly depends upon controlling the merchandise inventory.…

    • 501 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    project

    • 557 Words
    • 3 Pages

    Hotel ORGANIZATION CHART FINANCE & ACCOUNTING CONTROLLER ASST. FINANCIAL CONTROLLER EDP MANAGER ASST. EDP MANAGER GENERAL LEDGER GENERAL CASHIER CASHIER SUPERVISOR OUTLET CASHIER ACCT. PAYABLE PURCHASING MANAGER ACCOUNTING SUPERVISOR INCOME AUDITOR COST CONTROL NIGHT AUDITOR F&B CONTROLLER STOREMAN RECEIVER Bali Hospitality Professional Service www.balihospitalityservices.webs.com F&A CONTROLLER SECRETARY CREDIT SUPERVISOR A/R CLERK PURCASING CLERK BUYER Hotel ORGANIZATION CHART CHIEF ENGINEERING ASST.…

    • 557 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Thesis.

    • 795 Words
    • 4 Pages

    Established in 1890, La Frabica de Cervza de San Miguel Southeast Asia’s first brewery produced and bottled what would eventually become one of the best-selling beers in the region within the span of generation, San Miguel Beer would become an icon among beer drinkers – 120 years after its founding, nine out of ten Filipino drinkers are still reaching for the company’s flagship product. Yet, San Miguel has never been limited by its origins, successfully expanding its reach well beyond the beer industry.…

    • 795 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The sales record of the company are maintained and reviewed weekly with the sales manager while the production and inventory figures are not reviewed perfectly. The stock taking is done periodically not at the year end. When the final account of the company is prepared the accounts department of the company is not able to record the true value of the stock. Due to this the financial statements of the company does not represent the true picture of the firm.…

    • 1978 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Inventory

    • 574 Words
    • 3 Pages

    The business thought of expanding their company’s operation by using a computer system that will assist the owner in transaction of the businesses. For the past years to present, the business is using manual type of system in recording, transactions, and preparing the sales report.…

    • 574 Words
    • 3 Pages
    Good Essays