Consolidated Electric Case Study: Consolidated Electric Company

Improved Essays
Consolidated Electric Case Study: Report
Discussion Question 1: Design an inventory control system for this business
Consolidated Electric is a whole sale distributor of electrical equipment’s and supplies to electronic contractor owned by Joe Henry with an average sale of 20,000 line items. The current inventory method supported is a manual Cardex System which is outdated and not a cost effective way to manage the company inventory system. It is an Independent demand system which is directly proportional to the market condition in its current state.
Henry sets a target earn turn ratio each year for the business which determines the estimated costs of operations and return on investment goal for the company, but has been ineffective to fulfill the actual demand supply for the business in an effective centralized way.
Cardex System a card system, is currently used to manage the inventory of the business which makes use of the order point and quantity printed on the card manually to decide the reorder point for any commodity. According to the past experience the reorder point is calculated for expensive items and low cost ones in the 1:3 months ratio. This method had been showing drastic
…show more content…
Two of the most important issues in inventory control are order quantity and order timings. Hence my recommendation is to utilize a fixed order quantity system (Q system) as it will determine the reorder point of the items on the basis of the current market status depending on the average demand for the items and EOQ value. The current service levels for the company are 68-75 %. Therefore for an effective and flourishing business the service levels should match to 90-95%. In order for the Inventory Management System to achieve this value, the following requirements would be

