ACC 542 Week 3 Individual Assignment Data Table Analysis
Before data can be automated it must be evaluated for completeness. Examine the data tables that Kudler Fine Foods maintains for inventory. The table description is located under the Intranet tab – Information Technology tab in the Kudler Virtual Organization. The inventory table is located under Intranet tab – Finance and Accounting – Inventory Reports.
· Resource: Microsoft® Excel Pivot Table Tutorial http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033
· A sample pivot table is available for review on the rEsource page for this course.
· Prepare a 500- to 750-word brief for Kudler Fine Foods management:
o Evaluate the design elements of the data tables from an accounting perspective.
o Create an entity relationship diagram illustrating the existing data tables.
o Recommend improvements to the data tables.
o Create a pivot table in Microsoft® Excel using the general ledger inventory data located on the Kudler Fine Foods Intranet. This pivot table will be used to provide more information to management at Kudler Fine Foods.
o Explain how the information in the pivot table can improve decision-making for management at Kudler Fine Foods, including an example from the data.