Please help me to do it with Excel Solver

3. Ford has four automobile plants. Each is capable of producing the Taurus, Lincoln, or Escort, but it can only produce one of these cars. The fixed cost of operating each plant for a year and the variable cost of producing a car of each type at each plant are given in the table below. Ford faces the following restrictions: a Each plant can produce only one type of car. b The total production of each type of car must be at a single plant; that is, for example, if any Tauruses are made at plant 1, then all Tauruses must be made there. cIf plants 3 and 4 are used, then plant 1 must also be used. Each year, Ford must produce 500,000 of each type of car. Formulate an IP whose solution will tell Ford how to minimize the annual cost of producing cars. Plant Taurus Escort 1 2 3 4 Fixed Cost (8) 7 billion 6 billion 4 billion 2 billion 12,000 15,000 17,000 19,000 Variable Cost ($) Lincoln 16,000 18,000 19,000 22,000 9,000 11,000 12,000 14,000