Part 1: Optimal order quantity
Joshua is running a pharmacy in Nigeria (where Naira is the local currency). His recent experience in the MicroMasters course motivated him to rethink how to reorder pharmaceuticals to replenish inventory. He recalls from Module 4, Unit 1, Video 5, that he should consider the purchase cost, the order cost, and the holding cost. In the past, Joshua rigorously tracked these cost items. For Ibuprofen he knows that:
unit cost: c = 368 Naira/pack
demand: D = 670 packs/year
ordering cost: A = 2300 Naira/order
holding cost: r∗c = 47 Naira/pack*year
Part 1 Answer: How many packs of Ibuprofen should Joshua order to minimize the total cost?
256.07 Correct
Part 2: Consolidating orders
Joshua runs a second pharmacy on the other side of town. He has been ordering for each location individually from a wholesaler. He realizes that he can save some money by consolidating the two orders into one single order. The costs per pack for both pharmacies are exactly the same (use A, c and r∗c values from Part 1). The annual demand for Ibuprofen in the second pharmacy is 1150 packs.
Part 2 Answer: What is the consolidated optimal order quantity (in packs of Ibuprofen)?
Part 3: Savings from consolidation
Part 3 Answer: If Joshua places one consolidated order (as in Part 2) instead of placing two separate orders, how much money will he save?
Part 1 Answer: = EOQ= (2*D*S/H)0.5 = (2*670*2300/47)0.5 =256.07
Part 2 Answer: What is the consolidated optimal order quantity (in packs of Ibuprofen)?
Answer= EOQ= (2*D*S/H)0.5 = (2*(670+1150)*2300/47)0.5 =422.05
Part 3 Answer: If Joshua places one consolidated order (as in Part 2) instead of placing two separate orders, how much money will he save?
EOQ when only 1150 units are placed = (2*1150*2300/47)0.5 =335.49
Total cost for placing 256.07 units = (256.07*47)/2 +(670/256.07)*2300 =12035.53
Total cost for placing 335.49 units = (335.49*47)/2 +(1150/335.49)*2300 =15768.01
Total cost for placing 422.05 units = (422.05*47)/2 +(1820/422.05)*2300 =19836.43
Saving =12035.53+15768.01-19836.43
Saving=7967.11 Naira
Part 1: Optimal order quantity Joshua is running a pharmacy in Nigeria (where Naira is the...
13-11) Ray’s Satellite Emporium wishes to determine the optimal order size for its best-selling satellite dish (Model TS111). Ray has estimated the monthly demand for this model to be 404 units. This model costs Ray $347 to purchase from his supplier. His annual cost to carry inventory is 20% and he estimates that orders cost $42 to process. a) What is the optimal order quantity? b) On average, how many satellite dishes are in inventory? c) What is the annual...
a) What is the optimal order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips? The optimal order quantity after the change in pricing structure is ________ units (enter your response as a whole number). The total annual cost for Bell computers to order, purchase, and hold the integrated chips is $____________ (round your response to the nearest whole number). b) Bell Computers wishes to use a 10% holding cost rather than...
Ray’s Satellite Emporium wishes to determine the optimal order size for its best-selling satellite dish (Model TS111). Ray has estimated the monthly demand for this model to be 489 units. This model costs Ray $139 to purchase from his supplier. His annual cost to carry inventory is 23% and he estimates that orders cost $42 to process. What is the optimal order quantity? Ray’s Satellite Emporium wishes to determine the optimal order size for its best-selling satellite dish (Model TS111)....
A company wishes to determine the optimal order quantity for its products. The product is sold at a rate of 800 per week. Each order costs $500. On average, the cost of each product is $8 and the holding cost is based on an annual percentage rate of 10% per product. The lead time for order arrival is 1.5 weeks. Respond to parts (a) Suppose that annual percentage rate may vary up to 14% per product. How much will the...
Mr. Smith runs a world-food wholesale store in Nottingham. One of the items he orders from the Far East is Sriracha hot sauce. Every pack costs £10 and requires a six-month lead time for replenishment. Mr. Smith uses a 20% annual interest rate to compute holding costs. Estimated ordering cost is £50. During the six-month replenishment lead time, Mr. Smith estimates that he sells an average of 100 packs of sauce, but there is substantial variation from one six-month period...
Part II:InventoryManagement In the following, you need to manage the stock level of the company with respect to some costs that your team already estimated. The team report states that for one order made, the company should pay 20 AED as clerical costs and 30 AED as packing costs. It is stated also that the company spends 10 AED to produce one mask and that 80% of that corresponds to the cost of keeping one mask in stock for one...
Syarikat GU Sdn. Bhd. produces a product which has a constant monthly demand of 4000 units. The product requires a component which Syarikat GU Sdn. Bhd. purchases from a supplier at RM10 per unit. The component requires a three-day lead time from the date of order to the date of delivery. The ordering cost is RM0.60 per order and the holding cost is 10% per annum. You are required to: (a) (i) Compute the economic order quantity ...
Economic Order Quantity Ottis, Inc., uses 656,100 plastic housing units each year in its production of paper shredders. The cost of placing an order is $24. The cost of holding one unit of inventory for one year is $12. Currently, Ottis places 162 orders of 4,050 plastic housing units per year. Required: 1. Compute the economic order quantity. X units 2. Compute the ordering, carrying, and total costs for the EOQ. Ordering cost $ X Carrying cost Total cost 3....
Assuming that there is no safety stock and that the present stock level is 400 components, when should the next order be placed? (Assume a 360-day year.) (1 mark)COVID-19 Ltd produces a specialized product; LOCKDOWN which has a constant monthly demand of 4000 units. The LOCKDOWN requires a component which COVID-19 Ltd purchases from a supplier at GHS10 per unit. The component requires a three-day lead time from the date of order to the date of delivery. The ordering cost...
Discount-Mart, a major East Coast retailer, wants to determine the economic order quantity for its halogen lamps. It currently buys all halogen lamps from Specialty Lighting Manufacturers, in Atlanta. Annual demand is 2,000 lamps, ordering cost per order is $60, carrying cost per lamp is $12 a) What is the EOQ? 142 lamps per order (round your response to the nearest whole number). b) What are the total annual costs of holding and ordering (managing) this inventory? $ 1,697 (round...