Inventory Management and Optimization Strategies
Inventory Management and Optimization Strategies
ADMINISTRATIVE
BUSINESS OPTIMIZATION
AREQUIPA -2021
QUESTIONS FOR ANALYSIS
6-1 Why is inventory an important consideration for managers?
Inventory is an important consideration for managers because it shows a
a big investment and doesn’t want to have money without utility, nor does he want it to be lacking.
Inventory, good inventory control reduces costs that will be important.
6-2 What is the purpose of inventory control?
It has an important function as it adds flexibility to the operation of companies.
Having inventory control reduces costs for your available inventory, the customers
they can be left unsatisfied when they run out of stock.
Under what circumstances can an inventory be used as protection against the
inflation?
It is used when there is a necessary product or when the reserved products are not available.
purchased by the weather may have more demand.
6-4 Why would a company not always store large quantities of inventory?
to avoid shortages?
Sometimes the exceeded quantities would not be stored due to space or for some reason.
maintenance that these products require
6-5 What are some assumptions made when using the CLE model?
The necessary quantities required, whether they are constant or not, create order.
to avoid unnecessary expenses for an inventory.
Analyze the main inventory costs used to determine the COGS?
The quantities or orders required, the larger the quantity the greater the discount, but this
It depends on the order I have and the space required.
What is the PRO? How is it determined?
It is determined according to the order that was obtained, it is the rearrangement. The demand per day, by the
delivery time for an order in days.
6-8 What is the objective of sensitivity analysis?
The objective is that all input values are fixed and known with certainty.
However, since these values are often estimated or may change with the
time, it is important to understand the change that the quantity to be ordered can undergo, if it
they use other input values. The determination of the effects of these changes is called
sensitivity analysis.
What assumptions are made in the production run model?
When a company receives its inventory during a certain period, a new one is needed.
model that does not assume the instantaneous reception of inventory, which works
when the inventory flows continuously or accumulates over a period afterwards
to place an order
EXERCISES
6-18. Lila Batle determined that the annual demand for number 6 screws is
100,000 screws. Lila, who works at her brother's hardware store, is in charge of the
purchases and it costs $10 every time an order is placed. This cost includes
his salary, the cost of the methods used to place the order, etc. Furthermore,
estimate that the cost of keeping a screw in inventory for a year is: half
of one cent. Assume that the demand is constant throughout the year.
a)How many number 6 screws should Lila order at the same time if she wants to
minimize the total inventory cost?
b)How many orders per year should I place? What will be the annual cost of ordering?
D: 100,000
CP screws:
$10 pesos
$0.005 cents
b) N: 100,000 N: 5 orders
annual 20,000
$50
Therefore, the reorder point is 4000 units per year. The reorder point is 4000.
screws per year.
Lila's brother thinks that she places too many orders per year for the
screws. Think that an order should be placed only twice a year. If Lila continues
his brother's policy, how much more would his ordering policy cost each year?
Developed in problem 6-18? If only two orders are placed each year, what
What effect will it have on the PRO?
100,000
Bárbara Bright is a purchasing agent at West Valve, a company that sells valves.
industrial and fluid control devices. One of the most popular valves is the
Western has an annual demand of 4,000 units. The cost of each valve is
$90 and the storage cost is estimated at 10% of the cost of each valve. Barbara
conducted a study on the costs involved in placing an order for anyone
of the valves stored by West Valve; it concluded that the average cost per order is
from $25 per order. Even more, it takes about two weeks for the supplier
place an order and, during this time, the weekly demand for the valves
West is approximately 80. a) What is the CLE?
D=4.000
Ch= 10% (90)=9
Co= 25
L=2 weeks
d=80 2
= 149.07
b) The reorder point (ROP) is given by: = The PRO = 2x80 = 160
74.54∗ ℎ 149.07 2∗ 9
670.82
How many orders per year should I place? What is the annual cost of ordering?
The #ó =
4000
The = ∗∗ 4,000
The annual ordering cost = 149.07∗ The cost of the economic lot is
149.07 units, an order should be placed when the inventory reaches 160 valves.
have an average inventory of 74.54 units with a storage cost of $670.82
per year, issuing 26.83 orders per year at a cost of $670.82 annually.
Ken Ramsing has been in the lumber business for almost his entire life.
Ken's biggest competitor is Pacific Woods. Due to many years of experience,
Ken knows that the cost of placing a counter-order is $25 and that the
the cost to store is 25% of the unit cost. Both Ken and Pacific Woods
They receive the plywood in loads that cost $100 each. Moreover, Ken and Pacific
Woods deals with the same supplier and Ken was able to find out that Pacific Woods orders
quantities of 4,000 loads at once. Ken also knows that 4,000 loads is the CLE for
Pacific Wood. What is the annual demand for plywood loads for Pacific?
Woods?
6-23. Shoe Shine is a shop located on the north side of Centerville. The demand
The annual sale for popular sandals is 500 pairs and John Dirk, the owner of Shoe
Shine, you have the habit of ordering 100 pairs at a time. John estimates that the cost per order
It is $10 per order. The cost of the sandal is $5 per pair. In order for the policy to
Ordering from John should be the correct one, what would the cost be for storing as
percentage of the unit cost? If the storage cost is 10% of the cost, what is it?
What would be the optimal quantity to order?
D = 500 pairs
Sort 100 pairs at a time
Co = 10
Cost of Sandal = 5 x pair
Ch = 5*0.10
= 0.5
CP screws:
$20 pesos
$0.005 cents
D: 100,000 screws
$30 pesos
$0.005 cents
D: 100,000
CP screws:
$40 pesos
$0.005 cents
ANSWER:
6-25. The machining workshop of Ross White uses 2,500 supports over the course of a year, and
this usage is relatively constant in that period. The supports are purchased from a
supplier that is 100 miles away at $15 each, and the delivery time is
for 2 days. The annual cost for storing per item is $1.50 (or 10% of the unit cost)
and the cost per order is $18.75 per order. There are 250 working days per year.
What is the CLE?
250 supports
b) Given the CLE, what is the average inventory? What is the annual cost for
store the inventory? Average inventory: Q/2: 250/2 = 125 supports Cost
annual for storing inventory: Q*Ch/2= 125 * 1.5 = $187.5
c) By minimizing the cost, how many orders would be placed each year? What will be the cost?
annual per order? D/Q = 2,500/250 = 10, so 10 orders must be made
each year Co * D/Q = 18.75 * 10 = $187.5, so $187.5 is the annual cost for
to order
d) Given the CLE, what is the total annual cost of inventory (including the cost of
purchase)? 187.5+187.5+2500*15= $37,875
e) What is the time between orders? Since 10 orders would be placed each year and
The delivery time is 2 days, the time between orders is: 365/10–2 = 34.5
(days)
a) ¿Cuál es la tasa de demanda diaria? Demanda Anual = 2500 Días laborables = 250 2500
/ 250 = 10
b) ¿Cuál es la cantdad óptma de producción? D: 2,500 soportes CP: $25 CMI: 1.5 CLE =
Q*: √2 (2,500) (25) 1.5
289 supports
c) How long will it take to produce the optimal quantity? How much inventory is sold?
during this time? Q = 289 Daily quantity = 50
e) How many production runs would there be each year? What would be the annual cost for
preparation? 215 + 215 + 2500 * 15 = $37930
6-27 When the support provider heard that Ross (see problems 6-25 and 6-
26) I was considering producing them in his workshop, I notified Ross that I would lower the price.
from $15 to $14.50 per support, if Ross bought them in batches of 1,000. Without
Due to the embargo, delivery times would increase to 3 days for this large quantity. a)
What is the total annual cost of the inventory plus the purchase cost, if Ross buys
the supports in batches of 1,000 at $14.50 each? b) If Ross decides to buy in batches
Of 1,000 supports, what is the new PRO? c) Given the purchase options of
supports at $15 each, produce them in the workshop for $14.80 and take advantage of the discount,
What is your recommendation for Ross?
37021.88
b)PRO=10*3=30
What safety stock should Ross maintain if he wants a 98% service level?
service? IS= zσ = 2.05 (1.5) =3.075 units
c)What is the adjusted PRO for the supports? PRO = 20 + 3.075 = 23.075
d)What is the annual cost for storing the safety inventory, if the cost
The annual storage cost per unit is $1.50? 3.075 (1.5) = 4.61
Douglas Boats is a supplier of yacht equipment in the state of Oregon and
Washington. Sells 5,000 White Marine WM-4 diesel engines each year. These engines
they are sent to Douglas in 100 cubic foot containers and Douglas Boats maintains
he filled his warehouse with these WM-4 motors. The warehouse can hold 5,000 feet.
cubic supplies for yachts. Douglas estimates that the ordering cost is $10
by order and the cost for storage is $10 per engine per year. Douglas Boats
Consider the possibility of expanding the warehouse for WM-4 engines. How much will it
Should Douglas Boats expand and what would be the value of the expansion for the
Company? Suppose that demand is constant throughout the year.
D = 5000 Warehouse can hold 5000 feet
Co = 10 Ch = 10
How much should it expand? Value of the expansion?
12,000
Q*:√2(12,000)(30) 600
units 2