办公用品采购管理表

,供应商管理表,序号供应商类别供应周期账结周期发票联系人联系方式地址备注,1.0供应商1,2.0供应商2,3.0供应商3网店发票网店,4.0供应商4办公设备,5.0供应商5办公设备,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,商品管理表,序号品名编号型号规格单位采购单价与网店对比网络直营店单价网店链接备注,1.0产品1B0000110.00.19.0,2.0产品2B0000211.010.78,3.0产品3B0000312.011.76,4.0产品4B0000413.012.74,5.0产品5B0000514.013.72,6.0产品6B0000615.014.7,7.0产品7B0000716.015.68,8.0产品8B0000817.016.66,9.0产品9B0000918.017.64,10.0产品10B0001019.018.62,11.0产品11B0001120.019.6,12.0产品12B0001221.020.58,13.0产品13B0001322.021.56,14.0产品14B0001423.022.54,15.0产品15B0001524.023.52,16.0产品16B0001625.024.5,17.0产品17B0001726.025.48,18.0产品18B0001827.026.46,19.0产品19B0001928.027.44,20.0产品20B0002029.028.42,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0, 备注：采购周期定义未1个月采购1次，每月10号前提报。序号部门品名编号型号规格单位每月需求提报,1.02.03.04.05.06.07.08.09.011.012.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,11.0产品11B00011,12.0产品12B00012,13.0产品13B00013,14.0产品14B00014,15.0产品15B00015,16.0产品16B00016,17.0产品17B00017,18.0产品18B00018,19.0产品19B00019,20.0产品20B00020,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0产品11B00011,42.0产品12B00012,43.0产品13B00013,44.0产品14B00014,45.0产品15B00015,46.0, 备注：采购周期定义未1个月采购1次，每月10号前提报。序号品名编号型号规格单位每月需求汇总,1.02.03.04.05.06.07.08.09.011.012.0,1.0产品1B00001,2.0产品2B00002,3.0产品3B00003,4.0产品4B00004,5.0产品5B00005,6.0产品6B00006,7.0产品7B00007,8.0产品8B00008,9.0产品9B00009,产品10B00010,11.0产品11B00011,12.0产品12B00012,13.0产品13B00013,14.0产品14B00014,15.0产品15B00015,16.0产品16B00016,17.0产品17B00017,18.0产品18B00018,19.0产品19B00019,产品20B00020,21.0,22.0,23.0,24.0,25.0,26.0,27.0,采购跟踪表,序号下单日期采购单号供应商品名编号型号规格单位数量单价金额供应商确认人状态备注,1.0产品1B00001300.0,2.0产品2B0000211.0330.0,3.0产品3B0000312.0360.0,4.0产品4B0000413.0390.0,5.0产品5B0000514.0420.0,6.0产品6B0000615.0450.0,7.0产品7B0000716.0480.0,8.0产品8B0000817.0510.0,9.0产品9B0000918.0540.0,产品10B0001019.0570.0,11.0产品11B00011400.0,12.0产品12B0001221.0420.0,13.0产品13B0001322.0440.0,14.0产品14B0001423.0460.0,15.0产品15B0001524.0480.0,16.0产品16B0001625.0250.0,17.0产品17B0001726.0260.0,18.0产品18B0001827.0270.0待收货,19.066100005.0供应商5产品19B0001927.44274.4姓名5运输中,66100005.0供应商5产品20B0002028.42284.2姓名5待发货,21.04242,22.0,23.0,24.0,25.0,26.0,27.0,28.0,采购入库记录表,序号月份日期入库单号供应商品名编号型号规格单位数量单价金额确认人备注,产品1B00001300.0,2.0产品2B0000211.0330.0,3.0产品3B0000312.0360.0,4.0产品4B0000413.0390.0,5.0产品5B0000514.0420.0,6.0产品6B0000615.0450.0,7.0产品7B0000716.0480.0,8.0产品8B0000817.0510.0,9.0产品9B0000918.0540.0,产品10B0001019.0570.0,11.0产品11B00011400.0,12.0产品12B0001221.0420.0,13.0产品13B0001322.0440.0,14.0产品14B0001423.0460.0,15.0产品15B0001524.0480.0,16.0产品16B0001625.0250.0,17.0产品17B0001726.0260.0,18.0产品18B0001827.0270.0,19.066100005.0供应商5产品19B0001927.44274.4,66100005.0供应商5产品20B0002028.42284.2,21.04242,22.0,23.0,24.0,25.0,26.0,27.0,28.0,领用明细表,序号月份日期品名编号型号规格单位数量金额领用部门领用人经办人备注,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,11.0产品11B00011200.0,12.0产品12B00012210.0,13.0产品13B00013220.0,14.0产品14B00014230.0,15.0产品15B00015240.0,16.0产品16B00016250.0,17.0产品17B00017260.0,18.0产品18B00018270.0,19.0产品19B00019274.4,20.0产品20B00020284.2,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0产品11B00011200.0,42.0产品12B00012210.0,43.0产品13B00013220.0,44.0产品14B00014230.0,45.0产品15B00015240.0,46.0,47.0,部门费用分析表,序号部门总费用占比每月费用明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0品质1260.00.1597241589131260.0,2.0生产2838.60.3598357122942838.6,3.0销售1240.00.1571888548031240.0,4.0仓储600.00.0760591232918600.0,5.0生计1050.00.1331034657611050.0,6.0财务900.00.114088684938900.0,7.0,8.0,9.0,10.0,11.0,12.0,供应商分析表,序号部门总费用占比每月费用明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0供应商11380.00.1749359835711380.0,2.0供应商22970.00.3764926602952970.0,3.0供应商31260.00.1597241589131260.0,4.0供应商41720.00.2180361534371720.0,5.0供应商5558.60.0708110437847558.6,6.0,7.0,8.0,9.0,10.0,11.0,12.0