Question: Let's walk through the steps for calculating the optimal order quantity, price per unit, and total cost ( including ordering and holding inventory ) given
Let's walk through the steps for calculating the optimal order quantity, price per unit, and total cost including ordering and holding inventory given the information you provided.
Given Information:
Demand D units
Order Cost S $ per order
Holding Cost per unit of the unit price
Price Ranges:
units: Price $ per unit units: Price $ per unit units: Price $ per unit
Step : Calculate Holding Cost H for each price range
The holding cost per unit is of the unit price.
For units Price $:
HperunitperyearH times textper unit per yearHperunitperyear
For units Price $:
HperunitperyearH times textper unit per yearHperunitperyear
For units Price $:
HperunitperyearH times textper unit per yearHperunitperyear
Step : Calculate the Economic Order Quantity EOQ
The EOQ formula helps us determine the optimal quantity to order in order to minimize the total cost of inventory ordering and holding costs
EOQDSHEOQ sqrtfracDSHEOQHDS
Where:
D demand
S ordering cost
H Holding cost per unit calculated above
For Price Range units Price $ Holding Cost $:
EOQunitsEOQ sqrtfractimes times sqrtfracapprox sqrtapprox textunitsEOQunits
So the optimal order quantity is units.
For Price Range units Price $ Holding Cost $:
EOQunitsEOQ sqrtfractimes times sqrtfracapprox sqrtapprox textunitsEOQunits
So the optimal order quantity is units.
For Price Range units Price $ Holding Cost $:
EOQunitsEOQ sqrtfractimes times sqrtfracapprox sqrtapprox textunitsEOQunits
So the optimal order quantity is units.
Step : Calculate Total Cost TC
The total cost TC is the sum of the ordering cost and the holding cost:
TCDQSQHTC leftfracDQrighttimes S leftfracQrighttimes HTCQDSQH
Where:
D units demand
S ordering cost
H Holding cost per unit calculated above
Q Optimal order quantity
For units Price $ Holding Cost $ Q units:
Ordering cost:
ordersperyearfracquad textorders per yearordersperyeartimes
Holding cost:
fractimes
Total cost:
TCTC TC
For units
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
