Data Table Analysis for Kudler Fine Foods

Data Table Analysis for Kudler Fine Foods

In this brief, I will determine the design elements of data tables using accounting ideas to develop entity relationship diagrams illustrating the data tables already used and create entity relationship diagrams advising other alternatives to improve the data tables. I will also include a pivot table using the general ledger inventory data of Kudler, explaining how this information may improve the way management makes decisions for the company.
When observing Kudlers inventory data table, the table can easily be read and one can understand what the table is telling them. The structure of the data table consists of the GL Code, summary line item, inventory item, and the amount. Reading this report an individual will recognize that the first two numbers represent the store location. The tables also consist of inventory items, and the items are also broken down into the different departments. The last column lists the total sum amount of each code. The company??™s inventory data is not difficult to read and understand. The structure of the table makes it easy to recognize what items belong to which department and the amount of the inventory items. This information assist the stores in determining the sales made per store, the items in stock, and the amount of the inventory on hand.
An entity relationship diagram is an illustration representing graphical techniques describing the entities and their direct relationships. The diagram model includes four symbols: ovals, diamonds, rectangles, and connecting lines. Each of the symbols represents a description of what the entity stands for. For example, the diamond is a description of the relationships, rectangles represent entities, an oval signify the qualities of the entity, and the lines presents the connection of the relationships (Bagranoff, Simkin, Strand, 2008).
Kudlers inventory table is very important because it helps to maintain the inventories which, consist of the elements that make up an Item. These elements are used in managing the inventory and helping to recognize the availability of the ingredients included in the items, for products like bakery goods, etc. (University Of Phoenix, 2010). Kudler could make improvements in their inventory table by including a price column and a quantity column. The total column can remain. With the additional two columns this will assist them more efficiently in recognizing the exact amount of inventory before they have to reorder. It would be beneficial for them to know where they are and what they need to alleviate. Kudler would be able to know if what their stock levels are. For the discounted items or those that need to be moved this would be very helpful.
Improvements of the data and pivot tables will be a hugh help in rearranging codes to a certain particular order. Facilitating these improvements will make it more accessible in monitoring the different departments that has several items to sell. ???Separating the data will allow better visualization, understanding, and arrangement of the data needed to make better decisions??? (Birnbaum, 2003, p.89). Pivot tables are two dimensional summaries of statistical database information. This particular table allows the users the opportunity to select the type of information to exhibit for example, the maximum sales, total sales, average sales or even make changes to the selection categories (Bagranoff, Simkin, Strand, 2008). Reviewing the inventory table of Kudler as is, creating a pivot table may make it more understandable to read. Instead of trying to remember the coding for the different departments the pivot table could have a column for a summary line, next under the same category list all the inventory items, amounts, and last sum up the totals.
For instance, Kudler??™s Del Mar location may have their bakery department Merchandise Inventory, in which they can list some of the items in that department like cheeses, breads, etc. in addition to the amounts, and store location. The pivot table would total up the entire amounts and give a total sum amount of inventory for that locations bakery department Merchandise Inventory. The company can also include some entity items sold and can help recognize the relationships among the sales and inventory. Automatically the system will incorporate more current information regarding the inventory examining the similarities of the targeted inventory whenever a sales transaction is made. Using updated data tables and pivot table, Kudler will have the opportunity to recognize the variances of inventory they have left in the stores, what inventory items they need to order, and what needs to be relocated to storage.. The pivot table can be put to good use because with it Kudler will be able to make quick summaries about the data from a worksheet, finding totals, and average inventory counts of their items. The pivot table is also helpful because this would eliminate the redundancy of information in the database within the database. See Figure 2.
In concluding, Kudler Fine Foods is very extensive concerning their customer satisfaction, and in maintaining those satisfied customers, I have included some various recommendations that would assist Kudler with improving the current inventory data table. In addition I have given explanations of how the information in their pivot tables can help make better decisions for their management teams. So these proposed recommendations will assist Kudler in eliminating redundancy of information.

