Inventories Notes2 170419181823
Inventories Notes2 170419181823
Inventories Notes2 170419181823
Depending up on the purpose why these items are accumulated, different types of
inventories are identified. The following are the frequently encountered terms in
accounting.
Merchandise inventory: this refers to items or commodities bought for reselling
purpose in the normal activities of the business enterprise.
Manufacturing inventory: For manufacturing firms Inventory refers to raw materials
inventory, goods in process inventory, finished goods inventory, and supplies inventory.
-Raw materials inventories- are items acquired and being held for use in the
fabrication process. Raw materials are held as inputs of the manufacturing
process.
-Working process inventory - goods in the fabrication process but not yet
completed. They are also known as work in process or partially processed
goods.
-Finished Goods Inventory- these are goods that are completed and ready for
sale.
Supplies Inventory- these are various consumable items held for use in the
normal course of business. Supplies are not parts of the finished product.
Thus, inventory means different things for different establishments, but in all
cases it represents an asset item held for different purposes. However, in this
course inventory is used to mean merchandise inventory.
o Cost of Inventory: What is cost of inventory? Cost of inventory items includes all
costs necessary to acquire the item and to bring it in the location and conditions in
which it is ready for use. The cost of inventories includes;
-the item’s purchase price less discount
-Transportation-in (freight-in)
-handling charges
-cost of insurance while merchandise is in transit
-storage costs
o Why are inventories and their valuation important? From the standpoint of
management, inventories constitute an extremely important asset. Reasons:
1. The investment in inventories is frequently the largest current asset in
manufacturing and retail establishments, and also may be a material portion of the
company's total assets. In other words the company’s resources are tied up in the
form of inventories.
2. To maintain optimum level of inventories. Sales and customers may be lost if
products ordered by customers are not available in the desired style, quality and
quantity. An inefficient purchasing procedure, faulty manufacturing techniques
or inadequate sales efforts all may saddle a firm with excessive inventories.
1
Also, it becomes important for business to monitor inventory levels carefully to limit
the financing costs of carrying large inventories.
3. Merchandise is one of the most active elements in the operation of wholesale and
retail business. The sale of merchandise provides the principal sources of revenue for
such enterprises. When the net income is determined, the cost of merchandise sold is
the largest deduction from sales. In fact, it is usually larger than all others deductions
combined.
The misstatement in identifying the ending inventory will have the following effect:
o Understatement in identifying the ending inventory will result in overstatement of the
cost of good sold, in turn the overstatement of cost of good sold will understate the
gross profit, the as a result the net income of the period will be understated by the
same amount.
o The understatement of the period net income will result in understatement of the
owner’s equity for the period.
o The understated ending inventory for this period will be the beginning inventory for
the next period which still is understated. The understatement of beginning inventory
in the subsequent period will understate the cost of good sold for the period.
o The understated cost of goods in the subsequent period will overstate the period’s net
income. The overstated net income will in turn over state the period’s owner’s equity
which was understated in the previous period; thus the understated owner’s equity in
the previous period will be compensated by the overstated owner’s equity of this
period.
o Thus the amount of misstatement will be equal in two subsequent periods but of
opposite direction, therefore, these two misstatements will cancel each other, these
means if the effect in the net income of an incorrectly stated inventory is not
corrected, it is limited only to the period of the error and the following period.
Example: Assume that the correct ending inventory is Br 20,000but let us assume that in
assumption number 01 we have misstated the ending inventory as 25,000 while in
assumption number 02 we have misstated the ending inventory as 15,000. And let us see
now the effect of the misstatement in the balance sheet and income statement items,
If the ending inventory is correctly determined as 20,000:
Beginning inventory Br 18,000 Beginning owner’s equity 44,000
Add Purchase 190,000 Add Additional investment 0
Available for sale 208,000 Net income 6,000
Less Ending inventory 20,000 Less Withdrawal 0
Cost of goods sold 188,000 Ending owner’s equity 50,000
ABC Company
Income Statement
3
For the month ended Sene 30, 1992
FIFO LIFO Weighted Average
Sales (Net) …………………… 150,000 150,000 150,000
Cost of goods sold [earlier section] 40,000 51,000 45,970
Gross profit …………………… 110,000 99,000 104,030
Operating expenses …………… 80,000 80,000 80,000
Net income …………………… 30,000 19,000 24,030
ABC Company
Balance Sheet
As of Sene 30, 1992
FIFO LIFO Weighted Average
Merchandise inventory……….. 75,000 64,000 69,030
All other assets ……………… 234,000 234,000 234,000
Total assets …………………. 309,000 298,000 303,030
Total liabilities …………….. 124,000 124,000 124,000
ABC capital (155,000+net income) 185,000 174,000 179,030
Total liability & capital…………. 309,000 298,000 303,030
The three methods show different figures on the income statement and the balance sheet
for inventory, total assets, total liabilities & capital, cost of goods sold, gross profit and
net income.
Errors in reporting inventory
Companies must take care in both computing and taking the physical count of inventory.
If inventory is reported in error, it causes misstatements in cost of goods sold, gross
profit, net income, current assets, and capital account. It also means misstatements will
exist in the next period’s statements. This is because of the ending inventory on one
period is the beginning inventory of the next period. An error carried forward causes
misstatements in the next period are cost of goods sold, gross profit, and net income.
Misstatements will reduce the usefulness of financial statements.
Notice that inventory errors yield opposite effects in the cost of goods sold and net
income. Inventory errors also carry over to the next period, yielding a reverse effect.
Income Statement
1990 1991 1992
Sales [Given] 100,000 100,000 100,000
Cost of goods sold:
Beginning inventory 20,000 16,000 20,000
Add: Purchases 60,000 60,000 60,000
Cost of goods available for sales 80,000 76,000 80,000
Less: ending inventory 16,000 20,000 20,000
Cost of goods sold 64,000 56,000 60,000
Gross profit 36,000 44,000 40,000
Operating expenses (assumed) 10,000 10,000 10,000
Net income 26,000 34,000 30,000
Effects on Balance Sheet
Balance sheet effects of an inventory error are evident by looking at the components of
the accounting equation:
Assets = Liabilities + Capital
We can see, for example, that understating the ending inventory will understate both the
current assets and the total assets. An understating in ending inventory also yields an
understatement in capital because of the understatement of the net income. We can do the
same analysis with overstating the ending inventory. The following will summarize the
effects of the error on balance sheet:
Inventory error Asset Capital
Understating ending inventory Understated Understated
Overstating ending inventory Overstated Overstated
Errors in beginning inventory do not yield misstatements in the year-end balance sheet,
but they do affect the net income.
Goods in Transit
Are goods purchased but not yet received, at the end of a fiscal period. The accounting
for these shipped goods depends on who owns them on the unitary date. That can be
determined by application of the “passage of title” rule.
If the goods are slipped f.o.b. shipping point, title passes to the buyer when the seller
delivers the goods to the common carrier, who acts as an agent for the buyer. (the
abbreviation f.o.b. stands for free on board.)
If the goods are shipped f.o.b. destination, title does not pass units the buyer
receives the goods from the common currier “shipping point” and destination are often
designated by a particular location, for example, f.o.b. legal.
The accounting rule is that goods to which legal title has passed should be recorded as
purchase of the fiscal period. Otherwise a series of misstatement may be included in the
FS.
Consigned Goods - Under this arrangement, the consignor ships merchandise to the
consignee, who acts as the consigner’s agent in selling the goods. The consignee agrees
to accept the goods without any liability, except to exercise due care and reasonable
protection from loss or damage, until the goods are said to a third party. When the
consignee sells the goods, the revenue less a selling commission and expenses incurred in
accomplishing the rate is remitted to the consigner.
Goods out on consignment remain the property of the consignor and must be
included in the consigner’s inventory at purchase price or production cost.
The consignee must no entry to the inventory account to goods received because
they are the property of the consignor.
Sales on Installment – “Goods sold on installment” describes any types of sale in which
payment is required in periodic installments over an extended period of time. Because
the risk of loss from Uncollectible is higher in installment sale situations than in other
sales transactions, the seller often withholds legal title to the merchandise until all the
payments have been made. The question is whether the inventory should be considered
sold, even though legal title has not passed. The answer is that the goods should be
excluded from the seller’s inventory if the percentage of bad debts can be reasonably
estimated. Installment sales are discussed here to show that in some cases, the goods
should be removed from inventory, although legal title may not have period.
Damaged or obsolete goods
It is possible that some goods could be damaged or obsolete on the date of physical
count. Damage refers to physical destruction on goods. Obsolescence refers to the
deterioration of importance [acceptability of a product] for the users [purchasers]. Such
goods are not salable at the usual selling price. Therefore, care must be taken not to
include the cost of such goods at their purchase price.
If such items do not have a sales value, they should be excluded from the physical
counting. If they are salable at reduced price, their cost is determined by taking the net
realizable value. The net realizable value is sales price minus the cost of making the
sales.
6
Physical count of merchandise inventory
The merchandise inventory account under a perpetual inventory system is always up to
date. Yet events can occur where the book balance [merchandise inventory account
balance] may differ from the actual count. Such events include:
- Thefts,
- Losses,
- Damages, and
- Errors.
This means that nearly all companies take a physical count of inventory at least once each
year. Under the periodic inventory system, it is a must to take a physical count to know
the actual account balance of the merchandise inventory account any time. This is
because the merchandise inventory account is not up dated every time purchases and
sales are made. We determine the Birr amount for the physical count of inventory on
hand at the end of the period by following the steps indicated below:
(1) count the units of each item on hand,
(2) multiply the count for each item by its cost per unit, and
(3) add the costs for all items.
Example: Assume that ABC Company had reported the physical count of the inventory
on Sene 30, 1993 as follows:
Inventory item physical count unit cost
Sugar 1,000 kg Birr 4 per kg
Salt 2,000 kg Birr 1.40 per kg
Macaroni 3,000 kg Birr 3 per kg
Required: Compute the total inventory cost to be reported on the balance sheet on
Sene 30, 1993.
When taking a physical count, care must be taken not to count items more than once or
omit an item in the counting process. There are different methods to avoid such errors.
One of the methods is to use pre-numbered inventory tickets. This ticket may have the
following format.
The process of physical count is fairly standard. It means all companies use the same
procedure or steps in the physical count process. The following procedures are usually
followed by most merchandising companies:
(1) Decide the date and period of inventory counting [for example, inventory count will
start on Sene 25 and shall end in one-week time].
(2) Assign individuals who will conduct the physical count [for example, Abebe,
Tesema, and Alemu are assigned to take the count with specific responsibility, i.e., Abebe
will count, Alemu will measure, and Tesema will check the count].
(3) Prepare at least one inventory ticket for each product on hand.
7
(4) Issue the pre-numbered tickets to the assigned employees who will conduct the count.
(5) An employee will count the quantity of the product and obtain information on its
purchase date, selling price, and cost. [This information is sometimes included with the
product but must often be obtained from accounting records or invoices].
(6) Once the necessary information is collected, the employee records it on the ticket,
signs the ticket and attach it to the counted inventory so that it will be checked and avoid
double counting and omitting it from the count.
(7) Another employee often recounts and rechecks information on the ticket, signs the
ticket, and returns it to the inventory manager.
(8) To insure no ticket is lost or missed, internal control procedures verify that all pre-
numbered tickets are returned.
(9) The quantity and cost data on the inventory tickets are aggregated by multiplying the
number of units for each product by its unit cost. This gives us the Birr amount for each
product in inventory. The total of all products is the Birr amount reported for inventory
on the balance sheet. The above procedures are commonly used. However, do not
conclude that all companies must follow all the steps. A company can devise its own way
of taking physical count procedures.
Example: If NIKE sells goods to TARGET with terms FOB shipping point, which will
report these goods in its inventory while they are in transit?
1. An art gallery [painter] purchases a painting for Birr 11,400 on terms FOB shipping
point. Additional costs in obtaining and offering the artwork for sale includes Birr
130 for transportation-in, Birr 150 for import duties, Birr 100 for insurance during
shipment, Birr 180 for advertising and Birr 800 for sales salaries. For computing
inventory, what cost is assigned to the painting?
While determining or taking physical inventory, first the quantity of each kind of
Merchandise owned by an enterprise is identified, when periodic system is adopted,
counting, weighting or measuring is made at the end of the period.
Only merchandise owned by the business at the inventory date is included in inventory.
This is to say it is necessary to examine purchase and sales invoice of the last few days to
determine the legal ownership title of merchandise in transit.
In general inventory should include all (but only) those goods which the business has
legal ownership at the date of the balance sheet. For example merchandise could be
purchased on following terms, FOB shipping point or FOB Destination.
FOB Shipping point (Free on board shipping point) title will pass to the purchaser at the
shipping point, thus if these goods are in transit, they are fully owned by the enterprise
and should be included in the inventory even though they are not available for physical
count /measurement or weight/. It is must that the transaction should also be recorded as:
Purchase XXXXX
Account Payable XXXXX
The above transaction should be recorded in the current period rather than recording the
transaction in the following period.
FOB Destination (free on board destination point) means title will pass to the purchaser
at the destination point. In this case the merchandises in transit are not owned by the
buyer enterprise, thus these merchandise will not be included in the inventory.
In some cases manufacturers ship their product (merchandises) on consignment basis to
the retailers who act as the manufacturer’s (consigner’s) agent when selling the
merchandise. In this case the manufacturer is the legal owner of the merchandise
consigned, thus these consigned merchandise should be included in the inventory of the
manufacture. Even though the manufacturer does not have a physical possession, title is
still retained by the manufacturer. The retailer should not include consigned
merchandises in inventory because the consignee (the retailer) does not have a legal right
of ownership (title).
Inventory System
It is the process of designing and maintaining inventory for controlling the planned
balance between inventory and sales.
9
Periodic inventory system
Under this system, the Merchandise Inventory account is updated only once. This is done at
the end of the fiscal period. This means that the Merchandise Inventory account balance
will not change until the updating process takes place. When goods are purchased, they are
recorded in the Purchase Account. Similarly, the cost of goods sold will not be recorded
each time the goods are sold. Instead, the total cost of goods sold will be computed at the
end of the fiscal period.
Note that the following formula applies in computing the cost of goods sold.
The cost of goods sold for the period = Beginning merchandise inventory …. Birr xx
Plus: net purchases…………………… xx
Equals: cost of goods available for sales...
Xx
Less: end merchandise inventory ……… xx
Equals: cost of good sold
………………… xx
In periodic inventory systems, a separate temporary account is opened for each purchase,
purchase discount, purchase return and allowances and transportation-in transactions. The
following example will explain the recording process of these transactions in a general
journal form.
(a)purchase ABC merchandising firm purchases goods for reselling purpose for Birr
1,200 on credit. The terms of purchases are 2/10, n/30 on Sene 20, 1992. The journal
entry will be:
1992 Purchases ……………………….. 1,200
Sene 20 Accounts payable ………………..1,200
The periodic system uses a temporary Purchases account that accumulates the cost of all
purchase transactions during the period.
b) Purchase discounts:
ABC Merchandising paid the supplier for the above purchase in (a) on Sene 30, 1992.
The required payment is Birr 1,176 (1200 x 98%) and is recorded as:
1992 Accounts payable ………………..1,200
Sene 30 Purchase discount ……………… 24
Cash …………………………… 1,176
The periodic system uses a temporary account that accumulates discounts taken on
purchase transactions during the period
(c) Purchase returns and allowances
ABC returned goods purchased on (a) above because of defects on Hamle 2, 1992. The
cost of defects is Birr 300 (net of the discount). ABC records the return as:
1992 Accounts payable ………………… 300
Hamle 2 Purchase returns and allowances ……... 300
This entry is the same if ABC merchandising is given a price reduction [allowance]
instead of returning the merchandise. In periodic system, the temporary purchase returns
and allowances account is used to accumulate the cost of all returns and allowances
transactions during a period.
(d) Transportation-in
ABC paid Birr 75 to transport the merchandise to its store on the date of purchase. The
entry will be as follows:
10
1992 Freight-in 75
Sene 20 Cash 75
(e) Sales
ABC sold merchandise on credit basis for Birr 1,400 on Hamle 1, 1992. The cost of this
merchandise is Birr 1000. The terms of sales is 2/10, n/30. The journal entry will be:
1992 Accounts receivable ……………….1, 400
Hamle 1 Sales ……………………… 1,400
Under the periodic system the cost of goods sold is not recorded at the time of sales.
(f) Sales returns
A customer returned part of the merchandise sold in (e) above on Hamle 5, 1992. The
returned items sell for Birr 600 and the cost of this item is Birr 400. The journal entry to
record this transaction is:
1992 Sales returns and allowances ……….. 600
Hamle 5 Accounts receivable …………. 600
The periodic system records only the revenue reduction.
Perpetual inventory system
A perpetual book inventory system refers to a system of inventory taking and information
gathering on a continuous or ongoing basis using various accounting records to compute
stock on hand at any given time. The purchase and sales figures needed to calculate stock
on hand are derived from internal accounting records that must be kept current if the
computed book inventory is to correctly reflect the seller's true stock position. To
summarize it, a perpetual book inventory represents an up-to-then minute,-date, or-week
accounting system in which all transactions that affect inventory are considered as they
occur or shortly thereafter. Its major advantage is that the seller can determine stock on
hand as required by operating conditions and the need for inventory information.
A perpetual book inventory system for unit control involves continuous recoding of all
transactions (number of units sold or purchased), which changes the unit status of the
seller's merchandise inventory. Each unit transaction is posted as it occurs or shortly
thereafter (on daily basis). Perpetual unit control provides
In perpetual inventory systems, each purchase, purchase return and allowance, purchase
discount, and transportation-in transaction is recorded in the merchandise inventory
account. This means any change made on merchandise is immediately shown on the
merchandise inventory account. The cost of goods sold account is opened to record all
cost of items sold on the date of sales. Under perpetual system, the Merchandise
Inventory account shows the correct balance of goods available for sales on any date.
The following example will explain the recording process of transactions in a general
journal form using the perpetual inventory systems. The transactions are copies of the
transactions you have seen in the earlier example. Try to compare how the recording
process differ and make a note of it.
(a) Purchases:
ABC merchandising firm purchases goods for reselling purpose for Birr 1,200 on credit
on Sene 20, 1992. The terms of purchases are 2/10, n/30. The journal entry will be:
Sene 20 Merchandise inventory …………….. 1,200
Accounts payable …………………..1,200
The perpetual system does not use a temporary purchases account. Rather it will record
the cost of items purchased on the merchandise inventory account directly.
(b) Purchase discounts:
11
ABC merchandising paid the supplier for the above purchase in (a) on Sene 30, 1992.
The required payment is Birr 1,176 (1200 x 98%) and is recorded as:
1992 Accounts payable ………………..1,200
Sene 30 Merchandise inventory ……… 24
Cash …………………………… 1,176
The perpetual system uses the merchandise inventory account itself to record the
purchase discounts taken on purchase transactions during the period. If payment is
delayed until after the discount period [10 days] expires, the entry is to debit the accounts
payable and credit cash for Birr 1,200.
(c) Purchase returns and allowances
ABC returned goods purchased on (a) above because of defects on Hamle 2, 1992. The
cost of defects is Birr 300 (net of the discount). ABC records the return as:
1992 Accounts payable ………………… 300
Hamle 2 Merchandise inventory ……... 300
The above entry [1992 Hamle 2] is the same if ABC merchandising is given a price
reduction [allowance] instead of returning the merchandise. In perpetual system, the
temporary purchase returns and allowances account is not needed. The merchandise
inventory account will be reduced for the return and allowance amount during a period.
(d) Transportation-in
ABC paid Birr 75 to transport the merchandise to its store on the date of purchase. The
entry will be as follows:
1992 Merchandise inventory 75
Sene 20 Cash 75
In perpetual system, the transportation-in cost is charged to the merchandise inventory
account since it is part of the cost of goods purchased.
(e) Sales
ABC sold merchandise on credit basis for Birr 1,400 on Hamle 1, 1992. The cost of this
merchandise is Birr 1000. The terms of sales is 2/10, n/30. The journal entry will be:
1992 Accounts receivable ……………….1, 400
Hamle 1 Sales ……………………… 1,400
You can see that the perpetual system keeps the end inventory balance continuously
updated whenever there is a change in the inventory due to purchases or sales
14
transactions. As it is indicated in the above ledger card, there may be a need to use more
than one line to update the record. In FIFO method, it is not possible to mix up the unit
costs since we are not using average figures. The unit costs appear in the ledger card. The
concept of FIFO is applied in the perpetual system and periodic system strictly.
The method assumes that inventory flows in the reverse order of expenditure
made. That means the item purchased recently must be sold before selling items from the
earlier purchase. For example, if ABC Company purchased 400 units at Birr 3 each on
Sene 3, 1992 and 300 units at Birr 4 each on Sene 6, ABC must sell all the 300 units
before it sells any item from the 400 units. This is the assumption in the LIFO method. If
200 units are sold from the total purchases of the 700 units [400 + 300], it is assumed that
these units are from the 300 units. Thus, the cost of sales will be Birr 800 [200 units
@Birr 4].
Consider the following data to further illustrate how the LIFO method works.
[The same data were used to illustrate the FIFO method. You may compare and contrast
as you proceed with the illustration. This will assist you to understand the two methods
properly.]
Date Purchases Sold units Balance in units
Sene 10, 1992 4,000 units @Birr 6 no sales 4,000 units
Sene 15, 1992 8,000 units @Birr 8 no sales 12,000 units [4,000 + 8,000]
Sene 20, 1992 no purchases 6,000 units 6,000 units [12,000 – 6,000]
Sene 25, 1992 3,000 units @Birr 9 no sales 9,000 units [6,000 + 3,000]
Assume that these are the only transactions regarding purchases and sales during Sene.
How much is the cost of end inventory on Sene 30,1992 and the cost of goods sold during
Sene 1992 using the LIFO cost flow assumption under the periodic and the perpetual
inventory systems?
Under periodic inventory system, the end inventory is counted at the end of the period
and will be valued using the unit costs. In the example above, the end period is Sene 30,
1992. On this date, the end inventory in units is 9,000 units [assume there is no loss or
damage]. The cost of these units shall be the earliest cost. Therefore, the cost of the 9,000
units will be:
The earliest purchase [Sene 10] = 4,000 units @ Birr 6 = Birr 24,000
The next earliest purchase [Sene 15] = 5,000 units @ Birr 8 = Birr 40,000
Total cost of the end inventory is …………………… Birr 64,000
The total cost of goods available for sales is Birr 115,000 = [(4,000 x 6) + (8,000 x 8) +
(3,000 x 9)]. The total cost of goods available for sales will not differ from the FIFO
method. Thus, the cost of goods sold will be the total cost of goods available for sales
minus the end inventory balance, i.e., Birr 115,000 – Birr 64,000 = Birr 51,000. This
amount can be computed using the unit cost data as follows:
(1) The cost of goods sold from the most recent purchase [Sene 25]=3,000x9=Birr 27,000
(2) The cost of goods sold for the next recent purchase [Sene 15]=3,000x 8 = Birr 24,000
The total cost of goods sold during Sene 1992 [(1) + (2)]…………………….Birr 51,000
15
Under perpetual inventory system, we have seen that the inventory account is updated
whenever there is a change due to either purchases or sales transactions. For each item, there
is a subsidiary ledger that shows the changes made [decreases and increases] and the account
balance continuously. The following will be the ledger card for the above example using the
LIFO method of cost flow assumption. Compare how each transaction is recorded in the
ledger card here and the record using the FIFO method, which is done earlier.
Under the FIFO method, the end inventory balance and the cost of goods sold
figure is the same in both the periodic and perpetual inventory systems. [Check the
figures for your self]. But this is not the case for LIFO method. The cost of goods sold
figure is Birr 51,000 under the periodic inventory system and Birr 48,000 under the
perpetual system. The cost of end inventory is Birr 64,000 under the periodic system and
Birr 67,000 under the perpetual system. This difference is because of inconsistency in
applying the LIFO cost flow assumption. In perpetual system, you do not wait until the
end of the fiscal period to assign the cost to the cost of goods sold and the end inventory.
Rather you have to use the recent unit cost data available on the date the change occurred
on the inventory balance.
LIFO method is not recommended in companies dealing with perishable items
[items that will be spoiled within a short period of time]. For such items the FIFO method
is most appropriate to match the cost with the revenue generated. Some companies may
not want to consider such a strict cost flow. They prefer to use the average method since
there is no as such corresponding cost flow for physical movement of inventories.
The Weighted Average (WA) method
16
In this method there is no need to worry about how cost flows and physical flows
of inventories are related. This method suggests using a single unit cost in assigning cost
to cost of goods sold and ending inventory. When this method is coupled with the
periodic inventory system, there is only one unit cost to be computed for the fiscal period.
When it is used in combination with the perpetual inventory system, the average unit cost
will be computed whenever there is a purchase transaction. In such situation, there is no
single unit cost. Rather, the unit cost will move and hence the method is called the
moving average method.
The unit cost is computed not by taking a simple average [i.e. the sum of unit costs
divided by the frequency]. This is not correct! Individual unit costs must be weighted by
the total quantities purchased.
Let us consider the following example. [This example is used in the FIFO and
LIFO methods. It is reproduced for comparison purpose].
ABC Company purchased 400 units at Birr 3 each on Sene 3, 1992 and 300 units
at Birr 4 each on Sene 6, and it may sell any combination of the two purchases from the
total units available for sales. There is no cost flow assumption that corresponds with the
physical flow. If 200 units are sold from the total purchases of the 700 units [400 + 300],
it is assumed that these units are from the total mix of the 700 units. Thus, the cost of
sales will be computed using an average unit cost. The average unit cost is not Birr 3.5
[Birr 3 plus Birr 4 then divided by 2]. The average unit cost will be computed as follows:
Average unit cost = Total cost of goods available for sales.
Total quantity available for sales
= Birr (400 x 3) + (300 x 4)
400 units + 300 units
= Birr 2,400 Birr 3.43
700 units
Therefore, the cost of goods sold will be Birr 686 [Birr 3.43 x 200 units].
Consider the following data to further illustrate how the weighted average method works.
[The same data were used to illustrate the FIFO & LIFO methods. You may compare and
contrast as you proceed with the illustration. This will assist you to understand the three
methods properly.]
Date Purchases Sold units Balance in units
Sene 10, 1992 4,000 units @Birr 6 no sales 4,000 units
Sene 15, 1992 8,000 units @Birr 8 no sales 12,000 units [4,000 + 8,000]
Sene 20, 1992 no purchases 6,000 units 6,000 units [12,000 – 6,000]
Sene 25, 1992 3,000 units @Birr 9 no sales 9,000 units [6,000 + 3,000]
Assume that these are the only transactions regarding purchases and sales during Sene. If
ABC prefers to use the average method, how much is the cost of end inventory on Sene
30,1992 and the cost of goods sold during Sene 1992 [using the average method] under
the periodic and the perpetual inventory systems?
Under periodic inventory system, the end inventory is counted at the end of the
period and will be valued using a single average unit cost. In the example above, the end
period is Sene 30, 1992. On this date, the end inventory in units is 9,000 units [assume
there is no loss or damage]. The cost of these units shall be the average unit cost
multiplied by 9,000 units. Therefore, the unit cost must be computed first i.e,
*Unit costs are used to determine the cost of goods sold amount, not for the end
balance. The end balance is always the remainder amount. The unit costs are
computed as follows:
- On Sene 10, the average unit cost is Birr 6 since we have only one purchase.
- On Sene 15, Average unit cost = (Birr 24,000 + Birr 64,000)
4,000 units + 8,000 units
- On Sene 20, there is no purchase. So the unit cost will not change.
- On Sene 25, Average Unit cost = (Birr 44,020 + Birr 27,000)
6,000 units + 3,000 units
There are rounding made and check for your self.
You can see that in the perpetual system the unit costs move in the direction of actual
costs incurred. The cost of goods sold and end inventory balance are different compared
to the periodic system, as the unit cost used is not the same. If the actual cost increases
from time to time, the average cost also increases [as it is in the example]. If the actual
cost decreases from time to time, the average cost moves downwards. The average unit
18
cost will be computed whenever new purchases are made. As it is indicated in the above
ledger card, there is no need to use more than one line to show the end balance. This will
save space and avoids possible errors of recording on the ledger card.
FIFO will yield the lowest amount for the cost of merchandise sold, and the highest
amount of gross profit (net income). And it also provides the highest amount of inventory
that is reported in balance sheet.
On the other hand LIFO yields the highest cost of goods (merchandise) sold and lowest
gross profit. It also yields lowest inventory reported n the balance sheet. The average cost
method yields result that is between the two methods (i.e. between FIFO and LIFO).
The uses of three cost flow assumptions are revised under the inflation and deflation period as follows:
At a time of inflation, most portions of the gross profits is from sale of the inventory is
attributed to inflation effects, and are referred as inventory profits or illusory profits.
o The major criticism in FIFO method is that it has a tendency to maximize the
effect of inflation and defilation trends on amounts reported as gross profit.
o But the advantage of FIFO method is that the merchandise reported in inventory
on the balance sheet is usually at about the same as the current replacement cost.
o The major criticism on LIFO is that the birr amount reported for merchandise
inventory in balance sheet may be quit far from the current replacement cost.
o But those organizations which use LIFO usually disclose or attach a note to the
financial statement stating the difference between LIFO inventory amount and the
inventory amount if FIFO had been used.
LIFO provides tax advantage in the inflationary periods because most recent costs will
be included in the cost of good sold, and as a result the revenues are in effect matched
against current costs and the gross profit is low in relation to FIFO.
Average cost method compromises between FIFO and LIFO. The effect of price trend is
averaged, both in cost of good sold or cost of inventory. Weather in deflation or inflation
period, average costing method provides the same cost.
Valuation of inventory by other method than cost
19
So far inventories have been valued at cost which is the purchase price of merchandise..
Under certain circumstance, however, inventory is valued at other than cost. Two
commonly identified circumstances arise when:
For example:
1. When the cost of replacing the item is below recorded cost.
2. When the inventory is not salable at normal price because of imperfection,
style change, shops wear …etc.
If the replacement price of an item in the inventory is lower than its cost, the use of
the lower of cost or market method provides two advantages:
a. The gross profit (and net income) are reduced for the period in which the
decline occurred and,
b. An approximately normal gross profit is realized during the period in which
the item is sold.
Example:
Assume The sales price is Br 100.00
The cost of inventory is 70.00
Gross profit 30.00 30% of sales price
Assume the market price has declined to Br 60.00, if the costs of inventory declines,
the sales price will also declines.
Assume the sales price has become Br 90.00:
20
Gross profit 20.00 which is less by Br 7.00
because of market price decrease in the previous period. But matching states all cost
or expense of the period must be matched against the period’s revenue.
Thus it is important to identify a decrease in inventory if market is less than cost and
adjust the inventory to the market value in the period the decline occurred.
Example:
Description Total
Quantity UnitCost Unitmarket Cost Lower of cost
Price Price or Market
Commodity A 400 Br 10.25 Br 9.50 Br 4,100.00 Br 3,800.00
B 120 22.50 24.10 2,700.00 2,700.00
C 600 8.00 7.75 4,800.00 4,650.00
D 280 14.00 14.00 3,920.00 3,920.00
Total 15,520.00 15,070.00
Thus the decline in the cost that is Br 15,520.00 -15,070.00 = Br 450.00 will either be
included in cost of good sold, to reduce the gross profit, or it could be reported as
administration expenses reported separately.
1. Cost of Good Sole Br 450.00
Inventory Br 450.00
2. Unrealized Loss Br 450.00
Inventory Br 450.00
1. Valuation at Net Realizable Value
Obsolete, damaged, spoiled Merchandises and other merchandise that can be sold
only at a price below cost should be valued at net realizable value. For this purpose,
net realizable value is the estimated selling price less any direct cost of disposition,
such as sales commissions.
Net Realizable Value = Estimated sales value – Any direct cost to sell this
merchandises
Example:
Assume that damaged merchandises, which have a selling value of Br 1,500.00, could be
sold at Br 800.00 and to sell these proud we have direct expense (transportation,
brokerage fee, and the likes) of Br 150.00. Thus the inventory should be valued at Net
Realizable value (NRV).
NRV= Br 800.00- 150.00 =Br 650.00
Presentation of Merchandise inventory in the balance sheet
Merchandise inventory is usually reported next to receivable. Both the method of
determining the method of identifying the cost (Cost or Lower or Cost) and inventory
method (FIFO, LIFO, Average) should be stated either in parenthesis in the balance sheet
it self or we could attach a note to the financial statement.
Afro –Arts Company
21
Balance Sheet
December 31,2002
Current Asset
Cash Br 19,400.00
Account Receivable Br 80,000.00
Less: Allowance for Doubt full accounts 3,000.00 77,000.00
Merchandise inventory – at lower of cost (FIFO) or Market 216,300.00
An enterprise could have various costing method and inventory method, like LIFO for
one type of merchandise inventory (Commodity Y) and anther FIFO for the other
(Commodity X). In such cases a note will be attached stating the costing method, and
inventory method for each segment of inventory, separately.
22
This method is used mostly by department stores. Its main advantage is it will provide
inventory figure for use in preparing interim statements (With in the accounting
period statement).
This method could also be used in periodic inventory system to identify the cost of
inventory. This is done, when physical inventory is done, inventories will be recorded
at their retail price and to convert these inventories stated at retail we will multiply it
by the cost %age.
Example
If physical inventory taken on December 31, totaled Br 29,000.00, priced at retail, it
would be converted to cost rather than the above 30,000.00 Br, therefore,
29,000.00 X 62% = Br 17,980.00 which will be reported on the year-end
financial statement.
Gross profit method of estimating inventories
The gross profit method uses an estimate of the gross profit realized during the period
to estimate the inventory at the end of the period. By using the rate of gross profit, the
dollar amount of sales for a period can be divided in to its two components
1. Gross profit and
2. Cost of merchandise sold
The latter may then be deducted from cost of merchandise available for sale to yield
the estimated inventory of merchandise on hand.
Example:
Assume that the inventory on January 01 is Br 57,000.00, that net purchases during
the month are Br 180,000.00, that net sales during the month are Br 250,000.00, and
finally that the gross profit is estimated to be 30% of net sales. The inventory on
January 31 may be estimated as follows:
Merchandise inventory on January 01 Br 57,000.00
Purchase in January 180,000.00
Merchandise available for sale 237,000.00
Sales in January (net) 250,000.00
Less: estimated gross profit (250,000.00 * 30%) 75,000.00
Estimated cost of merchandise sold 175,000.00
Estimated merchandise inventory, Jan. 31 62,000.00
Inventories estimated in this manner are useful in preparing interim statements, and is
also useful in establishing an estimate of the cost of merchandise destroyed by fire or
other disaster.
23
Exercise-1
A list of error is shown below:
Exercise 3- Information:
Year Net Income per books Error in Ending
Inventory
Required: Assuming that no corrections were made in any year, compute the correct
income for 1993 and 1994.
Exercise-5- Indicate the effect of the following errors on cost of goods sold and
Accounts payable.
24
Error CGS Effect on
Account payable
aa) Ending Inventory is overstated because
of a miscount
b) Merchandise received was not recorded in the
purchase account but it was included in the
physical count.
c) Merchandise shipped FOB shipping point was
not
included in purchases or the ending physical
count
Exercise-6- Novel Company reported Br. 140, 000 of inventory on December 31,
2002, based on a physical count. Additional information:
a) Included in the physical count were machines billed to a costumer FOB shipping
point on December 31, 2002. These machines had a cost of Br., 6,000 and had
been billed at Br. 10, 000. The shipment was on Novel loading dock waiting to
be picked by the carrier.
b) Goods were in transit from a vendor to Novel. The invoice cost was Br. 16, 000
and the goods were shipped FOB shipping point on December 29, 2002.
c) Goods out on consignment amount to Br. 9, 200 (Sales price) shipping costs, Br.
240. (Gross margin is 15% on cost)
Required:
Compute the correct amount of ending Inventory for Novel Company.
Exercise-7- The Company had the following inventory transactions in 2003:
Date Transactions Units Cost per Unit
Jan 1, 2003 Balance 50 Br. 30
Feb 14 Sale 25
May 23 Purchase 100 Br. 40
Aug. 21 Sale 50
Nov. 5 Purchase 25 Br. 60
Nov. 18 Sale 95
Required: Compute the cost of good sold and the ending inventory using the following
systems:
a. FIFO Periodic
b. FIFO Perpetual
c. LIFO Periodic
d. LIFO Perpetual
e. Weighted average
f. Moving average
Exercise-8
Jan 1. Beginning Inventory 180 Units at Br. 40 each
Purchase:
Jan. 7 120 Units at Br. 50 each
Jan. 17 100 Units at Br. 60 each
Sales:
Jan. 10 140 Units
Jan.19 40 Units.
25
Required: Compute the cost of the inventory and cost of goods sold at the end of
January under the following alternatives:
a. FIFO periodic
b. FIFO Perpetual
c. LIFO Periodic
d. LIFO Perpetual
e. Weighted Average
f. Moving average
Exercise-9- On January 1 the Bea Company began business with the purchase of 250
Units of inventory for Br. 225, 000. During the month Bea had the following inventory
transactions.
Date
Janu-6- purchased 50 Units at Br. 1, 000 per Units.
11. Sold 220untis
17. Sold 60 units.
24. Purchase 80 units at Br. 1,250 per unit.
28. Sold 80 units
30. Purchased 200 units at Br. 1,100 per unit
Required: Compute the cost of goods sold and cost of the inventory at the end of
inventory at the end of January under the following inventory costing methods.
Exercise-11
26
Central Company began operations in 2003 by Selling a single product. Data on
purchases and sales for the year were as follows:
Purchases:
Units purchased
Unit Cost Total Cost
Date
April 10 6, 000 Br. 20. 00 Br. 120, 000
May 10 6, 000 24. 00 144, 000
June 8 6, 000 28.00 168, 000
July 12 6, 000 28.50 171, 000
Sept. 10 2, 000 30.20 60, 000
Oct. 12 2, 000 31.00 62, 000
Nov. 9 1, 200 32.00 38, 400
Dec. 11 1, 200 34.00 40, 000
30, 400
Sales
Exercise-12
Consider the following data for ABC trading company for the month ended Sene 30,
1993. [This data are copied from Activity 6. You need to compare the answer of this
activity with that of Activities 6 and 7].
27
Date Purchases Sold units
Sene 1, 1993 2,000 units @Birr 16 no sales
Sene 5, 1993 3,000 units @Birr 18 no sales
Sene 12, 1993 no purchases 4,000 units
Sene 20, 1993 3,000 units @Birr 19 no sales
Sene 27, 1993 no purchases 2,000 units
Required:
[1] Compute the cost of end inventory in units and in Birr using Weighted Average
method under periodic inventory system.
[2] Prepare the ledger card that shows the movement of units and account balance using
Weighted Average method under perpetual inventory system.
Exercise-13
ABC Company uses a periodic inventory system and had the following beginning
inventory and purchases during the month Hamle, 1992 for item X.
Date Units unit cost
Hamle 1,1992 Beginning inventory 400 Birr 14
Hamle 10, 1992 Purchases 200 Birr 15
Hamle 19, 1992 Purchases 300 Birr 16
Hamle 22, 1992 Purchases 250 Birr 20
Hamle 28, 1992 Purchases 100 Birr 21
As of Hamle 30, 1992, there were 550 units of X on hand. Sale of units were as follows:
Hamle 12, 1992 200 units at Birr 30
Hamle 20, 1992 200 units at Birr 30
Hamle 25, 1992 300 units at Birr 35
Required:
(1) Calculate the cost of goods available for sales and
(2) Under the periodic inventory systems, compute the cost of end inventory, cost
of goods sold, and the gross profit using:
[a] FIFO method
[b] LIFO method
[c] The weighted average method.
28