Inventory
Inventory
Inventory
(PAS 2)
Definition
PAS 2 defines inventories as assets:
● Produced and held for sale in the ordinary course of business
(finished goods inventory)
● In the process of production for such sale (work in process
inventory)
● In the form of materials or supplies to be consumed in production
(raw materials inventory)
● Purchased and held for resale in the ordinary course of business
(merchandise inventory)
2
Recognition
Inventories are recognized when they meet the definition of inventory
and they qualify for recognition as assets, such as when legal title is
obtained by the buyer from the seller.
3
1
Goods in Transit,
Freights
Goods in Transit
pertain to goods already shipped by the
seller but are not yet received by the buyer.
5
FOB Shipping Point
Ownership over the goods is transferred upon shipment.
The buyer records debit Purchases and credit Accounts
Payable upon shipment.
Ownership: Buyer
Other terms: FOB Seller; Cost, Insurance, & Freight (CIF); Free
alongside ship (FAS)
6
FOB Destination
Ownership over the goods is transferred only when the
buyer receives the goods.
The buyer records debit Purchases and credit Accounts
Payable when the goods are received.
Ownership: Seller
7
Freight Prepaid
the seller pays for the freight in advance before
shipment
Freight Collect
freight is not yet paid upon shipment. The carrier
collects shipping cost from the buyer upon
delivery
8
Illustration:
ABC Co. purchased goods with invoice price of P1,000 on account on
December 27, 20x1. The related shipping costs amounted to P10. The
seller shipped the goods on December 31, 20x1. The goods were
received on January 2, 20x2 and the account was settled on January 5,
20x2.
Dates to remember:
December 27, 20x1- The company purchased goods
December 31, 20x1- The goods were shipped
January 2, 20x2- The goods were received
January 5, 20x2- The account was settled
9
Illustration:
FOB Shipping point, freight collect
Dec. 31, Purchases 1,000
20x1
Accounts Payable 1,000
Jan. 2, Freight-in 10
20x2 Cash 10
Jan. 5, Accounts Payable 1,000
20x2 Cash 1,000
1,000 1,010 10
10
Illustration:
FOB Destination, freight prepaid
Dec. 31,
20x1 NO ENTRY
Jan. 2, Purchases 1,000
20x2 Accounts Payable 1,000
Jan. 5, Accounts Payable 1,000
20x2 Cash 1,000
1,000 1,000
11
Illustration:
FOB Shipping point, freight prepaid
Dec. 31, Purchases 1,000
20x1
Freight-in 10
Accounts Payable 1,010
Jan. 2,
20x2
NO ENTRY
1,000 1,010 10
12
Illustration:
FOB Destination, freight collect
Dec. 31,
20x1 NO ENTRY
Jan. 2, Purchases 1,000
20x2 Accounts Payable 990
Cash 10
Jan. 5, Accounts Payable 990
20x2 Cash 990
1,000 990
10
1,000
13
2
Ownership
Consigned Goods
Pertain to goods transferred by a consignor to a consignee who
will act as an agent of the consignor in trying to sell the goods.
Ownership: Consignor
Only a memo entry is normally used in recording the
consignment. Incidental costs of transferring consigned goods to
the consignee form part of the cost of the consigned goods.
Maintenance costs are charged as expenses.
15
Inventory Financing Agreements
Product Financing Agreement/ Goods
Sold with buyback Agreement
A seller sells inventory to a buyer but assumes an obligation to repurchase it at a later date.
This arrangement does not result to the transfer of control over the asset.
Ownership: Seller
Pledge of Inventory
A borrower uses its inventory as collateral security for a loan. This arrangement does not
result to the transfer of control over the asset.
Ownership: Debtor
16
Inventory Financing Agreements
Warehouse Financing
A third party holds the inventory and acts as the creditor’s agent. This arrangement does not
result to the transfer of control over the asset
Ownership: Debtor
Loan of Inventory
An entity borrows inventory from another entity to be replaced with the same kind of
inventory. This arrangement results to transfer of control over the asset.
Ownership: Borrower
17
Sale with Right of Return
The buyer normally recognizes goods purchased under a sale with right of return at the
time of sale.
Ownership: Buyer
18
Installment sale
An installment sale where the possession of the goods is transferred to the buyer but the seller
retains legal title solely to protect the collectability of the amount due is considered as a regular
sale.
Ownership: Buyer
20
Illustration:
Goods sold on an installment basis to XYZ Inc., title to the
goods is retained by ABC Co. until full payment is made.
XYZ Inc. took possession of the goods P750,000
Goods sold to Alpha Co. for which ABC Co. has signed an
agreement to repurchase the goods sold at a set price that
covers all costs related to the inventory 680,000
Goods sold where large returns are predictable 270,000
Goods received from Beta Co. for which an agreement as
signed requiring ABC Co. to replace such goods in the near 580,000
future
P1,260,000
21
3
Accounting for
Inventories
Perpetual Inventory
System
● The “Inventory” account is updated for each purchase and
sale of inventory.
● No physical count is needed in determining COGS and
ending inventory.
● “Cost of goods sold” is debited and “Inventory” is credited each
time a sale is made.
23
Periodic Inventory System
● The “Inventory” account is updated only when a physical count is
performed.
● No entry is made to recognize cost of goods sold when inventory is
sold.
Beginning inventory xx
Purchases xx
Add: Net purchases* xx
Add: Freight-in xx
Total goods available for sale xx
Less: Purchase returns, allowances and
Less: Ending inventory (physical count) (xx) discounts (xx)
Cost of goods sold xx Net purchases* xx
24
Periodic Inventory System
Inventory Inventory
Beg. Inventory COGS Beg. Inventory Purchase discounts
Net purchases Purchases Purchase returns
Sales Return Freight-in COGS
Sales return
Ending inventory
Ending inventory
25
Illustration:
Perpetual System Periodic System
1. The entity purchased goods worth P1,000 on account
Inventory P10,000 Purchases P10,000
Accounts Payable P10,000 Accounts Payable P10,000
2. The entity paid shipping costs of P1,000 on the purchase above
Inventory 1,000 Freight-in 1,000
Cash 1,000 Cash 1,000
3. The entity returned the damaged goods worth P2,000 to its supplier
Accounts Payable 2,000 Accounts Payable 2,000
Inventory 2,000 Purchase returns 2,000
4. The entity sold goods costing P5,000 for P20,000 on account
26
Illustration:
Perpetual System Periodic System
5. The entity purchased goods worth P1,000 on account
Sales Returns 800 Sales Returns 800
Accounts Receivable 800 Accounts Receivable 800
Inventory 200
NO ENTRY
Cost of goods sold 200
27
Illustration:
Solving for COGS using the Periodic Inventory System:
During the physical count, it was revealed that the inventory left amounted to 4,200
Purchases 10,000
Freight-in 1,000
TGAS 9,000
28
Measurement
Inventories are measured at the lower of cost and net realizable
value (NRV).
29
4
Cost
Cost
● The cost of inventories comprise all:
● Costs of purchase – include:
○ Purchase price
○ Import duties
○ Transport and handling costs (freight-in)
○ Other costs directly attributable to the acquisition of finished goods, materials and
services
● Discounts- Trade discounts, rebates and similar items are deducted in determining the
costs of purchase.
● Costs of conversion- include costs incurred directly in converting raw materials into
finished goods. Conversion costs include direct labor and variable and fixed production
overheads.
● Other costs – include only those incurred in bringing the inventories to their present
location and condition.
31
Cost
● The following costs should be excluded from cost of inventories and
recognized as expenses in the period in which they are incurred:
○ Selling costs (i.e. advertising, promotion costs, delivery expense or freight
out)
○ Abnormal amounts of wasted materials, labor or other production costs
○ Storage costs, unless those costs are necessary in the production
process
○ Administrative overheads
The cost of purchase does not include taxes paid which are subsequently recoverable
(i.e. VAT paid by VAT payers)
● Interest expense incurred on borrowings (borrowing costs) made to finance the
acquisition or production of an inventory that meets the definition of a
qualifying asset forms part of the cost of the inventory. All other interests are
charged as expenses.
32
Cost formulas
First-in, First-out (FIFO) cost formula
● This cost formula assumes that the items of inventory that
were purchased or produced first are sold first.
● Cost of goods sold represents costs from earlier purchases
while cost of ending inventory represents costs from the most
recent purchases.
● A unique characteristic of FIFO formula is that it yields the
same amounts of cost of goods sold and ending inventory
when applied in either a perpetual or periodic system.
33
Illustration:
Date Transaction Units Unit cost Total cost
1-Aug. Inventory 2,000 P36.00 P72,000
7 Purchase 3,000 37.20 111,600
12 Sales 4,200
13 Sales return 600
21 Purchase 4,800 38.00 182,400
22 Sales 3,800
29 Purchase 1,900 38.60 73,340
30 Purchase Return 300 38.60 (11,580)
Total goods available for sale P427,760
34
Illustration:
FIFO periodic
Beg. Inventory in units 2,000 TGAS in pesos 427,760
35
FIFO perpetual
Date Transaction Units Unit cost Total cost
1-Aug. Inventory 2,000 P36.00 72,000
7 Purchase 3,000 37.20 111,600
12 Net Sales (3,600)
Allocation:
From beg. Inventory 2,000 36.00 (72,000)
From Aug. 7 purchase 1,600 37.20 (59,520)
21 Purchase 4,800 38.00 182,400
22 Sales (3,800)
Allocation:
From Aug. 7 purchase 1,400 37.20 (52,080)
From Aug. 21 purchase 2,400 38.00 (91,200)
29 Net Purchase 1,600 38.60 61,760
Ending inventory at cost P152,960
37
Cost formulas
38
Illustration:
WAC= TGAS in pesos
TGAS in units Ending Inventory in units 4,000
= P37.52
TGAS at cost 427,760
Beg. Inventory in units 2,000 Ending Inventory at cost (150,080)
Net purchases in units 9,400 Cost of goods sold 277,680
TGAS in units *11,400
39
Cost formulas
Moving average- Perpetual
A new or moving weighted average cost is determined after every
purchase or as each shipment is received by dividing total goods
available for sale as of that date by the total quantity of goods available
for sale as of that date.
The moving average unit cost is then multiplied by the quantity of goods
sold after the latest purchase to determine cost of goods sold or by the
quantity of inventory on hand to determine ending inventory.
40
Illustration:
Date Transaction Units Unit cost Total cost
1-Aug. Inventory 2,000 P36.00 72,000
7 Purchase 3,000 37.20 111,600
Moving ave. unit cost (183,600/5,000) 5,000 36.72 183,600
12 Sales (4,200) 36.72 (154,224)
13 Sales return 600 36.72 22,032
21 Purchase 4,800 38.00 182,400
Moving ave. unit cost (233,808/6,200) 6,200 37,71 233,808
22 Sales (3,800) 37,71 (143,298)
29 Purchase 1,900 38.60 73,340
30 Purchase Return (300) 38.60 (11,580)
Ending inventory 4,000 P152,270
Discounts
Trade Discounts
● Given to encourage orders in large quantities.
● Do not form part of the cost of inventory; they are
directly deducted from the list price.
● They are not recorded in the books of buyer nor
seller.
43
Cash Discounts
● Given to encourage prompt payment.
● They are deducted from invoice price in order to determine the
amount of net payment required within the discount period.
● Accounted through either net method or gross method.
44
Accounting for Cash Discounts
Gross Method
● The cost of inventory and accounts payable are recorded gross of cash discounts.
● Purchase discounts are recorded under the “Purchase discounts” account only
when taken.
● Purchase discount is deducted from gross purchases when computing for net
purchases.
Net Method
● The cost of inventory and accounts payable are recorded net of cash discounts,
regardless of whether such discounts are taken or not.
● Purchase discounts not taken are recorded under the “Purchase discounts lost”
account and included as part of “other expenses” or as “finance cost” (interest
expense).
45
Illustration:
An entity purchases inventory with a list price of 10,000 on account under credit terms of 20%, 10%, 2/10, n/30.
46
6
Net Realizable
Value (NRV)
Net realizable value
(NRV)
Estimated selling price in the ordinary course of business
less the estimated costs of completion and the estimated
costs to sell.
48
Write-down to NRV
● In cases where NRV<Cost; the inventories may need to be written down
to their net realizable value.
● The excess of cost over NRV represents the amount of write-down. If
the cost of an inventory is lower than its NRV (NRV>Cost), no write-down
is necessary.
● Write-downs of inventories to NRV are normally charged to cost of
goods sold in the period of write-down. However, write-downs due to
abnormal losses are charged to loss.
49
Illustration:
ABC Co. buys and sells product A & B. The following unit costs are available for the inventory as
December 31, 20x1: (All costs are borne by ABC Co.)
Product A Product B
Number of units 2,000 3,000
Purchase cost per unit P100 P200
Delivery cost from supplier 20 30
Estimated selling price 150 250
Selling costs 22 40
General administrative 15 18
Requirements:
a. Determine the amount of write-down. Provide the adjusting entry.
b. Compute for the valuation of the inventories in ABC’s December 31, 20x1 statement of
financial position.
50
Illustration:
a.
Product A Product B
Cost:
Purchase cost per unit P100 P200
Delivery cost from supplier 20 30
Cost per unit 120 230
Net Realizable Value:
Estimated selling price 150 250
Selling costs (22) (40)
NRV per unit 128 210
Lower of cost and NRV 120 210
(cost) (NRV)
51
Illustration:
b.
Product A Product B
Lower of cost and NRV 120 210
Multiplied by: Number of 2,000 3,000
units
Inventory, Dec. 31, 20x1 240,000 630,000
52
Reversal of Write-downs
● When there is clear evidence of an increase in NRV
which was previously written down below cost, the
amount of write-down is reverted in profit or loss in the
period of such reversal so that the new carrying amount
is the lower of the cost and the revised NRV.
● However, the amount of reversal to be recognized
should not exceed the amount of the original write-
down previously recognized.
53
Illustration:
ABC Co. has the following comparative information regarding its inventories.
20x1 20x2
Cost 240,000 330,000
NRV 220,000 300,000
54
Illustration:
20x1 20x2
Cost 240,000 330,000
NRV 220,000 300,000
COGS before adjustments 2,000,000 1,800,000
55
Gets?
If you have questions, now is the best
time to raise them ☺
56
PRACTICE
PROBLEMS
Problem 1
The inventory records of BINI Co. on December 31, 20x1 shows a balance of 260,000. The following
information was also gathered:
a. Goods costing 10,000, purchased under FOB shipping point, were not included in the ledger
balance because these were still in transit as of December 31, 20x1. The supplier shipped the goods
on December 30, 20x1 and prepaid the freight of 1,000.
b. Goods costing 5,000 were received on December 31, 20x1. These were recorded on January 3,
20x2.
c. Goods costing 16,000 were shipped to a customer on December 31, 20x1 on an FOB shipping
point term. The goods were included in the ledger balance because the customer received the
shipment only on January 4, 20x2.
d. Goods costing 20,000 were shipped to a customer on December 31, 20x1 on an FOB Destination
term. The goods were not included in the balance because the goods were already dispatched
when the inventories were counted at 11pm on December 31, 20x1.
How much is the correct inventory of BINI Co. on December 31, 20x1?
a. 311,000 c. 280,000
b. 279,000 d. 312,000
58
Problem 1- Solution
c. 280,000
59
Problem 2
Information on Hercules Mulligan’s Hot Pants Co.’s inventories is shown below:
20x1 20x2
60
Problem 2- Solution
20x1
Cost 600,000
NRV 400,000
20x1 20x2
a. 200,000
61
Problem 3
62
Problem 3- Solution
d. 1,000
63
Problem 4
64
Problem 4- Solution
c. 33,000
65
7
Inventory
Estimation
Gross Profit Method
Gross profit is assumed to be relatively constant from period to
period. Thus, the gross profit is used to compute for the gross profit
rate (GPR) which in turn is used to determine the cost ratio.
The cost ratio is used in estimating the cost of inventory and cost of
goods sold
67
Gross Profit Rate
Gross profit rate can be expressed as a percentage
● Based on Sales
○ GPR is computed by dividing gross profit by the net sales
● Based on Cost of Goods Sold
○ GPR is computed by dividing gross profit by the cost of goods sold
68
Illustration:
1. If GPR based on cost is 25%, what is the GPR based on sales?
Net Sales (Squeeze) 125%
COGS (constant) (100%)
Gross profit rate based on cost (given) 25%
69
Cost Ratio
Cost ratio may be derived from the gross profit rate. The following may
provide guidance in deriving cost ratios from gross profit rates:
● Cost ratio from GPR based on sales = 100% Net Sales – GPR based on
Sales
● Cost ratio from GPR based on cost = 100% COGS / Net Sales
70
Illustration:
1. If GPR based on sales is 20%, what is the cost ratio?
Net Sales (constant) 100%
COGS (squeeze- cost ratio) (80%)
Gross profit rate based on sales (given) 20%
71
Net Sales
For the purpose of estimating inventory, only sales returns are deducted
from gross sales in computing for net sales.
72
Illustration: Gross profit based on sales
On October 1, 20x1, a flood destroyed the warehouse of ABC Co. and all the inventories contained therein. Off-site
back up of data base shows the following information:
73
Illustration:
Step 1: Compute for the net purchases using the Accounts Payable T-Account
Accounts Payable
74
Illustration:
Step 2: Extend the net purchases computed in step 1 to the inventory T account and squeeze for
the ending inventory
Inventory
75
Illustration:
The inventory loss due to flood is computed as follows:
76
Illustration: COGS
You were engaged to assist in reconstructing ABC Co.’s records after an operating system
crashed on August 1. ABC Co. does not have an established business continuity plan or a disaster
recovery program and only the following information has been determined:
77
Retail Method
The retail method is often used in the retail industry for measuring
large quantities of inventories with rapidly changing items for which
it is impracticable to use other costing methods.
78
Retail Method
The following are peculiar to the retail method:
79
Retail Method
The retail method is applied using either the:
1. Average cost method
2. FIFO cost method
3. Conservative cost method
80
Average cost method
Under this method, the TGAS at cost (beg. Inventory + net purchases) is
determined and divided by the TGAS at sales price/retail to come up with
the cost ratio
81
FIFO cost method
Similar to the Average cost method, the difference is that the beginning
inventories at cost and at retail are simply excluded from TGAS when
computing for the cost ratio.
82
Conservative cost method
Similar to the Average cost method, the difference is that any net
markdowns are excluded from TGAS at retail when computing for the cost
ratio.
83
Illustration:
Presented below is information pertaining to ABC Co.
Cost Retail
Inventory, Jan. 1 8,700 14,000
Purchases 55,300 80,300
Freight-in 2,000 -
Purchase Discounts 500 -
Purchase Returns 5,200 8,600
Departmental transfer in 1,000 1,500
Departmental transfer out 800 1,200
Markups 6,000
Markup cancellations 2,000
Markdowns 12,000
Markdown cancellations 3,000
Abnormal Spoilage 5,000 7,000
84
Illustration:
Presented below is information pertaining to ABC Co.
Cost Retail
Sales 43,800
Sales Return 2,500
Sales Discounts 1,000
Employee Discounts 500
Normal Spoilage 200
Compute for the (a) COGS and (b) Ending Inventory using:
1. Average cost method
2. FIFO cost method
3. Conservative cost method
85
Illustration:
Presented below is information pertaining to ABC Co.
Cost Retail
Inventory, Jan. 1 8,700 14,000
Net Purchases 55,300 80,300
Freight-in 2,000 -
Purchase Discounts (500) -
Purchase Returns (5,200) (8,600)
Departmental transfer in 1,000 1,500
Departmental transfer out (800) (1,200)
Net Markups (6k – 2k) 4,000
Net Markdowns (12k – 3k) (9,000)
Abnormal Spoilage (5,000) (7,000)
TGAS 55,500 74,000
86
Illustration:
Presented below is information pertaining to ABC Co.
Cost Retail
TGAS 55,500 74,000
Net Sales* (42,000)
Ending Inventory at retail 32,000
Sales 43,800
Sales Return (2,500)
Employee Discounts 500
Normal Spoilage 200
Net Sales* 42,000
87
Illustration:
Average cost method:
Cost ratio = 55,500
74,000
= 75%
Based on its general ledger, ABC Company reported inventory of P365,400 at the end of 2023. The
following items were included in the inventory total:
a. P31,500 worth of goods shipped by “Free Along Side” on December 31, 2023, and received by
ABC Co. on January 5, 2024.
b. Goods worth P12,400 ordered from a supplier on December 26, 2023, were shipped on
December 28 “Cost, Insurance and Freight” but had not arrived by Dec. 31, 2023.
c. P14,800 worth of goods ordered on December 25, 2023, were shipped to ABC Co. FOB ex-ship
on January 2,2024 and received on January 3, 2024.
d. A client ordered P21,600 worth of goods on December 27, 2023, which was dispatched FOB
seller on December 29, 2023, and received by the customer on January 5, 2024.
e. On December 29, 2023, goods worth P12,500 were shipped FOB Buyer to a client. The goods are
still on their way and the customer anticipates receiving them on January 5, 2024.
92
Problem 1
93
Problem 2
ABC Inc .is a retailer of Italian furniture and has five major product lines: sofas, dining tables,
beds, closets, and lounge chairs. On December 31, 2023, quantity on hand, cost per unit, and
net realizable value (NRV) per unit of the product lines are as follows:
Product line Quantity of hand Cost per unit NRV per unit
Sofas 100 50,000 51,000
Dining Tables 200 25,000 22,500
Beds 300 75,000 80,000
Closets 400 37,500 38,000
Lounge Chairs 500 12,500 10,000
Required: Compute the valuation of the inventory of ABC Inc. on December 31, 2023, under
PAS 2 using the LCNRV. Record the appropriate journal entries, as necessary.
94
Problem 2
LCNRV Write-down
Sofas 5,000,000 -
Dining Tables 4,500,000 500,000
Beds 22,500,000 -
Closets 15,000,000 -
Lounge Chairs 5,000,000 1,250,000
1,750,000
Journal Entry:
Cost of Goods Sold 1,750,000
Dining table 500,000
Lounge Chairs 1,250,000
95
Problem 3
96
Problem 3
2023:
Cost 3,600,000
NRV (3,000,000)
Write-down 600,000
2024:
NRV 2024 4,600,000
NRV 20243 (3,000,000)
Reversal 1,600,000
*Limit (Prev. WD) 600,000
97
Problem 4
The following information was available from the inventory records of ABC Company for
January:
Units Unit Cost Total Cost
Bal. on Jan. 1 3,000 9.77 29,310
Purchases:
Jan. 6 2,000 10.30 20,600
Jan. 26 2,700 10.71 28,917
Sales:
Jan. 7 (2,500)
Jan. 31 (4,000)
Bal. on Jan. 31 1,200
98
Problem 4
Sales:
1/7 2,500 x 9.77 = 24,425
1/31 500 x 9.77 = 4,885
2,000 x 10.30 = 20,600
1,500 x 10.71 = 16,065
6,500 65,975 COGS
(78,827) TGAS
12,852 End. Inv
99
Problem 4
TGAS 78,827
COGS (Squeeze) (65,975)
Ending Inventory 12,852
100
Problem 4
C. Weighted Average
101
Problem 4
D. Moving Average
Units Unit Cost Total Cost
Jan. 1 3,000 9.77 29,310
Jan. 6 2,000 10.30 20,600
5,000 9.98 49,910
Jan. 7 (2,500) 9.98 (24,950)
2,500 24,960
Jan. 26 2,700 10.71 28,917
5,200 10.36 53,877
Jan. 31 (4,000) 10.36 (41,440)
Balance Jan. 31 1,200 12,437
102
Problem 5
Cost Retail
Beginning inventory P650,000 P1,200,000
Purchases 9,000,000 14,700,000
Freight in 200,000
Purchase returns 300,000 500,000
Purchase allowances 150,000
Departmental transfer in 200,000 300,000
Net markups 300,000
Net markdowns 1,000,000
Sales 9,500,000
Sales discounts 100,000
Employee discounts 500,000
Estimated normal shoplifting losses 1,000,000
103
Problem 5
Cost Retail
Beginning inventory P650,000 P1,200,000
Purchases 9,000,000 14,700,000
Freight in 200,000
Purchase returns (300,000) (500,000)
Purchase allowances (150,000)
Departmental transfer in 200,000 300,000
Net markups 300,000
Net markdowns (1,000,000)
TGAS 9,600,000 15,000,000
104
Problem 5
Cost Retail
TGAS 9,600,000 15,000,000
Net Sales* (11,000,000)
Ending Inventory at retail 4,000,000
Sales 9,500,000
Employee Discounts 500,000
Normal Loss 1,00,000
Net Sales* 11,000,000
105
Illustration:
Average cost method:
Cost ratio = 9,600,000
15,000,000
= 64%
109