Premium Essay

Kudler Foods Data Tables

In: Business and Management

Submitted By nsinger
Words 599
Pages 3
Kudler Foods Data Tables Kudler Fine Foods was founded in 1998 by Kathy Kudler as an upscale specialty food store. The first location of Kudler was in La Jolla, CA, followed by stores opened in Del Mar and Encinitas. Kudler Fine Foods offers its customers selections in bakery and pastry products, fresh produce, fresh meat and seafood, condiments and packaged foods, as well as cheese and specialty dairy products. This brief will evaluate the design of Kudler’s current inventory data table, make recommendations for improvements to the current tables, and provide information for effectively using pivot tables.
Design Element Evaluation Analysis of Kudler’s data tables by end users is essential to Kudler’s inventory control. End users should be able to use inventory data tables to determine the amount of inventory on hand in each location, which in turn will assist end users in determining the amount of inventory to be ordered to replenish each location. Kudler’s current inventory data table provides its end users with general ledger coding, inventory items, store locations and departments, and the value of each inventory on hand. Users of Kudler’s current inventory data table are able to quickly identify the products store location and department by viewing the general ledger code. The first two numbers of the general ledger code indicate the store location of the inventory, while the third number indicates the department the inventory belongs to, and the last two numbers indicate the product.
Entity Relationship Diagram Entity relationship diagrams use four symbols to graphically depict entities and their direct relationships. Bagranoff, Simkin, & Strand further explain the four symbols, stating that rectangles represent entities, diamonds describe the nature of relationships, ovals denote the entity’s attributes, and connecting lines depict...

Similar Documents

Free Essay

Internal Controls

...Kudler Fine Foods: Internal Control and Risk Evaluation Latrice L. Alston ACC 542 Eva King March 3, 2013 Kudler Fine Foods: Internal Control and Risk Evaluation Kathy Kudler founded Kudler Fine Foods in 1998 with a vision to offer customers gourmet products at reasonable prices. As the business has grown, the need to evaluate internal processes and procedures has become increasingly more important. Kudler Fine Foods with three locations in California is faced with increasing productivity while controlling costs internally. In short, Kudler Foods has to manage costs and use technology to aid in the process of streamlining operations in all locations. The purpose of this analysis is to provide a clear and concise analysis of the method Kudler Fine Foods is currently using and offer recommendations to improve efficiency by capturing important data rather than extemporaneous data. Specifically, the current system used by Kudler Fine Foods does little to provide a true picture of inventory sources and the effect of the data on Kudler Fine Foods bottom line.       The current data table found on Kudler Fine Foods Finance & Accounting tab simply lists GL codes, products, and cost. While this information provides basic information regarding inventory and costs, the data table does not break out for users of the data comparable data to make decisions regarding inventory. One benefit of the data table currently used is that it......

Words: 607 - Pages: 3

Premium Essay

Data Table Analysis

...Data Table Analysis Sonya Cunningham University Of Phoenix Accounting Information System ACC/542 Eva King May 25, 2015 Data Table Analysis Kudler Fine Foods, established in 1998 is a specialty food store. The products at Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design elements of the data tables from an accounting perspective, recommend improvements to the data tables and explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data. It will also include an entity relationship diagram illustrating the existing data tables and a pivot table on Kudler inventory data from the company intranet. Evaluation of the design elements of the data tables from an accounting perspective Data Table is very basic but yet play a very big role in the achievement of Kudler Fine food. The company uses this data to decide when to order more inventory and also to manage inventory. The design of data tables categorizes the financial information into financial codes, items, department and the sums of total amount of transaction. It contains four columns: the GL Code, Inventory Item, Summary Line Item, and Amount. The GL codes consist of six numbers. The first two are store numbers and the last four numbers represent the department the item is......

Words: 769 - Pages: 4

Premium Essay

Data Analysis

...Data Table Analysis LeKane Gilling ACC/542 March 13, 2014 Brad Thompson Abstract In this brief, data tables will be analyzed because it can be critical to the accounting cycle. With accurate data that is informing, Kudler Fine Foods ought to be able to make more practical business decisions. With Kudler Fine Foods using data table to order, keep inventory, and to process their products, they can become more successful and on top of the food industry. As a company, Kudler needs to evaluate their design elements of the data tables that are needed for review from an accounting perspective. An entity relationship program would need to be developed showing the past data tables. A recommendation would need to be met for improvements or changes. With providing vital information in the pivot tables, then this will improve making decisions for every department at Kudler Fine Foods. By creating a pivot table that shows everything in a list, this will possibly help management see where items need to either increase or decrease because they're not selling. Data Table Analysis Kudler Fine Foods are a part of a broad spectrum of prestigious locations that are becoming successful. La Jolla, Del Mar, and Encinitas are the three stores that Kudler has opened, all located in California. The products range from fresh bread, harvest, meat and poultry, flavorings and packeted foods, and special milk and cheese products. Since 1998, Kudler’s goal is to supply the consumers carefully......

