A company has $4$ development projects that can be offered in bundles. The company has $4$ potential suppliers that can handle all four projects. Table $3$ shows the bundles and the offered prices by the suppliers.

Table $3$

Price

Suppliers$/$bundles $1234(1,2)(2,4)(1,3)(1,2,3)(1,2,3,4)$

$124756861216$

$226647971116$

$344567981216$

$4157661071216$

By using Excel Solver find the best assignment that minimizes total cost.