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)

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter10: Inventory
Section: Chapter Questions
Problem 5EA: Akira Company had the following transactions for the month. Calculate the ending inventory dollar...
icon
Related questions
Topic Video
Question
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
Method
Cost of Goods
Cost of Goods Sold Ending Inventory
Sales
Gross Margin
Available
First-in,
First-out
(FIFO)
Last-in,
First-out
(LIFO)
Weighted
Average
(AVG)
Transcribed Image Text: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 Method Cost of Goods Cost of Goods Sold Ending Inventory Sales Gross Margin Available First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,