An overview of the way of storing goods out
Inventory issued by the method of valuation is moving weighted average method, a full month weighted average method, advanced first Out method, LIFO, batch designation and other methods, the following examples illustrate the basic principles of these methods.
Business Analysis (case analysis)
Example analysis does not include a second way of warehousing
Data: Red Star Factory June 2002 a commodity of the beginning of the balance and purchase and sale of the current period as follows:
June 1 at the beginning of the Balance 150 unit price 60 yuan 9000 yuan
June 8 Sales of 70 pieces
June 15 Purchase 100 pieces of 62 yuan 6200 yuan
June 20 Sales of 50 pieces
June 24 Sales of 90 pieces
June 28 Purchase 200 pieces of 68 yuan 13600 yuan
June 30 Sales of 60 pieces
Full monthly weighted average
Using a weighted average method, this month, sales or consumption of inventory, usually only the number of registrations, do not register the unit price and amount, at the end of the month by the weighted average unit price, calculated at the end of the inventory cost and the current period of sales or consumption costs. The average unit cost of inventory is calculated as:
Weighted Average Cost = (total cost of inventory at the beginning of the month + the total cost of stock purchased in monthly)
This case calculates the final inventory commodity cost and the current sales cost according to a weighted average method, as well as the registration result of the inventory commodity breakdown, see the following table:
2002
Summary
Income
Issued
Balance
Month
Day
Number
Price
Amount
Number
Price
Amount
Number
Price
Amount
6
1
Opening Balance
150
60
9000
8
Sales
70
80
15
Buy into
100
62
6200
180
20
Sales
50
130
24
Sales
90
40
28
Buy into
200
68
13600
240
30
Sales
60
180
11520
Sales cost for the current period
270
64
17280
It can be seen from the table, the use of a weighted average method, the inventory of a breakdown of goods and the registration method is basically the same as the advanced first out method, only the final inventory of goods at the end of the balance unit price of 64 yuan, calculated the inventory cost of 11520 yuan, the current period of sales cost
Moving weighted average
Using the mobile weighted averaging method, when each purchase price and the balance unit price are not the same, we need to recalculate the weighted average price, and then calculate the inventory cost and sales cost before the next purchase. In this way, the cost of sales can be carried forward at any time. The average unit price of the formula is the moving-weighted average unit Price = (the previous balance amount + this purchase amount)/(the previous balance amount + this purchase quantity)
In the previous example, the average unit price after the first 批购 was:
Mobile Weighted Average Unit Price = (4800+6200)/(80+100) =61.11 (yuan)
The average unit price of the second 批购 is:
Mobile Weighted Average Unit Price = (2444+13600)/(40+200) =66.85 (yuan)
According to the moving weighted average method to calculate the sales cost and the balance cost of each batch of goods, and the registration result of the breakdown of the inventory goods, see the following table
2002
Summary
Income
Issued
Balance
Month
Day
Number
Price
Amount
Number
Price
Amount
Number
Price
Amount
6
1
Opening Balance
150
60
9000
8
Sales
70
60
4200
80
60
4800
15
Buy into
100
62
6200
180
61.11
11000
20
Sales
50
61.11
3056
130
61.11
7944
24
Sales
90
61.11
5500
40
61.11
2444
28
Buy into
200
68
13600
240
66.85
16044
30
Sales
60
66.85
4011
180
66.85
12033
Sales cost for the current period
270
16767
Using the mobile weighted averaging method, it is possible to carry forward the cost of the sale at any time and provide the balance quantity and amount on the inventory breakdown, which is beneficial to the daily control of the quantity and amount of inventory. But this method, because each purchase after the calculation of the average price, will increase the workload of accounting.
Advanced First Out
The method assumes that "the first warehousing inventory is first sent out", according to which, the cost of the sale or consumption of the inventory should be calculated along the unit cost order of the revenue inventory lot. Of course, this is only for the purpose of valuation, and the actual storage or issue of the order of goods is not much relationship.
This case uses the advanced first Out method valuation, the Inventory commodity breakdown ledger registration result is as follows table.
2002
Summary
Income
Issued
Balance
Month
Day
Number
Price
Amount
Number
Price
Amount
Number
Price
Amount
6
1
Opening Balance
150
60
9000
8
Sales
70
60
4200
80
60
4800
15
Buy into
100
62
80
100
60
62
11000
20
Sales
50
60
3000
30
100
60
62
8000
24
Sales
30
60
60
62
1800
3720
40
62
2480
28
Buy into
200
68
13600
40
200
62
68
16080
30
Sales
40
20
62
68
2480
1360
180
68
12240
Sales cost for the current period
270
16560
Backward First Out
The LIFO is in contrast to the FIFO approach, which assumes that the "purchased inventory is first issued", so that the first issued inventory shall be based on the unit price of the last purchase, and the closing stock is calculated at the unit price of the first purchased stock.
2002
Summary
Income
Issued
Balance
Month
Day
Number
Price
Amount
Number
Price
Amount
Number
Price
Amount
6
1
Opening Balance
150
60
9000
8
Sales
70
60
4200
80
60
4800
15
Buy into
100
62
6200
80
100
60
62
11000
20
Sales
50
62
3100
80
50
60
62
7900
24
Sales
50
40
62
60
3100
2400
40
60
2400
28
Buy into
200
68
13600
40
200
60
68
16000
30
Sales
60
68
4080
40
140
60
68
11920
Sales cost for the current period
270
16880
To achieve the processing of advanced first out inventory items
Warehouse
Positions
Goods
Lot/Effective Date to/production date
Batch
Number
Price
Warehousing time
Warehousing processing
Queue: Team (tail)
Add inventory information of incoming goods and fill in the warehousing time
Out of the library processing
Queue: Out team (Team head)
In the order of the storage time to carry out the library (first warehousing goods first out of the library)
Cost handling
Direct calculation of costs when out of library
LIFO inventory Item
Same-advanced first out
Warehousing processing
Stack: Press Stack
Add inventory information of incoming goods and fill in the warehousing time
Out of the library processing
Stack: Out Stack
After the storage time of the first order to carry out the library (after warehousing goods first out of the library)
Cost handling
Direct calculation of costs when out of library
Batch specified inventory item
Same-advanced first out
Warehousing processing
Same-advanced first out
Out of the library processing
Specify batch out of library
Cost handling
Direct calculation when out of library
Moving weighted average inventory item
Warehouse
Positions
Goods
Lot/Effective Date to/production date
Number
Price
Warehousing processing
When each purchase price and the balance unit price is not the same, you need to recalculate the weighted average price
The calculation method is:
Moving weighted Average Unit Price = (Previous balance amount + current purchase amount)/(Previous balance amount + this purchase quantity)
Out of the library processing
Out of the library at the current moving weighted average unit price
Cost handling
Direct calculation of costs when out of library
Full monthly weighted average inventory item
Warehouse
Positions
Goods
Lot/Effective Date to/production date
Number of the beginning of this month
Initial amount of this month
Number of inbound this month
Amount of this month's storage
Number of outbound libraries this month
Out of storage line items
Out/Storage number
Out/Inbound Document types
Out/Inbound Document detail serial number
Goods
Warehouse
Positions
Batch
Storage quantity
Storage Amount
Number of Out libraries
Out of the library amount
When the amount of out of the library is closed by the month, fill in the costing
Warehousing processing
Warehousing quantity and amount will be added to the storage quantity and amount in this month.
Fill in the warehousing details
Out of the library processing
The number of outbound libraries is added to the number of outbound libraries this month when the library is out.
Fill out the information of the library out of the warehousing details.
Cost handling
The cost is calculated at the end of each month, and the cost is filled out in the respective library list.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
