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

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
EOQ for Production Lots ExerciseA Power Company buys coal from a Coal mine togenerate electricity in rural areas. The Coal minecan supply coal at the rate of 3,500 tons per day for$10.50 per ton. The Power Company uses the coalat a rate of 800 tons per day and operates 365 daysper year. The annual carrying cost for coal is 20%of the acquisition cost, and the ordering cost is$5,000.a) What is the economical production lot size?b) What is the Power Company’s maximuminventory level for coal?
K Cesar Rego Computers, a Mississippi chain of computer hardware and software retail outlets, supplies both educational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of disks: D S I Purchase price Discount price Quantity needed to qualify for the discount = 5,900 disks. What is the EOQ? 36,100 disks $25 22% $0.87 $0.81 EOQ = units (round your response to the nearest whole number). ncorrect
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.
Q4/ Company produced 1000 pieces of air conditioners per year, the order cost is 6000$, the shortage cost is 10% of order cost and the inventory holding cost is one dollars per item per year. Find 1. number of ordering during the year. 2. The interval between two orders. 3. The annual cost. 4. maximum inventory 5. shortage allowable quantity
answer part a b and c
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