Calculation between 2 tables

Hello,

I have 2 tables, with a relation on the Attribute column.

The 1st "Capacity" table is composed as follows:

My second "Resources" table:

On my "Capacity" table, it is the volume that an attribute can process per day depending on the Program.
On my "Resources" table, it is the assignment per day of an attribute on a program.

I must therefore highlight the overall volume that will be processed according to the programs and assignments of the attributes.
example:
For 09/07, for the "Sale" program, I must obtain a value equivalent to 15 (Joëlle's Selling Capacity) + 5 (Nicolas Selling Capacity) = 20

How can I proceed?
Thank you in advance for your help.