The following data are pulled from a recent Walsh Manufacturing annual report

Assets
Raw material inventory $120,000
Work-in-process inventory $50,000
Finished goods inventory $300,000
Property, plant & equipment $500,000
Other assets $200,000
Total assets $1,170,000

Condensed Income Statement
Revenue $2,000,000
Cost of goods sold $600,000
Other expenses $1,000,000
Net income $400,000

Calculate: (a) Percent invested in inventory, (b) Inventory turnover, and (c) Weeks of supply.

(a) Percent invested in inventory = (120,000 + 50,000 + 300,000 )/1,170,000 = 40.17%
(b) Inventory turnover = 600,000/(120,000 + 50,000 + 300,000 ) = 1.28
(c) Weeks of supply = (120,000 + 50,000 + 300,000 ) /(600,000/52 ) = 40.73

Business

You might also like to view...

According to Geert Hofstede, which of the following is a key cultural dimension that helps account for rapid economic growth in Asia?

A) power distance B) individualist/collectivist C) feminine/masculine D) uncertainty avoidance E) long-term orientation

Business

How can the ACE process help a writer when submitting an online proposal?

What will be an ideal response?

Business