In: Accounting
Calculate the EOQ for the following items based on the information given. | |||||
Annual Demand | Annual Holding Cost (per unit) | Order Cost | |||
Item #1 | 30000 | $0.75 | $25.00 | ||
Item #2 | 15000 | $3.15 | $30.00 | ||
Item #3 | 55000 | $2.50 | $20.00 | ||
Item #4 | 80000 | $2.00 | $40.00 | ||
EOQ | |||||
Item #1 | |||||
Item #2 | |||||
Item #3 | |||||
Item #4 |
Item#1) Annual Demand | 30,000.00 |
Ordering costs | 25.00 |
Carrying costs | 0.75 |
EOQ = Underroot(2*A*O)/C | |
EOQ = Underroot(2*30000*25)/0.75 | |
EOQ = Underroot(1500000/0.75) | |
EOQ = Underroot(2000000) | |
EOQ = 1414.21 Units | |
Item#2) Annual Demand | 15,000.00 |
Ordering costs | 30.00 |
Carrying costs | 3.15 |
EOQ = Underroot(2*A*O)/C | |
EOQ = Underroot(2*15000*30)/3.15 | |
EOQ = Underroot(900000/3.15) | |
EOQ = Underroot(285714.29) | |
EOQ = 534.52 Units | |
Item#3) Annual Demand | 55,000.00 |
Ordering costs | 20.00 |
Carrying costs | 2.50 |
EOQ = Underroot(2*A*O)/C | |
EOQ = Underroot(2*55000*20)/2.5 | |
EOQ = Underroot(1100000/2.50) | |
EOQ = Underroot(440000) | |
EOQ = 663.32 Units | |
Item#4) Annual Demand | 80,000.00 |
Ordering costs | 40.00 |
Carrying costs | 2.00 |
EOQ = Underroot(2*A*O)/C | |
EOQ = Underroot(2*80000*40)/2 | |
EOQ = Underroot(6400000/2) | |
EOQ = Underroot(3200000) | |
EOQ = 1788.85 Units |