Help me please I don't understand this , thank you

9. A school has a vending machine that

sells water, orange juice, apple juice, and

grapefruit juice. Over the years, the school

has found that the ratio of water to orange

juice to apple juice to grapefruit juice sold

is 5:6:8:1.

a) If a total of 100 drinks are sold each

week, how many apple juices are sold?

b) Make a computer spreadsheet to help

the school order the correct number of

drinks. If a number is entered into any

drink column (as shown below), your

spreadsheet should automatically

update to show how many other drinks

to order, as well as the total number of

drinks to order.

c) Use a formula to calculate the percent

of each kind of drink sold.

Explanation:

answer; /// i believe the correct answer is $165.00 per resident in florida