Preview

Consolidated Electric Case Study

Good Essays
Open Document
Open Document
845 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Consolidated Electric Case Study
Richard Temple

Consolidated Electric Case Study

3/30/2012

Consolidated Electric Case Study

1. Design an inventory control system for Consolidated Electric based on the case.

Consolidated has a few problems with their inventory control. They have a purchasing agent doing periodic checks of their inventory without reviewing their history and the demand. The lack of a computer inventory system is another problem that Consolidated must address. To design a system for consolidated the company needs to make some changes to its structure and organization.

Consolidated needs to have a central warehouse location with small regional supply centers because it would be easier to supply one warehouse than four. Des Moines needs to be the central location because it is in the middle of Iowa and within an hour of all three supply centers. Consolidated should move away from earn and turn concept when dealing with inventory management. Inventory stock needs to be evaluated on a daily basis with a periodic review system to examine the movement of goods from the warehouse. They should also have a min max inventory level adjusted with lead times so replenishment can be swift and stock outs can be avoided. The more expensive the item a surcharge should be added for maintaining a stock of the item.

The ABC inventory management method should be used for inventory control on the slow selling items. When one of the items in the bottom 50 percent of the product lines is up for replenishment it should be evaluated for profitability. After evaluating the product make a decision to continue or discontinue warehousing the item.

2. Write a one-to two-page paper describing how the system you have designed will help the company meet customer-service and cost objectives.

Consolidated must have a computer for inventory control and to track inventory histories. Monitoring history can show trends in the movement of

