Hey everyone! I can not figure this out right now to save my life...so I need help
I need an equation that does the following....
"Take Rate" Tab
cells BM7:BV17 represent how many of the part called out in cell B7 is in each of the full products shown in cells BM6:BV6
"Volume Summary" Tab
cells C60:Q70 represents the total volume of each full product by each year shown in cells C59:Q59
"Allocations" Tab
I need to be able to calculate how many parts are per year since some parts will be on multiple full products
This equation I am after will go on this tab
Example...
Part 123 is on full product A, B and C. I need to know for each year, how many part 123 there are
"Take Rate" tab
cell B7 = part 123
cell BM7 = 1
cell BN7 = 2
cell BO7 = 3
"Volume Summary" Tab
Cell C60 = 10 C61 = 20 C62 =30
"Allocations" Tab
equation needed --> (1*10)+(2*20)+(3*30) = 140
This tells me that 140 part 123's are needed in year one. I will need to do this for every year and for every component
I need an equation that does the following....
"Take Rate" Tab
cells BM7:BV17 represent how many of the part called out in cell B7 is in each of the full products shown in cells BM6:BV6
"Volume Summary" Tab
cells C60:Q70 represents the total volume of each full product by each year shown in cells C59:Q59
"Allocations" Tab
I need to be able to calculate how many parts are per year since some parts will be on multiple full products
This equation I am after will go on this tab
Example...
Part 123 is on full product A, B and C. I need to know for each year, how many part 123 there are
"Take Rate" tab
cell B7 = part 123
cell BM7 = 1
cell BN7 = 2
cell BO7 = 3
"Volume Summary" Tab
Cell C60 = 10 C61 = 20 C62 =30
"Allocations" Tab
equation needed --> (1*10)+(2*20)+(3*30) = 140
This tells me that 140 part 123's are needed in year one. I will need to do this for every year and for every component