【管理表格】家樂福內(nèi)部分析資訊

1、Monthly Survey ResultDepartment 10Department 14HSSNSTotalHSSNSTotalNumber of items20109755884Number of items505393,1573,746% of total items2.26%12.33%85.41%100% of total items1.33%14.39%84.28%100%Average price index96.896.398.5Average price index96.097.0100.1% Turnover48.60%24.83%26.57%100% Turnover

2、21.74%24.68%53.58%100%Gross Margin rate2.09%6.37%10.00% 5.25%Gross Margin rate1.77%5.69%8.22%6.19%Department 11Department 15HSSNSTotalHSSNSTotalNumber of items1075296381Number of items1569904988% of total items2.62%19.69%77.69%100% of total items1.52%6.98%91.50%100%Average price index93.497.7#N/AAve

3、rage price index96.196.497.7% Turnover14.20%42.15%43.65%100% Turnover18.68%18.73%62.60%100%Gross Margin rate4.53%4.12%10.57% 6.99%Gross Margin rate3.58%6.70%9.42%7.82%Department 12GroceryHSSNSTotalHSSNSTotalNumber of items333332,0412,407Number of items1281,1257,1538,406% of total items1.37%13.83%84.

4、79%100% of total items1.52%13.38%85.09%100%Average price index94.296.598.5Average price index95.596.899.3% Turnover6.84%25.14%68.02%100% Turnover18.45%25.16%56.39%100%Gross Margin rate2.40%4.95%10.45% 8.51%Gross Margin rate2.21%5.42%9.60%7.18%Grocery Survey Result of NovemberBazaar Survey Result of

5、NovemberDepartment 30Department 33HSSNSTotalHSSNSTotalNumber of items1056852918Number of items3281,7021,733% of total items1.09%6.10%92.81%100% of total items0.17%1.62%98.21%100%Average price index93.097.298.5Average price index100.096.596.3% Turnover11.91%25.53%62.56%100% Turnover1.75%4.75%93.51%10

6、0%Gross Margin rate11.42%10.32%19.41%16.13%Gross Margin rate12.44%14.43%16.54%16.36%Department 31Department 34HSSNSTotalHSSNSTotalNumber of items9682,9062,983Number of items115241257% of total items0.30%2.28%97.42%100% of total items0.39%5.84%93.77%100%Average price index93.696.298.1Average price in

7、dex100.093.691.5% Turnover4.49%8.77%86.74%100% Turnover33.56%14.19%52.25%100%Gross Margin rate4.78%15.93%16.34%15.79%Gross Margin rate40.96%22.05%17.46%26.00%Department 32Department 35HSSNSTotalHSSNSTotalNumber of items5464,1334,184Number of items113281295% of total items0.12%1.10%98.78%100% of tota

8、l items0.34%4.41%95.25%100%Average price index97.096.296.7Average price index90.096.2#N/A% Turnover2.12%7.79%90.09%100% Turnover8.78%8.72%82.50%100%Gross Margin rate11.33%8.02%18.15%17.21%Gross Margin rate15.17%25.21%21.79%21.51%BazaarHSSNSTotalNumber of items2922610,11510,370% of total items0.28%2.

9、18%97.54%100%Average price index94.796.497.6% Turnover4.46%9.38%86.16%100%Gross Margin rate9.71%13.31%17.01%16.34%Appliance Survey Result of NovemberDepartment 40Department 43HSSNSTotalHSSNSTotalNumber of items727254288Number of items340256299% of total items2.43%9.38%88.19%100% of total items1.00%1

10、3.38%85.62%100%Average price index95.397.1100.1Average price index92.695.696.3% Turnover13.15%23.37%63.48%100% Turnover17.55%34.23%48.21%100%Gross Margin rate-0.14%-1.24%0.60%0.07%Gross Margin rate0.46%5.31%5.23%4.42%Department 41Department 44HSSNSTotalHSSNSTotalNumber of items1064343417Number of it

11、ems443249296% of total items2.40%15.35%82.25%100% of total items1.35%14.53%84.12%100%Average price index93.896.797.9Average price index98.198.799.2% Turnover10.80%32.55%56.66%100% Turnover5.69%43.22%51.09%100%Gross Margin rate0.38%2.74%5.23%3.89%Gross Margin rate0.04%0.31%0.23%0.25%Department 42Depa

