采购成本预算表( 以季度为周期).xlsx
上传人:lj****88 上传时间:2024-09-14 格式:XLSX 页数:3 大小:28KB 金币:10 举报 版权申诉
预览加载中,请您耐心等待几秒...

采购成本预算表( 以季度为周期).xlsx

采购成本预算表(以季度为周期).xlsx

预览

免费试读已结束,剩余 2 页请下载文档后查看

10 金币

下载此文档

如果您无法下载资料,请参考说明:

1、部分资料下载需要金币,请确保您的账户上有足够的金币

2、已购买过的文档,再次下载不重复扣费

3、资料包下载后请先用软件解压,在使用对应软件打开

采购管理工具——采购成本控制管理采购成本预算表(xxx年度,以季度为周期)说明:采购成本是指由购买存货而发生的买价(购买价格或发票价格)和运杂费(运输费用和装卸费用)构成的成本,其总额取决于采购数量和单位采购成本。本表格已将每个季度的采购量、采购费、人工费、运杂费、仓储费等成本明细都已经详细列出,可以用来进行年度采购成本预算,帮助采购管理者有效的控制采购成本。(内含自动计算公式,数据为模拟数据)编制人部门编制日期文件编号采购物料第1季度第2季度第3季度第4季度年度采购总成本物料类别名称规格型号单位单价计划采购量采购费人工费运杂费仓储费本月采购预算小计计划采购量采购费人工费运杂费仓储费本月采购预算小计计划采购量采购费人工费运杂费仓储费本月采购预算小计计划采购量采购费人工费运杂费仓储费本月采购预算小计本年度计划采购量采购费人工费运杂费仓储费本年度采购成本预算合计重点材料50500250005005005992659960030000500500400314001000500008009006005230068034000280200100345802780139000208021001699144879200500100000500500599101599601120200500500400121600100120020080090060020250068113620028020010013678027835566002080210016995624798050040000500500599415996024816050050040049560100280160800900600824606825456028020010055140278622288020802100169922875990500450005005005994659960354270500500400556701003902708009006009257068361470280200100620502789251010208021001699256889原材料28500140005005005991559960416912500500400183121004281128009006003041268419152280200100197322792781762080210016998405550500250005005005992659960530250500500400316501005502508009006005255068534250280200100348302795139750208021001699145629505002500050050059926599606303005005004003170010065030080090060052600686343002802001003488027981399002080210016991457795050025000500500599265996073035050050040031750100750350800900600526506873435028020010034930280114005020802100169914592940500200005005005992159960824320500500400257201008403208009006004262068827520280200100281002804112160208021001699118039辅助材料50500250005005005992659960930450500500400318501009504508009006005275068934450280200100350302807140350208021001699146229505002500050050059926599610305005005004003190010105050080090060052800690345002802001003508028101405002080210016991463795050025000500500599265996113055050050040031950101150550800900600528506913455028020010035130281314065020802100169914652950500250005005005992659961230600500500400320001012506008009006005290069234600280200100351802816140800208021001699146679355001750050050059919099613214555005004002285510133