simtrade半自动计算表改良版
Simtrade进出口预算表计算器
6
4
整箱装
20'集装箱价格 40'集装箱价格
16,433.51
17,588.70
采购单价 33.00
40' 650 26 32 退税率 5% USD汇率 6.2107
最小运费 15,051.76
工厂报价
项目
预算金额(RMB)
单位生产成本
25.60
生产总成本
256,000.00
预估报价
33.00
内合同金额
330,000.00
增值税
47,948.72
消费税
0.00
公司综合费用
16,500.00
利润
9,551.28
出口预算表
项目
预算金额(RMB)
合同金额
380,001.13
采购成本
330,000.00
FOB总价
361,270.98
内陆运费
5,773.20
报检费
200.00
报关费
200.00
海运费
15,051.76
保险费
3,678.40
核销费
10.00
银行费用
694.00
其他费用
19,200.06
退税收入
14,102.56
利润
19,296.28
进口预算表
项目
预算金额(JPY)合同Βιβλιοθήκη 额4,798,600.00
CIF总价
4,798,600.00
内陆运费
72,903.14
报检费
2,525.57
报关费
2,525.57
16 20
其他信息
进口方货币汇率 信用证修改次数 检验及证书数量
simtrade进出口预算[1]
![simtrade进出口预算[1]](https://img.taocdn.com/s3/m/86aac1e8ad02de80d5d8409d.png)
消费税是价内税，增值税是价外税
simtrade进出口预算[1]
（七）出口商的利润核算
利润＝合同金额-采购成本-内陆运费-报检费-报关费 -核销费-其他费用-公司综合费用-银行费用-海 运费-保险费+退税收入
两者相比较，取体积运费 总运费 12.384×6.2721 = CNY77.674
simtrade进出口预算[1]
（三）保险费的计算
出口交易中，在CIF成交时，出口商需要到"淘金网"中"保险 费"页查询保险费率，用以核算保险费。如用CFR或FOB方式，此 栏填"0"。
公式：保险费＝ CIF货价 ×（1＋保险加成率）× 保险费率 在进出口贸易中，根据有关的国际惯例，保险加成率通常为 10%，出口商也可按进口商要求与保险公司约定不同的保险加成率 例：EUR 60 per bottle CIF Oslo 进口商要求按成交价格的 110%投保协会货物保险条款(A)(保险费率0.8%)和战争险(保险费率 0.08%)， 解：保险金额＝60×1000×110%＝EUR 66,000
simtrade进出口预算[1]
(六)出口商退税收入
商品出口退税收入＝应退增值税 + 应退消费税 = 采购成本/(1+增值税率)×出口退税率 + 采购成本×消费税税率 = 350/(1+17%)×17% + 350×30% = 50.855+105= 155.855 一共1000瓶，共退税CNY155.855×1000=CNY 15585.5
simtrade(5.0进出口预算表)
公司综合费用
0
0
8
增值税
23.24786325
5
业务费用（从价）
业务费用（从量）
31.24786325
31.24786325
单位税后生产成本（从价）
单位税后生产成本（从量）
单位生产成本（取最大值）
103.8478632
103.8478632
103.8478632
（内）合同金额（真实）
工厂产成本
960000 工厂利润 336912.8205
进口商出售价 363.873202
第二步：确定工厂售价
商品信息（填写）
出口商采购价
件数（每1包装）
（内）合同金额（算税用）
4
160
6
160
工厂生产成本
算真实单位成本用（勿改）
真实销售数量
2
72.6
1
6000
增值税率
消费税率
消费税单位税额度
17.00%
0.00%
0.00%
税率（可得）
从价商品消费税
从量商品消费税
定价估算
第一步（估算工厂售价-与出口商）
进口商出售（USD/销售）
1USD=CNY
1
43.01
8.4602
3 大概
进口商出售（CNY/销售） 363.873202
利润空间(CNY.销售单位) 291.273202 除以三 97.09106733 工厂出售价 169.6910673
出口商出售价 266.7821347
星
623087.1795 出口商利润估计
424217.2979
进口商利润估计 488460.0309
使用流程 1 2 3
探析SIMTRADE操作中进出口预算表的填写方法
Forum学术论坛 2015年8月145探析SIMTRADE操作中进出口预算表的填写方法青岛理工大学琴岛学院 孙智贤摘 要：在SIMTRADE软件操作中，进出口预算表的填制非常关键，事关贸易的盈亏和最终得分。
在填写进出口预算表时有两种不同方法，这两种方法有相同之处，也存在明显的不同。
两种方法各有利弊，均可以使用，但是第二种方法更加符合实际。
要求学生在模拟操作和实际业务中掌握并且灵活选取填制进出口预算表的方法。
关键词：SIMTRADE 国际贸易实务模拟操作 进出口预算表中图分类号：F740.4 文献标识码：A 文章编号：2096-0298(2015)08(a)-145-03SIMTRADE 软件是一款国际贸易实务教学软件，它模拟了一个近乎真实的外贸环境，参与操作的人员会共同完成建立业务关系、交易磋商及合同订立、信用证业务、租船订舱、办理保险、报检报关和制单结汇等外贸业务。
其中，在进出口商签订合同之前，需要由进出口商分别添加和填写进出口预算表，而预算表是SIMTRADE 整个操作流程中，唯一一个不能经过系统检查，而只能在整笔贸易完成后才能知道正确与否的单据，所以它填制得好坏很大程度上影响着系统最后的得分。
并且，最主要的是，预算表的填写事关贸易的盈亏。
如果没有认真核算出价格，就可能会导致在贸易完成后才发现亏损，不仅财务状况那一项的分数很低，而且在实际业务中这是不允许的。
预算表的填制有两种方法，本文会具体分析在使用CIF 贸易术语和信用证结算方式下进出口预算表填制的两种方法。
1 方法1：先商议价格再核算利润和利润率1.1 出口预算表填写的方法首先，确定出口商品的合同总金额。
出口方先根据工厂的报价，估算出商品的价格，出口方先报价后，进口方再根据国内市场上的销货价格，进行讨价还价。
确定了一个双方都能接受的价格后，核算出合同总金额。
其次，计算出口商品的采购成本。
出口商品的采购成本即是出口商跟工厂签订的合同总金额减去出口商品的退税收入。
simtrade计算
基本计算
(一)毛重、净重、体积计算包装数量总体积cbm毛重kgs
25014.513500进口数量
一、合同金额（外币840001000
二、CIF总价（外币84464.555开证手续费率
三、内陆费用（外币141.548570.0015
四、报检费（外币32.539902综合费率
五、报关费（外币32.5399020.05
六、关税（外币0
七、增值税（外币14358.974
八、消费税（外币从价从量消费税
00
九、保险费（外币464.55505
十、银行费用（外币开证手续费修改手续费付款手续费修改次数
1260109.2
L/C D/A D/P T/T L/C费用（外D/A费用（外
235.2848467.2235.284
十一、其他费用（外币4200
十二、利润（外币L/C D/A D/P T/T
41764.64241915.8441915.8441932.64
(元256698.02257627.3257627.3257730.6
进口优惠税率
消费税从价消费税从量增值税汇率
0000.17 6.1463单位换算毛重kgs体积 cbm
4540.058
D/A费率D/P费率T/T费率
修改费（元付款手续费率
2000.00130.0010.0010.0008
D/P费用（外T/T费用（外币
8467.2。
SimTrade出口预算表的填写
SimTrade出口预算表的填写5 x 1000=3500KGSCalculation of volume:Packing box number = 1000 / 6 = 166.6, 167 round boxTotal volume = 167 * 0.08052 = 13.447CBMExample 2: food products 01001, the sales unit is CARTON (box), packaging units are CARTON (case), gross weight of 11.2KGS per carton, net weight of 10.2KGS per box, 0.014739CBM per box volume. If the quantity of the transaction is 2000CARTON, the gross, net weight and volume shall be calculated separatelySolution: gross weight = 2000 * 11.2 = 22400KGSNet weight = 2000 * 10.2 = 20400KGSVolume = 2000 * 0.014739 = 29.478CBMNote: because the units of this kind of product are the same as those of the packaging units, the contents of unit conversions may not be considered when calculating.(two) quotation quantity accounting;In the international transport of goods, often using the20'container and 40' container, the effective volume of 20'container is 25CBM, weight limit 17.5TNE, the effective volume of 40' container is 55CBM, weight limit 26TNE, 1TNE =1000KGS. The exporter proposes to calculate the quoted quantity in accordance with the maximum number of packages the container can accommodate in order to save sea freight.In the "gold rush net" product display in view of product details, according to the volume of products, packaging units, sales units, units converted to calculate the number of quotations.Example 1: 08003 (children Scooter), commodity sales unit UNIT (cars), packaging unit CARTON (box), unit conversion for 6 per box, each box volume is 0.0576CBM, the gross weight is 21KGS, try to calculate respectively the goods with maximum packing number and the corresponding number of quotations, 20'40' of the container transportation.Solution: per 20'containerBy volume the packing number is 25 / 0.0576 = 434.028By weight the packing number is 17.5 / 21 x 1000 = 833.33Whichever is smaller, so the maximum packing number rounding 434 boxes, the corresponding sales volume = 434 * 6 = 2604Per 40'containerBy volume the packing number is 55 / 0.0576 = 954.861By weight the packing number is 26 / 21 x 1000 = 1238.095Whichever is smaller, so the maximum packing number rounding 954 boxes, the corresponding sales volume = 954 * 6 = 5724Example 2: 01005 commodities (canned sweet corn), sales units and packaging units are CARTON (box), each box volume is 0.025736CBM, the gross weight is 20.196KGS, try to calculate respectively the maximumnumber of goods by 20', the number of cases and offer the export container transportation 40'.Solution: per 20'container:By volume packing number = 25 / 0.025736 = 971.402By weight packing number = 17.5 / 20.196 x 1000 = 866.51Whichever is smaller, so the maximum number of 866 rounded box packingAs the selling unit is the same as the packing unit, the quoted quantity of the goods is 866 cases.Per 40'container:By volume packing number = 55 / 0.025736 = 2137.084By weight packing number = 26 / 20.196 x 1000 = 1287.35Whichever is smaller, so the maximum number of 1287 rounded box packingAs the selling unit is the same as the packing unit, the quoted quantity of the goods is 1287 cases.[].I. contract amountThat is, the amount of the contract agreed upon by both parties, note that the cost currency shall be converted.For example: commodity 01005 "canned sweet corn", the contract value of USD16000, found that the current U.S. dollar (USD) exchange rate of 6.8261, try converting into local currency.Solution: contract amount = 16000 * 6.8261 = RMB 109217.6[].Two, procurement costsThrough mail and factory liaison, ask about the purchase price for cost accounting.For example: goods 01005 "sweet corn canned", the factory quoted price for each RMB80, purchase 971 only cost?Solution: procurement cost = 80 * 971 = RMB 77680[].Three, FOB total priceThat is, the total amount of FOB value of the goods ordered by both parties during the signing of the contract. The exporter should be considered in the export price, first calculate the purchasing cost, then plus expenses (which can be roughly estimated), and give a certain profit space, on the basis of the price, if not FOB price, to convert.Converted from CFR to FOB: FOB = CFR - ocean freightConverted from CIF to FOB: FOB = CIF - Ocean Freight - PremiumFor ocean freight and insurance, please refer to the following instructions.Note: the amount must be converted into the cost currency. The exchange rate can be found on the bank page of the gold rush net.Suppose, for example, that the total value of the contract FOB is USD26500, and in the "bank" page, the current dollar (USD) rate is found to be 6.8261.The amount to be filled in this column is: 26500 x 6.8261 =180891.65[].Four inland freightIn the "gold rush net" other costs, the inland freight rate wasRMB60/ cubic meters (Note: cubic meter or CBM).Available: inland freight = total volume of exported goods * 60The total volume algorithm, please refer to the basic calculations".[].Five. Inspection feeIn the "gold rush net" other costs, the inspection fee was found RMB200/ times.Availability: inspection fee = RMB200[].Six, customs feesIn the "gold rush net" other fees, check customs fees for RMB200/ times.Available: Customs fee = RMB200[].Seven, shipping chargesIn export transactions, exporters use CFR and CIF trade terms, and exporters have to pay for shipping charges. In the form of FOB, fill in the column "0"".In the export trade, the selection of container type and the method of goods packing are very important for exporters to reduce freight expenses. Size and weight of container,The loading, discharging and stack of the goods in the container are particular and need to be explored in practice.(I) basis of freight calculation;Freight unit (Freight Unit) means the basic unit used by a shipping company to calculate freight charges. Because of the wide variety of goods, the packing situation is different, the method of shipment is different, the calculation of freight standards vary.A: FCL containers in the container freight unit in the SimTrade20'container and 40' container two. The effective volume of the20'container is 25CBM, the weight limit is 17.5TNE, and the effective volume of the 40' container is 55CBM, and the weight limit is 26TNE, wherein 1TNE = 1000KGS;LCL: B by the ship to charge a higher price for the quasi tariff, often note on M/W or R/T, said the company will ship the goods weight or volume of two tons of tons of freight to choose the higher calculation.In LCL, the unit of freight is calculated as:1. weight ton (Weight Ton): one ton (1 TNE=1000KGM) for one tonof freight per gross gross weight of the goods;2. volume ton (Measurement Ton): according to total gross volume of goods, to a cubic meter (1 Cubic Meter), referred to as 1MTQ or 1CBM or 1CUM, also known as a product ton, as a freight ton.In the calculation of shipping time, the exporter must firstcalculate the volume of the goods according to the quantity quoted, and then to the "gold rush net" of the "freight inquiry" page, to find the goods should be approved at the port of destination tariff. If the quantity is just enough installed FCL (20'container or 40' container), directly take the freight for basic freight; if not installed FCL, with the total volume of products (or the total weight, take more freight LCL) * price to calculate shipping costs.(two) freight classification calculation method;A: Freight FCL FCL is divided into three parts, the total freightfee and = three.1. basic freightThe basic unit of basic freight freight FCL number = x2. port surchargePort surcharge port surcharge * FCL = unit number3. fuel surchargeFuel surcharge = unit fuel surcharge * FCL numberB LCL: LCL freight only basic freight, divided by volume and weight calculated in two ways1. by volume, X1 = unit, basic freight (MTQ) * total volume2. by weight, X2 = unit, basic freight (TNE) * gross weightTake the larger one in X1 and X2For example: 08003 (children Scooter) goods to be exported to Canada, Toronto port port. Try to calculate the number of transactions for 1000 and 2604 shipping charges respectively.Solution:The first step: calculate the volume and weight of the productIn the "Pan gold net" product display, we find that the volume ofthe commodity 08003 is 0.0576CBM per carton, gross weight of 21KGS per carton, 6 cars per carton. According to the product data, calculate the volume of the product first.The quoted quantity is 1000The total number of packing box = 1000 / 6 = 166.6, 167 round box, total volume = 167 x 0.0576 = 9.6CBMTotal gross weight = 1000 / 6 x 21 = 3500KGS = 3.5TNEThe quoted quantity is 2604The total number of packing box = 2604 / 6 = 434, total volume = 434 x 0.0576 = 24.998CBMTotal gross weight = 2604 / 6 x 21 = 9114KGS = 9.114TNEThe second step: check the freight rateIn the "gold rush net", "freight inquiry", the shipping to Toronto, Canada, the basic freight is: 20'per container USD3290, 40' containers per USD4410, LCL, per volume ton (MTQ) USD151, per ton (TNE) USD216;Port surcharge: USD132 per 20'container, USD176 per 40' container;Fuel surcharge is USD160 per 20'container, USD215 per 40' container;In addition, in the "gold rush net" in the "bank" page, can be found, the U. S. dollar exchange rate of 6.8261.The first step according to the calculated results, according to specifications of container (in freight calculated on the basis of that, the effective volume of 20'container is 25CBM, weight limit 17.5TNE, the effective volume of 40' container is 55CBM, weight limit 26TNE, 1TNE = 1000KGS), 1000 units of freight will be used for shipping LCL, 2604 vehicles fees should adopt the 20'container.1 the quantity quoted is 1000, and the basic freight by volume = 9.6 * 151 = 1449.6 (US dollars)By weight, the basic freight = 3.5 x 216 = 756 (US dollars)In comparison, the volume of freight is larger, shipping companies charge larger, the basic freight is USD1449.6Total freight = 1449.6 * 6.8261 = 9895.11 (RMB)2 the quoted quantity is 2604 pieces, because the volume and the weight are not more than one 20'container's volume and the limit weight, therefore installs a 20' container to be possibleTotal freight = 1 * (3290+132+160) * 6.8261= 3582 * 6.8261= 24451.09 (RMB)[].Eight, insurance premiumIn the export transaction, under the condition of "CIF", exporters need to inquire the premium rate on the "premium" page in the "gold rushnet", so as to calculate the insurance premium. In the form of "CFR" or "FOB", fill in "0" in this column". The formula is as follows: Insurance = insurance amount * insurance rateInsurance amount = CIF price * (1 + insurance plus rate)In the import and export trade, according to the relevant international practice, the insurance premium rate is usually 10%. The exporter may also agree with the insurance company on different insurance premium rates according to the importer's requirements.For example: CIF 03001 of the total price of the goods is USD8937.6, according to the requirements of the importer transaction price 110% covering institute cargo clauses (A) (insurance rate 0.8%) and war risk (insurance rate 0.08%), calculate the exporters due to the insurance cost?Explanation: the amount of insurance = 8937.6 * 110% = 9831.36 (US dollars)Insurance premium = 9831.36 x (0.8%0.08%) = 86.52 ($)The exchange rate for us dollars is 6.8261, RMB = 86.52 * 6.8261 = 590.59Note: 1.Since all risks (or A risks) cover all the additional coverage, the insurance company will not charge any additional coverage for all risks except for all risks (or A). In calculating the insured amount, the insurance premium for the general additional insurance may not be included.2. basic insurance can only choose one of them, special additional risks based on basic insurance on the insurance coverage, if at the same time, special additional risks of war risks and strike risk premium is calculated according to the only one, not cumulative (simultaneously against war risks and strike risk, the rate is 0.80 per thousand, instead of 1.60 per thousand).[].Nine, verification feesIn the "gold rush net" other costs, check out the write off fee of RMB10/ times.Availability: write off fee = RMB 10[].Ten, bank chargesDifferent methods of payment, bank fees are different (in which T/T export banks do not charge fees), usually for the total amount of X bank charges, in the "gold network" and "other expenses" can be found in the related rate.For example: when the total amount of the contract is USD28846.4,the bank charges are calculated in L/C, D/P and D/A respectively (modify a credit once the L/C method is assumed)Solution:The first step: query ratesRichard L/C in the "gold rush" "other expenses" page notification fees RMB200/ times, RMB100/ times, negotiating fees amendment rate of0.13% (minimum 200 yuan), D/A rate of 0.1% (the lowest 100 yuan, highest 2000 yuan), D/P rate of 0.1% (the lowest 100 yuan, highest 2000 yuan).The second step: inquires the exchange rateOn the bank page, the exchange rate of the dollar is 6.8261.The third step: calculate bank chargesL/C bank charges = 28846.4 * 0.13% * 6.8261 + 200 + 100 = 255.98 + 300 = 555.98D/P bank charges = 28846.4 * 0.1% * 6.8261 = 196.91D/A bank charges = 28846.4 * 0.1% * 6.8261 = 196.91[].Eleven, other expensesThis column includes the cost of a company: comprehensive cost, certificate of inspection fees, postage and certificate of origin certificate of inspection fees for books, which fill in the declaration form the exporter exit, inspection certificateapplication, such as health certificates, plant quarantine certificate, a certificate fee of 200 yuan; the postage is in the form of T/T exporters send documents to the importer in charge, $28 each.The above fees can be found in the "other charges" page of the "gold rush net", and accumulated in this column according to the actual conditions of this contract.For example: when the total amount of the contract under T/T isUSD8846.4, please calculate the amount that should be filled in thiscolumn. (assuming that a health certificate, a certificate of origin and a shipping document were sent to the importer) in this contractSolution:The first step: query ratesIn the "gold rush net" of the "other costs" page, check the exporter company comprehensive rate of 5%, to prove that RMB200/ copies of the book price, postage USD28/ times.The second step: inquires the exchange rateOn the bank page, the exchange rate of the dollar is 6.8261.The third step: calculate other expensesOther charges = 8846.4 x 5% x 6.8261 + 200 + 200 + 28 * 6.8261= 3019.32 + 400 + 191.13= 3610.45 (RMB)[].Twelve, tax refund incomeIn the "gold rush net" in the "tax rate" page, enter the commodity customs code for inquiries (for example, enter the commodity 10001 customs code 33041000, found that the export tax rebate rate of 17%, consumption tax from the price of 30%). If a contract involves a number of goods, it must be calculated separately and accumulated.Available: commodity export tax refund income = = VAT should be refunded + refund of consumption tax = purchasing cost / (1+ VAT rate) * export rebate rate + purchasing cost * consumption tax rate [].Thirteen, profitsThe above income and expenditure together to calculate, you can calculate.The calculation formula is: Profit = contract value + tax refund income - purchasing cost - inland freight - inspection fee - customs declaration - Ocean Freight - Premium - write off fees - bank charges - other fees[].。
SimTrade外贸实训商品价格构成及报价实例探析
SimTrade外贸实训商品价格构成及报价实例探析作者：袁定喜来源：《经济研究导刊》2018年第36期摘要：SimTrade外贸实训平台由南京世格公司和对外经贸大学联合开发，对于学生巩固所学专业知识，增强实践操作能力，起到了积极作用，目前在全国高校中被广泛使用。
在模拟交易中，学生普遍对商品如何定价感到困惑。
从工厂如何向出口商报价、出口商又如何向进口商报价两个维度，对价格构成、报价公式推导、报价实例等进行探析，这对于学生掌握相关操作、适应今后工作要求将有所帮助。
关键词：SimTrade;价格构成;报价实例中图分类号：F714; ; ; ; 文献标志码：A; ; ; 文章编号：1673-291X（2018）36-0154-04SimTrade外贸实训中，商品的价格由成本、各项税费和预期利润三个部分组成。
不论是工厂将商品销售给出口商，还是出口商将商品销售给进口商，在定价过程中，商品价格都要包含这样三个部分。
因此，在报价之前，必须搞清楚成本、各项税费共有多少，利润率估计是多少（利润率由定价方自行确定，可多可少）。
一、工厂向出口商报价（一）内合同金额的构成SimTrade中，工厂与出口商所签订的合同为国内买卖合同，简称为内合同。
内合同金额指工厂与出口商签订国内买卖合同的总金额（总价），等于商品销售单价乘以销售数量。
根据商品价格构成分析可知：内合同金额=生产总成本+各项税费+预期利润1.生产成本。
工厂角色登录后可在“淘金网”“产品展示”中查询得到单件商品的生产成本，在此基础上乘以销售数量即为生产总成本。
2.各项税费。
SimTrade里，工厂在完成一笔业务的过程中，须缴纳和花费的费用包括三项：增值税、消费税与公司综合费用。
这三种费用的计算方法如下：（1）增值税。
进入“淘金网”“税率”页面，输入交易商品海关编码进行查询（例如输入商品01001的海关编码2003101100，查到增值税率为17%）。
若是一笔合同涉及到多种商品，则需要分别计算再进行累加。
出口预算表计算
出口预算表的填写在进出口贸易中，商品的价格是买卖双方磋商的焦点，有时也是成交的决定性因素。
正确掌握进出口商品价格构成，合理采用各种作价方法，选用有利的计价货币和贸易条件，准确核算成本、利润，具有十分重要的意义。
在SimTrade中，当出口商起草合同完毕，发送给对方时，必须先填写出口预算表，预估各项费用；交易完成后，实际发生的金额将列于右侧栏中，供学生核对自己计算得正确与否。
以下就出口预算表中各项费用的计算加以说明，便于学生填写时参考。
注意出口预算表填入的数字全部为本位币，且都保留两位小数。
如需换算，汇率请参考"B2B(淘金网)"中的"银行"页面，如没有该项费用发生，请填"0"。
请选择以下主题查看相关内容：基本计算一、合同金额二、采购成本三、FOB总价四、内陆运费五、报检费六、报关费七、海运费八、保险费九、银行费用十、其他费用十一、退税收入十二、利润基本计算(一)毛重、净重、体积计算首先到"B2B(淘金网)"的"产品展示"中记下产品每箱的重量、体积，其次查询产品的销售单位与包装单位是否相同。
在计算重量时，对销售单位与包装单位相同的产品(如食品类产品)，可直接用交易数量×每箱的毛(净)重；对销售单位与包装单位不同的产品(如玩具类、服装类产品)，须先根据单位换算计算出单件的毛(净)重，再根据交易数量计算总毛(净)重。
在计算体积时，对销售单位与包装单位相同的产品(如食品类产品)，可直接用交易数量×每箱的体积；对销售单位与包装单位不同的产品(如玩具类、服装类产品)，须先根据单位换算计算出包装箱数，再计算总体积。
(注意：包装箱数有小数点时，必须进位取整箱，如不满整箱亦按整箱计算毛净重。
)例1：玩具类产品08001项，销售单位是UNIT(辆)，包装单位是CARTON(箱)，单位换算显示是每箱装6辆，每箱毛重23KGS，每箱净重21KGS，每箱体积0.08052CBM。
Simtrade预算表修正版
口预算） 包装数量 23 总净重(KG) 253 总毛重(KG) 299 总体积(CBM) 0.17089
包装单位 汇率：人民币/美元 CARTON 6.339 包装单位换算 汇率：本币/美元 400 6.339 合同类型 结算类型 FOB T/T 规格型号（中文） 罐，每罐3060克
Haifa,Israel LCLTNE 110 US$32.89
保险金额 保险费 US$144,989.68 US$1,275.91
CIF总价 US$131,808.80
税额 增值税 消费税 增值税额 消费从价税率 消费从量税率 消费税额 US$24,722.41 0.30% 0 US$436.28
用 托收手续费 电汇手续费 银行费用 US$130.50 US$104.40 US$104.40
合同类型 FOB
合同金额 加成比率 US$130,500.00
保险费率 10% 0.88%
合同类型 FOB
CIF总价 合同金额 海运费 保险费 US$130,500.00 US$32.89 US$1,275.91 内陆运费 总价(RMB) 总价(USD) ¥60.00 ¥10.25 固定费用 报检费 监管条件 US$310.00
其他费用 ¥6,525.00
项目 合同金额 CIF总价
进口预算表 预算金额 预算金额（本币） US$130,500.00 130,500.00 US$131,808.80 131,808.80
内陆运费 报检费 报关费 关税 增值税 消费税 海运费 保险费 银行费用 其他费用
US$1.62 US$0.00 US$31.55 US$13,180.88 US$24,722.41 US$436.28 US$32.89 US$1,275.91 US$104.40 US$6,525.00
外贸报价自动计算表格
输入区：要求利润：10%汇率： 6.7520GP 采购含税价：6元/个增值税：13%FOB 价格;$0.96美元/个TT 采购数量：9842个CIF 价格;$1.12美元/个每箱件数：60个/箱CFR 价格：$1.11美元/个每箱体积：0.164CBM退税率：15%付款方式：TT银行费用：0.10%海运费：1350美元9,112.50元保险COVER ：110%保险费率：0.880%其他费用3370元厂内费用：100立方-1成本：含税成本：6元/只退税收入：0.796460177元/只实际成本： 5.203539823元/只包装件数：165件校正区：165164.0333333164报价数量：9842个费用：国内费用：0.617354196元/个海运费：0.925878886元/个保险费：CIF 价格*110%*0.88%银行费用：报价*1%FOB 价格：实际成本： 5.203539823元/个按增值税发票单价，即采购价格退税收入=含税成本/（1+13%）*退税率实际成本=含税成本-退税收入按所需柜型得出可装件数直接输入数字即可利润=报价金额-采购成本-各项费用+退税收报价核算区：CFR ＝CIF×[1－（1＋保险加成率）×保险费率]国内费用=（立方数*内陆运费+报关报检费+核销费+公司综合业海运费=海运总费/报价数量CIF 价*保险COVER*保险费率报价*银行费用FOB 价格=实际成本+国内费用+银行手续费+利润外贸出口报价模型计算明细过程：此为厂内请人搬运费用，如果是自己工厂搬运工，可以设定为0数量一般可以提价10%-15%不等来出价欧美等客人需求质量可靠，可提价30%主要路线：按个数利润计算内陆运费100/立方，报检费120；报关费150；核销费100；公司综合费用3000报价的10%利润=（采购成本+各项费用-退最终价格得出国内费用：0.617354196元/个FOB 报价：6.474854304元/个换美元：0.959237675美元/个CFR 价格;实际成本：5.203539823元/个国内费用：0.617354196元/个海运费：0.925878886元/个CFR 价格：7.504752954元/个换美元：1.111815252美元/个CIF 价格;实际成本：5.203539823元/个国内费用：0.617354196元/个海运费：0.925878886元/个保险费：CIF 价格*110%*0.88%CIF 价格：7.586440095元/个换美元： 1.123917051美元/个1、2、3、4、5、6、7、8、常识区域：LC 银行费率：1%扁平产品方形产品TT 银行费率：0.10%20GP 28CBM 25CBM DP 银行费率：0.17%40GP 58CBM 55CBM DA 银行费率：0.15%40HQ 68CBM 65CBM按照实际报价的一定百分比计算的内容应一次求出，否则容易造成报价的低估；实际业务中，除了采用费用额相加的方法外，还有规定定额费用的做法，该费用率；的计算基础是含税的进货成本银行费用是根据出口发票金额的一定百分比收取，计费基础是成交价格。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
simtrade半自动计算表改良版
SimTrade是一种半自动计算表工具，可以帮助人们进行股票交易模拟和分析，提供了一种更加便捷和高效的方式来进行投资决策。
在本文中，我们将介绍SimTrade半自动计算表改良版的功能和优势，并探讨其在投资中的应用。
SimTrade半自动计算表改良版具有简单易用的特点。
它提供了一个直观的界面和操作流程，使用户可以轻松地进行股票交易模拟和分析。
通过简单的几步操作，用户可以输入股票代码、交易时间和交易数量等信息，然后点击计算按钮即可得到相应的交易结果。
这种简单易用的特点使得SimTrade成为投资者们进行投资决策的首选工具。
SimTrade半自动计算表改良版具有多种功能和工具，可以满足不同投资者的需求。
它提供了股票行情分析、交易模拟、风险评估等功能，帮助用户全面了解市场动态和投资风险。
此外，SimTrade还提供了多种技术指标和图表工具，如移动平均线、相对强弱指标等，帮助用户进行技术分析和趋势预测。
这些功能和工具的丰富性使得SimTrade成为一个全面的投资分析平台。
SimTrade半自动计算表改良版的另一个优势是其高效性和准确性。
它通过自动计算和分析，可以快速得到交易结果和风险评估等信息，帮助用户做出更加明智的投资决策。
与传统的手动计算和分析相比，
SimTrade不仅能够节省时间和精力，而且可以减少人为因素的干扰，提高投资决策的准确性和可靠性。
在实际应用中，SimTrade半自动计算表改良版可以帮助投资者进行实时交易模拟和回测分析。
通过输入不同的交易策略和参数，用户可以模拟不同的交易场景，并及时调整和优化投资策略。
同时，SimTrade还提供了历史行情数据的回测功能，可以帮助用户评估和验证不同的投资策略的盈利能力和风险水平。
这种实时模拟和回测分析的功能使得投资者能够更好地把握市场机会，降低投资风险。
除了个人投资者，SimTrade半自动计算表改良版还可以被金融机构和专业投资者广泛应用。
金融机构可以利用SimTrade进行投资组合分析和风险管理，帮助其优化投资组合和降低风险。
专业投资者可以利用SimTrade进行交易算法的开发和优化，提高交易执行的效率和盈利能力。
这种广泛的应用性使得SimTrade成为一个重要的投资工具和决策支持系统。
SimTrade半自动计算表改良版是一个功能强大、简单易用的投资分析工具，具有多种功能和工具，可以满足不同投资者的需求。
它的高效性和准确性使得投资者能够更好地把握市场机会，降低投资风险。
无论是个人投资者还是金融机构和专业投资者，SimTrade都可以帮助他们进行更加明智和有效的投资决策。
因此，SimTrade半自动计算表改良版是投资者们不可或缺的工具之一。