In: Accounting
ABC COMPANY is a distributor of linseed oil which is used in the manufacture of paint. The company buys linseed oil in bulk from a number of different linseed crushing plants. At the beginning of month of September the company had 25,000 gallons of linseed oil stored in its tank farm. The linseed oil was purchased from one crushing plant at a cost of $3.00. During the month of September the company purchased additional linseed oil and sold a linseed oil as follows.
9/3/XX purchased 10,000 gallons of linseed oil at $3.25 per gallon.
9/8/XX purchased 15,000 gallons of linseed oil at $3.50 per gallon
9/10/XX purchased 5,000 gallons of linseed oil at $3.60 per gallon.
9/11/XX sold 22,000 gallons to a paint manufacture for $5.00 per gallon.
9/12/XX purchased 20,000 gallons of linseed oil at $3.75 per gallon.
9/22/XX purchased 5,000 gallons of linseed oil at $3.80 per gallon.
9/30/XX sold 28,000 gallons of linseed oil for $5.20.
Required:
a. Complete the perpetual inventory record (provided) for the above transactions
using FIFO
b. Make the required journal entry on 9/8/XX for the FIFO method.
c. Make the required journal entry on 9/11/XX for the FIFO method.
d. Complete the perpetual inventory record (provided) for the above transactions
using LIFO
Date | Account | DR | CR | |
PURCHASED SOLD BALANCE
|
PURCHASED SOLD BALANCE |
|||||||||
opening balance | Purchase / (Sold) | Closing balance | |||||||
UTS | COST | TOT | UTS | COST | TOTAL | UTS | COST | TOT | |
9/1/XX - opening bal | 25,000.00 | 3.00 | 75,000.00 | - | 25,000.00 | 3.00 | 75,000.00 | ||
25,000.00 | 75,000.00 | - | - | 25,000.00 | 75,000.00 | ||||
9/3/XX | 25,000.00 | 3.00 | 75,000.00 | 10,000.00 | 3.25 | 32,500.00 | 25,000.00 | 3.00 | 75,000.00 |
10,000.00 | 3.25 | 32,500.00 | |||||||
25,000.00 | 75,000.00 | 10,000.00 | 32,500.00 | 35,000.00 | 107,500.00 | ||||
9/8/XX | 25,000.00 | 3.00 | 75,000.00 | 15,000.00 | 3.50 | 52,500.00 | 25,000.00 | 3.00 | 75,000.00 |
10,000.00 | 3.25 | 32,500.00 | 10,000.00 | 3.25 | 32,500.00 | ||||
15,000.00 | 3.50 | 52,500.00 | |||||||
35,000.00 | 107,500.00 | 15,000.00 | 52,500.00 | 50,000.00 | 160,000.00 | ||||
9/10/XX | 25,000.00 | 3.00 | 75,000.00 | 5,000.00 | 3.60 | 18,000.00 | 25,000.00 | 3.00 | 75,000.00 |
10,000.00 | 3.25 | 32,500.00 | 10,000.00 | 3.25 | 32,500.00 | ||||
15,000.00 | 3.50 | 52,500.00 | 15,000.00 | 3.50 | 52,500.00 | ||||
5,000.00 | 3.60 | 18,000.00 | |||||||
50,000.00 | 160,000.00 | 5,000.00 | 18,000.00 | 55,000.00 | 178,000.00 | ||||
9/11/XX | 25,000.00 | 3.00 | 75,000.00 | (22,000.00) | 3.00 | (66,000.00) | 3,000.00 | 3.00 | 9,000.00 |
10,000.00 | 3.25 | 32,500.00 | 10,000.00 | 3.25 | 32,500.00 | ||||
15,000.00 | 3.50 | 52,500.00 | 15,000.00 | 3.50 | 52,500.00 | ||||
5,000.00 | 3.60 | 18,000.00 | 5,000.00 | 3.60 | 18,000.00 | ||||
55,000.00 | 178,000.00 | (22,000.00) | (66,000.00) | 33,000.00 | 112,000.00 | ||||
9/12/XX | 3,000.00 | 3.00 | 9,000.00 | 20,000.00 | 3.75 | 75,000.00 | 3,000.00 | 3.00 | 9,000.00 |
10,000.00 | 3.25 | 32,500.00 | 10,000.00 | 3.25 | 32,500.00 | ||||
15,000.00 | 3.50 | 52,500.00 | 15,000.00 | 3.50 | 52,500.00 | ||||
5,000.00 | 3.60 | 18,000.00 | 5,000.00 | 3.60 | 18,000.00 | ||||
20,000.00 | 3.75 | 75,000.00 | |||||||
33,000.00 | 112,000.00 | 20,000.00 | 75,000.00 | 53,000.00 | 187,000.00 | ||||
9/22/XX | 3,000.00 | 3.00 | 9,000.00 | 5,000.00 | 3.80 | 19,000.00 | 3,000.00 | 3.00 | 9,000.00 |
10,000.00 | 3.25 | 32,500.00 | 10,000.00 | 3.25 | 32,500.00 | ||||
15,000.00 | 3.50 | 52,500.00 | 15,000.00 | 3.50 | 52,500.00 | ||||
5,000.00 | 3.60 | 18,000.00 | 5,000.00 | 3.60 | 18,000.00 | ||||
20,000.00 | 3.75 | 75,000.00 | 20,000.00 | 3.75 | 75,000.00 | ||||
5,000.00 | 3.80 | 19,000.00 | |||||||
53,000.00 | 187,000.00 | 5,000.00 | 19,000.00 | 58,000.00 | 206,000.00 | ||||
9/30/XX | 3,000.00 | 3.00 | 9,000.00 | (3,000.00) | 3.00 | (9,000.00) | 5,000.00 | 3.60 | 18,000.00 |
10,000.00 | 3.25 | 32,500.00 | (10,000.00) | 3.25 | (32,500.00) | 20,000.00 | 3.75 | 75,000.00 | |
15,000.00 | 3.50 | 52,500.00 | (15,000.00) | 3.50 | (52,500.00) | 5,000.00 | 3.80 | 19,000.00 | |
5,000.00 | 3.60 | 18,000.00 | |||||||
20,000.00 | 3.75 | 75,000.00 | |||||||
5,000.00 | 3.80 | 19,000.00 | |||||||
58,000.00 | 206,000.00 | (28,000.00) | (94,000.00) | 30,000.00 | 112,000.00 | ||||
9/8/XX - Journal Entry | |||||||||
Inventory | DR | 52500 | |||||||
Accounts Payable / CASH | CR | 52500 | |||||||
9/11/XX - Journal Entry | Cost of Good Sold | DR | 66000 | ||||||
Inventory | CR | 66000 | |||||||