solve in excel plz

\begin{tabular}{|l|l|l|l|l|} \hline & \multicolumn{1}{|c|}{ per unit } & \multicolumn{1}{c|}{ per unit } & \multicolumn{1}{c|}{ per unit } & \\ \hline & Warehouse 1 & Warehouse 2 & Warehouse 3 & Total Supply (units) \\ \hline Long Beach & $5.00 & $6.00 & $4.00 & 300 \\ \hline Vancouver, BC & $6.00 & $3.00 & $7.00 & 500 \\ \hline Total Demand (units) & 200 & 300 & 250 & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline Shipping Plan & Warehouse 1 & Warehouse 2 & Warehouse 3 & Total Supply (units) \\ \hline Long Beach \\ \hline Vancouver, BC Total Demand (units) & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Costs & Warehouse 1 & Warehouse 2 & Warehouse 3 \\ \hline Long Beach & & & \\ \hline \end{tabular} Vancouver, BC Total Costs - Total Supply of the Shipping Plan cannot be more than the Total Supply available from the Factories - Total Demand of the Shipping Plan must be equal to the Total Demand of the Warehouses provided in the top table - Be sure to complete the table with all necessary formulas - Use Simplex LP as the solving method Completed file is due Monday, 11/28 by 11:59pm