Sumco's annual demand is expected to increase from 1,000 units to 1,555 units, the ordering cost is reduced to $8 per order and the average carrying cost per unit per year remains the same at $0.50. Under these new conditions: a. Calculate the new EOQ. Calculate the Annual Ordering Cost, the Annual Holding Cost and the Total Annual Cost. ) If Sumco has a daily demand of 10 units and assuming that they will be ordering the exact amount calculated for EOQ in topic (a) with a lead time of 5 days, calculate the Reorder Point (ROP) and the Inventory b. С.

Sumco's annual demand is expected to increase from 1,000 units to 1,555 units, the ordering cost is reduced to $8 per order and the average carrying cost per unit per year remains the same at $0.50. Under these new conditions: a. Calculate the new EOQ. Calculate the Annual Ordering Cost, the Annual Holding Cost and the Total Annual Cost. ) If Sumco has a daily demand of 10 units and assuming that they will be ordering the exact amount calculated for EOQ in topic (a) with a lead time of 5 days, calculate the Reorder Point (ROP) and the Inventory b. С.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Problem 1: Auto Mart is a mythical seller of a variety of automobileparts and accessories. Auto Mart's owner, Jonathan Trott, wishes to determine the optimum order quantity for oneof the store's popular wiper blades. The annual demandfor the wiper blades is 16,000. The annual holding costper unit is US$2.50, and the cost to place an order is US$50:a What is the EOQ?b What are the total annual ordering and holding costs(inUS dollars)?
Problem: 4 ABC Ltd uses EOQ to determine the order quantity for its various components and is planning its orders. The Annual Consumption is 80,000 units. Cost to place one order is RO 1200. Cost per unit is RO 50 and carrying cost is 6% of unit cost. Find A) EOQ B) Number of orders per year C) Ordering cost D) Carrying cost and E) The total cost of inventory
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 390 units. Ordering cost is $36 holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? EOQ= ____round to nearest whole number b) if the holding cost per unit was $6.00 instead of $5, what would the optimal order quantity be? EOQ = ____round to nearest whole number
DC Company order 480,000 packs of orange juice per year from a Manila distributor. Atwo-dozen pack case of juice delivered to DC warehouse cost P48 including freightcharges. The company borrows funds at 10 percent interest rate to finance its inventory.DC Company purchasing agent has calculated that it cost P150 to place an order fororange juice and that the annual carrying cost (electricity, insurance, handling ) is P.80for each pack of juice.Required:a. Determine the Economic Order Quantity.
Problem 20-22 (Algo) Annual demand for a product is 16,120 units; weekly demand is 310 units with a standard deviation of 55 units. The cost of placing an order is $145, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.55 per unit. a. To provide a 90 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Reorder point____________ units ? b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) Service probability___________%
Thomas’ Bike Shop stocks a high volume item that has a normally distributed demand during the reorder period. The average daily demand is 70 units, the lead time is 4 days, and the standard deviation of demand during the reorder period is 15. a. How much safety stock provides a 95% service level to Thomas? b. What should the reorder point be
Suppose Sam's Hotel for Cats's problem 10 use a P system instead of a Q system. Demand average daily rate is 15 bags (90/6) and the standard deviation of daily demand is 6,124 bags 15 6 . The. Which P (on weekdays) and T should be used to approach the cost choices of EOQ? B. What additional amount of safety stock is required compared to a Q system? ç. It is time for periodic review. How much hay for the kittens' bed should be ordered?
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $8.80 per stone for quantities of 600 stones or more, $9.20 per stone for orders of 400 to 599 stones, and $9.70 per stone for lesser quantities. The jewelry firm operates 230 days per year. Usage rate is 16 stones per day, and ordering costs are $45.a. If carrying costs are $2 per year for each stone, find the order quantity that will minimize total annual cost. (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) b. If annual carrying costs are 20 percent of unit cost, what is the optimal order size? (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) c. If lead time is 3 working days, at what point should the company reorder? (Do…
A local artisan uses supplies purchased from an overseas supplier. The owner believes the assumptions of the EOQ model are met reasonably well. Minimization of inventory costs is her objective. Relevant data, from the files of the craft firm, are annual demand (D) = 150 units, ordering cost (S) = $42 per order, and holding cost (H) = $4 per unit per year. a. How many should she order at one time? b. How many times per year will she replenish her inventory of this material? c. What will be the total annual inventory costs associated with this material? d. If she discovered that the carrying cost had been overstated, and was in reality only $1 per unit per year, what is the corrected value of EOQ?
Annual demand for a product is 13,000 units; weekly demand is 250 units with a standard deviation of 40 units. The cost of placing an order is $100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.65 per unit. To provide a 98 percent service probability, what must the reorder point be? Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number. Suppose the production manager is told to reduce the safety stock of this item by 100 units. If this is done, what will the new service probability be? Note: Use Excel's NORM.S.DIST() function to find the correct probability for your computed z value. Round z value to 2 decimal places and final answer to the nearest whole percent.
Thomas Kratzer is tbe purchasing manager for theheadquarters of a la rge insurance company chain with a centralinventory operation. Thomas's fas test-moving inventory itemhas a demand of 6,000 units per year. The cost of each unit is$ 100, and the inventory carrying cost is $10 per unit per year. The average ordering cost is $30 per order. It takes about 5 days for anorder to arrive, and the demand for I week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per yea r?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f) What is the total annual inventory cost, including the cost ofthe 6,000 units?
DC Company order 480,000 packs of orange juice per year from a Manila distributor. Atwo-dozen pack case of juice delivered to DC warehouse cost P48 including freightcharges. The company borrows funds at 10 percent interest rate to finance its inventory.DC Company purchasing agent has calculated that it cost P150 to place an order fororange juice and that the annual carrying cost (electricity, insurance, handling ) is P.80for each pack of juice. a. Determine the Economic Order Quantity.b. Would you accept the offer if the Manila distributor offered a 10% discount off thedelivery price for minimum orders of P60,000 packs?