Question: What would you recommend doing with the items with less than 7 days worth of inventory? What would you recommend doing with the items with

What would you recommend doing with the items with less than 7 days worth of inventory?
What would you recommend doing with the items with more than 42 days worth of inventory?
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & G & H & 1 & J & K & L & M & N & 0 \\ \hline & Psku & Description & On Hand & Sold Qty & Days & Inv Turnover Ratio & & & & & & & & \\ \hline & 983401 & ENOZ MOTH CAKE & 168 & 119 & 30 & 12 & & & & & & & & \\ \hline & 1124001 & DG REUSABLE BAG & 355 & 278 & 27 & 14 & \multicolumn{6}{|c|}{ How many items have less than 7 days on hand? } & & 33 \\ \hline & 1125101 & GLADWARE FAMILY SIZE & 308 & 462 & 14 & 26 & \multicolumn{6}{|c|}{ How many items have more than 42 days worth of inventory? } & & 89 \\ \hline & 1125505 & COLANDER 4QT/7QT & 113 & 319 & 7 & 49 & \multicolumn{7}{|c|}{ How many items have between 7 and 42 days worth of inventory on hand? } & 326 \\ \hline & 1125701 & TAKEALONG 2PK LG RECT & 252 & 794 & 7 & 55 & & & & & & & & \\ \hline & 1125910 & BOWLS 490Z BLUE 2PK & 948 & 622 & 32 & 11 & & & & & & & & \\ \hline & 1126201 & POPCORN/SALAD BOWL & 462 & 539 & 18 & 20 & & & & & & & & \\ \hline & 1126301 & SALAD/CEREAL BOWL & 790 & 814 & 20 & 18 & & & & & & & & \\ \hline & 1126501 & TAKEALONG SQUARE & 2225 & 1076 & 43 & 8 & & & & & & & & \\ \hline & 1126701 & RECT PITCHER 1GAL & 500 & 816 & 13 & 28 & & & & & & & & \\ \hline 2 & 1126801 & CUTLERY TRAY & 266 & 282 & 20 & 18 & & & & & & & & \\ \hline & 1127001 & TAKE ALONG RECTANGLE & 505 & 752 & 14 & 26 & & & & & & & & \\ \hline & 1127301 & TAKEALONGS ENTREE & 1705 & 681 & 53 & 7 & & & & & & & & \\ \hline 5 & 1127402 & 8PC BOWL SET & 979 & 489 & 42 & 9 & & & & & & & & \\ \hline 6 & 1127603 & TAL SM BOWL 3.2 CUP & 237 & 739 & 7 & 54 & & & & & & & & \\ \hline 7 & 1127801 & ULTRA SEAL 4.7 QT & 931 & 442 & 44 & 8 & & & & & & & & \\ \hline 8 & 1127901 & LARGE ENTREE 3PK & 1877 & 634 & 62 & 6 & & & & & & & & \\ \hline 9 & 1128001 & TAKEALONG ROUND 3PK & 915 & 883 & 22 & 17 & & & & & & & & \\ \hline 0 & 1128201 & 24 OZ WATER BOTTLE & 219 & 219 & 21 & 17 & & & & & & & & \\ \hline 1 & 1130902 & SMALL GLASS CANISTER & 406 & 259 & 33 & 11 & & & & & & & & \\ \hline & 1131501 & TL MUFFIN PAN 12 CUP & 458 & 292 & 33 & 11 & & & & & & & & \\ \hline 3 & 1131701 & JFYFOL OVAL ROASTER GIAI & 1055 & 730 & 30 & 12 & & & & & & & & \\ \hline & 1131801 & JFYFOL ROASTER W/LD SM & 193 & 1913 & 2 & 172 & & & & & & & & \\ \hline 5 & 1132101 & JFYFOL CAKE/STUFFING 2PH & 383 & 2418 & 3 & 110 & & & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