Words: 1218 - Pages: 5

Free Essay

Data Table Analysis

...Data Table Analysis University of Phoenix Accounting Information Systems ACC/542 Anita Rodriguez April 2, 2012 Data Table Analysis Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process. Evaluate the design elements of the data tables from an accounting perspective The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table......

Words: 903 - Pages: 4

Premium Essay

Kudler

...Kudler Fine Foods Introduction Kudler Fine Foods has reviewed a significant growth in business. Expansion has been discussed on implementing services, increasing consumer purchase cycle and furthering efficiency of Kudler Fine Foods operations. Kudler Fine Foods strategic objective is to increase loyalty and profitability from customers. Customer’s purchases will be tracked through a Frequent Shopper Program using a point-of-sale (POS). The program will keep track of an individual customer’s purchase or purchases and provide high end incentives through a partnership with a loyalty points program (Kudler Fine Foods, 2009). Kudler’s partnership with a loyalty points program will provide customers with a points program where the customer can redeem points for high-end gift items, specialty foods and first-class airline upgrades (Kudler Fine Foods, 2009). Team A has been invited to create a business/systems requirement document to initiate the development of the Frequent Shopper Program. Team A will outline in the following document Team A’s proposed plan in meeting the objective of the aforementioned request. Executive Summary ------------------------------------------------- Kathy Kudler’s vision became a reality in 1998 when she opened her first store in La Jolla, California. Gourmet cooking coupled with efficient food preparation was the cornerstone of the La Jolla store (Apollo, 2008). Kudler’s has expanded with the opening of the Del Mar location and with Kudler’s......

Words: 1257 - Pages: 6

Premium Essay

Kudler Fine Foods

...Kudler Fine Foods BSA310 April 15, 2012 Kudler Fine Foods Kudler Fine Foods is an upscale specialty food store based in the San Diego area. There are three locations and each carries a variety of domestic and imported products, such as pastries, produce, meat, seafood, cheese, dairy, and packaged foods. Kudler’s keeps a database that is critical to the business processes of the company. In addition to the details kept about customer orders and demographics, information is catalogued for inventory, purchase orders, suppliers, and taxes. This enables a manager to quickly and accurately see what is happening and make appropriate decisions. These decisions include making timely orders from suppliers and keeping proper staffing levels at each location to ensure excellent customer service. The Customer Table contains data about customers to streamline the ordering process and helps with addresses and dates for special mailings. This simple tool allows Kudler’s to provide a personal touch along with better service. The Inventory Table determines available ingredients that make up an Item. For example, it is important for a baker to know how much flour he has in stock so that he/she can order more from a supplier before it runs out so that the company is always producing a product for the customer to buy. The Item Table lists all the finished goods that can be purchased from a particular store. Managers can make decisions about which......

Words: 1205 - Pages: 5

Premium Essay

Bsa 310 Critical Information System Paper

...Walker Critical Information System Kudler Fine Foods is a local gourmet grocery store located in San Diego, with three locations. All the stores carry the very best domestic and imported goods. Kathy Kudler, Owner of Kudler Fine Foods, opened the first of three stores in 1998. In the year 2000, Kathy opened a second store with the third store opening in 2003 (Kudler Virtual Organization, 2006). Kudler Fine Foods utilizes an information technology system that is vital to its business. The company uses the POS (Point of Sales) Database System to organize and keep track of items and orders. Without this, they would not be as successful as they are. Point of Sales System Databases keeps track of inventory, supplier, order, customer, store, tender (sales), tax table, order line, and item. A successful business cannot function accurately without all these tables. The Inventory Table contains the components that make up an item. Such as, perishable indicator, quantity on hand, and unit cost. It is also “used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, ect” (Kudler Virtual Organization, 2006). “The Supplier Table data concerning wholesalers, vendors and other suppliers from whom inventory is procured” (Kudler Virtual Organization, 2006). Meaning, depending on the inventory, which is going to determine who the supplier is going to be in general. Under Order Table, it is used to record information......

Words: 546 - Pages: 3

Premium Essay

Data Table Analysis

