Inventory Costing and Periodic and Perpetual inventory Systems

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. Insert comments, as needed, using Excels Add a Comment function.