The format of quotation is generally EXCEL format, which is more common. The following screenshot is an example:
Qualified quotations shall include:
1, project name, project time, customer name, contact information (showing respect for customers. )
2. The product is the key content, and the product should be clearly and emphatically described, such as name, brand, size, model, parameters, pictures, quantity, price, etc.
3. The final settlement price (if any) can also be displayed together with the preferential price.
Remember to mark your company, name and method at the end of the article, so that customers can find your contact information at the first time.
How to quote quickly;
1, open the tool for quotation.
2. Click on "Template Library", which will provide a variety of free templates to help you standardize your quotation, and you can use and save them directly.
Make a convenient quotation template with Wps form? Here is a practical method to make an excel quotation template.
1. First, enter the basic contents of the quotation in the wps table, as shown in the figure.
2. We need to draw the table lines of 1 line (where the quotation is located) and 5- 13 line (the quotation content), and merge the cells appropriately.
3. Select all the cells in the first row A 1-H 1, and then click the Merge Center tool in the Start toolbar.
4. Select all cells in A5-H 14 again, and then click all borders and horizontal center in the start toolbar.
5. Others are simpler, such as merging B3-D3 cells. (For the method of merging all cells with red lines, see step 3. Except those that don't need to be merged in the middle, click the inverted triangle at the bottom of this tool to make a selection before merging. )
6. The adjustment of the remaining column widths, the addition of some table lines, the combination of cells and the adjustment of fonts and font sizes are all relatively basic. The adjusted result chart is displayed directly here. (But please note that this is not the end. )
7. The following are the key points: the first is to automatically calculate the cells after "total lowercase" and "total uppercase" after entering the unit price; Second, the "Quantity" column in the quotation content shows the unit, and the value in the "Amount" column will be automatically calculated when the unit price is entered.
8. The automatic calculation formula of the "Amount" column in the quotation content is
=F6*E6
After the input is completed, put the mouse in the lower right corner of this cell. When it becomes a+sign, the formulas of other cells can be automatically obtained by drop-down.
9. The formula behind the total lowercase letters is
=SUM(G6:G 13)
10. The formula behind total capitalization is
=B 14
When you are finished typing, press enter and right-click the cell, and then select the Format Cell option in the list.
1 1. In Cell Format, click General-Special-RMB Capitalization and click OK to exit.
12. Select the cell E6-E 13, right-click and select the Cell Format option.
13. In the cell format, set "General"-"Custom"-"0" in turn (the quotation marks set must be in English mode). Which unit is not responding? Try to enter the quantity.
14. Basic effect. Ok, that's all for the general content, (end)
Recommend several quotation formats! Hello! The format of foreign trade quotation is similar, and I think your company should have it. Please note the following points in the foreign trade quotation.
The quotation content of different products will be slightly different, but it basically includes the following aspects:
1 product model item/model number ..
2 pictures consistent with the pictures of the quoted products.
3 dimensions/sizes/specifications/features, etc.
4 minimum order quantity /M.O.Q
Unit price The unit price must indicate the currency unit.
6 Packing details and container quantity (piece/container)
7 lead time of delivery
8 Terms of Payment Term of Payment
9 Validity period of quotation and other terms to be specified
Of course, the title of the quotation sheet needs to indicate the company name and contact information, which is convenient for customers to browse and remember.
It is recommended to go to the foreign trade forum of the affordable network, where there are many foreign trade materials to download. Wish the landlord an early order.