References
Bagranoff, N. A., Simkin, M. G., & Strand, N. C. (2008). Core Concepts of Accounting Information Systems (10th ed.). New York, NY: Wiley & Sons

Birnbaum, Duane, (2003) p.89, Microsoft Excel VBA professional projects, retrieved on January 12, 2011 from UOP online database.

University of Phoenix. Kudler Fine Foods. Retrieved on January 12, 2011 from website: https://ecampus.phoenix.edu/secure/aapd/cist/vop/business/Kudler/IT/KudlerITDatabases001.htm

Figure-2

|General Ledger Inventory Pivot Table | | |
| | | |
|Sum of Amount |?  |?  |
|Summary Line Item |Inventory Item |Total |
|Del Mar Bakery Department Merchandise Inventory |Agiago Cheese |816.48 |
|?  |Calamata Olive Bread |270.83 |
|?  |Challah |1210.68 |
|?  |Ciabatta |736.87 |
|?  |Danishs |255.05 |
|?  |Ficelle |417 |
|?  |Finnish Rye |2217.73 |
|?  |Focaccia |612.83 |
|?  |French Croissants |555.93 |
|?  |Fruit Croissants |873.05 |
|?  |Fruit Tarts |464.85 |
|?  |Honey Wheat |1599.38 |
|?  |Italian Sssemolina |319.36 |
|?  |Prussian Rye |266.57 |
|?  |Rustic Baguette |623.45 |
|?  |Sourdough Rounds and Batards |266.85 |
|?  |Swiss Muesli |1273.96 |
|Del Mar Bakery Department Merchandise Inventory Total |12780.87 |
|Del Mar Cheese & Dairy Merchandise Inventory |Aioli Sauce |268.03 |
|?  |Asiago |1473.45 |
|?  |Beurre Barratte de Celles sur Belle |376.28 |
|?  |Beurremont 83% Butter |278.38 |
|?  |Boursin |7935.99 |
|?  |Brie |362.71 |
|?  |Cabridoux |367.66 |
|?  |Camembert |264.59 |
|?  |Cheddar |2899.77 |
|?  |Chevre |1778.05 |
|?  |Clotted Cream |567.6 |
|?  |Danish Lurpak Butter |361.69 |
|?  |Dulce de Leche |252.4 |
|?  |Edam |616.32 |
|?  |Emmental |276.46 |
|?  |English Brandy Butter |1520.67 |
|?  |Feta |266.8 |
|?  |Fontina |851.76 |
|?  |Gorgonzola |707.75 |
|?  |Gouda |294.4 |
|?  |Grana Padano |437.43 |
|?  |Gruyere |460.56 |
|?  |Havarti |315.98 |
|?  |Jarlsberg |277.45 |
|?  |Limburger |745.91 |
|?  |Manchego |464.53 |
|?  |Mascarpone |304.85 |
|?  |Maytag |33475.13 |
|?  |Mozzarella |696.46 |
|?  |Parmigiano Reggiano |279.61 |
|?  |Pecorino Romano |513.33 |
|?  |Provolone |653.98 |
|?  |Raclette |253.34 |
|?  |Ricotta |853.87 |
|?  |Roquefort |331.71 |
|?  |Stilton |708.65 |
|Del Mar Cheese & Dairy Merchandise Inventory Total |?  |62493.55 |
|Del Mar Meat and Seafood Merchandise Inventory |Angus Beef |328.11 |
|?  |Beluga |1859.68 |
|?  |Caviar |557.58 |
|?  |Coho Salmon |843.65 |
|?  |Copper River King Salmon |312.41 |
|?  |Duck |1006.87 |
|?  |Dungeness Crab |595.88 |
|?  |Goose |298.32 |
|?  |Guinea Fowl |17200.46 |
|?  |Lobster |252.42 |
|?  |Oregon Sanddabs |343.51 |
|?  |Ostrich |440.95 |
|?  |Oysters |326.65 |
|?  |Pacific Swordfish |671.68 |
|?  |Partridge |277.92 |
|?  |Pheasant |251.57 |
|?  |Poussin |397.01 |
|?  |Quail |741.39 |
|?  |Red Snapper |2648.37 |
|?  |Sausages |267.9 |
|?  |Squab |269.56 |
|?  |Wild King Salmon |2217.22 |
|?  |Wild Turkey |524.71 |
|Del Mar Meat and Seafood Merchandise Inventory Total |32633.82 |
|Del Mar Produce Merchandise Inventory |Atemoya |442.34 |
|?  |Breadfruit |331.39 |
|?  |Canistel |1269.28 |
|?  |Cortland Apples |529.26 |
|?  |Empire Apples |1440.37 |
|?  |Feijoa |506.67 |
|?  |Fuji Apples |282.38 |
|?  |Gala Apples |941.87 |
|?  |Golden Delicious Applies |551.25 |
|?  |Gravenstein Apples |251.61 |
|?  |Litchi |8696.56 |
|?  |Longan |290 |
|?  |Mamey Sapote |476.36 |
|?  |McIntosh Apples |593.74 |
|?  |Northern Spy Apples |415.55 |
|?  |Pink Lady Apples |365.93 |
|?  |Rhode Island Grening Apples |6333.53 |
|Del Mar Produce Merchandise Inventory Total |?  |23718.09 |
|Del Mar Wine Merchandise Inventory |Blush Wines |395.1 |
|?  |Dessert Wines |748.4 |
|?  |Fruit Wines |303.39 |
|?  |Red Wines |304.81 |
|?  |Rice Wines |399.16 |
|?  |Sparkling Wines |384.17 |
|?  |White Wines |117030.98 |
|Del Mar Wine Merchandise Inventory Total |?  |119566.01 |
|Encinitas Bakery Department Merchandise Inventory |Agiago Cheese |561.14 |
|?  |Calamata Olive Bread |362.66 |
|?  |Challah |473.86 |
|?  |Ciabatta |478.83 |
|?  |Danishs |278.53 |
|?  |Ficelle |950.16 |
|?  |Finnish Rye |349.38 |
|?  |Focaccia |335.08 |
|?  |French Croissants |2517 |
|?  |Fruit Croissants |352.62 |
|?  |Fruit Tarts |286.07 |
|?  |Honey Wheat |1235.08 |
|?  |Italian Sssemolina |775.23 |
|?  |Prussian Rye |332.16 |
|?  |Rustic Baguette |511.72 |
|?  |Sourdough Rounds and Batards |363.85 |
|?  |Swiss Muesli |386.7 |
|Encinitas Bakery Department Merchandise Inventory Total |10550.07 |
|Encinitas Cheese & Dairy Merchandise Inventory |Aioli Sauce |863.25 |
|?  |Asiago |9772.47 |
|?  |Beurre Barratte de Celles sur Belle |334.08 |
|?  |Beurremont 83% Butter |335.11 |
|?  |Boursin |418.42 |
|?  |Brie |311.81 |
|?  |Cabridoux |638.82 |
|?  |Camembert |3139.56 |
|?  |Cheddar |984.71 |
|?  |Chevre |6493.36 |
|?  |Clotted Cream |1634.89 |
|?  |Danish Lurpak Butter |541.86 |
|?  |Dulce de Leche |1289.39 |
|?  |Edam |267.53 |
|?  |Emmental |979.79 |
|?  |English Brandy Butter |5365.83 |
|?  |Feta |252.68 |
|?  |Fontina |261.15 |
|?  |Gorgonzola |832.11 |
|?  |Gouda |310.68 |
|?  |Grana Padano |254.57 |
|?  |Gruyere |412.28 |
|?  |Havarti |1775.41 |
|?  |Jarlsberg |1062.24 |
|?  |Limburger |267.6 |
|?  |Manchego |490.35 |
|?  |Mascarpone |2485.93 |
|?  |Maytag |3972.44 |
|?  |Mozzarella |440.93 |
|?  |Parmigiano Reggiano |412.23 |
|?  |Pecorino Romano |348.55 |
|?  |Provolone |338.12 |
|?  |Raclette |288.19 |
|?  |Ricotta |306.13 |
|?  |Roquefort |322.62 |
|?  |Stilton |308.87 |
|Encinitas Cheese & Dairy Merchandise Inventory Total |48513.96 |
|Encinitas Meat and Seafood Merchandise Inventory |Angus Beef |1665.2 |
|?  |Beluga |252.94 |
|?  |Caviar |250.61 |
|?  |Coho Salmon |423.49 |
|?  |Copper River King Salmon |348.63 |
|?  |Duck |5041.08 |
|?  |Dungeness Crab |1113.25 |
|?  |Goose |252.16 |
|?  |Guinea Fowl |5031.94 |
|?  |Lobster |589.1 |
|?  |Oregon Sanddabs |285.16 |
|?  |Ostrich |413.75 |
|?  |Oysters |897.36 |
|?  |Pacific Swordfish |1896.75 |
|?  |Partridge |529.24 |
|?  |Pheasant |635.77 |
|?  |Poussin |513.12 |
|?  |Quail |365.92 |
|?  |Red Snapper |458.53 |
|?  |Sausages |311.86 |
|?  |Squab |2471.77 |
|?  |Wild King Salmon |1343.44 |
|?  |Wild Turkey |1253.82 |
|Encinitas Meat and Seafood Merchandise Inventory Total |26344.89 |
|Encinitas Produce Merchandise Inventory |Atemoya |921.44 |
|?  |Breadfruit |4951.69 |
|?  |Canistel |528.16 |
|?  |Cortland Apples |423.26 |
|?  |Empire Apples |284.55 |
|?  |Feijoa |541.19 |
|?  |Fuji Apples |1524.09 |
|?  |Gala Apples |758.18 |
|?  |Golden Delicious Applies |580.05 |
|?  |Gravenstein Apples |2944.58 |
|?  |Litchi |266.08 |
|?  |Longan |827.25 |
|?  |Mamey Sapote |877.22 |
|?  |McIntosh Apples |501.02 |
|?  |Northern Spy Apples |1050.7 |
|?  |Pink Lady Apples |424.07 |
|?  |Rhode Island Grening Apples |3457.13 |
|Encinitas Produce Merchandise Inventory Total |?  |20860.66 |
|Encinitas Wine Merchandise Inventory |Blush Wines |306.17 |
|?  |Dessert Wines |353.8 |
|?  |Fruit Wines |329.36 |
|?  |Red Wines |363.9 |
|?  |Rice Wines |456.29 |
|?  |Sparkling Wines |373.71 |
|?  |White Wines |255.3 |
|Encinitas Wine Merchandise Inventory Total |?  |2438.53 |
|La Jolla Bakery Department Merchandise Inventory |Agiago Cheese |1061.63 |
|?  |Calamata Olive Bread |452.67 |
|?  |Challah |254.02 |
|?  |Ciabatta |392.99 |
|?  |Danishs |534.07 |
|?  |Ficelle |558.43 |
|?  |Finnish Rye |945.27 |
|?  |Focaccia |4463.93 |
|?  |French Croissants |290.64 |
|?  |Fruit Croissants |427.24 |
|?  |Fruit Tarts |932.86 |
|?  |Honey Wheat |3116.01 |
|?  |Italian Semolina |697.06 |
|?  |Prussian Rye |6937.42 |
|?  |Rustic Baguette |283.2 |
|?  |Sourdough Rounds and Batards |727.92 |
|?  |Swiss Muesli |401.61 |
|La Jolla Bakery Department Merchandise Inventory Total |22476.97 |
|La Jolla Cheese & Dairy Merchandise Inventory |Aioli Sauce |261.69 |
|?  |Asiago |265.58 |
|?  |Beurre Barratte de Celles sur Belle |288.12 |
|?  |Beurremont 83% Butter |823.82 |
|?  |Boursin |423.91 |
|?  |Brie |1019.83 |
|?  |Cabridoux |540.44 |
|?  |Camembert |368.82 |
|?  |Cheddar |566.9 |
|?  |Chevre |576.65 |
|?  |Clotted Cream |625.71 |
|?  |Danish Lurpak Butter |273.89 |
|?  |Dulce de Leche |2456.18 |
|?  |Edam |511.42 |
|?  |Emmental |307.86 |
|?  |English Brandy Butter |315.09 |
|?  |Feta |1446.62 |
|?  |Fontina |564.24 |
|?  |Gorgonzola |385.18 |
|?  |Gouda |740.97 |
|?  |Grana Padano |607.78 |
|?  |Gruyere |310.16 |
|?  |Havarti |287.86 |
|?  |Jarlsberg |262.21 |
|?  |Limburger |296.34 |
|?  |Manchego |634.94 |
|?  |Mascarpone |336.56 |
|?  |Maytag |314 |
|?  |Mozzarella |489.27 |
|?  |Parmigiano Reggiano |494.5 |
|?  |Pecorino Romano |778.7 |
|?  |Provolone |335.21 |
|?  |Raclette |361.97 |
|?  |Ricotta |935.11 |
|?  |Roquefort |700.46 |
|?  |Stilton |251.08 |
|La Jolla Cheese & Dairy Merchandise Inventory Total |?  |20159.07 |
|La Jolla Meat and Seafood Merchandise Inventory |Angus Beef |2770.92 |
|?  |Beluga |573.66 |
|?  |Caviar |263.04 |
|?  |Coho Salmon |1049.8 |
|?  |Copper River King Salmon |509.69 |
|?  |Duck |1088.09 |
|?  |Dungeness Crab |330.15 |
|?  |Goose |350.81 |
|?  |Guinea Fowl |307.2 |
|?  |Lobster |370.72 |
|?  |Oregon Sanddabs |372.8 |
|?  |Ostrich |504.35 |
|?  |Oysters |353.35 |
|?  |Pacific Swordfish |798.2 |
|?  |Partridge |262.25 |
|?  |Pheasant |567.73 |
|?  |Poussin |889.17 |
|?  |Quail |322.08 |
|?  |Red Snapper |302.09 |
|?  |Sausages |2210.92 |
|?  |Squab |258.75 |
|?  |Wild King Salmon |352.24 |
|?  |Wild Turkey |404.35 |
|La Jolla Meat and Seafood Merchandise Inventory Total |15212.36 |
|La Jolla Produce Merchandise Inventory |Atemoya |631.5 |
|?  |Breadfruit |315.63 |
|?  |Canistel |250.74 |
|?  |Cortland Apples |526.1 |
|?  |Empire Apples |271.09 |
|?  |Feijoa |402.17 |
|?  |Fuji Apples |1341.05 |
|?  |Gala Apples |303.32 |
|?  |Golden Delicious Applies |428.4 |
|?  |Gravenstein Apples |612.82 |
|?  |Litchi |263.54 |
|?  |Longan |293.93 |
|?  |Mamey Sapote |278.22 |
|?  |McIntosh Apples |348.44 |
|?  |Northern Spy Apples |491.06 |
|?  |Pink Lady Apples |1039.07 |
|?  |Rhode Island Grening Apples |360.16 |
|La Jolla Produce Merchandise Inventory Total |?  |8157.24 |
|La Jolla Wine Merchandise Inventory |Blush Wines |282.64 |
|?  |Dessert Wines |310.83 |
|?  |Fruit Wines |547.9 |
|?  |Red Wines |495.27 |
|?  |Rice Wines |400.01 |
|?  |Sparkling Wines |544.77 |
|?  |White Wines |512.49 |
|La Jolla Wine Merchandise Inventory Total |?  |3093.91 |
|Grand Total |?  |429000 |

Leave a Reply

Your email address will not be published. Required fields are marked *