采购成本分析表excel模板

采购批次采购数量平均存量存储成本采购成本总成本2

¥ 920.00 ¥ 460.00 ¥ 7,360.00 ¥ 910.00 ¥ 8,569.003

¥ 613.33 ¥ 306.67 ¥ 4,906.67 ¥ 1,365.00 ¥ 6,271.674

¥ 460.00 ¥ 230.00 ¥ 3,680.00 ¥ 1,820.00 ¥ 5,500.005

¥ 368.00 ¥ 184.00 ¥ 2,944.00 ¥ 2,275.00 ¥ 5,219.006

¥ 306.67 ¥ 153.33 ¥ 2,453.33 ¥ 2,730.00 ¥ 5,183.337

¥ 262.86 ¥ 131.43 ¥ 2,547.00 ¥ 3,185.00 ¥ 5,732.008

¥ 230.00 ¥ 115.00 ¥ 1,840.00 ¥ 3,640.00 ¥ 5,480.009

¥ 204.44 ¥ 102.22 ¥ 1,635.56 ¥ 4,095.00 ¥ 5,730.5610

¥ 184.00 ¥ 124.00 ¥ 1,984.00 ¥ 4,550.00 ¥ 6,534.0011

¥ 178.00 ¥ 89.00 ¥ 1,869.00 ¥ 5,005.00 ¥ 6,874.0012

¥ 153.33 ¥ 76.67 ¥ 1,226.67 ¥ 5,460.00 ¥ 6,686.6713

¥ 141.54 ¥ 70.77 ¥ 1,132.31 ¥ 5,915.00 ¥ 7,047.3114 ¥ 131.43 ¥ 65.71 ¥ 1,051.43 ¥ 6,370.00 ¥ 7,421.43年采购计划量1840采购成本455单位存储成本16采购成本分析表

基础数据

辅助列表

¥2,000.00

¥3,000.00

¥4,000.00

¥5,000.00

¥6,000.00

¥7,000.00

¥8,000.00