Question: February ( 4 ) March ( 5 ) April ( 4 ) May ( 4 ) June ( 5 ) July ( 4 ) Total

February (4) March (5) April (4) May (4) June (5) July(4) Total Season
Sales ($) TY Plan $310,852 $414,469 $449,008 $621,703 $1,036,172 $759,860 $3,592,063
Sales ($) LY Actual $310,852 $414,469 $449,008 $621,703 $898,016 $759,860 $3,453,907
+/-% Chg.0%0%0%0%15%0%4%
Sales (%) TY Plan 8.7%11.5%12.5%17.3%28.8%21.2%100.0%
Sales (%) LY Actual 9.0%12.0%13.0%18.0%26.0%22.0%100.0%
Reductions ($) TY Plan
Reductions ($) LY Actual $50,842 $65,210 $88,420 $99,473 $138,156 $110,525 $552,625
+/-% Chg.
Reductions (%) of ttl season TY Plan
Reductions (%) of ttl season LY Actual 9.2%11.8%16.0%18.0%25.0%20.0%100.0%
Reductions Rate (%) TY Plan 20.0%
Reductions Rate (%) LY Actual 16.4%15.7%19.7%16.0%15.4%14.5%16.0%
Stock to Sales Ratio TY Plan 2.152.102.252.302.402.25
Stock to Sales Ratio LY Actual 2.252.302.502.602.202.50
BOP ($) TY Plan
BOP ($) LY Actual $699,416 $953,278 $1,122,520 $1,616,428 $1,975,635 $1,899,649 $1,377,821
+/-% Chg.
EOP ($) TY Plan $1,695,000
EOP ($) LY Actual $953,278 $1,122,520 $1,616,428 $1,975,635 $1,899,649 $1,769,800 $1,556,218
+/-% Chg.
Purchases ($ retail) TY Plan
Purchases ($retail) LY Actual $615,555 $648,920 $1,031,337 $1,080,382 $960,186 $740,536 $5,076,916
+/-% Chg.
Initial MU% TY Plan
Initial MU% LY Actual 63.0%63.7%61.9%62.4%65.8%63.0%63.3%
Purchases ($ cost) TY Plan
Purchases ($ cost) LY Actual $227,755 $235,558 $392,939 $406,224 $328,384 $273,998 $1,864,858
+/-% Chg.
Gross Margin ($) TY Plan
Gross Margin ($) LY Actual $177,025 $240,346 $244,248 $350,541 $543,645 $437,817 $1,993,622
+/-% Chg.
Gross Margin (%) TY Plan
Gross Margin (%) LY Actual 56.9%58.0%54.4%56.4%60.5%57.6%57.7%
Turnover TY Plan
Turnover LY Actual 0.380.400.330.350.460.412.33
Sell Through % TY Plan
Sell Through % LY Actual 24.6%27.0%21.7%23.9%32.1%30.0%68.9%
Weeks of Supply TY Plan
Weeks of Supply LY Actual 10.612.512.211.610.89.7

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!