...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 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
...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 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
...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 Kudler needs...
Words: 1144 - Pages: 5
...Kudler Fine Foods is a company that has grown since the initial opening in 1998, and to manage with the growth Kudler selected Microsoft Access as the database to help track inventory, sales, orders, employees, and customers. Kudler’s inventory consist of perishable products, therefore inventory needs be accurately tracked. This paper will evaluate the design elements of the data tables from an accounting perspective, create an entity relationship diagram including a pivot table, recommend improvements to the data tables, and explain how the new diagrams will improve Kudler’s decision making for management. Table Analysis The data table analysis is vital to Kudler’s success. The data is organized into general ledger codes, inventory item, summary line item, and the total amount of the item’s transaction. The data provided in the analysis table, which are viewed by the users, shows how much money is spent on what product and which store. The description of the data table gives the total amount and quantity on hand for an item and calculating average price for an item. From an accounting perspective, the data tables are simple and easy to read. There are four headings. They include the GL Code, inventory item, summary line item and the amount. The GL Code helps to identify which store the item is located. For example, 12 stands for La Jolla, 13 identify the store in Del Mar, and 14 identify the Encinitas store. The inventory items identify what items are in the inventory. At...
Words: 567 - Pages: 3
...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 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...
Words: 599 - Pages: 3
...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
...Data Table Analysis Brief Ashley Jones ACC/542 November 5, 2012 Anita Rodriguez, M.A., CPA Data Table Analysis Brief Kudler Fine Foods has data that must be evaluated and automated into the data systems. Before the data can be automated, it must be evaluated for completeness. One must evaluate two different items: The Access data tables and The Inventory Database. To better assist Kudler Fine Foods, one must evaluate the design elements of the Access data tables from an accounting perspective and recommend improvements to the existing tables. An entity relationship diagram and pivot table will assist with understanding the data. One can then provide an explanation of how the information in the pivot table may improve decision making. Design Elements From an accounting perspective, the design elements of the data tables lack the information needed for processing transactions on a daily basis. The data in the table provide information on the customers, inventories, items, orders, order lines, stores, suppliers, tax tables, and tenders. The tables do not provide information on the transactions to journalize and add to the general ledger. The tables lack information for the financial reports, except for a few of the tables. The inventory table will provide the basic information for the quantity on hand for cost of goods calculations with unit cost for the income statement. The tender table will provide basic information on whether the payment is cash, credit sale...
Words: 536 - Pages: 3
...Learning Team C Week Five Assignment Score Sheet TEAM This is a very good attempt at putting together a system concept for the Kudler Fine Food project. You presented a clear definition of what the Kudler Fine Food Frequent Shopper project was to look like. However, there are some areas that you need to reconsider. I enjoyed reading your paper. General comments: See my comments in your paper. You need to do a thorough review of grammar and spelling. - Grammar, spelling, and/or sentence structure errors detracted from this write up. See my comments in the paper. You need to do a better job at proofing your work for grammar and spelling errors. Take advantage of the Center for Writing Excellence tools. This paper had several APA Style errors. I have indicated in red on this score sheet those sections that did not earn maximum points. I have included my comments in your paper. A commented copy of your paper follows these comments and the scoring matrix. Comments in red text or highlighted in green are deficient. Disregard comments highlighted in yellow – my marking used for grading or gray – information I copied from a different area of your paper. Let me know if you have any questions. Disregard highlights in yellow. I use these to track through your papers. |Subject |Points |Points Earned | | ...
Words: 5738 - Pages: 23
...| 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
...2012 System Integrity and Validation Kudler Fine Foods has three different locations that carry domestic and imported foods that are in five different departments. Kudler Fine Food management decided to have an accounting firm come in and look at the computer system that they are using. Kudler Fine Food is looking to successfully improve the system for possible expansion in the local area or in different states. The accounting firm has given Kudler Fine Foods six weeks to let them know what the strengths, weaknesses, and what improvements need to be done. The accounting firm took the first week to look at the type of system that Kudler Fine Foods have and how to make improvements. What the accounting firm discovered is that Kudler Fine Foods has installed the comprehensive modular Retail Management System which is a point-of-sale that may or may not have a web-based program. During this time the accounting firm discussed the improvements to the module to reduce the manual transactions and make the system more effective. The accounting firm also discussed the possible threats and ways that the threats can be prevented. The next step that needed to be discussed is the type of software for Kudler Fine Foods. The accounting firm made a suggestion of industry-customizable financial software that would replace the current processes. Once the accounting firm decided that the industry-customizable financial software would benefit Kudler Fine Foods there were flowcharts produced...
Words: 1807 - Pages: 8
...Kudler Fine Foods Service Request SR-kf-013 BSA375 Business Systems Development Abstract Kudler Fine Foods, an upscale specialty gourmet foods shop with three locations (La Jolla, Del Mar and Encinitas), has an expressed interest in the development of a Frequent Shopper Program to enable enhanced information management by tracking customer-purchasing practices. The information collected regarding customer purchase behaviors through the Frequent Shopper Program will improve the quality of Kudler Fine Foods’ product lines and reduce the quantities of perishables discarded. To increase revenue and customer loyalty, and as an alternative to providing discounts, Kudler Fine Foods has partnered with a loyalty points program to offer incentives for customer loyalty in the form of high-end rewards for shopping at Kudler Fine Foods. Customers will earn points with every purchase, redeemable for high-value gift items such as first-class airline upgrades, and other specialty items (Apollo Group, Inc., 2007). Facilitating this effort will require systems planning and selection as well as current and proposed systems analysis and design, in conjunction with systems implementation and integration, training, operations, and maintenance. Kudler Fine Foods Service Request SR-kf-013 Initiatives Outline Kathy Kudler, the founder of Kudler Fine Foods, opened her first gourmet food shop in 2003. Since that time, two additional stores have opened, and other locations in Carlsbad...
Words: 7143 - Pages: 29
