...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 located...
Words: 769 - Pages: 4
...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 provides...
Words: 607 - Pages: 3
...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 design...
Words: 903 - Pages: 4
...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 chosen...
Words: 1218 - Pages: 5
...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 latest...
Words: 1257 - Pages: 6
...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 pertinent...
Words: 546 - Pages: 3
...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 products...
Words: 1205 - Pages: 5
...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
...| Course Design Guide School of Business ACC/542 Version 3 Accounting Information Systems | Copyright © 2012, 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Bagranoff, N. A., Simkin, M. G., & Strand Norman, C. (2008). Core concepts of accounting information systems (10th ed.). New York, NY: Wiley. Hunton, J. E., Bryant, S. M., & Bagranoff, N. A. (2004). Core concepts of information technology auditing. Hoboken, NJ: Wiley. O’Brien, J. A. & Marakas, G. M. (2008). Management information...
Words: 2104 - Pages: 9
...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 shopping...
Words: 1337 - Pages: 6
...Kudler Fine Foods has been a successful organization due to many factors including hard work, dedication, and inventory control. As of now there are three locations with each location having their own inventory. Through hard work expansion of the organization was bound to happened, but also created the need to identify strengths and weakness of the current system, and determine if a more efficient method would be better. Kudler Fine Foods inventory is the backbone of the organization. A lot of cash is tied up in Kudler’s inventory making this a top priority to improve. Kudler needs a standardized ordering system to keep track of their inventory. As of now they are using a computerized ordering system, what they need is a system that will help them keep track of their inventory as it is sold or purchased. Kudler also needs an accounting system that will help them with payroll, accounts payable, and sales. A network that will connect sales, accounts payable, payroll, and inventory all together. Having a system that will connect all departments will allow for a more accurate financial statement. This will also allow for the managers to see expenses with each department, and see which item is being sold more. Another opportunity that Kudler needs is a system that would allow authorized personnel to enter all three stores from any location. Kudler would benefit from a network that linked managers together in order from them to view and enter data from any location...
Words: 400 - Pages: 2
...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
...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 management...
Words: 1148 - Pages: 5
...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 id...
Words: 779 - Pages: 4
...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 charged...
Words: 1352 - Pages: 6
