How to calculate the weighted average method in basic accounting

An enterprise adopts the weighted average method at the end of the month.

Accounting raw materials, 100 pieces of materials in stock at the beginning of the month, 80 yuan per piece, two batches were purchased in the middle of the month, 150 pieces at a time, 75 yuan per piece, and 250 pieces at a time, 85 yuan per piece, then the weighted average unit price of the material at the end of the month was ( ) yuan. a．81

b．c．75d．85

The total value is 80 * 100 + 75 * 150 + 85 * 250 = 40500, and the total number of pieces is 100 + 150 + 250 = 500

Unit price 40500 500 = 81

Weighted average method:

It refers to a method that calculates the weighted average unit cost of inventory by taking the total purchase quantity of the month plus the inventory quantity at the beginning of the month as the weight, removing the total purchase cost of the month plus the inventory cost at the beginning of the month, and calculating the cost of the inventory at the end of the period.

Calculation formula: inventory unit cost = (inventory quantity at the beginning of the month + sum of the purchase quantity of each batch this month) cost of inventory issued this month = quantity of inventory issued this month * inventory unit cost.

The cost of inventory inventory at the end of the month = the quantity of inventory at the end of the month * the cost of inventory units or = the actual cost of inventory at the beginning of the month + the actual cost of inventory in revenue this month - the actual cost of inventory issued in this month.

Calculation formula: Inventory unit cost = (Inventory quantity at the beginning of the month + Sum of the purchase quantity of each batch in this month).

The cost of inventory issued this month = the quantity of inventory issued this month * the cost of inventory units.

The cost of inventory at the end of the month = the quantity of inventory at the end of the month * the cost of inventory units or = the actual cost of inventory at the beginning of the month + the receipt of this month.

Actual Cost of Inventory - The actual cost of inventory issued this month.

2.Example: An enterprise uses a weighted average method at the end of the month to account for raw materials, and there are 100 pieces of materials in stock at the beginning of the month, each of which is 80 yuan, and two more are purchased in the middle of the month.

batch, 150 pieces at a time, 75 yuan per piece, and another 250 pieces, 85 yuan per piece, then the weighted average unit price of the material at the end of the month is ( ).

Yuan. a．81

b．c．75d．85

The total value is 80*100+75*150+85*250=40500

The total number of pieces is 100 + 150 + 250 = 500

Unit price 40500 500 = 81

Concept of weighted average method: The weighted average method refers to a method that calculates the cost of inventory this month and the cost of inventory at the end of the period by taking all the purchased quantity of the month plus the inventory quantity at the beginning of the month as the weight, removing all the purchase costs of the month plus the inventory cost at the beginning of the month, and calculating the cost of the inventory at the end of the period.

The weighted average method is a method that uses the observations of the same variable arranged in chronological order in the past and uses the chronological number as the weight to calculate the weighted arithmetic mean of the observations, and uses this number as a trend in the value of the variable in the future period. The weighted average method in accounting is divided into the moving weighted average method and the month-end weighted average method.

Extended information: The weighted average method can calculate the weighted average unit price of the inventory in the current period at the end of the period based on the quantity and amount of inventory held at the beginning of the period and the quantity and amount of inventory deposited in the current period, and calculate the actual cost of inventory issued in the current period at one time as the ** of the inventory issued in the current period and the inventory held at the end of the period.

The so-called moving weighted average method is a method in which a new average unit cost is calculated for inventory immediately after each purchase as the basis for the next shipment. The formula is: weighted average unit price (balance amount before warehousing amount amount of this income) (balance quantity before warehousing amount of this revenue) amount issued in the current period quantity issued in the current period weighted average unit price.

The use of the moving weighted average method enables managers to understand the balance of inventory in a timely manner, and the average unit cost calculated and the cost of inventory issued and held are more objective. However, due to the fact that the average unit price must be calculated once for each Bianhong receipt, the calculation workload is large, and it is not suitable for enterprises with frequent receipt and delivery.

The so-called month-end weighted average method refers to the method of calculating the average unit price of inventory at the end of the month at the end of the month, based on the amount of inventory issued in the current month and the actual cost of inventory at the end of the month. The formula is: weighted average unit price (opening balance amount current month revenue amount) (opening balance quantity current month revenue quantity), current month amount issued this month quantity with dan book weighted average unit price, current month balance amount beginning balance amount current month revenue amount current month amount issued this month.

Example: The quantity of inventory A of an enterprise at the beginning of the month is 150 kg, the unit price is 10 yuan, and the cost is 1500 yuan. The total quantity of this month's warehousing is 400 kilograms, the cost is 5,500 yuan, and 350 kilograms are issued.

Find the average unit cost of inventory = (1500 + 5500) (150 + 400) = yuan kilogram (rounded).

Inventory cost issued = 350 * yuan.

Inventory cost at the end of the month = 1500 + yuan.

The use of the month-end weighted average method only at the end of the month to calculate the weighted average unit price is relatively simple, which is conducive to simplifying the cost calculation work, but because it is not possible to provide the unit price and amount of the issued and balanced inventory from the account, it is not conducive to the daily management and control of inventory cost.

The weighted average method in accounting includes the month-end weighted average method and the moving weighted average method.

Formula for the month-end weighted average method:

Unit Cost of Inventory Actual cost of inventory at the beginning of the month (actual unit cost of each batch of purchases this month Quantity of each batch purchased this month) (Quantity of inventory at the beginning of the month Sum of the quantity of each batch purchased this month).

Inventory cost issued this month Quantity of inventory issued this month Inventory unit cost.

Month-end inventory inventory cost Month-end inventory quantity inventory quantity inventory unit cost at the end of the month.

or the cost of inventory inventory at the end of the month The actual cost of inventory at the beginning of the month + the actual cost of inventory in revenue this month - the actual cost of inventory issued this month.

The weighted average method is used to calculate the weighted average unit price only once at the end of the month, which is relatively simple and conducive to simplifying the cost calculation work, but it is not conducive to the daily management and control of inventory cost because it is not possible to provide the unit price and amount of issued and balanced inventory from the account at ordinary times.

Moving Weighted Average:

The cost of goods in stock under the moving weighted average method** is automatically weighted average based on each revenue type document; It is calculated by calculating the moving weighted average unit price based on the quantity and amount of each revenue and the amount before each income. It is calculated as follows:

Moving weighted average unit price

The amount of goods that are balanced before this income + the amount of goods that are included in this income) (The number of products that are balanced before this income + the number of products that are included in this income.)

The commodity cost calculated by the moving weighted average method is relatively balanced and accurate, but the workload of calculation is large, and it is generally suitable for commodity circulation enterprises with few varieties or large unit price difference between the purchased commodities.

Weighted average method:

It refers to a method that calculates the weighted average unit cost of inventory by taking the total purchase quantity of the month plus the inventory quantity at the beginning of the month as the weight, removing the total purchase cost of the month plus the inventory cost at the beginning of the month, and calculating the cost of the inventory at the end of the period.

Calculation formula: Inventory unit cost = (Inventory quantity at the beginning of the month + Sum of the purchase quantity of each batch this month) Cost of inventory issued this month = Quantity of inventory issued this month * Inventory unit cost of inventory at the end of the month = Quantity of inventory at the end of the month * Cost of inventory unit or = Actual cost of inventory at the beginning of the month + Actual cost of inventory in revenue this month - Actual cost of inventory issued this month.

The weighted average method is the basic method of index synthesis, which has two forms, namely addition rule and multiplication rule.

The weighted average method is also known as the "comprehensive weighted average method" and the "weighted average method once a month". It refers to the total purchase cost of the current month plus the inventory cost at the beginning of the month as the weight, and the whole of the month is removed.

A method of calculating the cost of inventory issued in the current month and the cost of inventory at the end of the period based on the purchase quantity plus the inventory quantity at the beginning of the month to calculate the weighted average unit cost of inventory.

Weighted average unit cost of inventory = (cost of inventory at the beginning of the month + cost of inventory purchased in the current month) (quantity of inventory held at the beginning of the month + quantity of inventory purchased in this month).

Month-end inventory inventory cost = month-end inventory inventory quantity Inventory weighted average unit cost.

