In: Accounting
Dalia Wahebi sells one type of machine, a mini-blender. She provides the following information for May 2018.
Dalia held 2 mini-blenders in inventory at 1 May 2018. They cost $1,200 each
Date |
Purchases |
Date |
Sales |
1 May |
3 @ $1,250 |
2 May |
4 @ $2,900 |
7 May |
4 @ $1,300 |
17 May |
4 @ $3,000 |
21 May |
8 @ $1,450 |
24 May |
7 @ $3,000 |
Dalia wants to know the value of closing inventory and also her Gross Profit for the month of May 2018.
REQUIRED
(a) Calculate the value of the closing inventory using FIFO and AVCO.
(b) Calculate the Gross Profit for the month of May 2018.
1)FIFO METHOD:
Inventory value = 2900
Cost of goods sold = 20,050
Gross profit = 44600- 20050 = 24550
Date | Purchase | Cost of goods sold | Balance | |||||
Units | rate | Units | rate | amount | Units | rate | amount | |
Opening | 2 | 1200 | 2400 | |||||
01-May-20 | 3 | 1250 | 2 | 1200 | 2400 | |||
3 | 1250 | 3750 | ||||||
Inventory | 6150 | |||||||
02-05-20 | 2 | 1200 | 2400 | 1 | 1250 | 1250 | ||
2 | 1250 | 2500 | ||||||
Inventory | 1250 | |||||||
07-05-20 | 4 | 1300 | 1 | 1250 | 1250 | |||
4 | 1300 | 5200 | ||||||
6450 | ||||||||
17-05-20 | 1 | 1250 | 1250 | 1 | 1300 | 1300 | ||
3 | 1300 | 3900 | ||||||
Inventory | 1300 | |||||||
21-05-20 | 8 | 1450 | 1 | 1300 | 1300 | |||
8 | 1450 | 11600 | ||||||
Inventory | 12900 | |||||||
24-05-20 | 1 | 1300 | 1300 | 2 | 1450 | 2900 | ||
6 | 1450 | 8700 | ||||||
Cost | 20050 | Inventory | 2900 |
2) AVCO METHOD:
Inventory value = 2,864
Cost of goods sold = 20,106
Gross profit = 44600 - 20106 = 24,494
Date | Purchase | Cost of goods sold | Balance | |||||
Units | rate | Units | rate | amount | Units | rate | amount | |
Opening | 2 | 1200 | 2400 | |||||
01-May-20 | 3 | 1250 | 2 | 1200 | 2400 | |||
3 | 1250 | 3750 | ||||||
5 | 1230 | 6150 | ||||||
Inventory | 6150 | |||||||
02-05-20 | 4 | 1230 | 4920 | 1 | 1230 | 1230 | ||
Inventory | 1230 | |||||||
07-05-20 | 4 | 1300 | 1 | 1230 | 1250 | |||
4 | 1300 | 5200 | ||||||
5 | 1290 | 6450 | ||||||
Inventory | 6450 | |||||||
17-05-20 | 4 | 1290 | 5160 | 1 | 1290 | 1290 | ||
Inventory | 1290 | |||||||
Related SolutionsJohnson and Company provides you the following information Purchase price of each Machine &nbJohnson and Company provides you the following information
Purchase price of each Machine
300,000
Useful life of each machine
5 years
Salvage value
100,000
Method of Depreciation
Straight line
Tax rate
50%
Cost of Debts
10%
Earnings before depreciation & Tax
Machine
Year 1
Year 2
Year 3
Year 4
Year 5
X
200,000
10% increase
10% increase
10% increase
10% increase
Y
0
100,000
200,000
300,000
1200,000
Required which of the machine should...
Marigold Company purchased Machine #201 on May 1, 2017. The following information relating to Machine #201...Marigold Company purchased Machine #201 on May 1, 2017. The
following information relating to Machine #201 was gathered at the
end of May. Price $122,400 Credit terms 2/10, n/30 Freight-in $
1,152 Preparation and installation costs $ 5,472 Labor costs during
regular production operations $15,120 It is expected that the
machine could be used for 10 years, after which the salvage value
would be zero. Marigold intends to use the machine for only 8
years, however, after which it expects...
Sheffield Company purchased Machine #201 on May 1, 2017. The following information relating to Machine #201...Sheffield Company purchased Machine #201 on May 1, 2017. The
following information relating to Machine #201 was gathered at the
end of May. Price $96,900 Credit terms 2/10, n/30 Freight-in $ 912
Preparation and installation costs $ 4,332 Labor costs during
regular production operations $11,970 It is expected that the
machine could be used for 10 years, after which the salvage value
would be zero. Sheffield intends to use the machine for only 8
years, however, after which it expects...
JAVA question A string may use more than one type of delimiter to bracket information into...JAVA question
A string may use more than one type of delimiter to bracket
information into "blocks". The primary ways to divide things up
into block is by the braces { } , parentheses ( ), and brackets [ ]
as delimiters.
A string is considered properly delimited if each right
delimiter ] } or )( is matched with a preceding left delimiter { [
( of the same type in such a way that either the resulting blocks
of...
Ellie May, a mother with type B blood, has a child with type O blood. she...Ellie May, a mother with type B blood, has a child
with type O blood. she claims that Jethro, who has type A blood, is
the father. He claims that he cannot possibly be the father. Based
on this information only, is it possible that Jethro is the
father?
If blood tests ordered by the judge revealed that the
father is homozygous in genotype, is it possible for Jethro to be
the father?
Ellie May, a mother with type B blood, has a child with type O blood. she...Ellie May, a mother with type B blood, has a child with type O
blood. she claims that Jethro, who has type A blood, is the father.
He claims that he cannot possibly be the father. Based on this
information only, is it possible that Jethro is the father?
If blood tests ordered by the judge revealed that the father is
homozygous in genotype, is it possible for Jethro to be the
father?
Can you show work using the punnet...
Ellie May, a mother with type B blood, has a child with type O blood. She...Ellie May, a mother with type B blood, has a child with type O
blood. She claims that Jethro, who has type A blood, is the father.
He claims that he cannot possibly be the father. Further, blood
tests ordered by the judge reveal that the father is homozygous.
The judge rules that:
a) Ellie May is right and Jethro must pay up.
b) Jethro is right and is a winner-winner (chicken dinner).
c) Ellie May cannot be the real...
Inventory a) Natasha Burke provides you with the following information in respect of one of her...Inventory
a) Natasha Burke provides you with the following information in
respect of one of her inventory items:
1 March
Balance
55 units @ $40.00 unit
8 March
Sold
35 units @ $90.00 unit
15 March
Purchased
60 units @ $45.00 unit
22 March
Sold
55 units @ $95.00 unit
29 March
Purchased
40 units @ $50.00 unit
31 March
Stocktake
60 units on hand
Tasks
i. Prepare inventory ledger cards for the inventory item using
both the FIFO and...
The management of the Mini Mill Steel Company estimated the following elasticities for a special type...The management of the Mini Mill Steel Company estimated the
following elasticities for a special type of steel: EP 2, 1, and E
where x refers to steel XY and Y to aluminum. Next year, the firm
would like to increase the price of the steel it sells by 6
percent. The management forecasted that income will rise by 4
percent next year and that the price of aluminum will fall by 2
percent. (a) If the sales this year...
Lansing, Inc. provides the following information for one of its department’s operations for June (no new...Lansing, Inc. provides the following information for one of its
department’s operations for June (no new material is added in
Department T):
WIP inventory—Department T Beginning inventory ((8,000 units,
20% complete with respect to Department T costs)
Transferred-in costs (from Department S) $ 33,350
Department T conversion costs 9,020
Current work (18,500 units started)
Prior department costs 83,250
Department T costs 168,480
The ending inventory has 3,000 units, which are 50 percent
complete with respect to Department T costs and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|