Related Documents

  • Decent Essays

    Hrm/531 Week 2

    • 556 Words
    • 3 Pages

    Late payment of vendor invoices, which means late fees and lost cash discounts: The help with the new ERP Mal-Bal will be able to make payments to vendors in time for the system can integrate with the inventory purchased from the stores department. Late deliveries to customers: The old software integration of data is a problem and in order to make timely deliveries and the purchase order will be received by the marketing needs to be marked to material dispatch section in time. The lack of which will result in a delay of deliveries. Growth in inventories, accompanied by an increase in stockouts: Integration of data and lack of availability of information to employees will result in stock in hand not matching with the product demand and purchase department may…

    • 556 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    Wooten’s Electric Utility Company About the Company Wooten’s Electric Utility Company is a company that was created to serve over 580 homes and farms. Today Wooten’s Electric Utility Company is one of the largest electric companies in the United States of America with nearly 15,000 miles of lines that serve more than 65,000 meters.…

    • 762 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Mid-Town Office Products is an established company that specializes in the sale and distribution of office supplies. Its warehousing facility is located in the suburbs near Los Angeles. The company is known for its business capabilities, customer relationships and operational excellence. The company aims their merchandise and marketing efforts toward catalog orders and online shopping which allows the consumer to buy products and services over the internet. As a result of Mid-Town’s business strategy this company has a competitive advantage over its competition rendering next day delivery in addition to providing a greater value to its customers through price differentiation.…

    • 335 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    BSG Lessons Learned How did the key theories and concepts in the course relate to the simulation? The Business Strategy Game (BSG) was the practice of strategic management that offers virtual executive experience. The assigned team could analyze the market, set the direction, and make strategy for company’s growth in BSG.…

    • 1159 Words
    • 5 Pages
    Great Essays
  • Improved Essays

    In 1997, Duke Power made its first big merger that would set the future of Duke Energy. Duke Power purchased PanEnergy Corp for $7.4 billion in order to help the utility company branch out nationally. After this buyout Duke Power changed its name to Duke Energy Corporation in order to set a new platform for expansion and growth. At the time Duke Energy had net assets of $13.5 billion while PanEnergy had $7.6 billion. The merger was a necessity for both companies because the gas and electricity markets were moving together.…

    • 460 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    For doing as such, the providers offer Arrow focused estimating on items. The providers all have put an enthusiasm for balancing out process through the channel, keeping record of who uses the items, and having wish for wholesalers to perform value included administration. The customers would want for Arrow to give them parts in little volume on request and in addition collect units so that the production lines can keep running without intrusion. The entering of Express shows a reasonable test to Arrow’s current plan of…

    • 746 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Tsc Stores Case Study

    • 1110 Words
    • 4 Pages

    TSC Stores, Supply Chain Management for Profitable Growth Brad is currently in a process of creating a long term supply chain strategy that will support the company’s corporate growth, cost objective and also the program of the Project 275. However, the rapidly growing volumes and complexities in the supply chain are causing concerns, and Brad is worried that the company may not be able to handle the planned growth. In addition to that the company is faced with several other challenges that threaten its plans, namely, stock-outs in stores and DC, low service level, too much inventory in enterprise, slow inventory turnover, and tied up working capital. 1. What does your analysis of the data in Exhibit 3 suggest that Brad Twiddy might want…

    • 1110 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Electric Cooperatives: Going Beyond the Wires One day in July, a girl named Alexis and her dad were reading a story before bedtime as the lights start flickering. “Daddy, why are the lights doing that?” she said terrified holding onto her dad’s arm. “Don’t worry sweetheart, that happens a lot because of the electric company.…

    • 649 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    By how much do your recommendations for these two items reduce annual cycle inventory, stock out, and ordering costs? Summary This case portrays the issues confronting Sue McCaskey, the new materials administrator of a wholesale merchant of car parts. She looks for approaches to cut the bloated inventories while enhancing client administration.…

    • 1101 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    GAP Case Study Essay

    • 813 Words
    • 4 Pages

    In the past year, the company GAP has seen a steady decrease in their stock prices which has been caused by a couple of different things. A change in management and poor communication within new management has caused sales to steadily decrease. One effect of this poor communication in management is that GAP’s inventory is not well organized, which hurts the net cash flow of the company. The old system used to order inventory was “by gauging the response [to the product], the management [was] able to forecast demand properly and release an appropriate production order to vendors and suppliers…” (“Gap Inc Left”).…

    • 813 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Students in the online sections should email their cases to their online TA. Name: Jennifer Johnson Zhao Jin OIS – 3440 Applications of Business Statistics Section “00” Instructor: Professor Tariq Mughal Case 10.1 Motive Power Company – part 1 Executive Summary In case 10 .1 Motive Power Company Part 1, manufacturing manager Cregg Hart is approached by another supplier for rivets. Motive Power is very keen on their quality and are interested in evaluating the new rivets by comparing them to their existing supplier’s rivets.…

    • 1295 Words
    • 6 Pages
    Great Essays
  • Superior Essays

    Question 1. Aggregate inventory data suggest that while overall average inventory levels are declining, the relative percentage being held by manufacturers is increasing. Explain why you think this observation is either true or false. Describe how such a shift could benefit the operations of the entire channel and how manufacturers could take advantage of the shift.…

    • 1166 Words
    • 5 Pages
    Superior Essays
  • Improved Essays

    Hagen Style Case Study

    • 1028 Words
    • 5 Pages

    Executive Summary Hagen Style is a successful kitchen equipment company in Europe and its success owes to its direct marketing operations, along with its efficient distribution system. To Hagen Style, it is a good start that this company developed the appropriate marketing and distribution strategies which fit the market at that time. These Operation Strategies are maintained by effective Operations Management. For instance, without strict planning and management, the two distributions could be a mess and unable to realize fast delivery. The information system help analyse the orders and standardised packing progress ensures the product safety.…

    • 1028 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    Case Study 2 ACCT-504-61405 Situation A: - In evaluating the internal control over inventory for the Williams Oil Services Company, an auditor learns that the warehouse receiving clerk is responsible for ordering parts for supply inventory use in drilling services, counts the inventory when received at the dock, records the receipts into the inventory ledger, and takes the annual inventory, No supervisor reviews the receiving clerk’s work. Missing Internal Control characteristics for William Oil Services: - In the William’s case oil Services Company, The missing internal control characteristic is Monitoring Control, The clerk is the only person who has to maintain all the inventory related records.…

    • 967 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    1. Define acronyms CRP, EDI, OSB, ECR and explain. CRP - Continuous Replenishment system - the purpose of this system is to streamline the logistic system, reducing inventory, and improve overall ordering and service quality for the channel customers. EDI - Electronic data interchange - P&G system involves a lot of data transfers from their retailers to P&G on warehouse product shipments to each store. This system also paved a way to determine the quality of the products to be shipped.…

    • 858 Words
    • 4 Pages
    Decent Essays