7-ELEVEN便利店购物小型零售店 7-11采购预算系统

1、7-11柳王店水果采购销售数据分析系统,水果采购盈利数据输入,采购时间:2010.4.8,采购员:,采购总额:元,422,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.5,苹果80#,21.35,0.9,20.45,64,3.00 ,3.13 ,4.07 ,4.00 ,83.2,81.8,1.8,梨子,34.21,1.4,32.81,48,1.40 ,1.46 ,1.90 ,2.00 ,62.4,65.62,2.5,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,2.50 ,0,2

2、.5,3.8,小番茄,13.11,0.45,12.66,45,3.43 ,3.55 ,4.62 ,4.80 ,58.5,60.768,4.5,芒果,27.36,1,26.36,110,4.02 ,4.17 ,5.42 ,5.50 ,143,144.98,17,荔枝,8.4,0.45,7.95,100,11.90 ,12.58 ,16.35 ,17.00 ,130,135.15,4.5,香梨,13.89,1,12.89,55,3.96 ,4.27 ,5.55 ,6.00 ,71.5,77.34,桂圆,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,葡萄,1,0,1,0,0

3、.00 ,0.00 ,0.00 ,8.00 ,0,8,西瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,5.00 ,0,5,合计:,122.32,5.2,117.12,422,548.6,587.158,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,422.00 ,548.60 ,126.60 ,30.00%,0,0.00 ,0,0,0,0,0,合计:(元),422.00 ,本次采购盈利,126.60 ,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.9,采购员:林易,采购总额:元

4、,94,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.50 ,苹果80#,15.45,0.64,14.81,48,3.11 ,3.24 ,4.21 ,4.50 ,62.4,66.645,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,2.00 ,0,2,2.00 ,香蕉,24.66,0.45,24.21,46,1.87 ,1.90 ,2.47 ,2.50 ,59.8,60.525,3.80 ,小番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,4.80 ,0,4

5、.8,4.50 ,芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,5.50 ,0,5.5,17.00 ,荔枝,1,0,1,0,0.00 ,0.00 ,0.00 ,17.00 ,0,17,4.50 ,香梨,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,0.00 ,桂圆,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,0.00 ,葡萄,1,0,1,0,0.00 ,0.00 ,0.00 ,8.00 ,0,8,0.00 ,西瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,5.00 ,0,5,合计:,48.11,1.09,47.02,9

6、4,122.2,181.47,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,94.00 ,122.20 ,28.20 ,30.00%,0,0.00 ,0,0,0,0,0,合计:(元),94.00 ,本次采购盈利,28.20 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.10,采购员:林易,采购总额:元,153,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.00 ,苹果7

7、0#,24.52,1.1,23.42,64,2.61 ,2.73 ,3.55 ,3.50 ,83.2,81.97,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,2.00 ,0,2,2.00 ,香蕉,25.64,0.9,24.74,46,1.79 ,1.86 ,2.42 ,2.50 ,59.8,61.85,4.00 ,小番茄,11.9,0.45,11.45,43,3.61 ,3.76 ,4.88 ,4.50 ,55.9,51.525,4.50 ,芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,5.50 ,0,5.5,17.00 ,荔枝,1,0,1,0,0.00

8、,0.00 ,0.00 ,17.00 ,0,17,4.50 ,香梨,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,0.00 ,桂圆,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,0.00 ,葡萄,1,0,1,0,0.00 ,0.00 ,0.00 ,8.00 ,0,8,0.00 ,西瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,5.00 ,0,5,合计:,69.06,2.45,66.61,153,198.9,244.845,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,

9、房租(天),水电,其他费用,153.00 ,198.90 ,45.90 ,30.00%,0,0.00 ,0,0,0,0,0,合计:(元),153.00 ,本次采购盈利,45.90 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.12,采购员:林易,采购总额:元,381.5,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.00 ,苹果70#,24.5,1.1,23.4,63,2.57 ,2.69 ,3.50 ,3.50 ,81.9,81.9,1.80 ,梨子,1,0,

10、1,0,0.00 ,0.00 ,0.00 ,2.00 ,0,0,2.50 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,2.50 ,0,0,4.00 ,小番茄,14.3,0.64,13.66,45,3.15 ,3.29 ,4.50 ,4.50 ,61.47,61.47,5.50 ,小芒果,14.7,0.45,14.25,78,5.31 ,5.47 ,6.00 ,6.00 ,85.5,85.5,4.50 ,大芒果,26.37,0.64,25.73,106,4.02 ,4.12 ,5.50 ,5.50 ,141.515,141.515,2.00 ,柑子,44.99,1.76,43.2

