D12 X V fx =D11*(1+L3) A B C D E F G H M DEPARTMENT NAME Insert your Department Name here Planned % Increase BUYER Alexa Krieff 10.0% SEASON SPRING 2022 February March April May June July August 6 Learning Unit 6 TOTAL 8 BOM STOCK $ (RETAIL) LAST YEAR $ 310.00 374.00 $ 420.00 $ 480.00 $ 516.00 $ 460.00 $ 348.00 9 PLAN THIS YEAR 341.00 11 LAST YEAR 70.00 $ 110.00 $ 140.00 $ 180.00 $ 220.00 $ 180.00 $ 900.00 12 PLAN THIS YEAR 77.00 1 $ 121.00 $ 140.00 180.00 $ 220.00 $ 180.00 918.00 13 % Change (inc/dec) 14 % to LY Sales 7.8% 12.2% 15.6% 20.0% 24.4% 20.0% 100.0% SALES $ % to Plan Sales LAST YEAR 6.00 $ 14.00 $ 30.00 $ 54.00 $ 66.00 $ 72.00 $ 242.00 PLAN THIS YEAR MD Rate LY 8.6% 12.7% 21.4% 30.0% 30.0% 40.0% 26.9% MD Rate Plan % to LY MD 2.5% 5.8% 12.4% 22.3% 27.3% 29.8% 100.0% MARKDOWNS $ % to Plan MD PURCHASES $ (RETAIL) LAST YEAR $ 140.00 $ 170.00 $ 230.00 $ 270.00 $ 230.00 $ 140.00 $ 1,180.00 PLAN THIS YEAR EOM STOCK $ (RETAIL) LAST YEAR $ 374.00 $ 420.00 $ 480.00 $ 516.00 $ 460.00 $ 348.00 PLAN THIS YEAR STOCK/SALES RATIO S/S Ratio LY 4.4 3.4 3.0 2.7 2.3 2.6 S/S Ratio Plan 4.4 3.4 3.0 2.7 2.3 2.6 SEASON TOT. LAST YEAR (ly) THIS YEAR (Plan) PERCENT CHANGE (TY PLAN VS. LY ACTUAL) Sales $ 900.00 Markdown $ 242.00 Average Stock $ 415.43 Purchases (at Ret.) $ $ 1,180.00 Cost of Purchases $ 354.00 IMU % 70.0% Markdown % 26.9% Gross Margin % 61.9% Turnover 2.17