Question

In: Accounting

PLEASE SHOW ME THE CALCULATION SheldonSheldon ​Company's inventory records for the most recent year contain the...

PLEASE SHOW ME THE CALCULATION

SheldonSheldon

​Company's inventory records for the most recent year contain the following​ data:

LOADING...

​(Click the icon to view the​ data

THE DATA IS POSTED BELOW

SheldonSheldon

Company sold a total of

21 comma 10021,100

units during the year.Read the requirements

LOADING...

.

Requirement 1. Using the​ average-cost method, compute the cost of goods sold and ending inventory for the year. ​(Round the average cost per unit to the nearest​cent.)

Using the average-cost method, the cost of goods sold is

$

and the ending inventory is

$

.

Requirement 2. Using the FIFO​ method, compute the cost of goods sold and ending inventory for the year.

Using the FIFO method, the cost of goods sold is

$

and the ending inventory is

$

.

Quantity  Unit Cost

Beginning inventory-  9,000 $18.00

Purchases during year - 16,000  $20.00

Solutions

Expert Solution

  • All working forms part of the answer
  • Requirement 1

--Working

Beginning Inventory cost = 9000 x 18 = $ 162,000
Purchase cost = 16000 x $ 20 = $ 320,000

Total cost of Goods available for sale = 320000 + 162000 $ 482,000
Total units available = 9000 + 16000 = 25,000 units

Average cost = 482000 / 25000 = $ 19.28 per unit

--Answer

Using the average-cost method, the cost of goods sold is

$ 406,808

[21,100 units x $ 19.28]

and the ending inventory is

$ 75,192

[ (9000 + 16000 – 21100) units x $ 19.28]

  • Requirement 2

Cost of goods sold:

Ending inventory is

   From Beginning balance

$ 162,000

[9000 x $ 18]

   From Beginning balance

$ 0

[0 units x $ 18]

   From Purchases

$ 242,000

[12100 x 20]

   From Purchases

$ 78,000

[3900 x 20]

Using the FIFO method, the cost of goods sold is

$ 404,000

and the ending inventory is

$ 78,000


Related Solutions

Spencer Company's inventory records for the most recent year contain the following data: Spencer Company sold...
Spencer Company's inventory records for the most recent year contain the following data: Spencer Company sold a total of 19,200 units during the year.   Beginning Inventory 4,000 $ 8.00 Purchases during year 16,000 $ 12.00 1. Using the average-cost method, compute the cost of goods sold and ending inventory for the year.   2. Using the FIFO method, compute the cost of goods sold and ending inventory for the year. 3. Using the LIFO method, compute the cost of goods sold...
SimpsonSimpson ​Company's inventory records for the most recent year contain the following​ data: Quantity Unit Cost...
SimpsonSimpson ​Company's inventory records for the most recent year contain the following​ data: Quantity Unit Cost Beginning inventory 2,000 $8.00 Purchases during year 18,000 $10.00 Simpson Company sold a total of 19,800 units during this year. 1. Using the average- cost method, compute the cost of goods sold and the ending inventory of the year. 2. Using the FIFO method, compute the cost of goods sold and the ending inventory of the year. 3. Using the LIFO method, compute the...
The records of the Dodge Corporation show the following results for the most recent year: Sales...
The records of the Dodge Corporation show the following results for the most recent year: Sales (16,200 units) $ 307,800 Variable expenses 162,000 Net operating income 64,800 Given these data, the unit contribution margin was: $4 $5 $19 $9
Hess Company's inventory records show the following data for the month of September:                             &
Hess Company's inventory records show the following data for the month of September:                                                                                       Units                          Unit Cost Inventory, September 1                     100                            $3.00 Purchases: September 8                   450                              3.50                    September 18                    300                              3.70 A physical inventory on September 30 shows 150 units on hand. a. Calculate the value of ending inventory and cost of goods sold if the company uses FIFO inventory costing and a periodic inventory system. b. Calculate the value of ending inventory and cost of goods sold if...
A partial income statement for a company's most recent fiscal year follows: Sales $800,000 Inventory, January...
A partial income statement for a company's most recent fiscal year follows: Sales $800,000 Inventory, January 1 $420,000 Add purchases (a) ___ Goods available for sale (b) Inventory, December 31 470,000 Cost of goods sold (c) Gross margin 250,000 Deduct expenses: Selling (d) Administrative (e) Income before taxes (f) Income taxes (g) Net income (h) Earnings per share (5,000 shares outstanding) $4.20 Additional data: Selling expenses are 20 percent of sales, administrative expenses are 10 percent of cost of goods...
A partial income statement for a company's most recent fiscal year follows: Sales $400,000 Inventory, January...
A partial income statement for a company's most recent fiscal year follows: Sales $400,000 Inventory, January 1 $210,000 Add purchases (a) ____ Goods available for sale (b) ____ Inventory, December 31 235,000 Cost of goods sold (c) ____ Gross margin 125,000 Deduct expenses: Selling (d) ____ Administrative (e) ____ Income before taxes (f) ____ Income taxes (g) ____ Net income (h) ____ Earnings per share (5,000 shares outstanding) $2.10 Additional data: Selling expenses are 20 percent of sales, administrative expenses...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost Inventory, May 1 200 $2.00 Purchases: May 8 200 3.00 May 15 100 4.00 The company uses a periodic inventory system. A physical inventory on May 30 shows 150 units on hand. Assuming FIFO (First-In-First-Out) inventory costing, calculate the cost of goods sold. a. $1,100 b. $850 c. $700 d. $980
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost...
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 100 $3.34 Purchases: September 8 450 3.50 September 18 350 3.70 A physical inventory on September 30 shows 200 units on hand. Calculate the value of the ending inventory and cost of goods sold if the company uses weighted average inventory costing and a periodic inventory system. (Round cost per unit to 2 decimal places and ending inventory and cost of...
Comparison of Inventory Costing Methods—Perpetual System (Appendix) Bitten Company's inventory records show 600 units on hand...
Comparison of Inventory Costing Methods—Perpetual System (Appendix) Bitten Company's inventory records show 600 units on hand on October 1 with a unit cost of $5 each. The following transactions occurred during the month of October: Date Unit Purchases Unit Sales October 4 500 @ $10.00 8 800 @ $5.40 9 700 @ $10.00 18 700 @ $5.76 20 800 @ $11.00 29 800 @ $5.90 All expenses other than cost of goods sold amount to $3,000 for the month. The...
1. Eneri Company's inventory records show the following data: Units Unit Cost Inventory, January 1 5,000...
1. Eneri Company's inventory records show the following data: Units Unit Cost Inventory, January 1 5,000 $9.20 Purchases: June 18 4,500 8.00 November 8 3,000 7.00 A physical inventory on December 31 shows 2,000 units on hand. Eneri sells the units for $13 each. The company has an effective tax rate of 20%. Eneri uses the periodic inventory method. Under the FIFO method, the December 31 inventory is valued at A. $16,133. B. $14,000. C. $16,480. D. $18,400. 2. Priscilla...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT