Question

Floral Beauty, Inc., is a large floral arrangements store located in Asheville Mall. Bridal Lilies, which are a specially created bunch of lilies for bridal bouquets, cost Floral Beauty $19 each. There is an annual demand for 22,000 Bridal Lilies. The manager of Floral Beauty has determined that the ordering cost is $85 per order, and the carrying cost, as a percentage of the unit cost, is 14%. Floral Beauty is now considering a new supplier of Bridal Lilies. Each lily would cost only $17.50, but to get this discount, Floral Beauty would have to buy shipments of 2,000 Bridal Lilies at a time.

Should Floral Beauty use the new supplier and take this discount for quantity buying?
Determine:
a) What is the EOQ for the current supplier?
b) What is the annual ordering cost for the current supplier?
c) What is the holding cost per unit per year for the current supplier?
d) What is the total annual inventory cost (including purchase cost) for the current supplier?
e) What is the annual holding cost for the new supplier (when purchasing 3,000 each order)?
f) What is the total annual inventory cost (including purchase cost) for the new supplier (when purchasing 3,000 each order)?

Answer 1

a. 1186

b. $1,576.73

c. $2.66

d. $419,578.96

e. $623,33

f. $389,298.33

Step-by-step explanation:

a) What is the EOQ for the current supplier?

EOQ = √(2×Annual Demand×Ordering Cost) / Holding Cost per unit

= √(2×22,000×$85) / $19 × 14%

= 1186

b) What is the annual ordering cost for the current supplier

annual ordering cost = Total demand / EOQ × Cost per order

= 22,000/1186 × $85

= $1,576.73

c) What is the holding cost per unit per year for the current supplier?

holding cost per unit = $19 × 14%

= $2.66

d) What is the total annual inventory cost (including purchase cost) for the current supplier

total annual inventory cost = Purchase Cost + Ordering Cost + Carrying Cost

= 22,000×$19 + $1,576.73 + (1186/2) × $2.66

= $419,578.96

e) What is the annual holding cost for the new supplier (when purchasing 3,000 each order)

annual ordering cost = Total demand / EOQ × Cost per order

= 22,000/3,000 × $85

= $623,33

f) What is the total annual inventory cost (including purchase cost) for the new supplier (when purchasing 3,000 each order)?

total annual inventory cost = Purchase Cost + Ordering Cost + Carrying Cost

= 22,000×$17.50 + $623,33 + (3,000/2) × ($17.50 × 14%)

= $389,298.33