Question

In: Accounting

Assume Joker Company uses a periodic inventory system. Calculate cost of goods sold and ending inventory using (1) FIFO, (2) LIFO and (3) average cost. Round per unit cost to two decimal places.

Date

Transaction

Quantity

Price/Cost

1/1

Beginning inventory

2,000

10.00

1/3

Purchases

18,000

10.40

1/7

Sales (@ $26 per unit)

7,000

 

1/20

Purchases

6,000

11.00

1/22

Sales (@ $27 per unit)

16,000

 

1/30

Purchases

3,000

12.00

 

  1. Assume Joker Company uses a periodic inventory system. Calculate cost of goods sold and ending inventory using (1) FIFO, (2) LIFO and (3) average cost. Round per unit cost to two decimal places.

 

  1. Assume Joker Company uses a perpetual inventory system. Calculate cost of goods sold and ending inventory using (1) FIFO, (2) LIFO and (3) average cost. Round per unit cost to two decimal places.

Solutions

Expert Solution

Correct Anwer:

Requirement 1 : Periodic Inventory System

Cost of Goods Available for sale

Units

Cost per unit

value

Beginning Inventory

2000

$          10.00

$     20,000.00

Purchases

18000

10.4

$ 1,87,200.00

10-Jan

6000

$          11.00

$     66,000.00

20-Jan

3000

$          12.00

$     36,000.00

total

29000

$ 3,09,200.00

FIFO (Periodic)

Total Units Avalable for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Cost of Goods Sold

$                               -  

2000

$             10.00

$                20,000.00

5000

$             10.40

$                52,000.00

13000

10.4

$            1,35,200.00

3000

11

$                33,000.00

total cost of goods sold

$            2,40,200.00

Ending Inventory

(309,200 – 240,200)

$                      69,000

LIFO (Periodic)

Total Units Available for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Ending Inventory

3000

$             12.00

$                36,000.00

4000

$             11.00

$                44,000.00

2000

$             11.00

$                22,000.00

14000

$             10.40

$               1,45,600.0

Value Of Ending Inventory

$                  2,47,600

Cost of Goods sold

(309,200 -247,600)

$                61,600.00

Weighted Average Cost

Units

(A)

29000

Total Cost

(B)

$    3,09,200

Average Cost

(C=B/A)

$          10.66

Weighted Average

Total Units Available for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Cost of Goods sold

23000

@

$             10.66

$            2,45,227.59

Total cost of Goods Sold

$            2,45,227.59

Ending Inventory

(309,200 – 245,277.59)

$                63,972.41

Requirement 2: Perpetual Inventory .

Cost of Goods Available for sale

Units

Cost per unit

value

Beginning Inventory

2000

$          10.00

$     20,000.00

Purchases

18000

10.4

$ 1,87,200.00

10-Jan

6000

$          11.00

$     66,000.00

20-Jan

3000

$          12.00

$     36,000.00

total

29000

$ 3,09,200.00

FIFO (Perpetual)

Total Units Available for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Cost of Goods Sold

$                               -  

2000

$             10.00

$                20,000.00

5000

$             10.40

$                52,000.00

13000

10.4

$            1,35,200.00

3000

11

$                33,000.00

total cost of goods sold

$            2,40,200.00

Ending Inventory

($ 309,200 – 240,200)

$                      69,000

LIFO (Perpetual)

Total Units Available for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Cost of Goods sold

7000

$             10.40

$                72,800.00

6000

$             11.00

$                66,000.00

10000

$             10.40

$            1,04,000.00

Cost of Goods Sold

$                  2,42,800

Value of Ending Inventory

($309,200 – 242,800)

$                66,400.00

Average cost per unit as on (1/7)

units

cost

total

beginning balance

2000

$                10.00

$        20,000.00

purchases (1/3)

18000

$                10.40

$    1,87,200.00

total

20000

$    2,07,200.00

average cost per unit

$                10.36

Average cost per unit as on (1/22)

units

cost

total

beginning balance

13000

$                10.36

$    1,34,680.00

purchases (1/3)

6000

$                11.00

$        66,000.00

total

19000

$    2,00,680.00

average cost per unit

$                10.56

Weighted Average (perpetual Inventory)

Total Units Avalable for sale

29000

$            3,09,200.00

Units Sold

23000

Ending Inventory Units

6000

Valuation

Cost of Goods sold

7000

@

$             10.36

$                72,520.00

16000

@

$             10.56

$            1,68,993.68

Total cost of Goods Sold

$            2,41,513.68

Ending Inventory

($ 309,200 – $ 241,513.68)

$                67,686.32

End of Answer:

Thumbs up will be highly appreciated.

Thanks.


Related Solutions

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
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 36 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 43 $ 7.10 $ 305.30 April 1 38 6.35 241.30 June 1 53 6.10 323.30 September 1 48 6.60 316.80 Total 182 $ 1,186.70 Cost of...
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...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 38 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 54 $ 7.50 $ 405.00 April 1 49 6.75 330.75 June 1 64 6.50 416.00 September 1 59 7.00 413.00 Total 226 $ 1,564.75. FIFO $...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 33 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 41 $ 7.80 $ 319.80 April 1 36 7.05 253.80 June 1 51 6.80 346.80 September 1 46 7.30 335.80 Total 174 $ 1,256.20 Cost of...
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...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
Part one: Calculate cost per unit. (Round answer to 2 decimal places) Weighted-average cost per unit...
Part one: Calculate cost per unit. (Round answer to 2 decimal places) Weighted-average cost per unit Part two: Calculate ending inventory, cost of goods sole, and gross profit under each of the following methods: LIFO, FIFO, and Average Cost. Part three: Calculate gross profit rate under each of the following methods: LIFO, FIFO, and Average-cost (Round answers to 1 decimal place) You are provided with the following information for Cheyenne Inc. for the month ended June 30, 2019. Cheyenne uses...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT