Question

Determine the cost of goods sold and ending merchandise inventory by preparing a perpetual inventory record...

Determine the cost of goods sold and ending merchandise inventory by preparing a perpetual inventory record using the specific identification method. Assume the following costing information for the books sold during the​ month: Aug 3: 4 books for $14, Aug 15: 4 books costing $14 and 5 books costing $20 each, Aug 28: 2 books costing $20 each and 4 books costing $29 each.... Aug 1 Beginning Merchandise Inventory 12 books @ $14 each; Aug 3 : Sold 4 books @ $18 each; Aug 12 Purchased 8 books @20 each; Aug 15 sold 9 books @$18 each; Aug 20 Purchased 5 books @ $29; Aug 28 Sold 6 books @ $20 each (Purchases, Cost of Goods, Inventory on Hand)

date qty
date Qty Unit Cost Tot Cost Qty Unit Cost Tot Cost Qty

Unit Cost

Tot Cost

Homework Answers

Answer #1

Solution

1) Specific Identification Method

Purchases Cost of Goods Sold Inventory on Hand
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Aug 1 12 $14 $168
Aug 3 4 $14 $56 8 $14 $112
Aug 12 8 $20 $160 8 $14 $112
8 $20 $160
Aug 15 4 $14 $56 4 $14 $56
5 $20 $100 3 $20 $60
Aug 20 5 $29 $145 4 $14 $56
3 $20 $60
5 $29 $145
Aug 28 2 $20 $40 4 $14 $56
4 $29 $116 1 $20 $20
1 $23 $23
Totals 13 $305 19 $368 6 $99

Please give thumbs up :-)

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
Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by...
Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by preparing Colour perpetual inventory record under the​ last-in, first-out​ (LIFO) method for the year Transaction Units Sales in Units Unit Cost Total Cost Beginning inventory 1/1 5,500 $51 $280,500 Purchases March 30 4,500 67 301,500 July 15 850 70 59,500 September 1 6,600 Total available for sale 10,850 $641,500 Units sold September 1 (6,600) Ending inventory 4,250 LIFO: Cost of Cost of Units Unit...
Requirement 1. Requiremen Compute cost of goods sold and gross profit using the FIFO inventory costing...
Requirement 1. Requiremen Compute cost of goods sold and gross profit using the FIFO inventory costing method. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the...
Complete the following table using the perpetual FIFO method of inventory flow. Purchases Cost of Goods...
Complete the following table using the perpetual FIFO method of inventory flow. Purchases Cost of Goods Sold Inventory Date Qty Unit Cost Total Cost Qty Unit Cost Total Cost Qty Unit Cost Total Cost July 2 600 12.00       5 200 13.00       7 300       10 325 14.00       12 300 150       18 250 13.00       22 50 205       25 120 180       28 330 15.00       31 70 5       31 Bal
1. Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are...
1. Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 68 units @ $96 10 Sale 50 units 15 Purchase 88 units @ $102 20 Sale 48 units 24 Sale 14 units 30 Purchase 30 units @ $107 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable DVD players are as...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 Inventory 79 units @ $84 10 Sale 53 units 15 Purchase 105 units @ $89 20 Sale 58 units 24 Sale 18 units 30 Purchase 29 units @ $93 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Exercise 8-14 Inventory cost flow methods; perpetual system [LO8-1, 8-4] Altira Corporation uses a perpetual inventory...
Exercise 8-14 Inventory cost flow methods; perpetual system [LO8-1, 8-4] Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the month of August 2018: Aug.1 Inventory on hand—3,300 units; cost $7.40 each. 8 Purchased 16,500 units for $6.80 each. 14 Sold 13,200 units for $13.30 each. 18 Purchased 9,900 units for $6.20 each. 25 Sold 12,200 units for $12.30 each. 31 Inventory on hand—4,300 units. Exercise 8-14 Part 1 Required: 1. Determine the inventory...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 2,200 units at $27 May 10 1,100 units at $29 May 12 1,540 units May 20 990 units at $31 May 14 1,320 units May 31 660 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for December...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Purchases Sales Dec. 1 1,400 units at $28 Dec. 10 700 units at $30 Dec. 12 980 units Dec. 20 630 units at $32 Dec. 14 840 units Dec. 31 420 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 2,700 units at $26 May 10 1,350 units at $28 May 12 1,890 units May 20 1,215 units at $30 May 14 1,620 units May 31 810 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total of $49,000. During the month, SM purchased and sold merchandise on account as follows:   Oct 7 Purchase 30 chairs @ $750 each        14 Sale 30 chairs @ 1,200 each        18 Purchase 50 chairs @ $775 each        27 Sale 40 chairs @ $1,200 each Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT