Introduction to Inventory
This presentation is the property of its rightful owner.
Sponsored Links
1 / 34

Introduction to Inventory PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on
  • Presentation posted in: General

Introduction to Inventory. Total Cost Analysis Computation of Safety Stocks Setting Order Points Joint Replenishment Number of Facilities and Inventory. Total Cost Analysis. Start with EOQ Identify alternatives Vendor discounts Transportation options Other issues

Download Presentation

Introduction to Inventory

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Introduction to inventory

Introduction to Inventory

Total Cost Analysis

Computation of Safety Stocks

Setting Order Points

Joint Replenishment

Number of Facilities and Inventory


Introduction to inventory

Total Cost Analysis

Start with EOQ

Identify alternatives

Vendor discounts

Transportation options

Other issues

Examine only total relevant costs

Select least cost alternative


Introduction to inventory

*

Economic Order Quantity

$

Total Cost

Cost of Carrying

Inventory

Cost of Ordering

Order Quantity


Introduction to inventory

Elements of Inventory Carrying Costs

10-20 %

Interest and Opportunity Cost

Storage and Handling

8-14 %

Depreciation and Obsolescence

6-12 %

Insurance and Taxes

2 -3 %

Total 25-50 %


Introduction to inventory

Economic Order Quantity

$

(With Constant Ordering Costs)

Total Cost

Cost of Carrying

Inventory

Cost of Ordering

Zero Inventory

JIT

Order Quantity


Introduction to inventory

Determining EOQ

Total Cost = OC + CC

OC = Order Placement Cost = A(R/Q)

CC = Inventory Carrying Cost = 1/2(QVW)

Where:

Q = Optimal Order Quantity (EOQ)

A = Cost of placing an order

R = Annual Rate of use

V = Value per unit

W = Carrying cost as a percentage of average value of inventory


Introduction to inventory

Quantity

Average

Inventory

Time

Average Inventory

Inventory Carrying Cost = 1/2 (QVW)

Where:

Q=Order Quantity

V=Value per Unit

W= Carrying Cost as a Percentage of the Average Value of Inventory


Introduction to inventory

AR

QVW

TC =

+

2

Q

or

TC = ARQ-1 + .5QVW

To minimize cost, set 1st derivative = zero

and solve for Q

-AR

VW

TC’ = -ARQ-2 + .5VW

TC’ =

= 0

or

+

2

Q2

2AR

2AR

or

Q2

=

AR

VW

VW

VW

=

2

Q2

Determining EOQ

Total Cost = OC + CC

OC = A(R/Q)

CC = 1/2(QVW)

Total Cost = A(R/Q) + 1/2(QVW)

Q=


Introduction to inventory

Total Cost Analysis

Total Cost = OC + CC + Tr + PC + It + SS + Other

Where:

OC = Order Placement Cost

CC = Inventory Carrying Cost

Tr = Transportation Cost

PC = Product Cost

It = Inventory in Transit Cost

SS = Safety Stock Cost


Introduction to inventory

Total Cost Analysis

Total Cost = OC + CC + Tr + PC + It + SS + Other

OC = A(R/Q)

CC = 1/2(QVW)

Tr = rRwt/100

PC = VR

It = iVRt/365

SS = BVW

Where:

Q, R, A, V, W = As previously defined

r = Transportation rate per 100 pounds (CWT)

wt = Weight per unit

i = Interest rate or cost of capital

t = Lead time in days

B = Buffer of inventory to prevent stockouts


Introduction to inventory

$

TC

~

CC

~

PC

TR

OC

r1

p1

r2

p2

Quantity

Total Cost without Coordination

of Purchasing and Transportation


Introduction to inventory

$

TC

~

CC

~

PC

TR

OC

r1/p1

r2/p2

Quantity

Total Cost without Coordination

of Purchasing and Transportation


Introduction to inventory

Computing Safety Stock

(BVW)

If sales are constant and there is no variation in delivery times,

no buffer is necessary, i.e., safety stock is not a relevant cost.

If sales or lead times vary, safety stock is necessary to maintain

desired service levels.

Begin with Order Point


Introduction to inventory

Quantity

Order

Point

Time

Lead Time

Setting Order Points

No Uncertainty

Order Point = Daily Use X Lead Time in Days

Place orders when stock level falls to the level of the

order point.


Introduction to inventory

Quantity

Order

Point

Lead Time

Time

Stockout

