Consider the following transactions for DeTrees Company for the month shown in chronological order: Number of Units Beginning inventory 100 Purchased 80 Unit Cost $66 75 Sales Sold 50 Sold Ending inventory 25 105 $120 125 In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using perpetual inventory updating. PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$" (i.e. $12,345.67). [HINT - You definitely will want to consider using this EXCEL spreadsheet Final Chapter10 #1 #2 Worksheets.xlsx to assist in your calculations.] Weighted average cost per unit = $70 per unit. Cost Allocation Cost of Goods Available Cost of Goods Sold Ending Inventory Sales Gross Margin Method First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)

Consider the following transactions for DeTrees Company for the month shown in chronological order: Number of Units Beginning inventory 100 Purchased 80 Unit Cost $66 75 Sales Sold 50 Sold Ending inventory 25 105 $120 125 In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using perpetual inventory updating. PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$" (i.e. $12,345.67). [HINT - You definitely will want to consider using this EXCEL spreadsheet Final Chapter10 #1 #2 Worksheets.xlsx to assist in your calculations.] Weighted average cost per unit = $70 per unit. Cost Allocation Cost of Goods Available Cost of Goods Sold Ending Inventory Sales Gross Margin Method First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)

Name: Consider the following transactions for DeTrees Company for the month
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Consider the following transactions for DeTrees Company for the month shown in chronological order:Number of UnitsBeginning inventory100Purchased80Unit Cost$6675SalesSold50SoldEnding inventory25105$120125In the table below, calculate the dollar valu

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

FLCL Company had the following transactions for the month: Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. first-in, first-out (FIFO) last-in, first-out (LIFO) weighted average
Scrappers Supplies tracks the number of units purchased and sold throughout each accounting perlod but applies Its inventory costing method at the end of each period, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31. Transactions Units Unit Cost Beginning inventory, January 1 Transactions during the year: a. Purchase on account, March 2 b. Cash sale, April 1 ($48 each) c. Purchase on account, June 30 d. Cash sale, August 1 ($48 each) 170 $ 32 330 34 (410) 220 38 (80) Required: 1-a. Calculate the Cost of Goods Sold and Ending Inventory for Scrappers Supplies assuming it applies the LIFO cost method perpetually at the time of each sale. TIP: The sale of 410 units on April 1 is assumed, under LIFO, to consist of the 330 units purchased March 2 and 80 units from beginning inventory. 1-b. Does the use of a perpetual inventory system result in a higher or lower Cost of Goods…
You have the following information for Van Gogh Inc. for the month ended October 31, 2025.Van Gogh uses a periodic method for inventory. Date Description Units unit cost Selling price per unit 1-Oct Beginning inventory 60 $24 9-Oct Purchase 120 $26 11-Oct Sale 100 $35 17-Oct Purchase 100 $27 22-Oct Sale 60 $40 25-Oct Purchase 70 $29 29-Oct Sale 110 $40 1. Calculate (i) ending inventory, (ii) cost of goods sold, (iii) gross profit, and (iv) gross profitrate under LIFO.2. Calculate (i) ending inventory, (ii) cost of goods sold, (iii) gross profit, and (iv) gross profit rateunder FIFO.3. Calculate (i) ending inventory, (ii) cost of goods sold, (iii) gross profit, and (iv) gross profit rateunder Average-cost (round cost per unit to three decimal places.) Please dont provide solution image based thanku
There are such data of the ABC Company’s activity. The company uses perpetual inventory updating. Number of Units Unit Cost, $ Sales prise, $ Beginning inventory 900 60 Purchased 700 65 Sold 1 900 100 Sold 2 200 120 Ending inventory Find ending inventory and its cost Calculate the cost of goods sold in units and in dollar value for Company ABC for the month. Provide calculations for first-in, first-out (FIFO) method. Find Gross margin for the 1-st and 2-d sells
In chronological order, the inventory, purchases, and sales of a single product for a recent month are as follows (see attached). 1.Using the periodic inventory system, compute the cost of ending inventory, cost of goods sold, and gross margin. Use the average-cost, FIFO, and LIFO inventory costing methods. (Round unit costs to cents and totals to dollar.) 2.Explain the differences in gross margin produced by the three methods.
The following data are available for Sellco for the fiscal year ended on January 31, 2020: Sales 830 units Beginning inventory 230 units @ $ 4 Purchases, in chronological order 290 units @ $ 5 450 units @ $ 7 250 units @ $ 7 Required:a. Calculate cost of goods sold and ending inventory under the cost flow assumptions, FIFO, LIFO and Weighted average (using a periodic inventory system): (Round unit cost to 2 decimal places.) b. Assume that net income using the weighted-average cost flow assumption is $15,300. Calculate net income under FIFO and LIFO. (Round unit cost to 2 decimal places.)
You have the following information for Bramble Inc. for the month ended October 31, 2022. Bramble uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 54 $23 Oct. 9 Purchase 132 25 Oct. 11 Sale 108 34 Oct. 17 Purchase 103 26 Oct. 22 Sale 55 39 Oct. 25 Purchase 65 28 Oct. 29 Sale 121 39
Atlas Company uses the perpetual inventory costing system. The company has provided the following data for the current period: Units Total $ 800.00 $1,540.00 $ 960.00 $6,000.00 Date Transaction 1-Nov Beginning balance 4-Nov Purchases 40.00 70.00 40.00 6-Nov Purchases 7-Nov Sales 100.00 Calculate the total purchases for the period given per FIFO $20.00 $22.00 $24.00 $60.00
Givens Company uses a periodic inventory system.Its records show the following for the month of december 2019,in which 68 units were sold at$100 per unit. Units Units Cost Total Cost December 1 Beginning inventory 30 $9 $270 15 Purchase 25 $11 $275 24 Purchase 35 $12 $420 Totals 90 $965 Required: (show all calculate the Cost of Goods Sold on December 31,2019 for Given Company using the following cost flow assumptions: a.Calculate the Cost of Goods Sold on December 31,2019 for Given Company using the following cost flow assumptions: i)Weighted Average Cost method and ii) First-In-First-Out(FIFO) method. b.calculate the Gross Profit for the month ended December 31,2019 for Given Company using the following cost flow assumptions: i)Weighted Average Cost method and ii) First-In-First-Out(FIFO) method.
What is the Weighted average cost per unit?
The accounting records of Sheridan Company show the following data. Beginning inventory 2,710 units at $5 Purchases 7,470 units at $7 Sales 9,376 units at $10 Calculate average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Average unit cost ______ Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost Cost of goods sold: FIFO, LIFO, Average cost
You are provided with the following information for Lily Inc. for the month ended June 30, 2022. Lily uses the periodic method for inventory system. Date Description Quantity Unit Cost orSelling Price June 1 Beginning inventory 40 $34 June 4 Purchase 135 37 June 10 Sale 110 60 June 11 Sale return 15 60 June 18 Purchase 55 40 June 18 Purchase return 10 40 June 25 Sale 54 65 June 28 Purchase 35 43 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.225.) Weighted-average unit cost $Enter the weighted-average cost per unit in dollars