I am struggling to understand how to calculate GMP percentage by customer as asked in question 4. I believe I have the first art of query set up correctly but I am at a loss as to how to finish. Can you provide some guidance please?

Analyze gross margin percentages by customer for Year 2016, after considering your previous findings. (10 points) 2, evenies - Similar to 13 Your answer will be in a query called Q4answer. If you use more than 1 query, name the other - Change dates queries as Q4Step1, Q4Step2.... Q4answer Step1 Ship date 2016 not17 Sort GMP from the smallest to the largest. Stop 2 to get Gimp 5. Develop a trial balance of accounts receivable by customer at December 31, 2016, after reflecting about any proposed audit adjustments. (10 points) Your answers will be in a query called Q5answer. If you use more than 1 query, name the other queries as Q5Step1, Q5Step2... Q5answer. The trail balance should include Customer Name, Opening Balance, Sales, Cash Receipts, and Unapplied Receipts (in that order). Summary of audit findings Accounts Inventory Sales Cost of sales receivable Other As of December 31, 2016 $37,333,890.86 $14,269,387.17 $18, 114,802.50 Q1. Audit finding ( 1 , 751 , 911.73) 1 751,911.73 Q2. Audit finding Q Q3. Audit finding 1,2.43 917 . 30) ( 501 271 . 83 ) 1 243 917.30 ( 501 271 83 Adjusted as of 34 338 061,83 13, 76 8, 115. 34 15 , 118, 973.47 ( 501 , 271 . 83 )All Access ... @