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

Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 500       17 Purchase 200 $5.30       25 Sale 150       28 Purchase 100 5.80 May 5 Purchase 250 5.30       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Instructions: 1. Compute the inventories at the end of each month and the cost of goods sold for each month for the following alternatives: FIFO periodic Cost of Goods Sold Ending Inventory April $  fill in the blank 1 $  fill in the blank 2 May $  fill in the blank 3 $  fill in the blank 4 FIFO perpetual Cost of Goods Sold Ending Inventory April $  fill in the blank 5 $  fill in the blank 6 May $  fill in the blank 7 $  fill in the blank 8 LIFO periodic Cost of Goods Sold Ending Inventory…
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 9 units at $48 Feb. 17   Purchase 18 units at $49 Jul. 21   Purchase 6 units at $51 Nov. 23   Purchase 4 units at $51 There are 7 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to the nearest cent and final answers to the nearest whole dollar, if required.
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Date Line Item Description Units and Cost Jan. 1   Inventory 8 units at $24 Feb. 17   Purchase 11 units at $25 Jul. 21   Purchase 10 units at $26 Nov. 23   Purchase 19 units at $26 There are 8 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to the nearest cent and final answers to the nearest whole dollar, if required. a. Determine the inventory cost by the first-in, first-out method.fill in the blank 1 of 3$ b. Determine the inventory cost by the last-in, first-out method.fill in the blank 2 of 3$ c. Determine the inventory cost by the weighted average cost method. Round average unit cost to the two decimal places, and round your final answer to the nearest dollar.fill in the blank 3 of 3$
Inventory Costing Methods Oppenheimer Inc. reported the following information for the month of August: August 1 Inventory 61 units @ $26 August 7 Purchase 60 units @ $27 August 18 Purchase 65 units @ $29 August 27 Purchase 46 units @ $30 During August, Oppenheimer sold 147 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for August under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1. Of the 147 units sold, 51 cost $26, 42 cost $27, 49 cost $29, and 5 cost $30. 4,031 2,440 2. FIFO 2,395 x 4,076 x 24 3. LIFO 4. Weighted average method (Round average unit cost to the nearest cent, $ and round all other calculations and your final answers to the nearest dollar.)
using perpetual inventory
Weighted average cost flow method under perptual inventory system. The following units of a particular item were availabe for sale during the calendar year. Jan. 1 Inventory 4,000 units at $20 April 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 Instructions: The firm uses the weighted averaghe cost method with a perpetual inventory system. Determine the cost of merchandise sold for each sale and the inventory balance after each sale. (chapter 7 question EX 7-9 page 380- immediate accounting I textbook)
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 @ $90 Mar. 10 Purchase 60 units @ $100 Aug. 30 Purchase 20 units @ $108 Dec. 12 Purchase 70 units @ $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 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
Pleas help solve and explain this equation
Beginning inventory, purchases, and sales for an inventory item are as follows: Sep. 1 Beginning Inventory 24 units @ $10 5 Sale 17 units 17 Purchase 10 units @ $15 30 Sale 8 units Assuming a perpetual inventory system and the last-in, first-out method: a. Determine the cost of the goods sold for the September 30 sale.$fill in the blank 1
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 50 units @ $112 Aug. 30 Purchase 30 units @ $120 Dec. 12 Purchase 70 units @ $126 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 a. First-in, first-out (FIFO) $fill in the blank 1 $fill in the blank 2 b. Last-in, first-out (LIFO) fill in the blank 3 fill in the blank 4 c. Weighted average cost fill in the blank 5 fill in the blank 6
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 4 units at $50 Feb. 17 Purchase 8 units at $51 Jul. 21 Purchase 16 units at $53 Nov. 23 Purchase 19 units at $54 There are 14 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to two decimals and final answers to the nearest whole dollar, if required. a. Determine the inventory cost by the first-in, fiest-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.
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 14 units @ $24 Feb. 17 Purchase 6 units @ $25 July 21 Purchase 13 units @ $28 Nov. 23 Purchase 18 units @ $28 There are 14 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. Round average unit cost to the nearest cent and final answers to the nearest whole dollar, if required.