11、3,67.5,1.50 ,1.56 ,2.00 ,2.00 ,86.46,86.46,3.50 ,黄香瓜,6.6,0.1,6.5,22,3.33 ,3.38 ,4.50 ,4.50 ,29.25,29.25,0.00 ,葡萄,1,0,1,0,0.00 ,0.00 ,0.00 ,8.00 ,0,0,0.00 ,西瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,5.00 ,0,0,合计:,135.46,4.69,130.77,381.5,486.095,486.095,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天)

12、,水电,其他费用,381.50 ,486.10 ,104.60 ,27.42%,0,0.00 ,0,0,0,0,0,合计:(元),381.50 ,本次采购盈利,104.60 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.14,采购员:林易,采购总额:元,81,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.50 ,苹果75#,19.91,1,18.91,59,2.96 ,3.12 ,3.50 ,3.50 ,66.185,66.185,1.80 ,梨子,19.19,

13、0.45,18.74,22,1.15 ,1.17 ,1.50 ,1.50 ,28.11,28.11,2.50 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,2.50 ,0,2.5,4.00 ,小番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,4.50 ,0,4.5,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,5.50 ,0,5.5,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,2.00 ,0,2,3.50 ,黄香瓜,1,0,1,

14、0,0.00 ,0.00 ,0.00 ,4.50 ,0,4.5,0.00 ,葡萄,1,0,1,0,0.00 ,0.00 ,0.00 ,8.00 ,0,8,0.00 ,西瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,5.00 ,0,0,合计:,47.1,1.45,45.65,81,94.295,127.295,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,81.00 ,94.30 ,13.30 ,16.41%,0,0.00 ,0,0,0,0,0,合计:(元),81.00 ,本次采购盈利,13.

15、30 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.15,采购员:林易,采购总额:元,52,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,实际销售,3.50 ,苹果75#,1,0,1,0,0.00 ,0.00 ,0.00 ,3.50 ,0,3.5,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,1.50 ,0,1.5,2.50 ,香蕉,27.5,0.9,26.6,52,1.89 ,1.95 ,2.54 ,2.50 ,67.6,66.5,4.00 ,小番茄

16、,1,0,1,0,0.00 ,0.00 ,0.00 ,4.50 ,0,4.5,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,6.00 ,0,6,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,5.50 ,0,5.5,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,2.00 ,0,2,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,4.50 ,0,4.5,0.00 ,葡萄,1,0,1,0,0.00 ,0.00 ,0.00 ,8.00 ,0,8,0.00 ,西瓜,1,0,1,0,0.00 ,0.00 ,

17、0.00 ,5.00 ,0,0,合计:,36.5,0.9,35.6,52,67.6,102,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,52.00 ,67.60 ,15.60 ,30.00%,0,0.00 ,0,0,0,0,0,合计:(元),52.00 ,本次采购盈利,15.60 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.17,采购员:林易,采购总额:元,516,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤

18、,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,24.42,0.9,23.52,64,2.62 ,2.72 ,3.00 ,3.00 ,70.56,6.56,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.50 ,香蕉,45.19,0.51,44.68,110,2.43 ,2.46 ,2.50 ,2.50 ,111.7,1.7,3.50 ,黄番茄,14.13,0.64,13.49,45,3.18 ,3.34 ,3.50 ,3.50 ,47.215,2.215,6.00 ,小芒果,14.3,0.64,13.66,80,5.59 ,5.86

19、 ,6.00 ,6.00 ,81.96,1.96,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.00 ,黄香瓜,10.44,0.45,9.99,39,3.74 ,3.90 ,4.00 ,4.00 ,39.96,0.96,4.50 ,小黄瓜,7.33,0.45,6.88,28,3.82 ,4.07 ,4.50 ,4.50 ,30.96,2.96,9.00 ,油桃,18.24,0.9,17.34,150,8.22 ,8.65 ,9.00 ,9.00 ,156.

20、06,6.06,合计:,137.05,4.49,132.56,516,538.415,22.415,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,516.00 ,538.42 ,22.42 ,4.34%,0,0.00 ,0,0,0,0,0,合计:(元),516.00 ,本次采购盈利,22.42 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.18,采购员:林易,采购总额:元,64,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单

21、价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,24.14,0.9,23.24,64,2.65 ,2.75 ,3.50 ,3.50 ,81.34,17.34,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.50 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.50 ,大芒果,1,0,1,0,0.00 ,0.0

22、0 ,0.00 ,0.00 ,0,0,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,33.14,0.9,32.24,64,81.34,17.34,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电

23、,其他费用,64.00 ,81.34 ,17.34 ,27.09%,0,0.00 ,0,0,0,0,0,合计:(元),64.00 ,本次采购盈利,17.34 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.19,采购员:林易,采购总额:元,22,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,1.50 ,梨子,18.63,0.45,18.18,22,1.18 ,1.21 ,1.5

24、0 ,1.50 ,27.27,5.27,2.50 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,

25、小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,27.63,0.45,27.18,22,27.27,5.27,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,22.00 ,27.27 ,5.27 ,23.95%,0,0.00 ,0,0,0,0,0,合计:(元),22.00 ,本次采购盈利,5.27 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.2

26、0,采购员:林易,采购总额:元,160,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,24.63,1,23.63,64,2.60 ,2.71 ,3.50 ,3.50 ,82.705,18.705,1.80 ,菠萝,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.00 ,香蕉,22.52,0,22.52,54,2.40 ,2.40 ,3.00 ,3.00 ,67.56,13.56,4.00 ,红番茄,14.14,0.5,13.64,42,2.97 ,

27、3.08 ,3.50 ,3.50 ,47.74,5.74,5.50 ,甘蔗,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0

28、,0,合计:,68.29,1.5,66.79,160,198.005,38.005,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,160.00 ,198.01 ,38.01 ,23.75%,0,0.00 ,0,0,0,0,0,合计:(元),160.00 ,本次采购盈利,38.01 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.21,采购员:林易,采购总额:元,359,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,

29、系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,20.24,0.9,19.34,50,2.47 ,2.59 ,3.50 ,3.50 ,67.69,17.69,1.80 ,梨子,18.16,1.1,17.06,45,2.48 ,2.64 ,3.00 ,3.00 ,51.18,6.18,2.50 ,香蕉,18.11,0,18.11,43,2.37 ,2.37 ,3.00 ,3.00 ,54.33,11.33,4.00 ,黄番茄,13.69,0.5,13.19,47,3.43 ,3.56 ,4.00 ,4.00 ,52.76,5.76,5.50 ,小芒果,16.57,0.5,16.07,

30、92,5.55 ,5.72 ,7.00 ,7.00 ,112.49,20.49,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,柑子,33.31,1.1,32.21,82,2.46 ,2.55 ,3.00 ,3.00 ,96.63,14.63,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,124.08,4.

31、1,119.98,359,435.08,76.08,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,359.00 ,435.08 ,76.08 ,21.19%,0,0.00 ,0,0,0,0,0,合计:(元),359.00 ,本次采购盈利,76.08 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.22,采购员:林易,采购总额:元,165,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差

32、额,3.50 ,苹果70#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.00 ,香蕉,75.37,0.45,74.92,165,2.19 ,2.20 ,3.00 ,3.00 ,224.76,59.76,4.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,

33、2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,84.37,0.45,83.92,165,224.76,59.76,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,165.00 ,22

34、4.76 ,59.76 ,36.22%,0,0.00 ,3,0,0,0,0,合计:(元),168.00 ,本次采购盈利,56.76 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.23,采购员:林易,采购总额:元,175,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,21.46,0.9,20.56,60,2.80 ,2.92 ,3.50 ,3.50 ,71.96,11.96,3.50 ,梨子,17.11,0.45,16.66,45,2.63 ,2.

35、70 ,4.00 ,4.00 ,66.64,21.64,3.00 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.00 ,黄番茄,11.46,0.45,11.01,40,3.49 ,3.63 ,4.00 ,4.00 ,44.04,4.04,3.50 ,红番茄,13.15,0.45,12.7,30,2.28 ,2.36 ,3.50 ,3.50 ,44.45,14.45,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,

36、黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,69.18,2.25,66.93,175,227.09,52.09,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,175.00 ,227.09 ,52.09 ,29.77%,0,12.16 ,0,0,0,0,0,合计:(元),187.1

37、6 ,本次采购盈利,39.93 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.24,采购员:林易,采购总额:元,216,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,24.16,1,23.16,70,2.90 ,3.02 ,3.50 ,3.50 ,81.06,11.06,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.00 ,香蕉,48.23,0,48.23,107,2.22 ,2.22 ,3.00

38、,3.00 ,144.69,37.69,4.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,5.50 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.50 ,黄香瓜,12.98,0.55,12.43,39,3.00 ,3.14 ,3.50 ,3.50 ,43.505,4.505,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,

39、0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,92.37,1.55,90.82,216,269.255,53.255,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,216.00 ,269.26 ,53.26 ,24.66%,0,1.72 ,2,0,0,0,0,合计:(元),219.72 ,本次采购盈利,49.54 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.25,采购员:林易,采购总额:

