A company has three factories in Chicago, Kansas City, andHouston where it produces its products and from where it can weeklysupply its three distribution centers located in New York, LosAngeles, and Atlanta. The supply capacities at the three factories,the demand requirements at each of the three distribution centers,and the transportation costs in $ per ton from each factory to eachdistribution center are shown in the table below. Formulate alinear programming (LP) model of this transportation problem withthe objective of minimizing total shipping cost. I am asking forthe LP model formulation only in question

1. Factories Distribution Centers Total Supply New York LosAngeles Atlanta Chicago $8 $5 $6 120 tons Kansas City $15 $10 $1280 tons Houston $3 $9 $10 80 tons Total Demand 150 tons 70 tons 60tons

2. Solve the LP model you formulated in question 1, using ExcelSolver. Information and steps for Excel Solver are provided in onethe attached document on Blackboard in this module. You are tosubmit your answer for question 2 of this Assignment, as in thesolution summary shown in the attached document on Blackboardcontaining information and steps for Excel Solver, as well assubmit the Excel file containing both the Answer Report and Sheet1spreadsheet.