0% found this document useful (0 votes)
82 views4 pages

Comparative Analysis of Inventory Methods

This document contains exercises and problems related to accounting for inventories. It includes questions about inventory costing methods like FIFO, LIFO, weighted average and specific identification. It asks students to calculate ending inventory values and costs of goods sold for a variety of scenarios using both perpetual and periodic inventory systems. Students are asked to apply the lower of cost or net realizable value rule to inventory valuation and discuss its purpose.

Uploaded by

Shynia Chand
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
82 views4 pages

Comparative Analysis of Inventory Methods

This document contains exercises and problems related to accounting for inventories. It includes questions about inventory costing methods like FIFO, LIFO, weighted average and specific identification. It asks students to calculate ending inventory values and costs of goods sold for a variety of scenarios using both perpetual and periodic inventory systems. Students are asked to apply the lower of cost or net realizable value rule to inventory valuation and discuss its purpose.

Uploaded by

Shynia Chand
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Week 8 Tutorials

Chapter 6: Accounting for retailing


1. What is the meaning of the terms DPP and EXW? Discuss the impact of such terms on
the buyer’s and seller’s accounting system. Provide an example to illustrate.

2. The perpetual inventory system is superior to the periodic system. Discuss.

Problem 6.17
Journal entries, discounts, closing entries and income statements — both perpetual and
periodic inventory systems
GST version

Clara’s Chairs buys chairs for $80 each and sells them for $140 each. On 1 August 2022,
86 chairs were in inventory. Clara’s Chairs completed the transactions below during August.

A physical inventory count taken on 31 August 2022 showed 63 chairs in stock.

Required
(a) In two columns and assume the business is registered for the GST, prepare general
journal entries to record the transactions assuming:
i. a perpetual inventory system is used
ii. a periodic inventory system is used. Narrations are not required.
(b) Assuming Clara’s Chairs closes its accounts at month end; prepare relevant entries to
close the accounts under both inventory systems.
(c) Prepare two separate income statements showing gross profit and profit for August,
assuming that:
i. the perpetual inventory system was used
ii. the periodic inventory system was used.
(LO3, LO4, LO5 and LO6)

1
Chapter 13: Inventories
1. Must a company use the inventory costing method that best conforms to the actual
physical movement of the goods? Explain.

2. Why is the lower of cost and net realisable value rule required by accounting standards?
Is it permissible to revalue inventories upwards? If so, when? Are there any limits to
revaluation?

Exercise 13.3

Lower of cost and net realisable value

The inventory of Simmonds Ltd contains the following packs of nuts and bolts at 30 June 2022.

Unit Price

Quantity of Cost per


NRV
Inventory Item units unit

Item #1254 113 $3.50 $3.00

Item #7231 45 4.95 6.95

Item #8853 30 9.95 8.50

Item #7699 75 2.95 3.95

Item #3420 60 7.95 6.95

Item #6588 25 9.95 8.50

Required

(a) Determine the ending inventory value at 30 June 2022, applying the lower of cost and net
realisable value rule to the individual items.
(b) What effect did application of the rule, rather than cost, have on the financial statements of the
company?
(LO5)

2
Exercise 13.5

Inventory cost methods — perpetual inventory system

GST version

The following information relates to the inventory of the Lighting Warehouse Ltd during the month of
August: (Note, purchases are GST Inclusive)

August 1 Beginning Inventory 60 units @ $11

12 Purchased 90 @ $13.20

15 Sold 80 units

21 Purchased 120 @ $14.30

22 Sold 100 units

28 Sold 65 units

Lighting Warehouse Ltd uses the perpetual inventory method of accounting for inventory. Ignore GST.

Required

Determine the cost of the ending inventory. Note a phusical stocktake verified inventory records
reflected ending stock levels. The manager of Lighting Warehouse Ltd is evaluating inventory
valuation methods and is seeking your assistance to calculate the value of closing inventory and cost
of goods sold for each of the following methods:

(a) FIFO
(b) LIFO
(c) Moving average; note, round unit cost to the nearest cent.
(d) Specific identification – records identified the ending inventory consisted of 5 units
from beginning inventory, 12 units from the purchase on 12 August and the remaining
from the purchase on 21 August.
(LO3)

3
Exercise 13.6

FIFO and average cost flow methods — periodic and perpetual inventory systems

GST version
Steele Security Systems Ltd sells home security and surveillance systems. The table below
summarises the inventory movements for the most popular model of camera used in their home
security systems. (All purchases of inventory are GST Inclusive)

July 1 Beginning Inventory 55 @ $250 = $ 13 750

Aug. 15 Sales 40

Sept. 2 Purchases 90 @ $280.50 = 25 245

Nov. 10 Sales 35

Dec. 19 Sales 25

Feb. 21 Purchases 85 @ $282.70= 24 029.50

Mar. 28 Sales 42

May 31 Sales 55

Required
(a) Using the weighted average costing method for periodic inventory, calculate the cost of
sales and closing value of inventory to be presented in the financial reports for the year
ended 30 June 2023.
(b) Using the moving average method costing inventory under perpetual inventory, calculate
the cost of sales and closing value of inventory to be presented in the financial reports for
the year ended 30 June 2023.
(c) Using a periodic system and the FIFO method of valuing inventory, calculate the cost of
sales and closing inventory to be presented in the financial reports for the year ended 30
June 2023.
(d) Using a perpetual system and the FIFO method of valuing inventory, calculate the cost
of sales and closing inventory to be presented in the financial reports for the year ended
30 June 2023.
(e) Compare the results generated for the inventory valuation methods for the requirements
completed in (a), (b), (c) and (d) above. What are the main differences?

Common questions

Powered by AI

For Simmonds Ltd, applying the lower of cost and net realisable value rule could lead to a write-down of inventory for items where net realizable value is below cost, such as Item #1254 and Item #8853. This results in reduced asset values and potentially higher cost of goods sold, lowering net income for the period .

The weighted average method smooths out fluctuations in price over time, leading to averaged costs for inventory which reflect steady financial numbers. Conversely, FIFO reports higher profits in times of inflation because older, cheaper costs are the first to be expensed. Therefore, the choice influences reported profitability, tax liabilities, and perception of financial health .

The perpetual inventory system is regarded as superior because it maintains a continuous, real-time record of inventory levels and cost of goods sold, which improves accuracy in financial statements. In contrast, the periodic system only updates inventory levels at specific intervals, potentially leading to discrepancies or delays in financial reporting .

In a perpetual inventory system, the moving average method calculates a new average cost per unit after each purchase, resulting in regularly updated cost of goods sold and inventory valuations. Specific identification matches each unit of inventory with its specific cost, providing precise financial insight. Moving average smooths out purchase cost fluctuations but can over-simplify valuation, whereas specific identification provides higher accuracy suitable for unique items but is cumbersome for large quantities .

The FIFO method assumes earliest items purchased are sold first, leading to lower costs of goods sold and higher inventory values during inflation. LIFO, conversely, matches recent costs with revenue, resulting in higher costs of goods sold and lower ending inventory. The moving average smooths out price fluctuations by averaging costs, offering a middle ground. Specific identification assigns costs based on actual inventory use, best suited for unique items; it provides the most accurate matching of cost to revenue but is labor-intensive. For Lighting Warehouse Ltd, these methods will affect profitability and tax liability differently, influencing managerial decisions .

In periodic inventory systems, inventory records and cost of goods sold are updated at period end, potentially causing inaccuracies and delayed recognition of inventory changes. In contrast, perpetual systems allow for continuous tracking of inventory and immediate reflection of sales and purchases, providing more accurate and timely financial reporting for Clara’s Chairs, aiding better decision-making .

DPP means the seller delivers the goods to a destination address and bears the costs until the goods are at the designated place, impacting the seller's accounting system by reflecting higher shipping expenses, while EXW implies that the buyer bears the transportation costs from the seller’s premises, impacting the buyer’s accounting system by incurring additional logistics expenses. For example, if a company in Sydney orders goods with DPP from a supplier in Melbourne, the supplier's books will account for the delivery expenses, while, with EXW, the buying company in Sydney will record these costs instead .

The 'lower of cost and net realisable value' rule ensures that inventory is not overstated in financial statements by valuing it at the lower of its cost or estimated selling price minus costs to sell. The rule prevents overvaluation of assets but limits upward revaluation unless certain conditions, like market recovery or an updated assessment, justify it at year-end; revaluation typically cannot surpass the original purchase cost .

It is not necessary for a company to choose an inventory costing method that exactly mirrors actual physical movement. Accounting standards allow methods like FIFO, LIFO, and average costing which may not reflect physical flow but provide consistency and operational efficiency in financial reporting. The key is selecting a method that offers reliable and useful information, compliant with regulatory requirements .

Steele Security Systems Ltd's choice between methods like FIFO, LIFO, or weighted average significantly impacts reported profit margins, tax liabilities, and inventory valuations. FIFO may present higher profits in inflationary periods, affecting tax obligations and external perceptions of profitability. In contrast, LIFO can lower taxable income during such times. The weighted average offers a moderate approach. These choices influence managerial decisions regarding pricing, investment, and strategy, thus affecting stakeholder perceptions and financial health representations .

You might also like