講義教案報告

1、Shanghai permarket Chain Store FileNameCurrentUser Report Select by G/R/D Siteetail, Shanghai permarket Chain Store FileNameCurrentUser Report Select by G/R/D Siteetail, ZRRP0310- MerchandiseDivi 2016.01.1306:33 Sales D/12-1月 -UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -2/ Sales,Stock and

2、Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% Site01 FRESH LIU LI QIAO -45.8 18.518.5 460-02 DRY -102.3 59.559.5 03 -1,034-04 -1,979-05 -430-06 FAMILY -14.8 -18.2-18.2 -07 OTHER MDSE -UserName INVEN059 NO.of

3、 Site 1Merchandise as of12-1月 -2/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% Site01 FRESH LIU LI QIAO -45.8 18.518.5 460-02 DRY -102.3 59.559.5 03 -1,034-04 -1,979-05 -430-06 FAMILY -14.8

4、-18.2-18.2 -07 OTHER MDSE -34-08 JEWELRY & 10 -24-40 CLUB 0041 NATIONWIDE 0049 0051 E0088 VALUE ADDED 90 DSUB -13,721 -50 -1 -TOTAL -54.0 14.9 14.9 13,720-EXCLUDE UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -3/ Sales,Stock and Markdown are in Date:2016.01.13 - -Monthly-Sales LY % To Sales L

5、WTDTY LW TY%To Sales %To Sales % %To DailyTY Stock Mark DW MTD GP% SiteLIU LI QIAO DAILY CUSTOMER % -26.1 DAILY AVERAGE % -% -GROUP % WTD CUSTOMER % 12.9 WTD AVERAGE % % AVERAGE YTD % MTD CUSTOMER % -6.9 MTD AVERAGE % % EX. % YTD CUSTOMER % -6.9 YTD AVERAGE % % Group 01 FRESH FOOD 001 PRODUCE-UserNa

6、me INVEN059 NO.of Site 1Merchandise as of12-1月 -3/ Sales,Stock and Markdown are in Date:2016.01.13 - -Monthly-Sales LY % To Sales LWTDTY LW TY%To Sales %To Sales % %To DailyTY Stock Mark DW MTD GP% SiteLIU LI QIAO DAILY CUSTOMER % -26.1 DAILY AVERAGE % -% -GROUP % WTD CUSTOMER % 12.9 WTD AVERAGE % %

7、 AVERAGE YTD % MTD CUSTOMER % -6.9 MTD AVERAGE % % EX. % YTD CUSTOMER % -6.9 YTD AVERAGE % % Group 01 FRESH FOOD 001 PRODUCE-002 MEAT-051 SEAFOOD-TOTAL 48.5 24.924.9 -Group 02 FRESH FOOD 047 DRIED -048 DESSERT-0000TOTAL -Group 03 FRESH FOOD 004BAKERY- PRODUCT005 DELICATESSEN-056 BREAD-116 FRESH -TOT

8、AL -Group 04 FRESH FOOD 003 FROZEN FOOD-152-053 DAIRY / DAILY-TOTAL -8.6 460-Group 10 DRY UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -4/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP

9、% SiteLIU LI QIAO 006 COOKING OIL-143.7 143.7 455-63-UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -4/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 006 COOKING OIL-143

10、.7 143.7 455-63-81-007 NEEDS008 FOOD-010 PASTA / -171-011 AGRICULTURAL -058 PET FOOD-083 IMPORT COOKING -96229-1,401-117 COOKING NEEDS-TOTAL -99.0 83.083.0 Group 12 DRY 017 -344-623-0050-95388-050 CANDY/CHOCOLATE-062 HEALTH -084 SNACK-118 -119 BABY & -TOTAL -7.8 -1,936-Group 13 DRY 009 -59.8 299.3 -

11、51.9 142.1 -51.9 142.1 -294-018 LIQUOR-019 BEVERAGE-256-000020 CIGARETTE054 GIFTUserName INVEN059 NO.of Site 1Merchandise as of12-1月 -5/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI

12、 QIAO 0085 IMPORT BEVERAGE-373.1 100.9 28-TOTAL -223.3 100.9Group 20 APP 036 LADIESWEAR-UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -5/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% Si

