超市管理系统表

,序号供应商编号类别联系人联系电话地址供货周期结账周期发票备注,1.0供应商1G0001生鲜类,2.0供应商2G0002水产类,3.0供应商3G0003食品类,4.0供应商4G0004酒水类,5.0供应商5G0005坚果类,6.0供应商6G0006水果类,7.0供应商7G0007生活用品类,8.0供应商8GL0001生鲜类,9.0供应商9GL0002水产类,10.0供应商10GL0003食品类,11.0供应商11GL0004酒水类,12.0供应商12GL0005坚果类网店发票,13.0供应商13GL0006果蔬类,14.0供应商14GL0007生活用品类网店发票,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,序号品名类别编号单位销售单价常备库存备注,1.0香蕉F000013.99根据上一日销量采购，17:00后不补货,2.0苹果F000028.99,3.0梨F000032.99,4.0哈密瓜F000044.5,芒果F00005,6.0螃蟹S0000150.0,7.0虾S0000230.0,鱼S00003,猪肉SH000125.030.0,牛肉SH000238.0,11.0羊肉SH000335.0,青椒SH00042.0,13.0菠菜SH00051.99,14.0南瓜SH00062.3,土豆SH00071.8,16.0旺旺雪饼SP0001,17.0旺旺雪梅SP0002,18.0软面包SP00039.9,19.0红酒JS0001102.0,白酒JS000248.0,21.0啤酒JS00033.5,22.0饮料JS00043.0,23.0核桃JG0001,24.0开心果JG000222.0,25.0花生JG0003,26.0拖把AR0001件,27.0扫帚AR0002件,28.0洗洁精AR00039.9,序号月份日期品名类别编号单位单价数量金额供应商收货人质量抽检备注,香蕉F000011.6160.0,苹果F000024.0400.0,3.0梨F000031.2120.0,4.0哈密瓜F00004200.0,5.0芒果F000054.6460.0,螃蟹S0000130.03000.0,7.0虾S0000214.01400.0,鱼S000035.0500.0,9.0猪肉SH00011600.0,10.0牛肉SH000228.02800.0,11.0羊肉SH000322.02200.0,12.0青椒SH0004,13.0菠菜SH0005,14.0南瓜SH0006,15.0土豆SH0007,旺旺雪饼SP0001优－,17.0旺旺雪梅SP00029.0900.0,18.0软面包SP0003,19.0红酒JS000156.05600.0,20.0白酒JS000220.02000.0,21.0啤酒JS00031.6160.0,22.0饮料JS00041.5150.0,23.0核桃JG0001,24.0开心果JG00021600.0,25.0花生JG0003,26.0拖把AR0001件,27.0扫帚AR0002件,28.0洗洁精AR00035.8580.0,29.043497.0,30.043498.0,31.0,序号月份日期品名类别编号单位单价数量金额备注,香蕉F000013.9993.0371.07,苹果F000028.99719.2,梨F000032.99239.2,4.0哈密瓜F000044.5360.0,芒果F00005720.0,6.0螃蟹S0000150.04000.0,7.0虾S0000230.02400.0,鱼S00003720.0,猪肉SH000125.02000.0,10.0牛肉SH000238.03040.0,11.0羊肉SH000335.02800.0,青椒SH000496.0192.0,13.0菠菜SH00051.99159.2,14.0南瓜SH00062.3184.0,土豆SH00071.8144.0,16.0旺旺雪饼SP0001,17.0旺旺雪梅SP00021200.0,18.0软面包SP0003792.0,19.0红酒JS0001102.08160.0,20.0白酒JS000248.03840.0,21.0啤酒JS00033.5280.0,饮料JS0004240.0,23.0核桃JG0001640.0,24.0开心果JG00021760.0,25.0花生JG0003,26.0拖把AR00011200.0,27.0扫帚AR0002,28.0洗洁精AR0003792.0,29.043498.0软面包SP000349.5,30.043499.0红酒JS0001102.0510.0,31.043500.0白酒JS000248.0240.0,32.043501.0啤酒JS00033.517.5,33.043502.0饮料JS0004,34.043503.0核桃JG000140.0,35.043504.0开心果JG0002110.0,36.043505.0花生JG000360.0,37.043506.0拖把AR000175.0,38.043507.0扫帚AR000260.0,39.043508.0洗洁精AR000349.5,40.0,41.0,42.0,序号品名编号单位前库存入库数量销售数量现库存备注,1.0香蕉F0000193.07.0低于常备库存时显示黄的提示,2.0苹果F00002,3.0梨F00003,4.0哈密瓜F00004,5.0芒果F00005,6.0螃蟹S00001,7.0虾S00002,8.0鱼S00003,9.0猪肉SH0001,10.0牛肉SH0002,11.0羊肉SH0003,12.0青椒SH000496.04.0低于常备库存时显示黄的提示,13.0菠菜SH0005,14.0南瓜SH0006,土豆SH0007,16.0旺旺雪饼SP0001,17.0旺旺雪梅SP0002,18.0软面包SP0003,19.0红酒JS0001,白酒JS0002,21.0啤酒JS0003,22.0饮料JS0004,23.0核桃JG0001,24.0开心果JG0002,25.0花生JG0003,26.0拖把AR0001件,27.0扫帚AR0002件,28.0洗洁精AR0003,序号类别销售金额占比每月销售明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0生鲜类8519.20.2074859282358519.2,2.0水产类7120.00.1734082788337120.0,3.0食品类3001.50.0731018186682952.049.5,4.0酒水类13302.50.32398365578312520.0782.5,5.0坚果类3570.00.08694769036983360.0210.0,6.0水果类2409.470.05868287157292409.47,7.0生活用品类3136.50.07638975653922952.0184.5,8.0,9.0,合计41059.17,项目月度利润分析,1.02.03.04.05.06.07.08.09.010.011.012.0,采购金额28370.0,销售金额39832.671226.5,场地费用5000.0,水电费1000.0,人工费用1000.0,货架费用500.0,税费500.0,其他费用200.0,毛利润3262.672000.0