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 their 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 pizzas are pepperoni. They 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?
Show work please (excel)