...Data Table Analysis Crystal Spencer ACC/542 February 27, 2012 Christy Countryman Kudler Fine Food is the fast growing fine food specialty business that was established in 1998, and at each of their stores the company first initially selected Microsoft Access as their AIS to track employees, customer, inventory, orders, and sales. Kudler’s products have perishable inventory that must be properly tracked. This brief will evaluate database tables from an accounting perspective. In addition, gives recommendations for improvement, pivot table, and entity relationship diagram will help the company have a better decision-making process. Assessment of the design elements of the data tables from an accounting perspective. Data Table analysis is vital to the success of the business, the data given in these tables is available for the end user to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables will arranges the financial data into department, financial codes, items, and sums of total amount of transaction. Data table get the most out of the informational and visual presentation for the financial data. The user of the data can easily to identify the item belongs to certain department and how many items were received at the given cost for a certain period. In addition, the data allows in finding quantity and total amount on hand for an item and calculating average price of the item. ...

Words: 874 - Pages: 4

Premium Essay

Kindler Fine Foods

...Kudler Fine Foods Misty Robinson MMPBL/502-Managing the Business Enterprise Abstract Kudler Fine Foods is an upscale food store in the San Diego metropolitan area, specializing in fine foods and wines. This paper will explore the primary functions of management and who is responsible for each function. Also, how Kudler Fine Foods is utilizing the use of technology and the internet within the organization. Table of Contents Introduction…………………………………………………………………………………….. 4 Primary Functions of Management at Kudler Fine Foods……………………………………... 4 The Use of Technology and the Internet……………………………………………………….. 5 Five Forces – Porter’s Model……………………………………………………………………6 Conclusion……………………………………………………………………………………….7 References……………………………………………………………………………………….8 Kudler Fine Foods Introduction Kathy Kudler, founder of Kudler Fine Foods, has a passion for gourmet cooking, which requires the use of gourmet ingredients. She was often tasked in finding the ingredients she needed to prepare the gourmet meals she desired. While out shopping one day she realized there was a great demand for a fine food store, one that could offer the finest ingredients and other specialty items at a reasonable price. Kathy had a vision; it was then that the first Kudler Fine Foods was opened in 1998. The store is driven by its mission statement – “our selections, coupled with our experienced, helpful and knowledgeable staff, merge to offer each customer a delightful and pleasing......

Words: 1337 - Pages: 6

Premium Essay

System Integrity and Validation

...August 11, 2014 Irene Branum Preface Kudler Fine Foods began operations in 1998, by Kathy Kudler; the company has grown from one store to three and aspirations to add more locations in the near future. Our company was hired to analyze Kudler’s future accounting technology needs. We recommended a system to automate the accounting functions of accounts payable, accounts receivable, inventory, and payroll. We concluded that upgrading its accounting information system with retail-specific software instead of custom written software would be best for Kudler Foods. We have assessed the design basics of the data tables from an accounting perspective; recommend improvement to the data tables, and clarified how the information in the pivot table advanced decision-making for management The pivot table made from the information extracted from Kudlers inventory report for year-end will improve the decision-making process of inventory to be purchased by store location and by product type. We have analyzed the risk associated with the Accounting Information System in the areas of accounts payable, accounts receivable, inventory, and payroll, identified all risks and internal control points, incorporated the controls and risks into flowcharts, designed internal controls to mitigate risks to the systems, evaluated the application of internal controls to the systems, and discussed other controls, outside the system that Kudler Fine Foods may need. Kudler’s......

Words: 1148 - Pages: 5

Premium Essay

Bsa/310 Kudler Loyalty Program

...Kudler Loyalty Program Adam Love BSA/310 5/30/2011 Deborah Marshall Kudler Loyalty Program Kudler Fine Foods is a well-known California grocer specializing in high quality and specialty foods. Since Kudler does not consider the price of its products to be a primary differentiator from other grocers their intent is to produce more profit through increasing their customer purchase cycle. To achieve their goal Kudler has partnered with a loyalty points program to provide customers with points which can be redeemed for high end gift items, airline first-class upgrades, or other specialty foods. This program will also enable the ability to track customer transactions and identify trends that will allow Kudler Fine Foods to customize its product base to better serve its customers. Before implementing this program, Kudler will need to identify legal, ethical, and security considerations as well as complete a financial analysis to justify the expenditures of the loyalty program. The Program According to Kudler Fine Food’s Sales & Marketing intranet website, customers prefer high quality and specialty foods are more important than high value prices. Kudler’s Sales and Marketing Department is developing a Frequent Shopper Program which will offer incentives to its members through point accumulation and offer Kudler valuable insight into the shopping tendencies of customers. Initially, this program should promote customer loyalty and give Kudler...

Words: 1159 - Pages: 5

Premium Essay

Data Analysis

