How to use EXCEL to make a customer quotation system for the furniture industry, help me

Updated on furniture 2024-09-01
1 answers
  1. Anonymous users2024-01-24

    To put it simply, you can make a list of parts prices, each with a unique code, price, specifications, description, and so on.

    When making a quotation, the price is quoted from the "Parts Price List" with Vlookup, and if you can't find it, you should add it to the "List" in time.

    Unit price * quantity, summed, equals total price.

    As long as the list price is correct and the number of parts is correct, then it's OK, of course, you can also use VBA to deal with the complicated points.

Related questions
18 answers2024-09-01

The prospect of furniture is not bad, but you have to choose the right address to open the store, understand the consumption level of your side, and see the right place to open the store, the address of your store is not good, the price is too high, or too low, you can't make money.

4 answers2024-09-01

Normally, furniture bai

Innovation in the industry is indispensable >>>More

4 answers2024-09-01

You're going to a county town, which is classified as a tertiary market in furniture marketing, the lowest in the furniture market, but it should be said that it is the most potential market. Many manufacturers will launch corresponding products for different levels of the market, so you must first position your products accurately, not only to often go to the furniture city to see, but also to have a certain understanding of the preferences of local residents. >>>More

1 answers2024-09-01

Sales are subject to VAT. Educational fee surcharge. Urban construction tax. Levee fee. Corporate income tax.

2 answers2024-09-01

An important member of the market economy, there is demand and market.