3.The Axis car rental company allows its customers to pick up a rental car at one location andreturn it to any of its locations. Currently, two locations (1 and 2) have 16 and 18 surplus cars,respectively, and four locations (3, 4, 5, and 6) each need 10 cars. The costs of getting the surpluscars from locations 1 and 2 to the other locations are summarized in the following table. Costs of Transporting Cars Between Locations

Location 3Location 4Location 5Location 6Location 1$54$17$23$30Location 2$24$18$19$31Because 34 surplus cars are available at locations 1 and 2, and 40 cars are needed at locations 3, 4, 5,and 6, some locations will not receive as many cars as they need. However, management wants tomake sure that all the surplus cars are sent where they are needed, and that each location needing carsreceives at least five. Develop a spreadsheet model for this problem and solve it using Solver. Optimal solution 730 $4.A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual returnBondAnnual ReturnMaturityRiskTax-FreeA9.50%LongHighYesB8.00%ShortLowYesC9.00%LongLowNoD9.00%LongHighYesE9.00%ShortHighNoThe officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments. The officer’s goalis to maximize annual return. a.Formulate an LP model for this problem (by hand).