Calculate the popularity index for the following sales in Excel. Round each result to two decimals.

Item

Portions sold

A $60$

B $35$

C $80$

D $40$

Item

Portions sold

a $43$

b $60$

c $70$

d $125$

Item

Portions sold

A $91$

B $120$

C $65$

D $50$

E $45$

$2.$ Using the popularity indexes calculated in Question $1$a$,$ predict the sales for each item if total sales for all items are expected to be $400.$

$3.$ Using the popularity indexes calculated in Question $1$b$,$ predict the sales for each item if total sales for all items are expected to be $150.$

$4.$ Using the popularity indexes calculated in Question $1$c$,$ predict the sales for each item if total sales for all items are expected$$to$$be$450.$