Foreword The following experience is learned from "an expert" of Taisheng Furniture Company, the largest furniture manufacturer in the Asia-Pacific region. Applicable to: MDF veneer+solid wood furniture needs painting (American furniture, modern furniture PU PE NC AC painting) as long as it needs painting; Applicable conditions: The factory has at least a perfect painting line (computer programmed automatic painting line, process spraying platform and perfect painting tools). At the very least, push and draw lines by hand.) Hanging lines and ground wires can be used. Not applicable to: stickers. Skin-attached. Oiled. . . . It's good to see this. Software assistance: Microsoft office software excel has a large number of formulas. It can completely meet the needs of cost analysis (convenient, simple and appropriate). Establish a complete cost analysis workflow: establish a painting volume BOM to test the amount of paint in the painting line-test the paint ratio in the paint mixing room 1: paint plane volume algorithm and establish 1. Meaning of picture scroll: Simply put, it is the area that each product needs to draw; 2. Volume drawing algorithm: Use your tape measure to measure the length, width and height of all parts of each product that need to be drawn normally, and then use the formula: length mm* width mm* height mm/25.4/25.4/12/12 (this is square feet) to collectively refer to it as "material". For example, if a product is 12.38, then the product is "12.38 material" (this is a unit commonly used by international and Taiwanese companies, and they often say: How much is a material for this product? At present, some domestic-funded enterprises use square meters to calculate; 3. Understand the above methods, and then measure all the products produced by the factory, and set them up in excel tables. According to color classification (when there are multiple color measurements in an imte, these measurements are completely separated and established under a file. The principle is one product and one file. Two: coating line dosage test 1. Tools needed: electronic scale with high stability (it is best to withstand more than 30kg); 2. Need mood: patience is the most important; 3. Friends who have worked in the furniture factory know that each painting line has many spray platforms and spray hands (gunmen); Every product has a painting process; According to the painting process of each product, the consumption of a product in each process is measured by electronic scales in turn. For the accuracy of data, IMTE should be tested at least 20 times in each process. Then the average value is a single consumption; 4. Measure the consumption of each product produced by the factory in turn according to the complaint method, and establish detailed process test data on excel. 3: paint ratio data establishment of paint mixing room (room) 1. Every drop of paint on the production line is delivered from the paint mixing room to the painting line. 2. In the painting process of each product, several kinds of coatings are mixed and blended together, so we need to weigh the proportion of each coating after electronic blending. 3. Establish spreadsheet data. All the data above 1.2.3 are established in spreadsheets, and the expenses are calculated by formulas. The details are as follows: single product consumption/single product volume = actual cost of single product consumption. The complete consumption of a single product should include the following contents: industry standards, international standards, English, composition, trade, student courseware, enterprise management, QA, foreign trade QC, QE training, quality inspection certification, inspector forum, personnel training, textile and clothing, college graduation thesis, electronics, electrical appliances, furniture professional knowledge training. Chemical coatings, household appliances, handicrafts, test quotations, medical knowledge, food knowledge, web page special effects, website code, Korean, Japanese, Vietnamese and other small languages; N* M3 e ~ L0 g test data+unit price of paint provided by finance+coating process. Of course, these are all sprayed by hand. Taking one less picture is totally different from taking one more. But you can take a relative value as the cost data. A well-managed factory cost must be stable!