Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

1

Business Oct 05, 2020

1. Calculate Cost of Goods Sold (COGS) and Ending Inventory (EI) under FIFO, LIFO, and W/A (Periodic Inventory).

The units of an item available for sale during the year were as follows:

Jan. 1 Inventory 6 units at $28
Feb. 4 Purchase 12 units at $30
July 20 Purchase 14 units at 32
Dec. 30 Purchase 8 units at $33

There are 11 units of the item in the physical inventory at December 31.

2. If the sale price per item is $50 each, how much is the gross margin under each method?

I have the first portion done (Question 1) on the attachment. Question 2 I'm confused.

Expert Solution

Response:
Jan. 1 Inventory 6 units at $28= 168
Feb. 4 Purchase 12 units at $30= 360
July 20 Purchase 14 units at $32= 448
Dec. 30 Purchase 8 units at $33= 264
40 units $1240  Cost of Goods Available for Sale
-Ending Inv 11
Sold 29

Cost of ending inventory under FIFO: -
Date of purchase No. Of Units Rate Amount
Dec. 30 8 33 264
July 20 3 32 96
------
Total 11 360
Cost of ending inventory under LIFO
Date of purchase No. of Units Rate Amount
Jan 1 6 28 168
Feb. 4 5 30 150
--------
Total 11 318
Cost of ending inventory under weighted average (Periodic)
Cost of Goods Available for Sale 1240
No. of units Available for Sale 40
Weighted average price 31
Cost of ending inventory (31*11) 341

1.Calculation of cost of goods sold
FIFO LIFO W/A (Periodic)

Cost of Goods Available for Sale 1240 1240 1240
Less Ending inventory 360 318 341
------- ------- --------
Cost of goods sold 880 922 899

2.Calculation of gross margin
FIFO LIFO W/A (Periodic)
Sales (50* 29) 1450 1450 1450
Cost of goods sold 880 922 899
-------- --------- --------
Gross margin 570 528 551
Gross margin percentage 39.31 36.41 38
(Gross margin/sales*100)

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment