Fill This Form To Receive Instant Help
Homework answers / question archive / In the table below is data for two companies in a competitive industry
In the table below is data for two companies in a competitive industry. ($000) Company A Company B Revenues(sales) 132470 93440 Cost of Goods Sold 43645 49828 Average inventory 7358 8714 Average receivable 5551 7318 Average payable 7054 8663 Calculate the turnover ratios and evaluate the relative performance (operating efficiency) of both companies.
The turnover ratios are calculated as below:
Accounts Receivable Turnover Ratio
The value of accounts receivable turnover ratio for each company is calculated as below:
Accounts Receivable Turnover Ratio = Net Sales/Average Receivable
Using the values provided in the question, we get,
Company A = 132,470/5,551 = 23.86
Company B = 93,440/7,318 = 12.77
_____
Inventory Turnover Ratio
The value of inventory turnover ratio for each company is determined as follows:
Inventory Turnover Ratio = Cost of Goods Sold/Average Inventory
Using the values provided in the question, we get,
Company A = 43,645/7,358 = 5.93
Company B = 49,828/8,714 = 5.72
_____
Accounts Payable Turnover Ratio
The value of accounts payable turnover ratio for each company is arrived as below:
Accounts Payable Turnover Ratio = Cost of Goods Sold/Average Payable
Using the values provided in the question, we get
Company A = 43,645/7,054 = 6.19
Company B = 49,828/8,663 = 5.75
_____
Evaluation:
Based on the values calculated above, it can be concluded that Company A is operating more efficiently than Company B. This is evident from the fact that Company A is able to collect its receivables faster than Company B as it has a high accounts receivable turnover ratio of 23.86. Inventory turnover ratio indicates how quickly the company is able to sell its inventory and replace it. Again, for Company A, this ratio is higher at 5.93 as compared to Company B having a ratio of 5.72. Further, Company A is able to pay its suppliers more quickly as compared to Company B. This is indicated by the value of high accounts payable turnover ratio for Company A (6.19) when compared with Company B (5.75).