Use the data given below to answer the following question(s). Below is the spreadsheet for demand prediction of a company that sells chocolates. A B C 1 Demand Prediction Models 23 Linear Model 4 A 10,000 5 B 10 67 Price Demand 8 $50 9,500 9 $55 9,450 10 $45 9,550 11If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be represented in C9 using absolute addressing?

$527.7.if the following was the question  $527.7 is the answer.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?

Alot of credit card rewards

Ithink that’s the oneplus7pro