采购成本分析表基础数据采购批次采购数量平均存量存储成本采购成本2¥920.00¥460.00¥7,360.00¥910.003¥613.33¥306.67¥4,906.67¥1,365.004¥460.00¥230.00¥3,680.00¥1,820.005¥368.00¥184.00¥2,944.00¥2,275.006¥306.67¥153.33¥2,453.33¥2,730.007¥262.86¥131.43¥2,102.86¥3,185.008¥230.00¥115.00¥1,840.00¥3,640.009¥204.44¥102.22¥1,635.56¥4,095.0010¥184.00¥92.00¥1,472.00¥4,550.0011¥167.27¥83.64¥1,338.18¥5,005.0012¥153.33¥76.67¥1,226.67¥5,460.0013¥141.54¥70.77¥1,132.31¥5,915.0014¥131.43¥65.71¥1,051.43¥6,370.00辅助列表年采购计划量1840采购成本455单位存储成本45678910111213¥2,944.00¥2,453.33¥2,102.86¥1,840.00¥1,635.56¥1,472.00¥1,338.18¥1,226.67¥1,132.31¥1,051.43¥182000¥2,275.00¥2,730.00¥3,185.00¥3,640.00¥4,095.00¥4,550.00¥5,005.00¥5,460.00¥5,915.00¥6,370.0012345678¥-¥1,000.00¥2,000.00¥3,000.00¥4,000.00¥5,000.00¥6,000.00¥7,000.00¥8,000.00¥7,360.00¥4,906.67¥3,680.00¥2,944.00¥2,453.33¥2,102.86¥1,840.00¥1,635.56¥910.00¥1,365.00¥1,820.00¥2,275.00¥2,730.00¥3,185.00¥3,640.00采购成本存储成本总成本¥8,270.00¥6,271.67¥5,500.00¥5,219.00¥5,183.33¥5,287.86¥5,480.00¥5,730.56¥6,022.00¥6,343.18¥6,686.67¥7,047.31¥7,421.43160.0000.00¥7,000.00¥8,000.00¥7,360.00
