95 采购成本预算表（以季度为周期）.xlsx

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