Weighted average cost method with perpetual inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. Date 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00 1,500,000 25,000 82.00 2,050,000 30,000 150.00 4,500,000 10,000 88.40 884,000 19,000 150.00 2,850,000 Purchases Quantity Purchases Unit Cost Purchases Total Cost Cost of Goods Sold Quantity Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost

Weighted average cost method with perpetual inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. Date 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00 1,500,000 25,000 82.00 2,050,000 30,000 150.00 4,500,000 10,000 88.40 884,000 19,000 150.00 2,850,000 Purchases Quantity Purchases Unit Cost Purchases Total Cost Cost of Goods Sold Quantity Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost

Name: 2. Determine the total sales, the total cost of goods sold, and the g
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.Total salesTotal cost of goods sold $Gross profit3. Determine the ending inventory cost as of March 31.$ Weighted average cost method with per

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Weighted Average Cost Flow Method Under Perpetual Inventory System The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $20 Apr. 19 Sale 2,500 units June 30 Purchase 6,000 units at $24 Sept. 2 Sale 4,500 units Nov. 15 Purchase 1,000 units at $25 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round unit cost to two decimal places, if necessary. Schedule of Cost of Goods SoldWeighted Average Cost Flow Method Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Jan. 1 fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Apr. 19 fill in the blank 4 $fill in the blank 5 $fill in the blank 6 fill in the blank 7…
The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are shown in Problem 7-1A. Adjunt Problem 7-1A Instructions 1. Determine the inventory on March 31 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 2. Determine the inventory on March 31 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 3.Determine the inventory on March 31 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the nearest cent. 4.Compare the gross profit and the March 31 inventories, using the following column headings: FIFO Lifo Weighted average…
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 50 units at $126 Mar. 10 Purchase 40 units at $136 Aug. 30 Purchase 30 units at $140 Dec. 12 Purchase 80 units at $142 There are 40 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of goods sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Ending Inventory and Cost of Goods Sold Inventory Method Ending Inventory Cost of Goods Sold First-in, first-out (FIFO) $ $ Last-in, first-out (LIFO) Weighted Average Cost
Periodic inventory by three methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00 1,500,000 25,000 82.00 2,050,000 30,000 150.00 4,500,000 10,000 88.40 884,000 19,000 150.00 2,850,000 1. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Inventory, March 31 $ 966,000 ✓ Cost of goods sold $ 6,940,500 2. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the…
Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 50 units @ $106 Mar. 10 Purchase 60 units @ $118 Aug. 30 Purchase 20 units @ $122 Dec. 12 Purchase 70 units @ $124 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Merchandise Inventory and Cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold First-in, first-out (FIFO) $ $ Last-in, first-out (LIFO) Weighted average cost
Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory Aug. 13 Purchase Nov. 30 Purchase Available for sale There are 22 units of the item in the physical Inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first- out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). 20 units at $29 7 units at $31 9 units at $32 36 units $580 217 288 $1,085 a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted averi Chapter 7 homework assignment take frame
Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan.1 Inventory 27 units at $400 per unit Feb. 19 Purchase 55 units at $460 per unit June 8 Purchase 62 units at $540 per unit Oct. 7 Purchase 57 units at $550 per unit There are 46 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost under each of the following methods. a. Determine the inventory cost by the first-in, first-out method.$ b. Determine the inventory cost by the last-in, first-out method.$ c. Determine the inventory cost by the average cost method. Do not round intermediate calculation and round final answer to the nearest whole value.$
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 1,045 units @ $130 Feb. 17 Purchase 1,380 units @ $132 July 21 Purchase 1,660 units @ $135 Nov. 23 Purchase 1,130 units @ $137 There are 1,205 units of the item in the physical inventory at December 31. The periodic inventory system is used. a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost by the last-in, first-out method. C. Determine the inventory cost by the weighted average cost method. Do not round intermediate calculation and round final answer to the nearest whole dollar. 11:52 PM 5/20/2021 DI %24 %24 %24
Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units e $94 Mar. 10 Purchase 70 units e $102 Aug. 30 Purchase 30 units e $106 Dec. 12 Purchase 60 units e $110 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the Inventory cost and the cost of merchandise sold by three methods. Round Interim calculations to one decimal and final answers to the nearest whole dollam Cost of Merchandise Inventory and Cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold a. First-in, first-out (FIFO) S b. Last-in, first-out (LIFO) c. Weighted average cost
Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 50 units @ $102 Mar. 10 Purchase 60 units @ $114 Aug. 30 Purchase 20 units @ $122 Dec. 12 Purchase 70 units @ $128 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Merchandise Inventory and Cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold First-in, first-out (FIFO) $fill in the blank 1 $fill in the blank 2 Last-in, first-out (LIFO) fill in the blank 3 fill in the blank 4 Weighted average cost fill in the blank 5
Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units @ $114 Mar. 10 Purchase 70 units @ $126 Aug. 30 Purchase 20 units @ $134 Dec. 12 Purchase 70 units @ $140 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Merchandise Inventory and Cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold First-in, first-out (FIFO) $fill in the blank 1 $fill in the blank 2 Last-in, first-out (LIFO) fill in the blank 3 fill in the blank 4 Weighted average cost fill in the blank 5 fill in the blank 6
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $102 Mar. 10 Purchase 50 units at $110 Aug. 30 Purchase 10 units at $116 Dec. 12 Purchase 100 units at $118 There are 60 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of goods sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Ending Inventory and Cost of Goods Sold Inventory Method Ending Inventory Cost of Goods Sold First-in, first-out (FIFO) $fill in the blank 1 $fill in the blank 2 Last-in, first-out (LIFO) fill in the blank 3 fill in the blank 4 Weighted average cost fill in the blank 5 fill in the blank 6