Kudler Fine Foods was founded by Kathy Kudler in the summer of 1998 in La Jolla, California. Two other stores were opened at Del Mar and Encinitas California, Kudler Fine Foods deals in specialty foods sells; fresh bakery/Pastries fresh produce fresh meat & seafood condiments and packaged foods cheese's and specialty dairy products (Kudler Fine Foods, 2003). The Entity Relation diagram and pivot table would help Kudler Fine Foods improve the data tables and improve the decision making. Entity Relationship Diagram
An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables. Data Tables from Accounting Perspective
The inventory of Kudler Fine Foods is arranged in the inventory report by store locations, items sold, the amount, and general ledger (GL) code assigned to each inventory item. The codes are all of six digits, La Jolla store GL code starts with “12,” Del Mar starts with “13,” and Encinitas starts with “14.” The uniformity of the codes will help the management of Kudler Fine Foods forecast future purchases and help manage the inventory of all three stores. In the charter of accounts the inventory GL code are the same, this will make the accounting less complex. The POS module system transmits data from the cash register to inventory report by calculating the cost of goods sold and calculating merchandise inventory using the FIFO method (Kudler Fine Foods, 2003). Use of Pivot Table to improve...