价格和利润运算-20160618

Sheet1成本运费RMB利润率利润RMB佣金汇率标价RMB标价US重量kg1公斤运费挂号费货代折扣提现手续点20$65.000.348.61773117250.156.469162.0625.050.780910.03黄色列是公式列，勿改动白色列可以按你需求改动27$38.100.337.23546234510.156124.1220.690.3871210.0315$38.100.330.37178265010.156101.2416.870.3871210.0313$38.100.329.22783603430.15697.4316.240.3871210.0320$38.100.333.23164918970.156110.7718.460.3871210.03M列提现手续点，即为使用某个收款卡全程需要的手续费，如P卡一般为3%，即为0.03。WF卡一般为2.5%，即为0.02510.5$38.100.327.79790276450.15692.6615.440.3871210.0311$38.100.328.08388941850.15693.6115.600.3871210.0311$38.100.328.08388941850.15693.6115.600.3871210.0311$38.100.328.08388941850.15693.6115.600.3871210.03需要复制粘贴多项数据到本表格时最好用“右键-选择性粘贴-数值”这样不会把你原来的格式粘过来防止出错E列利润率，即（利润/售价）Sheet2Sheet3