Questions:
1. Ending Inventory?
2. Total cost available for sale?
3. Total number of units available for sale?
4. Ending inventory if the company uses LIFO?
5. Gross profit if the company uses FIFO?
6. Cost of goods sold if the company uses average cost?
7. Ending inventory if the company uses average cost?
8. gross profit if the company uses average cost?
FIFO = THE GOODS PURCHASED EARLIER ARE SOLD FIRST
lifo= the goods latest purchased are sold
average = average cost is found out to determine cost of goods sold
1. Ending Inventory?
=BEGINNING +PURCHASE-SALES
=15000+[60000+50000+50000+70000]-225000
=20000 UNITS
2.Total cost available for sale?
BEGINNING+PURCHASE
=34000+144000+125000+130000+192500
=625500$
3.Total number of units available for sale?
=15000+60000+50000+50000+70000
=245000 U NITS
5. FIFO
COST OF GOODS SOLD | 570500 | [34000+60000*2.4+50000*2.5+50000*2.6+50000*2.75] |
ENDING INVENTORY | 55000 | [20000*2.75]] |
GROSS PROFIT | 294500 | [865000-570500]SALES-COST OF GOODS SOLD |
4.Ending inventory if the company uses LIFO?
COST OF GOODS SOLD | 579500 | [70000*2.75+50000*2.6+50000*2.5+55000*2.4] | ||
ENDING INVENTORY | 46000 | [5000*2.4+34000] | ||
GROSS PROFIT | 285500 | [865000-579500]SALES-COST OF GOODS SOLD | ||
5.AVERAGE
BEGINNING | 15000 | 34000 | ||
PURCHASE | 60000 | 2.4 | 144000 | |
50000 | 2.5 | 125000 | ||
50000 | 2.6 | 130000 | ||
70000 | 2.75 | 192500 | ||
TOTAL UNITS | 245000 | 625500 |
AVERAGE = 625500/245000=2.55$
COST OF GOODS SOLD = 225000*2.55
=573750$
ENDING INVENTORY = 2.55$*20000UNITS
=51000$
GROSS PROFIT =865000-573750
=291250$
Questions: 1. Ending Inventory? 2. Total cost available for sale? 3. Total number of units available...
Aurora Co. has beginning inventory of 15,000 units at a cost of $34,000. Total sales of 225,000 units were $865,000. The following purchases were made: Quarter Units Unit Cost Total Cost 60,000 50,000 50,000 70,000 $2.40 $2.50 $2.60 $2.75 $144,000 $125,000 $130,000 $192,500 Calculate the following: FIFO -Ending Inventory COGS Gross Profit LIFO - Ending Inventory COGS Gross Profit Avg Cost-Ending Inventory COGS Gross Profit 1. What is Gross Profit if the company uses FIFO? 2. What is Ending Inventory...
Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost FIFO (PERIODIC) Unit Selling Price July 1 July 13 July 25 July 31 Beginning Inventory Purchase Sold Ending Inventory Units Unit Cost 40 $10 200 (100) 140 $14 Units Cost per Unit Total Beginning Inventory Purchases July 13 Goods Available for Sale Cost of Goods Sold Units from Beginning Inventory Units from July 13 Purchase...
calculate the cost of goods available for sale, ending inventory, and cost of goods sold if Aircarf uses (a) FIFO, (b) LIFO, or (c) weighted average cost. Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July Units Unit Cost July 1 July 5 July 13...
Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic Weighted Average Answer Units Date Transaction 1-Jan Beginning Inventory 28-Mar Purchase 22-Aug Purchase 14-Oct Purchase Unit Cost $60 $66 $70 Total Cost $600 $1,320 $1,400 $1,900 $5,220 $76 The Company sold 45 Units for $100 each on October 28. (Dollars) Beginning Inventory Purchases Cost of Goods Available for Sale Gross Sales COGS Gross Profit Ending Inventory, Sales
The following is the inventory record of widgets for the ABC Company Units Cost/Unit 1-Jan Beginning Inventory 1001 $10.00 15-Apr Purchase 2001 $11.00 24-Aug Purchase 300 $12.00 27-Nov Purchase 400 $13.00 At the end of the fiscal year, the physical inventory found 450 widgets on hand at 12/31. Total sales for the year were 500 widgets sold at a retail price of $20.00 per widget Required: (a) Calculate the endign inventory value under FIFO, LIFO and Weighted Average (b) Calculate...
E6A-26 Comparing ending merchandise inventory, cost of goods sold, and gross profit using the periodic inventory system-FIFO, LIFO, and weighted-average methods Assume that Jump Coffee Shop completed the following periodic inventory trans actions for a line of merchandise inventory: g Objective 7 Appendix 6A 2. COGS $513 53A G03 Jun. 1 Beginning merchandise inventory 17 units @ $ 15 each 12 Purchase 5 units @$19 each 20 Sale TO 14 units @$37 each 24 Purchase 11 units @ $ 23...
Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,500 units at $30; purchases, 4,500 units at $40; operating expenses (excluding income taxes), $99,000; ending inventory per physical count at December 31, 1,500 units; sales price per unit, $70; and average income tax rate, 30%. Required: 1. Prepare income statements under the FIFO, LIFO, and weighted average costing methods. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Units FIFO...
M7-10 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weighted Average Cost (Periodic Inventory) (LO 7-3] Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July. Unit Cost $20 July 1 July 5 July 13 July...
pt1 pt2 pt.3 Exercise 6-4A Part 1 Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. FIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory # of units Cost per Cost of Goods Available for Sale Cost per unit # of units Cost of Goods Sold unit # of units Cost Ending per unit Inventory Beginning Inventory Purchases: Apr. 7 Jul. 16 Oct.6 Total ES Sales revenue Gross profit...
Jun. 1 Beginning merchandise inventory 12 Purchase 20 Sale 24 Purchase 29 Sale 17 units @ 5 units @ 14 units @ 11 units @ 13 units @ $ $ $ $ $ 15 each 19 each 37 each 23 each 37 each 1. Compute ending merchandise inventory, cost of goods sold, and gross profit using the FIFO inventory costing method. 2. Compute ending merchandise inventory, cost of goods sold, and gross profit using the LIFO inventory costing method. 3....