Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventoryholding costs are $7.55 per unit.DDVendor AQuantity1-1415-2425-99100-199200-399400+Price$35.0034.7533.5532.3531.1530.75Vendor CVendor DVendor ADVendor BVendor BWhich vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost?Chris Sandvig Irrigation should orderunits at a time from(enter your response as a whole number).Quantity1-2425-99100-199200-399400+Price$34.7534.0032.8031.6030.50MacBook AirOVendor CQuantity1-4950-149150-299300+Price$34.5033.7532.5031.10Vendor DQuantity1-149150-299300+Price$34.2533.0031.00Next

EOQ = Sqrt(2*D*S/h) D = Annual Demand= 1100 S = Order Cost = 10 h = Holding Cost= 7.55 EOQ =…

Answered: migation, Inc., has holding costs are…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

03) Halifax Souvenir Company currently orders 500 units four times each year. Each order costs $12 and each unit costs $1.20 per year to carry. On average, it takes 5 days to receive an order from the supplier. The company operates 250 days per year. Required: 1. What is the EOQ? 2. Calculate total annual inventory cost under EOQ. 3. What is the current inventory cost? 4. What is the re-order point?
TOPIC : Inventory Systems for Independent Demand
A. Ltd buys 400 units of an item at a purchase cost Sh.5000 per unit and ordering cost of Sh.2,000 per order placed. The carrying cost is estimated at 24% of cost of an item p.a. The Co. has received a 2% discount offer for purchases of 100 or more units. Required: a) Determine the best inventory policy for this item. b) Determine the discount level at which the firm will be indifferent between taking and not taking the discount offer.
Develop an EOQ solution and calculate total relevant costs for the data in the preceding table.
IL Data related to the inventories of Metro Supply are presented below: 困 Surgical Equipment $ 260 170 240 Surgical Supplies $ 120 Rehab Rehab Selling price Cost Equipment S 340 Supplies $ 165 90 250 235 162 Replacement cost Costs to sell Normal gross profit ratio 80 158 30 25 10 30% 30% 30% 20% *Show your computation! If not, no credit A) In applying the lower of cost or market rule, the inventory of surgical equipment would be valued at: B) In applying the lower of cost or market rule, the inventory of surgical supplies would be valued at: C) In applying the lower of cost or market rule, the inventory of rehab equipment would be valued at: D) In applying the lower of cost or market rule, the inventory of rehab supplies would be valued at:
Give typed answer only
am. 124.
Question 1 Consider again managing inventory for product 101, provided by Supplier A. Recall thatdemand for 101 is approximately d = 200 units per week. You pay a purchase cost p = $500per unit and value your inventory at r = $550 per unit. You estimate your inventory carry-ing cost rate at r = 18% per year; storing one item of product 101 in your DC requires anequivalent rent (storage cost) of s = $10 per unit per year.Use truckload shipping for your orders of product 101; recall then that your total fixedcost (k + F ) = $900 for any order of size no greater than Q = 700 units. You estimate atotal lead time (order processing plus transit time) of 12 days for these shipments.To reduce your logistics costs, you decide that it might be worthwhile to backorder someof the customer demand you face each cycle. When backordering, you will delay your out-bound shipping of some of your customers’ orders.
Beginning Quantity Ending Inventory Order? Lost Week Demand inventory on-order inventory position (yes/no) Sales 1 100 53 2 40 3 36 4 38 5 55 6 34 7 30 8 31 9 40 10 57 11 30 12 53
If no safety stock is required, what would the re-order point be?
3. a) Calculate the Lot size for Zara production clothes. D d р Q H S = = 11 Annual demand = 400,000 units Daily demand = 400,000/250= 1,600 per day Daily production rate = 4,000 units EOQ desired = 400 = Holding cost $20 per unit Setup cost (to be determined) = b) Determine optimal number of needles to order. D = 1,000 units S = $10 per order H = $.50 per unit per year c) Determine expected number of orders. d) Determine the total annual cost.
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $55, and annual holding cost per unit is $4. O Allen Mfg. Quantity 1-499 500-999 1000+ Unit Price $16.00 15.50 15.00 Baker Mfg. Quantity 1-399 400-799 800+ Unit Price $16.10 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 489 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? The optimal order quantity is 1000 with a total cost of $ (round your responses to the nearest whole number).

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS