用Excel编制存货动态图表模板

存货报告Import 选择存货位置： in JV

存货趋势分析指标 0.48 0.48 2.01 1.52 1.32 1.56 1.64 2.12 2.28 2.61 3.03 2.94 平均存货 2667 2667 2667 2667 2667 2667 2667 2667 2667 2667 2667 2667指标 5000 4000 金额 平均存货

期间 jan feb mar apr may jun jul aug sep oct nov dec

金额 3745 3974 3865 3690 3184 2647 1834 1623 1793 1503 1497 2652

3000 2000 1000 0 jan feb mar apr may jun

Value Total Inventory Local Inventory Local in JV Local in DC Import Inventory Import in JV Import in DC Coverage Total Inventory Local Inventory Local in JV Local in DC Import Inventory Import in JV Import in DC

Jan 70,157 65,662 35,240 30,422 4,495 3,745 750 Jan 2.34 2.53 2.34 2.00 1.10 0.48 1.10

Feb 70,895 66,021 33,036 32,985 4,874 3,974 900 Feb 2.25 2.45 2.21 1.90 0.98 0.48 1.15

Mar 73,117 66,752 35,989 30,763 6,365 3,865 2,500 Mar 2.23 2.14 1.78 1.80 1.30 2.01 0.97

Apr 76,249 70,109 34,234 35,875 6,140 3,690 2,450 Apr 1.98 2.16 2.10 2.30 1.20 1.52 0.98

May 83,031 77,957 41,234 36,723 5,074 3,184 1,890 May 2.10 2.13 2.20 1.90 1.20 1.32 0.94

Jun 88,197 83,000 45,346 37,654 5,197 2,647 2,550 Jun 2.20 2.30 2.40 1.80 1.30 1.56 0.96

存货报告

指标

0.48 0.48 2.01 1.52 1.32 1.56 1.64 2.12 2.28 2.61 3.03 2.94

平均存货

266726672667266726672667266726672667266726672667

期间janfebmaraprmayjunjulaugsepoctnovdec金额374539743865369031842647183416231793150314972652

Total InventoryTotal Inventory 70,157 2.34 70,895 2.25 73,117 2.23 76,249 1.98 83,031 2.10 88,197 2.20

平均存货 3.50 3.00 2.502.00 1.50

1.00 0.50may jun jul aug sep oct nov dec

Jul 85,786 81,352 39,476 41,876 4,434 1,834 2,600 Jul 1.87 1.99 1.90 2.10 1.40 1.64 1.04

Aug 88,482 83,859 40,234 43,625 4,623 1,623 3,000 Aug 1.65 2.24 2.10 2.30 1.60 2.12 1.09

Sep 79,904 74,166 37,645 36,521 5,738 1,793 3,945 Sep 1.76 2.12 2.00 2.20 1.50 2.28 0.98

Oct 81,917 75,632 38,654 36,978 6,285 1,503 4,782 Oct 1.80 2.48 2.23 2.40 1.70 2.61 1.08

Nov 80,226 73,030 31,265 41,765 7,196 1,497 5,699 Nov 1.67 2.41 2.13 2.50 1.60 3.03 1.23

Dec 75,384 66,832 28,576 38,256 8,552 2,652 5,900 Dec 1.87 2.14 2.10 2.20 1.70 2.94 1.45

6

85,786 88,482 79,904 81,917 80,226 75,384 1.87 1.65 1.76 1.80 1.67 1.87

6