Please use the provided Excel template and then use Solver function.

Pine Tree Boba is a popular bubble tea house in the U District. Below are the three most popular drinks it sells, the amount of ingredients each requires, and the price of them: Drink 1 ($4.79) requires 2 units of bubble, 1 unit of milk, and 2 units of tea. Drink 2 ($5.49) requires 1 unit of bubble, 2 units of milk, and 2 units of tea. Drink 3 ($5.99) requires 2 units of bubble, 2 units of milk, and 2 units of tea. With a limited supply of 100 units of bubble, 200 units of milk, and 150 units of tea, how many cups of each drink should it make to maximize the revenue? Unit Bubble Unit Milk Unit Tea 1 1 2 Drink Type No. to Make Drink 1 Drink 2 Drink 3 TOTAL Unit Price Total Bubble Total Milk 100 200 100 200 100 200 Total Tea Total Price 150 4.79 150 5.49 150 5.99 1 2 NN 2 2 2 2 1 Postive=delay ngative= ahead O=on time 0