Table to Analyze

Total Collection Budget: $100,000$

Target Sell$-$thru Time: $12$ weeks

Status at end of Gth Week:

$\backslash$table$[[,$Unit Cost,Units Bought,Cost,Retall Price,Units Sold,GM$\%,$Sell$-$thru,Sales S$,$GMS$],[$Shirt A$,22\mathrm{.}00,500,11,000,44\mathrm{.}00,350,50\mathrm{.}0\%,70\mathrm{.}0\%,15,400,7,700],[$Shirt B$,20\mathrm{.}00,600,12,000,40\mathrm{.}00,225,50\mathrm{.}0\%,37\mathrm{.}5\%,9,000,4,500],[$Shirt C$,18\mathrm{.}00,600,10,800,36\mathrm{.}00,400,50\mathrm{.}0\%,66\mathrm{.}7\%,14,400,7,200],[$Pant D$,24\mathrm{.}00,500,12,000,48\mathrm{.}00,200,50\mathrm{.}0\%,40\mathrm{.}0\%,9,600,4,800],[$Pant E$,25\mathrm{.}00,500,12,500,50\mathrm{.}00,240,50\mathrm{.}0\%,48\mathrm{.}0\%,12,000,6,000],[$Pant F$,30\mathrm{.}00,300,9,000,60\mathrm{.}00,190,50\mathrm{.}0\%,63\mathrm{.}3\%,11,400,5,700],[$Accessory G$,14\mathrm{.}00,300,4,200,30\mathrm{.}00,160,53\mathrm{.}3\%,53\mathrm{.}3\%,4,800,2,560],[$Accessory H$,8\mathrm{.}00,500,4,000,20\mathrm{.}00,420,60\mathrm{.}0\%,84\mathrm{.}0\%,8,400,5,040],[$Total Collection,,$3,800,75,500,,2,185,,57\mathrm{.}5\%,85,000,43,500],[$Open$-$to$-$buy,,,$24,500,,,,,,]]$

Questions $-$ Provide and answer AND detailed explanation for each answer

Which items are performing better than the buyer expected?

Which items are performing worse than the buyer expected?

Which item has the best GMROI$\%($GMROI$\%=$ GM$ $/$ Avg. Inventory at Cost$)?$

Which of the three shirts has the best GMROI$\%?$

Which of the three pants has the best GMROI$\%?$

Do you recommend the buyer invest the remainder of her open$-$to$-$buy in this collection or divert the money to another use?

If the answer to #$6$ was "yes," how do you recommend the buyer invest the remaining open$-$to$-$buy by item?

Do you recommend the buyer make any price changes at this time?