Prepare a 750-word brief for Kudler Fine Foods management:
Evaluate the design elements of the data tables from an accounting perspective.
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. This pivot table will be used to provide more information to management at Kudler Fine Foods.
Explain how the information in the pivot table can improve decision-making for management at Kudler Fine Foods, including an example from the data.