Cost accounting method:
1. Establish a detailed account of materials and classify them according to main materials and auxiliary materials
2. Determine time unit consumption
3. Material input according to production plan
4. Summarize direct costs and allocate costs by hours worked.
5. Carry forward the completion cost according to the quantity of completed product varieties
6. Production in progress at the beginning of the period + production in the current period - completion in the current period = production in the current period
1: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
The cost accounting form is a very practical form, and filling in the form is mostly for general purposes. If you happen to need to download the cost accounting excel form, please download it quickly.Graduation thesis design registration form,Project scheduleIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works