
(a)
Annual demand, D = 300 x 12 = 3,600
Ordering cost, K = $85
Cost of the product, C = $20
Annual holding cost %, i = 15%
EOQ = (2.D.K / i.C)1/2 = sqrt(2*3600*85 / (0.15*20)) = 452 units
(b)
Average daily demand, d = D / 250 = 3600 / 250 = 14.4
Lead time, L = 10 days
So, Reorder point, ROP = lead time demand = d.L = 144 units
(c)
ROP = lead time demand = d.L = 14.4 x 20 = 288 units
(d)
The EOQ and ROP values completes the policy variables i.e. in each order cycle, 452 units are to be ordered when the inventory position falls to 288 units.
(e)
Inventory position = Inventory on-hand + quantity on order - backorder
In this case:
So, there will be no difference in inventory level and inventory position and hence the ROP will also be the same.
1 6. A business is trying to identify the optimal order quantity for one of its produets. Demand 2 is constant and...
Leaky Pipe, a local retailer of plumbing supplies, faces demand for one of its SKUS at a constant rate of 18,700 units per year. It costs Leaky Pipe $15 to process placed. No backordering is allowed. Assume 250 working days a year. an order to replenish stock and $2.00 per unit per year to carry the item in stock. Stock is received 2 working days after an order is a. What is Leaky Pipe's optimal order quantity= 775 units b....
Teck is a Canadian metal mining and processing company with new investments in coal and oil. The company has several warehouses in Western Canada that store thousands of parts and supplies for the machines and equipment used in its mines and operations. The stocks in the warehouses are controlled using computers in the Vancouver head office. For spare parts, the EOQ/ROP model is used. The following data is the usage of specific spare part during a nine-month period: Jan Feb...
#1 ArcSite Electrical, which produces generators, purchases a component that is used in its generators directly from the supplier. The generator production operation requires a constant 1,000 components per month. It costs S25 to place each order. The unit cost is S2.50 per component, and the quarterly per-component holding cost is 5% of the value of the component. ArcSite operates 250 working days per year and the component supplier has a lead time of 5 days. (a) What is the...
A firm is operating a fixed inventory system. One product has the following characteristics: Order cost $35/order Unit cost $15/unit Holding cost/unit/year 20% of unit cost Annual demand 1800 Lead time 2 weeks Answer the following questions: a. What is the optimal order quantity, EOQ? b. What is the total annual inventory cost? c. If management decides to use order size of 400 rather than the EOQ, what will be the impact on total cost? (Calculate) c. If demand is...
Problem 4: Solve EOQ and Re-order point of problem
displayed below, please show detailed solution with
formulas used in excel, thank you.
Bart's Barometer Business is a retail outlet that deals
exclusively with weather equipment. Bart is trying to
decide on an inventory and reorder policy for home barometers.
Barometers cost Bart $240 each and demand is about 5,750 per year
distributed fairly evenly throughout the
year. Reordering costs are $120 per order and holding
costs are figured at 15% of the...
A local store sells toilet paper to people in the surrounding communities. The demand for the toilet paper has been increasing and management needs to ensure that enough rolls are available to meet the increasing demand. The daily demand for the toilet paper is 400 rolls. The store operates 250 days per year. The following information is also available about the product. The cost of each roll……………………….…..$2. Ordering costs………………………………..……$100 per order Annual holding costs per unit…………… 10% of the costs...
3. Given the following inventory, calculate the Economic Order Quantity and Reorder Point. Annual Requirements (R) 7200 units Setup Cost (S) 100 per order Holding rate (k) 20% per year Unit Cost (C) 20 per unit Order lead time (LT) 6 days Number of days per year 360 Please show work including formulas for EXCEL.
If annual demand is 24,000 units, and the order quantity is 3,000 units, which of the following accurately describes the decision-making environment? a. The annual number of order placements will be 8, and average inventory levels will be 1,500 b. The annual number of order placements will be 8, and average inventory levels will be 3,000 c. The annual number of order placements will be 12, and average inventory levels will be 12,000 d. The annual number of order placements...
A company that sells different models of socks, faces an annual demand of 10,000 units of its main model. The cost of issuing a purchase order is $ 50 and it has been estimated that the cost of unit storage of the product for one year is $ 2.5. Assume that the provider takes a long time to fill a 7 days order, and the company wants a 5 day security inventory. With a 360-day year, determine: a) The economic...
A store faces demand for one of its popular products at a constant rate of 2,400 units per year. It costs the store $70 to process an order to replenish stock and $20 per unit per year to carry the item in inventory. A shipment from the supplier is typically received 12 working days after an order is placed. The store buys the product for $90 per unit and sells it for $160 per unit. At the moment the store...