ork 4 ch14 integration K Question 1, Problem 3 > HW Score: 66.67%, 0.67 of 1 point Points: 0.67 of 1 Save 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) Annual Price/Unit Holding Cost/Unit Supplier Abbott Baker Carpenter 10,000 20,000 (p) (H) Lead Time (L) (days) Annual Administrative Cost $9,000 $6,000 $28 $5.60 5 $11,000 $12,000 $9,000 $31 $6.20 3 $9,000 $11,000 $10,000 $30 $6.00 9 $12,000 Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular? Using Abbott and a shipping quantity of 10,000 units is the lowest cost alternative, with annual total costs to Horizon Cellular of $1,170,480. (Enter your response as an integer.)