Resources: Kudler Fine Foods Virtual Organization, sample pivot table, and Microsoft Excel Pivot Table tutorial
Review the sample pivot table, available on the student Web site for this course
Access the Inventory Reports data table in the Kudler Fine Foods Virtual Organization intranet site, located under the Finance and Accounting tab. The table description is located under the Information Technology tab.
Prepare a brief of at least 1,400 words for Kudler Fine Foods management in which you address the following:
Evaluate the design elements of the nine data tables from an accounting perspective. - do the table s provide adequate information for the accounting cycle? Do some of the tables need to be eliminated? merged? Are there data fields within the tables that need to be added? removed? Does the field need to chabe it''s format in order to improve the information that can be used in the accounting cycle?
Create an entity relationship diagram illustrating the existing data tables.
Recommend improvements to the data tables.
Create a pivot table in Microsoft® Excel using the general ledger inventory data located on the Kudler Fine Foods intranet.
Submit the Excel file with your paper submission
Explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data.
Paper must be in proper APA formatting