Question

In: Accounting

Calculate the EOQ for the following items based on the information given. Annual Demand Annual Holding...

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

Solutions

Expert Solution

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

Related Solutions

Use the following information to determine the implied inventory holding cost: EOQ = 95 units Demand...
Use the following information to determine the implied inventory holding cost: EOQ = 95 units Demand = 350 units Fixed Ordering Costs = $5 A. $0.39   B. $12.50 C. $2.58 D. $2.56. PLEASE SHOW YOUR WORK
Given the following price and dividend information: A. calculate the holding period return. (Round to 4...
Given the following price and dividend information: A. calculate the holding period return. (Round to 4 decimals) B. calculate the $1 investment equivalent. (Round to 4 decimals) C.calculate the probability of losing money. (Round to 4 decimals) Year Price Dividend 0 50.72 1 43.54 1.75 2 49.22 2.10 3 51.30 2.20 4 52.45 2.50 5 56.35 2.75
Given the following price and dividend information, calculate the holding period return. (Enter percentages as decimals...
Given the following price and dividend information, calculate the holding period return. (Enter percentages as decimals and round to 4 decimals) Year Price Dividend 0 50.72 1 43.54 1.75 2 49.22 2.10 3 51.30 2.20 4 52.45 2.50 5 56.35 2.75
Using the EOQ​ model, if a​ firm's order quantity is 500 units and its annual holding...
Using the EOQ​ model, if a​ firm's order quantity is 500 units and its annual holding cost is greater than its annual setup​ cost, then what can we say about the optimal order​ quantity? A. Optimal order quantity​ = 500 units B. Optimal order quantity​ < 500 units C. Optimal order quantity​ > 500 units D. Not enough information is given to answer the question
1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b....
1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b. holding cost per inventory unit of $2.00 c. estimated demand for inventory of 200,000 Solve EOQ using the information listed above:                                                                   B. Calculate the total cost associated the EOQ amount calculated in part A: C. The company wants to keep Safety Stock of an additional; 8 units. Calculate the cost associated with the safety stock and the total cost of the EOQ amount...
Given the following information, calculate the price elasticity of demand and use it to project how...
Given the following information, calculate the price elasticity of demand and use it to project how the consumer's quantity demanded and expenditure will change in response to a future price increase. Conclude by identifying what your findings suggest about how effective taxing this good would be for a government trying to raise revenue or change behavior. % change (growth rate) = (value new - value old) / value oldElasticity = |% change in quantity / % change in price| Milk...
Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts...
Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts using the economic order quantity. Next, calculate the period order quantities and the planned order receipts. In both cases, calculate the ending inventory and the total inventory carried over the 10 weeks. Please show all work Week 1 2 3 4 5 6 7 8 9 10 Total Net Requirements 75 70 60 0 100 80 70 65 0 80 Planned Order Receipt Ending...
If the annual demand for a specific product is 14,000, the annual holding costs is 0.50...
If the annual demand for a specific product is 14,000, the annual holding costs is 0.50 per unit, and the ordering cost per order is is 50, what is the Economic Order Quantity? Round to the nearest whole number (e.g. 234.3845 would be "234"). BONUS: In addition to answering below (for IW credit) on a sheet of graph paper NEATLY graph Ordering Costs, Carrying Costs, and Total Costs for the following problem. Turn in your hand-written graph at the beginning...
Calculate the effective annual cash flows to a parent company, given the following information. A U.S....
Calculate the effective annual cash flows to a parent company, given the following information. A U.S. based MNC has a subsidiary in the United Kingdom to which it provides periodic management consulting services by sending a consultant to the U.K. four times a year. The consultant holds seminars and provides other services to the subsidiary in its main offices. Each time the consultant works 25 hours in seminars and one-on-one consulting. The Parent company’s cost of hiring the consultant services...
Given the following data, what is the EOQ? TC? No of orders per year, demand/month= 1300...
Given the following data, what is the EOQ? TC? No of orders per year, demand/month= 1300 units, ordering cost=$46, holding cost=$4.50/unit/year
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT