Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AB AC AD W X Z AA Test Exercise 5 - Inventory Valuation During the year, Trombley Inc has the following inventory transactions: Date Transaction

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
AB AC AD W X Z AA Test Exercise 5 - Inventory Valuation During the year, Trombley Inc has the following inventory transactions: Date Transaction # of units Unit cost Total Cost 1/1 Beginning Inventory 20 $22 $440 3/4 Purchase Inventory 25 $21 $525 6/9 Purchase Inventory 30 $20 $600 11/11 Purchase Inventory 30 $18 $540 105 $2,105 For the entire year, the company sells 81 units of inventory for $30 each. Required: 1. Using FIFO, calculate cost of goods sold, ending inventory value, sales revenue and gross profit 2. Using LIFO, calculate cost of goods sold, ending inventory value, sales revenue and gross profit 3. Using Weighted average cost, calculate cost of goods sold, ending inventory value, sales revenue and gross profit 4. Determine which method will result in higher profitability when inventory costs are declining Requirement 1: FIFO of units Unit cost 20 S 22 Cost of Goods Sold Total Cost #units sold Unit Cost $440 25 $ 21 $525 Date Transaction 1/1 Beginning inv 1/1 Sell beginning inv 3/4 Purchase Inv 3/4 Sell purchased in 6/9 Purchase Inv 6/9 Sell purchased inv 11/11 Purchase Inv 11/11 Sell purchased in 30 S 20 $600 30 $ 18 $540 Total Inventory Sold: 0 $0 # of units Unit Cost Total Value 12/31 Ending Inventory Sales Revenue Cost of Goods Sold Gross Profit $0 Requirement 2: LIFO # of units Unit cost 22 Total Cost #units sold Unit Cost $440 Cost of Goods Sold 20 25 21 $525 Date Transaction 1/1 Beginning inv 1/1 Sell beginning inv 3/4 Purchase Inv 3/4 Sell purchased inv 6/9 Purchase Inv 6/9 Sell purchased in 11/11 Purchase Inv 11/11 Sell purchased inv 30 20 $600 30 18 $540 Total Inventory Sold: 0 $0 # of units Unit Cost Total Value 12/31 Ending Inventory Sales Revenue Cost of Goods Sold Gross Profit $0 Requirement 3: Weighted average cost Date Transaction # of units Unit cost 1/1 Beginning Inventory 20 $22 3/4 Purchase Inventory 25 $21 6/9 Purchase Inventory 30 $20 11/11 Purchase Inventory 30 $18 105 Weighted Average Cost: Total Cost $440 $525 $600 $540 $2,105 # of units Unit Cost Total Value 12/31 Ending Inventory Sales Revenue Cost of Goods Sold Gross Profit $0 Requirement 4: Which has higher profitability when inventory costs are declining? has higher profitability when inventory costs are declining

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Auditing And Assurance Services

Authors: Philomena Leung, Paul Coram, Barry J. Cooper, Peter Richardson

6th Edition

1118615247, 9781118615249

More Books

Students also viewed these Accounting questions

Question

Beta is a measure of firm-specific risk. true or false

Answered: 1 week ago

Question

What are the general types of interviews? Explain each.

Answered: 1 week ago

Question

6 How can HRM contribute to ethical management and sustainability?

Answered: 1 week ago