Cost of inventory issued in the current period = Quantity of inventory issued in the current period Weighted average unit cost of inventory.

or = Inventory cost at the beginning of the period + Inventory cost with revenue in the current period - Inventory cost at the end of the period.

The weighted average method, in the market, is a method of averaging different weights according to the importance of each data in the observation period.

It is characterized by the fact that the average value obtained already includes long-term trend changes.

Calculation formula: Inventory unit cost = (Inventory quantity at the beginning of the month + Sum of the purchase quantity of each batch this month) Cost of inventory issued this month = Quantity of inventory issued this month * Inventory unit cost of inventory at the end of the month = Quantity of inventory at the end of the month * Cost of inventory unit or = Actual cost of inventory at the beginning of the month + Actual cost of inventory in revenue this month - Actual cost of inventory issued this month.

2.Example: An enterprise uses a weighted average method at the end of the month to account for raw materials, 100 pieces of materials in stock at the beginning of the month, each piece is 80 yuan, and two batches are purchased in the middle of the month, one is 150 pieces, each piece is 75 yuan, and the other is 250 pieces, each piece is 85 yuan, then the weighted average unit price of the material at the end of the month is () yuan.

a．81 b． c．75 d．85

The total value is 80 * 100 + 75 * 150 + 85 * 250 = 40500, and the total number of pieces is 100 + 150 + 250 = 500

Unit price 40500 500 = 81

The weighted average method refers to a method that calculates the weighted average unit cost of the inventory based on the total purchase quantity of this month's difference plus the inventory quantity at the beginning of the month plus the inventory quantity at the beginning of the month, and calculates the weighted average unit cost of the inventory on this month's hand-bent inventory and the cost of the ending inventory on this basis.

The weighted average method is an averaging method that takes the weights into account. The weighted average method uses the measured values of several previous periods of the same variable arranged in chronological order, and uses the chronological number as the weight. In everyday life, we often use averages to represent the "average" of a set of data.

In a set of data, the number of occurrences of a data is called the weight of the megabend.

The weighted average method is a method that uses the opening balance quantity and the current month's income quantity of a material as weights at the end of the month to calculate the average unit cost of the material. Specifically, this method is to divide the sum of the inventory amount at the beginning of the month and the amount purchased in the current month by the sum of the inventory quantity at the beginning of the month and the quantity purchased in the current month, and the average unit price of the material at the end of the month is obtained as the unit price of the material cost issued this month.

The moving weighted average method is regarded as a more objective inventory guessing valuation method that is not easily affected by subjective factors. This method can provide the income, issuance and balance of inventory at any time, so that managers can understand the balance of inventory in a timely manner and strengthen management.

Advantages of the weighted average method: the weighted average unit price is calculated only once at the end of the month, which is relatively simple, and the unit cost calculated at the time of market **** or ** is averaged, and the allocation of inventory cost is more compromised.

The weighted average method refers to a method in which an enterprise calculates its unit cost on average based on the quantity of materials in stock, which is used as a valuation standard for issuing material inventory. The weighted average unit cost is generally calculated at the end of the month, so it is also known as the "weighted average at the end of the month". It is calculated as follows:

Weighted average unit cost = (Actual cost of materials at the beginning of the month Actual cost of materials in this month's revenue) (Number of materials in the beginning of the month Quantity of materials in this month's income).

Actual cost of materials issued = quantity of materials found Weighted average unit cost.

For example, the round steel listed in the inventory material ledger is an example, and the chain hall is calculated as follows:

Weighted average unit cost = (3200 12800) (800 3000) = yuan kg) will. Counting the Olympics. Net.

The actual cost of materials issued this month = 1100 yuan) will, count the Olympic net.

The weighted average method is adopted, the accounting is simple, the average unit cost calculated is more reasonable, and the inventory cost is more moderate. However, due to the fact that the average unit cost is concentrated in the calculation of the month, the valuation, summary and registration of the delivery voucher must also be concentrated at the end of the month, which not only increases the workload of the month-end accounting, but also affects the timely dispersion of the accounting. In order to overcome the above shortcomings, another weighted average method has been proposed, namely the moving weighted average method.

Yes. Plan.