Setting Order Points

With Uncertainty

Order Point = Mean Daily Use X Lead Time in Days

To Protect Against Stockouts, Place Orders Sooner

But How Much Sooner?


Introduction to inventory

Setting Order Points

With Uncertainty

Place orders when stock levels fall to the mean, and half the time you have enough to cover sales and half the time you don’t; i.e., you have a 50% Fill Rate.

Raise the order point, and you raise the service level.

One Standard Deviation of Buffer Stock Provides an 84% Fill Rate

Two Standard deviations of Buffer Stock Provides a 97.5% Fill Rate

How Do We Know?

Example


Introduction to inventory

Sales

Day (Xi) (Xi ‑ X) (Xi – X)2

1 100 0 0

2 90 ‑10 100

3 110 10 100

4 85 15 225

5 105 5 25

6 110 10 100

7 95 ‑5 25

8 115 15 225

9 100 0 0

10 90 ‑10 100

11 110 10 100

12 90 ‑10 100

SUM 1200 0 1100

Mean = 100; Std Dev = 10

Average Daily Sales


Introduction to inventory

Mean and Standard Deviation

of Average Daily Sales

Mean = 1200/12 = 100

___________ ________

Std Dev =√ (Xi – X)2 = √1100/11 = 10

n-1


Introduction to inventory

Assume constant delivery time of one day, i.e., no variation

Mean Sales = 100 units

Standard Deviation of Sales = 10 units

Order Point = Mean Daily Use X Lead Time in Days + Buffer Stock

Order Point = 100 + 10 = 110

Setting Order Points

With Uncertainty


Introduction to inventory

Setting Order Points

With Uncertainty

Quantity

110

100

Time

Lead Time

Order Point = Daily Use X Lead Time in Days + Buffer Stock

By Ordering Sooner, Stockouts are Avoided

What is the service level (fill rate) associated with this order point?


Introduction to inventory

68%

34%

34%

Sales

90

100

110

Computing Safety Stock

One Standard Deviation = 68% of the area.

Half of the time sales are below 100; 84% of the time sales are below 110.


Introduction to inventory

95%

47.5%

47.5%

Sales

80

100

120

Computing Safety Stock

Two Standard Deviations = 95% of the area.

Half the time sales are below 100; 97.5% of the time sales are below 120.


Introduction to inventory

Areas under the standard normal probability

distribution between the mean and successive values of z

\\\

\\\\

z0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09

0.00.00000.00400.00800.01200.01600.01990.02390.02790.03190.0359

0.10.39800.04380.04780.05170.05570.05960.06360.06750.07140.0753

0.20.07930.08320.08710.09100.09480.09870.10260.10640.11030.1141

0.30.11790.12170.12550.12930.13310.13680.14060.14430.14800.1517

0.40.15540.15910.16280.16640.17000.17360.17720.18080.18440.1879

0.50.19150.19500.19850.20190.20540.20880.21230.21570.21900.2224

0.60.22570.22910.23240.23570.23890.24220.24540.24860.25180.2549

0.70.25800.26120.26420.26730.27040.27340.27640.27940.28230.2852

0.80.28810.29100.29390.29670.29950.30230.30510.30780.31060.3133

0.90.31590.31860.32120.32380.32640.32890.33150.33400.33650.3389

1.00.34130.34380.34610.34850.35080.35310.35540.35770.35990.3621

1.10.36430.36650.36860.37080.37290.37490.37700.37900.38100.3830

1.20.38490.38690.38880.39070.39250.39440.39620.39800.39970.4015

1.30.40320.40490.40660.40820.40990.41150.41310.41470.41620.4177

1.40.41920.42070.42220.42360.42510.42650.42790.42920.43060.4319

1.50.43320.43450.43570.43700.43820.43940.44060.44180.44290.4441

1.60.44520.44630.44740.44840.44950.45050.45150.45250.45350.4545

1.70.45540.45640.45730.45820.45910.45990.46080.46160.46250.4633

1.80.46410.46490.46560.46640.46100.46780.46860.46930.46990.4706

1.90.47130.47190.47260.47320.47380.47440.47500.47560.47610.4767

2.00.47720.47780.47830.47880.47930.47980.48030.48080.48120.4817

2.10.48220.48260.48300.48340.48380.48420.48460.48500.48540.4857

2.20.48610.48640.48680.48710.48750.48780.48810.48840.48870.4890

2.30.48930.48960.48980.59800.49040.49060.49090.49110.49110.4916

2.40.49180.49200.49220.49250.49270.49290.49310.49320.49340.4936

2.50.49380.49400.49410.49430.49450.49460.49480.49490.49510.4952

2.60.49530.49550.49560.49570.49590.49600.49610.49620.49630.4964

2.70.49650.49660.49670.49680.49690.49000.49710.49720.49730.4974

2.80.49740.49750.49760.49770.49770.49780.49790.49790.49800.4981

2.90.49810.49820.49820.49830.49840.49840.49850.49850.49860.4986

3.00.49860.49870.49870.49880.49880.49890.49890.49890.49900.4990

4.00.49997


Introduction to inventory

SDt =

(t)(SD)2 + (D)2 (St)2

Effects of Delivery Time Variation

Where:

SDt = Standard Deviation of Demand over time(Units of Safety Stock required to satisfy 68 percent of sales levels during lead time)

t = Average delivery time

St = Standard Deviation of delivery time

D =Average Demand

SD =Standard Deviation of Demand


Introduction to inventory

Example

ASSUMPTIONS

Average Sales (D) = 100 units

Standard Deviation of Sales (SD ) = 10 units

CARRIER A CARRIER B

 Average Transit Time (t) 5 Days 5 Days

 Standard Deviation of Time (St) 1 Day 2 Days


Introduction to inventory

Example

(Continued)

Combined standard deviations

CARRIER A

SDt = (5) (10)2 + (100)2 (1)2 = 102 units

CARRIER B

SDt = √ (5) (10)2 + (100)2 (2)2 = 201 units


Introduction to inventory

Example

(Continued)

Assumptions:

Cost of Carrying Safety Stock = BVW

(Buffer Stock) X (Value) X (Carrying Cost)

Value per Unit = $100.00

Carrying Cost = 20 percent

Service Level = 97.5 percent a

________________________________________________

a To attain a 97.5% service level, the shipper will have to

add 2 standard deviations of safety stock to the order point.


Introduction to inventory

Example

(Continued)

CARRIER A: SDt = 102 units

Cost = 2 X 102 X 100 X .2 = $4,080

CARRIER B: SDt = 201 units

Cost = 2 X 201 X 100 X .2 = $8,040

Additional cost of using a less reliable carrier:

($8,040 ‑ $4,080) = $3,960


Introduction to inventory

Inventory and the Number of Facilities

Basic Trade-off

More facilities = more inventory

More facilities = shorter shipments

Tie in with ABC Analysis

Consolidate slow moving items in central locations

Trade increased transportation for reduced inventory

or vice versa


Introduction to inventory

X

Inventory and the Number of Facilities

$

(Y)

Y= b

Number of Facilities (X)


Introduction to inventory

Joint Replenishment

Order multiple items at the same time.

When any item hits an order point, place orders for all items.

Constraint: Order only full truckloads (e.g., 40,000 lbs).


Introduction to inventory

Q + I - P

)

(

- Ii + Pi

Qi = Ri

R

Joint Replenishment

Where:

Qi = Order Quantity of the ith item (to be determined)

Ri = Annual Rate of Use of the ith item

Ii = Inventory on hand for the ith item

Pi = Reorder point for the ith item

Q = Total Shipment Size

R = Total of Individual Usage Rate

I = Total of Individual Inventory Items on Hand

P = Total of Individual Reorder Points


Introduction to inventory

Units

Ri Pi Ii

Corn 6,400 163 154

Beans 9,800 218 250

Peas 5,100 150 180

Totals 21,300 531 584

Cases =25 pounds

Ri Pi Ii

Corn160,000 4,075 3,850

Beans245,000 5,450 6,250

Peas127,000 3,750 4,500

Totals 532,50013,27514,600

R P I

Joint Replenishment

Example: Corn, Beans, Peas


Introduction to inventory

Q + I - P

)

(

- Ii + Pi

Qi = Ri

R

Corn:

Qi = 160,000 (40,000+14,600-13,275) - 3,850 + 4,075 = 12,641

532,500

Beans:

Qi = 245,000(40,000+14,600-13,275) - 6,250 + 5,450 = 18,213

532,500

Peas:

Qi = 127,500(40,000+14,600-13,275) - 4,500 + 3,750 = 9,145

532,500 40,000

Joint Replenishment

Example: Corn, Beans, Peas


  • Login