NoTable is a furniture store in Halfway, Oregon, that manufactures custom-design

NoTable 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. NoTable 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.
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 NoTable’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.
a. Explore whether NoTable’s credit policy works. For orders that already have been paid, compare early, on time, and late payments.
b. For the orders that have not been fully paid yet, explore the aging of the outstanding balances. What insights can you collect?
c. Analyze accounts receivable by customer. Explore whether there is an issue with accounts receivable concentration.
I have attached all info for the question. As well as a powerpoint for extra help on the topic. Please upload an excel file showing how you solved it as well as a sperate word file answering the questions