Question

In: Accounting

The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                           &n

The following pertain to the cost of H’s only inventory item:

  • Inventory on hand, January 1                                                10 units @ $  9 per unit
  • Purchases, January 2                                                             150 units @ $14 per unit
  • Purchases, January 12                                                         195 units @ $15 per unit
  • Purchases, January 16                                                           75 units @ $15 per unit
  • Purchases, January 20                                                            50 units @ $16 per unit
  • Purchases, January 26                                                          205 units @ $19 per unit

685

Sales during January totaled 615 units. Each unit sold for $40.

Calculate COGS AND GP for January AND EI as of 01-31 under the following assumptions:

  • H uses periodic LIFO

EI:                                                                                   

COGS:                                                                           

Gross profit:                                                                  

  • H uses periodic FIFO

EI:                                                                                   

COGS:                                                                           

Gross profit:                                                                  

  • H uses a weighted average method and rounds the unit cost to the nearest penny.

EI:                                                                                   

COGS:                                                                           

Gross profit:                                                                  

Make sure that the sum of your COGS AND EI answers add up to 100% of your COGAS.

Solutions

Expert Solution

Sales = $615 x40 = $24600

Cost of goods sold = $10005

Gross profit = $24600 - 10005 = $14595

2)

Sales = $615 x40 = $24600

Cost of goods sold = $9605

Gross profit = $24600 - 9605 = $14995

3)

Sales = $615 x40 = $24600

Cost of goods sold = $9815.40

Gross profit = $24600 - 9815.40 = $14784.60


Related Solutions

The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                           &
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                                                 295 units @ $50 per unit Purchases, January 12                                                            590 units @ $88 per unit Purchases, January 20                                                             450 units @ $91 per unit Purchases, January 31                                                            300 units @ $93 per unit 1,635 Sales, January 5                                                                         75 units @ $200 per unit Sales, January 15                                                                     350 units @ $200 per unit Sales, January 22                                                                     550 units @ $200 per unit Sales, January 30                                                                     140 units @ $200 per unit 1,115                                          (1,115 x...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units What value should be assigned to cost of goods sold using LIFO?
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units (a) What value should be assigned to the ending inventory using FIFO? Value assigned to the ending inventory $
Inventory TableClose The following data pertain to Company A’s inventory that was purchased on January 5,...
Inventory TableClose The following data pertain to Company A’s inventory that was purchased on January 5, Year 1, for $40,000: March 31, Year 1 June 30, Year 1 December 31, Year 1 Estimated selling price $42,000 $44,000 $41,000 Cost of disposal 2,000 2,000 2,500 Normal profit margin 1,200 1,400 1,100 Cost of completion 1,000 1,000 1,000 Current replacement cost 38,000 42,000 36,000 Note: Entire inventory was sold on May 1, Year 2. EmailClose To: Bill West From: Rufus Brown Date:...
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...
Consider the following information on an inventory management system:             Item Cost:                 &nbsp
Consider the following information on an inventory management system:             Item Cost:                                $10             Order Cost:                              $250             Annual Holding Cost:              33% of item cost             Annual Demand:                     25,750             Average Demand:                   515 per week             Std. Dev. of Demand:              125 per week             Leadtime:                                2 weeks          1. Ignoring the uncertainty in the demand (i.e. looking only at average values), find the optimal order quantity and the reorder point. What is the annual inventory holding and ordering cost for this...
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.)
McAdams Company had the following inventory cost values for one item of inventory for April: Date...
McAdams Company had the following inventory cost values for one item of inventory for April: Date Activity Units Purchased Cost/Unit Total Cost Apr. 1 BI 400 $14 $5,600 Apr. 8 Purchase 2,200 16 35,200 Apr. 25 Purchase 600 18 10,800 Apr. 30 Purchase 800 20 16,000 Available for sale: Units purchased = 4,000; Total cost = $67,600 Sales Activity: Apr. 19.....1,200 units Apr. 26.....1,400 units Units sold = 2,600 Units remaining in EI Available for sale..........4,000 units Units sold.....................2,600 Ending...
Part 1 On January 1, 2021, ABC Inc. started business with inventory on hand of $34,000....
Part 1 On January 1, 2021, ABC Inc. started business with inventory on hand of $34,000. The company reported purchases for the year of $136,000 and sales of $306,000. The value of inventory on hand on December 31, 2021 was $45,000 at end of year prices. The price index for 2020 was 106. What should abc Inc. report as COGS for 2021 if they use Dollar Value LIFO as their inventory method? Part 2 ABC Co. uses the conventional approach...
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in...
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in units B8867 10 100 4500 J1252 5.25 6500 120 K9667 1.22 4000 1000 L2425 12.5 54 254 M4554 5.25 6500 120 T6334 70 500 800 W9856 .75 800 20000 X2215 1.5 8000 2000 Y3214 70 1000 500 Y6339 4 3500 125 which of the following items is not classified as C items by annual dollar usage? Which is not classified as C items by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT