Purchase Solution

Inventory Turnover

Not what you're looking for?

Ask Custom Question

XYZ corporation reports the following data on their IS and BS:

Sales: 1,000,000.00
CoGS: 500,000.00
Gross Margin: 500,000.00
SG&A: 250,000
EBIT: 250,000
Interest: 150,000
EBT: 100,000
Taxes: 30,000
Net Income: 70,000

Balance Sheet (Simplified)

Assets

Inventory: 1,000,000
Other Current Assets: 2,000,000
Long Term Assets: 5,000,000
Total Assets: 8,000,000

Liabilities

Current Liabilities: 2,000,000
Long Term Debt: 3,000,000

Equity

Paid-In Capital: 1,000,000
Retained Earnings: 2,000,000

Total Liabilities and Equity: 8,000,000

In addition, the accounting department reports last years inventory balance was 3,000,000

Now the questions:

What are the inventory turns for the firm?
If the average turns in this same industry is 4x, is XYZ better or worse then average?

What must be done to improve inventory turns?

Purchase this Solution
Solution Summary

Response discusses the steps to compute the Inventory Turnover

Solution Preview

Now the questions:

What are the inventory turns for the firm?
If the average turns in this same industry is 4x, is XYZ better or worse then average?

What must be done to improve inventory turns?

Inventory Turnover = ...

Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Firm's Inventory Level and Inventory Turnover Ratio

    Solution: Inventory turnover ratio Sales Average inventory 1 Assuming that sales are $1000000 and inventory turnover ratio is 2 times: Average inventory = Sales Inventory turnover ratio

  • Working Capital

    Take a 360 day year Number of days in inventory = 360 / inventory turnover= 360/6.67 = 54 days (C) What is the account receivables turnover for 2003?

  • Cash conversion cycle

    (Cash conversion cycle) Auburn Hair Products has an inventory turnover of six times per year, a receivables turnover of 10 times, and a payables turnover of 12 times.

  • Inventory turnover comparison to industry leaders: Widget Inc.

    Inventory Turnover = 21500 / 1250 = 17.2 times b) Inventory / Assets = 1250 / 16600 = 7.53% c) Compared to industry leaders who have inventory turnover of 13 times, Widget Inc. has inventory turnover of 17.2 times.

  • Organic Grocers, Inc: Inventory turnover, performance to ind

    a) Inventory Turnover = COGS/Avg. Inventory. Organic Grocer's Inventory Turnover = 11,110,000/985,800 = 11.27 times per year. b) Organic Grocer's Inventory Turnover is less (worse) than the industry average.

  • Cash freed up

    We calculate the inventory levels at the two turnover rates Inventory Turnover = Sales/Inventory Inventory = Sales/Inventory Turnover At inventory turnover of 2, inventory = 10/2 = $5 million At inventory turnover of 5, inventory = 10/5=$2 million

  • Turnover Ratios

    Inventory turnover 3. Fixed asset turnover 4.

  • Inventory turnover rate

    Inventory turnover rate is how fast the inventory is being sold.

  • Freeing Up Cash by Increasing Inventory Turnover Ratio

    Inventory turnover = Sales/Inventory Inventory = Sales/Inventory Turnover With an inventory turnover of 2, the amount of inventory held was 10/2=$5 million With an inventory turnover of 5, the amount of inventory held will be 10/5 = $2 million The

  • Inventory turnover and Total Sales

    602909 Inventory turnover and Total Sales Baker Mfg. Inc. (see Table 11.9) wishes to compare its inventory turnover to those of industry leaders, who have turnover of about 13 times per year and 8% of their assets invested in inventory.

View More Related Solutions