Hospital Inventory Dashboard Figure 5: Top 5 Products by Quantity \begin{tabular}{lr} Product & \\ \hline VACUETTE NEEDLE HOLDER 1000/CS & 5,448 \\ SYRINGE LUER LOCK 3CC \#309657 & 4,351 \\ NEEDLE BLOOD COLLECTION SAFETY & 4,145 \\ SYRINGE LUER LOCK 10CC \#309604 & 4,053 \\ \hline TOURNIQUET 1"X18" ORANGE \#CH50 & 3,738 \\ \hline \end{tabular} Figure 7: Top 5 Categories by Quantity \begin{tabular}{lr|} Category & \\ \hline SYRINGE & \\ VACUETTE & 27,011 \\ SOLUTION & 23,992 \\ DRESSING & 17,321 \\ CATHETER & 9,587 \\ & 9,049 \end{tabular} Figure 6: Top 5 Products by Value $ Product MATTRESS AIR TRANSFER HOVERMAT CARTRIDGE HYDROGEN PEROXIDE SO CATHETER FEMORAL (COOLGARD) TR DRESSING SOFT SILICONE MEPILEX TUBE FEEDING ENTERAL CORTRAK 2 Figure 8: Top 5 Re-order Products by Quantity Product ACCU-CHEK AVIVA CONNECT GLUCOS BAND WRIST ID ADULT \#841-11-VH BANDAGE TUBE DERMAFIT SIZE L ( BANDAGE TUBE SPANDAGE SIZE 3 \# BANDAGE TUBE SPANDAGE SIZE 5 \# 16,623 11,923 10,513 10,409 9,514 1 1 1 1 1 Which aisle has the highest physical inventory value? Aisle 4 Aisle 5 Aisle 1 Aisle 6 What aisle has the lowest unit price on average? Aisle 4 Aisle 5 Aisle 2 Aisle 1 Which of the following statements are true? CARTRIDGE HYDROGEN PEROXIDE SO represents the highest value in inventory. Overall, the pre-inventory count is higher than the physical inventory count. The category DRESSING represents the highest physical inventory count. Aisle 4 had a pre-inventory count that is higher than the physical inventory count. What can be concluded from the dashboard? The perpetual inventory system does not require periodic inventory counts. The unit price for products in Aisle 4 is higher than the unit price of products in Aisle 5 . Aisle 9 should have space to add more inventory. The dashboard shows healthy inventory levels of products