Question

The following relates to ABC Company’s inventory for April: Date Description 4/1 Beginning Inventory 4/5 Purchases...

The following relates to ABC Company’s inventory for April: Date Description 4/1 Beginning Inventory 4/5 Purchases 4/18 Purchases 4/30 Ending inventory Units 1,500 2,500 1,000 1,800 Unit cost $10 $11 $12 Batch cost $15,000 $27,500 $12,000 Calculate cost of goods available for sale for April _____________________ Calculate the cost of goods sold under the following methods: ________________ FIFO ________________ Average Calculate cost of ending inventory under the following methods: ________________ LIFO ________________ Average

Homework Answers

Answer #1

Calculation of Cost of goods available for sale

= Value of opening stock + purchases

=15000 + 27500 + 12000

=$54500

Calculation of COGS

FIFO

Units COGS amount
Out of beginning inventory 1500 1500*10=15000
Out of 4/5 purchases 1700 1700*11=18700
Total COGS =$33700

AVERAGE METHOD

Weighted avg cost per unit = Cost of goods available for sale/ no of goods available for sale

=54500/(1500+2500+1000) =$10.9 per unit

COGS = 3200 units * 10.9 =$34880

ENDING INVENTORY

LIFO

Units Ending inventory
Out of beginning inventory 1500 1500*10=15000
Out of 4/5 purchases 300 300*11=3300
Ending inventory =$18300

AVERAGE

ENDING inventory = 1800 *10.9 =$19620

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit...
Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit Cost Total Cost June 1 Beginning 30 $ 11.00 $ 330.00 11 Purchase 35 12.00 420.00 24 Purchase 35 14.00 490.00 30 Ending 39 Required: Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO, (b) LIFO, and (c) weighted average cost methods.
ABC Company had the following purchases and sales in June. What is the ending June inventory...
ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods? Date                   Action                      Units          Cost June 1             Beg. Inventory           100               $2 June 6             Sale                                50 June 9             Purchase                      200              $4 June 15           Sale                               175 June 20           Purchase                      100              $5 June 25           Sale                               125 ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual...
Beginning inventory, purchases, and sales data for May are as follows:             May   1         ...
Beginning inventory, purchases, and sales data for May are as follows:             May   1          Inventory                                            40 units at $10                         4          Purchase                                              30 units at $12 12        Purchase                                            45 units at $15                         The business maintains a periodic inventory system. Assume 60 units were sold during the month. Required Part 1) Determine the COST OF GOODS SOLD under each of the following methods: A)First-in first-out (FIFO) B)Last-in first-out (LIFO) C)Weighted-average Part 2) Determine...
ABC Company had the following purchases and sales in June. What is the ending June inventory...
ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods? Date Action Units Cost June 1 Beg. Inventory 100 $2 June 6 Sale 50 June 9 Purchase 200 $4 June 15 Sale 175 June 20 Purchase 100 $5 June 25 Sale 125
Mitchell Company’s record of transactions for the month of June was as follows. Purchases: Date                 Units         &nbs
Mitchell Company’s record of transactions for the month of June was as follows. Purchases: Date                 Units               Unit Cost June 1              600       @         3.00€ 4                        1,500    @         3.04 8                        800       @         3.20 13                     1,200     @        3.25 21                     700        @        3.30 29                     500        @        3.13                          -------                          5,300 Sales: Date              Units                Unit Cost June 3           500       @          5.00€ 9                    1,300     @          5.00 11                  600        @          5.50 23                  1,200     @          5.50 27                  900        @          6.00                      ----------                       4,500 Instructions (a) Assuming...
Vaughn Company, which uses a periodic inventory system, had a beginning inventory on May 1, of...
Vaughn Company, which uses a periodic inventory system, had a beginning inventory on May 1, of 300 units of Product A at a cost of $6.25 per unit. During May, the following purchases and sales were made. Purchases:   Sales: May 6 300 units at $7.20 May 4 275 units 14 400 units at $9.10 300 units 21 100 units at $11.50 22 400 units 28 500 1 ,300 units at $11.80 24 225 1 ,200 units Instructions: Compute the May...
Benjamin Buttons company had the following inventory transactions for the month of September. Beginning Inventory 400...
Benjamin Buttons company had the following inventory transactions for the month of September. Beginning Inventory 400 units @ $5.60 per unit = $2,240.00 Purchase #1 480 units @ $5.75 per unit = $2,760.00 Purchase #2 520 units @ $6.00 per unit = $3,120.00 Purchase #3 550 units @ $6.20 per unit = $3,410.00 Purchase #4 560 units @ $6.25 per unit = $3,500.00 Total 2,510 $15,030.00 Less: Sold 1,315 Ending Inventory 1,195 Required: 1. Calculate the value of the Cost...
Exercise 2 – LIFO Perpetual Lighting Designs by Laura has the following list of beginning inventory,...
Exercise 2 – LIFO Perpetual Lighting Designs by Laura has the following list of beginning inventory, purchases, and sales for the month of May: 1st      Beginning Inventory                         500 light bulbs at $0.75 6th      Purchase                                           300 light bulbs at $0.55 9th      Sale                                                   650 light bulbs 12th    Purchase                                           200 light bulbs at $0.60 16th    Sale                                                   275 light bulbs 22nd   Purchase                                            200 light bulbs at $0.65 30th    Sale                                                   125 light bulbs Calculate the cost of ending inventory using the last-in, first-out method under...
Journalize each transaction: April 1- We buy 4 items at 10 cents per item April 3-...
Journalize each transaction: April 1- We buy 4 items at 10 cents per item April 3- We sell 2 items for $1 per item for cash April 6- We buy 4 items at 12 cents per item April 12- We sell 3 items at $1 per item for cash April 20- We buy 4 items at 15 cents per item April 27- We sell 5 items at $1 per item for cash What is ending inventory & cost of goods...
computing Cost of Goods Sold and Ending Inventory Bartov Corporation reports the following beginning inventory and...
computing Cost of Goods Sold and Ending Inventory Bartov Corporation reports the following beginning inventory and purchases for 2017 Beginning inventory 400 @ $12 each $4,800 Inventory purchased 600 @ $14 each 8,400 Cost of goods available 1,000 units $13,200 Bartov sells 600 of these units in 2017. Compute its cost of goods sold for 2017 and the ending inventory reported on its 2017 balance sheet under each of the following inventory costing methods: (Do not round until your final...