12.27 Chris Sandvig Irrigation, Inc., has summarized theprice list from four potential suppliers of an underground controlvalve. See the accompanying table. Annual usage is 2,400 valves;order cost is $10 per order; and annual inventory holding costsare $3.33 per unit.Which vendor should be selected and what order quantity isbest if Sandvig Irrigation wants to minimize total cost? PXVENDOR AQUANTITY1-4950-7475-149150-299300-499500+VENDOR CQUANTITY1-99100-199200-399400+PRICE$35.0034.7533.5532.3531.1530.75PRICE$34.5033.7532.5031.10VENDOR BQUANTITY1-7475-149150-299300-499500+PRICE$34.7534.0032.8031.6030.50VENDOR DQUANTITY1-199200-399400+PRICE$34.2533.0031.00

EOQ = 120 units (rounded to nearest integer since decimal value cant be procured)

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

Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Price/Unit Holding Cost/Unit Lead Time (L) (p) (wks) Supplier 10,000 25,000 50,000 Bradley $40,000 $26,000 $19,000 Alexander $30,000 $28,000 $17,000 $7.15 $7.15 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? and a shipping quantity of Using Annual Freight Costs Shipping Quantity (Q) -w an example Get more help. (H) $1.43 $1.43 6 4 Annual…
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)
The cash discount is 1. the most common industry discount 2. given to the special vendors 3. Is given when they purchase a large quantity 4. given when the delivery is accepted early
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) (p) $7.15 $7,15 Annual Supplier Bradley Alexander 10,000 25,000 $40.000 $26.000 50,000 $18.000 Cost/Unit (H) (wks) Administrative Cost $15.000 $1.43 $1.43 $30,000 $25,000 $17,000 6 $10,000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using V and a shipping…
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…
So, what exactly is the function of finished-goods inventory?
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 inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 Next
With added emphasis being placed on efficiencies in the supply chain, P&G’s CEO has asked you to evaluate costs associated to inventory control of wool as it presents opportunities of improved cost savings. Advise on the ideal number of units of wool that should be ordered to minimise costs, in addition comment on the ROP for wool given the information provided. Lastly, indicate the downside of depending on the EOQ model for an organisation such as P&G.
4. Distinguish between a supplier and a prime vendor. 5. Describe the Farm/School Meals Initiative.
Where inventory is positioned in the supply chain?
Taylor Products distributes two premium kid chairs-Hayden Recliner and Hadley Rocking. Fixed expenses total $390,000 per month. Sales Contribution Margin Ratio Hayden Recliner Hadley Rocking $600,000 $300,000 75% 45% Based on the current sales mix, what is the break-even point in dollar sales for Hayden Reclin O $400,000 $450,000 O $387,000 O $415,000 $392,000
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $8.80 per stone for quantities of 600 stones or more, $9.20 per stone for orders of 400 to 599 stones, and $9.70 per stone for lesser quantities. The jewelry firm operates 230 days per year. Usage rate is 16 stones per day, and ordering costs are $45.a. If carrying costs are $2 per year for each stone, find the order quantity that will minimize total annual cost. (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) b. If annual carrying costs are 20 percent of unit cost, what is the optimal order size? (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) c. If lead time is 3 working days, at what point should the company reorder? (Do…

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