GURUFOCUS.COM » STOCK LIST » Consumer Cyclical » Retail - Cyclical » Wesfarmers Ltd (OTCPK:WFAFY) » Definitions » Inventory Turnover

Wesfarmers (Wesfarmers) Inventory Turnover : 2.42 (As of Dec. 2023)


View and export this data going back to 2008. Start your Free Trial

What is Wesfarmers Inventory Turnover?

Inventory Turnover measures how fast the company turns over its inventory within a year. It is calculated as Cost of Goods Sold divided by Total Inventories. Wesfarmers's Cost of Goods Sold for the six months ended in Dec. 2023 was $9,888 Mil. Wesfarmers's Average Total Inventories for the quarter that ended in Dec. 2023 was $4,093 Mil. Wesfarmers's Inventory Turnover for the quarter that ended in Dec. 2023 was 2.42.

Days Inventory indicates the number of days of goods in sales that a company has in the inventory. Wesfarmers's Days Inventory for the six months ended in Dec. 2023 was 75.55.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Wesfarmers's Inventory-to-Revenue for the quarter that ended in Dec. 2023 was 0.27.


Wesfarmers Inventory Turnover Historical Data

The historical data trend for Wesfarmers's Inventory Turnover can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Wesfarmers Inventory Turnover Chart

Wesfarmers Annual Data
Trend Jun14 Jun15 Jun16 Jun17 Jun18 Jun19 Jun20 Jun21 Jun22 Jun23
Inventory Turnover
Get a 7-Day Free Trial Premium Member Only Premium Member Only 3.21 4.76 5.24 4.27 4.66

Wesfarmers Semi-Annual Data
Jun14 Dec14 Jun15 Dec15 Jun16 Dec16 Jun17 Dec17 Jun18 Dec18 Jun19 Dec19 Jun20 Dec20 Jun21 Dec21 Jun22 Dec22 Jun23 Dec23
Inventory Turnover Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 2.13 2.10 2.32 2.18 2.42

Wesfarmers Inventory Turnover Calculation

Wesfarmers's Inventory Turnover for the fiscal year that ended in Jun. 2023 is calculated as

Inventory Turnover (A: Jun. 2023 )
=Cost of Goods Sold / Average Total Inventories
=Cost of Goods Sold (A: Jun. 2023 ) / ((Total Inventories (A: Jun. 2022 ) + Total Inventories (A: Jun. 2023 )) / count )
=19399.329 / ((4275.474 + 4053.02) / 2 )
=19399.329 / 4164.247
=4.66

Wesfarmers's Inventory Turnover for the quarter that ended in Dec. 2023 is calculated as

Inventory Turnover (Q: Dec. 2023 )
=Cost of Goods Sold / Average Total Inventories
=Cost of Goods Sold (Q: Dec. 2023 ) / ((Total Inventories (Q: Jun. 2023 ) + Total Inventories (Q: Dec. 2023 )) / count )
=9888.22 / ((4053.02 + 4133.869) / 2 )
=9888.22 / 4093.4445
=2.42

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Wesfarmers  (OTCPK:WFAFY) Inventory Turnover Explanation

Inventory Turnover measures how fast the company turns over its inventory within a year. A higher Inventory Turnover means the company has light inventory. Therefore the company spends less money on storage, write downs, and obsolete inventory. If the inventory is too light, it may affect sales because the company may not have enough to meet demand.

1. Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Wesfarmers's Days Inventory for the six months ended in Dec. 2023 is calculated as:

Days Inventory =Average Total Inventories (Q: Dec. 2023 )/Cost of Goods Sold (Q: Dec. 2023 )*Days in Period
=4093.4445/9888.22*365 / 2
=75.55

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Wesfarmers's Inventory to Revenue for the quarter that ended in Dec. 2023 is calculated as

Inventory-to-Revenue=Average Total Inventories (Q: Dec. 2023 ) / Revenue (Q: Dec. 2023 )
=4093.4445 / 15137.216
=0.27

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Be Aware

Usually retailers pile up their inventories at holiday seasons to meet the stronger demand. Therefore, the inventory of a particular quarter of a year should not be used to calculate Inventory Turnover. An average inventory is a better indication.


Wesfarmers Inventory Turnover Related Terms

Thank you for viewing the detailed overview of Wesfarmers's Inventory Turnover provided by GuruFocus.com. Please click on the following links to see related term pages.


Wesfarmers (Wesfarmers) Business Description

Traded in Other Exchanges
Address
123 St Georges Terrace, Level 14, Brookfield Place Tower 2, Perth, WA, AUS, 6000
Wesfarmers is Australia's largest conglomerate. Its retail operations include the Bunnings hardware chain (number one in market share), discount department stores Kmart and Target (number one and three) and Officeworks in office supplies (number one). These activities account for the vast majority of group earnings before taxes. Other operations include chemicals, fertilisers, industrial and medical gases, LPG production and distribution, and industrial and safety supplies. Management is focused on generating cash and creating shareholder wealth in the long term.

Wesfarmers (Wesfarmers) Headlines