Question

In: Accounting

Figure out how to calculate ending inventory (costs assigned to ending inventory and COGS) Also COGS (gross profit) using LIFO periodic inventory system.

Figure out how to calculate ending inventory (costs assigned to ending inventory and COGS) Also COGS (gross profit) using LIFO periodic inventory system.

Jan1/ Beginning inventory 160 @2= 320

Jan3 sales 110 units @$8

Feb14 purchase 246 units @ $3 = 738

Feb15 Sales 180 units @ $8

Jun30 purchase 210 units @ $4 = $840

Nov6 Sales 158 units @ 8

Nov19 Purchase 68units @ $5 = $340

total 684 units $2,238 448 units

  

Solutions

Expert Solution


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.
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
Periodic System— Calculating Ending Inventory and Cost of Sales using LIFO The following information is available...
Periodic System— Calculating Ending Inventory and Cost of Sales using LIFO The following information is available for Water Inc. Date Units Unit Cost January 1, 2020 (beginning inventory) 100 $50.00 Purchases: January 10, 2020 75 52.00 January 15, 2020 150 52.50 January 30, 2020 100 55.00 The company maintains a periodic inventory system. A physical inventory count shows 125 units in stock on January 31. What is (a) ending inventory on January 31, and (b) cost of goods sold for...
FIFO & LIFO periodic inventory system
Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.   Date Transaction                              Unit unit cost 1-Sep Inventory 20 $100.00  12-Sep Purchase 45 $103.00  19-Sep Purchase 20 $104.00  26-Sep Purchase 50 $105.00  Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold. What you notice about in...
FIFO & LIFO periodic inventory system
Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.   Date Transaction                              Unit unit cost 1-Sep Inventory 20 $100.00  12-Sep Purchase 45 $103.00  19-Sep Purchase 20 $104.00  26-Sep Purchase 50 $105.00  Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold. What you notice about in...
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...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO periodic cost flow assumption. Sales 97 units at $ 18 per unit Beginning inventory 88 units at $ 6 per unit Purchases 58 units at $ 10 per unit Calculate the cost of goods sold using the LIFO periodic cost flow assumption. Units x Cost per Unit = Total Cost Units from beginning inventory x = Units from purchase x = Cost of Goods...
SPK Industries uses the LIFO inventory costing system, use the following information to calculate the COGS...
SPK Industries uses the LIFO inventory costing system, use the following information to calculate the COGS if they sold 50 units in July. Date Purchases Price per Unit 6/15 30 units $120 6/30 40 units $130 7/15 20 units $150
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the...
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the periodic system given the information below? On December 1, 2017, Ivanhoe Company had the account balances shown below. Debits Credits Cash $5,180 Accumulated Depreciation—Equipment $1,460 Accounts Receivable 4,230 Accounts Payable 2,710 Inventory (2,900 x $0.60) 1,740 Common Stock 10,200 Equipment 21,400 Retained Earnings 18,180 $32,550 $32,550 The following transactions occurred during December. Dec. 3 Purchased 3,900 units of inventory on account at a cost...
In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as...
In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables. Date Product Region SalesRep Customer Sales COGS Gross Profit 4/19/2020 Product3 Region3 SalesRep2 Customer16 $            14,046 $               5,337 All products: 4/19/2020 Product7 Region4 SalesRep15 Customer72 $               2,504 $               1,703 Product9 only: 4/19/2020 Product2 Region4 SalesRep18 Customer71 $               1,505 $                  843 Product3 and SalesRep16 only: 4/19/2020 Product6 Region4 SalesRep14 Customer88 $               4,232 $              ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT