You are in charge of ordering a $168.86 fluid control device for your company. The pumps have an annual demand of 28,500 units. Each order costs $785.11 to place. Each pump costs 12.45% to hold. If you purchase less than 1500, there is no discount; purchase 1500 to less than 3000, 7.5% discount; purchase 3000+ units and you receive a 15% discount.
|
1 |
Determine the order quantity |
|
2 |
Based on #1, calculate the number of orders |
|
3 |
Based on #1, calculate the average inventory |
|
4 |
Based on #1, calculate the annual order cost |
|
5 |
Based on #1, calculate the annual holding cost |
|
6 |
Based on #1, calculate the total cost of inventory including purchase cost |
| Answers | |||
| 1 | Determine the order quantity | 3000 | units |
| 2 | Based on #1, calculate the number of orders | 9.50 | orders |
| 3 | Based on #1, calculate the average inventory | 1500 | units |
| 4 | Based on #1, calculate the annual order cost | $ 7,458.55 | |
| 5 | Based on #1, calculate the annual holding cost | $ 26,804.23 | |
| 6 | Based on #1, calculate the total cost of inventory including the purchase cost | $4,124,867.77 |

Answers 2-6 BASED ON ANSWER 1:

Formulas for answer 1:

Calculation of Three ranges

Formulas Ans 1:

Formulas Answer 2-6:

You are in charge of ordering a $168.86 fluid control device for your company. The pumps...
Here is the first part of the question Task 1. A wholesale distributor stocks and sells low flow toilets to contractors for use in commercial office buildings. The estimated annual demand for the toilets is 5,475 units. The estimated average demand per day is 18 units. The purchase cost from the toilet manufacturer is $135.00 per unit. The lead-time for a new order is 5 days. The ordering cost is $90.00 per order. The average holding cost per unit per...
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...
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...
PA 12-2 Sarah's Organic Soap Company makes organic... Sarah's Organic Soap Company makes organic liquid soap. One of the raw materials for her soaps is organic palm oil. She needs 1500 kgs of palm oil per day on average. The supplier charges a $56 delivery fee per order (which is independent of the order size) and $6 per kg. Sarah's annual holding cost is 15%. Assume she operates and sells 5 days per week, 52 weeks per year. If Sarah...
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?...
Hami Company sells school ba gs and the annual demand is estima bags. The ordering cost is RM 36 per order and the holding cost per is 7% of the unit cost. The cost of each bag is normally RM 40 The supplier offers the following discounts to Hami Company: Order Quantity Discount Unit Cost Below 100 units None RM 40.00 7% RM 37.20 200 units or more (15 Marks) a) What would be the optimal order quantity? (15 Marks)...
A local family sports store sells basketball. The store orders the balls from a manufacturer at a cost of $250 per order. The annual holding cost is $6 per unit per year. The purchase price of a basketball is $40 per unit per year. The store has a demand for 48,000 balls per year. The s tock is received 5 working days after an order has been placed. No backorders are allowed. Assume 300 working days a year. a. What...
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...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering cost per order is $50, holding rate is 40%, and unit cost is $200. The department store currently is ordering every two months, but now is offered the following quantity discount scheme: For an order of up to ‘L-1’ units no discount. For an order from L units up to 299 units-a discount of 25%, and for a larger order - a discount of...
Exercise 20.6 (Algorithmic) Ordering and Carrying Costs Ottis, Inc., uses 683,400 plastic housing units each year in its production of paper shredders. The cost of placing an order is $33. The cost of holding one unit of inventory for one year is $12. Currently, Ottis places 170 orders of 4,020 plastic housing units per year. Required: 1. Compute the annual ordering cost. $ 2. Compute the annual carrying cost. $ 3. Compute the cost of Ottis’s current inventory policy. $...