Question

In: Accounting

Inventory Costing Worksheet Practice &

Inventory Costing Worksheet Practice

Units Cost per unit

Beginning inventory 30 $10

Puirchase 3/31 20 $11

Purchase 4/30 20 $12

Purchase 5/31 30 $13

There is a total of 100 units. 65 units were sold, therefore 35 units were in ending inventory. Calculate the following under the periodic method for costing inventory

Compute cost of goods sold under FIFO.

Compute ending inventory under FIFO.

Compute cost of goods sold under LIFO.

Compute ending inventory under LIFO.

Compute cost of goods sold under average cost.

Compute ending inventory under average cost.

Expert Solution

Solution

Compute cost of goods sold under FIFO.= $700

Compute ending inventory under FIFO.= $450

Compute cost of goods sold under LIFO.= $795

Compute ending inventory under LIFO.= $355

Compute cost of goods sold under average cost.= $748

Compute ending inventory under average cost.= $403

Working

	Units	Cost per unit	value
Beginning Balance	30	$ 10.00	$ 300
Purchases
	20	$ 11.00	$ 220
	20	$ 12.00	$ 240
	30	$ 13.00	$ 390

Cost of goods available for sale	100		$ 1,150

.

Average Cost of Inventory

Units	(A)	100
Total Cost	(B)	$ 1,150
Average Cost	(C=B/A)	$ 11.50

.

FIFO
Total Units Available for sale		100
Units Sold		65
Closing Stock in Units		35

Valuation
Ending Inventory	30	@	$ 13.00	$ 390
	5	@	$ 12.00	$ 60

Value Of Ending Inventory				$ 450

Cost of Goods sold	1150 minus 450			$ 700
LIFO
Total Units Available for sale		100
Units Sold		65
Closing Stock in Units		35

Valuation
Ending Inventory	30	@	$ 10.00	$ 300
	5	@	$ 11.00	$ 55

Value Of Ending Inventory				$ 355

Cost of Goods sold	1150 minus 355			$ 795

Weighted Average method
Total Units Available for sale		100
Units Sold		65
Closing Stock in Units		35

Valuation
Ending Inventory	35	@	$ 11.50	$ 403

Value Of Ending Inventory				$ 403

Cost of Goods sold	(Total Purchase and opening stock Minus Closing Stock)			$ 748

ekkarill92 answered 2 years ago

transcription and translation practice worksheet

I'm working on the worksheet aspect of this practice set and my adjustments are not lining...

I'm working on the worksheet aspect of this practice set and my adjustments are not lining up with the adjusted trial balance. Could someone please help me with the adjusting entries? I'll post them and the original entries for reference, thank you. ORIGINAL ENTRIES: DECEMBER TRANSACTION DATA Dec 1 Homer’s pays $1,200 for a one year insurance policy. The term of the policy is from 12/1/19 through 11/30/20. Dec 1 Homer’s purchases Equipment (a forklift) for $10,000, paying...

Cat worksheet: use in combination with the cat photos provided in the module to practice your...

Cat worksheet: use in combination with the cat photos provided in the module to practice your dihybrid cross skills **refer to text sections 9.4 & 9.5 to help you during this exercise** Look at the photographs of domestic cats found in this module and take a look at the information on Mendelian traits that control the appearance of cats’ coats found below: Coat uniformity is controlled by genes at the P locus: genotype (P--) = white patches of fur &...

This chapter is about inventory costing and capacity analysis. Specifically, it discusses alternative inventory costing methods...

This chapter is about inventory costing and capacity analysis. Specifically, it discusses alternative inventory costing methods (variable, absorption and throughput), alternative income statement format presentations (variable and absorption costing operating income) and alternative denominator-level capacity concepts (theoretical, practical and normal capacities). Let's pretend that you are introducing these concepts to a group of cost accounting students. In three sentences or less, explain why this chapter is important and how to balance management incentives with full and fair inventory disclosure when...

Match each statement below with the appropriate inventory costing method. 1. This inventory costing method shows...

Match each statement below with the appropriate inventory costing method. 1. This inventory costing method shows cost of goods sold on the income statement at the most current inventory costs during a period of deflation 2. This inventory costing method results in the highest amount of income tax expense reported on the income statement during a period of deflation 3. This inventory costing method results in the highest amount paid to purchase inventory during a period of inflation

How are intra-entity inventory transfers treated on the consolidation worksheet and how are they reflected in...

How are intra-entity inventory transfers treated on the consolidation worksheet and how are they reflected in a consolidated statement of cash flows?

Perpetual Inventory Using The method of inventory costing based on the assumption that the costs of...

Perpetual Inventory Using The method of inventory costing based on the assumption that the costs of goods sold should be charged against revenue in the order in which the costs were incurred.FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 53 units at $93 10 Sale 39 units 15 Purchase 25 units at $99 20 Sale 22 units 24 Sale 12 units 30 Purchase 24 units at $105 The business maintains a perpetual...

6. Periodic Inventory System and Inventory Costing Methods In chronological order, the inventory, purchases, and sales...

6. Periodic Inventory System and Inventory Costing Methods In chronological order, the inventory, purchases, and sales of a single product for a recent month are as follows: Units Amount per Unit June 1 Beginning inventory 150 $30 4 Purchase 400 33 12 Purchase 800 36 16 Sale 1,300 60 24 Purchase 300 39 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....

Exercise 6.2 worksheet - MONOHYBRID PRACTICE PROBLEMS 1. Cystic fibrosis is an autosomal recessive genetic disorder....

Exercise 6.2 worksheet - MONOHYBRID PRACTICE PROBLEMS 1. Cystic fibrosis is an autosomal recessive genetic disorder. Ron is homozygous dominant (FF) and Nancy is a carrier (Ff ) of cystic fibrosis. Use a Punnett square to predict the genotypic and phenotypic ratios of their offspring who are normal, normal carriers, and affected. Show all your work. Assign symbols for each allele. Parents (P): Male ♂ = Female ♀ = Key Punnett Square: First Generation (F1) Genotypic Ratio: Phenotypic Ratio: 2....

Hi, I am struggling to understand this worksheet my professor gave us for practice. Could someone...

Hi, I am struggling to understand this worksheet my professor gave us for practice. Could someone make any sense of this? The scenario: Sodium is found largely in the extracellular compartment with concentrations between 130-145 mM with intracellular sodium concentrations between 3.5-5mM. This chemical difference gives sodium a large concentration gradient, which when permitted (by opening of a channel or through facilitated transport) will move down its concentration gradient to enter the cell. Sodium also has a favorable electrical gradient;...