166 采购成本预算表（季度）.xlsx

采购管理工具采购成本控制管理采购成本预算表（季度）说明：采购成本是指由购买存货而发生的买价(购买价格或发票价格)和运杂费(运输费用和装卸费用)构成的成本，其总额取决于采购数量和单位采购成本。本表格已将每月的采购量、采购费、人工费、运杂费、仓储费等成本明细都已经详细列出，可以用来进行季度采购成本预算，帮助采购管理者有效的控制采购成本。（内含自动计算公式，数据为模拟数据）编制人部门编制日期采采购购物物料料 10 月月份份 11 月月份份 12 月月份份物物料料类类别别名名称称规规格格型型号号单单位位单单价价计计划划采采购购量量采采购购费费 人人工工费费 运运杂杂费费 仓仓储储费费本本月月采采购购预预算算小小计计计计划划采采购购量量采采购购费费 人人工工费费 运运杂杂费费 仓仓储储费费本本月月采采购购预预算算小小计计计计划划采采购购量量重点材料20200400020030010046001002000200300100260050202004000200300100460010120202003001002620512020040002003001004600102204020030010026405220200400020030010046001032060200300100266053原材料2020040002003001004600104208020030010026805420200400020030010046001052100200300100270055202004000200300100460010621202003001002720562020040002003001004600107214020030010027405720200400020030010046001082160200300100276058辅助材料2020040002003001004600109218020030010027805920200400020030010046001102200200300100280060202004000200300100460011122202003001002820612020040002003001004600112224020030010028406220200400020030010046001132260200300100286063其他物料2020040002003001004600114228020030010028806420200400020030010046001152300200300100290065202004000200300100460011623202003001002920662020040002003001004600117234020030010029406720200400020030010046001182360200300100296068合合 计计38007600038005700190087400207141420380057001900528201121预预计计现现金金支支出出 10 月份 11 月份 12 月份部部门门经经理理复复核核总总经经理理审审批批文件编号第第 4 季季度度合合 计计采采购购费费 人人工工费费 运运杂杂费费 仓仓储储费费本本月月采采购购预预算算小小计计本本季季度度计计划划采采购购量量采采购购费费 人人工工费费 运运杂杂费费 仓仓储储费费本本季季度度采采购购预预算算合合计计100020030010016003507000600900300880010202003001001620352704060090030088401040200300100164035470806009003008880106020030010016603567120600900300892010802003001001680358716060090030089601100200300100170036072006009003009000112020030010017203627240600900300904011402003001001740364728060090030090801160200300100176036673206009003009120 12 月月份份11802003001001780368736060090030091601200200300100180037074006009003009200122020030010018203727440600900300924012402003001001840374748060090030092801260200300100186037675206009003009320128020030010018803787560600900300936013002003001001900380760060090030094001320200300100192038276406009003009440134020030010019403847680600900300948013602003001001960386772060090030095202242038005700190033820699213984011400171005700174040第 4 季度合计 12 月份