Inventory Management Models and Calculations
Inventory Management Models and Calculations
Production Management
Team:
Irma Carolina Mancera Núñez
Jorge Alberto Hernández Hernández
Salvador Cantor Freyre
Jorge Tulio Vázquez Cano
Table of contents
Cantidad de Pedido Fija................................................................... 3
FIXED PERIODS WITH SAFETY INVENTORY................ 5
Fixed period modelo .8
Quantity discount model ............................................. 11
ABC Classification .......................................................................... 17
Fixed Order Quantity
The fixed order quantity models aim to determine the specific point (R).
What will be ordered, as well as its size (Q).
1.-In a hardware store, the independent demand for certain bolts that
is commonly used is 500 units per month. The ordering cost is
30 dollars per order placed. The maintenance cost is 25% per year and
Each unit has a cost of .50 dollars. According to the economic quantity.
From the order, what should be the lot size for this product?
2.-Ray's Satellite Emporium wants to determine the best order size for its
the best-selling antenna (model TS111). Ray estimated that the annual demand
for this model it will be 1,000 units. Its cost to handle one unit is
$100 per year per unit and estimates that each order costs $25. With the EOQ model,
How many units should Ray order each time?
∗ 2 2∗ 1000∗ 25
= √ = √ = 23
100
4.-The Always Fresh Grocery Store carries a specific brand of tea that has the
following characteristics: Sales = 8 boxes per week Ordering cost =
$10 per order Maintenance fee = 20% per year Cost of the item = $80 per
box.
a)
∗ 2 2∗ 416∗ 10
= √ = √ = 23
16
b)
= ∗ =416∗ 10 = 18
23
5.-The local Toyota dealer must decide the quantity of shock absorbers.
spare of a specific type that must be ordered for the repairs of the
Toyota cars. These shock absorbers have a demand of four.
units per month at a cost of 25 dollars each. The maintenance fee is
30% per year and the ordering cost is 15 dollars per order.
a)What is the economic amount of the order for this item?
b)What is the annual cost of ordering and maintenance for this part?
c)Which el coI amtosuch
dtheIInventory?
a)
∗ 2 2∗ 48∗ 15
= √ = √ = 14
0.30∗ 25
b)
48
c) ∗ = ∗ 15 = 52
14
48 14
= + ∗ + ∗ = ( 48)(25 )+ ∗ 15 + ∗( 0.30 )( 25 )1304
2 14 2
6.- Find the economic order quantity, the reorder point, and the cost.
total dhe I andOntariodatwo: Dannual claim ) = 1,000 units daily demand
average () = 1,000/365 Order cost (S) = 5 dollars per order Cost of
1.25 dollars per unit per year
Cost per unit (C) = 12.50 dollars.
∗ 2 2∗ 1000∗ 5
= √ = √ = 90
1.25
= 2.7397∗ 5 = 13.69
= +∗ +∗ (
= 1000 )(
12.50 +1000
) ∗ 5 +90∗ 1.25 = 12611.80
2 90 2
Dunstreet's Department Store wants to establish an order policy for inventory with a probability of
95% chance that it will not run out. To illustrate the recommended procedure, use the ordering policy as an example.
white sheets. The demand for white sheets is 5,000 per year. The store is open 365 days a year.
year. Every two weeks (14 days) the inventory is counted and a new order is placed. The sheets take 10 days to
arrive. The standard deviation of the demand is five per day. Currently, there are 150 sheets available.
How many sheets should I ask for?
5000
= = 13.69
ℎ 365
+ = √(14+ 10)52= 600
= ( + )+ ( + )− ( + 10+ 1.645
= 13.69 14 ) 600−( 150 )= 1,315.56
≈ 1,316
Lieutenant Commander Data plans his monthly trip (every 30 days) to Gamma Hydra City for
pick up a supply of isolineal modules. The trip will take about two days. Before
exit, Data places the order at GHC Supply Store. Data uses the modules with an average index of
five a day (seven days a week) with a standard deviation of demand of one
day. It needs a service probability of 98%. Currently, it has 35 modules in
inventory, how many should he ask for?
+ = √(2+ 30)12=5.65
= ( + )+ ( + )− ( + 2+ 2.0538
= 5 30 ) 5.65−( 35 =) 136.6≈ 137
= ( + ) + ( + )− ( + 6+ 2.0538
= 100 10 ) ( 50 =) 1,641.84
44.72−
≈ 1,642
3. University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days)
when a salesperson from one of the pharmaceutical companies passes by. Tetracycline
It is one of the most important antibiotics, with an average daily demand of 2.
000 capsules. The standard deviation of daily demand is derived from the analysis
from the recipes of the last three months and it is 800 capsules. The order takes five
days to arrive. University Drug wants to cover 99% of the prescriptions. The salesman has just
arrive and at that moment there are 25,000 capsules in existence. How many capsules are there?
what to ask?
= ( + )+ ( + )− ( 2.32 38.7453−
= 2000 19+ ) ( 25000 = )13,089.889
≈ 13,090
Fixed-term model
The annual demand for a product is 13,000 units; the weekly demand is
of 250 units with a standard deviation of 40 units. The cost of making a
The order is for $100 and the delivery time is four weeks. The annual cost for
inventory management is $0.65 per unit. To offer a probability of
98% service, what is the economic order quantity and what should be the point
about reordering?
2 2 ( 13,000100
)( )
∗
= √ = √ 2,000
0.65
=√ 2 equals
√ ( 4 )402 = 80
The annual demand for a product is 15,600 units. The weekly demand is 300.
units with a standard deviation of 90 units. The cost of placing an order is
$31.20 and the time to receive it is four weeks. The annual management cost of
Inventory is $0.10 per unit. Find the reorder point and the necessary policy.
to have a service probability of 98%.
∗ 2 2 ( 15,60031.20
)( )
= √ = √ = 3120
0.10
=√ 2= √4(90)2= 180
= + =( 300)(4 ) +( 2.053180
)( = 1570
)
Retailers Warehouse (RW) is an independent supplier of household items for
department stores. RW aims to stock enough items to offer a
Service probability of 98%. One of the items stored is a set of knives.
of stainless steel. The demand (2,400 sets per year) is relatively stable during
all year round. Whenever new stock is requested, a buyer must ensure that
the figures are correct regarding the available inventory and then a new order is placed
by phone. The total cost of placing an order is around $5. RW thinks that the
maintenance of inventory and the payment of interest on the capital borrowed,
insurance, etc., add up to an annual maintenance cost of $4 per unit. The analysis of the
previous information shows that the standard deviation of retailer demand is
of more or less four units a day for a year of 365 days. The delivery time
The order is for seven days.
a) What is the economic order quantity?
b) What is the reorder point?
2 2(400)(5)
∗
= √ = √ = 32
4
=√ 2=
√7(4)2= 11
2400
= = = 6.5753
ℎ 365
= + =( 6.57537)(9.05311
)( = 69)( )
GentleBen's Bar and Restaurant uses 5,000 quarter bottles of an imported wine.
Year. The sparkling wine costs $3 per bottle and is served only in full bottles because
loses the bubbles in a short time. Ben thinks each order costs him $10 and the costs
The maintenance costs are 20% of the purchase price. An order takes three to arrive.
weeks. The weekly demand is 100 bottles (almost two weeks a year) with a
standard deviation of 30 bottles. Ben would like to use an inventory system that
minimize inventory costs and offer a service probability of 95%.
a) What amount of money should Ben ask for?
b) At what inventory level should an order be placed?
∗
2 2(5000)(10) = 409
= √ = √
0.6
0.20∗ 3 = 0.6
=√ 2= √3(30) =252
Quantity discount model
➢ Varies according to the size of the order
➢ Discrete change instead of unitary
➢ Calculate Q for each possible price and check if the quantity is feasible.
➢ If Q is lower or higher than the range then IT IS NOT FEASIBLE
2 ( 3000 )40
1.− √ 230.94
. 25 × 18
( root of )23000
Square 40
2.− = 224.78
. 25 × 19
(
√23000 )
40
3.− 219.08
. 25 × 20
[Link] Incorporated (CUI) produces copper contacts that are used in switches and
relays. CUI needs to determine the order quantity Q to satisfy the
annual demand at the lowest cost. The price of copper depends on the quantity
request. Below is the discount price and other details for the
problem:
Copper price $0.82 per pound up to 2,499 pounds
$0.81 per pound for orders between 2,500 and 5,000 pounds
$0.80 per pound for orders over 5,000 pounds
2 ( 50000 )30
1. − √ = 4330.12 = 4331
. 20 × .80
2 ( 50000 )30
2.− √ = 4303.31 = 4304
. 20 × .81
2 ( 50000 )30
3.− √ = 4276.99 = 4277
16.4
3. Bell Computers buys integrated circuits at $350 per unit. The cost of
the holding cost is $35 per unit per year, the ordering cost is $120 per order,
and sales remain stable at 400 per month. The company's supplier,
Rich Blue Chip Manufacturing, Inc. decides to offer price concessions with the
intention to attract larger orders. The pricing structure is shown at
continuation.
Pricing structure for Rich Blue circuits:
1–99 units $350
100–199 units $325
200 or more units $300
a) What is the optimal quantity to order and the minimum cost with which Bell
Computers order, buy, and maintain these integrated circuits?
2 ( 4800 )120
1. − √ = 10.47 = 11
35 ×300
2 ( 4800 )120
− √ = 10.06 = 11
35 ×325
2 ( 4800 )120
3.− √ = 9.69 = 10
35 ×350
b) Bell Computers wants to use a holding cost of 10% instead of the cost of
maintain a fixed amount of $35 used in section a. What is the optimal quantity to order?
And what is the optimal cost?
2 ( 4800 )120
1.− √ 195.95 = 196
10 × 300
2 ( 4800 )120
2.− √ = 188.27 = 189
. 10 × 325
2 ( 4800 )120
3.− √ = 181.42 = 182
10 × 350
4. Chris Sandvig Irrigation, Inc. summarized the price list from four suppliers
potentials of an underground control valve. See the following table. The use
annual is 2,400 valves; the ordering cost is $10 per order and the costs
Annual inventory holding costs are $3.33 per unit. Which seller should
choose and what is the best quantity to order if Sandvig Irrigation wants to minimize
its total cost?
Seller A
( )
− √ 2 2400 10 = 21.65 = 22
3.33 times30.75
2 ( 2400 )10
2.− √ = 21.51 = 22
3.33 times31.15
2 ( 2400 )10
3. − √
3.33 ×32.35 = 21.10 = 22
2 ( 2400 )10
4.− √
3.33 ×33.55 = 20.72 = 21
2 ( 2400 )10
5.− √ = 20.36 = 21
3.33 ×34.75
2 ( 2400 )10
6.− √ = 20.29 = 21
3.33 ×35
Seller B
( )
− √ 2 2400 10 21.73 = 22
3.33 ×30.5
2 ( 2400 )10
2.− √ = 21.35 = 22
3.33 ×31.60
2 ( 2400 )10
3.− √ 20.96 = 21
3.33 ×32.80
2 ( 2400 )10
4.− √ = 20.59 = 21
3.33 ×34
2 ( 2400 )10
5. − √ = 20.26 = 21
3.33 ×34.75
Seller C
2 ( 2400 )10
. −√ = . =
3.33 ×October 31
2 ( 2400 )10
2.− √ 21.06 = 22
3.33 ×32.50
2 ( 2400 )10
3.− √ = 20.66 = 21
3.33 ×33.75
2 ( 2400 )10
4. − √ = 20.44 = 21
3.33 ×34.50
Seller D
2 ( 2400 )10
1.− √ = 21.56 = 22
3.33 ×31
2 ( 2400 )10
2.− √ = 20.89 = 21
3.33 ×33
2 ( 2400 )10
3.− √ = 20.49 = 21
3.33 ×34.25
2 ( 2400 )10
34.25 √
114.4225
= 20.49 = 21
ABC Classification
• Pareto Principle
• Top A products (80%)
• Important Product B (15%)
• Product C less important (5%)
2. DAT, Inc. produces digital audio tapes for the consumer audio division.
DAT does not have enough personnel in its inventory supply section to control
all the items in stock, so he asked him to determine an ABC classification.
This is a sample of the inventory records: