While reviewing the data in the ARTable you notice that the company's aging categories are not the industry standard.Therefore, you need to add a column to the table to calculate the industry standard aging categories.This will allow you to evaluate the receivables against other companies in the same industry.

The industry standard aging categories are

Not due (< 0 days outstanding)

Current (0 to 30 days outstanding)

31 to 60 days

61 to 90 days

91 to 180 days

Greater than 180 days

Use the column called days OS to determine each aging category

Name the new column Typical Aging