Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Compute the cost assigned to ending inventory using ( a ) FIFO, ( b ) LIFO, ( c ) weighted average, and ( d

3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 620 units from beginning inventory, 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Units Sold at Retail Units Acquired at Cost 620 units @ $45 per unit 380 units @ $42 per unit 100 units @ $30 per unit Date Activities Jan. 1 Beginning inventory Feb. 10 Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept. 10 Sales Totals 735 units @ $70 per unit 170 units @ $50 per unit 400 units @ $46 per unit 570 units @ $70 per unit 1,305 units 1,670 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 73,760 1,670 units 2. Compute the number of units in ending inventory. Ending inventory 365 units 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. ( weighted average, and (d) specific identification. For specific identification, units sold consist of 620 units from beginning inventory. 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase. Perpetual FIFO: Goods Purchased Cost # of units per unit Cost of Goods Sold Cost Cost of Goods per Sold unit # of units sold Date # of units Jan 1 620 Feb 10 380 IS 42.00 620 380 > Mar 13 100 IS 30.00 620 . 380 100 @ IS Mar 15 620 $ 27,900.00 42 45.00 >> @ @ Inventory Balance Cost per Inventory unit Balance IS 45.00 27,900.00 $ $ 45.00 27.900.00 $ 42.00 15.950.00 IS 43.860.00 $ $ 45.00 27 900.00 $ 42.00 15.960.00 s 30.00 3,000.00 $ 46.880.00 $ 42.00 $ 1.784.00 $ 30.00 900.00 $ 2,664.00 IS 42.00 11,130.00 30.00 3,000.00 $ 50.00 8,500.00 $ 22.630.00 $ IS 42.00 11,130.00 $ 30.00 3,000.00 50.00 8,500.00 $ 46.00 18.400.00 $ 41.030.00 115 30 42.00 4,830.00 $32.730.00 Aug 21 170 50.00 265 100 = 170 Sept 5 400 @ s 46.00 265 100 00 170 400 Sept 10 265 > $ 42.00 $ 11,130.00 100 3,000.00 30.00 170 8.500.00 50.00 IS 46.00 35 1.610.00 365 46.00 $ 24,240.00 16.790.00 $ 16.790.00 $ 16.790.00 Totals $ 56,970.00 Perpetual FIFO Perpetual LIFO > Red text indicates no response was expected in a celor a formula based calculation is incorrect; no points deducted. 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (weighted average, and (a specific identification. For specific identification, units sold consist of 620 units from beginning inventory. 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase. Perpetual FIFO Perpetual LIFO 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 Cost # of per units unit Cost of Goods Sold Cost per Cost of Goods unit Sold Date # of units sold # of units Inventory Balance Cost per Inventory unit Balance IS 45.00 $27.900.00 Jan 1 620 Feb 10 380 IS 42.00 > 620 @ . $27,900.00 IS 45.00 $ 42.00 380 18 15.960.00 $43,860.00 Mar 13 100 620 30.00 $27.900.00 45.00 IS 42.00 380 15.950.00 100 > 2 30.00 3,000.00 $46,860.00 Mar 15 380 $11.400.00 365 IS 45.00 $16,425.00 100 * S 30.00 IS 42.00 $ 45.00 4,200.00 255 11.475.00 $27.075.00 $16.425.00 Aug 21 170 535 > IS 45.00 50.00 $24.075.00 170 50.00 8,500.00 $32.575.00 Sept 5 400 385 . 46.00 $16,425.00 45.00 "IA" 170 8,500.00 50.00 IS 46.00 400 18 18.400.00 $43,325.00 Sept 10 400 $18.400.00 @ $ 45.00 $ 46.00 S 50.00 170 8,500.00 365 26.900 $53,975.00 Totals IS 0.00 Red text indicates no response was expected in a celor a formula-based calculation is incorrect; no points deducted. 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. ( weighted average, and (d) specific identification. For specific identification, units sold consist of 620 units from beginning inventory. 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase. 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 places.) Weighted Average Perpetual: Goods Purchased # of Cost Date units per unit Jan 1 # of units sold Cost of Goods Sold Cost per Cost of Goods Sold unit # of units Inventory Balance Cost Inventory per unit Balance IS $ 45.00 27,900.00 620 Feb 10 380 > IS 42.00 > 620 IS 45.00 380 s 27 900.00 15.960.00 $ 43.860.00 Average 1.000 > Mar 13 100 620 30.00 42.00 s 43.86 IS 43.86 $ 30.00 $ 42.60 IS 27.193.20 11.400.00 380 1.000 80 > > Mar 15 735 42.60 $ 31,311.00 366 Aug 21 170 365 50.00 s 42.60 IS 42.60 $ 50.00 $ 44.95 38,593.20 $ 15.549.00 $ 15.549.00 8,500.00 s 24.049.00 170 Average 535 Sept 5 400 535 @ 46.00 400 s 44.95 $ 46.00 IS 45.40 s 24,048 25 18.400.00 $ 42,448.25 935 Sept 10 570 S 45.40 365 $ 45.40 $ 25,878.00 $ 57,189.00 $ 16.571.00 Totals Red text indicates no response was expected in a celor a formula-based calculation is incorrect: no points deducted. 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (weighted average, and (c) specific identification. For specific identification, units sold consist of 620 units from beginning inventory. 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase. Complete this question by entering your answers in the tabs below. Perpetual FIFO Perpetual LIFO Weighted Average Specific id Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold consist of 620 units from beginning inventory, 280 from the February 10 purchase, 100 from the March 13 purchase, 120 from the August 21 purchase, and 185 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Specific Identification Cost of Goods Sold Ending Inventory Cost of Goods Available for Sale Cost Cost of # of Goods per units Available unit for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory 620 $ 45.00 $ 27.000 620 $ 45.00 27.900 $ 45.00 s 0 Beginning inventory Purchases: Feb 10 March 13 380 4200 100 170 $ 42.00 $ 30.00 $ 50.00 $ 46.00 16,800 5.400 5.000 23.000 $ 77,200 Aug 21 280 $ 42.00 100$ 30.00 120$ 50.00 185$ 46.00 1,305 11,780 3,000 6.000 8.510 $57.170 100 $ 42.00 0$ 30.00 50 $ 50.00 215$ 46.00 365 0 2.500 400 9.690 Sep 5 Total 1.670 $ 16,590

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

College Accounting A Contemporary Approach

Authors: David Haddock, John Price, Michael Farina

3rd edition

978-0077639730

Students also viewed these Accounting questions