Create a relationship between the Orders table Order ID field and the OrderDetails table Order ID field.

Use Power Pivot to create a calculated column in the e$10$m$1$Inventory table of the data model. Name the calculated column Total Value of Inventory and multiply the quantity on hand by the unit price in the column.

Create a PivotTable on a new worksheet with Supplier Number from the Suppliers table as a Filter, the Product Description field from the e$10$m$1$Inventory table as the Rows. Use Unit Price, Quantity on Hand, and Total Value of Inventory as the Values.