You May Also Find These Documents Helpful

  • Powerful Essays

    The purpose of this group assignment is to collaborate as a team to compare different inventory systems and describe the advantage and disadvantages of each system in comparison to the others. Management of inventory is important to any business that wants to succeed. Companies purchase inventory systems to help manage the inventory of an organization. Team A reviewed the following companies and their inventory management programs: Best Buy, , and . This Inventory System Summary includes a description of the chosen companies and their inventory systems, and a comparison describing the advantages and disadvantages of each system. Best Buy…

    • 2054 Words
    • 59 Pages
    Powerful Essays
  • Good Essays

    Currently inventory and control is a paper based inventory management system that has become outdated and obsolete. The system is a seven step process that includes a separate document for each step. These steps or processes are expensive and time consuming, and hinder future growth toward expanding into a global organization. The seven steps are; 1) Receiving documentation; 2) Scheduled orders documentation; 3) Orders received documentation; 4) Raw materials/sub-assemblies documentation; 5) Sub-assembly/final product documentation; 6) Sales order form documentation; 7) Shipping documentation. Along with each of these steps an inventory technician is responsible for putting the information into a computer, which could conceivably be seen as 14 separate steps.…

    • 841 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Adjunct Professor

    • 1156 Words
    • 5 Pages

    | The purpose of this assignment is to prepare for subsequent assignments in this course. Research one inventory system per team member used in an organization with which you are familiar. Collect four years of inventory data from…

    • 1156 Words
    • 5 Pages
    Powerful Essays
  • Best Essays

    Qrb 501 Week 2

    • 1899 Words
    • 8 Pages

    References: Atkinson, C. (2005, May 9). Today’s Inventory Management. Retrieved September 19, 2010, from http://www.inventorymanagementreview.org/strategy/…

    • 1899 Words
    • 8 Pages
    Best Essays
  • Good Essays

    Inventory Management

    • 333 Words
    • 2 Pages

    2. Indicate the type of inventory issues the firm has such as stock out costs, carrying costs, order quantity issues, safety stock and EOQ issue. In your opinion, is their system appropriate for the firm’s business?…

    • 333 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Alliance Supermarkets

    • 755 Words
    • 4 Pages

    A positive element of the firm’s procedural design is that Alliance utilizes a periodic inventory system, as opposed to perpetual inventory systems, which allows for inventory levels to be updated following the completion of each transaction, resulting in a more accurate inventory measurement on a daily basis. For this kind of business, continuous monitoring can be quite advantageous when multiple area locations are in operation, as it allowed for “item locator” services and inter-store transfers to be possible. Additionally, Alliance Supermarkets’ Chief Information Officer, Merchandisers, and Purchasing Managers can analyze the inventory levels for specific products between locations, along with variances in purchasing trends between the locations. With such information, the firm can implement inter-store transfers to properly distribute merchandise to the locations high rapid sales performance for a given product. For example, suppose Store A is shown to have had rapid sales for a particular Snapple beverage, and is now completely sold out of the product. Miles away, Store B has sold very few units of the same product.…

    • 755 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Inventory management has been operated under a system referred to as “earn and turn.” Under this program the company sets a ratio of gross profit margin multiplied by inventory turnover that must meet company requirements of 2.0. This level is subject to change and is set at the beginning of each year by Joe Henry, the company’s owner. However, this method, while effective in controlling profitability of the business and product lines, is an ineffective means for controlling inventory. Some stockout conditions result while other items are ordered in sufficient quantity to last years. Individual line items are managed under a cardex running inventory system where product is recorded as it arrives from the manufacturer and then reduced as sales are made. Each card includes a reorder point that is determined by judgment and past experience. Cards are reviewed weekly and reorder quantities will range from a month’s supply for more expensive items to a three month supply for those that are less costly. Over the past two years the company has shown interest in converting to a computer driven system, but it is far from full implementation. While the data used has been accurate when compared to accounting records…

    • 1102 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Inventory Turnover

    • 1081 Words
    • 5 Pages

    Inventory management is necessary for owners like Kathy to maintain a stocking service for quick turnaround to help ensure total customer satisfaction. The fill rate of an item develops a well managed inventory list. A well maintained stock list must be kept to avoid shortages of frequently used items. One of the problems affecting Kudler Fine Foods was that of reliable suppliers, they ran into the…

    • 1081 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Acct 352 Case 13.12

    • 369 Words
    • 2 Pages

    Instead of guessing how much inventory is needed, the supervisor needs to identify what, when and how much to purchase through a process. They can use the economic order quantity method which keeps sufficient stock on hand without interfering with any services with customers because of short stock.…

    • 369 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cru Computer Rentals

    • 562 Words
    • 3 Pages

    Additional gains could be made by improving inventory management. Rather than requiring two weeks of inventory to fill available demand, Richard should consider the variation in demand in his business and choose a more prudent level of safety stock. Available inventory that satisfies two times average demand adds a significant cash burden to CRUs business.…

    • 562 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Inventory Contro;

    • 1503 Words
    • 7 Pages

    Read the case study below “Harvey Industries”. Provide reasoning for the current financial distress of the company and make recommendations for improvements to the new company president. Include at least one specific recommendation for both Supply Chain Management (chapter 15) and Inventory Management (chapter 13), as well as any other recommendations you deem necessary from your reading. Provide your recommendations in a 2-4 page APA style paper.…

    • 1503 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Intercompany Eliminations

    • 1170 Words
    • 5 Pages

    Intercompany sales of inventory cause there to be unrealized profit on the books of the consolidated entity. The consolidated income statement should reflect only revenues earned through transactions with parties outside of the consolidated group; profits earned through intercompany transactions are considered to be unrealized, and therefore must be eliminated when preparing consolidated financial statements. Consolidated sales, on the consolidated income statement, should include only sales to parties outside of the affiliated group; consolidated cost of sales, also on the consolidated income statement, should reflect the cost of the goods to the affiliated group; and consolidated inventory, on the consolidated balance sheet, should reflect the cost to the affiliated group (Jeter & Chaney, 2010).…

    • 1170 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Six Sigma Case Study

    • 583 Words
    • 3 Pages

    3. With the centralization of the logistics structure information was shared more easily with a common system that made the access similar from one facility to another within the system. The ability of forecasting improved with an increase in products, and no change for inventory levels. The organization of the data and information needed to be developed to accommodate the European structure and business “attitude”, which cost a great deal of money for Shavers and took longer than wanted to have it established and implemented. The biggest change and drawback from the system centralization was the people within the organization. The local management felt as though they had less say and diminished power in what happened at their level and with the common language of the company being English, this has caused issues for the company.…

    • 583 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Tally

    • 4442 Words
    • 18 Pages

    MYOB (Mind Your Own Business) is an Australian-based technology company that provides financial software and products to businesses in Australia and New Zealand. While the company offers over 100 services and products, it is mostly known for its suite of accounting software for small to medium-size businesses. MYOB's mission is to help businesses by providing user-friendly accounting software. According to the company, over 1 million businesses in Australia and New Zealand use MYOB softwar…

    • 4442 Words
    • 18 Pages
    Powerful Essays
  • Good Essays

    According to Thomas M. McHugh (2011) computerized inventory management systems provide many benefits that are hard to obtain using paper methods or an in-house spreadsheet. Systems that are specific to the lab can be used relatively quickly without a significant learning curve or system customization. The ability to analyze the inventory, item usage, purchasing history, and other areas (e.g., lot numbers, equipment) are important improvements to spreadsheets and paper systems. If the system includes equipment tracking, it can be used to determine the capital asset as well as track the service history and lifespan of equipment. The ability to streamline and automate many of the inventory control tasks will be increasingly important to reduce hands-on time while improving the analysis of trends, reducing stock-outs, and avoiding expiring reagents. The ability to ensure that the right reagent in the right quantity is present at the right time is critical to laboratory operations. Given that reagents are approximately one-half of most labs' operating budgets, a continued focus on this expense will assist the laboratory in continuing to provide accurate and timely laboratory testing at the lowest cost.…

    • 939 Words
    • 3 Pages
    Good Essays