A company reported the following data:
Year 1 | Year 2 | |
Cost of goods sold | $317,500 | $279,100 |
Average inventory | 72,000 | 93,000 |
Required:
1. Calculate the company's merchandise inventory turnover for each year,
2. Comment on the company's efficiency in managing its inventory.
1.
For year 1
Merchandise inventory turnover = Cost of goods sold/ Average inventory
= 317,500/72,000
= 4.41 times ( round off to two decimals)
For year 2
Merchandise inventory turnover = Cost of goods sold/ Average inventory
= 279,100/93,000
= 3.00 times ( round off to two decimals)
2.
Inventory turnover has decreased in year 2. Decrease in inventory turnover indicates that the company is not managing its inventory efficiency.
Kindly comment if you need further assistance. Thanks‼!
Required information The following information applies to the questions displayed below! Laker Company reported the following January purchases and sales data for its only product. Activities Jan. 1 Beginning inventory Jan 10 Sales Jan, 20 Purchase zon, 25 sales. Units Acquired at Cost Units sold at Retail 190 its 56.0 840 100 units $15 60 units @ $5.00 80 units $15 110 units $4.50 380 units $1.950 Required: The Company uses a periodic inventory system. For specific identification, ending inventory...
E6-15 Lewis Incorporated and Clark Enterprises report the following amounts for the year. Clark 50,000 60,000 235,000 60,000 Lewis Inventory (beginning) 24,000 Inventory (ending) Purchases Purchase returns 18,000 261,000 5,000 Required: 1. Calculate cost of goods sold for each company. 2. Calculate the inventory turnover 3. Calculate the average days in inventory for each company. 4. Explain which company appears to be managing its inventory more efficiently. ratio for each company.
Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 255 units, where 230 are from the January 30 purchase, 5 are from the January 20 purchase, and 20 are from beginning inventory. Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of...
4. Chodia Company reported the following data for 2013 Cost of Beginning Inventory Invoice Cost of merchandise purchases: Purchase Returns and Allowances Purchase Discounts received: Cost of Transportation in: Cost of merchandise sold to customers in sales transactions $ 25,000 550,000 25,000 10,000 15,000 $330,000 Determine Chodia Company's Balance of Ending Inventory 5. Brill Company reported the following year end amounts:
Lopez Company reported the following current-year data for its only product. The company uses a periodic inventory system and its ending inventory consists of 360 units-120 from each of the last three purchases Dan. 1 Beginning inventory Mar. 7 Purchase July 28 Purchase Oct. 3 Purchase Dec. 19 Purchase 220 units $2.80$616 480 units$3.251,560 1,120 units $3.303,696 1,000 units$3.603,600 400 units $4.10 1,640 Totals 3,220 units $ 11,112 Determine the cost assigned to ending inventory and to cost of goods...
Flora's Gifts reported the
following current-month data for its only product. The company uses
a periodic inventory system, and its ending inventory consists of
74 units—57 units from the January 6 purchase, and 17 units from
the January 25 purchase. Jan. 1 Beginning inventory 170 units @
$3.60 = $ 612.00 Jan. 6 Purchase 350 units @ $3.60 = 1,260.00 Jan.
17 Purchase 575 units @ $3.20 = 1,840.00 Jan. 25 Purchase 30 units
@ $2.70 = 81.00 Totals 1,125...
Part I Jason Company uses a perpetual inventory system and reported the following transactions involving inventory during the month of December 2018: December 1 Beginning inventory 4 Purchases 13 Sales 21 Purchases 26 Sales 30 Purchases 100 units 200 units 150 units 300 units 375 units 400 units @ $8.00 @ $8.25 @ $11.20 @ $8.50 @ $11.20 @ $8.75 Required: (Show all workings and rounded amounts to one decimal place of a dollar) a. Calculate the Cost of Goods...
The 2021 income statement of Anderson Medical Supply Company
reported net sales of $11 million, cost of goods sold of $5.7
million, and net income of $845,000. The following table shows the
company's comparative balance sheets for 2021 and 2020:
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost of goods sold of $5.7 million, and net income of $845,000. The following table shows the company's comparative balance sheets for 2021 and 2020:...
Dollar General Corporation operates general merchandise stores
that feature quality merchandise at low prices to meet the needs of
middle-, low-, and fixed-income families in southern, eastern, and
midwestern states. For the year ended January 29, 2016, the company
reported average inventories of $2,900 (in millions) and an
inventory turnover of 4.83. Average total fixed assets were $2,190
(million) and the fixed asset turnover ratio was 9.32.
1-a. Calculate Dollar General’s net sales and
cost of goods sold.
1-b. Calculate...
Laker Company reported the following January purchases and
sakes data for its only product
Required information (The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. old at Retail Units Acquired at Cost 165 units@ $9.00 - $1,485 125 units $18.00 - Activities Jan 1 Beginning inventory Jan 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 110 units $8.00 125 units $18.00 $2.50...