We have demand for a product with 1500 units/month. The vendor offers quantity discounted method for purchasing as the table below: Order Quantity condition 1 - 299 price( USD) 10 >= 300 price 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3$/ order. Monthly Warcehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/ month. Please suggest the best ordering policy.

We have demand for a product with 1500 units/month. The vendor offers quantity discounted method for purchasing as the table below: Order Quantity condition 1 - 299 price( USD) 10 >= 300 price 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3$/ order. Monthly Warcehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/ month. Please suggest the best ordering policy.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Enter the formulas in the template. The numeric answers are to the right. Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered $200.00 $190.00 2,500 Total Cost Order Cost Order Cost (D/Q* Ordering Cost) Carry Cost Carry Cost (Q/2* Carrying Cost) Purchase Cost (D* Price) Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered 72.5 72.5 90.0 125.0 150.0 200.0 $200.00 $190.00 2,500 72.5 36.3 2.8 $13,784.05 Order Cost $6,892 Total Cost $ 293,784.05 $ 233,784.05 $ 194, 105.56 $ 194,875.00 $ $ 198,500.00 $2,500.00 Order Cost (D/Q* Ordering Cost) $6,892.02 $6,892.02 $5,555.56 $4,000.00 195,583.33 $3,333.33 Carry Cost $6,892…
We have demand for a product with 1500 units/ month. The vendor offers. quantity discounted method for purchasing as the table below: Order Quantity condition Price (USD) 1+299 10 >300 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3S/ order. Monthly Warehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/month. Please suggest the best ordering policy. I
(c) A company which produces washing machines has to store a certain item, and two such items are needed to assemble one washing machine. Annual demand for machines is 1000 units. The following information is available. Ordering cost = Rs.250 per order Inventory holding cost = Rs.125 per unit per year Back-order cost = Rs.150 per unit per year Find the following. i) Economic order quantity ii) Optimum level of shortage
Daily demand for product sample kits is normally distributed with a mean of 35 units and a standard deviation of 4. Supply is virtually certain with a lead time of 9 days. The cost of placing an order is $20, and annual carrying costs for one kit is 25 percent. The price of one kit is $12.50. Assume a year has 365 days.If a 99% service level is desired, what is average inventory on hand? If demand had no variation, what would the reorder point be?
Explain the relationship between the annual ordering cost and the ordering size. Why is there a need to compute for the Economic order quantity?
12.27 Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the accompanying table. Annual usage is 2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3.33 per unit. Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? PX VENDOR A QUANTITY 1-49 50-74 75-149 150-299 300-499 500+ VENDOR C QUANTITY 1-99 100-199 200-399 400+ PRICE $35.00 34.75 33.55 32.35 31.15 30.75 PRICE $34.50 33.75 32.50 31.10 VENDOR B QUANTITY 1-74 75-149 150-299 300-499 500+ PRICE $34.75 34.00 32.80 31.60 30.50 VENDOR D QUANTITY 1-199 200-399 400+ PRICE $34.25 33.00 31.00
B). As an inventory manager, you must decide on the order quantity for an item. Its annual demand is 679 units. Ordering costs are $7 each time an order is placed, and the holding cost is 10% of the unit cost. Your supplier provided the following price schedule. Quantity Price per Unit 1 - 100 $5.65 101 - 350 $4.95 351 or more $4.55 What ordering-quantity policy do you recommend?
The mythical Own Distributors has an annual demand of 2,000 units for itshandheld security wands. The average cost of the handheld security wand isUS$140. Carrying cost is 18% of the unit cost of the security wand. Orderingcosts are US$30 per order. If the company orders in quantities of 500 or more,it can get a 6% discount on the unit cost of the security wand. Should the OwenDistributors take the quantity discount?
Ollah's Organic Pet Shop sells bags of cedar chips for pet bedding or snacking (buyers choice). The supplier has offered the following terms: Order 1-100 bags, and the price is $6.00 a bag. Order 101 or more and the price is $4.50 a bag. Annual demand is 630, fixed ordering costs are $9 per order, and the per bag holding cost is estimated to be around $2 per year. What order quantity should Ollah order, based on the volume discount? Is this different from the EOQ? if so how could this be? please show calculations.
Wang Distributors has an annual demand for an air-port metal detector of 1,400 units. The cost of a typical detector to Wang is $400. Carrying cost is estimated to be 20% of the unit cost,and the ordering cost is $25 per order. If Ping Wang, the owner,orders in quantities of 300 or more, he can get a 5% discount on thecost of the detectors. Should Wang take the quantity discount?
Explain why it is not necessary to include product cost(price or price times quantity) in the EOQ model, but thequantity discount model requires this information.