Students who are trying to raise funds have an agreement with a local pizza chain. The chain has agreed to sell them pizzas at a discount, which the students can then resell to families in the local community for a profit. It is expected that of the 500 families in the community, at most 70% will buy pizza. Based on a survey of personal preferences, the students believe that they should order no more than 120 cheese pizzas, no more than 150 pepperoni pizzas, and no more than 100 vegetarian pizzas. They also want to make sure that at least 20% of the total pizzas are cheese and at least 50% of the total pizzas are pepperoni. They expect to make a profit of $1.45, $1.75, and $1.98, respectively, for each cheese, pepperoni, and vegetarian pizza they resell. How many pizzas of each type should they buy?

Please show in Excel and Solver.