Question
Tigo Automobiles has two manufacturing facilities, two warehouses, and three customer hubs. The manufacturing facilities are in Morales and Monterrico, the warehouses are in Salama
Tigo Automobiles has two manufacturing facilities, two warehouses, and three customer hubs. The manufacturing facilities are in Morales and Monterrico, the warehouses are in Salama and Zacapa, and the customer hubs are in Guatemala City, Quetzaltenango, and Huehuetenango. Cars are produced at plants, then shipped to warehouses, and finally shipped to customer hubs. Morales can produce 150 cars per week, and Monterrico can produce 100 cars per week. Guatemala City requires 80 cars per week, Quetzaltenango requires 70, and Huehuetenango requires 60. It costs $10,000 to produce a car at each plant. This problem has been solved using SOLVER in excel and the following table provides the sensitivity report of the solution. Use the Table 1 to answer the questions that follow: