Combined Ranking Of Two Columns Weighted

There are two sheets here with the same problem to tackle.

Sheet one
Cube vs Sales, need to rank these into one column weighted (maybe 70/600 sales to 30/40 Cube) to show that higher cube items that aren't selling fast enough need to be removed. So the ranking should show that the highest rank items (top 1-20) are the items that need to be removed due to the fact they are high cube and low sales.

Sheet Two
Ratings vs Sales, need to rank these into one column weighted to see the lower rated items that are below 4 stars (4.0) and high sales need to be addressed. The Highest-ranking items should be those that sale the most and have very low star ratings, weight at maybe (60 rate/40 sales). Indicating demand but poor quality

The previous solve is still weighting cube too high, along with there was no solve for ranking low star with high sales. Thank you