13、teLIU LI QIAO 0085 IMPORT BEVERAGE-373.1 100.9 28-TOTAL -223.3 100.9Group 20 APP 036 LADIESWEAR-42-039 F.ACC.-094 LADIES -TOTAL -Group 21 APP 040 MENS WEAR-55-120 MENS TOTAL -55-Group 22 APP -052 HOSIERY-135UND 136 LEISUREWEAR137 BRASSIERE138 -139 CONSIGNMENT TOTAL -649-Group 23 000090 MEN SHOES-Use

14、rName INVEN059 NO.of Site 1Merchandise as of12-1月 -6/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 0091 LADIES SHOES-4-092 K.SHOES/ACC.-50093 SPO./CAN.-UserName INVEN059 NO.of

15、Site 1Merchandise as of12-1月 -6/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 0091 LADIES SHOES-4-092 K.SHOES/ACC.-50093 SPO./CAN.-096 SLIPPER-TOTAL -Group 28 APP 038 GIRLS WEA

16、R-34-041 BOYS WEAR-095 GIRLS -121 BOYS -TOTAL -Group 29 105 CONSIGNMENT TOTAL Group 53 APPAREL 000000TOTAL Group 31 HL 025 KITCHEN-360-270-292-69-990-066 PLASTIC WARE / -101 DINING-107 HOUSEHOLD -TOTAL -UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -7/ Sales,Stock and Markdown are in Date:201

17、6.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO Group 32 HL 030 SUPPLY-101-15311-UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -7/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%

18、To Sales %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO Group 32 HL 030 SUPPLY-101-15311-033 SPORTING GOODS-034 LUGGAGE-035 GIFT & -064 ION6-TOTAL -Group 34 HL 026 -027 BATH-028 HOME DECOR-TOTAL -Group 35 HL 024 TOYS-029 FURNITURE-031 HARDWARE-26-51-00-032 AUTOMOTIVE-

19、067 LIGHTING0.16 -TOTAL -Group 37 HL 0000UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -8/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO TOTAL 00Group 39 000000TOTAL Group 30 HL

20、 UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -8/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO TOTAL 00Group 39 000000TOTAL Group 30 HL 00059 AV / 1097 TV-TOTAL -57-Group 33 H

21、L 023 MAJOR APPLIANCE-0.00 -049 SMALL APPLIANCE-TOTAL -373-Group 36 HL 1.90 3.95 1.90 3.95000072 MOBILE PHONE 073 BOOK / MAGAZINE000-00000-076 COMPUTER AND -AL TOTAL -UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -9/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY L

22、W TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 11 FAMILY CARE 012 COSMETICS-UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -9/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC Dail

23、yTY Stock MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 11 FAMILY CARE 012 COSMETICS-9013 HAIR CARE-014 BODY / SKIN -122 SKIN CLEANING-247-123 ORAL CARE-124 WOMEN SANITARY -0-140 TRAVELING TOTAL -Group 15 FAMILY CARE 015 P R GOODS-237-210-00-016 CLEAN-H.H.CHEMICAL-TOTAL -Group 16 FAMILY CARE 042 ACC.-0-

24、1-1043 INFANT WEAR-126 BABY DI -127 BABY 128TOYS& 129 MATERNITY WEAR130 MATERNITY CARE-TOTAL -33.8 -Group 51 OTHER UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -10/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stoc

25、k MarkDWTY Amount MTDTY GP% SiteLIU LI QIAO 104 -3434-TOTAL -Group 52 JEWELRY & UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -10/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales % %To Sales % %To TY INC DailyTY Stock MarkDWTY Amount MTDTY GP% SiteLIU

26、 LI QIAO 104 -3434-TOTAL -Group 52 JEWELRY & TOTAL Group 98 MARKETING 103 MARKETING -24-TOTAL -24-Group 14 C/P 074 C/P H.B.A.10075 C/P H.B.A.20077 C/P 0080 C/P BEVERAGE0TOTAL 00Group 38 C/P 081 C/P ELEC.1團購家電 0082 C/P HARDLINE0TOTAL 00Group 60 NATIONWIDE 0TOTAL 00Group 99 DUMMY 099 DUMMY 0TOTAL 00Group 70 UserName INVEN059 NO.of Site 1Merchandise as of12-1月 -11/ Sales,Stock and Markdown are in Date:2016.01.13 - -Sales % To Sales LWTDTY LW TY%To Sales %To Sales % %To DailyTY Stock MarkD