PLEASE SOLVE USING EXCEL

Based on the following information, calculate the Minimum Cost for the following linear programming problem.

There is a Distribution Center capable to distribute two products to two assembly lines for warehouse retails business. The assembly line located in NC requires a minimum of $3000$ hours of production while the one located in FL requires some minimum of $2000$ hours. The assembly for product A requires $20$ minutes in $NC$ or $30$ minutes in $FL.$ The assembly of the product $B$ requires $30$ minutes in $NC$ and $25$ minutes in FL$.$ The assembly cost in NC is $$5\mathrm{.}00$ for A and $$4\mathrm{.}00$ for $B.$ Products A and $B$ cannot be negative.

Based on the following information, calculate the Maximum Profit for the following linear programming problem.

If the manufacturing costs of new airplanes are $$1\mathrm{.}5M$ for model $DFL$ and $$4\mathrm{.}5$M for model ELD, which production combination will maximize the profits if the selling price is $$3M$ and $$7M$ respectively? The LA or the NY warehouses can use no more than $2000$ hours each. The model DFL requires $30$ hours in LA or $50$ hours in NY for it production. The model ELD requires $45$ hours in LA or $20$ hours in NY$.$ The number of airplanes DFL or ELD cannot be negative.