Question

In: Accounting

A- 10.5 Use the following information relating to Shana Company to calculate the inventory turnover ratio...

A- 10.5 Use the following information relating to Shana Company to calculate the inventory turnover ratio and the number of days’ sales in inventory ratio.

year sales cost of sales average inventory
2021 22000 16500 2400
2022 28000 21000 3000
2023 33000 24750 3500
2024 35000 26250 4000

Solutions

Expert Solution

Formula of inventory turnover ratio
Inventory turnover ratio = cost of goods sold/average inventory
calculation of inventory turnover ratio
year 2021 cost of sale = 16500
average inventory = 2400
Inventory turnover ratio = 16500/2400 = 6.88
year 2022 cost of sale = 21000
average inventory = 3000
inventory turnover ratio = 21000/3000 = 7
year 2023 cost of sale = 24750
average inventory = 3500
inventory turnover ratio = 24750/3500 = 7.07
year 2024 cost of sale = 26250
average inventory = 4000
inventory turnover ratio = 26250/4000 = 6.56
number of days sale in inventory ratio = 365/inventory turnover ratio
no of days in a year = 365 days
year 2021 = 365/6.88 = 53.05 days
year 2022 = 365/7 = 52 days
year 2023 = 365/7.07 = 52.63 days
year 2024 = 365/6.56 = 55.62 days

answers are rounded off upto 2 decimal places


Related Solutions

A- 10.5 Use the following information relating to Shana Company to calculate the inventory turnover ratio...
A- 10.5 Use the following information relating to Shana Company to calculate the inventory turnover ratio and the number of days’ sales in inventory ratio. year sales cost of sales average inventory 2021 22000 16500 2400 2022 28000 21000 3000 2023 33000 24750 3500 2024 35000 26250 4000 b.PA3. 10.2 Trini Company had the following transactions for the month. N0. of Unit cost per unit total beginning inventory 1050 22$ 23100 purchased May 31 1020 23 23460 purchased Jul15 1300...
Current Ratio: Asset Turnover Ratio: Inventory Turnover Ratio: Days In Sales Inventory Ratio: Gross Margin Ratio:...
Current Ratio: Asset Turnover Ratio: Inventory Turnover Ratio: Days In Sales Inventory Ratio: Gross Margin Ratio: Earning Per Share Ratio: Discuss what each ratio indicates about company performance. What does each ratio “tell” about a company? Interpret the ratios and use the interpretation as a basis to analyze the operational effectiveness .
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000...
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000 and cost of goods sold of $1,713,635,000. Belt had the following balances: January 1 December 31 Inventories $301,500,000 $385,000,000 Required: Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. Round to two decimal places. times 3. Calculate the inventory turnover in days. Round to two decimal places. days
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio =...
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio = 1.80; current assets = $275. a. 50 b. 60 c. 80 d. 70 e. 40
Inventory Turnover and Days’ Sales in Inventory – W. Glass & Company reported the following information...
Inventory Turnover and Days’ Sales in Inventory – W. Glass & Company reported the following information in its recent annual report: 2015 2016 Cost of goods sold $4,000,000 $4,600,000 Beginning inventory $900,000 860,000 Ending inventory 860,000 640,000 Calculate the company’s inventory turnover and days’ sales in inventory for both years.
What is the inventory turnover ratio using each of the following methods:
QuarterUnitsPurchasedCost perUnitTotal1200$11$2,2002300123,6003300133,9004200142,8001,000$12,500Inventory at the beginning of the 1st quarter: 400 units at $10 per unit.Sales for the fiscal year: 800 units at $15 per unit.What is the inventory turnover ratio using each of the following methods:1. FIFO Method2. Average Cost Method3. LIFO Method
What is the relationship between the inventory turnover ratio and the "days of inventory"? For a...
What is the relationship between the inventory turnover ratio and the "days of inventory"? For a given amount of cost of goods sold, as inventory turnover ratio increases, the "days of inventory" cannot be predicted to increase or decrease increases initially increases, then decreases decreases
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
The steel company is trying to determine the effect of its inventory turnover ratio and days...
The steel company is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash flow cycle. Company’s sales last year (all on credit) were $150,000, and it earned a net profit of 6%, or $9,000. It turned over its inventory 7.5 times during the year, and its DSO was 36.5 days. Its annual cost of goods sold was $121,667. The firm had fixed assets totaling $35,000. Steel's payables deferral period is 40...
What insights can be gained from inventory ratio analysis, such as inventory turnover ratio and number...
What insights can be gained from inventory ratio analysis, such as inventory turnover ratio and number of days’ sales in inventory ratio?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT