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)=12,550 units
Order Cost (S)= $175 per order
Holding Cost per unit =8% of the unit price
Price Ranges:
1-999 units: Price = $91 per unit1000-3499 units: Price = $88 per unit3500-5999 units: Price = $86 per unit
Step 1: Calculate Holding Cost (H) for each price range
The holding cost per unit is 8% of the unit price.
For 1-999 units (Price = $91):
H=0.0891=7.28perunitperyearH =0.08\times 91=7.28\,\text{per unit per year}H=0.0891=7.28perunitperyear
For 1000-3499 units (Price = $88):
H=0.0888=7.04perunitperyearH =0.08\times 88=7.04\,\text{per unit per year}H=0.0888=7.04perunitperyear
For 3500-5999 units (Price = $86):
H=0.0886=6.88perunitperyearH =0.08\times 86=6.88\,\text{per unit per year}H=0.0886=6.88perunitperyear
Step 2: 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).
EOQ=2DSHEOQ =\sqrt{\frac{2DS}{H}}EOQ=H2DS
Where:
D =12,550(demand)
S =175(ordering cost)
H = Holding cost per unit (calculated above)
For Price Range 1-999 units (Price = $91, Holding Cost = $7.28):
EOQ=212,5501757.28=4,387,5007.28602,325.27776.6unitsEOQ =\sqrt{\frac{2\times 12,550\times 175}{7.28}}=\sqrt{\frac{4,387,500}{7.28}}\approx \sqrt{602,325.27}\approx 776.6\,\text{units}EOQ=7.28212,550175=7.284,387,500602,325.27776.6units
So, the optimal order quantity is 777 units.
For Price Range 1000-3499 units (Price = $88, Holding Cost = $7.04):
EOQ=212,5501757.04=4,387,5007.04623,442.05790.8unitsEOQ =\sqrt{\frac{2\times 12,550\times 175}{7.04}}=\sqrt{\frac{4,387,500}{7.04}}\approx \sqrt{623,442.05}\approx 790.8\,\text{units}EOQ=7.04212,550175=7.044,387,500623,442.05790.8units
So, the optimal order quantity is 1000 units.
For Price Range 3500-5999 units (Price = $86, Holding Cost = $6.88):
EOQ=212,5501756.88=4,387,5006.88638,365.22798.98unitsEOQ =\sqrt{\frac{2\times 12,550\times 175}{6.88}}=\sqrt{\frac{4,387,500}{6.88}}\approx \sqrt{638,365.22}\approx 798.98\,\text{units}EOQ=6.88212,550175=6.884,387,500638,365.22798.98units
So, the optimal order quantity is 3500 units.
Step 3: Calculate Total Cost (TC)
The total cost (TC) is the sum of the ordering cost and the holding cost:
TC=(DQ)S+(Q2)HTC =\left(\frac{D}{Q}\right)\times S +\left(\frac{Q}{2}\right)\times HTC=(QD)S+(2Q)H
Where:
D =12,550 units (demand)
S =175(ordering cost)
H = Holding cost per unit (calculated above)
Q = Optimal order quantity
For 1-999 units (Price = $91, Holding Cost = $7.28, Q =777 units):
Ordering cost:
12,550777=16.15(ordersperyear)\frac{12,550}{777}=16.15\quad \text{(orders per year)}77712,550=16.15(ordersperyear)16.15175=2,826.2516.15\times 175=2,826.2516.15175=2,826.25
Holding cost:
77727.28=2,828.52\frac{777}{2}\times 7.28=2,828.5227777.28=2,828.52
Total cost:
TC=2,826.25+2,828.52=5,654.77TC =2,826.25+2,828.52=5,654.77TC=2,826.25+2,828.52=5,654.77
For 1000-3499 units

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!