+1 862 207 3288 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-Summer
LY LY LY LY
Season 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.00
14.63% 18.54% 17.41% 17.93% 16.42% 15.08% 100.00%
Aug’16 (Plan): Sep’16 (Plan):
$3,525.00 $3,590.00
Aug’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.00
15.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 4200
Reductions LY% Feb March April May Jun Jul Season Total
14.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 Aug
2.7 2.8 2.33 2.32 2.34 2.36 2.34
Fall Aug Sep Oct Nov Dec Jan’15
2.34 2.33 2.32 2.33 2.71 3.2
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!
