The supply capacities at each origin $($factory$)$ and demand at each destination $($warehouse$)$ are shown and the cost information is given as follows.Cost Information:WarehousePlease generate the conceptual model and excel model to decide the optimal transportation decisions