Answer:
EBI Solar
a. Weeks of supply = 14.05 weeks
b. Inventory turnover = 20.5x
Weeks of supply = 2.5 weeks
Explanation:
a) Data and Calculations:
Inventory turnover = 3.7 x
Cost of goods sold = $2.8 million
Average inventory = $756,757 ($2,800,000/3.7)
Current value of inventory:
Raw materials = $95,000
Work-in-process 26,000
Finished goods 15,800
Total = $136,800
a. Weeks of supply = 14.05 weeks (52/3.7)
b. Inventory turnover = 20.5x ($2,800,000/$136,800)
Weeks of supply = 2.5 weeks (52/20.5)