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).