Compute the cost of goods sold in both units

Reference no: EM131021313

During April, Leary Company sold 1,000 units of Product Q. Product Q’s beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.)

Assignment Template attached below

April 1	Beginning inventory	200 units @ $1
April 5	Purchases	200 units @ $2
April 10	Purchases	200 units @ $3
April 15	Purchases	200 units @ $4
April 20	Purchases	200 units @ $5
April 25	Purchases	200 units @ $6

Required:

Compute the cost of goods sold in both units, and cost and compute the number of units in the ending inventory.

Compute the cost of the ending inventory under average cost.

Compute the cost of the ending inventory under LIFO.

Compute the cost of the ending inventory under FIFO.

Explain how you calculated each answer and include your explanations in the Excel worksheet that you submit.

Instructions:

Complete this assignment using an Excel spreadsheet, and date and explain each entry on your deliverable.

Leary	Month of April Inventory	Ending Inventory and COGS
Option #1- Mod 4- Protfolio Project Student Template

Date	Inentory Activity	# Units	$ Cost	Total Cost
1-Apr	Briginning Inventory (BI)
5-Apr	Purchases (Transferred in or TI)
10-Apr	Purchases (Transferred in or TI)
15-Apr	Purchases (Transferred in or TI)
20-Apr	Purchases (Transferred in or TI)
25-Apr	Purchases (Transferred in or TI)
Q1: TOTAL	Goods Avail for Sale(units and $)
Given: Units sold (transferred out or TO) +=

MustKnow:	Inventory Formula=
	Units =
	EI=

Q2: Average cost= EI= Good available for sale$ / Goods available for sale units=
	EI= units in inventory * average cost=
	COGS= BI + TI - EI
	BI + TI = $4,200; EI = $3,500

Q3: LIFO=	First-In, Still-Here for EI =	EI=
	COGS= BI + TI - EI
	BI + TI = EI =

Q4: FIFO=	Last-In, Still- Here for EI=	EI
	COGS= BI + TI - EI
	BI + TI = EI =

Question 5- Show work speadsheet on how you calculated the numbers

Reference no: EM131021313

Questions Cloud

Determine depreciation for the first year of the trucks : Determine depreciation for the first year of the truck's useful life by the straight-line and units-of-output methods if the truck is actually driven 16,000 miles. (Round depreciation per mile for the units-of-output method to the nearest whole cent)..

Describe the organization''s mission : Discuss the organization's effectiveness in terms of influencing healthcare delivery and improving accessibility to healthcare services via the policies promulgated by the organization.

Find the delay timet encountered in the read operation : The inverters utilize (W/L)n =1. Each of the bit lines has a 2-pF capacitance to ground. The sense amplifier requires a minimum of 0.2-V input for reliable and fast operation. Find the upper bound on W/L for each of the access transistors so that ..

Weber corporation has 10 million shares of a preferred stock : Weber Corporation has 10 million shares of a preferred stock issue outstanding that pays a cumulative $6 annual dividend on a quarterly basis. However, due to poor profitability the company has not paid the preferred stock dividend for the last five ..

Compute the cost of goods sold in both units : Compute the cost of goods sold in both units, and cost and compute the number of units in the ending inventory.

Relationship b/w the coefficient of variation and debt ratio : Graph the relationship between the coefficient of variation and the debt ratio. Label the areas associated with business risk and financial risk.

How well is the company performing : Evaluate tire city's financial health,how well is the company performing

What is working capital management : What is working capital management? and what are the factors influencing the amount of working capital to hold?

Danielson company reported following stockholder''s equity : Danielson Company reported the following stockholder's equity section of the balance sheet on 1/1/15 (assume all common stock was issued on the same time)

User Account

All Pages