超市最强的数据分析模板.xls
( 4.5 )《超市最强的数据分析模板.xls》由会员分享，可在线阅读，更多相关《超市最强的数据分析模板.xls（54页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、本本周周（3.28-4.33.28-4.3）门门店店综综合合数数据据统统计计门门店店本本周周预预算算 本本周周销销售售预预算算达达成成比比销销售售占占比比 上上周周销销售售上上周周销销售售占占比比占占比比增增减减 周周销销售售环环比比 本本周周毛毛利利JM001JM001246.75221.9289.94%31.01%229.8229.92%1.09%-3.44%19.09JM002JM00269.3957.0282.17%7.97%53.767.00%0.97%6.07%4.60JM003JM003119.6499.9383.53%13.97%104.9713.67%0.30%-4.80%8
2、.13JM004JM00454.0843.9281.22%6.14%44.915.85%0.29%-2.19%3.19JM005JM005164.3598.5159.94%13.77%106.2013.83%-0.06%-7.25%8.10JM006JM006162.40101.6862.61%14.21%129.5316.87%-2.66%-21.50%9.41JM007JM00733.6227.0180.35%3.78%27.513.58%0.19%-1.80%2.03JM008JM00893.4365.5970.20%9.17%71.309.28%-0.12%-8.01%4.86合计94
3、3.66715.5975.83%100.00%768.00100.00%0.00%-6.82%59.41本本周周（3.28-4.33.28-4.3）部部组组综综合合数数据据统统计计部组本本周周预预算算 本本周周销销售售预预算算达达成成比比销销售售占占比比 上上周周销销售售上上周周销销售售占占比比占占比比增增减减 周周销销售售环环比比 本本周周毛毛利利蔬果组86.1059.3868.96%8.30%63.838.31%-0.01%-6.97%0.00肉品组51.9328.8655.58%4.03%26.493.45%0.58%8.93%0.00水产组15.005.7138.05%0.80%6.2
4、90.82%-0.02%-9.19%0.00熟食组41.5527.7966.87%3.88%28.723.74%0.14%-3.24%0.00生鲜部194.58121.7362.56%17.01%125.3216.32%0.69%-2.87%0.00日配172.49123.4171.54%17.25%129.6416.88%0.37%-4.81%10.53加工组180.40129.2771.66%18.06%147.2419.17%-1.11%-12.21%11.70休闲组84.4973.9387.50%10.33%79.2310.32%0.01%-6.70%8.22酒饮组59.0933.59
5、56.85%4.69%32.294.20%0.49%4.05%3.29食品处496.47360.1972.55%50.34%388.4050.57%-0.24%-7.26%33.74清洁用品165.58179.78#25.12%194.0525.27%-0.14%-7.36%20.51家用百货组 34.6220.7359.87%2.90%24.553.20%-0.30%-15.58%4.08服装鞋帽组 43.2425.9059.90%3.62%27.873.63%-0.01%-7.05%1.05文体用品组9.177.2679.12%1.01%7.811.02%0.00%-7.05%0.03用品
6、部252.61233.6692.50%32.65%254.2833.11%-0.46%-8.11%25.67超市小计943.66715.5975.83%100.00%768.00100.00%0.00%-6.82%59.41自自营营销销售售毛毛利利率率上上周周毛毛利利上上周周自自营营销销售售上上周周毛毛利利率率周周毛毛利利环环比比毛毛利利率率增增减减本本周周日日均均来来客客上上周周日日均均来来客客169.5011.26%20.97176.7211.87%-8.96%-0.60%4704496942.5510.81%4.7143.218.76%-2.36%2.05%1705179779.6710
7、.21%7.9786.567.60%2.00%2.61%3427306933.799.44%3.5933.427.99%-11.14%1.45%1723174476.0710.65%8.6882.848.18%-6.72%2.47%2942318282.8111.36%12.10100.999.34%-22.23%2.02%2629322520.519.88%2.1320.617.73%-4.78%2.14%1093113049.959.73%5.3955.327.55%-9.76%2.18%29323078554.8510.71%65.54599.668.53%-9.36%2.17%2644
8、2774自自营营销销售售毛毛利利率率上上周周毛毛利利上上周周自自营营销销售售上上周周毛毛利利率率周周毛毛利利环环比比毛毛利利率率增增减减本本周周日日均均来来客客上上周周日日均均来来客客0.00#DIV/0!0.000.00#DIV/0!#DIV/0!#DIV/0!465850900.00#DIV/0!0.000.00#DIV/0!#DIV/0!#DIV/0!111612870.00#DIV/0!0.000.00#DIV/0!#DIV/0!#DIV/0!3354110.00#DIV/0!0.000.00#DIV/0!#DIV/0!#DIV/0!310132240.00#DIV/0!0.000.0
9、0#DIV/0!#DIV/0!#DIV/0!123.418.54%11.80129.649.10%-10.75%-0.57%75267996129.279.05%13.14147.248.92%-10.94%0.13%5637614767.4112.20%9.5171.3913.32%-13.51%-1.12%5596609933.459.83%3.3832.0510.54%-2.68%-0.71%36753470353.549.54%37.82380.329.95%-10.79%-0.40%176.5111.62%21.62190.3711.36%-5.13%0.26%6716736019.
10、3721.08%4.7522.6221.02%-14.12%0.06%10861256本本周周（3.28-4.33.28-4.3）门门店店综综合合数数据据统统计计本本周周（3.28-4.33.28-4.3）部部组组综综合合数数据据统统计计5.3319.66%1.306.1821.09%-19.57%-1.43%9009380.1028.20%0.050.1726.97%-36.69%1.23%248325201.3112.75%27.72219.3412.64%-7.40%0.11%554.8510.71%65.54599.6610.93%-9.36%-0.22%周周来来客客数数增增减减本本周
11、周日日均均客客单单价价上上周周日日均均客客单单价价周周客客单单价价环环比比增增减减-26567.3966.071.32-9247.7842.745.0435841.6648.87-7.21-2236.4236.78-0.35-24047.8447.680.16-59755.2657.37-2.11-3735.3234.790.53-14631.9633.09-1.13-130386.61395.48-8.86周周来来客客数数增增减减本本周周日日均均客客单单价价上上周周日日均均客客单单价价周周客客单单价价环环比比增增减减-43218.2117.910.02-17136.9629.420.26-7
12、624.3221.850.11-12312.8012.720.01-47023.4223.160.01-51032.7634.22-0.04-50318.8718.560.0220513.0613.29-0.02-64438.2437.660.02-16927.2627.93-0.02-3841.1342.46-0.03-7741.8434.310.22本本周周（3.28-4.33.28-4.3）蔬蔬果果组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美蔬果组20.3015.747
13、7.52%26.50%17.1026.78%-0.28%平百蔬果组4.705.95126.61%10.02%5.438.51%1.51%密云蔬果组7.208.74121.36%14.72%8.2912.99%1.72%通州蔬果组7.404.5261.12%7.62%4.967.78%-0.16%双桥蔬果组15.208.1053.26%13.63%9.1614.36%-0.72%机场蔬果组16.006.6941.81%11.27%8.9614.03%-2.76%燕郊蔬果组4.202.2653.73%3.80%2.413.78%0.02%良乡蔬果组11.107.3966.56%12.44%7.51
14、11.77%0.68%蔬蔬果果汇汇总总86.1086.1059.3859.3868.96%68.96%100.00%100.00%63.8363.83100.00%100.00%本本周周（3.28-4.33.28-4.3）肉肉品品组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美肉品组12.707.9762.74%13.42%5.929.27%4.15%平百肉品组3.104.53146.28%7.64%1.482.31%5.32%密云肉品组9.504.6949.39%7.90%4.
15、607.21%0.69%通州肉品组4.201.9947.50%3.36%2.333.64%-0.28%双桥肉品组10.705.2048.60%8.76%5.859.17%-0.41%机场肉品组4.100.348.33%0.58%2.153.38%-2.80%燕郊肉品组2.031.7686.88%2.97%1.782.78%0.19%良乡肉品组5.602.3742.27%3.99%2.393.74%0.24%肉肉品品汇汇总总51.9351.9328.8628.8655.58%55.58%48.61%48.61%26.4926.4941.51%41.51%本本周周（3.28-4.33.28-4.3
16、）水水产产组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美水产组4.052.0249.79%3.40%1.983.10%0.29%平百水产组0.850.5160.16%0.86%0.270.42%0.44%密云水产组2.400.9539.72%1.61%1.061.66%-0.05%通州水产组0.900.3943.44%0.66%0.520.81%-0.15%双桥水产组2.020.3718.45%0.63%0.460.71%-0.09%机场水产组2.200.188.32%0.31
17、%0.610.96%-0.65%燕郊水产组0.880.2730.54%0.45%0.430.68%-0.23%良乡水产组1.701.0159.51%1.70%0.961.51%0.20%水水产产汇汇总总15.0015.005.715.7138.05%38.05%9.61%9.61%6.296.299.85%9.85%本本周周（3.28-4.33.28-4.3）熟熟食食组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美熟食组11.109.8588.72%16.58%9.9015.51
18、%1.07%平百熟食组2.852.4886.86%4.17%2.083.26%0.91%密云熟食组4.703.6176.88%6.09%2.453.83%2.25%通州熟食组3.312.2568.00%3.79%2.503.91%-0.12%双桥熟食组8.583.4540.20%5.81%2.834.43%1.37%机场熟食组6.102.9047.59%4.89%5.528.65%-3.76%燕郊熟食组1.110.9182.12%1.54%0.971.53%0.01%良乡熟食组3.802.3361.42%3.93%2.463.86%0.07%熟熟食食汇汇总总41.5541.5527.7927.
19、7966.87%66.87%46.79%46.79%28.7228.7244.99%44.99%本本周周（3.28-4.33.28-4.3）日日配配组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美日配40.0032.6481.61%54.98%33.0751.81%3.17%平百日配19.3610.3753.55%17.46%10.4516.38%1.08%密云日配23.0016.5371.89%27.84%17.0126.65%1.20%通州日配11.008.7279.29%1
20、4.69%9.3714.67%0.01%双桥日配28.5018.7265.70%31.53%19.2130.10%1.43%机场日配23.8018.2176.50%30.66%22.8135.74%-5.08%燕郊日配5.834.8382.89%8.14%4.436.94%1.20%良乡日配21.0013.3863.71%22.53%13.2920.81%1.72%日日配配汇汇总总172.49172.49123.41123.4171.54%71.54%207.83%207.83%129.64129.64203.11%203.11%本本周周（3.28-4.33.28-4.3）加加工工组组数数据据
21、统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美加工组44.5033.3875.02%56.22%38.0659.63%-3.41%平百加工组13.809.3167.48%15.68%6.7510.58%5.10%密云加工组30.0026.3887.93%44.42%26.6441.74%2.68%通州加工组8.708.0091.96%13.47%7.3611.54%1.94%双桥加工组30.6017.2356.32%29.02%22.6235.44%-6.41%机场加工组28.0016.4
22、258.63%27.65%21.4833.66%-6.01%燕郊加工组8.806.3171.70%10.63%7.1211.16%-0.53%良乡加工组16.0012.2476.47%20.61%17.2026.94%-6.33%加加工工汇汇总总180.40180.40129.27129.2771.66%71.66%217.70%217.70%147.24147.24230.68%230.68%本本周周（3.28-4.33.28-4.3）休休闲闲组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比
23、比增增减减和美休闲组20.8022.34107.39%37.62%24.0837.72%-0.10%平百休闲组7.086.9998.72%11.77%7.6812.04%-0.27%密云休闲组9.507.9583.64%13.38%8.8513.87%-0.49%通州休闲组6.506.2596.15%10.53%6.5710.30%0.23%双桥休闲组14.709.5665.03%16.10%9.6415.10%1.00%机场休闲组13.6011.4283.96%19.23%12.3519.34%-0.11%燕郊休闲组2.812.5189.43%4.23%2.493.90%0.33%良乡休闲组
24、9.506.9172.78%11.64%7.5711.86%-0.21%休休闲闲汇汇总总84.4984.4973.9373.9387.50%87.50%124.50%124.50%79.2379.23124.14%124.14%本本周周（3.28-4.33.28-4.3）酒酒饮饮组组数数据据统统计计门门店店部部组组本本周周预预算算本本周周销销售售预预算算达达成成比比销销售售占占比比上上周周销销售售上上周周销销售售占占比比占占比比增增减减和美酒饮组14.708.8360.07%14.87%7.1511.20%3.67%平百酒饮组4.802.1745.11%3.65%1.812.84%0.81%密
25、云酒饮组4.402.9566.96%4.96%4.937.72%-2.76%通州酒饮组4.002.6766.86%4.50%2.443.82%0.68%双桥酒饮组12.506.1749.36%10.39%4.847.59%2.80%机场酒饮组10.806.0656.13%10.21%6.9410.87%-0.66%燕郊酒饮组1.691.2875.96%2.16%0.971.51%0.65%良乡酒饮组6.203.4655.81%5.83%3.215.03%0.80%酒酒饮饮汇汇总总59.0959.0933.5933.5956.85%56.85%56.57%56.57%32.2932.2950.5
- 配套讲稿：
如PPT文件的首页显示word图标，表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制：
部分文档作品中含有的国旗、国徽等图片，仅作为作品整体效果示例展示，禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词：
- 超市 最强 数据 分析 模板
淘文阁 - 分享文档赚钱的网站所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。
限制150内