Retail Buying Plan

Using estimated values for W-wear provided on Excel, complete LY figures for Fall using basic stock method and s-s ratio method which are the first two worksheets only.Fall-Winter Spring-Summer Fall-Winter Spring-SummerLY LY LY LYSeason Sales in Mn $ $21,588.00 $20,988.00 Markdowns 9.40% 7.30%Stock turnover 4.8 3.9 Shortages 2.60% 2.10%Profit% 14.30% 12.60% Employee Discounts 1.42% 1.10%Operating Expenses 38.00% 34.35%Sales (2014-15) in Mn$ Feb’15 March’15 April’15 May’15 Jun’15 Jul’15 Season Total Aug ‘15 Sep’15 Oct ‘15$3,070.00 $3,892.00 $3,653.00 $3,763.00 $3,446.00 $3,164.00 $20,988.00 $3,359.00 $3,416.00 $3,559.0014.63% 18.54% 17.41% 17.93% 16.42% 15.08% 100.00%Aug’16 (Plan): Sep’16 (Plan):$3,525.00 $3,590.00Aug’14 Sep’14 Oct’14 Nov’14 Dec’14 Jan’15 (next year) Season Total Feb’15 March’15 April’15$3,389.00 $3,500.00 $3,300.00 $3,904.00 $4,785.00 $2,565.00 $21,443.00 $3,070.00 $3,892.00 $3,653.0015.80% 16.32% 15.39% 18.21% 22.31% 11.96% 100.00%**For S-S ratio method: use BOMs from next month (calculate based on sales and ratio) Feb ’16 (Plan): March ’16 (Plan):** For Basic stock method use avg stock figures for each respective season for Jan EOM 3310 4200Reductions LY% Feb March April May Jun Jul Season Total14.23% 8.32% 17% 18.50% 22.10% 19.85% 100.00%Aug Sep Oct Nov Dec Jan (2013)11.50% 7.00% 15% 18.50% 22.10% 25.90% 100.00%S-S ratio Spring Feb March April May Jun Jul  Aug2.7 2.8 2.33 2.32 2.34 2.36  2.34Fall Aug Sep Oct Nov Dec Jan’152.34 2.33 2.32 2.33 2.71 3.2