To the expert: I don't know what you mean by "more requirements, cut it"
The requirements are A, B C and D
LIFO =LAST IN FIRST OUT.
In lifo method the latest purchased goods are considered to be sold first.
unit purchase | Unit cost | Total cost | unit sold | CGS per unit | CGS | Inventory Balance | |
Beg. oldest | 1500 | 12 | 18000 | ||||
Beg. Next Oldest | 1700 |
14 |
23800 |
[18000+23800] 41,800 |
|||
purchase January 20 | 5500 | 16 | 88000 |
[41800+88000] 129,800 |
|||
January 18 | 9500 | 20 | 190000 |
[129800+190000] 319,800 |
|||
Sales May 1 | 9500 | 20 | |||||
5500 | 16 | ||||||
1000 | 14 | 292,000 |
[319800-292000] 27,800 |
||||
Purchase july 28 | 15000 | 18 | 270000 |
[27800+270000] 297,800 |
|||
cost of goods sold =9500*20+5500*16+1000*14 = 190000+88000+14000=292000
Req.A
cost on ending inventory is $297,800
cost of goods sold $292,000 [16000unit sold]
req B
BEGINNING | END | ||
LIFO | 41800 | 297800 | |
AJUSTMENT | 0 | 16200 | |
FIFO | 41800 | 314,000 | [297800+16200] |
REQ C
Opening inventory + Purchase - cost of goods sold = ending inventory
41800(same as LIFO) + [88000+190000+270000]- CGS= [297800+16200] (ENDING INVENTORY IN FIFO IS 16200 MORE THAN LIFO)
=41800+548000-cgs= 314000
cgs under FIFO= 275,800$
REQD
(1) | (2) | = | INVENTORY TURNOVER RATIO (3) | ||
LIFO | 292000 | / | 169800 | = | 1.72 |
FIFO | 275800 | / | 177900 | = | 1.55 |
INVENTORY RATIO = COST OF GOODS SOLD/ AVERAGE INVENTORY
LIFO AVERAGE INVENTORY = OPENING+CLOSING /2
=(41800+297800) / 2
=169800
FIFO AVERAGE INVENTORY = OPENING+ CLOSING /2
=(41800+314000) /2
=177900
lifo method resulted into higher inventory ratio than fifo method.
To the expert: I don't know what you mean by "more requirements, cut it" The requirements...
To the expert: I don't know what you mean by "more requirements, cut it" The requirements are A, B C and D 4. Inventory transactions for Hal Easton Stores are summarized in the table below. The company uses the LIFO perpetual method for both financial and tax reporting. (Click the icon to view the inventory transactions.) The inventory footnote from Hal Easton Stores' annual report indicates that the difference between the LIFO costs and the current (FIFO) costs of inventory...
Burton Company uses the LIFO perpetual method for financial reporting and tax purposes. A summary of Burton's inventory for the current year is presented below. '(Click the icon to view the inventory transactions.) 5. Read the requirements2. Requirement a. Compute the ending inventory and cost of goods sold for the current year. Begin by preparing Burton Stores' perpetual inventory record under the last-in, first-out (LIFO) method for the year. (When entering the layers for the units sold, enter the first...
e of dolls during December as follows: i Requirements ost of of end saction chre 1. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the FIFO inventory costing method. 2. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the LIFO inventory costing method. 3. Which method results in a higher cost of goods sold? 4. Which method results in a higher cost of ending merchandise inventory?...
Dec. 1 Beginning merchandise inventory 13 units @ $11 each 8 Sale 9 units @ $24 each 14 Purchase 17 units @ $15 each 21 Sale 14 units @ $24 each Assume that Upper J Upper L ToysJ L Toys store bought and sold a line of dolls during DecemberDecember as follows: LOADING... (Click the icon to view the transactions.) Upper J Upper L ToysJ L Toys uses the perpetual inventory system.Read the requirements. LOADING... Requirement 1. Compute the cost...
PLEASE GIVE SOLUTION IN THE SAME FORMAT AS THE IMAGE THANK YOU! To more efficiently manage its Inventory, Treynor Corporation maintains its Internal Inventory records using first-In, first-out (FIFO) under a perpetual Inventory system. The following Information relates to its merchandise Inventory during the year: Jan. 1 Inventory on hand-20,000 units; cost $13.10 each. Feb. 12 Purchased 70,000 units for $13.40 each. Apr. 30 Sold 50, 800 units for $20.99 each. Jul. 22 Purchased 5e,eee units for $13.70 each. Sep....
Dec. 1 Beginning merchandise inventory 12 units @ $8 each 8 Sale 8 units @ $21 each 14 Purchase 16 units @ $14 each 21 Sale 15 units @ $21 each 1. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the FIFO inventory costing method. 2. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the LIFO inventory costing method. 3. Which method results in a higher...
Saxton Company's inventory records for the most recent year contain the following data: (Click the icon to view the data) Saxton Company sold a total of 20,100 units during the year Read the requirements Requirement 1. Using the average-cost method, compute the cost of goods sold and ending inventory for the year. (Round the average cost per unit to the nearest cent) Using the average-cost method, the cost of goods sold is and the ending inventory is $ Requirement 2....
flow methods : FIFO, LIFO, Average Cost CALCULATOR FULL SCREEN PRINTER VERSION BACK NEXT Exercise 6-7 Lisa Company had 256 units in beginning inventory at a total cost of $26,112. The company purchased 512 units at a total cost of $66,560. At the end of the year, Lisa had 205 units in ending inventory. (a) Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round average-cost per unit and final answers...
Note: I have answers for requirements 1 and 2, so please solve it for requirement 3 asap. Thank you. Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2021 1,250 units @ $90 each Purchases: January 15 2,600 units @ $105 each January 21 2,400 units @ $110 each Sales: January 5 1,200 units @ $130 each January 22 1,600 units @ $140 each...
Saxton Company's inventory records for the most recent year contain the following data: (Click the icon to view the data.) Saxton Company sold a total of 18,500 units during the year. Read the requirements. Requirement 1. Using the average-cost method, compute the cost of goods sold and ending inventory for the year. (Round the average cost per unit to the nearest cent.) Using the average-cost method, the cost of goods sold is $ 20000 and the ending inventory is $...