40、元,228,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,3.50 ,苹果70#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,1.80 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,2.50 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,4.00 ,黄番茄,13.64,0.45,13.19,48,3.52 ,3.64 ,4.00 ,4.00 ,52.76,4.76,7.00 ,小芒果,16.91,0.45

41、,16.46,110,6.51 ,6.68 ,7.00 ,7.00 ,115.22,5.22,3.50 ,西瓜,19.96,0,19.96,53,2.66 ,2.66 ,4.00 ,4.00 ,79.84,26.84,3.00 ,甘蔗,10,0,10,17,1.70 ,1.70 ,3.00 ,3.00 ,30,13,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,

42、66.51,0.9,65.61,228,277.82,49.82,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,228.00 ,277.82 ,49.82 ,21.85%,0,0.00 ,4,0,0,0,0,合计:(元),232.00 ,本次采购盈利,45.82 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.26,采购员:林易,采购总额:元,439,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格

43、,定价所得,差额,4.50 ,苹果80#,20.04,0.9,19.14,73,3.64 ,3.81 ,4.00 ,4.00 ,76.56,3.56,3.50 ,梨子,16.26,0.45,15.81,45,2.77 ,2.85 ,3.50 ,3.50 ,55.335,10.335,3.00 ,香蕉,22.66,0,22.66,55,2.43 ,2.43 ,3.00 ,3.00 ,67.98,12.98,3.00 ,甘蔗,20,0,20,36,1.80 ,1.80 ,3.00 ,3.00 ,60,24,5.00 ,进口香蕉,29.19,0,29.19,100,3.43 ,3.43 ,5.00

44、,5.00 ,145.95,45.95,4.50 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,3.00 ,柑子,61.74,5.5,56.24,130,2.11 ,2.31 ,3.00 ,3.00 ,168.72,38.72,3.50 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,173.89,6.85,167.04,439,574.

45、545,135.545,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,439.00 ,574.55 ,135.55 ,30.88%,0,0.00 ,5,0,0,0,0,合计:(元),444.00 ,本次采购盈利,130.55 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.27,采购员:林易,采购总额:元,0,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,0.00 ,苹果71#,

46、1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0

47、.00 ,0,0,0.00 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,10,0,10,0,0,0,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,0.00 ,0.00 ,0.00 ,#DIV/0!,0,0.00 ,0,0,0,0,0,合计:(元),0.00 ,本次采购盈利,0.

48、00 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.28,采购员:林易,采购总额:元,0,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,0.00 ,苹果71#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0

49、.00 ,0.00 ,0,0,0.00 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,10,0,10

50、,0,0,0,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,0.00 ,0.00 ,0.00 ,#DIV/0!,0,0.00 ,0,0,0,0,0,合计:(元),0.00 ,本次采购盈利,0.00 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.29,采购员:林易,采购总额:元,0,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,0.00 ,苹果72#,1,0,1,0,0.00 ,

51、0.00 ,0.00 ,0.00 ,0,0,0.00 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00

52、,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,10,0,10,0,0,0,盈利分析,采购成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,0.00 ,0.00 ,0.00 ,#DIV/0!,0,0.00 ,0,0,0,0,0,合计:(元),0.00 ,本次采购盈利,0.00 ,表示上次采购,表示本

53、次采购,水果采购盈利数据输入,采购时间:2010.4.30,采购员:林易,采购总额:元,0,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,0.00 ,苹果71#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,梨子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,香蕉,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄番茄,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0

54、,0.00 ,小芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,大芒果,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,柑子,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,黄香瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,小黄瓜,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,油桃,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,合计:,10,0,10,0,0,0,盈利分析,采购

55、成本合算,项目,进货价格,销售价格,销售价差,利润率,损耗(斤),损耗(元),运输费用,人工费用,房租(天),水电,其他费用,0.00 ,0.00 ,0.00 ,#DIV/0!,0,0.00 ,0,0,0,0,0,合计:(元),0.00 ,本次采购盈利,0.00 ,表示上次采购,表示本次采购,水果采购盈利数据输入,采购时间:2010.4.31,采购员:林易,采购总额:元,0,老顾客价格,商品名称,重量(斤),皮重(斤),净重(斤),含皮进价(元),折合单价/斤,去皮单价(元)斤,系统定价,零售价格,定价所得,差额,0.00 ,苹果72#,1,0,1,0,0.00 ,0.00 ,0.00 ,0.00 ,0,0,0.00 ,梨子,1,0,1,0,0.00 ,0