Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Odis Mullenax is the owner and President of Mullenax Automobile Parts Inc. His company makes various parts for major automobile manufacturers worldwide. They manufacture intake
Odis Mullenax is the owner and President of Mullenax Automobile Parts Inc. His company makes various parts for major automobile manufacturers worldwide. They manufacture intake manifold systems, air induction systems, coolant pump modules, oil filtration systems, coil springs, stabilizer bars, precision springs, and other key components within their three business units. Mullenax Automobile Parts is one link in a very long supply chain. Odis understands that the supply chain is not a single line of suppliers and buyers. Odis knows that the supply chain is more like a complex web where inputs come from multiple directions, often appearing unrelated to one another.
Odis has been working with Estella Epperson, Vice President of Operations, to ensure their supply chain management techniques are as robust as possible. To date, they have tackled demand forecasting and resource planning systems. They are ready to look at their inventory management capabilities. Inventory is extremely important because it is money sitting on the shelf. Consequently, they want to produce sufficient inventory to meet the customers' demands while ensuring the inventory turns over.
Inventory is managed by Madie Mcconke, Director of Inventory Management. Madie is well known throughout the automotive industry as a top inventory specialist. Madie takes several approaches to ensure they have sufficient inventory while always focusing on generating high inventory turnover. As mentioned previously, inventory is money sitting on the shelf. Madie understands that frequent turnover is a big positive because it enables Mullenax Automobile Parts to increase cash flow and reduce warehousing and carrying costs.
Odis and Estella schedule a meeting with Madie. They request that she present the current status of Mullenax's inventories. For example, they want to know if their inventory turnover ratio is good compared to other companies in the automotive industry. Furthermore, what system is Mullenax using to guarantee the lowest possible annual inventory cost?
As Madie pulls together information for the presentation, she focuses on two main items: Economic Order Quantity EOQ and Inventory Turnover Ratio. Madie uses the following data to build her illustrations to support her explanations concerning how Mullenax inventories are managed: the weekly requirement of one part is units, the order cost is $ per order, the holding cost is $ per unit per year, and the part cost is $ per unit. The firm operates fiftytwo weeks per year. Madie has her assistant use the data to compute various inventory statistics. Other data Madie had available were the cost of revenue or cost of goods sold $ and the average inventory $; therefore, she has the data required for the inventory turnover ratio. Madie also had last year's inventory turnover ratio for Ford General Motors and Toyota Since Mullenax Automobile Parts was dependent on the production and sales of the major
Weekly requirement
Setup cost
Holding cost
Unit cost
Number of weeks per year
units
$ per order
$ per unit per year
$ per unit
Annual requirement in units
EOQ units
Annual holding cost
Annual order cost
Annual purchase cost
Total annual inventory cost
Cost of goods sold
$
Average inventory
$
Inventory turnover ratio
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started