Question

In: Accounting

Larson Company employs a periodic inventory system and reported the following inventory information for the month...

Larson Company employs a periodic inventory system and reported the
following inventory information for the month of August:

August 1    Beginning inventory 2,600 units @ $27 cost per unit
August 6    Sold 1,100 units
August 15   Purchased 1,400 units @ $36 cost per unit
August 18   Sold 1,500 units
August 23   Purchased 900 units @ $29 cost per unit
August 26   Purchased 600 units @ $23 cost per unit
August 29   Sold 2,300 units
August 30   Purchased 1,500 units @ $40 cost per unit

During August, Larson Company reported operating expenses of $29,000
and had an income tax rate of 39%.

Using the weighted average method, Larson Company's gross profit for
August totaled $71,050.

Calculate the amount of net income reported on Larson Company's income
statement for August using the LIFO method.

Solutions

Expert Solution

Ans. We will use the weighted average gross profit to calculate total sales. To find out this we need to
compute cost of goods sold under weighted average method.
Total units sold (1,100 + 1,500 + 2,300)   =   4,900 units
Average cost: Cost of goods available for sale Cost of goods sold - Periodic Average cost Ending inventory - Periodic Average cost
Units Rate Total Units Rate Total Units Rate Total
Beginning inventory 2600 $27.00 $70,200
Purchases:
15-Aug 1400 $36.00 $50,400
23-Aug 900 $29.00 $26,100
26-Aug 600 $23.00 $13,800
30-Aug 1500 $40.00 $60,000
Total 7000 $220,500 4900 $31.50 $154,350 2100 $31.50 $66,150
Average cost per unit =   Total cost of goods available for sale / Units available for sale
$88,000 / 11,000
$31.50 per unit
*Calculation of Total sales:
Cost of goods sold $154,350
Add: Gross profit $71,050
Total sales $225,400
Now we will calculate cost of goods sold under LIFO periodic method to calculate the amount
of net income.
Total units sold (1,100 + 1,500 + 2,300)   =   4,900 units
LIFO: Cost of goods available for sale Cost of goods sold - Periodic LIFO Ending inventory - Periodic LIFO
Units Rate Total Units Rate Total Units Rate Total
Beginning inventory 2600 $27.00 $70,200 500 $27.00 $13,500 2100 $27.00 $56,700
Purchases:
15-Aug 1400 $36.00 $50,400 1400 $36.00 $50,400
23-Aug 900 $29.00 $26,100 900 $29.00 $26,100
26-Aug 600 $23.00 $13,800 600 $23.00 $13,800
30-Aug 1500 $40.00 $60,000 1500 $40.00 $60,000
Total 7000 $220,500 4900 $163,800 2100 $56,700
*In LIFO method the units that have purchased last, are released the first one and ending inventory units
remain from the first purchase.
*Calculations of Net income:
Particulars LIFO   Amount
Sales $225,400
Cost of goods sold -$163,800
Gross profit $61,600
Operating expense -$29,000
Income before taxes (a) $32,600
Income tax expenses (a*0.39) -$12,714
Net income $19,886

Related Solutions

THE Company employs a periodic inventory system and sells its inventory to customers for $10 per...
THE Company employs a periodic inventory system and sells its inventory to customers for $10 per unit. THE Company had the following inventory information available for the month of May: May 1 Beginning inventory 280 units @ $3.80 cost per unit May 6 Purchased 350 units @ $4.90 cost per unit May 8 Purchased 240 units @ $4.10 cost per unit May 14 Sold 410 units May 19 Purchased 400 units @ $5.75 cost per unit May 23 Sold 270...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per unit. ABC Company reported the following inventory information for the month of May: May 1 Beginning inventory 4,200 units @ $9 cost per unit May 6 Purchased 2,000 units @ $12 cost per unit May 8 Sold 3,000 units May 13 Purchased 2,500 units @ $6 cost per unit May 18 Sold 1,900 units May 21 Purchased 4,000 units @ $8 cost per unit...
ABC Company employs a periodic inventory system and sells its inventory to customers for $29 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $29 per unit. ABC Company had the following inventory information available for the month of May: May 1 Beginning inventory 2,400 units @ $14 cost per unit May 8 Sold 1,100 units May 13 Purchased 1,400 units @ $11 cost per unit May 18 Sold 1,200 units May 21 Purchased 800 units @ $19 cost per unit May 28 Sold 500 units May 30 Purchased 1,700...
ABC Company employs a periodic inventory system and sells its inventory to customers for $32 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $32 per unit. ABC Company reported the following inventory information for the month of May: May 1 Beginning inventory 4,200 units @ $12 cost per unit May 6 Purchased 2,000 units @ $9 cost per unit May 8 Sold 3,000 units May 13 Purchased 2,500 units @ $15 cost per unit May 18 Sold 1,900 units May 21 Purchased 4,000 units @ $8 cost per unit...
ABC Company employs a periodic inventory system and sells its inventory to customers for $32 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $32 per unit. ABC Company reported the following inventory information for the month of May: May 1 Beginning inventory 4,200 units @ $12 cost per unit May 6 Purchased 2,000 units @ $9 cost per unit May 8 Sold 3,000 units May 13 Purchased 2,500 units @ $15 cost per unit May 18 Sold 1,900 units May 21 Purchased 4,000 units @ $8 cost per unit...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per unit. ABC Company had the following inventory information available for the month of May: May 1 Beginning inventory 1,600 units @ $12 cost per unit May 8 Sold 1,100 units May 13 Purchased 1,700 units @ $24 cost per unit May 18 Sold 1,000 units May 21 Purchased 1,500 units @ $18 cost per unit May 28 Sold 800 units May 30 Purchased 1,200...
Towing Company employs a periodic inventory system and sells its inventory to customers for $34 per...
Towing Company employs a periodic inventory system and sells its inventory to customers for $34 per unit. Towing Company had the following inventory information available for the month of May: May 1 Beginning inventory 2,200 units @ $17 cost per unit May 8 Sold 1,700 units May 13 Purchased 1,800 units @ $13 cost per unit May 18 Sold 1,600 units May 21 Purchased 1,300 units @ $23 cost per unit May 22 Purchased 1,100 units @ $15 cost per...
1. Jeters Company uses a periodic inventory system and reports the following for the month of...
1. Jeters Company uses a periodic inventory system and reports the following for the month of September. Date Explanation Units Unit Cost Total Cost 9/1 Inventory 120    $5 $ 600 9/12 Purchases 370      6 2.220 9/23 Purchases 200    7 1,400 9/30 Inventory 230 Instructions Compute the cost of ending inventory and the cost of goods sold using the FIFO, LIFO, and average-cost methods. (Round average unit cost to three decimal places) Which costing method gives the highest ending...
AP Jeters Company uses a periodic inventory system and reports the following for the month of...
AP Jeters Company uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit cost Total cost June 1 Inventory 120 $5 $600 June 12 Purchase 370 $6 $2200 June 23 Purchase 200 $7 $1400 June 30 Inventory 230 Instructions a. Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO, (2) LIFO, and (3) average-cost. (Round average unit cost to three decimal places.) b. Which costing...
Jeters Company uses a periodic inventory system and reports the following for the month of June....
Jeters Company uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 120 $5 $600 12 Purchase 370 6 2,220 23 Purchase 200 7 1,400 30 Inventory 230 Instructions a. Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO, (2) LIFO, and (3) average-cost. (Round average unit cost to three decimal places.) b. Which costing method gives the highest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT