Part 1
Banana Inc. currently needs exactly 600 LCD screens per month
for their smartphones. They currently order 450
screens in every order. The contracted price for screens is $20 per
unit and they have calculated the storage and
other inventory holding costs to be 30% of the price per year per
item. Other costs associated with ordering (per
order) are:
- Order placement fees (documentation, network support): $100
- Delivery costs (Fuel, Driver, Truck, etc.): $150
- Cost of receiving an order (Inspection, documentation, etc.):
$200
- Labor cost of purchasing professionals: $150
Answer questions 1 to 16 based on the above information.
1. What is the annual demand?
2. How many orders does Banana Inc. currently place in a
year?
3. How often is the company ordering (in weeks)? (Two
decimals)
4. Under the current ordering policy (Q = 450), what is the total
purchasing cost per year?
5. Under the current ordering policy (Q = 450), what is the total
ordering cost per year?
6. Under the current ordering policy (Q = 450), what is the total
holding cost per year?
7. Under the current ordering policy (Q = 450), what is the total
inventory cost per year?
8. What is the Economic Order Quantity (EOQ)?
9. Under EOQ, how often will the company order (in weeks)? (Two
decimals)
10. Under EOQ, what is the total ordering cost per year?
11. Under EOQ, what is the total holding cost per year?
12. Under EOQ, what is the total inventory cost per year?
13. How much does Banana Inc. save by changing its ordering
quantity to EOQ?
14. The supplier increases the price of LCD screens by 20%. What
would the new EOQ be?
15. By making changes in its warehouse planning, Banana Inc.
reduces the holding cost to 20% (instead of
30%) of the price per year per item. What is the new EOQ? (Ignore
question 14.)
16. After decreasing holding costs, Banana Inc. finds a new company
for transportation. As a result, delivery
costs associated with each order is decreased by $50. What is the
new EOQ? (Ignore questions 14 and 15.)
Part 2
Edison Inc. is an automotive company that manufactures
self-driving cars. These cars require a very expensive
component that costs $1,800 per unit. This component should be
stored in very specific conditions. Also, Edison
Inc. takes very strict and costly security measures to ensure
safety of the inventory of this component. Finally, due
to the rapid advances in technology, this component is expected to
lose its value very quickly. As a result of all of
this, the holding cost per unit per year for this item is very
high, $1,200. Because Edison Inc. buys 2,000 units per
year from the supplier, it is one its biggest buyers. Therefore,
and to make Edison Inc. happy, the supplier pays
delivery costs. As a result, the ordering cost is $400 per
order.
Answer questions 17 to 20 based on the above information.
17. Edison Inc. is using EOQ for this component. How much is its
total inventory cost?
18. Given the risks associated with holding this component, the
supplier wants to motivate Edison Inc. to buy
in larger quantities. Therefore, it offers a 3% discount on the
item price if Edison Inc. buys the item in lot
sizes of 300 units or more. If Edison Inc. decides to accept this
offer, how many units should it buy in each
order? (We call this quantity Q*)
19. If Edison Inc. decides to order Q* in each order instead of
EOQ, how much will its total inventory cost be?
20. Based on your analysis, do you suggest that Edison Inc. accepts
the discounted price and order Q*?
Economic order quantity and its calculations
Part 1 Banana Inc. currently needs exactly 600 LCD screens per month for their smartphones. They...
QUESTION 3 * EOQ no Points Wicker uses 20.000 units per year of a particular item of inventory purchased for £1. It costs £28 for each order placed with the supplier and the cost of holding a unit of inventory for a year is £1:20. What is: 1. the economic order quantity? 2. the total annual cost of ordering and holding inventories for this business?
Joe Birra needs to purchase malt for his microbrewery production. His supplier charges $35 per delivery (no matter how much is delivered) and $1.20 per gallon. Joe’s annual holding cost per unit is 35 percent of the price per gallon. Joe uses 250 gallons of malt per week. Suppose Joe orders 1000 gallons each time. What is his average inventory (in gal)? Suppose Joe orders 1500 gallons each time. How many orders does he place with his supplier each year?...
A firm has been ordering a certain item 600 units at a time. The firm estimates that ordering cost is $200/order, and that annual demand is 1800 units per year. The assumptions of the basic EOQ model are thought to apply. For what value of holding cost (H: avg $cost of holding one piece for 1 year) would their ordering policy (600 units per order) be economically optimal (be the EOQ)? EOQ = Sq Root[(2D*S)/H] Where: D...
CHAP 15 - Q13 DROPDOWN OPTIONS ARE BELOW THIS 13. Calculate economic ordering quantity (EOQ) Inventory costs can be categorized as the costs incurred for holding the inventory, the costs of ordering and receiving the inventory, and the cost of running out of inventory. costs are the direct and indirect costs of keeping inventory on hand. The number of units in the optimal size order is called the economic ordering quantity (E0Q). Murphy Company purchases custom-made durable packing boxes to...
3. Calculate the Economic Ordering Quantity (EOQ) model Aa Aa Inventory costs can be categorized as the costs associated with holding the inventory, ordering and receiving the inventory, or running out of the inventory. For example, costs are the direct and indirect costs of keeping inventory on hand. carrying ordering The number of units in the optimal size order is called the economic ordering quantity (EOQ). Jones Company purchases custom-made durable packing boxes to ship its equipment. Each year, Jones...
Eagle Insurance is a large insurance company chain with a central inventory operation. The company’s fastest-moving inventory item has a demand of 80,000 units per year. The cost of each unit is $200, and the inventory carrying cost is $15 per unit per year. The average ordering cost is $60 per order. It takes about 2 days for an order to arrive. This is a corporate operation, and there are 250 working days per year. (Please show all work including...
Economic Order Quantity Ottis, Inc., uses 656,100 plastic housing units each year in its production of paper shredders. The cost of placing an order is $24. The cost of holding one unit of inventory for one year is $12. Currently, Ottis places 162 orders of 4,050 plastic housing units per year. Required: 1. Compute the economic order quantity. X units 2. Compute the ordering, carrying, and total costs for the EOQ. Ordering cost $ X Carrying cost Total cost 3....
Need help on E, F, and G. PA 12-3 Joe Birra needs to purchase malt for his... Joe Birra needs to purchase malt for his micro-brew production. His supplier charges $40 per delivery (no matter how much is delivered) and $1.25 per gallon. Joe's annual holding cost is 30% of the price per gallon. Joe uses 200 gallons of malt per week. a. Suppose Joe orders 125 gallons each time. What is his average inventory? gallons (Round your answer to...
#1 ArcSite Electrical, which produces generators, purchases a component that is used in its generators directly from the supplier. The generator production operation requires a constant 1,000 components per month. It costs S25 to place each order. The unit cost is S2.50 per component, and the quarterly per-component holding cost is 5% of the value of the component. ArcSite operates 250 working days per year and the component supplier has a lead time of 5 days. (a) What is the...
The H.A.L. Computer Store sells a printer for $230. Demand for this is constant during the year, and monthly demand is forecasted to be 52 units. The holding cost is $22 per unit per year, while the cost of ordering is $45 per order. Currently, the company is ordering 12 times per year (60 units each time). There are 260 working days per year and the lead-time is 7 days.REMEMBER TO EXPLICITLY WRITE THE FORMULAS USED.a.) Given the current policy of ordering 60 units at a time, what is the total of...