采購管理工具——采購計劃管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

各類物料月度采購計劃表（含預算）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

說明：采購計劃是指企業(yè)管理人員在了解市場供求情況，認識企業(yè)生產經營活動過程中和掌握物料消耗規(guī)律的基礎上對計劃期內物料采購管理活動所做的預見性的安排和部署。本文檔主要用于列出一年內各月度的采購計劃明細。（內含自動計算公式，所列數據為模擬數據）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序號,品名,類別,規(guī)格,使用部門,單位,年度計劃采購數量,單價,年度總預算,1月,,2月,,3月,,4月,,5月,,6月,,7月,,8月,,9月,,10月,,11月,,12月,

,,,,,,,,,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額,數量,金額

1,,,,,,1000,200,200000,100,20000,100,20000,100,20000,100,20000,100,20000,100,20000,100,20000,100,20000,50,10000,50,10000,50,10000,50,10000

2,,,,,,1000,200,200000,101,20200,101,20200,101,20200,101,20200,101,20200,101,20200,101,20200,101,20200,51,10200,51,10200,51,10200,51,10200

3,,,,,,1000,200,200000,102,20400,102,20400,102,20400,102,20400,102,20400,102,20400,102,20400,102,20400,52,10400,52,10400,52,10400,52,10400

4,,,,,,1000,200,200000,103,20600,103,20600,103,20600,103,20600,103,20600,103,20600,103,20600,103,20600,53,10600,53,10600,53,10600,53,10600

5,,,,,,1000,200,200000,104,20800,104,20800,104,20800,104,20800,104,20800,104,20800,104,20800,104,20800,54,10800,54,10800,54,10800,54,10800

6,,,,,,1000,200,200000,105,21000,105,21000,105,21000,105,21000,105,21000,105,21000,105,21000,105,21000,55,11000,55,11000,55,11000,55,11000

7,,,,,,1000,200,200000,106,21200,106,21200,106,21200,106,21200,106,21200,106,21200,106,21200,106,21200,56,11200,56,11200,56,11200,56,11200

8,,,,,,1000,200,200000,107,21400,107,21400,107,21400,107,21400,107,21400,107,21400,107,21400,107,21400,57,11400,57,11400,57,11400,57,11400

9,,,,,,1000,200,200000,108,21600,108,21600,108,21600,108,21600,108,21600,108,21600,108,21600,108,21600,58,11600,58,11600,58,11600,58,11600

10,,,,,,1000,200,200000,109,21800,109,21800,109,21800,109,21800,109,21800,109,21800,109,21800,109,21800,59,11800,59,11800,59,11800,59,11800

11,,,,,,1000,200,200000,110,22000,110,22000,110,22000,110,22000,110,22000,110,22000,110,22000,110,22000,60,12000,60,12000,60,12000,60,12000

12,,,,,,1000,200,200000,111,22200,111,22200,111,22200,111,22200,111,22200,111,22200,111,22200,111,22200,61,12200,61,12200,61,12200,61,12200

13,,,,,,1000,200,200000,112,22400,112,22400,112,22400,112,22400,112,22400,112,22400,112,22400,112,22400,62,12400,62,12400,62,12400,62,12400

14,,,,,,1000,200,200000,113,22600,113,22600,113,22600,113,22600,113,22600,113,22600,113,22600,113,22600,63,12600,63,12600,63,12600,63,12600

15,,,,,,1000,200,200000,114,22800,114,22800,114,22800,114,22800,114,22800,114,22800,114,22800,114,22800,64,12800,64,12800,64,12800,64,12800

16,,,,,,1000,200,200000,115,23000,115,23000,115,23000,115,23000,115,23000,115,23000,115,23000,115,23000,65,13000,65,13000,65,13000,65,13000

17,,,,,,1000,200,200000,116,23200,116,23200,116,23200,116,23200,116,23200,116,23200,116,23200,116,23200,66,13200,66,13200,66,13200,66,13200

18,,,,,,1000,200,200000,117,23400,117,23400,117,23400,117,23400,117,23400,117,23400,117,23400,117,23400,67,13400,67,13400,67,13400,67,13400

19,,,,,,1000,200,200000,118,23600,118,23600,118,23600,118,23600,118,23600,118,23600,118,23600,118,23600,68,13600,68,13600,68,13600,68,13600

20,,,,,,1000