Question - Redster Company is a manufacturing firm. Presented below is information concerning one of its products, called Ander.
Using an Excel spreadsheet, compute the cost of goods sold under the following situations:
|
Date
|
Transaction
|
Quantity
|
Price/Cost
|
|
1/1
|
Beginning inventory
|
2,900
|
$10
|
|
2/12
|
Purchase
|
3,300
|
$15
|
|
3/2
|
Sale
|
2,400
|
$28
|
|
4/18
|
Purchase
|
4,500
|
$18
|
|
5/31
|
Sale
|
3,800
|
$30
|
a. Periodic system, FIFO cost flow
b. Perpetual system, FIFO cost flow
c. Periodic system, LIFO cost flow
d. Perpetual system, LIFO cost flow
e. Periodic system, weighted-average cost flow
f. Perpetual system, moving-average cost flow
Your submission must show all calculations used to arrive at the answers.