Data Table Analysis-Kudler Fine Foods ACC/542 July 30, 2012 Yasin Dadabhoy Data Table Analysis-Kudler Fine Foods Kudler Fine Foods is a rapidly growing retail company that began in 1998 that uses a Retail Enterprise Management System (REMS) to track customers, inventory, sales and employees. Being that the majority of Kudler’s inventory is perishable its inventory must be consistently tracked. The following brief will evaluate data tables from an accounting perspective, and provide recommendations for improvements. In addition a pivot table will be created using Kudler’s inventory data that will assist the company’s management improve decision making. Design elements of data tables From an accounting prospective data table …show more content…
For example, using the attached pivot table Kathy is able to see the top 10 inventory items by dollar value at each location. Analyzing this information can help Kathy determine if inventory will need to move from one location to another to avoid spoiling. The ability to quickly visualize this information is extremely important to making improved decisions. Although Kathy and the management team have a vast amount of data that is generated from standard operations, they must learn to use the information that is available to sound make business decisions. In conclusion this brief has evaluated the design elements of data tables and recommended improvements to the existing data tables. In addition a pivot table was created using inventory data for Kudler Fine Foods. Lastly this brief explained how information in the pivot table can help to improve decision making for Kathy and management at Kudler. References Apollo Group Inc. (2011). Kudler Fine Foods. Retrieved from https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet.asp. Bagranoff, N. A., Simkin, M. G., & Strand, N. C. (2008). Core Concepts of accounting information systems (10th Ed.). New York, NY:
Kudler Fine Foods has requested a system to launch its new Frequent Shopper Program. This new initiative will track purchase behavior at the individual customer level. Through a partnership with a loyalty points program, Kudler will be able to offer their most valued customers high value incentives. Behavior patterns discovered from tracking purchases will enable Kudler to refine its processes and offerings to customers. Customers prefer Kudler’s Fine Foods because of the high quality foods. Rather than offering discounted prices for loyalty points redemption, Kudler will offer high value gifts to customers. This will promote the
The management team of Kudler fine Foods uses the intranet to keep demographic data on each of its customers. They can access their names, addresses and important data for special mailings. The inventory is managed and the availability of ingredients can be determined. The items from a store can be obtained from what has been purchased. An order table can be used to record pertinent information. The order line can be seen to show the description, quantity and price. The store table is used to retain data for each store. The supplies table contains data information from tax table is used to provide accurate taxes. The tender table is used to provide a record of payment for an order.
Romney, M., & Steinbart, P. (2012). Accounting information systems. (12th ed., p. 143). Upper Saddle River, NJ: Prentice Hall.
Kathy Kudler, and her company, Kudler Fine Foods, are attempting to initiate a customer loyalty program. According to Kudler (2007)This loyalty program, also called the frequent shopper program, is designed to award points for customer purchases which can then be redeemed for valuable gift items such as airline seat upgrades to first class or other specialty foods offered by Kudler. This program is designed to benefit Kudler by increasing customer loyalty and improving their profitability and bottom line. The ability to accomplish this goal in a manner that will produce the expected results efficiently and in a timely manner will be greatly enhanced through
Review the following example on how to perform the inventory turnover calculation, which shows you how to complete the table.
Strategic decisions are characterized by uncertainty and unstructured decision. These areas will include budgets, target markets, policies, and business objectives. Cuban Pete’s needs to implement automated systems that provide data in real-time on food items ordered and comparisons of weekly sales totals versus food costs, allowing planning for tighter
Kudler Fine Foods has tracked information such as dollar value and profit margin per transaction, dollar sales and profit levels by day, and dollar sales and profit margins by item. Additionally, Kudler plans to add an employee training program and new software systems will facilitate the effort (Kudler Fine Foods, 2003, 2005). The medium with which Kudler manages employee, customer, and inventory information is by database.
Kudler Fine Foods is in a position to use its information technology, marketing strategies, and sales plans to create a prominent place in their niche market. Focusing on internal and external environments will help Kudler formulate a successful plan for the future and prepare for the changes that occur in such a diverse platform of partnerships, contracts, suppliers, and customers. Having a sales plan in place shows forward thinking of the management team. Planning is the most important part of being a successful enterprise and now that Kudler has three stores they are in a position to evaluate where they are and develop their future.
The determination of these values requires you to add columns to the Inventory Analysis worksheet. Mr. Milligan asks you to use the worksheet provided. As Mr. Milligan will use the Inventory Analysis worksheet during a presentation, he wants the worksheet to have a professional appearance. To enhance the worksheet’s appearance, you include an appropriate header and format to the worksheet, column, and row labels. The header should display the name of the business, the name of the worksheet, and the current date. As you construct the worksheet, you use the currency format for all columns containing dollar values. Also, for any column that contains a percentage, you
Information Management System (IMS) refers to a database that integrates financial and other information in organizations from different levels of management and produces regular reports. Starbucks is one of the firms that have implemented IMS. This paper describes IMS for Starbucks, its impact on competitive edge and how it helps to coordinate supply chain partners and to monitor inventory levels. The paper also explains why managing information is better than moving products.
Accounting Information Systems Controls and Processes, 1st Edition_Leslie Turner, Andrea Weickgenannt (SM+TB+IM +Spatteli,s Pizzeria Solutions+Process
Kimmel, P. D., Weygandt, J. J., & Kieso, D. E. (2009). Accounting: Tools for business decision
Accounting Information Systems The Crossroads of Accounting and IT by Donna Kay, Ali Ovlia Instructor’s Solutions Manual
The internal data created by Woolworths needs to be converted to meaning and useful information for the strategic mangers to utilize in forming strategic plans. Woolworths will store all of this data in data warehouses and then mine this data to find patterns and
The problem faced by the company is they do not have any systematic system to record and keep their inventory data. It is difficult for the admin to record the inventory data quickly and safely because they only keep it in the logbook and not properly organized.