Deliverable: a single Excel Workbook for:

· Cust ID – Unique ID for each customer 

· Region – Sales Region of the country where the sale was made

· Payment Method – Method of payment

· Transaction Code – Unique transaction code for each transaction

· Purchase Source – How purchase was made

· Purchase Amount – Amount of purchase in USD $

· Product Type – Type of Product purchased

Submit a single Excel Workbook with worksheet tabs named as outlined above containing the 4 Required Pivot Tables listed in the Assignment document.  Name and submit your Excel file in Canvas using the following naming convention:  lastname-firstname-MBA6350- Case1.xlsx

Submit a single Word Document containing your “Executive Summary”.  Ensure it follows the requirements listed in the Assignment Document.  Name and submit your Word file in Canvas using the following naming convention:  lastname-firstname-MBA6350-Case1.doc