A new platoon is being deployed for a year to a base in Afghanistan. Military vehicles are being shipped over to aid them with their missions. The ship transporting the vehicles has 5000 square feet of space available and a weight restriction of 200 tons.

There is a budget of dollar 100 million for acquiring and shipping the vehicles.

Using the table provided below, formulate an LP to help the platoon leader decide how many of each vehicle they should have shipped to them in order to maximize the total firepower capability of the fleet.

Solve it using either Excel solver or Lingo. Include model output, and interpretation of the decision variables from the solution)