Please formulate this problem in general by hand form and also a model for AMPL for data and model

TABLE 9.10 Water resources data for Metro Water District Cost (Tens of Dollars) per Acre Foot Los Devils Colombo River Sacron River Calorie River Minimum needed Requested Berdoo 16 14 19 30 50 338 88 13 13 20 70 70 San Go 22 19 23 0 30 Hollyglass 17 15 10 8 Supply 50 60 50 (in units of 1 million acre feet)

TABLE 9.10 Water resources data for Metro Water District \begin{tabular}{l|c|c|c|c|c} \hline & \multicolumn{3}{c|}{ Cost (Tens of Dollars) per Acre Foot } & \multirow{2}{*}{ Supply } \\ \cline { 2 - 5 } & Berdoo & Los Devils & San Go & Hollyglass & \multirow{2}{*}{ S } \\ \hline Colombo River & 16 & 13 & 22 & 17 & 60 \\ Sacron River & 14 & 13 & 19 & 15 & 50 \\ Calorie River & 19 & 20 & 23 & - & (in units of 1 \\ \hline Minimum needed & 30 & 70 & 0 & 10 & million acre feet) \\ Requested & 50 & 70 & 30 & & \end{tabular}