Question

In: Accounting

during january, tedesco company sold 183 units of product k. It's beginning inventory and purchases during...

during january, tedesco company sold 183 units of product k. It's beginning inventory and purchases during the month were as following: january. 1- beginng inventory 100 units @ $41, january 5 -purchases 100 units @ $43, january 10 -purchases 100 units @ $38, january 15- purchases 100 units @ $50, january 20- purchases 100 units @ $48. Using the periodic inventory system compute the ending inventory and the cost of goods sold using the methods: a) average cost, b) FIFO, c) LIFO. SHOW ALL WORK

Solutions

Expert Solution

Purchase value of all inventory purchased = (100 units*$43)+(100 units*$38)+(100 units*$50)+(100 units*$48)

= $4,300+$3,800+$5,000+$4,800 = $17,900

Total units purchased = 100 units+100 units+100 units+100 units = 400 units

Opening Inventory = 100 units*$41 = $4,100

a) Average cost = (Opening Inventory+Purchase value)/Total opening units and units purchased

Average cost = ($4,100+$17,900)/500 units = $22,000/500 units = $44 per unit

Ending inventory (in units) = Opening inventory+Purchased units-Units sold = 100+400-183 = 317 units

Ending inventory (in $) = 317 units*$44 per unit = $13,948

Cost of goods sold = Opening Inventory+Purchases-Ending Inventory

= $4,100+$17,900-$13,948 = $8,052

b) Under FIFO method the material purchased first will be sold first, hence in the ending inventory the material left will be the units last purchased (i.e. 317 units will include 17 units purchased on january 5 and all the units purchased on january 10, 15 and 20).

Ending Inventory = (17 units*$43)+(100 units*$38)+(100 units*$50)+(100 units*$48)

= $731+$3,800+$5,000+$4,800 = $14,331

Cost of goods sold = Opening Inventory+Purchases-Ending Inventory

= $4,100+$17,900-$14,331 = $7,669

c) Under LIFO method the material purchased last will be sold first, hence in the ending inventory the material left will be the units first purchased and opening inventory (i.e. 317 units will include 100 units from opening inventory, inventory purchased on january 5 and january 10 and 17 units purchased on january 15).

Ending Inventory = (100 units*$41)+(100 units*$43)+(100 units*$38)+(17 units*$50)

= $4,100+$4,300+$3,800+$850 = $13,050

Cost of goods sold = Opening Inventory+Purchases-Ending Inventory

= $4,100+$17,900-$13,050 = $8,950

  


Related Solutions

During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. C.           Compute gross profit under for a...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out Compute gross profit under for a and b....
During April, Wiggins Company sold 900 units of Product X for $10 per unit.  Its beginning inventory,...
During April, Wiggins Company sold 900 units of Product X for $10 per unit.  Its beginning inventory, purchases, and sales during the month were as follows: April   1          Beginning Inventory   200 units @ $1             5          Purchases                    200 units @ $2             8          Sales                            300 units             10        Purchases                    200 units @ $3             15        Purchases                    200 units @ $4             18        Sales                            300 units             20        Purchases                    200 units @ $5             25        Purchases                    200 units @ $6             28        Sales                            300 units Compute the proper cost to be assigned to ending inventory, cost of goods sold, and gross profit under each of these methods using the...
Purple Company uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:
  Purple Company uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:   Quantity Unit Cost Total Cost Beginning inventory, Jan 1 16 $10 $160 Purchase, Jan 11 14 $12 $168 Purchase, Jan 20 23 $15 $345 Totals 53   $673 On January 25, Purple Company sold 25 units of this product The other 28 units remained in inventory at January 31. Determine the Cost...
A company has a beginning inventory of $ 20,000 and purchases during the year of $...
A company has a beginning inventory of $ 20,000 and purchases during the year of $ 160,000. The beginning inventory consisted of 2,000units and 8,000 units were purchased during the year. 3,880 units remain in ending inventory. The cost of the ending inventory using the​ average-cost method will​ be: (Round any intermediary calculations to two decimal places and your final answer to the nearest​ dollar.)
McCaffy Company uses a periodic inventory system. It sold 1,000 units of Product H. Its beginning...
McCaffy Company uses a periodic inventory system. It sold 1,000 units of Product H. Its beginning inventory and purchases during the month were as follows: April 1 Beginning inventory 200 units @ $1 5 Purchases 200 units @ $2 10 Purchases 200 units @ $3 15 Purchases 200 units @ $4 20 Purchases 200 units @ $5 25 Purchases 200 units @ $6 Compute the cost of the ending inventory under each of three methods: (a) average-cost, (b) LIFO, and...
CorpX has 50 units in beginning inventory with a cost of $300. During the year purchases...
CorpX has 50 units in beginning inventory with a cost of $300. During the year purchases were made as follows: January 15- 100 units @ 5.75 per unit                      =          $575 total cost June 15- 100 units @ 5.50 per unit                           =          $550 total cost October 20-50 units @ 5.00 per unit                        =          $250 total cost Total Units = 250                                                                   $1375 total cost An inventory count at year end reveals 60 units in ending inventory. Required: 1-what is the ending...
The following units are available for sale during the year: January 1 Beginning Inventory 10 units...
The following units are available for sale during the year: January 1 Beginning Inventory 10 units at $18 each April 3 Purchase 30 units at $20 each August 31 Purchase 28 units at $25 each September 29 Purchase 17 units at $30 each December 31 Ending Inventory 21 units Determine ending inventory cost by (a) FIFO method, (b) LIFO method, and (c) average cost method.
A company reports the following beginning inventory and two purchases for the month of January. On...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 260 units. Ending inventory at January 31 totals 120 units. Units Unit Cost Beginning inventory on January 1 230 $ 2.10 Purchase on January 9 50 2.30 Purchase on January 25 100 2.44 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO.
A company reports the following beginning inventory and two purchases for the month of January. On...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 320 units. Ending inventory at January 31 totals 140 units. Units Unit Cost Beginning inventory on January 1 290 $ 2.70 Purchase on January 9 70 2.90 Purchase on January 25 100 3.04 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method. Use a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT