Some of the information found on a detail inventory card for
Ayayai Inc. for the first month of operations is as
follows.
|
Received |
||||||||
|
Date |
No. of Units |
Unit Cost |
Issued, |
Balance, |
||||
| January 2 | 1,600 | $3.75 | 1,600 | |||||
| 7 | 1,100 | 500 | ||||||
| 10 | 1,000 | 4.00 | 1,500 | |||||
| 13 | 900 | 600 | ||||||
| 18 | 1,400 | 4.13 | 700 | 1,300 | ||||
| 20 | 1,100 | 200 | ||||||
| 23 | 1,700 | 4.25 | 1,900 | |||||
| 26 | 1,200 | 700 | ||||||
| 28 | 2,000 | 4.38 | 2,700 | |||||
| 31 | 1,700 | 1,000 | ||||||
If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, would the amounts shown as ending inventory in (1), (2), and (3) above be the same? What amount would be shown as ending inventory?
Homework Answers
Solution:
| Computation of ending inventory COGS under FIFO - Ayayai Inc. | ||||||||||||
| Date | Beginning Inventory | Purchase | Issue | Ending Inventory | ||||||||
| Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
| 2-Jan | 0 | $0.00 | $0.00 | 1600 | $3.75 | $6,000.00 | 0 | $0.00 | $0.00 | 1600 | $3.75 | $6,000.00 |
| 7-Jan | 1600 | $3.75 | $6,000.00 | 0 | $0.00 | $0.00 | 1100 | $3.75 | $4,125.00 | 500 | $3.75 | $1,875.00 |
| 10-Jan | 500 | $3.75 | $1,875.00 | 1000 | $4.00 | $4,000.00 | 0 | $0.00 | $0.00 | 500 | $3.75 | $1,875.00 |
| 1000 | $4.00 | $4,000.00 | ||||||||||
| 13-Jan | 500 | $3.75 | $1,875.00 | 0 | $0.00 | $0.00 | 500 | $3.75 | $1,875.00 | 600 | $4.00 | $2,400.00 |
| 1000 | $4.00 | $4,000.00 | 400 | $4.00 | $1,600.00 | |||||||
| 18-Jan | 600 | $4.00 | $2,400.00 | 1400 | $4.13 | $5,782.00 | 600 | $4.00 | $2,400.00 | 1300 | $4.13 | $5,369.00 |
| 100 | $4.13 | $413.00 | ||||||||||
| 20-Jan | 1300 | $4.13 | $5,369.00 | 0 | $0.00 | $0.00 | 1100 | $4.13 | $4,543.00 | 200 | $4.13 | $826.00 |
| 23-Jan | 200 | $4.13 | $826.00 | 1700 | $4.25 | $7,225.00 | 0 | $0.00 | $0.00 | 200 | $4.13 | $826.00 |
| 1700 | $4.25 | $7,225.00 | ||||||||||
| 26-Jan | 200 | $4.13 | $826.00 | 0 | $0.00 | $0.00 | 200 | $4.13 | $826.00 | 700 | $4.25 | $2,975.00 |
| 1700 | $4.25 | $7,225.00 | 1000 | $4.25 | $4,250.00 | |||||||
| 28-Jan | 700 | $4.25 | $2,975.00 | 2000 | $4.38 | $8,760.00 | 0 | $0.00 | $0.00 | 700 | $4.25 | $2,975.00 |
| 2000 | $4.38 | $8,760.00 | ||||||||||
| 31-Jan | 700 | $4.25 | $2,975.00 | 0 | $0.00 | $0.00 | 700 | $4.25 | $2,975.00 | 1000 | $4.38 | $4,380.00 |
| 2000 | $4.38 | $8,760.00 | 1000 | $4.38 | $4,380.00 | |||||||
| Total | 6700 | $27,387.00 | 1000 | $4,380.00 | ||||||||
| Computation of ending inventory COGS under LIFO - Ayayai Inc. | ||||||||||||
| Date | Beginning Inventory | Purchase | Issue | Ending Inventory | ||||||||
| Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
| 2-Jan | 0 | $0.00 | $0.00 | 1600 | $3.75 | $6,000.00 | 0 | $0.00 | $0.00 | 1600 | $3.75 | $6,000.00 |
| 7-Jan | 1600 | $3.75 | $6,000.00 | 0 | $0.00 | $0.00 | 1100 | $3.75 | $4,125.00 | 500 | $3.75 | $1,875.00 |
| 10-Jan | 500 | $3.75 | $1,875.00 | 1000 | $4.00 | $4,000.00 | 0 | $0.00 | $0.00 | 500 | $3.75 | $1,875.00 |
| 1000 | $4.00 | $4,000.00 | ||||||||||
| 13-Jan | 500 | $3.75 | $1,875.00 | 0 | $0.00 | $0.00 | 900 | $4.00 | $3,600.00 | 500 | $3.75 | $1,875.00 |
| 1000 | $4.00 | $4,000.00 | 100 | $4.00 | $400.00 | |||||||
| 18-Jan | 500 | $3.75 | $1,875.00 | 1400 | $4.13 | $5,782.00 | 700 | $4.13 | $2,891.00 | 500 | $3.75 | $1,875.00 |
| 100 | $4.00 | $400.00 | 100 | $4.00 | $400.00 | |||||||
| 700 | $4.13 | $2,891.00 | ||||||||||
| 20-Jan | 500 | $3.75 | $1,875.00 | 0 | $0.00 | $0.00 | 700 | $4.13 | $2,891.00 | 200 | $3.75 | $750.00 |
| 100 | $4.00 | $400.00 | 100 | $4.00 | $400.00 | |||||||
| 700 | $4.13 | $2,891.00 | 300 | $3.75 | $1,125.00 | |||||||
| 23-Jan | 200 | $3.75 | $750.00 | 1700 | $4.25 | $7,225.00 | 0 | $0.00 | $0.00 | 200 | $3.75 | $750.00 |
| 1700 | $4.25 | $7,225.00 | ||||||||||
| 26-Jan | 200 | $3.75 | $750.00 | 0 | $0.00 | $0.00 | 1200 | $4.25 | $5,100.00 | 200 | $3.75 | $750.00 |
| 1700 | $4.25 | $7,225.00 | 500 | $4.25 | $2,125.00 | |||||||
| 28-Jan | 200 | $3.75 | $750.00 | 2000 | $4.38 | $8,760.00 | 0 | $0.00 | $0.00 | 200 | $3.75 | $750.00 |
| 500 | $4.25 | $2,125.00 | 500 | $4.25 | $2,125.00 | |||||||
| 2000 | $4.38 | $8,760.00 | ||||||||||
| 31-Jan | 200 | $3.75 | $750.00 | 0 | $0.00 | $0.00 | 1700 | $4.38 | $7,446.00 | 200 | $3.75 | $750.00 |
| 500 | $4.25 | $2,125.00 | 500 | $4.25 | $2,125.00 | |||||||
| 2000 | $4.38 | $8,760.00 | 300 | $4.38 | $1,314.00 | |||||||
| Total | 6700 | $27,578.00 | 1000 | $4,189.00 | ||||||||
Add Answer to:
Some of the information found on a detail inventory card for
Ayayai Inc. for the first...
Some of the information found on a detail inventory card for Oriole Inc. for the first...
Some of the information found on a detail inventory card for
Oriole Inc. for the first month of operations is as
follows.
Received
Date
No. of Units
Unit Cost
Issued,
No. of Units
Balance,
No. of Units
January 2
1,700
$4.74
1,700
7
1,200
500
10
1,100
5.06
1,600
13
1,000
600
18
1,500
5.21
800
1,300
20
1,100
200
23
1,800
5.37
2,000
26
1,300
700
28
2,100
5.53
2,800
31
1,800
1,000
Calculate average-cost per unit. (Round answer to...
Some of the information found on a detail inventory card for Oriole Inc. for the first...
Some of the information found on a detail inventory card for Oriole Inc. for the first month of operations is as follows. Date January 2 5.06 Received Issued, Balance, No. of Units Unit Cost No. of Units No. of Units 1,700 $4.74 1,700 1.200 500 1,100 1,600 1,000 600 1,500 5.21 800 1,300 1,100 1,800 5.37 2.000 1,300 700 2,100 5.53 2.800 1,800 1,000 200 Calculate average cost per unit. (Round answer to 2 decimal places, e.g. 2.76.) Average-cost per...
Some of the information found on a detail inventory card for Novak Inc. for the first...
Some of the information found on a detail inventory card for Novak Inc. for the first month of operations is as follows. If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, would the amounts shown as ending inventory in (1)FIFO, (2)LIFO, and (3)Average Cost above be the same? What amount would be shown as ending inventory? (Round average cost per unit to 4 decimal places, e.g. 2.7621 and final answers...
Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follo...
Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 1a) Calculate average-cost per unit. 1b) From...
Some of the information found on a detail inventory card for Shamrock Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Un...
Some of the information found on a detail inventory card for Shamrock Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 Calculate average-cost per unit. (Round answer...
Some of the information found on a detail inventory card for Metlock Inc. for the first month of operations is as...
Some of the information found on a detail inventory card for Metlock Inc. for the first month of operations is as follows. Date January 2 Received Issued, Balance, No. of Units Unit Cost No. of Units No. of Units 1,700 $3.84 1,700 1,200 500 1,100 4.10 1,600 1,000 600 1,500 800 1,300 1,100 1,800 4.35 2,000 1,300 700 2,100 4.48 2,800 1,800 1,000 4.22 200 Calculate average-cost per unit. (Round answer to 2 decimal places, e.g. 2.76.) Average-cost per unit...
Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for...
Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for Coronado Inc. for the first month of operations is as follows. Received No. of Units 1,400 Date Issued, No. of Units Unit Cost $4.02 January 2 900 800 4.29 Balance, No. of Units 1,400 500 1,300 600 1,300 200 1,700 700 2,500 1,000 1,200 700 500 1,100 4.42 1,500 4.56 1,000 1,800 4.69 1,500 (b) Your answer is partially correct. Try again. If the...
Some of the information found on a detail inventory card for Tamarisk Inc. for the first...
Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 Calculate average-cost per unit. (Round answer...
Some of the information found on a detail inventory card for Buffalo Inc. for the first...
Some of the information found on a detail inventory card for
Buffalo Inc. for the first month of operations is as follows.
Received
Date
No. of Units
Unit Cost
Issued,
No. of Units
Balance,
No. of Units
January 2
1,600
$5.10
1,600
7
1,100
500
10
1,000
5.44
1,500
13
900
600
18
1,400
5.61
700
1,300
20
1,100
200
23
1,700
5.78
1,900
26
1,200
700
28
2,000
5.95
2,700
31
1,700
1,000
Calculate average-cost per unit. (Round answer...
Attempts: 2 of 3 used ( 2) From these data compute the ending inventory on each of the following bases. Assum...
Attempts: 2 of 3 used ( 2) From these data compute the ending inventory on each of the following bases. Assume that perpetual inventory records are kept in units only. (1) First-in, first-out (FFO).(2) Lasti, est-out (LIFO). (3) Average-cost. (Round final answers to decimal places, .g. 6,548.) (1) (3) Average-cost FIFO Ending Inventory Attempts of 3 used SAVE FOR LATER SUBMIT ANSWER the art above The parts of this question must be completed in order. This part will be available...
Some of the information found on a detail inventory card for
Oriole Inc. for the first month of operations is as
follows.
Received
Date
No. of Units
Unit Cost
Issued,
No. of Units
Balance,
No. of Units
January 2
1,700
$4.74
1,700
7
1,200
500
10
1,100
5.06
1,600
13
1,000
600
18
1,500
5.21
800
1,300
20
1,100
200
23
1,800
5.37
2,000
26
1,300
700
28
2,100
5.53
2,800
31
1,800
1,000
Calculate average-cost per unit. (Round answer to...
Some of the information found on a detail inventory card for Oriole Inc. for the first month of operations is as follows. Date January 2 5.06 Received Issued, Balance, No. of Units Unit Cost No. of Units No. of Units 1,700 $4.74 1,700 1.200 500 1,100 1,600 1,000 600 1,500 5.21 800 1,300 1,100 1,800 5.37 2.000 1,300 700 2,100 5.53 2.800 1,800 1,000 200 Calculate average cost per unit. (Round answer to 2 decimal places, e.g. 2.76.) Average-cost per...
Some of the information found on a detail inventory card for Metlock Inc. for the first month of operations is as follows. Date January 2 Received Issued, Balance, No. of Units Unit Cost No. of Units No. of Units 1,700 $3.84 1,700 1,200 500 1,100 4.10 1,600 1,000 600 1,500 800 1,300 1,100 1,800 4.35 2,000 1,300 700 2,100 4.48 2,800 1,800 1,000 4.22 200 Calculate average-cost per unit. (Round answer to 2 decimal places, e.g. 2.76.) Average-cost per unit...
Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for Coronado Inc. for the first month of operations is as follows. Received No. of Units 1,400 Date Issued, No. of Units Unit Cost $4.02 January 2 900 800 4.29 Balance, No. of Units 1,400 500 1,300 600 1,300 200 1,700 700 2,500 1,000 1,200 700 500 1,100 4.42 1,500 4.56 1,000 1,800 4.69 1,500 (b) Your answer is partially correct. Try again. If the...
Some of the information found on a detail inventory card for
Buffalo Inc. for the first month of operations is as follows.
Received
Date
No. of Units
Unit Cost
Issued,
No. of Units
Balance,
No. of Units
January 2
1,600
$5.10
1,600
7
1,100
500
10
1,000
5.44
1,500
13
900
600
18
1,400
5.61
700
1,300
20
1,100
200
23
1,700
5.78
1,900
26
1,200
700
28
2,000
5.95
2,700
31
1,700
1,000
Calculate average-cost per unit. (Round answer...
Attempts: 2 of 3 used ( 2) From these data compute the ending inventory on each of the following bases. Assume that perpetual inventory records are kept in units only. (1) First-in, first-out (FFO).(2) Lasti, est-out (LIFO). (3) Average-cost. (Round final answers to decimal places, .g. 6,548.) (1) (3) Average-cost FIFO Ending Inventory Attempts of 3 used SAVE FOR LATER SUBMIT ANSWER the art above The parts of this question must be completed in order. This part will be available...
Most questions answered within 3 hours.
-
A smoke detector system uses two devices, A and B. If smoke is
present, the probability...
asked 43 minutes ago -
Your division head has assigned another important project to you
and your team. This project is...
asked 8 minutes ago -
Under normal use conditions, the Mean Time To Failure of a
heating coil can be modeled...
asked 1 hour ago -
Consider the probability that fewer than 34 out of 116 CDs will
be defective. Assume the...
asked 23 minutes ago -
4J Manufacturing Company uses a job order cost accounting system
and keeps perpetual inventory records. Prepare...
asked 12 minutes ago -
Please write code in C++
using recursive function
Write a program that computes the sequence of...
asked 11 minutes ago -
What is 345 as an unsigned decimal number? It is 34
with subscript of 5. Not...
asked 27 minutes ago -
I've been struggling with these homework questions. Any help
would be greatly appreciated
1. For the...
asked 25 minutes ago -
Read the In-Depth Integrative Case 1.2 (Pharmaceutical
Companies, Intellectual Property, and the Global AIDS Epidemic) in...
asked 24 minutes ago -
Consider a mass-spring system. The spring has a spring constant
of 2.27e+3 N/m. On the end...
asked 30 minutes ago -
People are most likely to believe their ancestors play an active
role in their lives in...
asked 1 hour ago -
A student holds a ruler by one end (x=0 where the student holds
it). The student...
asked 1 hour ago