The annual demand for an item is 20,000 units. The cost to process an order is $25 and the annual inventory holding cost is $4 per item per year. Given the following price-quantity breaks for purchasing the item: Quantity Price 1-1,999 $2.50 per unit 2,000 or more $2.40 per unit What is the quantity you will order each time? Please provide detailed calculation of the total cost (including inventory cost and purchasing cost) for each quantity discount scenario.

The annual demand for an item is 20,000 units. The cost to process an order is $25 and the annual inventory holding cost is $4 per item per year. Given the following price-quantity breaks for purchasing the item: Quantity Price 1-1,999 $2.50 per unit 2,000 or more $2.40 per unit What is the quantity you will order each time? Please provide detailed calculation of the total cost (including inventory cost and purchasing cost) for each quantity discount scenario.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 2CE: Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An...

See similar textbooks

Similar questions

Pietro expects to produce 50,000 units and sell 49,300 units. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Required: 1. Prepare a statement of cost of goods sold in good form. 2. What if the beginning inventory of finished goods decreased by 5,000? What would be the effect on the cost of goods sold?
Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?
Diagnostic Supplies has expected sales of 98,000 units per year, carrying costs of $5 per unit, and an ordering cost of $8 per order. a. What is the economic ordering quantity? Economic ordering quantity b-1. What is the average inventory? Average inventory b-2. What is the total carrying cost? Total carrying cost units units
You are asked to manage the purchases of potatoes (10 kgs per bag). The annual demand = 1200 bags, Deliveredpurchase cost = 30/bags, Annual carrying cost percentage= 10percent, Order cost = 50/order. The lead time is 5 working days. Assuming 24 working days per month. 5.1 Determine the Economic Order Quantity 5.2 Determine the reorder point 5.3 Determine the average inventory5.4 Suppose orders are placed only at review time. Find the optimal period and the optimal orderquantity.
A. Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Required: 1. Compute the economic order quantity. 2. How many orders would be placed under the EOQ policy? 3. Compute the annual ordering cost for the EOQ. 4. Compute the annual carrying cost for the EOQ. 5. Compute the total inventory-related cost at the EOQ. 6. Previously, the company had been purchasing 5,000 units of product X per order: What is the ordering cost per year under the previous policy? ii. The annual carrying cost? iii. How much money does the company save over the policy of purchasing 5,000 units per order using the EOQ policy? i. B. Kings Company presents the following information: 1. Annual credit sales: P 25,200,000 2. Collection period: 3 months 3. Rate of return: 12% Kings company considers changing its credit term from n/30 to 3/10, 1/30. The following are…
Given: Peter Piper has projected sales of 72,000 pipes this year, ordering cost of P6 per order, and carrying costs of P2.40 per pipe. With the given data, can you give me the solution on how to get: -What is the economic ordering quantity? -Total inventory cost at EOQ -How many orders will be placed during the year?-What will the average inventory be? Thank you in advance.
1. Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs and total inventory costs from the following: Annual consumption: 6000 units ; Carrying cost per unit: RO 2 Cost of placing one Order: RO 60 2. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per unit for a year and EOQ is 60 units. 4. If the price of the material is RO 15 per unit and the annual consumption is 4000 units, the interest and store keeping charges are 20% of the value and the cost of placing of an order and receiving the goods is RO 60, how much material should be ordered at one time? 5. Alexander pump LLC uses about 75000 valves per year and the usage is fairly constant at 6250 units per month. The valve…
1. Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs and total inventory costs from the following:Annual consumption: 6000 unitsCost of placing one Order: RO 60Carrying cost per unit: RO 22. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per unit for a year and EOQ is 60 units.4. If the price of the material is RO 15 per unit and the annual consumption is 4000 units, the interest and store keeping charges are 20% of the value and the cost of placing of an order and receiving the goods is RO 60, how much material should be ordered at one time? 5. Alexander pump LLC uses about 75000 valves per year and the usage is fairly constant at 6250 unitsper month. The valve cost of…
1. Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs and total inventory costs from the following: Annual consumption: 6000 units Carrying cost per unit: RO 2 Cost of placing one Order: RO 60 2. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per unit for a year and EOQ is 60 units. 4. If the price of the material is RO 15 per unit and the annual consumption is 4000 units, the interest and store keeping charges are 20% of the value and the cost of placing of an order and receiving the goods is RO 60, how much material should be ordered at one time? 5. Alexander pump LLC uses about 75000 valves per year and the usage is fairly constant at 6250 units per month. The valve…
if the holding cost of an item is $0.15 per unit per day, the ordering cost is $200 per order, the purchasing cost per unit is $12 for any quantity less than 500 units, and $11 otherwise. The daily demand is 80 units. Find the economic order quantity?
The rate of consumption of an item is 20 units per year. The cost of procurement (i.e. placing an order and receiving the goods) per order is Rs. 40. The unit cost is Rs. 100. Inventory carrying cost is 0.16% and it depends upon the average stock. Use Model I to determine: (i) EOQ (ii) If lead time is 3 months, determine the reorder point.
A retailer anticipates selling 3,000 units of its product at a uniform rate over the next year. Each time the retailer places an order for a units, it is charged a flat fee of $50. Carrying costs are S30 per unit per year. How many times should the retailer reorder each year and what should be the lot size to mınımize inventory costs? What is the minimum inventory cost? Use the formula ECQ to obtain your answers. They should order times a year units The minimum inventory cost is $