Hello. I need help with this project. Basically I only need to know what adjusting entry is needed for each audit work steps:

Audit work steps

1. Verify that every sales transaction has a shipping number and FedEx identification number. Identify and quantify any sales that have not been shipped (including names of customers and transaction numbers). Propose any necessary audit adjustment.

2. Verify that every shipping number has a recorded sales transaction. Identify and quantify the cost of sales for products shipped without a sale being recorded (including names of customers and transaction numbers). Propose any necessary audit adjustment.

3. Identify shipments that occurred in 2017 for 2016 sales. Identify and quantify any sales and the cost of sales for amounts recorded in the improper period (including names of customers and transaction numbers). Propose any necessary audit adjustment.

4. 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.

BACKGROUND INFO ABOUT THE COMPANY

Analytics mindset TechWear Part IV: Background: It is now February 6, 2017, and you are ready to begin the year-end audit procedures for the 2016 audit. The client has provided the 2016 data that you requested (Analytics_mindset_case_studies_Techwear_P4.xls) so you can begin your work. Procedures have already been performed by your team to ensure that the data you received is accurate.

The data file includes data on two tabs 2016 AR data and 2016 inventory relief data. 2016 AR data tab The data fields are the same as what you received for 2015, with the exclusion of the ship date. Additionally, the "Type" field includes transaction information for the opening balance (Opening Balance), which reconciles with the 2015 ending balance of $684,491.19 and the unapplied cash receipts (Unapplied Receipts). 2016 inventory relief data tab This data includes the following fields:

ShipNum: this is the shipping number. This number becomes the sales transaction number when the invoice is created, which is the transaction number field on the 2016 AR data tab.

FedExID: this is the FedEx identification number. All items shipped on a given day will have the same number.

CustNum: this is a unique customer number to identify the customer (same field that is on the 2016 AR data tab).

CustName: this is the customer name (same field that is on the 2016 AR data tab).

InvoiceDate: this is the date the sale was invoiced (billed) (same field that is on the 2016 AR data tab). ShipDate: this is the date the goods were shipped.

InvCostReliefAmount: this is the inventory cost relief amount, or the cost of sales.

The December 31, 2016, working trial balance shows the following: Accounts receivable $18,114,802.50 (no allowances have been recorded) Sales $37,333,890.86 Cost of sales $14,269,387.17

You have been asked to perform each of the following select work steps that are based on the auditing procedures documented in the audit data analysis template from Part III. Perform your analysis in Tableau.