| Beaufort Brand | Spring Classification Analysis TY vs LY | | | | | | | | | | | 10/7/19 |
| | Stock to Sales Analysis |
| | Spring TY (This Year) Week 13 | | | | | Spring LY (Last Year) Week 13 |
| Class | TY Sales | | TY Receipts (sales+OH) | | TY ST% | LY Sales | | LY Receipts (sales +OH) | | LY ST% | TY vs LY |
| | Sales Pen | | Rcpt Pen | | | Sales Pen | | Rcpt Pen | | | +/- Sales | +/- Receipts |
| Jackets | 22% | $508,000 | 24% | $2,726,200 | 19% | 35% | $873,100 | 31% | $3,719,300 | 23% | -42% | -27% |
| Pants | 15% | $336,600 | 13% | $1,476,700 | 23% | 9% | $217,700 | 10% | $1,264,700 | 17% | 55% | 17% |
| Dresses | 15% | $335,500 | 12% | $1,386,000 | 24% | 20% | $492,500 | 20% | $2,442,400 | 20% | -32% | -43% |
| Blouses | 11% | $263,100 | 9% | $1,054,000 | 25% | 6% | $152,900 | 8% | $923,400 | 17% | 72% | 14% |
| Sweaters | 10% | $232,000 | 11% | $1,197,400 | 19% | 4% | $98,900 | 5% | $638,000 | 16% | 135% | 88% |
| Jersey Tees | 7% | $163,300 | 4% | $501,100 | 33% | 7% | $182,400 | 5% | $633,700 | 29% | -10% | -21% |
| Leather/Suede | 6% | $138,000 | 9% | $1,044,700 | 13% | 9% | $227,200 | 10% | $1,235,400 | 18% | -39% | -15% |
| Coats | 4% | $100,900 | 5% | $511,500 | 20% | 6% | $138,300 | 6% | $700,200 | 20% | -27% | -27% |
| Special Occasion | 4% | $89,000 | 7% | $762,100 | 12% | 0% | $0 | 0% | $0 |
| Skirts | 2% | $40,600 | 4% | $414,000 | 10% | 3% | $75,900 | 3% | $349,200 | 22% | -47% | 19% |
| Evening Gowns | 4% | $87,600 | 1% | $143,700 | 61% | 1% | $26,100 | 2% | $182,000 | 14% | 236% | -21% |
| Accessories | 1% | $18,400 | 1% | $148,800 | 12% | 0% | $0.00 | 0% | $0.00 |
| Total | 100% | $2,313,000 | 100% | $11,366,200 | 20% | 100% | $2,485,000 | 100% | $12,088,300 | 21% | -7% | -6% |
| $ Shortfall/Surplus to LY | | -$172,000 | | -$722,100 |
| Formulas | Sales pen %= classification sales/total sales | | Receipt pen %= classification receipts/total receipts | | sell through = sales $/ receipts $ | | | | | sell through = sales $/ receipts $ | =(TY sales-LY sales)/LY sales |
| | | | | | | | | | | | | =(TY recpt-LY recpt)/LY recpt |
| 13 weeks of selling at 2.5% weekly goal sell through= | | | 32.5 | sell through goal for 13 weeks |
| | 1 | What is your total sell through? How does it compare to LY? How does it compare to your sell through goal? |
| | 2 | Are your sales up or down to LY? By what %?How does this % compare to your receipts? |
| | 3 | If your goal is 2.5% a week after 13 weeks of selling what is your target sell through percentage? Are you close? |
| | 4 | What is your classification with thehighest sell through? What is your lowest? Is this consistent with LY? |
| | 5 | Where do you see opportunities?Where do you see liabilities? |
| | 6 | Formulate a plan of action. |
| | 7 | It's mid season so it's the perfect time to RTV slow sellers and reorder best selling classifications. Which classifications will you suggest to RTV? Which classifications do you want to reorder? |
| | 8 | Think of how these learnings might influence your other brands? |
ixawda.e
ClassificationAnalysis10.6.19-2.xlsx
