can you explain how to do this

Using Excel Solver to solve a LP problem Use Microsoft Solver to do the Mixing Gin Drinks For Maximum Profit example in the Linear Programming PowerPoint file. The goal is to duplicate the answer shown using Linear Programming but using Solver. The problem statement is as follows: A bartender is limited in his knowledge of mixing drinks. He only knows how to make Tom Collins (TC) and Gin and Tonics (GT). TC and GT take different amounts of gin, sugar, and tonic. He makes a profit of $2.00 on a TC and $4.00 on a GT. The drinks are made according to the proportions below with the available ounces of ingredients listed. The goal is to Maximize Profit. Submit your answer when done. TC GT Available Gin 2 ounces 4 ounces1800 ounces Sugar 2 teaspoons 1 teaspoon 600 teaspoons Tonic 1 bottle 1 bottle 400 bottles Profit $2.00 $4.00 Maximize Profit subject to the constraints below. 2 TC + 4 GT S 2 TC + 1 GT S 1 TC + 1 GT S 1800 Ounces of Gin 600 Teaspoons of Sugar 400 Bottles of Mix