Ivanhoe Electronics has enjoyed tremendous sales growth during the last 10 years. However, even though...

90.2K

Verified Solution

Question

Accounting

Ivanhoe Electronics has enjoyed tremendous sales growth during the last 10 years. However, even though sales have steadily increased, the company's CEO, Helen Martin, is concerned about certain aspects of its performance. She has called a meeting with the corporate controller and the vice presidents of finance, operations, sales, and marketing to discuss the company's performance. Helen begins the meeting by making the following observations:
We have been forced to take significant write-downs on inventory during each of the last three years because of obsolescence. In addition, inventory storage costs have soared. We rent four additional warehouses to store our increasingly diverse inventory. Five years ago inventory represented only 20% of the value of our total assets. It now exceeds 35%. Yet, even with all of this inventory, "stockouts" (measured by complaints by customers that the desired product is not available) have increased by 40% during the last three years. And worse yet, it seems that we constantly must discount merchandise that we have too much of.
Helen asks the group to review the following data and make suggestions as to how the company's performance might be improved.
\table[[(in millions),2027,2026,2025,2024],[Inventory],[Raw materials,$264,$214,$166,$129],[Work in process,121,90,53,35],[Finished goods,608,526,430,251],[Total inventory,$993,$830,$649,$415],[Current assets,$ 1,944,$1,530,$1,282,$826],[Total assets,$2,856,$2,718,$2,598,$2,050],[Current liabilities,$648,$640,$574,$408],[Sales revenue,$10,188,$9,361,$8,143,$6,705],[Cost of goods sold,$ 6,840,$5,905,$4,802,$3,485],[Net income,$813,$1,070,$1,063,$937]]
Compute the current ratio, gross profit rate, profit margin, inventory turnover, and days in inventory for 2025,2026, and 2027.(Round current ratios to 2 decimal places, e.g.15.21, and all other answers to 1 decimal place, e.g.15.2. Use 365 days for calculation.)
\table[[,2027,2026,2025],[urrent Ratio,:1,:1,:1 SOLVE FOR THE INVENTORY TURNOVER AND DAYS IN INVENTORY FOR 2025,2026 and 2027, thank you.
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students