AutoSave OFF HW-2A-Merchandise Plan-Fall Season Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Calibri (Body) 9 Paste BIU ' ' A ab Wrap Text Insert General Share 4 Comments Delete v Merge & Center $ %" Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data Sensitivity Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No 15 fx A B C D E F G H J K L M N P Q 1234567829 10 Spring-Summer LY Fall-Winter LY Spring-Summer Fall-Winter LY LY Season Sales in Mn S Stock turnover Profit% $ 20,988.00 $ 21,443.00 Markdowns 7.30% 9.40% 3.9 12.60% 4.8 14.30% Shortages 2.10% 2.60% Employee Discounts 1.10% 1.42% Operating Expenses 34.35% 38.00% Feb March April May Jun Jul $ 3,070.00 $ 3,892.00 $ 3,653.00 $ 3,763.00 $ 3,446.00 $ 3,164.00 $ Season Total 20,988.00 $ Aug Sep 3,389.00 $ 14.63% 18.54% 17.41% 17.93% 16.42% 15.08% 100.00% Oct 3,500.00 $3,300.00 11 12 13 14 15 Sales (2017-2018) in MnS Spring-Summer Aug Sep (Plan for next year): |(Plan for next year): $ 3,525.00 $ 3,590.00 Feb March Aug Sep Oct Nov Dec Jan $ 3,389.00 $ 3,500.00 $ 3,300.00 $ 3,904.00 $ 4,785.00 $ 2,565.00 $ Season Total 21,443.00 $ 3,085.00 $ April 3,760.00 $ 3,450.00 15.80% 16.32% 15.39% 18.21% 22.31% 11.96% 100.00% Fall-Winter Feb (Plan for next year): March (Plan for next year): 3310 4200 16 SARAN 22222222 31 Note **For S-S ratio method: use BOMs from next month (calculate based on sales and ratio) **For Basic stock method use avg stock figures for each respective season for Jan EOM Spring March April 14.23% 8.32% 17% May 18.50% Jun 22.10% Jul 19.85% Season Total 100.00% Reductions LY% Fall Aug Sep Oct Nov Dec 23 11.50% 7.00% 18.50% 22.10% (next year) 25.90% 100.00% Spring Feb March April May Jun Jul Aug 2.7 2.8 2.33 2.32 2.34 2.36 2.34 S-S ratio Fall Aug Sep Oct Nov Dec Jan (next year) 2.34 2.33 2.71 3.2 Estimates Fall-Basic Stock Method Fall-S-S Ratio Method + Ready Page: 1 of 1 B + 115%