Tables can efficiently calculate product pricing for us, so how can we use tables to achieve efficient, scientific and reasonable pricing?
Shipping Calculator.
First let’s look at the product pricing table I always use. In this form, as long as you enter the main parameters of the product, you can automatically calculate how much the product needs to sell for in US dollars. It is very convenient. You can refer to the production of the form or contact me to request it. Let’s learn how to use this form. The first item in the form is the freight calculator. I will use the China Post registered small package as an example. For example, our product weighs 200 grams and is to be sent to Russia. Let’s calculate how much freight is required. At the time of writing this article, the standard shipping price per kilogram of China Post’s registered small parcels sent to Russia is 86.67 yuan, and the registration fee is 8 yuan. Let’s use the table to calculate the shipping cost.
We enter 86.67 here for the unit freight price, which is the standard freight we calculate to Russia. Enter the actual weight of the product 200 grams here for the product weight. Enter 8 yuan for the registration fee here. If there is no shipping discount here, For a discount, fill in 100%, which means there is no discount on freight. If it is a 10% discount, fill in 90%. After entering it, the international shipping price will be automatically calculated as 22.8 yuan. This 22.8 yuan is what our product is shipped to Russia. freight.
Product profit and selling price calculator.
After understanding the shipping calculator, we next introduce the product profit and selling price calculator. Here we can calculate how much profit the product needs to make, and the actual sales dollar amount after including the profit. So how to calculate Woolen cloth? Let us also give an example. For example: Our products are purchased online, and the wholesale cost is 20 yuan. Now our calculation results.
If we purchase goods online and the wholesaler does not provide free shipping, we need to pay 5 yuan for shipping. Then fill in 5 yuan for domestic shipping. If the seller offers free shipping, we can fill in 0 yuan. International shipping We don’t need to fill it in here. The 22.8 yuan here is the international shipping fee. After filling in, we can adjust our profit margin. Here I fill in 50%, which means I earn 50% profit on this product. Below is the exchange rate of RMB against the U.S. dollar. You can fill it in based on the real-time exchange rate of the U.S. dollar. When I wrote the article, the exchange rate of the U.S. dollar was 6.2485, so just fill in 6.2485. The latter one is the “AliExpress” commission. Just fill in 5% of the commission charged by the platform. After filling in these places, the form will automatically output a profit of 23.9 yuan. The profit is the output value of the form and is automatically calculated. It cannot be changed. If we want to change the value of profit, we can adjust the profit rate. Now we fill in 50%. When we adjust the profit rate to 60%, the profit number will change. At the back is the position of the “AliExpress” selling price. This place cannot be changed. It is also the value output by the system after automatic calculation. This means that if we set the sales price of this product on “AliExpress” as 12.08 US dollars If so, we will earn RMB 23.9 per sale.
Sale price calculator after discount.
After we calculated the pricing of the product earlier, we have determined how much the product will sell for. Then we will definitely need to discount the product in the future sales process. Let’s explain this part. Selling price after discount calculator.
We do not need to enter the “AliExpress” selling price in this calculator, because this place also calls the “AliExpress” selling price data above 4-52, so we only need to enter the discount Just enter the discount we want to give to the product. Here I enter 30% to give the product a 30% discount. If you want to give the product a 50% discount, you can enter 50%. We don’t need to change the other places because that is all Output value, now we see that the actual sales price of this product after a 30% discount is 8.456 US dollars, and the profit after discount is RMB2.39 yuan.
Tips.
In table calculations, we mentioned places that cannot be entered. We hope everyone will be careful not to enter them, because they are output values. If we enter them, the calculation formulas in the table will be gone, which will affect the calculation of the table. and call functions.