Bubble.io Building a backend formula that assigns values to questionnaire answers

My business needs assistance with our Bubble.io application. The back end should be able to receive answers from an online questionnaire and assign point values to each answer for use in a formula. Once all questions within the questionnaire have been answered, the totals will need to automatically compile in a formula that I designed with the results being populated into a manager's dashboard. For example, (see the attached file) if the dropdown answer under the Probability section selected is Highly Likely = 20 points, Likely = 10 points, and so on. Once all questions in each of the 5 categories have been answered, the score totals will be used in a formula I have created and will likely need help with creating that stage as well. This formula will consist of addition, multiplication, and division, and follow the proper order of operations. This resulting score will need to be displayed on a manager's dashboard that is yet to be created, however, the questionnaire and all the dropdown answers and scoring have been created.