Assume that you are the sales manager of a collection cars gallery. You want to make an analysis to maximize your profit. You note down the cost of the cars that you can buy and the prices that you can sell them in 2nd and 3rd row of an Excel sheet in the given format below. There will be 10 available cars. Your total budget is given in A5. You can buy the cars within the given budget. Each car is unique, so you can't buy more than one from the same car. The total capacity of your gallery can hold at most 6 cars, so you can't buy more than 6 cars. Using Excel Solver, show the items that should be chosen by writing BUY under the corresponding car in row 4 and also calculate the total profit in Cell B5. A sample template is shown below. Assume that you are the sales manager of a collection cars gallery. You want to make an analysis to maximize your profit. You note down the cost of the cars that you can buy and the prices that you can sell them in 2nd and 3rd row of an Excel sheet in the given format below. There will be 10 available cars. Your total budget is given in A5. You can buy the cars within the given budget. Each car is unique, so you can't buy more than one from the same car. The total capacity of your gallery can hold at most 6 cars, so you can't buy more than 6 cars. Using Excel Solver, show the items that should be chosen by writing BUY under the corresponding car in row 4 and also calculate the total profit in Cell B5. A sample template is shown below