Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help completing the specified ID prtion of this problem. Thank you for your help. Montoure Company uses a perpetual inventory system. It entered

I need help completing the specified ID prtion of this problem.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Thank you for your help.
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Unita Sold at Retail Date Activities 1 Beginning inventory Feb. 10 Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept. 10 Sales Totals Unit# Acquired at Cost 620 units $45 per unit 310 units $42 per unit 120 unito 630 per unit 190 units $50 per unit 520 unita 9 648 per unit 770 units @ $85 per unit 1,760 units 1710 unitse $85 per unit 1,480 units Required: 1. Compute cost of goods available for sale and the number of units available for sale Cost of goods available for sale Number of units available for sale $ 78,980 1.760 units 2 Compute the number of units in ending inventory. Ending inventory 280 units Perpetual FIFO Perpetual LIFO weighted Average Specific Id Compute the cost assigned to ending inventory using FIFO. (Round your average cost per unit to 2 decimal places.) Perpetual FIFO: Goods Purchased of Cost of Goods Sold Cost per of units sold Cost of Goods Sold Date Cost per units Cost per unit Inventory Balance # of units Inventory unit Balance 620 @ $ 45.00 $ 27,900.00 unit Jan 1 Feb 10 310 @ $ 42.00 620 @ 310 @ $ 45.00 = $ 42.00 = $ 27,900.00 13.020.00 $ 40,920.00 Mar 13 120 @ $ 30.00 620 @ 310 @ 120 @ $ 45.00 = $ 42.00 $ 30.00 $ 27,900.00 13.020.00 3,600.00 $ 44,520.00 Mar 15 620 e 150 $ 4500 $42.00 $ 27,900.00 6,300.00 $ 34,200.00 310 120 @ S 42.00/= 5 30.00 $ 13,020.00 3,600.00 $ 16,620.00 Aug 21 190 @ 550.00 160 120 1901 $42.00 $ 30.00 = $50.00 5 6,720.00 3,600.00 9,500.00 $ 19,820.00 Septs 520 @ $48.00 1601 120 190 520 $42.00 530.00 - $ 50,00 5 48.00 $ 6,720.00 3.600.00 9,500.00 24.960.00 $ 44,780.00 Sept 10 160 @ 120 1901 @ 240 0 $ 42.00/= $ 30.00 S 50.00 S 48.00 $ 6.720.00 3,600.00 9,500.00 11,520.00 $ 31,340.00 $ 65,540.00 0 0 0 280 @ M $48.00 = 13.440.00 $ 13.440.00 $ 13,440.00 Totals Perpetual FIFO Perpetual LIFU Weighted Average Specific Id Compute the cost assigned to ending inventory using LIFO. (Round your average cost per unit to 2 decimal places.) Perpetual LIFO: Goods Purchased # of Date Cost per Cost of Goods Sold # of units sold Cost per unit Cost of Goods Sold units Cost per unit Inventory Balance # of units Inventory Balance 620 @ $45.00 = $ 27,900.00 Jan 1 Feb 10 310 @ $ 42.00 620 @ $ 45.00 = 310 @ $ 42.00 - $ 27,900.00 13,020.00 $ 40,920.00 Mar 13 120 @ $ 30.00 620 @ $ 45.00 = 310 @ $42.00 - 120 @ $ 30.00 = $ 27,900.00 13,020.00 3,600,00 $ 44,520.00 Mar 15 280 e $ 45.00 = $ 12,600.00 120 @ 310 @ 340 e $ 30.00 $ 42.00 $ 45.00 = 5 3,500.00 13,020.00 15,300.00 $ 31,920.00 $ 12,600.00 Aug 21 1901 $ 50.00 280 @ 190] @ $ 45.00 $ 50.00 $ 12,600.00 9,500.00 $ 22,100.00 Sept 5 520 $ 48.00 280 @ 190 520 @ $ 45.00 550.00 $48.00 $ 12,600.00 9,500.00 24,960.00 $ 47,060.00 Sept 10 280 520 @ 1901 @ $ 48.00 $ 50.00 $ 45.00 $ 12,600.00 $ 24,960.00 9,500.00 34.460 $ 66,380.00 Totals $ 12 600.00 CICOLI Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using weighted average. (Round your average cost per unit to 2 decimal place Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance # of Cost Date per Cost of Goods Sold Inventory # of units units unit unit unit Balance Jan 1 620 @ $ 45.00 $ 27,900.00 Cost per of units sold Cost per Feb 10 310 $ 42.00 6201 @ 310 @ 930 @ $ 45.00 = $ 42.00 $ 44.00 $ 27,900.00 13.020.00 $ 40,920.00 Average Mar 13 120 @ $ 30.00 930 120 @ 1,050 @ $44.00 530.00 - $ 42.40 $ 40,920.00 3,500.00 5 44,520.00 Mar 15 7701 $ 42.40 $ 32,648.00 280 $42.40 $ 11,872.00 Aug 21 190 @ $50.00 280 @ 190 542.40 = 550.00 $ 45.47 $ 11,872.00 9,500.00 $ 21,372.00 Average 470 e Sept 5 520 $ 48.00 470 @ 520 @ 990 @ $ 45.47 $ 48.00 $ 46.80 $ 21,370.90 24,960.00 $ 46,330.90 710 @ $ 46.80 280 @ $ 46.80= Sept 10 Totals $ 33,228.00 $ 65,876.00 5 13.104.00 ( Perpetual LIFO Specific Id> Verpetuat FIFO Perpetual LIFO weighted Average Specific Id Cost of Goods Sold Ending Inventory Cost per Cost per Cost per w of units sold Cost of Goods Sold unit # of units in ending inventory unit Ending Inventory 0 $45.00 $ 0 Specific identification Cost of Goods Available for Sale Cost of #of units Goods unit Available for Sale Beginning inventory 620 $ 45,00 $ 27,000 Purchases Fob 10 310 S 42.00 16,800 March 13 120 $ 30.00 5,400 Aug 21 1905 50.00 5.000 Sep 5 520 $ 48.00 23,000 Totat 1,760 $ 77,200 210 $42.00 8,820 0 0 0 $ 8,820 10015 42.00 $ 30.00 $ 50.00 5 48.00 100 4.200 0 0 0 $ 4,200 210 Verpetuat FIFO Perpetual LIFO weighted Average Specific Id Cost of Goods Sold Ending Inventory Cost per Cost per Cost per w of units sold Cost of Goods Sold unit # of units in ending inventory unit Ending Inventory 0 $45.00 $ 0 Specific identification Cost of Goods Available for Sale Cost of #of units Goods unit Available for Sale Beginning inventory 620 $ 45,00 $ 27,000 Purchases Fob 10 310 S 42.00 16,800 March 13 120 $ 30.00 5,400 Aug 21 1905 50.00 5.000 Sep 5 520 $ 48.00 23,000 Totat 1,760 $ 77,200 210 $42.00 8,820 0 0 0 $ 8,820 10015 42.00 $ 30.00 $ 50.00 5 48.00 100 4.200 0 0 0 $ 4,200 210

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Security And Auditing Of Smart Devices

Authors: Sajay Rai, Philip Chukwuma, Richard Cozart

1st Edition

0367567997, 978-0367567996

More Books

Students also viewed these Accounting questions