Current Attempt in Progress No Table is a furniture store in Halfway, Oregon, that manufactures custom-designed wooden tables of exceptional quality. Most of their customers are collectors, including several movie stars. Their business model is simple: a customer contacts them, they work with the customer on a design, build the table, and deliver it to the customer's residence. No Table just hired you as an intern for their accounting department. They hope your data analytics skills can help them with some of the decisions they face. They provide you with an Excel file that contains several worksheets with data generated from their ERP system. The underlying data model is shown here, followed by a data dictionary. Data Model Supplier PurchaseOrders 8 ID PurchaseOrderID SupplierName Status QuoteLead Time ActualLeadTime Supplier Designer DeliveryStatus LaborEstimate ID LaborActual DesignerName RawMaterialEstimate RawMaterialActual Designer SalesOrders Customer SalesOrderID Amount CustomerName Paid State Days SalesTaxRate DaysOutstanding Customer Data Dictionary PurchaseOrders Name Description PurchaseOrderId Uniquely identifies a purchase order. SUPPOR Status A purchase order's status: Canceled, Delivered, Open, or Returned. QuotedLeadTime The number of days the vendor committed to deliver the goods.ActualLeadTime The number of days it took the vendor to deliver the goods. Supplier ID of the vendor from whom the goods are purchased. DeliveryStatus An order is canceled, delivered, open, or returned. For orders that have been delivered, it is specied whether they were early, ontime, late, or disruptive. Disruptive implies that the production process was disrupted. LaborFstimate The estimated dollar amount for labor for the production order. LaborActual The actual dollar amount used for labor for the production order. Name Description RawMaterialEstimate The estimated dollar amount for raw materials for the production order. RawMaterialActual The actual dollar amount for raw materials for the production order. Designer ID of the designer who designed the production order (table). Supplier Name Description ID Uniquely identifies a vendor. Name A vendor's name. salesorders Name Description SalesOrderId Uniquely identifies a sales order. Amount The amount the customer owes NoTable. Paid Has the order been paid in full: Yes or No. Days For orders that are fully paid, the number of days it took to pay them. DaysOutstanding For orders that are not fully paid yet, the number of days the receivable has been outstanding. Customer ID of the customer to whom the table was sold. Customer Name Description Paid Has the order been paid in full: Yes or No. Days For orders that are fully paid, the number of days it took to pay them. DaysOutstanding For orders that are not fully paid yet, the number of days the receivable has been outstanding. Customer ID of the customer to whom the table was sold. Customer Name Description ID Uniquely identifies a customer. Name A customer's name. State The state in which a customer lives. Sales TaxRate The sales tax rate for the state in which the customer lives. Designer Name Description ID Uniquely identifies a designer. Name A designer's name. Click here to view the Excel. NoTable's management would like to include additional information about credit risk in their financial report. They ask you to explore accounts receivable and provide some insights. They provide you with sales orders and payment data generated by their ERP system. You can find these data in the SalesOrders and Customer worksheets. The following is some additional information regarding No Table's credit policy: All payments are due within 30 days. . Early payments: There is a 3% discount for all orders paid in full within 2 weeks (15 days). On time payments: There is no discount or no penalty for sales orders paid on time. . Late payments: There is a 3% penalty for all sales orders with a late payment. 1. Explore whether No Table's credit policy works. For orders that already have been paid, compare early, on time, and late payments. 2. For the orders that have not been fully paid yet, explore the aging of the outstanding balances. What insights can you collect? SUPPORT 3. Analyze accounts receivable by customer. Explore whether there is an issue with accounts receivable concentration. & Please download the Excel input file, complete your Excel file, create your Word file, and submit (upload) your completed Excel and Word files.Customer Name Description ID Uniquely identifies a customer. Name A customer's name. State The state in which a customer lives. SalesTaxRate The sales tax rate for the state in which the customer lives. Designer Name Description ID Uniquely identifies a designer. Name A designer's name. Click here to view the Excel. NoTable delivers items to customer residencies. You notice that no sales tax was collected for any of the sales. 1. Determine the total sales tax amount that No Table should have collected. 2. Determine how much sales tax should have been collected and remitted to the different states. Please download the Excel input file, complete your Excel file, create your Word file, and submit (upload) your completed Excel and Word files. 1 Upload files Supported file formats: Excel, Word 0 / 2 File Limit SUPPORT & Attempts: 0 of 1 used