Inventory Turnover Ratio Ending Inventory (Dec. 31st) $126,000 Month Ending Inventory Cost of Goods Sold Inventory Turnover Ratio January $53,000 $89,000 February $80,000 $1,220,000 March $90,000 $980,000 April $50,000 $770,000 May $73,000 $930,000 June $81,000 $860,000 July $158,000 $558,000 August $216,000 $1,328,000 September $66,000 $982,000 October $104,000 $850,000 November $169,000 $1,290,000 December $101,000 $1,010,000 Total COGS Average monthly inventory Annual Inventory Ratio
Inventory Turnover Ratio Ending Inventory (Dec. 31st) $126,000 Month Ending Inventory Cost of Goods Sold Inventory Turnover Ratio January $53,000 $89,000 February $80,000 $1,220,000 March $90,000 $980,000 April $50,000 $770,000 May $73,000 $930,000 June $81,000 $860,000 July $158,000 $558,000 August $216,000 $1,328,000 September $66,000 $982,000 October $104,000 $850,000 November $169,000 $1,290,000 December $101,000 $1,010,000 Total COGS Average monthly inventory Annual Inventory Ratio
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 11E
Related questions
Question
Suppose that a firm has an ending inventory of $126,000 as of December 31, 2012. The accounting information for 2013 has been collected in the Microsoft Excel Online file below. Complete the spreadsheet.
Inventory Turnover Ratio | |||
Ending Inventory (Dec. 31st) | $126,000 | ||
Month | Ending Inventory | Cost of Goods Sold | Inventory Turnover Ratio |
January | $53,000 | $89,000 | |
February | $80,000 | $1,220,000 | |
March | $90,000 | $980,000 | |
April | $50,000 | $770,000 | |
May | $73,000 | $930,000 | |
June | $81,000 | $860,000 | |
July | $158,000 | $558,000 | |
August | $216,000 | $1,328,000 | |
September | $66,000 | $982,000 | |
October | $104,000 | $850,000 | |
November | $169,000 | $1,290,000 | |
December | $101,000 | $1,010,000 | |
Total COGS | |||
Average monthly inventory | |||
Annual Inventory Ratio |
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337272124/9781337272124_smallCoverImage.gif)
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337272124/9781337272124_smallCoverImage.gif)
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
![Financial Accounting: The Impact on Decision Make…](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning