The following spreadsheet screen$-$print shows the optimal solution for a network optimization problem. Analyze the solution and answer questions $14$ and $15.$

Inputs $-$ Costs, Capacities, Demands

Demand Region

Production and Transportation Cost per $1,000,000$ Units Fixed Low Fixed High

Supply Region N$.$ America S$.$ America Europe Asia Africa Cost $($$$)$ Capacity Cost $($$$)$ Capacity

N$.$ America $81921011301156,000109,00020$

S$.$ America $11777108981004,500106,75020$

Europe $102105951191116,500109,75020$

Asia $1151259059744,100106,15020$

Africa $142100103105714,000106,00020$

Demand $12814167$

Decision Variables

Demand Region $-$ Production Allocation $(1000$ Units$)$ Plants Plants

Supply Region N$.$ America S$.$ America Europe Asia Africa $(1=$open$)(1=$open$)$

N$.$ America $0000000$

S$.$ America $12800001$

Europe $0000000$

Asia $00416001$

Africa $00100701$

Constraints

Supply Region Excess Capacity

N$.$ America $0$

S$.$ America $0$

Europe $0$

Asia $0$

Africa $3$

N$.$ America S$.$ America Europe Asia Africa

Unmet Demand $00000$

Objective Function

Cost $=$ $ $23,751$