The turnover is 1.27

3. Explain why your stock turnover rate (cell H11) is high or low compared to industry averages, and what could potentially be impacting this rate based on the seasonal information provided and your understanding of stock turnover rates. merchandise plan assortment plan Sheet3 Sheet4 Sheet5 Sheet6 S student 1 student2 student 3 student 4 student 5 6 MONTH BUYING PLAN Final Project Students (4 or 5 on team) Sales (LY) % Planned Increase Planned Sales for Period $225.00 15% 5258.75 note that this rounded up fod season total in (14) Initial Markup % 52. Planned Reductions 3% note that this NOTE: since markdowns increase FEB MAR SEASON AUGUST 13 16% 17 23% is based on plan for TY and on gesult of LY season APR MAY JUNE JULY 15.77% 17.05% 18.95% 5.19 4.95 4.03 2.1% 3.9% 5.0% 17 14% Sales Distribution Stock-Sales Ratio Reductions Distribution 100.00% 5.43 4,83 turnover rate ??? 4.75 4.17 2.0% 22% 3.8% $34.08 $40 84 44.39 $44.63 $110.11 $211.98 $49.08 $192.79 $211.08 PLANNED MONTHLY SALES PLANNED MONTHLY BOM PLANNED MONTHLY EOM PLANNED MONTHLY REDUCTIONS PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST (OTB) $185.05 $186.11 $5.70 $40.84 $19.22 $218.59 $5.44 $44.16 $218.59 $197.79 $10.10 $33.47 $15.75 $46.21 $259,00 $223.17 average inventory????? $210.86 $9.84 $49.21 $43.73 ? Need a total S20,57 $223.17 $12.95 $87.41 $41.13 $5.18 $75,68 $35.61 $52.89 $24,89 merchandise plan assortment plan Sheet3 Sheet4 6 MONTH BUYING PLAN_Final Project student 1 student 2 student 3 student 4 student 5 $225.00 Students (4 or 5 on team) Sales (LY) % Planned Increase Planned Sales for Period 15% $258.75 note that this # is rounded up for season total in H14) Initial Markup % Planned Reductions % FEB 52.95% 3% note: that this is based on plan for TY and on result of LY seag MAR APR MAY JUNE 13.16% 17.23% 15.77% 17.05% 18.95% 5.43 4.17 5.19 4.95 4.03 2.2% 2.0% 2.1% 3.9% 5.0% Sales Distribution Stock-Sales Ratio Reductions Distribtution $34.08 $185.05 $44.16 $218.59 $197.79 $49.08 $197.79 $223.17 $186.11 PLANNED MONTHLY SALES PLANNED MONTHLY BOM PLANNED MONTHLY EOM PLANNED MONTHLY REDUCTIONS PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST (OTB) $44.63 $186.11 $211.98 $5.18 $75.68 $35.61 $40.84 $211.98 $218.59 $5.44 $52.89 $24.89 $10.10 $12.95 $5.70 $40.84 $19.22 $33.47 $15.75 $87.41 $41.13 merchandise plan assortmei student 5 H14) esult of LY season JUNE JULY 18.95% NOTE: since markdowns increase SEASON AUGUST 4.03 17.84% 100.00% 4.83 turnover rate ??? 3.8% 4.75 5.0% 250 44.39 $49.08 $197.79 $46.21 $259.00 $223.17 average inventory ?????? $210.85 $223.17 $12.95 $87.41 $41.13 $9.84 $49.21 $43.73 ? Need a total $20.57