Question

A company reported the following data:

A company reported the following data:

      


Year 1Year 2
Cost of goods sold$317,500$279,100
 Average inventory72,00093,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 0
Add a comment Improve this question Transcribed image text
Answer #1

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‼!

Add a comment
Know the answer?
Add Answer to:
A company reported the following data:
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required information The following information applies to the questions displayed below! Laker Company reported the following...

    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...

    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.

     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...

    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 p...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT