Question

PLEASE USE EXCELUPD United Parcel Delivery (UPD) owns a fleet of 1800 delivery trucks serving the metropolitan Chicago area. All trucks are maintained at a central garage. On the average, four trucks a week require a new engine. Engines cost $900 each, and the delivery time is two weeks. There is a fixed order cost of $130, and UPD uses an annual inventory holding cost rate of 30%. For each week a truck is out of service, UPD estimates it suffers a loss of $80. That is in addition to about $1000 they need to allocate for administrative cost to answer customer complaints.

a) What is the reorder point? using Excel

b) What is the optimal inventory level for engine? use EXcel

c) How many spare engins are allowed to be in repair/not ready? d) What is the cycle time e) How many orders per year? f) What is the total annual cost?please use excel

Answer 1

a)reorder point =

A=Annual Usage=4 X 52Weeks=208

O= ordering cost per order=$130

C=Annual Carrying Cost of one Unit=900 X 30%=270

Reorder point=

=14.15

=15 Units Because units canot be placed in decemals

b.optimal inventory level for engine=Reorder point=15 units

c. spare engins are allowed to be in repair/not ready=optimal inventory level for engine=Reorder point=15 units

d.cycle time=365/15=24.33 days

e.orders per year=208/15=14 Orders

f.total annual cost=ordering cost+1/2 X carrying cost=14X130+270/2=1955