ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision:Annual demand is 5000 unitsOrdering cost is $100 per orderAnnual holding cost is 25%How much is the EOQ for each quantity discount?How much should be the EOQ?

Optimal order quantity is the ideal quantity of products that the company should buy to decrease the…

Answered: How much is the EOQ for each quantity…

Business

Operations Management

How much is the EOQ for each quantity discount? How much should be the EOQ?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 15P

See similar textbooks

Similar questions

Kris Lee, the owner and manager of the Quality Hardware Store, is reassessing his inventory policy for hammers. He sells an average of 50 hammers per month, so he has been placing an order to purchase 50 hammers from a wholesaler at a cost of $20 per hammer at the end of each month. However, Kris does all the ordering for the store himself and finds that this is taking a great deal of his time. He estimates that the value of his time spent in placing each order for hammers is $75. What would the unit holding cost for hammers need to be for Kris' current inventory policy to be optimal according to the basic EOQ model? What is this unit holding cost as a percentage of the unit acquisition cost? What is the optimal order quantity if the unit holding cost actually is 20 percent of the unit acquisition cost? What is the corresponding value of TVC? What is TVC for the current inventory policy? If the wholesaler typically delivers an order of hammers in 5 working days (out of 25 working…
Ray wishes to determine the optimal order quantity for its best-selling bike in his bike store. Ray pays the supplier a wholesale price of $118 each for this bike. Ray has estimated the average daily demand for this bike is 23 units. The store opens 304 days a year. The cost to carry one bike in the store for a whole year is 8% of the unit bike cost. Ray has estimated that, on average, the order processing cost, i.e., ordering cost, with the bike supplier each time is $152, and it roughly takes 20 working days to receive the order from the supplier. Ray wishes to avoid the stock-out situation with a probability of 95%, and this requires Ray to carry a safety stock of 30 bikes in the store. What is the optimal order quantity (EOQ value) that Ray should order each time from the bike supplier to minimize his long-run inventory cost?
The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jeans Company uses 35,000 yards of denim per year to make jeans. The cost of ordering denim from the textile company is $500 per order. It costs Western $0.35 per yard annually to hold a yard of denim in inventory. Determine the optimal number of yards of denim the Western Jeans Company should order, the minimum total annual inventory cost, the optimal number of orders per year, and the optimal time between orders.
Hayes electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters as follows: (a) both ordering cost and carrying cost are 10% less that originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.
Square City Appliance orders four types of washing machines. Table 7 gives the annual demand, purchasing cost, and annual holding cost (as a percentage of purchase cost), and the fixed cost of ordering a product. Determine an ordering policy that minimizes the sum of fixed and holding costs. Each time an order is delivered, a $10,000 cost is incurred. Determine an ordering policy to minimize annual cost of meeting demand. TABLE 7 Product 1 Product 2 Product 3 Product 4 Annual demand 10,000 3,000 4,000 500 Unit purchasing cost $400 $300 $200 $900 Holding cost percentage .2 .2 .2 .2 Product order cost $1,000 $1,000 $1,000 $1,000 Step-by-step solution Step 1 of 3 Square city appliance orders four types of washing machines. The annual demand, purchasing cost and annual holding cost (as a percentage of purchase cost) and the fixed cost of ordering a product are given in the table below. Also each time an order is…
ANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?
ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is…
JAL Trading is a Hong Kong manufacturer of electroniccomponents. During the course of a year it requires container cargo space on ships leaving Hong Kong bound forthe United States, Mexico, South America, and Canada.The company needs 280,000 cubic feet of cargo space annually. The cost of reserving cargo space is $7000 and thecost of holding cargo space is $0.80/ft3. Determine howmuch storage space the company should optimally order,the total cost, and how many times per year it should placean order to reserve space
Blade Breakers Ltd. manufactures blades. The following are the details of their operation during 2020: Average monthly market demand 2,000 blades Ordering costs $ 200 per order Inventory carrying costs 20% per annum Cost of lamps $ 1000 per blade Normal usage 100 blades per week Minimum usage 50 blades per week Maximum usage 200 blades per week Lead time to supply 4 - 6 weeks Compute: Economic order quantity. Maximum level of stock. Minimum level of stock. Re-order level of stock. What tradeoffs in costs are involved in computing the Economic Order Quantity?
The Interstate Carpet Discount Store has annual demand of10,000 yards of Super Shag carpet. The annual carrying costfor a yard of this carpet is $1.25, and the ordering cost is$300. The carpet manufacturer normally charges the store $8per yard for the carpet. However, the manufacturer has offered a discount price of $6.50 per yard if the store will order5000 yards. How much should the store order, and what willbe the total annual inventory cost for that order quantity?
TJ, Inc. makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ, Inc. just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Amount (pounds) Cost per Shipment ($) Almond 6,100 7,500 Brazil 7,400 7,025 Filbert 7,400 6,750 Pecan 6,000 7,100 Walnut 7,400 7,875 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts. An accountant at TJ, Inc. analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.70 for the Regular Mix,…
Geox Ltd buys shoes from a supplier in Italy and sells them on to retailers in Australia. Geox Ltd currently uses an EOQ model to determine the number of shoes to send to order. The annual demand for shoes is approximately 45,600. The ordering cost is $55 per order. The annual cost of physically storing shoes is $8.75 per unit. The insurance on the inventory (shoes) cost is $4.25 per unit. The opportunity cost (annual ROI 25% x $30) is $7.50 per unit. The accountant of Geox Ltd, Richard Branson, recently attended a seminar on Just-in-Time (JIT) and is considering how the ideas of JIT differ from traditional techniques like EOQ and how they may help to manage inventory more efficiently. REQUIRED: A) Use the EOQ model to determine the optimal number of shoes per order. (show calculations) B) If it takes two weeks to receive an order, at what point should Geox Ltd reorder shoes? (show calculations) C) Geox Ltd has determined that demand may vary from the average by up to 25%. To handle…