Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sorry this is a long one. Thank you. Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions.
Sorry this is a long one. Thank you.
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 600 units @ $35 per unit 300 units @ $32 per unit 150 units @ $20 per unit Date January 1 February 10 March 13 March 15 August 21 September 5 September 10 Activities Beginning inventory Purchase Purchase Sales Purchase Purchase Sales Totals 725 units @ $80 per unit 190 units @ $40 per unit 540 units @ $37 per unit 730 units @ $80 per unit 1,455 units 1,780 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 61,180 1,780 units 2. Compute the number of units in ending inventory. Ending inventory 325 units 3. Compute the cost assigned to ending Inventory using (2) FIFO. (6) LIFO. (weighted average, and (d specific Identification. (For specific identification, units sold consist of 600 units from beginning Inventory. 200 from the February 10 purchase, 150 from the March 13 purchase. 140 from the August 21 purchase, and 365 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 FIFO. (Round your average cost per unit to 2 decimal places.) Perpetual FIFO: Cost of Goods Sold # of units Cost sold Cost of Goods Sold Goods Purchased Cost # of units Date per unit per unit January 1 300 at $ 32.00 February 10 Inventory Balance Cost # of units Inventory per unit Balance 600 at $35.00 = $ 21,000.00 600 at $ 35.00 = $ 21,000.00 300 at $32.00 = 9.600.00 $ 30,000.00 600 at $35.00 = $ 21,000.00 300 at $32.00 = 9.800.00 150 at $ 20.00 = 3,000.00 $ 33.600.00 Total February 10 150 at $ 20.00 March 13 Total March 13 = March 15 600 at 125 at 0 at $ 35.00 $ 32.00 $ 20.00 = $ 21,000.00 4,000.00 0.00 $ 25,000.00 0 at 175 at 150 at $ 35.00 = $32.00 = $20.00] = 5.800.00 3,000.00 $ 8.600.00 Total March 15 1901 at $ 40.00 August 21 0 at 175 at 150 at 190) at $ 35.00 - $32.00 = $20.00 = $40.00= $ 0.00 5,000.00 3,000.00 7,600.00 $ 16,200.00 Total August 21 540 at $ 37.00 September 5 0 at 175 at 150 at 190) at 540 at $35.00 = $32.00 = $ 20.00 = $40.00 = $37.00 = Total September 5 = $ = 0 at 175 at 150 at 1901 at 215 at September 10 $ 35.00 $ 32.00 $ 20.00 $ 40.00 $ 37.00 $ 0.00 5.600.00 3,000.00 7,600.00 19.980.00 $ 35,180.00 $ 0.00 0.00 0.00 0.00 12.025.00 $ 12,025.00 $ 12,025.00 = 0 at o at 0 at 0 at 325 at $35.00= $32.00 = $ 20.00 = $40.00 = $37.00 = $ 5,600.00 3.000.00 7.600.00 7.955.00 $ 24,155.00 $ 49,155.00 = Total September 10 Totals 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.) Goods Purchased Cost # of units per unit Date Perpetual LIFO: Cost of Goods Sold # of units Cost sold Cost of Goods Sold per unit January 1 Inventory Balance Cost # of units Inventory per unit Balance 800 at $ 35.00 = $ 21,000.00 600 at $ 35.00 $ 21,000.00 300 at S 32.00 = 9,600.00 $ 30,600.00 300 at $ 32.00 February 10 Total February 10 150 at $20.00 March 13 600 a: 300 at 150 at $ 35.00 = S 32.00 = S 20.00 = $ 21,000.00 9,600,00 3,000.00 $ 33,600.00 Total March 13 = 275 at 300 at March 15 $35.00 $ 32.00 $ 20.00 = $ 9,625.00 9,800.00 3,000.00 $ 22,225.00 325 at 0 at 0 at S 35.00= S 32.00 = $ 20.00 = S 11,375.00 0.00 0.00 S 11,375.00 150 at = Total March 15 1901 at S 40.00 August 21 325 at 0 at 0 at 190 at $ 35.00 = S 32.00 = $ 20.00 = S 40.00 = S 11,375.00 0.00 0.00 7,600.00 S 18,975.00 Total August 21 540 at $ 37.00 September 5 325 at 0 at 0 at 190 540 $ 35.00 = S 32.00 $ 20.00 S 40.00 = $ 37.00 = S 11,375.00 0.00 0.00 7,600.00 19.980.00 $ 38,955.00 Total September 5 " 0 at 0 at indi September 10 $ 35.00 $ 32.00 $ 20.00 $ 40.00 $ 37.00 0 at 190 at 540 at = $ 0.00 0.00 0.00 7,600.00 19.980.00 27,580.00 $ 49,805.000 325 at 0 at 0 at 0 at 0 at $ 35.00 S 32.00 = $ 20.00 = S 40.00 = $ 37.00 = S 11.375.00 0.00 0.00 0.00 0.00 1" = Total September 10 Totals S 11,375.00 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: Cost of Goods Sold # of units Cost Cost of Goods Sold sold Goods Purchased Cost # of units Date Inventory Balance Cost # of units Inventory per unit Balance 600 at $35.00 = $ 21,000.00 per unit per unit January 1 300 at $32.00 February 10 600 at 300 at 900 at $ 35.00 = $ 32.00 = $35.00] = $ 21,000.00 9.600.00 $ 30.600.00 Average February 10 150 at $20.00 March 13 600 at 150 at 750 at $ 35.00 = $ 20.00 = Average March 13 March 15 $ 21,000.00 3,000.00 $ 24,000.00 $10.400.00 725 at $ 32.00 = $ 23,200.00 325 at 190) at $ 40.00 August 21 325 at 190) at $ 10,400.00 7,600.00 $ 18,000.00 Average August 21 $32.00] = $32.00 = $ 40.000 = $ 35.00 - $35.00 = $37.00 = $38.00) = 515) at 5401 at $37.00 September 5 515 at 540 at 1,055 at $ 18,025.00 19.980.00 $ 38,005.00 Average September 5 September 10 Totals 730 at $38.00 = 325) at $38.00= $ 11,700.00 $ 26,280.00 S 49,480.00 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 600 units from beginning inventory, 200 from the February 10 purchase, 150 from the March 13 purchase, 140 from the August 21 purchase, and 365 from the September 5 purchase.) Date = January 1 February 10 March 13 August 21 September 5 Totals Goods Purchased Cost # of units per unit 600 at $ 35.00 300 at $32.00 150 at $ 20.00 190) at $ 40.00 540 at $ 37.00 1.780 Specific Identification: Cost of Goods Sold # of units Cost sold Cost of Goods Sold per unit at $35.00 $ 0.00 at $32.00 at $ 20.00 0.001 at $ 40.00 at $ 37.00 = 0.00 0 $ 0.00 Inventory Balance Cost # of units Inventory per unit Balance at $ 35.00 = $ 0.00 at $32.00 = at $ 20.00 = 0.00 at $ 40.00 = at $ 37.00 = 0.00 0 $ 0.00 ++ oi 4. Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places.) FIFO LIFO Weighted Average Specific Identification Sales Less: Cost of goods sold Gross profit 5. The company's manager earns a bonus based on a percent of gross profit. Which method of Inventory costing produces the highest bonus for the manager? O Weighted Average O FIFO OLIFO Specific IdentificationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started