- Column A: the customer ID

- Column B: the total sale on account and invoiced during the year

- Column C: the account receivable balance outstanding at year-end

- Column D: the date when the invoice was issued

- Column E: the date when the invoice balance was paid off in the following year

Assume that if the receivable was not paid over the course of the following year, the entire amount would be written off. In that case, the corresponding cell in column E remains blank.

Assume four categories of aging receivables: (1) 0-30 days outstanding, (2) 31-60 days outstanding, (3) 61-90 days outstanding, and (4) above 90 days outstanding.

Calculate the percentage of account receivables written off out of total credit sales.

Calculate the percentage of account receivables written off in each category of outstanding receivable age (think about which dates are relevant when assigning the categories of aging receivables).

Collect the data for year 2013 (total outstanding receivables, percentage of receivables written off relative to credit sales, and the percentage of receivables written off in each aging category of outstanding receivables), and fill in the table in the Solution worksheet.

Solution worksheet:

Year	Total Outstanding Receivables	Percent of sales on account written off	Percent of outstanding receivables written off by receivale age group
			0-30	31-60	61-90	over 90
2013

2013:

	Date:	12/31/13
customer	total sales to customer	amount	date purchased	date paid
1	49,423	4,977	11/16/13	1/29/14
2	118,146	46,731	10/27/13	1/17/14
3	211,035	148,895	9/15/13	4/5/14
4	202,255	143,924	10/11/13	1/11/14
5	159,176	93,809	12/20/13	1/8/14
6	195,815	122,519	9/17/13	1/31/14
7	183,171	141,476	10/18/13
8	88,028	82,247	11/20/13	1/29/14
9	79,707	16,131	11/21/13	1/22/14
10	238,133	143,035	9/25/13	2/5/14
11	115,372	83,146	12/25/13	2/14/14
12	185,606	112,701	12/17/13	1/12/14
13	56,385	54,179	10/19/13	1/5/14
14	48,152	37,620	12/5/13	1/17/14
15	154,166	103,228	11/16/13	1/24/14
16	91,514	21,447	12/13/13	1/28/14
17	99,944	92,014	9/9/13	1/24/14
18	93,471	28,338	10/16/13	1/30/14
19	69,726	63,932	12/11/13	2/1/14
20	120,488	96,210	11/9/13	1/16/14
21	95,294	91,129	9/26/13	4/3/14
22	38,827	22,197	9/5/13	2/18/14
23	155,182	65,426	9/26/13	3/1/14
24	162,412	128,150	11/7/13	1/27/14
25	41,944	16,802	9/8/13	2/6/14
26	165,696	118,454	10/16/13	1/25/14
27	141,724	118,424	11/2/13	1/25/14
28	72,976	15,440	11/12/13	1/27/14
29	86,234	29,649	10/2/13
30	38,384	33,786	9/13/13	4/4/14
31	175,695	90,911	12/7/13	1/16/14
32	193,933	142,327	11/11/13	1/19/14
33	195,492	114,385	10/23/13	1/28/14
34	125,115	63,613	10/7/13	1/26/14
35	203,057	131,297	12/25/13	1/15/14
36	140,077	95,271	12/2/13	1/13/14
37	175,431	124,638	12/18/13	1/1/14
38	45,205	13,640	11/12/13	1/30/14
39	88,547	76,936	9/26/13
40	207,184	136,081	9/14/13
41	124,949	105,344	10/30/13	1/10/14
42	150,735	128,338	9/24/13	4/5/14
43	144,466	44,572	11/19/13	1/18/14
44	143,920	76,541	11/1/13	1/27/14
45	183,049	147,324	9/29/13	3/28/14
46	125,342	49,071	11/12/13	1/19/14
47	154,430	113,159	9/16/13	1/1/14
48	97,452	29,571	11/29/13	1/29/14
49	14,671	10,322	9/20/13	1/24/14
50	233,031	145,005	9/3/13	2/5/14

Please show work.

Thank you so much!