...Data Table Analysis ACC/542 Data Table Analysis Kuder Fine Foods design elements table shows the different tables that are used to determine information. The breakout and design of the table is straight forward and provides what exactly is under each category. The customer information is very detailed and some other categories could be combined. Inventory and item could be combined since they both will provide some same information. Depending on the item that customers like can depend on the inventory amount on hand. Order and order line can also be combined in one and just add additional field where needed. The design of the access table can provide very detail information regarding inventory and items needed for each store. Combining some of the columns can help to formulize the information more and give a better results for the company to use for growth and revenue. Access Table Analysis Inventory is the key to Kudler Fine Foods business. The inventory stock has to stay stocked for the business to make profit. Having the right suppliers will make sure inventory is received in a timely manner. Cost reduction regarding how much is paid out to suppliers is important because it more cost is going to supplier, then what is sold there is an issue. Kudler Fine Foods should look into combining their stores to have one supplier. Management or owner should look into products and quantity on hand to determine their stock. Having a description of each item and supplier......

Words: 779 - Pages: 4

Free Essay

Cmgt 400 Week 2 Team

...Kudler Fine Foods IT Security Report Kudler Fine Foods is an upscale specialty food store with the very best domestic and imported fare at every location. In keeping with their motto, “Shopping the World for The Finest Food”, Kudler Fine Foods shops the world in order to provides the very best Baked and pastry products, fresh meat and seafood, fresh produce, cheese and specialty dairy products, wines, and condiments and packaged foods. Kudler Fine Foods brings those food items back to their loyal customers in the San Diego metropolitan are. Kudler Fine Foods has stores in Del Mar, La Jolla, and Encinitas. Their mission is to offer their customers a delightful and pleasing shopping experience by employing experienced, helpful, and knowledgably staff, coupled with their selection of fine foods. Background Customer rewards programs and the like have become commonplace in many small and large retail market places. Kudler Fine Foods understands the benefits these programs offer. Customer rewards programs are electronic records management (ERM) systems that collect and store customer sales transaction information in databases from which reports can be queried. Kudler Fine Foods plans to develop the RMS, but needs help from Learning Team “A” to manage security concerns during the system development life cycle (SDLC) in order to safeguard data stored as customer information within the newly implemented system as prescribed by the Federal Trade Commission (FTC). The FTC is......

Words: 1352 - Pages: 6

Premium Essay

Business

...Kudler Fine Foods Frequent Shopper Program Team A BSA/375 February 28, 2012 Name Frequent Shopper Program Statement of Scope and Goals The goal for this Service Request is to design a fully integrated rewards program, thus the Frequent Shopper Program. This program will help track customer purchases and reward the consumers in loyalty points. These loyalty points can be redeemed at any time toward the rewards program products and services. Kudler will benefit by being able to track the items most commonly purchased by consumers. Furthermore, Kudler can develop reports that illustrate what is most popular based on the season, time of day, and with current trends in the market. With this newly acquired material, Kudler to have certain specials for the products to reward their loyal consumers. To ensure Kudler’s Frequent Shopper Program is successful, Kudler will need to keep its competitive edge by remaining current in the market and current trends. In addition to conduction market research, Kudler will need to consistently strive to provide exceptional service at all times, along with the best values in town. Consumers are always looking for the store that has the best deals with the best service. By providing deals on items personally geared at a particular consumer based on their previous purchases will make the shopping experience more personal and catered toward the customers individual needs. Advertising is also a large contributor in how......

Words: 1228 - Pages: 5

Premium Essay

System

...systems of Kudler Fine Foods. We have discussed their current computer system and evaluated the possibility of threats to it and recommend integrated software solutions. The T3 line at Kudler is clearly more data transmission than is necessary for the company, so it was recommended they switch to T1 dedicated line to reduce costs. Due to the importance of inventory control, we showed management how to take their current inventory data tables and construct pivot tables to improve decision making on inventory. Internal controls were reviewed on payroll, accounts payable, accounts receivable, and inventory processes to ensure the accuracy and validity of data. The review determined that if Kudler does not implement the recommended internal controls system suggested, the business could be under serious threats. Information Technology (IT) auditing is another important improvement that Kudlers should make since our analysis showed that there are risks and vulnerabilities in the AIS process. Our final recommendation will be in the way that the audit process is improved by using computer assisted auditing techniques. This will complete the firm’s analysis and recommendations for Kudler Fine Foods. o Our firm last week analyzed and recommended different types of Information Technology (IT) audits that Kudler Fine Foods can use to assess the risks and vulnerabilities in Accounting Information Systems (AIS) processes. In addition to audit types, owner Kathy......

Words: 1144 - Pages: 5