超市供销存管理表

,序号供应商编号类别地址联系人联系电话送货周期结账周期等级备注,1.0供应商1G0001生鲜类60天AA,2.0供应商2G0002生鲜类,3.0供应商3G0003果蔬类,4.0供应商4G0004果蔬类,5.0供应商5G0005酒水类5H,6.0供应商6G0006酒水类,7.0供应商7G0007干杂类5H,8.0供应商8G0008干杂类8H,9.0供应商9G0009日用品类12H,10.0供应商10G0010日用品类1天60天AA,11.0,12.0,13.0,14.0,序号品名编号类别型号规格单位采购单价销售单价会员价保质期备注,1.0品名16600001.010.013.3,2.0品名26600002.011.015.414.63,3.0品名36600003.0果蔬类12.016.815.967天,4.0品名46600004.0果蔬类13.018.217.297天,5.0品名56600005.019.618.62,6.0品名66600006.015.019.95,7.0品名76600007.0干杂类16.022.421.28,8.0品名86600008.0干杂类17.023.822.61,9.0品名96600009.0日用品类18.025.223.94,10.0品名106600010.0日用品类19.026.625.27,11.0品名116600011.020.028.026.61天,12.0品名126600012.029.427.931天,13.0品名136600013.022.030.829.26,品名146600014.023.032.230.59,15.0品名156600015.024.033.631.92,16.0,17.0,18.0,19.0,20.0,22.0,23.0,24.0,25.0,26.0,27.0,序号品名编号类别型号规格单位现有库存每次采购数量采购周期备注,1.0品名16600001.0当库存＜10时下单采购，采购数量根据每天销售量定,品名26600002.0,3.0品名36600003.0果蔬类,4.0品名46600004.0果蔬类,5.0品名56600005.0,6.0品名66600006.0,7.0品名76600007.0干杂类,8.0品名86600008.0干杂类,9.0品名96600009.0日用品类5天/次,品名106600010.0日用品类5天/次,11.0品名116600011.0,12.0品名126600012.0,13.0品名136600013.0,14.0品名146600014.0,15.0品名156600015.01.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,序号日期单号品名编号类别型号规格单位数量坏损实收数金额收货人备注,1.0Y8800001品名16600001.0100.0,2.0Y8800001品名26600002.0110.0,3.0Y8800002品名36600003.0120.0,4.0Y8800002品名46600004.0130.0,5.0Y8800003品名56600005.0140.0,6.0Y8800003品名66600006.0150.0,7.0Y8800004品名76600007.0160.0,8.0Y8800004品名86600008.0170.0,9.0Y8800005品名96600009.0180.0,Y8800005品名106600010.0190.0,11.0Y8800006品名116600011.0200.0,12.0Y8800006品名126600012.0210.0,13.0品名136600013.0220.0,14.0品名146600014.0230.0,品名156600015.01.019.0456.0,16.0Y8800008品名16600001.0100.0,17.0Y8800008品名26600002.0110.0,18.0Y8800009品名36600003.0120.0,19.0Y8800009品名46600004.0130.0,Y8800010品名56600005.0140.0,21.0Y8800010品名66600006.0150.0,22.0Y8800011品名76600007.0160.0,23.0Y8800011品名86600008.0170.0,24.0Y8800012品名96600009.0180.0,25.0Y8800012品名106600010.0190.0,26.0Y8800013品名116600011.0300.0,27.0Y8800013品名126600012.0210.0,28.0品名136600013.0220.0,29.0品名146600014.0230.0,30.0品名156600015.0480.0,42,42,序号品名编号类别型号规格单位1月2月3月4月5月6月7月8月9月10月11月12月,43831.043832.043833.043834.043835.043836.043837.043838.043839.043840.043841.043842.043843.043844.043845.043846.043847.043848.043849.043850.043851.043852.043853.043854.043855.043856.043857.043858.043859.043860.043861.043862.043863.043864.043865.043866.043867.043868.043869.043870.043871.043872.043873.043874.043875.043876.043877.043878.043879.043880.043881.043882.043883.043884.043885.043886.043887.043888.043889.043890.043891.043892.043893.043894.043895.043896.043897.043898.043899.043900.043901.043902.043903.043904.043905.043906.043907.043908.043909.043910.043911.043912.043913.043914.043915.043916.043917.043918.043919.043920.043921.043922.043923.043924.043925.043926.043927.043928.043929.043930.043931.043932.043933.043934.043935.043936.043937.043938.043939.043940.043941.043942.043943.043944.043945.043946.043947.043948.043949.043950.043951.043952.043953.043954.043955.043956.043957.043958.043959.043960.043961.043962.043963.043964.043965.043966.043967.043968.043969.043970.043971.043972.043973.043974.043975.043976.043977.043978.043979.043980.043981.043982.043983.043984.043985.043986.043987.043988.043989.043990.043991.043992.043993.043994.043995.043996.043997.043998.043999.044000.044001.044002.044003.044004.044005.044006.044007.044008.044009.044010.044011.044012.044013.044014.044015.044016.044017.044018.044019.044020.044021.044022.044023.044024.044025.044026.044027.044028.044029.044030.044031.044032.044033.044034.044035.044036.044037.044038.044039.044040.044041.044042.044043.044044.044045.044046.044047.044048.044049.044050.044051.044052.044053.044054.044055.044056.044057.044058.044059.044060.044061.044062.044063.044064.044065.044066.044067.044068.044069.044070.044071.044072.044073.044074.044075.044076.044077.044078.044079.044080.044081.044082.044083.044084.044085.044086.044087.044088.044089.044090.044091.044092.044093.044094.044095.044096.044097.044098.044099.044100.044101.044102.044103.044104.044105.044106.044107.044108.044109.044110.044111.044112.044113.044114.044115.044116.044117.044118.044119.044120.044121.044122.044123.044124.044125.044126.044127.044128.044129.044130.044131.044132.044133.044134.044135.044136.044137.044138.044139.044140.044141.044142.044143.044144.044145.044146.044147.044148.044149.044150.044151.044152.044153.044154.044155.044156.044157.044158.044159.044160.044161.044162.044163.044164.044165.044166.044167.044168.044169.044170.044171.044172.044173.044174.044175.044176.044177.044178.044179.044180.044181.044182.044183.044184.044185.044186.044187.044188.044189.044190.044191.044192.044193.044194.044195.044196.0,1.0品名16600001.0100.0100.0,2.0品名26600002.0110.0110.0,3.0品名36600003.0果蔬类120.0120.0,4.0品名46600004.0果蔬类130.0130.0,5.0品名56600005.0140.0140.0,6.0品名66600006.0150.0150.0,7.0品名76600007.0干杂类160.0160.0,8.0品名86600008.0干杂类170.0170.0,9.0品名96600009.0日用品类180.0180.0,品名106600010.0日用品类190.0190.0,11.0品名116600011.0200.0300.0,12.0品名126600012.0210.0210.0,13.0品名136600013.0220.0220.0,14.0品名146600014.0230.0230.0,品名156600015.0456.0480.0,16.0,17.0,18.0,备注：收银系统数据导出,序号月份日期品名编号类别型号规格单位数量金额收银员备注,品名16600001.0140.0,品名26600002.0154.0,3.0品名36600003.0168.0,4.0品名46600004.0182.0,5.0品名56600005.0196.0,6.0品名66600006.0210.0,7.0品名76600007.0224.0,品名86600008.0238.0,9.0品名96600009.0252.0,品名106600010.0266.0,11.0品名116600011.0280.0,12.0品名126600012.0294.0,13.0品名136600013.0308.0,14.0品名146600014.0322.0,15.019.0638.4,16.0品名16600001.0112.0,17.0品名26600002.0123.2,18.0品名36600003.0134.4,19.0品名46600004.0145.6,20.0品名56600005.0156.8,21.0品名66600006.0168.0,22.0品名76600007.0179.2,23.0品名86600008.0190.4,24.0品名96600009.0201.6,25.0品名106600010.0212.8,26.0品名116600011.012.0336.0,27.0品名126600012.0235.2,28.0品名136600013.0246.4,29.0品名146600014.0257.6,30.018.0604.8,31.03.043891.033.6,32.042,序号品名编号类别型号规格单位2.03.04.05.06.07.09.011.0,43831.043832.043833.043834.043835.043836.043837.043838.043839.043840.043841.043842.043843.043844.043845.043846.043847.043848.043849.043850.043851.043852.043853.043854.043855.043856.043857.043858.043859.043860.043861.043862.043863.043864.043865.043866.043867.043868.043869.043870.043871.043872.043873.043874.043875.043876.043877.043878.043879.043880.043881.043882.043883.043884.043885.043886.043887.043888.043889.043890.043891.043892.043893.043894.043895.043896.043897.043898.043899.043900.043901.043902.043903.043904.043905.043906.043907.043908.043909.043910.043911.043912.043913.043914.043915.043916.043917.043918.043919.043920.043921.043922.043923.043924.043925.043926.043927.043928.043929.043930.043931.043932.043933.043934.043935.043936.043937.043938.043939.043940.043941.043942.043943.043944.043945.043946.043947.043948.043949.043950.043951.043952.043953.043954.043955.043956.043957.043958.043959.043960.043961.043962.043963.043964.043965.043966.043967.043968.043969.043970.043971.043972.043973.043974.043975.043976.043977.043978.043979.043980.043981.043982.043983.043984.043985.043986.043987.043988.043989.043990.043991.043992.043993.043994.043995.043996.043997.043998.043999.044000.044001.044002.044003.044004.044005.044006.044007.044008.044009.044010.044011.044012.044013.044014.044015.044016.044017.044018.044019.044020.044021.044022.044023.044024.044025.044026.044027.044028.044029.044030.044031.044032.044033.044034.044035.044036.044037.044038.044039.044040.044041.044042.044043.044044.044045.044046.044047.044048.044049.044050.044051.044052.044053.044054.044055.044056.044057.044058.044059.044060.044061.044062.044063.044064.044065.044066.044067.044068.044069.044070.044071.044072.044073.044074.044075.044076.044077.044078.044079.044080.044081.044082.044083.044084.044085.044086.044087.044088.044089.044090.044091.044092.044093.044094.044095.044096.044097.044098.044099.044100.044101.044102.044103.044104.044105.044106.044107.044108.044109.044110.044111.044112.044113.044114.044115.044116.044117.044118.044119.044120.044121.044122.044123.044124.044125.044126.044127.044128.044129.044130.044131.044132.044133.044134.044135.044136.044137.044138.044139.044140.044141.044142.044143.044144.044145.044146.044147.044148.044149.044150.044151.044152.044153.044154.044155.044156.044157.044158.044159.044160.044161.044162.044163.044164.044165.044166.044167.044168.044169.044170.044171.044172.044173.044174.044175.044176.044177.044178.044179.044180.044181.044182.044183.044184.044185.044186.044187.044188.044189.044190.044191.044192.044193.044194.044195.044196.0,品名16600001.0140.0112.0,2.0品名26600002.0154.0123.2,3.0品名36600003.0果蔬类168.0134.4,4.0品名46600004.0果蔬类182.0145.6,5.0品名56600005.0196.0156.8,6.0品名66600006.0210.0168.0,7.0品名76600007.0干杂类224.0179.2,品名86600008.0干杂类238.0190.4,9.0品名96600009.0日用品类252.0201.6,品名106600010.0日用品类266.0212.8,11.0品名116600011.0280.0336.0,品名126600012.0294.0235.2,13.0品名136600013.0308.0246.4,14.0品名146600014.0322.0257.6,15.0品名156600015.0638.4604.833.6,16.0,17.0,20.0,序号品名编号类别型号规格单位原库存入库数量销售数量过期数量现库存备注,品名16600001.0,品名26600002.0,3.0品名36600003.0果蔬类,4.0品名46600004.0果蔬类,5.0品名56600005.0,6.0品名66600006.0,7.0品名76600007.0干杂类,8.0品名86600008.0干杂类,9.0品名96600009.0日用品类,10.0品名106600010.0日用品类,11.0品名116600011.025.022.0,12.0品名126600012.0,13.0品名136600013.0,14.0品名146600014.0,15.0品名156600015.039.038.0,16.0,17.0,19.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,序号类别销售金额占比每月销售明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0生鲜类1674.40.232233009709868.0806.4,2.0果蔬类630.00.0873786407767350.0280.0,3.0酒水类3141.60.435728155341674.41433.633.6,4.0干杂类831.60.115339805825462.0369.6,5.0日用品类932.40.12932038835518.0414.4,6.0,7.0,8.0,9.0,10.0,11.0,12.0,序号品名编号类别型号规格单位采购金额库存金额损坏金额销售金额毛利润备注,1.0品名16600001.0200.0252.032.0,2.0品名26600002.0220.022.0277.235.2,3.0品名36600003.0果蔬类240.0302.438.4,4.0品名46600004.0果蔬类260.026.0327.641.6,5.0品名56600005.0280.028.0352.844.8,6.0品名66600006.0300.030.0378.048.0,7.0品名76600007.0干杂类320.032.0403.251.2,8.0品名86600008.0干杂类340.034.0428.454.4,9.0品名96600009.0日用品类360.036.0453.657.6,10.0品名106600010.0日用品类380.038.0478.860.8,11.0品名116600011.0500.040.0616.056.0,12.0品名126600012.0420.042.0529.267.2,13.0品名136600013.0440.044.0554.470.4,14.0品名146600014.0460.046.0579.673.6,15.0品名156600015.0936.01276.8316.8,16.0,17.0,18.0,19.0,21.0,22.0,23.0,25.0,26.0,27.0