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 60,000 units and Horizon's plant operates 250 days per year. The data for three suppliers are inthe following table.DAnnual Freight CostsShipping Quantity (Q)Annual10,000$11,000SupplierAbbottBakerCarpenterPrice/Unit20,000(P)$8,500$30$6,500$31$5,500Annual HoldingCost/Unit (H)$6.00$6.20Lead Time(L) (days)47Administrative Cost$11,000$9.000$9,000$8,000$29$5.803$8,000Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular?Usingand a shipping quantity ofunits is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your response as an integer.)

Given information:Annual Demand (D) = 60,000 unitsNumber of weeks = 250 daysDaily Demand (d) =…

Answered: Using and a shipping quantity of units…

Using and a shipping quantity of units is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your response as an integer)

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

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

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

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
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 following table. Annual Freight Costs Shipping Quantity (Q) Price/Unit (p) $28 $30 $31 Annual Holding Cost/Unit (H) $5.60 Lead Time Annual 10.000 (L) (days) Supplier Abbott 20,000 Administrative Cost $7,500 $6,000 $9,000 $10.000 $9.000 $11.000 $10,000 $9.000 $11,000 $6.00 $6.20 Baker 9 Carpenter 7 Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular? Using V and a shipping quantity of V units is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your response as an integer.)
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…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Meanwhile, Weekend Projects is a national chain of retail outlets and 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) Annual Lead Annual Supplier 20,000 40,000 Price/unit(p) Administrative Holding Cost/Unit(H) (L)(wks) $1.5 $1.8 Time Cost Bradley $30,000 $20,000 Alexander $25,000 $22,000 $6 $5 $20,000 $30,000 4 What is the total annual cost for Weekend Projects if the company chooses Alexander as the supplier and determines the shipping quantity at 40,000 units per shipment? $608,600 O $609,600 $606,600 O $607,600
Eagle Electric Repair is a repair facility for several major electric appliance manufacturers. Eagle wants to find a low-cost supplier for an electric relay switch used in many appliances. The annual requirements for the relay switch (D) are 100,000 units. Eagle operates 250 days a year. The following data are available for two suppliers, Kramer and Sunrise, for the part: Supplier Freight CostsShipping Quantity (Q ) Price/Unit (p) Carrying Cost/Unit (H ) Lead Time (L) (days) Administrative Costs 2,000 10,000 Kramer $30,000 $20,000 $5.00 $1.00 5 $10,000 Sunrise $28,000 $18,000 $4.90 $0.98 9 $11,000 Which supplier will provide the lowest annual total costs?
Chris Sandvig Irrigation, Inc., has summarizedthe price list from four potential suppliers of an undergroundcontrol valve. See the accompanying table. Annual usage is2,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 quantityis best if Sandvig Irrigation wants to minimize total cost?
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.15 per unit. D Vendor A units at a time from Vendor C Vendor B Quantity 1-14 15-24 25-99 100-199 200-399 400+ 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 A Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor D Vendor B Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 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
Adelie Enterprises has decided to dropthe international supplier from consideration. Furthermore,Adelie has decided to order boxes in lots of 10,000 to op-timize the use of available storage space at its distributionfacility. To more completely consider the cost/volume trad-eoffs associated with selecting the local or national supplier,management has collected the following data. Adelie servicesits customers 250 days per year. a. On purely a total cost basis, which supplier should beselected if there is low demand for Adelie’s new service;which supplier should be selected under moderatedemand assumptions; and which supplier should beselected under high demand?b. Which supplier achieves the lowest expected cost ifthe probability of low demand is 35 percent, moderatedemand is 45 percent, and high demand is 20 percent?
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
Eight Flags operates several amusement parks in the Midwest. The company stocks machine oil to service the machinery for the many rides at the parks. Eight Flags needs 30,000 gallons (D) of oil annually; the parks operate 50 weeks a year. Management is unsatisfied with the current supplier of oil and has obtained two bids from other suppliers. The data are contained in the following table. D i Annual Freight Costs Shipping Quantity (Q) (wks) Cost Supplier Sharps Winkler 5,000 $5,200 $5,400 Price/Unit Annual Holding Lead Time (L) Annual Administrative 10,000 15,000 (P) Cost/Unit (H) $3,600 $3,200 $3.70 $3.700 $3,400 $0.74 5 $4,000 $5,000 $3.90 $0.78 6 Which supplier and which shipping quantity will provide the lowest costs for Eight Flags? Using and a shipping quantity of is the lowest cost alternative, with annual total costs to Eight Flags of $. (Enter your response as an integer.)
1.Upstream supply chain members are A. retailers B. manufacturers C. end-use customers D. suppliers 2.The integrated group of business processes that form a supply chain are A. marketing, manufacturing and finance B. procurement, production and distribution C. manufacturing and service D. demand, value, and quality 3.The bullwhip effect occurs when A. slight to moderate demand variability becomes magnified as demand information is transmitted back upstream. B. slight to moderate demand variability becomes magnified as supply information is transmitted back upstream. C. slight to moderate demand variability becomes magnified as demand information is transmitted back downstream. D. slight to moderate demand variability becomes magnified as supply information is transmitted back downstream. 4.The key element in achieving supply chain integration is A. quality management B. ISO certification C. information technology D. EDI 5.A disadvantage of RFID technology that has hindered its…
Alison's Accessories is a high volume worldwide fashion house with outlets in 65 countries. Sadly, space does not permit an exhaustive list but once the test is over, check out their website. Kalil, the supply chain manager is conducting her usual thorough analysis of her final four candidates for supplier and has developed the following tables of pertinent costs and other shipping metrics. Regardless of supplier, Alison's Accessories will operate 220 days per year and has forecast annual demand of 250,000 units. Kalil has obtained quotes for three different shipment sizes (Freight Costs table). All costs are in US Dollars. Table 1 Unit costs Supplier Price/Unit Carrying Cost A 123 22 B 125 19 C 126 18 D 100 40 Annual Freight Costs Supplier 15,000 units 25,000 units 50,000 units A 380,000 260,000 237,000 B 615,000 547,000 470,000 C 285,000 240,000 200,000 D 380,000 260,000 237,000 Other Costs Supplier Lead Time Annual Admin Costs A 30 250,000 B 15 275,000 C 7 225,000 D 90…