Question

The following information was available for the year ended December 31, 2016: Net sales $ 857,750 Cost of goods sold 609,550 Average accounts receivable for the year 39,900 Accounts receivable at year-end 29,400 Average inventory for the year 174,000 Inventory at year-end 157,800
Required:
a. Calculate the inventory turnover for 2016. (Round your answer to 2 decimal places.)
b. Calculate the number of days' sales in inventory for 2016, using year-end inventories. (Use 365 days a year. Round your answer to 1 decimal place.)
c. Calculate the accounts receivable turnover for 2016. (Round your answer to 1 decimal place.)
d. Calculate the number of days' sales in accounts receivable for 2016, using year-end accounts receivable. (Use 365 days a year. Round your answer to 1 decimal place.)

Answer 1

Answer:Inventory turnover = 3.50 Times

Number of days sales in inventory= 94.5 Days

Accounts Receivable Turnover = 21.5 Times

Number of days sales in accounts receivable =12.5 days

Explanation:

a) Inventory turnover  = Cost of goods sold / Average inventory

$609,550 / $174,000 = 3.50 Times

b)Number of days sales in inventory = inventory at year end / Cost of goods sold x 365

$157,800 / $609,550  x 365 = 94.49≈94.5 Days

.

c)Accounts Receivable Turnover  = Net sales / Average accounts Receivable  for the year

$857,750/$39,900 = 21.49≈ 21.5 Times

d)Number of days sales in accounts receivable = end of year Accounts Receivable / Net credit sales x 365

$29,400 / $857,750  x  365 = 12.51 ≈ 12.5 days