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

Your company has the following items in inventory: Unit Cost $9 $90 $6 Item A B с D E F G H Annual Demand 1200 100 4500 400 35 250 1000 100 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does? d) Define and discuss the term "productivity" with help of productivity equation.
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?
Given the information below, conduct an ABC analysis and determine which items should be classified as A, B, and C. Which items do you suggest the firm keep the tightest control over? Explain. Item Part Number Item Cost Quantity In Stock 142-AZ $546.00 318 4392-GF $45.00 1250 86935-ES $15.35 3546 173-DC $653.00 1876 999-BA $199.00 526 7846-NM $23.00 973 2765-OP $385.00 790 103-VX $12.50 4875 2648-YT $16.75 5185
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)
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…
[8] United States. Your harvest has just come in and you picked 795,000 pounds of apples. You need to distribute the harvest to the appropriate warchouse locations. You manage an apple orchard that distributes fruit throughout the southeast part of the [A] Using the following warchouse information, allocate the apples to their appropriate locations. DEMAND STANDARD DESIRED WARE CURRENT STOCK DEVIATION OF DEMAND HOUSE INVENTORY FORECAST AVAIL- ABILITY Atlanta 35,000 lbs 190,000 lbs 20,000 lbs 95% Miami 10,000 Ibs 170,000 lbs 18,000 lbs 95% Columbia 45,000 lbs 155,000 Ibs 10,000 lbs 85% Memphis 5,000 lbs 145,000 Ibs 25,000 lbs 80% [B] Discuss two additional methods to push inventory into a network.
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.
Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon to be introduced to the market. The annual requirements (D) are 40,000 units and Horizon's plant operates 250 days per year. The data for three suppliers are in the attached table. Annual Freight Costs Shipping Quantity (Q) Supplier 10,000 20,000 Price/Unit (p) Annual Holding Cost/Unit (H) Lead Time (L) (days) Annual Administrative Cost Material Costs Abbott $11,000 $8,500 $29 $5.80 4 $11,000 $232,000.00 Baker $12,000 $9,500 $31 $6.20 3 $12,000 $1,240,000 Carpenter $9,000 $7,000 $28 $5.60 8 $9,000 $1,120,000 Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular? Using the supplier [X] and a shipping quantity of [X] units is the lowest cost alternative, with annual total costs to Horizon Cellular of [X]. (Quantity and Annual Total Costs are integer…
6.
4. Oxford Breeze School is gearing up to start their new session. Just like other grammar schools, they too provide goodie bags to their students. To source the bags, they have asked for quotations from their long-term supplier. The supplier's quote has given below: No. of Goodies Price 800 $8 801- 1200 $7 1200+ $6 The school operates 250 days per year. Daily usage rate is 35 goodies and ordering costs are $50. Carrying costs is $2. a) Determine an order quantity that will minimize the Total Cost. b) Figure out the Number of orders. c) If lead time is 10 days, at what point should the company re-order?
i need the answer quickly

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