Question
Required: 1. Compute cost of goods available for sale and the number of units available for sale. 2. Compute the number of units in ending
Required: 1. Compute cost of goods available for sale and the number of units available for sale.
2. Compute the number of units in ending inventory.
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 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 from the September 5 purchase.
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.)
5. The companys manager earns a bonus based on a percent of gross profit. Which method of inventory costing produces the highest bonus for the manager?
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Units Sold at Retail 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 Units Acquired at Cost 540 units @ $40 per unit 320 units @ $36 per unit 100 units @ $24 per unit 120 units @ $45 per unit 520 units @ $41 per unit 650 units @ $85 per unit 640 units @ $85 per unit 1,290 units 1,600 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 units 2. Compute the number of units in ending inventory. Ending inventory units 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 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: Goods Purchased Cost of Goods Sold Inventory Balance # of units Cost Inventory units 540 @ $ 40.00 = $ 21,600.00 # of Cost Date Cost per unit # of units sold per unit Cost of Goods Sold per unit Balance Jan 1 Feb 10 Mar 13 Mar 15 Aug 21 Sept 5 Sept 10 Totals S 0.00 $ 0.00 Perpetual FIFO Perpetual LIFO > 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 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 LIFO. (Round your average cost per unit to 2 decimal places.) Perpetual LIFO: Goods Purchased # of Cost units per unit Cost of Goods Sold Cost Date # of units sold per unit Cost of Goods Sold Inventory Balance Cost # of units Inventory per unit Balance 540 @ $ 40.00 = $ 21,600.00 Jan 1 Feb 10 Mar 13 Mar 15 Aug 21 Sept 5 Sept 10 0 Totals $ 0.00 Perpetual FIFO Weighted Average > 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 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 weighted average. (Round your average cost per unit to 2 decimal places.) Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance #of Cost of Goods Sold Inventory units Balance 540 @ $ 40.00 = $21,600.00 Cost Cost Date # of units sold # of units Cost per unit per unit per unit Jan 1 Feb 10 Average Mar 13 Mar 15 Aug 21 Average Sept 5 Sept 10 Totals $ 0.00 3. Compute the cost assigned to ending inventory using (a) FIFO. (6) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 from the September 5 purchase. Complete this question by entering your answers in the tabs below. Cost per Perpetual FIFO Perpetual LIFO Weighted Specific Id Average Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold consist of 540 units from beginning inventory, 220 from the February 10 purchase, 100 from the March 13 purchase, 70 from the August 21 purchase, and 360 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Specific Identification cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Cost of Cost of # of units Cost per Goods # of units Cost per Ending # of units Goods unit Available sold unit in ending Sold inventory unit Inventory for Sale Beginning inventory 540 S 40.00 $ 27,000 0 $ 40.00 S 0 Purchases: Feb 10 320 S 36.00 16,800 220 $36.00 7.920 100 $36.00 3,600 March 13 100 $ 24.00 5,400 0 $ 24.00 0 Aug 21 120 S 45.00 5,000 0 $ 45.00 0 Sep 5 520 S 41.00 23,000 0 $ 41.00 0 Total 1,600 $ 77,200 220 $ 7,920 100 S 3,600
Step 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