Please use solver and excel and get final answer!!

Smoothie Shack is a smoothie shop that specializes in 4 different types of smoothies, all named after colors (the Blue, Green, Red, and Yellow.) Each smoothie's ingredients are listed in the following table, along with the amount of each ingredient that Smoothie Shack has available for the day. Also, in the table, the selling price for each of the smoothies is listed. Management is aware of historical demands, so they want to ensure that there are at least 20 green smoothies made. They also know that the Red smoothie is a pretty good substitute for the Blue, and vice versa. Therefore, if they run out of Red, most customers will opt for the Blue, or if they run out of the Blue, most customers will opt for the Red. Management has taken this information and has decided that between the Red and Blue, there must be at least 100 smoothies. Also, Smoothie Shack sells out on a typical day, so they are not concerned about waste. With the goal of maximizing revenue, how many of each smoothie should be made? Formulate a linear programming model in a spreadsheet, and upload your excel file that clearly answers the previous