An assembler orders two components from a single supplier. The assembler uses 200 units of the first component and 4000 units of the second component every month. The fixed transportation cost is $600. Also, the inspection and sorting costs are $100 for each component. The unit purchasing cost is $400 for the first component and $200 for the second component. The carrying cost is 20%. The assembler is trying to come up with an ordering plan that minimizes total holding and ordering costs. Find the best possible plan using the heuristic method. Calculate the average number of orders per month and order quantity for each component. In addition, calculate the total holding and ordering costs.
Please show calculation in excel as well as answer
Step by stepSolved in 2 steps with 2 images
- A company has the demand of 1800 units per year (demand rate is constant), holding costs of $13 per unit and setup costs (ordering cost) of $27 per order. The order lead time is 1 days, and the company operates 245 days every year. To avoid a stockout, they need to place an order at least ______ days before the inventory runs out.arrow_forwardSuppose that a product with an annual demand of 2400 units, a setup cost per production run of $8, and a holding cost of $1 per unit per year. With 200 working days in a year, conisder the following ordering plans: 1) order 600 units once each quarter and all 600 units will be delivererd in a single day 2) order 200 units once each month and all 200 units will be delivered in a single day 3) order 120 units each 6-month, and each order will be delivered over a period of 60 days a) Suppose that the items will be delivered at a rate of 40 pieces per day, what is the minimum overall costs in this case? b) Which ordering strategy has the lowest overall cost and why?arrow_forwardA manufacturer procures a subassembly from a supplier. The annual demand is 145,000 units, the cost per unit is $4, the inventory-carrying charge is 12 percent, and the order cost is $225. For orders between 10,000 but less than 30,000, a five percent discount is applied, and for orders exceeding 30,000, a eight percent discount is applied. What is the optimal order quantity? Use the Quantity Discount Excel template to find your answer.arrow_forward
- A manufacturer’s annual demand is 6000 units. The current units per order is $100. The setup cost is $50 per order and the holding cost is $7 per unit. The cost per unit is $2.50. The Number of work days is 250 per year. What is the annual setup cost? What is the annual holding cost? What is the optimal order quantity (EOQ)? Using the EOQ, how many orders should be placed per year? What is the interval between orders? What is the inventory administration cost? What is the total cost of inventory?arrow_forwardKGU company sells shoes whose daily demand is 100 units. The inventory holding cost is $2 per unit per year. The company also spends $20 per unit to process order. It takes 6 days from the time of reorder to the stocking of the inventory. The company keeps a safety stock that can cover twice the inventory. What is the ideal order quantity for KGU to purchase to minimize inventory costs? What is the ideal level of inventory at which KGU should pace a purchase order?arrow_forwardCentral University has a demand level of 80 units per day, for a particular toner cartridge in the student computer labs each year. The cost of each unit is 10.95. The purchasing director of the university estimates the ordering cost at $45 and thinks that the university can hold this type of inventory at an annual storage cost of 22%. Operating days are 250. The lead time is for orders to arrive is four days. a. To minimize the total annual cost of purchasing and carrying how many toner cartridges should be ordered? [Select] b. What are the numbers of orders that need to be placed? [Select] c. What is the total cost of managing the inventory? $ [Select] d. What are the number of days in between orders? [Select] e. What is the re-order point? [Select] f. What is the total cost, including the cost of the cartridges? $ [Select]arrow_forward
- ABC analysis is based on the presumption that carefully controlling all items is necessary to produce important inventory savings. A True B Falsearrow_forwardKaniri Global Imports (a retail store) sells artisan greeting cards. The owners search for localartists from around the world from whom to buy their greeting card inventory. The followinginformation is available to you for this problem:Demand/Sales = 110 cases of cards per yearOrdering or Setup Cost = $25 per orderCarrying Charge = 18% per yearUnit Cost = $150 per caseAnswer the following questions and be sure to show your computations. You can use whateversymbol you need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ). Computeto two decimal places. In reality they would round, but for this problem keep the twodecimal places.2. How many times should Kaniri order in a year? Do not answer in terms of how manydays or months, but rather how many times per year. Round your answer up to the nexthighest whole number.3. Answer all three:a. What is the annual cost of ordering the cards?b. What is the annual cost of carrying the…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.