Analysis on the way of storing goods out of stock

Source: Internet
Author: User
Tags add date end final
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.


Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.