Question

In: Accounting

Hatchet Corporation sells one product (using the periodic system of inventory) and had the following inventory...

Hatchet Corporation sells one product (using the periodic system of inventory) and had the following inventory transactions during the current month: Beginning Inventory 200 units costing $7 each Purchase on the 5th 600 units costing $8 each Purchase on the 17th 400 units costing $10 each Units sold during the month 900 units at a retail price of $15 each Answer the following questions in the space below. Calculate the cost of goods sold during the month using the Last-In-First-Out method of inventory allocation. Calculate the ending inventory balance (in dollars) using the Weighted-Average method of inventory allocation.

Solutions

Expert Solution

using the periodic system of inventory

Calculate the cost of goods sold during the month using the Last-In-First-Out method of inventory allocation.

Date

Units

Cost

Total cost

Beginning

200

$7

$1400

5th

600

8

4800

17th

400

10

4000

Goods available for sales

1200

$10200

Cost of goods sold

From 17th layer

400

10

4000

From 5th layer

500

8

4000

Cost of goods sold

$8000

Calculate the ending inventory balance (in dollars) using the Weighted-Average method of inventory allocation.

Ending inventory units = Goods available for sales - Sold units

Ending inventory units = 1200 - 900 = 300 units

Date

Units

Cost

Total cost

Beginning

200

7

$1400

5th

600

8

4800

17th

400

10

4000

Total

1200

$10200

Average cost per units

10200 / 1200

= $8.5

Units

Average cost per units

Total cost

Ending inventory balance

300

8.5

$2550


Related Solutions

Yang Corporation uses the periodic inventory system. The following sales and purchases of the same product...
Yang Corporation uses the periodic inventory system. The following sales and purchases of the same product were made during 20x1 at Yang Corporation. The opening inventory consisted of 50 units at $2 each. Purchases Sales Date Units $ per unit Date Units Unit $Price Total March 15 200 3 April 25 250* 5 June 15 600 5 June 30 500** 6 *for specific identification, sold 50 units of opening inventory and 200 units of March 15 purchase **for specific identification,...
Periodic (FIFO, LIFO, Average) Spring River sells bottled water using a periodic inventory system. The following...
Periodic (FIFO, LIFO, Average) Spring River sells bottled water using a periodic inventory system. The following is a list of beginning inventory and purchases for bottles used in manufacturing their spring water.                         Beginning Inventory                           6,000 bottles at $0.20                         First Purchase                                      4,500 bottles at $0.22                         Second Purchase                                 5,600 bottles at $0.24                         Third Purchase                                    2,000 bottles at $0.26 At the end of the year, 2,500 bottles remained in ending inventory. What is cost of merchandise sold and ending...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 130 $10 5/5 Purchase 210 $12 5/15 Purchase 350 $14 5/25 Purchase 310 $16 Sales were 470 units at $20.  Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for...
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for the month of March. Units Cost Per Unit Beginning Inventory (March 1) 250 $12 Purchase (March 25th) 130 $13 Purchase (March 28th) 285 $15 Sale (March 30th) 350 1. If the company uses a FIFO inventory method, what will be COST OF GOODS SOLD for the month of March? (please only enter positive numbers) Use the same information as for Question 1 If the...
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for...
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2016: Date Activity Quantity Unit Price 5/1 Beginning Inventory 150 $10 5/5 Purchase 200 $12 5/15 Purchase 300 $14 5/25 Purchase 150 $16 Sales were 525 units at $20.  Using the LIFO method, determine the dollar values following for the month of May: 1. Ending Inventory 2. Cost of Goods Available for Sale 3. Cost of Goods Sold
Capwell Corporation uses a periodic inventory system
Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2011, its fiscal-year end, based on a physical count, was determined to be $326,000. Capwell's unadjusted trial balance also showed the following account balances: Purchases, $620,000; Accounts payable; $210,000; Accounts receivable, $225,000; Sales revenue, $840,000. The internal audit department discovered the following items:1. Goods valued at $32,000 held on consignment from Dix Company were included in the physical count but not recorded as a purchase.2. Purchases...
Inventory Costing Methods—Periodic Method The following data are for the Porter Corporation, which sells just one...
Inventory Costing Methods—Periodic Method The following data are for the Porter Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 1,200 $8 Purchases: February 11 1,500 9 May 18 1,400 12 October 23 1,100 14 Sales: March 1 1,400 July 1 1,400 October 29 1,200 Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in, first-out, (b) last-in, first-out, and (c) weighted-average cost method. Round the...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 100 $10 5/5 Purchase 240 $12 5/15 Purchase 270 $14 5/25 Purchase 320 $16 Sales were 430 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Swifty Corp. uses a periodic inventory system. The company had the following inventory transactions in April:...
Swifty Corp. uses a periodic inventory system. The company had the following inventory transactions in April: April 3 Purchased merchandise from Blue Spruce Ltd. for $26,000, terms 1/10, n/30, FOB shipping point. 6 The appropriate company paid freight costs of $770 on the merchandise purchased on April 3. 7 Purchased supplies on account for $5,050. 8 Returned damaged merchandise to Blue Spruce and was given a purchase allowance of $3,700. The merchandise was repaired by Blue Spruce and returned to...
Flint Corp. uses a periodic inventory system. The company had the following inventory transactions in April:...
Flint Corp. uses a periodic inventory system. The company had the following inventory transactions in April: April 3 Purchased merchandise from Pina Colada Ltd. for $27,200, terms n/30, FOB shipping point. 6 The appropriate company paid freight costs of $710 on the merchandise purchased on April 3. 7 Purchased supplies on account for $4,940. 8 Returned damaged merchandise to Pina Colada received a credit of $3,200. The merchandise was returned to inventory for future resale. 30 Paid the amount due...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT