Attribute Analysis HW Assignment In this assignment you are going to be conducting an attribute analysis on our store's dress category based on the below results in the selling report. First, calculate the sales % and inventory % for the attribute 1 PRINT. Once you complete the percentages then you can compare sales to inventory. Note the performance of each as overperforming, underperforming, or performing in line - sales compared to inventory. Lastly you'll note what changes you'd make to your assortment next season based on the results from your analysis. Then complete the sames steps for Attribute 2 LENGTH. DATA DUMP FROM YOUR REPORTING SYSTEM *BUYER DECIDES ON ATTRIBUTES* STYLE DESCRIPTION COLOR MSRP SALES $ SALES UNITS ATTRIBUTES TOTAL RESULTS FLORAL MAXI DRESS STRIPE MINI DRESS STRIPE MAXI DRESS SOLID MINI DRESS STRIPE MIDI DRESS FLORAL MINI DRESS SOLID MAXI DRESS SOLID MINI DRESS FLORAL MIDI DRESS STRIPE MIDI DRESS 4,706 480 325 601 555 493 $260,247 $35,976 $17,859 $36,030 $24,947 $27,090 $17,486 $19,379 $25,487 $32,311 $23,683 MUL BLW NVY BLK TAN RED WHT BLK MUL TAN $74.95 $54.95 $59.95 $44.95 $54.95 $44.95 $69.96 $44.95 $54.95 $54.95 ON HAND INVENTORY $ $701,497 $83,120 $54,236 $95,440 $67,470 $56,049 $67,335 $70,030 $92,148 $70,886 $44,784 ON HAND INVENTORY UNITS 12,863 1109 987 1592 1501 1020 1498 1001 2050 1290 815 LENGTH MAXI MINI MAXI MINI MIDI PRINT FLORAL STRIPE STRIPE SOLID STRIPE FLORAL SOLID SOLID FLORAL STRIPE MINI 389 277 567 588 431 MAXI MINI MIDI MIDI ATTRIBUTE 1: PRINT ON HAND SALES $ INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) SOLID $69,813 $229,647 $250,509 STRIPE FLORAL $104,663 $85,772 $260,247 $221,340 $701,497 TOTAL ATTRIBUTE 1: PRINT SALES $ ON HAND INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) SOLID $229,647 STRIPE $69,813 $104,663 $85,772 $250,509 FLORAL $221,340 TOTAL $260,247 $701,497 Note what you would change or keep the same in PRINTS for your dress category assortment next year. ATTRIBUTE 1: LENGTH SALES $ ON HAND INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) MINI $85,778 MIDI $281,188 $171,719 $248,590 $701,497 $83,084 $91,385 $260,247 MAXI TOTAL Note what you would change or keep the same in PRINTS for your dress category assortment next year. Attribute Analysis HW Assignment In this assignment you are going to be conducting an attribute analysis on our store's dress category based on the below results in the selling report. First, calculate the sales % and inventory % for the attribute 1 PRINT. Once you complete the percentages then you can compare sales to inventory. Note the performance of each as overperforming, underperforming, or performing in line - sales compared to inventory. Lastly you'll note what changes you'd make to your assortment next season based on the results from your analysis. Then complete the sames steps for Attribute 2 LENGTH. DATA DUMP FROM YOUR REPORTING SYSTEM *BUYER DECIDES ON ATTRIBUTES* STYLE DESCRIPTION COLOR MSRP SALES $ SALES UNITS ATTRIBUTES TOTAL RESULTS FLORAL MAXI DRESS STRIPE MINI DRESS STRIPE MAXI DRESS SOLID MINI DRESS STRIPE MIDI DRESS FLORAL MINI DRESS SOLID MAXI DRESS SOLID MINI DRESS FLORAL MIDI DRESS STRIPE MIDI DRESS 4,706 480 325 601 555 493 $260,247 $35,976 $17,859 $36,030 $24,947 $27,090 $17,486 $19,379 $25,487 $32,311 $23,683 MUL BLW NVY BLK TAN RED WHT BLK MUL TAN $74.95 $54.95 $59.95 $44.95 $54.95 $44.95 $69.96 $44.95 $54.95 $54.95 ON HAND INVENTORY $ $701,497 $83,120 $54,236 $95,440 $67,470 $56,049 $67,335 $70,030 $92,148 $70,886 $44,784 ON HAND INVENTORY UNITS 12,863 1109 987 1592 1501 1020 1498 1001 2050 1290 815 LENGTH MAXI MINI MAXI MINI MIDI PRINT FLORAL STRIPE STRIPE SOLID STRIPE FLORAL SOLID SOLID FLORAL STRIPE MINI 389 277 567 588 431 MAXI MINI MIDI MIDI ATTRIBUTE 1: PRINT ON HAND SALES $ INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) SOLID $69,813 $229,647 $250,509 STRIPE FLORAL $104,663 $85,772 $260,247 $221,340 $701,497 TOTAL ATTRIBUTE 1: PRINT SALES $ ON HAND INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) SOLID $229,647 STRIPE $69,813 $104,663 $85,772 $250,509 FLORAL $221,340 TOTAL $260,247 $701,497 Note what you would change or keep the same in PRINTS for your dress category assortment next year. ATTRIBUTE 1: LENGTH SALES $ ON HAND INVENTORY $ SALES % PERFORMANCE INVENTORY % (SALES % VS. INVENTORY %) MINI $85,778 MIDI $281,188 $171,719 $248,590 $701,497 $83,084 $91,385 $260,247 MAXI TOTAL Note what you would change or keep the same in PRINTS for your dress category assortment next year