Can someone solve this using the LP method linear programming method please?

They solved it here but not with the LP method linear programming method https://www.chegg.com/homework-help/marc-smith-vice-president-operations-hhn-inc-manufacturer-ca-chapter-10-problem-27p-solution-9780136036081-exc

Data for Problem 9-19 PLANT LOCATION MARKET AREA WATERLOO PUSAN BOGOTA FONTAINEBLEAU DUBLIN $30 Canada Demand 4,000 Production cost Transportation cost South America Demand 5,000 Production cost Transportation cost Pacific Rim Demand 10,000 Production cost Transportation cost Europe Demand 5,000 Production cost Transportation cost Capacity 50 30 25 8,000 2,000 5,000 9,000 9,000 Which of the new possible plants should be opened? E 9-19 Marc Smith, vice president for operations of HHN, Inc., a manufacturer of cabinets for telephone switches, is constrained from meeting the 5-year forecast by limited capacity at the existing three plants. These three plants are Waterloo, Pusan, and Bogota. You, as his able assistant, have been told that because of existing capacity constraints and the expanding world market for HHN cabinets, a new plant is to be added to the existing three plants. The real estate department has advised Marc that two sites seem particularly good because of a stable po- litical situation and tolerable exchange rate: Dublin, Ireland, and Fontainebleau, France. Marc suggests that you should be able to take the data on the next page and determine where the fourth plant should be located on the basis of production costs and trans- portation costs. Which location is better? Data for Problem 9-19 PLANT LOCATION MARKET AREA WATERLOO PUSAN BOGOTA FONTAINEBLEAU DUBLIN $30 Canada Demand 4,000 Production cost Transportation cost South America Demand 5,000 Production cost Transportation cost Pacific Rim Demand 10,000 Production cost Transportation cost Europe Demand 5,000 Production cost Transportation cost Capacity 50 30 25 8,000 2,000 5,000 9,000 9,000 Which of the new possible plants should be opened? E 9-19 Marc Smith, vice president for operations of HHN, Inc., a manufacturer of cabinets for telephone switches, is constrained from meeting the 5-year forecast by limited capacity at the existing three plants. These three plants are Waterloo, Pusan, and Bogota. You, as his able assistant, have been told that because of existing capacity constraints and the expanding world market for HHN cabinets, a new plant is to be added to the existing three plants. The real estate department has advised Marc that two sites seem particularly good because of a stable po- litical situation and tolerable exchange rate: Dublin, Ireland, and Fontainebleau, France. Marc suggests that you should be able to take the data on the next page and determine where the fourth plant should be located on the basis of production costs and trans- portation costs. Which location is better