產(chǎn)品收入、成本、利潤動態(tài)分析圖表xls

1、Chart1Page 11月2月3月4月5月6月7月8月9月10月11月12月020040060080010001200140047%48%49%50%51%52%53%54%55%56%57%58%銷售收入銷售成本銷售毛利銷售毛利率產(chǎn)產(chǎn)品品1 1 各各月月銷銷售售數(shù)數(shù)據(jù)據(jù)匯匯總總產(chǎn)品1銷售收入銷售策劃成本銷售毛利銷售毛利率SC1月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量97.935.219.543.2銷售單價39.924.022.260.9銷銷售售收收入入3,908.6844.8432.92,6

2、30.9銷售成本2,375.1383.7241.81,749.6銷銷售售毛毛利利1,533.5461.1191.1881.3銷售毛利率39.2%54.58%44.14%33.50%SC2月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量88.630.615.242.8銷售單價41.524.022.260.9銷銷售售收收入入3,678.4734.4337.42,606.5銷售成本2,255.4333.5188.51,733.4銷銷售售毛毛利利1,422.9400.9149.0873.1銷售毛利率38.7%5

3、4.58%44.14%33.50%SC3月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量99.836.420.443.0銷售單價39.524.022.260.9銷銷售售收收入入3,945.2873.6452.92,618.7銷售成本2,391.2396.8253.01,741.5銷銷售售毛毛利利1,554.0476.8199.9877.2銷售毛利率39.4%54.58%44.14%33.50%SC4月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)

4、產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量107.138.624.344.2銷售單價38.824.022.260.9銷銷售售收收入入4,157.6926.4539.52,691.8銷售成本2,492.9401.4301.31,790.1銷銷售售毛毛利利1,664.8525.0238.1901.7銷售毛利率40.0%56.67%44.14%33.50%SC5月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量107.940.225.242.5銷售單價38.124.022.260.9銷銷售售收收入入4,112.5964

5、.8559.42,588.3銷售成本2,451.8418.1312.51,721.3銷銷售售毛毛利利1,660.7546.7247.0867.0銷售毛利率40.4%56.67%44.14%33.50%SC6月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量119.245.730.143.4銷售單價35.821.022.260.9銷銷售售收收入入4,271.0959.7668.22,643.1銷售成本2,606.2475.3373.21,757.7銷銷售售毛毛利利1,664.8484.4295.0885.4

6、銷售毛利率39.0%50.48%44.14%33.50%SC7月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量126.252.830.542.9銷售單價38.821.022.272.4銷銷售售收收入入4,891.91,108.8677.13,106.0銷售成本2,766.4549.1402.61,814.7銷銷售售毛毛利利2,125.5559.7274.51,291.3銷售毛利率43.5%50.48%40.54%41.57%SC8月60cb16d5e1721037c4c9e48f25b151aa.xls

7、項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量131.855.931.444.5銷售單價38.621.022.272.4銷銷售售收收入入5,092.81,173.9697.13,221.8銷售成本2,878.2581.4414.51,882.4銷銷售售毛毛利利2,214.6592.5282.61,339.5銷售毛利率43.5%50.48%40.54%41.57%SC9月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量122.250.328.343.6銷售單價39.621.022.272

8、.4銷銷售售收收入入4,841.21,056.3628.33,156.6銷售成本2,741.0523.1373.61,844.3銷銷售售毛毛利利2,100.2533.2254.71,312.4銷售毛利率43.4%50.48%40.54%41.57%SC10月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量123.149.429.644.1銷售單價39.721.022.272.4銷銷售售收收入入4,887.41,037.4657.13,192.8銷售成本2,725.5469.3390.71,865.4銷銷售

9、售毛毛利利2,161.9568.1266.41,327.4銷售毛利率44.2%54.76%40.54%41.57%SC11月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量115.145.327.342.5銷售單價39.920.022.272.4銷銷售售收收入入4,589.1906.0606.13,077.0銷售成本2,588.5430.4360.41,797.8銷銷售售毛毛利利2,000.6475.7245.71,279.3銷售毛利率43.6%52.50%40.54%41.57%SC12月60cb16d5e1721037c4c9e48f25b151aa.xls項項目目合合計計產(chǎn)產(chǎn)品品1 1產(chǎn)產(chǎn)品品2 2產(chǎn)產(chǎn)品品3 3銷售數(shù)量119.443.230.