还价核算表

填表日期：年9月24日填表人：编号：核算规则：还价利润核算时保留2位小数。还价成本核算时保留4位小数，小于1时保留5位小数，最终得出的单位采购成本保留2位小数。核算信息：核算单位：计算过程销售收入总额(¥)21.10*2556*6.75退税收入总额(¥)140*2556/(1+17%)*13%采购成本总额(¥)140*2556海洋运费总额(¥)1400*6.75国内包干费总额(¥)900公司定额费总额(¥)140*2556*3%垫款利息总额(¥)140*2556*6.50%/360*45银行手续费总额(¥)21.10*2556*0.25%*6.75保险费总额(¥)21.10*2556*110%*0.80%*6.75佣金总额(¥)利润总额(¥)364038.30+39760.00-357840.00-9450.00-900.00-10735.20-2907.45-910.10-3203.54销售利润率17852.01/364038.30核算单位：20'FCL7018V1&V434pcCIF900pcs1'20FCL22017852.014.90%货号客户还价(US$)计价单位贸易术语还价数量采购成本(¥)900.0010735.202907.45910.103203.54335932.0120'FCL计算结果364038.3039760.00357840.009450.00采购成本(¥)7012F2&F321.10pcCIF2556pcs1'20FCL140Flish-man-HillardLinkParkCO.电子钟表SHANGHAIKUWAIT还价利润核算货号客户还价(US$)计价单位贸易术语还价数量还价核算表2010明霞FD-FSH-HJ0924进口商货物名称装运港目的港计算过程销售收入总额(¥)34*900*6.75退税收入总额(¥)220*900/(1+17%)*13%采购成本总额(¥)220*900海洋运费总额(¥)1400*6.75国内包干费总额(¥)900公司定额费总额(¥)220*900*3%垫款利息总额(¥)220*900*6.50%/360*45银行手续费总额(¥)34*900*0.25%*6.75保险费总额(¥)34*900*110%*0.80%*6.75佣金总额(¥)利润总额(¥)206550.00+22000.00-198000.00-9450.00-900.00-5940.00-1608.75-516.38-1817.64销售利润率10317.23/206550.00核算单位：计算过程销售收入(¥)21.10*6.75海洋运费(¥)900/2556国内包干费(¥)1400/2556*6.75银行手续费(¥)21.10*0.25%*6.75保险费(¥)21.10*110%*0.80%*6.75佣金(¥)利润(¥)21.10*10%*6.75采购成本(¥)(142.4250-0.3521-3.6972-0.3561-1.2533-14.2425)/1-13%/(1+17%)+3%+6.5%/360*45核算单位：计算过程销售收入(¥)34*6.75海洋运费(¥)900/900国内包干费(¥)1400/900*6.75银行手续费(¥)34*0.25%*6.7510.50000.5738计价单位贸易术语PC计算结果229.50001.000014.2425132.179001'20FCL5.00%货号客户还价(US$)7012V1&V434pcCIFpc计算结果还价数量销售利润率142.42500.35213.69720.35611.25337012F2&F321.1pcCIF25561'20FCL4.90%10317.235.00%还价采购成本核算货号客户还价(US$)计价单位贸易术语还价数量销售利润率9450.00900.005940.001608.75516.381817.64计算结果206550.0022000.00198000.00保险费(¥)34*110%*0.80%*6.75佣金(¥)利润(¥)34*10%*6.75采购成本(¥)(229.5000-1.0000-10.5000-0.5738-2.0196-22.9500)/(1-13%/(1+17%)-3%-6.50%/360*45)22.9500226.222.0196