Inventory Levels :-
Months | Sales (A) | Retail Stock (B) | Stock-Sales Ratio (B/A) |
1 | $10000 | $30000 | 3 |
2 | $11000 | $32000 | 2.91 |
3 | $13000 | $36000 | 2.77 |
4 | $16000 | $37000 | 2.31 |
5 | $19000 | $34000 | 1.79 |
6 | $9000 | $22000 | 2.44 |
7 | $11000 | $32000 | 2.91 |
8 | $13000 | $31000 | 2.38 |
9 | $16000 | $37000 | 2.31 |
10 | $19000 | $31000 | 1.63 |
11 | $21000 | $29000 | 1.38 |
12 | $25000 | $34000 | 1.36 |
EOM | $19500 | ||
Totals | $183000 | $404500 | |
Average Inventory | $24750 | ||
Stock Turnover Rate | 7.39 times |
Average Inventory = (Beginning Stock + Ending Stock)/2
= ($30000 + $19500)/2
= $49500/2
= $24750
Stock Turnover Rate = Total Sales / Average Inventory
= $183000 / $24750
= 7.39 times
1. Calculate the annual stock turnover rate based on the following monthly sales and inventory figures....
BusinessCourse Inventory Turnover The following financial data is from Brenner Instruments' financial statements (thousands of dollars, except earnings per share.) 2019 Sales revenue $210,000 Cost of goods sold 125,000 Net income 8,300 Dividends 2,600 Earnings per share 4.15 Support BusinessCourse (usanus of DOllars) Dec. 31, 2019 Dec. 31, 2018 Assets Cash $18,300 $18,000 Accounts receivable (net) 41,000 46,000 39,500 Inventory 43,700 Total current assets 103,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 $172,000 $167,000 Total assets Liabilities...
Required: 1. Calculate the following six (6) ratios: Current Ratio, Quick Ratio, Receivables Turnover Ratio, Inventory Turnover Ratio, Profit Margin Ratio and Debt to Assets Ratio. Be sure to show the actual calculation as well as your final answer You are only required to calculate the ratios for 2017, however, for two of the ratios (Receivables Turnover Ratio and Inventory Turnover Ratio), you will need data from 2016 for the formula When calculating the Quick Ratio, please note that Short-Term...