NoTable's management would like to include additional information about credit risk in their...

Question

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.

Explore whether NoTable's credit policy works. For orders that already have been paid, compare early, on time, and late payments.

For the orders that have not been fully paid yet, explore the aging of the outstanding balances. What insights can you collect?

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.

pro2-q3-1-un5wemdl.png pro2-q3-2-0xovd100.png pro2-q3-3-kl2wjk01.png pro2-q3-4-u2dm04ni.png pro2-q3-data-0ol3coo1.xlsx

Khushboo · Accepted Answer

PurchaseOrders
	PurchaseOrderId	Status	QuotedLeadTime	ActualLeadTime	Supplier	LaborEstimate	RawMaterialEstimate	LaborActual	RawMaterialActual	Designer	DeliveryStatus
	1	Delivered	30	28	1	28560.3	31416.33	26656.28	35224.37	1	On Time
	2	Delivered	30	45	3	1901.55	2263.75	2807.05	2535.4	5	Disruptive
	3	Canceled	45	48	2	22416.52	20815.34	22416.52	29621.83	4	Cancelled
	4	Canceled	60		5	31322.72	19470.88	30476.16	26243.36	4	Cancelled
	5	Delivered	90		6	30709.82	27096.9	23483.98	25290.44	5	Early
	6	Delivered	120	133	3	5356.12	6312.57	4399.67	6503.86	5	Late
	7	Returned	60	63	2	14657.76	14250.6	15879.24	10993.32	3	Returned
	8	Delivered	30	42	1	25033.8	17447.8	16689.2	21999.4	3	Disruptive
	9	Returned	30		5	20146.62	22471.23	17822.01	15497.4	5	Returned
	10	Delivered	60	75	3	28459.44	31403.52	29440.8	23552.64	5	Disruptive
	11	Returned	30		2	8283	8283	7730.8	9387.4	4	Returned
	12	Delivered	90	100	3	17558.72	21399.69	10974.2	13169.04	3	Late
	13	Canceled	45	46	1	11542.72	11542.72	8657.04	10460.59	5	Cancelled
	14	Delivered	15	15	4	30997.05	20369.49	29225.79	23912.01	2	On Time
	15	Delivered	30	30	4	20634.04	16212.46	22107.9	16949.39	2	On Time
	16	Canceled			5	16238.75	16238.75	24033.35	14939.65	4	Cancelled
	17	Delivered	45	40	2	7426.24	9363.52	9040.64	7426.24	5	Early
	18	Delivered	45	75	6	19417.97	13120.25	11545.82	11021.01	5	Disruptive
	19	Delivered	30	29	1	12918.32	12501.6	10834.72	8334.4	3	On Time
	20	Returned			5	30191.35	31053.96	31916.57	21565.25	5	Returned
	21	Delivered	30	32	2	24288.28	16411	18380.32	14441.68	2	On Time
	22	Delivered	30	29	4	1188.2	1960.53	1366.43	2198.17	4	On Time
	23	Delivered	45	40	6	32941.24	22283.78	36816.68	26159.22	2	Early
	24	Delivered	45	123	5	33989.46	19993.8	36988.53	34989.15	5	Disruptive
	25	Delivered	45	45	1	8770.8	8186.08	8770.8	10817.32	2	On Time
	26	Canceled			8	22857.49	19768.64	12355.

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

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment