Question

In: Accounting

1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 60 $ 52 $ 3,120 Apr. 7 Purchase 140 54 7,560 Jul. 16 Purchase 210 57 11,970 Oct. 6 Purchase 120 58 6,960 530 $ 29,610 For the entire year, the company sells 450 units of inventory for $70 each.  

1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

Solutions

Expert Solution

STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC FIFO METHOD
RECIEPTS COST OF GOODS SOLD BALANCE
DATE UNITS RATE AMOUNT $ UNITS RATE AMOUNT $ UNITS RATE AMOUNT $
1-Jan 60 52 3120 60 52 3120
Purchasse
7-Apr 140 54 7560 140 54 7560
16-Jul 210 57 11970 210 57 11970
6-Oct 120 58 6960 40 58 2320 80 58 4640
TOTAL 530 29610 450 24970 80 4640
STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC LIFO METHOD
RECIEPTS COST OF GOODS SOLD BALANCE
DATE UNITS RATE AMOUNT $ UNITS RATE AMOUNT $ UNITS RATE AMOUNT $
1-Jan 60 52 3120 60 52 3120
Purchasse
7-Apr 140 54 7560 120 54 6480 20 54 1080
16-Jul 210 57 11970 210 57 11970
6-Oct 120 58 6960 120 58 6960
TOTAL 530 29610 450 25410 80 4200
FIFO LIFO
Ending inventory 4640 4200
Cost of goods sold 24970 25410
Sales revenue (450*70) 31500 31500
Gross Profit (Sales-COGS) 6530 6090

Related Solutions

Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3)During the year, TRC Corporation has the following inventory transactions.DateTransactionNumber of UnitsUnit CostTotal CostJan.1Beginning inventory52$44$2,288Apr.7Purchase132466,072Jul.16Purchase202499,898Oct.6Purchase112505,600498$23,858For the entire year, the company sells 432 units of inventory for $62 each.Exercise 6-4A Part 22. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 250 $ 5,000 March 5 Sale ($400 each) 15 March...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4,6-5) [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning Inventory 20 $215 $4,300 March 5 Sale ($330 each) 15 March 9 Purchase 10...
Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 152 $ 1,216 August 4 Sale ($185 each) 5 August...
Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit...
Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 156 $ 1,248 August 4 Sale ($205 each)...
Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit...
Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 152 $ 1,216 August 4 Sale ($185 each)...
Compute ending inventory, cost of goods sold, and gross profit.
My question: Assume the company uses three inventory pools instead of one. Compute ending inventory, cost of goods sold, and gross profit. (Round price index to 2 decimal places, e.g. 1.45 and final answers to 0 decimal places, e.g. 6,548.)   William’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, William adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category   Quantity  ...
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO,...
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO, LIFO, and weighted average assuming a perpetual inventory system is in place. Beginning Balance - 90 units at $11 March 3 - Purchase 300 units for $15 April 4 - Sell 240 units for $28 June 30 - Purchase 250 units for $18 August 16 - Sell 180 units for $30
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale   15 blank
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT