Ask Operation Management Expert

Problem: Joe Henry, the sole owner and president of the Consolidated Electric Company, reflected on his inventory management problems. He was a major wholesale supplier of equipment and supplies to electrical contractors, and his business hinged on the efficient management of inventories to meet his customers' needs. While Henry had built a very successful business, he was nearing retirement age and wanted to pass along a good inventory management system. Henry's two sons-in-law were employed in the company. Carl Byerly, the older of the two, had a college degree in mathematics and was very interested in inventory formulas and computers. The other son-in-law, Edward Wright, had a degree in biology and was manager of one of the company's wholesale warehouses. Joe Henry started the Consolidated Electric Company in the 1940s and built it into a highly profitable business. In 2016 the company had achieved $10 million in sales and earned $1 million in pretax profits. Consolidated Electric was currently the twelfth largest electrical wholesaler in the country. Consolidated Electric operates through four warehouses in Iowa (Des Moines, Cedar Rapids, Sioux City, and Davenport). From these sites, contractors in Iowa, Minnesota, Nebraska, Wisconsin, Illinois, and Missouri are supplied with a wide range of electrical equipment, including wire, electrical boxes, connectors, lighting fixtures, and electrical controllers.

The company stocks 20,000 separate line items in its inventory purchased from 200 different manufacturers. (A line item is defined as a particular item carried at a particular location.) These items range from less than 1 cent each to several hundred dollars for the largest electrical controllers. Of the 20,000 line items, a great many are carried to provide a full line of service. For example, the top 2,000 items account for 50 percent of the sales and the bottom 10,000 items for only 20 percent. The remaining 8,000 items account for 30 percent of the sales. The company has continually purged its 20,000 inventory items to carry only those that are demanded at least once a year. As Henry says, "We live and die by good customer service at a reasonable selling price. If we do not meet this objective, the customer will go to another wholesaler or buy directly from the manufacturer." Henry explained that he currently managed inventory by using an "earn and turn" concept. According to this concept, the earnings margin multiplied by the inventory turn ratio must equal a constant value of 2.0. For example, if a particular electrical item costs $6 to purchase wholesale and is sold for $10, then the earnings margin is $4and the earn ratio for this item is $4/$10 = .40.

If this item has a turn ratio of 5 times a year (sales are 5 times the average inventory carried), then the product of earn and turn is .4(5) = 2.0. If another item earns more, it can turn slower; if it earns less, it must turn faster. Each year, Henry sets a target earn-turn ratio for the entire business and a value for each product line. These targets are based on the estimated costs of operations and the return-on-investment goal for the company. As stated above, the current target ratio for the business is 2.0. The purchasing agents and inventory managers at each location are measured by their ability to meet the target earn-turn ratios on their product lines. The actual ratios are reported monthly. Although earn-turn ratios work quite well in controlling profitability of the business and entire product lines, they do not work very well for individual inventory items. Some line items tend to be in excess supply, while others are often out of stock. The inventory is currently managed by use of a small computer system. A record for each item is kept and a clerk posts transactions on the record as units are received or issued, thus keeping a running on-hand inventory balance. Periodically, a purchasing agent reviews the records for a particular supplier. Then, using the order point and quantity stored on the record, the purchasing agent places an order for all items that are below their reorder point.

If the total quantities of all items required from a supplier do not meet the purchase discount minimums or a truckload lot, additional items near their reorder points are added to the order. This is not done when the total order size is too far from the minimums, since excessive inventories would build up. The order quantity and reorder point on each record are based on judgment and past experience. Generally speaking, a three-month supply is ordered for low-cost items and as little as a one-month supply for expensive items. Most lines are reviewed on a weekly basis. Consolidated Electric had been converting its inventory records to a new software system. At the present time, an on-hand balance is maintained on the computer, and an accurate history of all orders placed, receipts, and issues is kept. A demand history for a typical item. Henry was anxious to utilize the new system to calculate reorder points and order quantities, but he was unsure of the exact formulas to use. Using standard textbooks in the inventory field, Henry and Carl Byerly developed the formulas given in Exhibit 1.

2273_1.jpg

The EOQ formula utilizes a carrying cost of 28 percent and an ordering cost of $4.36 per order placed. These figures were based on past cost history at the company. The formulas were programmed into the computer and tested on a pilot basis. For some items the formulas seemed to work quite well, but for others they resulted in drastic departures from current practice and from common sense. For example, on one electrical box, the formulas would have ordered a two-year supply. Henry wanted to get the new software up as soon as possible, but he was not sure that the formulas would work properly. He wondered whether the formulas would meet the customer-service objectives of the business. Would they take advantage of truckload lots or purchase discounts whenever appropriate, and would the formulas result in reasonable inventory levels?

Questions

1. Design an inventory control system for this business. Provide the formulas that you would use for a P System, Q system or other system you design. Compare these to the formulas currently used. Examine the data from the Appendix to note any peculiarities in demand that your system might encounter. What would you do about them?

2. Describe how the system you have designed will help the company meet customer-service and cost objectives.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92748742

Have any Question?


Related Questions in Operation Management

Conflictdefine functional versus dysfunctional conflict in

Conflict Define functional versus dysfunctional conflict in a work group and explain how you can increase functional conflict and decrease dysfunctional conflict. Develop a response that includes examples and evidence to ...

For this assignment you will need to find 2 articles in

For this assignment, you will need to find 2 articles in business that can help describe what are IT strategic initiative being undertaken by an organization are like. Choose a different organization for each of the arti ...

Coping with problems joe is a little nervous he has just

Coping With Problems Joe is a little nervous. He has just been transferred from another plant to take over a production line. Production is down and there is a serious problem with absenteeism. To make matters worse, the ...

Over 30 years ago michael porter identified a holistic

Over 30 years ago Michael Porter identified a holistic approach to understanding how competitive forces shape strategy. He posited that the only way to truly insulate an organization from underlying economic volatility i ...

You are the contracting officer for an air-to-ground

You are the contracting officer for an air-to-ground missile development program. A contract for pre-production models of the missile was awarded by your predecessor and the contractor is behind schedule. In a program me ...

The ikea case provides an excellent opportunity to apply

The IKEA case provides an excellent opportunity to apply strategic management concepts to a large privately-held company that is expanding into India. IKEA is a Netherlands-based Swedish company with a presence in 44 cou ...

Can you answer for me the following questions about social

Can you answer for me the following questions about social loafing and the three main causes of free-riding. 1. Give a description of the phenomenon of social loafing. 2. Give a description of the phenomenon of free-ridi ...

1 analyzing the bridgestonefirestone and ford motor company

1. Analyzing the Bridgestone/Firestone and Ford motor company, is it sufficient to use the ISO/QS 9000 standards as the main basis of vendor/product selection? 2. What position to these cars company ( 1. Volkswagen, 2. F ...

Research the effect of primary and secondary seat belt laws

Research the effect of primary and secondary seat belt laws on the occurrence of motor-vehicle injuries and fatalities. Explain how epidemiologic studies influenced the development of current seat belt laws. Describe how ...

Please provide a brief paragrap of the key takaways from

Please provide a brief paragrap of the key takaways from each of the following topics: Designing Clear Visuals in business reports Designing Successful Documents and Websites Writing Winning Proposals

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As