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 800 valves; order cost is $7 per order; and annual inventory holding costs are $2.15per unit.DVendor Aunits at a time fromVendor CVendor BQuantity1-1415-2425-99100-199200-399400+Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost?Chris Sandvig Irrigation should order(enter your response as a whole number).Vendor APrice$35.0034.7533.5532.3531.1530.75Vendor DVendor BQuantity1-2425-99100-199200-399400+Price$34.7534.0032.8031.6030.50Vendor CQuantity1-4950-149150-299300+Price$34.5033.7532.5031.10Vendor DQuantity1-149150-299300+Price$34.2533.0031.00

Given data is Annual demand (D) = 800 valves Holding cost (H) = $7 per order Order cost (S) = $2.15…

Answered: Chris Sandvig Irrigation, Inc., has…

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

None
Competitive Dimensions include I. Delivery Reliability II. Location III. Brand IV. Quality V. Price Option I and III Option I and IV Option I, IV and V Option II and IV
Chris Sandvig Irrigation, Inc., has summarized theprice list from four potential suppliers of an underground controlvalve. See the accompanying table on the next page. Annual usageis 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 isbest if Sandvig Irrigation wants to minimize total cost?
Asia Furnishing is a retailer of modular toilet products. Currently, the lead time for one of the products, the toilet door, is relatively high, at 5 weeks. The average demand for toilet doors is 200 per week. The standard deviation of demand during the lead time is 85 doors. The store plans to provide a service level of 99 per cent. (a) The store is looking for another supplier who can supply the doors in one week at the same price. Analyse how much safety stock can be reduced by moving to the new supplier without reducing the 99 per cent cycle-service level. (b) The store hired a new manager who insists on using a probability distribution for the lead time of supply, instead of a fixed lead time. Based on the historical data from the present supplier, she estimated that the standard deviation of lead time is 1 week. How will the amount of safety stock change after including this information? What should be the reorder level for the store? Do state all…
How would these factors affect an EOQ analysis?(1) The use of just-in-time procedures.
A hospital treating COVID patients needs to buy gloves, gowns, and masks for the health care professionals working at the facility. The hospital has two suppliers who can supply the items. The cost, and the maximum number of each item each supplier can provide is given below: Supplier A Supplier B Gloves (cost, max units) ($0.30/unit, 20,000) ($0.35/unit, 11,000) Gowns Masks ($2.00, ($2.50, 5000) 10,000) ($1.75, 7000) ($2.55, 9,500) The hospital immediately needs 30,000 units of gloves, 5500 units of gowns, and 12,500 masks. To account for the economies of scale in logistics, the Supplier A has a requirement of at least 25,000 units in the order, while Supplier B has a requirement of a minimum order size of 10,000 units and a maximum order size of 20,000. What is is the minimum total cost of order that the hospital needs to pay to the suppliers to get the items?
link of PDF : https://docdro.id/psUSO2n https://docdro.id/KV8USNQ question : 1/. According to Simpson and et.al, why should we measure the performance of our suppliers?
Briefly describe how supply chain planning and control is managed in an ERP system.
please show work in excel The New Haven Foundation gave a grant to the Affordable Computers Co.(ACC) to manufacture low cost computers for children in developing countries. ACC needs 3000 memory chips per month for use in producing these hardware. The ordering cost is 12 dollars, and holding cost is 0.3 dollars per chip per year. a) What is the economic order quantity for the memory chips? b) Based on your answer to part (a), what would be the time between orders? (Hint: Q/D)
Reactions and additional comments: Per the textbook definition, the term bullwhip effect “Describes the distortions in a supply chain caused by changes in customer demand, resulting in large swings in inventory levels as the orders ripple upstream from the retailer to the distributor and manufacturer” (Wallace, 2020, p. 137). The term is derived from physics. When cracking a whip, someone just has to snap their wrist and it causes a wave like effect that increases with a chain reaction. The bullwhip effect is a term that was first used in the 1990s. The makers of Pampers had many changes in order volumes, when usually diapers were bought at a constant rate (The Bullwhip effect : History and solutions, 2021). This caused the company to receive hard hits in demand with each new order from the retailers. For example, during the Covid-19 pandemic, everyone was told to stay home, go to school from home, and work from home. This caused the need for many more computers and electronic…
please answer part c. thank you
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900

SEE MORE QUESTIONS

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