Question
Seminole Company began year 2013 with 23,000 units of product in its January 1 inventory, at a cost of $15 for each unit. It made
Seminole Company began year 2013 with 23,000 units of product in its January 1 inventory, at a cost of $15 for each unit. It made successive purchases of its product in year 2013, as follows. The company uses a periodic inventory system. On December 31, 2013, a physical count reveals that 40,000 units of its product remain in inventory.
| ||
Mar. 7 | 30,000 units | @ $18 each |
May 25 | 39,000 units | @ $20 each |
Aug. 1 | 23,000 units | @ $25 each |
Nov. 10 | 35,000 units | @ $26 each |
PART 3 | Seminole Company |
|
|
|
| |||
Column-> | A | B | C | D | # EI Units | # Sold Units | $SoldUnits | |
Date | Activities | # Units Buy | Cost/unit | Cost GAS | 40,000 | 110,000 | $35 | |
1-Jan | BI |
|
|
|
| |||
7-Mar | TI |
|
|
| ||||
25-Mar | TI |
|
|
| ||||
1-Aug | TI |
|
|
| ||||
10-Nov | TI |
|
|
| ||||
TOTAL |
|
|
|
|
|
| ||
Q1A. Units in Available for Sales is BI + TI (Column B)= | Units (BI + TI) = |
| ||||||
Q1B. Costs of Units Available for Sales (Column D)= | Dollars (BI + TI)= |
|
| |||||
Q2. FIFO |
|
|
| EI |
| COGS | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Q2. LIFO |
|
|
| EI |
| COGS | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Q2. Weighted Average |
|
| EI |
| COGS | |||
Weighted cost/unit= | Column F/Column B | equals |
| per unit |
|
| ||
Cost EI= |
|
|
|
|
|
|
|
|
Q.3 | Sales |
| COGS/Method |
| Gross Profit | |||
|
|
|
|
|
| |||
Q3. FIFO |
|
|
|
|
| |||
|
|
|
|
|
| |||
Q3. LIFO |
|
|
|
|
| |||
|
|
|
|
|
| |||
Q3. WtAvg |
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started