Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15:Purchase Jan. 17:Sales Jan. 21: Purchase Jan. 23: Sales Totals Cost of Goods Sold - Perpetual LIFO: 560: 840 890: Ending Inventory- Perpetual LIFO: 2,290; Calculate cost of goods sold for the January 11 sale of 450 units Calculate cost of goods sold for the January 17 sale of 670 units. $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Ending Inventory for January - 370 units $7,840 14,280 16.910 $39,030 @ units @ units @ units @ @ 450 670 800 1,920 Cost per unit $14 $14; Cost per unit $40 $40 $40: per unit = units@ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance

Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15:Purchase Jan. 17:Sales Jan. 21: Purchase Jan. 23: Sales Totals Cost of Goods Sold - Perpetual LIFO: 560: 840 890: Ending Inventory- Perpetual LIFO: 2,290; Calculate cost of goods sold for the January 11 sale of 450 units Calculate cost of goods sold for the January 17 sale of 670 units. $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Ending Inventory for January - 370 units $7,840 14,280 16.910 $39,030 @ units @ units @ units @ @ 450 670 800 1,920 Cost per unit $14 $14; Cost per unit $40 $40 $40: per unit = units@ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance

Name: REQUIRED: Determine the cost assigned to ending inventory and to cost
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Eachyellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO.DateJan. 1 Beginning inventoryJan. 11: SalesJan. 15 Purc

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

urrent ALLE empt mFIogress Flint Corporation uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 120 $6 $720 12 Purchases 360 2,520 23 Purchases 240 1,920 30 Inventory 250 I Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 420 units occurred on June 15 for a selling price of $9 and a sale of 50 units on June 27 for $10. (Round answers to 3 decimal places, e.g. 5.125.) June 1 %24 June 12 $ June 15 $ 7:59 acer 7.
Use the following information for the Exercises 3-7 below. (Algo) [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 385 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Date January 1 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals Units Acquired at Cost 225 units @ $ 15.00- 180 units @ $14.00- 385 units @ $ 12.00 = 790 units $ 3,375 2,520 4,620 $ 10,515 Units sold at Retail 175 units 210 units 385 units Exercise 5-5 (Algo) Perpetual: Gross profit effects of inventory methods LO A1 1. Compute gross profit for the month of January for Laker Company for the four inventory methods. 2. Which method yields the highest gross profit? 3. Does gross profit…
Required information [The following information applies to the questions displayed below.] Ferris Company began January with 6,000 units of its principal product. The cost of each unit is $8. Merchandise transactions for the month of January are as follows: Date of Purchase Jan. 10 Jan. 18 Totals Sales Units 5,000 6,000 11,000 Date of Sale Jan. 5 Jan. 12 Jan. 20 Total Purchases Includes purchase price and cost of freight. Units 3,000 2,000 4,000 9,000 Unit Cost* $9 10 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $105,000 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system.
Cost Flow Methods The following three identical units of Item JC07 are purchased during April: April 2 April 15 April 20 Total Average cost per unit Item Beta Units Cost Purchase 1 $182 Purchase 1 183 Purchase 1 184 3 $549 $183 ($5493 units) Assume that A method of inventory costing in which the cost of the units sold and in ending Inventory is a weighted average of the purchase costs. (b) last-in, first-out (LIFO); and (c) weighted average cost method. Gross Profit Ending Inventory a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost $ $ $
Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 14 $102 $1,428 Sept. 12 Purchases 48 105 5,040 Sept. 19 Purchases 50 106 5,300 Sept. 26 Purchases 23 23 107 2,461 Totals 135 $14,229 (a) Compute the ending inventory at September 30 using the FIFO, LIFO and average-cost methods. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to O decimal places, e.g. 125.) The ending inventory at September 30 $ FIFO $ LIFO $ AVERAGE COST (b) Compute the cost of goods sold at September 30 using the FIFO, LIFO and average-cost methods. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to O decimal places, e.g. 125.) Cost of goods sold EA FIFO +A $ LIFO AVERAGE-COST $
Assume that three identical units of merchandise were purchased during October, as follows: Units Cost October 5 Purchase 1 $ 5 12 Purchase 13 28 Purchase 1 15 Total $33 Assume one unit is sold on October 31 for $28. Determine cost of goods sold, gross profit, and ending inventory under the LIFO method.
HOW DO I CALCULATE THE COST OF THE ENDING INVENTORY AND THE COST OF GOODS SOLD? Date Explanation Units Unit Cost Total Cost June 1 Inventory 150 $4 $600 12 Purchase 450 5 2,250 23 Purchase 400 6 2,400 30 Inventory 80 Assume a sale of 500 units occurred on June 15 for a selling price of $7 and a sale of 420 units on June 27 for $8.
Perpetual Inventory Using LIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 3,800 units at $41 Apr. 19 Sale 2,500 units June 30 Purchase 4,600 units at $45 Sept. 2 Sale 4,900 units Nov. 15 Purchase 1,800 units at $48 The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods Sold LIFO Method Pukchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Jan. 1 Apr. 19 June 30 Sept. 2
March1 Beginning inventory = 29 units @ $5.90 March3 Purchased 15 units @ 3.70 March9 Sold 23 units @ 8.90 1)What is the cost of goods sold for Julia & Company assuming it uses LIFO? Date Transaction Numberof Units UnitCost March 1 Beginning inventory 930 7.22 March 10 Purchase 550 7.64 March 16 Purchase 760 8.14 March 23 Purchase 580 8.54 2)Marvin sold 1,900 units of inventory during the month. Cost of goods sold assuming FIFO would be: 3)A company's sales equal $60,000 and cost of goods sold equals $20,000. Its beginning inventory was $1,600 and its ending inventory is $2,400. The company's inventory turnover ratio equals:
Date Jan. Mar. 12 Sep. 17 Jan. 1-Dec. 31 y lupy yo dinom s Transaction Beginning inventory Purchase Purchase Sales Units p120 90 de 60 270 170 Unit Cost $21 16 9 shol Total Cost $2,520 1,440 540 $4,500 Required: 1. Using FIFO, calculate ending inventory and cost of goods sold. 2. Using LIFO, calculate ending inventory and cost of goods sold. 3. Because of the increasing popularity of electronic video games, Parker Games continues to see a decline in the demand for board games. Sales prices have decreased by over 50% during the year. At the end of the year, Parker estimates the net realizable value of the 100 units of unsold inventory to be $500. Determine the amount of ending inventory to report using lower of cost and net realizable value under FIFO. Record any necessary adjusting entry. 09.10
LIFO During the year, TRC Corporation has the following inventory transactions. Unit Cost $ 52 54 57 58 Date Transaction Jan. 1 Beginning inventory Apr. 7 Purchase Jul.16 Purchase Oct. 6 Purchase Total Beginning Inventory Purchases: 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. Apr 07 Jul 16 Oct 06 For the entire year, the company sells 450 units of inventory for $70 each. Sales revenue Gross profit Cost of Goods Available for Sale Cost of Goods Available for Sale $ # of units 0 Number of Units 60 140 210 120 530 Cost per unit 69 $ 0 0 0 0 0 Total Cost $ 3,120 7,560 11,970 6,960 $29,610 # of units Cost of Goods Sold Cost per unit Cost of Goods Sold Ending Inventory # of units Cost Ending per unit Inventory