Inventory Coverage Calculation

Please post create table or declare table variable with insert(s) of sample data and what the desired query output should be. Thanks.