12、rtment 45HSSNSTotalHSSNSTotalNumber of items557431493Number of items05225230% of total items1.01%11.56%87.42%100% of total items0.00%2.17%97.83%100%Average price index94.395.0101.8Average price index#N/A#N/A#N/A% Turnover24.41%33.98%41.61%100% Turnover0.00%16.86%83.14%100%Gross Margin rate-4.02%-0.4

13、3%2.07%-0.27%Gross Margin rate#DIV/0!4.92%0.76%1.46%ApplianceHSSNSTotalNumber of items292361,7582,023% of total items1.43%11.67%86.90%100%Average price index94.696.898.7% Turnover15.77%33.96%50.28%100%Gross Margin rate-2.41%0.62%2.24%0.96%Trend of Survey result- GroceryPricing IndexJanFebMarAprMayJu

14、nJulAugSepOctNovDecHS95.897.094.995.495.596.195.996.494.994.895.5S96.396.795.094.995.295.996.096.097.496.696.8NS100.598.395.399.196.796.997.096.899.298.399.3Sales ParticipationJanFebMarAprMayJunJulAugSepOctNovDecHS17.60%19.77%18.37%18.75%18.14%18.51%19.26%17.21%24.00%22.97%18.45%S15.76%14.85%15.31%1

15、3.91%12.18%11.36%11.00%10.57%24.21%23.45%25.16%NS66.64%65.37%66.32%67.35%69.68%70.14%69.74%72.22%51.80%53.58%56.39%MarginJanFebMarAprMayJunJulAugSepOctNovDecHS3.71%5.51%1.68%2.31%2.59%1.33%2.59%3.11%2.40%2.30%2.21%S4.57%7.42%4.12%5.69%6.09%6.97%5.90%5.26%6.95%6.62%5.42%NS9.30%9.18%9.58%9.53%9.19%9.6

16、8%8.25%7.91%9.62%9.96%9.60%Price index90.092.094.096.098.0100.0102.0JanFebMarAprMayJunJulAug SepOctNovDecHSSNSSales0.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%Jan Feb MarApr MayJunJulAug Sep OctNov DecHSSNSMargin0.00%2.00%4.00%6.00%8.00%10.00%12.00%JanFebMarAprMayJunJulAug SepOctNovDecHSSNS

17、Trend of Survey result- BazaarPricing IndexJanFebMarAprMayJunJulAugSepOctNovDecHS93.495.093.092.591.593.091.489.094.894.894.7S93.795.691.888.290.192.992.793.396.796.496.4NS97.795.190.694.293.696.896.194.998.696.997.6Sales ParticipationJanFebMarAprMayJunJulAugSepOctNovDecHS4.41%3.96%2.73%5.38%4.04%2.

18、02%1.79%1.54%5.52%5.23%4.46%S8.21%6.58%7.77%6.77%8.40%6.06%4.90%4.49%13.98%12.12%9.38%NS87.38%89.46%89.49%87.85%87.57%91.91%93.31%93.97%80.50%82.65%86.16%MarginJanFebMarAprMayJunJulAugSepOctNovDecHS9.82%9.29%11.78%6.79%8.40%14.02%12.09%11.82%8.31%10.18%9.71%S11.36%15.19%11.00%10.83%10.24%11.04%10.05

19、%9.90%15.29%14.92%13.31%NS15.62%16.82%18.39%18.05%17.91%18.29%17.70%16.64%17.17%16.86%17.01%Price index80.085.090.095.0100.0JanFebMarAprMayJunJulAugSepOctNovDecHSSNSSales0.00%20.00%40.00%60.00%80.00%100.00%JanFebMarApr MayJunJulAug SepOctNov DecHSSNSMargin0.00%5.00%10.00%15.00%20.00%JanFebMarAprMayJ

20、unJulAugSepOctNovDecHSSNSTrend of Survey result- AppliancePricing IndexJanFebMarAprMayJunJulAugSepOctNovDecHS92.395.292.391.992.194.596.596.594.594.594.6S93.993.190.189.690.690.192.492.296.796.996.8NS99.596.188.980.290.789.290.091.598.196.898.7Sales ParticipationJanFebMarAprMayJunJulAugSepOctNovDecHS3.41%4.20