Question

In: Accounting

Purple Company uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:

 

Purple Company uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:

  Quantity Unit Cost Total Cost
Beginning inventory, Jan 1 16 $10 $160
Purchase, Jan 11 14 $12 $168
Purchase, Jan 20 23 $15 $345
Totals 53   $673

On January 25, Purple Company sold 25 units of this product The other 28 units remained in inventory at January 31.

Determine the Cost of Goods Sold for the month of January using the LIFO cost flow assumption.

Determine the Inventory balance on January 31 assuming the company uses FIFO to allocate inventory costs.

Prepare the adjusting entry needed if a physical count of inventory on January 31 reveals that there are only 26 items remaining in inventory and Purple uses the FIFO cost flow assumption.

Considering current replacement costs, what inventory costing method would you recommend that Purple use in order the show the most realistic balance sheet value for inventory at January 31?

Group of answer choices

Specific identification

Average cost

FIFO

LIFO

Solutions

Expert Solution

1) COGS using LIFO :-

COGS = begining inventory + purchases - ending inventory

calculating ending inventory using LIFO :

given ending inventory = 28 units

Using LIFO , assign the cost of oldest inventory to the ending inventory

therefore,ending inventory = 16x10 + 12x12 = 160+144=304

calculating COGS :

COGS using LIFO = 160+168+345 -(304) = 673-304 = $369

2) inventory balance on 31 st using FIFO:-

using FIFO, assign last-in inventory value to ending inventory

given ending inventory = 28 units

therefore, inventory balance on 31st january = 23x15 + 5x12 = $405

3)  the adjusting entry needed if a physical count of inventory on January 31 reveals that there are only 26 items remaining in inventory and Purple uses the FIFO cost flow assumption:-

using FIFO cost of 28 units of inventory balance on 31st january = 23x15 + 5x12 = $405

but if the physical count of inventory on january 31 reveals that there are only, 26 units, new ending inventory amount for 26 units = 23x15 + 3x12 = $381

amount that should be adjusted = 405-381 = $24

therefore, adjusting entry is:

particulars amount amount

inventory adjustment account DR 24

to inventory account 24

4) For a more accurate cost, use the FIFO method of inventory valuation as it assumes the older items that are less costly are the ones sold first.

explanation:

the current replacement cost should be lower of cost or market.

lets consider each option in detail:

Under specific identification method, every item in your inventory is tracked from the time it is stocked to when it is sold. It is usually used for large items that can be easily identified and have widely different features and costs associated with these features.

Under the weighted average cost method, the weighted average is used to determine the amount that goes into the cost of goods sold and inventory.

FIFO is based on the premise that the first inventory purchased is the first to be sold. The remaining assets in inventory are matched to the assets that are most recently purchased or produced.

Under LIFO inventory valuation method, the assumption is that the newer inventory is sold first while the older inventory remains in stock

To assess the method which is best , we need to pay attention to changes in the inventory costs:

· If the inventory costs are escalating or are likely to increase, LIFO costing may be better. As higher cost items are considered sold, it results in higher costs and lower profits.

· In case your inventory costs are falling, FIFO might be the best option for you.

· For a more accurate cost, use the FIFO method of inventory valuation as it assumes the older items that are less costly are the ones sold first.

therefore FIFO is the best method of inventory valuation considering current replacement cost.


Related Solutions

Keaton Accessories uses a perpetual inventory system. The company's beginning inventory of a particular product and...
Keaton Accessories uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows: Quantity Unit Cost Total Cost Beginning Inventory (Jan. 1) 160 $40 $6,400 Purchase (Jan. 9) 80 45 3,600 Purchase (Jan. 21) 80 46 3,680 Total 320 $13,680 On January 24, Keaton sold 180 units of this product. The other 140 units remain in inventory at January 31. i.) Determine the cost of goods sold...
A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases...
A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases during a month as as follows: Beginning Inventory Jan 1: 16 pairs at $10 ea Purchase Jan 11: 14 pairs @ $12 ea Purchase Jan 20: 23 pairs at $15 ea On Jan 14 the company sold 25 units of shoes. The other 28 units remained in inventory at Jan 31. Question 1: Assuming the company uses the average cost flow assumption what is...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. C.           Compute gross profit under for a...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out Compute gross profit under for a and b....
Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular product...
Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows: Quantity Unit Cost Total Cost Beginning inventory (Jan. 1) 20 $ 15 $ 300 Purchase (Jan. 11) 16 $ 21 336 Purchase (Jan. 20) 27 $ 23 621 Total 63 $ 1,257 On January 14, Beech Soda, Inc. sold 29 units of this product. The other 34 units remained in inventory at January...
GGG uses a perpetual inventory system. The company’s beginning inventory of a particular product and its...
GGG uses a perpetual inventory system. The company’s beginning inventory of a particular product and its purchases during the months of January and February were as follows:                                                                                         Quantity                             Unit Cost    Beginning inventory (Jan. 1)................................................. 50                                         $6.00        Purchase (Jan. 10)................................................................. 25                                           7.00        Purchase (Jan. 22)................................................................. 25                                           8.52           Purchase (Feb. 9)…………………………………………              65                                    11.00             Total     ...............................................................................                                                   On February 25, GGG sells 65 units of this product. The other units remain in inventory at February...
12. Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular...
12. Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows: Jan. 1   Beginning inventory = 16 units at a price of $10 each Jan. 11 Purchased inventory = 14 units at a price of $11.95 each Jan. 20 Purchased inventory = 23 units at a price of $15 each On January 14, Beech Soda, Inc. sold 25 units of this product. The...
A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory.
  A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory. January 1: Purchased 30 units at SAR11 per unit February 5: Purchased 30 units at SAR 13 per unit March 16: Sold 50 Units for SAR 15 per unit A.Prepare general journal entries to record the March 16 sale using the FIFO inventory valuation method. LIFO inventory valuation method. Weighted average valuation method. B. What is the cost of...
A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory.
  Q1- A company wants to implement good internal control. What are the policies and procedures you can suggest to minimize human frauds and errors? (1Mark) Q2- Assume that you have a company. And the management team estimates that 3% of sales will be uncollectible. Give any amount of sales and prepare the journal entry using the percent of sales method.                                                                                              (1Mark) Q3- A company that uses a perpetual inventory system made the following cash purchases and sales. There was...
Q4. Malik Company uses a periodic inventory system. The beginning inventory of a particular product, and...
Q4. Malik Company uses a periodic inventory system. The beginning inventory of a particular product, and the purchases during the current year, were as follows: Date Transaction Units Price Amount Jan 1 Beginning inventory 60 $105 6,300 Mar 8 Purchase 30 $115 Aug 11 Purchase 90 $125 Oct. 23 Purchase 20 $135 At December 31, the ending inventory of this product consisted of 55 and selling price during year was $150. Using periodic costing procedures, determine the following under each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT