In cell D$5,$ apply the SUBTOTAL with the COUNTA function to count the number of records in the Part ID field of the Inventory$\_$Tbl table.

In cell D$6,$ apply the SUBTOTAL function with the SUM function to the Stock Qty field to calculate the quantity of items in the warehouse.

In cell D$7,$ apply the SUBTOAL function with the SUM function to the Inventory Value field to calculate the total value of items in the warehouse.

In cell D$8,$ apply the SUBTOTAL function with the SUM function to the Restock Indicator field to calculate the number of items requiring restocking.

In cell D$9,$ calculate the difference between cells D$5$ and D$8,$ returning the total number of items that do not require restocking.

In cell D$10,$ apply the SUBTOTAL function with the SUM function to the Restock Cost field to calculate the total cost of restocking items that have low inventory.

Insert a pie chart of the data in the range C$8$:D$9$ and resize it to cover the range C$11$:D$18.$ Remove the chart title and add data labels to the pie slices showing the percentage of items that need restocking.

Use the slicers to show results for items only in warehouse row $1$ and bin $9.$

Save the workbook, and then close it$.$