Developing a Spreadsheet Model
​

​Here, we developed a spreadsheet model for our example transportation problem to obtain a complete solution and then identified whether it is feasible or not. A feasible solution is one that satisfies all the constraints. Next, we added the objective function to the model in order to obtain the minimum cost of shipment.
Manually changing shipment values is not practical since there are just too many possible shipment combinations. Thus, we add optimization to the spreadsheet model.