Use Alteryx tools to complete and include explainations.

Issues to address $($place each solution in its own container$)1.$ Sales cannot be reconciled by the company by division or by product. Please create summaries of revenue by division $($by month$),$ by division $($in total for $($year$),$ by product $($in total for year$)$ and by product by division $($in total for year$).$ Please only include revenue related to product sales, not any revenue created by shipping of goods$2.$ Please show outstanding receivables at year end by customer $($PLEASE SHOW CUSTOMER NAME FOR EASE OF USE BY CLIENT$)$ and by sales region$\mathrm{.}3.$ Days sales outstandinga. Please show the average days sales outstanding by customer name over the course of the year $($for those that are not still outstanding$).$ For further analysis, please show average days sales outstanding by division and by product.b$.$ Please also show total number of days outstanding at year end by Sales Order ID$.$ Additionally please create a list of the $25$ customers by name with the longest sales outstanding $($still outstanding at year end that also indicates the region those sales are allocated to$).$ For additional analysis, please show the Days Sales Outstanding at year end by division and by product to show any differences from overall yearly averages $($calculated in part $3$a$)4.$ Management and the audit team have identified that some Sales VPs are borderline on meeting their sales goals for the year. Please identify anyoutstanding sales invoices that should be checked for potential earnings management.