a) Formulate the problem as a linear programming by clearly defining decision variables, objective function, and constraints. Objective function, and constraints need to show the mathematical relationships.

b) Develop an excel model to solve the problem

The distribution system for the Herman Company consists of two plants, two warehouses, and two customers. Plant capacities (units) and shipping costs per unit (in \$) from each plant to each warehouse are shown in Table 1. Customer demand and shipping costs per unit (in \$) from each warehouse to each customer are listed in Table 2. Warehouse 2 informs customer 1 that it can only ship no more than 100 units. Table 1 Information (olants to warehouses) Table 2 Information (warehouses to customers) The distribution system for the Herman Company consists of two plants, two warehouses, and two customers. Plant capacities (units) and shipping costs per unit (in \$) from each plant to each warehouse are shown in Table 1. Customer demand and shipping costs per unit (in \$) from each warehouse to each customer are listed in Table 2. Warehouse 2 informs customer 1 that it can only ship no more than 100 units. Table 1 Information (olants to warehouses) Table 2 Information (warehouses to customers)