ork 4 ch14 integration Question 1, Problem 3 HW Score: 66.67%, 0.67 of 1 point Save Points: 0.67 of 1 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 K 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 Lead Price/Unit Holding Cost/Unit Time (L) Annual Supplier 10,000 20,000 (p) (H) (days) Administrative Cost Abbott $9,000 $6,000 $28 $5.60 $9,000 Baker $11,000 $9,000 $31 $6.20 $11,000 Carpenter $12,000 $10,000 $30 $6.00 . $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.)