Following information are given : D = annual demand = 115/ day x 5 days/week x 5
ID: 372998 • Letter: F
Question
Following information are given :
D = annual demand = 115/ day x 5 days/week x 52 weeks / year = 29900
Co = Ordering cost = $ 200
Ch = annual unit inventory holding cost = 15 % of $30 = $4.5
Optimal number of boxes that should be placed on order ( EOQ)
= Square root ( 2 x Co x D/Ch)
= Square root ( 2 x 200 x 29900/4.5)
= 1630.26 ( 1630 rounded to nearest whole number)
Number of orders per year = Annual demand/ EOQ = 29900/1630 = 18.34
Reorder point
= Weekly demand ( 5 days week) x Lead time ( weeks )
= 115 x 5 x 14
= 8050
OPTIMAL ORDER NUMBER = 1630 BOXES
NUMBER OF ORDERS = 18.34
REORDER POINT = 8050
Total annual cost
= Annual ordering cost + Annual inventory holding cost
= Ordering cost x Number of orders + Annual unit holding cost x Average inventory
= Co x Annual demand /Order quantity + Ch x Order quantity /2
= 200 x 29900/Order quantity + 4.5 /2 x Order quantity
= 598,0000/Order quantity + 2.25 x Order quantity
Thus total cost when order quantity is equal to monthly demand
= Annual demand / 12
= 29900/12
Corresponding annual cost
= 598,0000 x12/29900 + 2.25 x 29900/12
= 2400 + 5606.25
= $ 8006.25
Total cost when order quantity = EOQ = 1630 boxes:
Corresponding annual cost
= 598,0000/1630 + 2.25 x 1630
= $3668.71 + $3667.50
= $7336.21
Cost saving Derakshan Inc will realize = $8006.25 - $7336.21 = $670.04
COST SAVING BY DERAKSHAN INC THROUGH IMPLEMENTATION OF EOQ SYSTEM = $670.04
OPTIMAL ORDER NUMBER = 1630 BOXES
NUMBER OF ORDERS = 18.34
REORDER POINT = 8050
Explanation / Answer
The Derakhshan Division of Gilmore Co Inc. provides emerald precious stones. The stones should be shipped in a particular box which keeps the gem safe in shipping and has a label so customer know how to contact for another order. Derakhshan buy these boxes from Kohe Noor Company (supplier). For coming year Derakhshan needs 115 of these boxes daily. The current price of this box is $30. Under the present arrangement with the supplier, the Derekhshan must take one twelfth of its annual need every month. This agreement was reached in order to reduce lead time by assuring Gilmore a regular spot on the supplier’s production schedule. Without this agreement, the lead time would be about 14 weeks. No quantity discounts are offered on these boxes; however, the supplier requires that a minimum of 500 boxes be on an order. Derakhshan has enough space to store boxes. Derakhshan stores the emerald stones in a separate safe storage under highly protected environment. Associated with each shipment of boxes is ordering costs of $200, which include all the costs. In addition, inventory carrying costs (including taxes) on all items are considered to be 15% of the purchase price per unit per year. (Consider each week as 5 working days). What is optimal order number of boxes that should be placed in each order? Determine the number of orders per year? What is the optimal reorder for boxes? What cost saving will Derakhshan Inc. realize if it implements an order based on EOQ? (Hint, estimate the total cost under optimal solution and total cost under current situation, then compare the two situations).