Question

Double West Suppliers (DWS) reported sales for the year of $400,000, all on credit. The average gross profit percentage was 35 percent on sales. Account balances follow:

Beginning Ending
Accounts receivable (net) $ 51,000 $ 61,000
Inventory 67,000 46,000
Required:
1. Compute the following turnover ratios. (Round your answers to 1 decimal place.)
2. By dividing 365 by your ratios from requirement 1, calculate the average days to collect receivables and the average days to sell inventory. (Use 365 days in a year. Do not round intermediate calculations. Round turnover ratio calculation and final answers to 1 decimal place.)

Answer 1

1. Accounts Receivables Turnover Ratio = Net Credit Sales/Average Accounts Receivables = 400,000 / (51000 + 61000)/2

= 400,000/56,000

= 7.1 times

Inventory Turnover Ratio = Cost of Goods Sold/Average Inventory = (Sales-Gross Profit)/Average Inventory = (400,000 - 35% * 400,000) / (67000 + 46000)/2

=400,000 - 140,000 / 56,500

= 260,000 / 56,500

= 4.6 times

2. Average Days to Collect Receivables = 365/7.1 = 51.40 or 52 days

Average Days to Collect Inventory = 365/4.6 = 79.34 days