Question

In: Accounting

On May 1, Black Bear Company had 400 units of inventory on hand, at a cost...

On May 1, Black Bear Company had 400 units of inventory on hand, at a cost of $4.00 each. The company uses a perpetual inventory system. All purchases and sales are on account. A record of inventory transactions for the month of May for the company is as follows: Purchases Sales 300@ $7.00 1,000 @ $7.00 400 @ $7.50 May 4 May 3 1,300@ $4.10 700 @ $4.40 14 16 29 500@ $4.75 18 Instructions a. Calculate the cost of goods sold and ending inventory using FIFO. b. Prepare journal entries to record the May 4 purchase and the May 3 and 16 sales. c. Calculate gross profit for May

Solutions

Expert Solution

(a).Calculation of cost of good sold and ending inventory of Arrow Company:
Under FIFO Method
DATE PURCHASED COGS INVENTORY  
May units cost per unit unit cost per unit COGS units cost per unit inventory
1-May 400 4 1600
3-May 300 4 1200 100 4 400
4-May 1300 4.1 100 4 400
1300 4.1 5330
14-May 700 4.4 100 4 400
1300 4.1 5330
700 4.4 3080
16-May 100 4 400 400 4.1 1640
900 4.1 3690 700 4.4 3080
18-May 400 4.1 1640 700 4.4 3080
29-May 500 4.75 700 4.4 3080
500 4.75 2375
Total 1700 6930 1200 5455
Cost of good sold= $6930
Inventory = $ 5455
(b).
Answer:
Journal entries:
Date Particulars Dr Cr
$ $
3-May Account receivable a/c                           Dr 2100
sales a/c 2100
(Being sales made on credit @ $7 per unit)
3-May Cost of good sold a/c                               Dr 1200
     Merchandise inventory a/c 1200
(Being sales made which cost @$4 per unit)
4-May Purchase a/c   (Merchandise inventory)      Dr 5330
     Account payable a/c 5330
(Being urchase made on credit)
16-May Account receivable a/c                           Dr 7000
sales a/c 7000
(Being sales made on credit @ $7 per unit)
16-May Cost of good sold a/c                               Dr 4090
     Merchandise inventory a/c 4090
(Being sales made which cost @$4 per unit for 100 units ,$4.1 per unit for 900 units)
( c ).
Calculation of Gross profit:
$ $
Sales -MAY 3 - (300 units @ $7) 2100
May 16 -(1000 units @$7) 7000
May 18 - (400 units @ $7.5) 3000 12100
Less: Cost of good sold under FIFO method 6930
Gross profit 5170

Related Solutions

Campbell Company had 400 units of product in work in process inventory at the beginning of...
Campbell Company had 400 units of product in work in process inventory at the beginning of the period. It started 1,300 units during the period and transferred 1,100 units to finished goods inventory. The ending work in process inventory was estimated to be 60 percent complete. Cost data for the period follow: Product Costs Beginning balance $ 37,560 Added during period 58,800 Total $ 96,360 Required Calculate the number of equivalent units of production. Calculate the product cost per equivalent...
A company had inventory on November 1 of 5 units at a cost of $16 each....
A company had inventory on November 1 of 5 units at a cost of $16 each. On November 2, they purchased 13 units at $18 each. On November 6 they purchased 9 units at $21 each. On November 8, 11 units were sold for $51 each. Using the LIFO perpetual inventory method, what was the value of the inventory on November 8 after the sale? $278 $272 $283 $315 $294
Callum Pty Ltd had the following transactions occur during May. May 1 Inventory on hand was...
Callum Pty Ltd had the following transactions occur during May. May 1 Inventory on hand was 20 units at a cost of $10 per unit May 5 Purchased 20 units for cash for $17 per unit May 10 Sold 35 units for cash at a selling price of $20 per unit May 31 Inventory on hand was 5 units (i) Calculate the cost of sales in May using the average cost inventory costing method (ii) Prepare the journal entries to...
Causwell Company began 2018 with 22,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2018 with 22,000 units of inventory on hand. The cost of each unit was $6.00. During 2018 an additional 42,000 units were purchased at a single unit cost, and 32,000 units remained on hand at the end of 2018 (32,000 units therefore were sold during 2018). Causwell uses a periodic inventory system. Cost of goods sold for 2018, applying the average cost method, is $225,600. The company is interested in determining what cost of goods sold would...
Causwell Company began 2021 with 25,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2021 with 25,000 units of inventory on hand. The cost of each unit was $6.00. During 2021 an additional 45,000 units were purchased at a single unit cost, and 35,000 units remained on hand at the end of 2021 (35,000 units therefore were sold during 2021). Causwell uses a periodic inventory system. Cost of goods sold for 2021, applying the average cost method, is $241,500. The company is interested in determining what cost of goods sold would...
Causwell Company began 2021 with 29,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2021 with 29,000 units of inventory on hand. The cost of each unit was $4.00. During 2021 an additional 45,000 units were purchased at a single unit cost, and 39,000 units remained on hand at the end of 2021 (35,000 units therefore were sold during 2021). Causwell uses a periodic inventory system. Cost of goods sold for 2021, applying the average cost method, is $171,500. The company is interested in determining what cost of goods sold would...
Franklin Co. had 10 units of an inventory item on hand at the beginning of the...
Franklin Co. had 10 units of an inventory item on hand at the beginning of the current year, each of which had a per-unit cost of $10. During the year, 20 additional units were purchased at $11, and 25 units were sold. What is the amount of the ending inventory under the LIFO and the average-cost methods of accounting for inventory? (Round your intermediate calculations and final answers to 2 decimal places.)
Ella Company had 160 units in beginning inventory at a total cost of $320. The company...
Ella Company had 160 units in beginning inventory at a total cost of $320. The company purchased 400 units at a total cost of $1,500. At the end of the year, Ella had 120 units in ending inventory Beginning 160 units ($2.00) $ 320 Purchases 500 units ($3.00) 1,500 Cost of goods available for sale $1,820 A physical count of ending inventory on June 30 reveals that there are 100 units on hand. REQUIREMENTS: Calculate the cost of ending inventory...
PQR Corporation had an inventory of widgets on hand on January 1, 2016 which cost $10...
PQR Corporation had an inventory of widgets on hand on January 1, 2016 which cost $10 per widget. During 2016 PQR increased its widget inventory through two purchases. On February 1, PQR purchased another 1000 widgets at a cost of $13 per widget; and on September 1, 2016 it purchased another 1000 widgets at 15 per widget. There was only one sale of widgets during 2016. It occurred on December 11, 2016 when 1500 widgets were sold. What was the...
Bonita Corp. had 1,800 units of part M.O. on hand May 1, 2020, costing $27 each....
Bonita Corp. had 1,800 units of part M.O. on hand May 1, 2020, costing $27 each. Purchases of part M.O. during May were as follows. Units Units Cost May 9 2,300 $29 17 3,800 30 26 1,300 31 A physical count on May 31, 2020, shows 2,300 units of part M.O. on hand. Using the FIFO method, what is the cost of part M.O. inventory at May 31, 2020? Using the LIFO method, what is the inventory cost? Using the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT