Quality and Quantity at Kudler Fine Foods

566 Words Jan 14th, 2018 2 Pages
When they open their first store, Microsoft Access was selected as the database to track inventory, orders, and customers. The products, they sold are perishable and inventory must be properly tracked. Kudler excessive inventory is always a concern. This paper will evaluate database tables from accounting perspective, provide recommendation for improvement and create pivot table to help Kudler's management to improve decision making process.
Evaluate the design elements of the data tables from an accounting perspective. First, the table organizes the financial data into department, then financial account codes, items, and then sums the total amount of transactions for the code. Then counts how many quantities of the items were in inventory during the period. Second, this design maximizes the visual and informational presentation for the financial data. Given this design, the user of the information can readily identify what items belong to a certain department, and how many items were in to arrive at the total cost for a particular item for the period. Third, given the presentation of the total amount and quantity on hand for an item, the information user can easily calculate the effective average purchase price for an item. Recommend improvements to the data table The data tables, specifically the Pivot table, may be improved on by arranging the codes chronologically; sort the data by compiling…

More about Quality and Quantity at Kudler Fine Foods