Using Microsoft data solver, please provide a detailed breakdown of this problem including pictures and work shown. Allied Freight supplies goods to three customers, who each require $30$ units. The company has two warehouses. In warehouse $1,40$ units are available, and in warehouse $2,30$ units are available. The costs of shipping one unit from each warehouse to each customer are shown below. There is a penalty for each unsatisfied customer unit of demand $-$ with customer $1,$ a penalty cost of $$90$ is incurred; with customer $2,$$$80$; and with customer $3,$$$110.$

$\backslash$table$[[,,$To$,,],[,,$Customer $1,$Customer $2,$Customer $3],[$From$,$Warehouse $1,$$$15,$$$35,$$$25],[,$Warehouse $2,$IS$10,$$$30,$$$40],[,$Penalty cost,$$90,580,$$$110$