Problem
Analyze gross margin percentages by month and by customer, reporting results in a tabular and graphical form, after considering your previous findings. Identify any percentages that are outside the range of expectations.
You will need to first export the transactions that need to be adjusted, if any, to Excel from steps 1 to 3. Then you will need to make the adjustments to the sales (AR) amount and/or inventory cost on the 2016 AR data tab and 2016 inventory relief data tab, respectively.