The Marlin Company operates 50 weeks a year, and its cost of goods sold last year was $1,800,000. The firm carries six items in inventory: three raw materials, two work-in-process items, and one finished good. The following table shows the company’s last year’s average inventory levels for these items, along with their unit values.
Category Part Number Average Inventory Units Value per Unit
Raw Materials RM-1 1750 $15
RM-2 1500 $ 20
RM-3 1900 $ 10
Work-in-process WIP-1 1500 $40
WIP-2 1300 $50
Finished Goods FG-1 1000 $120
a. What is their average aggregate inventory value?
b. How many weeks of supply does the firm have?
c. What was their inventory turnover last year?
d. The turnover ratio is widely used because it is a common measure that links to the financial statements of the firm. Discuss the benefits and drawbacks of using this measure.