Question

ABC Corp had the following inventory transactions for the month of December 20X5 Date transaction type...

ABC Corp had the following inventory transactions for the month of December 20X5

Date transaction type amount (units) price per unit

Dec1 opening balance 400 $5.12

Dec3 purchase 1100 $5.23

Dec15 purchase 900 $5.48

Dec22 purchase 250 $5.66

Dec2 sales 300 $6.50

Dec 6 sales 800 $6.50

Dec 18 sales 700 $8.00

Dec25 sales 150 $8.00

What is the value of the inventory held by ABC as at December 31 20X5 if the company values its inventory using the weighted average cost formula and uses a perpetual inventory system?

Round all calculations to two significant decimal places for example $5.66.

Homework Answers

Answer #1
Particular Quantity change Actual unit cost Actual total cost
01-Dec Opening balance 400 $5.12 $2,048
02-Dec Sales -300
03-Dec purchase 1100 $5.23 $5,753
06-Dec Sales -800
15-Dec Purchase 900 $5.48 $4,932
18-Dec Sales -700
22-Dec Purchase 250 $5.66 $1,415
25-Dec Sales -150
31-Dec Ending inventory 700 Total purchase cost =$14,148

weighted average unit cost = $14,148 / (400+1100+900+250) = $14,148/2650 = $5.34 (rounded off)

Value of ending inventory = $5.34 x 700 = $3735 (approx.)

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
ABC Corp. had the following inventory transactions for the month of December 20X5: Date Transaction type...
ABC Corp. had the following inventory transactions for the month of December 20X5: Date Transaction type Amount (units) Price per unit Dec. 1 Opening balance 400 $5.12 Dec. 3 Purchase 1,100 $5.23 Dec. 15 Purchase 900 $5.48 Dec. 22 Purchase 250 $5.66 Dec. 2 Sale 300 $6.50 Dec. 6 Sale 800 $6.50 Dec. 18 Sale 700 $8.00 Dec. 25 Sale 150 $8.00 What is the value of the inventory held by ABC as at December 31, 20X5, if the company...
Two different companies, Ripper and Berners, entered into the following inventory transactions during December. Both companies...
Two different companies, Ripper and Berners, entered into the following inventory transactions during December. Both companies use a perpetual inventory system. • December 3 – Ripper Corporation sold inventory on account to Berners Corp. for $499,000, terms 2/10, n/30. This inventory originally cost Ripper $302,000. • December 8 – Berners Corp. returned inventory to Ripper Corporation for a credit of $4,700. Ripper returned this inventory to inventory at its original cost of $2,844. • December 12 – Berners Corp. paid...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3 Sheffield Ltd. sold goods to Bramble Corp. for $57,000, terms n/15, FOB shipping point. The inventory had cost Sheffield $30,200. Sheffield’s management expected a return rate of 3% based on prior experience. 7 Shipping costs of $760 were paid by the appropriate company. 8 Bramble returned unwanted merchandise to Sheffield. The returned merchandise has a sales price of $1,760, and a cost of $960....
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3 Flounder Ltd. sold goods to Novak Corp. for $70,000, terms n/15, FOB shipping point. The inventory had cost Flounder $37,200. Flounder’s management expected a return rate of 3% based on prior experience. 7 Shipping costs of $960 were paid by the appropriate company. 8 Novak returned unwanted merchandise to Flounder. The returned merchandise has a sales price of $2,160, and a cost of $1,160....
Pronghorn Corp. uses a perpetual inventory system. The company had the following inventory transactions in April:...
Pronghorn Corp. uses a perpetual inventory system. The company had the following inventory transactions in April: April 3 Purchased merchandise from DeVito Ltd. for $25,700, terms 1/10, n/30, FOB shipping point. 6 The appropriate company paid freight costs of $700 on the merchandise purchased on April 3. 7 Purchased supplies on account for $5,450. 8 Returned damaged merchandise to DeVito and was given a purchase allowance of $3,400. The merchandise was repaired by DeVito and returned to inventory for future...
he following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3...
he following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3 Swifty Ltd. sold goods to Blue Spruce Corp. for $81,700, terms n/15, FOB shipping point. The inventory had cost Swifty $43,500. Pictou’s management expected a return rate of 3% based on prior experience. 7 Shipping costs of $1,140 were paid by the appropriate company. 8 Blue Spruce returned unwanted merchandise to Swifty. The returned merchandise has a sales price of $2,520, and a cost...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3 Flounder Ltd. sold goods to Novak Corp. for $70,000, terms n/15, FOB shipping point. The inventory had cost Flounder $37,200. Flounder’s management expected a return rate of 3% based on prior experience. 7 Shipping costs of $960 were paid by the appropriate company. 8 Novak returned unwanted merchandise to Flounder. The returned merchandise has a sales price of $2,160, and a cost of $1,160....
During the month, the following transactions occurred for Trevor’s Supply Company.   The company uses the perpetual inventory...
During the month, the following transactions occurred for Trevor’s Supply Company.   The company uses the perpetual inventory method. Dec. 1 Accepted a 4-month, 6% note from a customer in settlement of $12,400 account. 3 Wrote off as uncollectible specific accounts totaling $680. 8 Purchased $17,200 of inventory on account, terms 2/10, n/30. 11 Sold $25,000 of inventory that cost $17,500, terms 1/15, n/45. 12 Paid $13,750 for employee salaries. 15 Customers returned $8,000 of inventory sold on December 11th that cost...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3...
The following merchandise transactions occurred in December. Both companies use a perpetual inventory system. Dec. 3 Monty Ltd. sold goods to Grouper Corp. for $64,800, terms n/15, FOB shipping point. The inventory had cost Monty $34,400. Monty’s management expected a return rate of 3% based on prior experience. 7 Shipping costs of $880 were paid by the appropriate company. 8 Grouper returned unwanted merchandise to Monty. The returned merchandise has a sales price of $2,000, and a cost of $1,080....