HOMEWORK \#3 - BALANCING INVENTORY USING \% TO TOTAL for This problem is going to use all the things we've learned so far this semester to analyze sales and inventory productivity INSTRUCTIONS: 1. Calculate data for all yellow highlighted columns INCLUDING TOTAL 2. Identify 4 Items That Meet ALL the following criteria for a Strong Item that you can do something about to maximize future sales: 1) Strong sell-thru (STD sell-thru \% greater than 50%, which is about 25% above weighted STD s/t) 2) Weeks of Supply for a BASIC item that does not look excessive ( Look at dept. total and remember what we said about basic WOS expectations) 3) UNDERbought using the \% to total method : meaning the IDEAL supply will be based on \% to total 4) Average weeks sales greater than department simple average by 20% 5) Copy and paste all info on those four int the box provided THE BEST WAY TO DO THIS IS HIGHLIGHT EACH STYLEICATEGORY THAT APPLIES AND THEN SEE WHERE THEY ALIGN ACROSS THE COLUMNS I WOULD CHANGE THE COLOR OF THE CELL TO WHITE WHERE YOU SEE THE CRITERIA APPLY - THEN YOU CAN VISULLY SEE WHERE THEY ALIGN Do not sort the data until you are through highlighting -because there are many croteria to sort by 3. Choose 1 item of the strong 4 to write bulleted action plan. Your action plan should be two sentences each, since you have multiple criteria to discuss 4. Identify the style with the worst metrics and performance. ( hint: look at s/t and WOS for the most important criteria to determine the worst ) WOS: (Oh+00)/ Avg unit sales per week STD sell thru\%: STD unit sales/ ( OH+STD unit sales) STD sales \% to total : STD unit sales /total STD unit sales OH+OO%TL:OH+OO style/ Total OH+OO Ideal OH+OO units: Total OH+OO STD sales \% total Unit under/over =Ideal (OH+OO) HOMEWORK \#3 - BALANCING INVENTORY USING \% TO TOTAL for This problem is going to use all the things we've learned so far this semester to analyze sales and inventory productivity INSTRUCTIONS: 1. Calculate data for all yellow highlighted columns INCLUDING TOTAL 2. Identify 4 Items That Meet ALL the following criteria for a Strong Item that you can do something about to maximize future sales: 1) Strong sell-thru (STD sell-thru \% greater than 50%, which is about 25% above weighted STD s/t) 2) Weeks of Supply for a BASIC item that does not look excessive ( Look at dept. total and remember what we said about basic WOS expectations) 3) UNDERbought using the \% to total method : meaning the IDEAL supply will be based on \% to total 4) Average weeks sales greater than department simple average by 20% 5) Copy and paste all info on those four int the box provided THE BEST WAY TO DO THIS IS HIGHLIGHT EACH STYLEICATEGORY THAT APPLIES AND THEN SEE WHERE THEY ALIGN ACROSS THE COLUMNS I WOULD CHANGE THE COLOR OF THE CELL TO WHITE WHERE YOU SEE THE CRITERIA APPLY - THEN YOU CAN VISULLY SEE WHERE THEY ALIGN Do not sort the data until you are through highlighting -because there are many croteria to sort by 3. Choose 1 item of the strong 4 to write bulleted action plan. Your action plan should be two sentences each, since you have multiple criteria to discuss 4. Identify the style with the worst metrics and performance. ( hint: look at s/t and WOS for the most important criteria to determine the worst ) WOS: (Oh+00)/ Avg unit sales per week STD sell thru\%: STD unit sales/ ( OH+STD unit sales) STD sales \% to total : STD unit sales /total STD unit sales OH+OO%TL:OH+OO style/ Total OH+OO Ideal OH+OO units: Total OH+OO STD sales \% total Unit under/over =Ideal (OH+OO)