Assignment 5
(Not rated)
(Not rated)
Assignment #5
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 |
- Periodic system, FIFO cost flow
- Perpetual system, FIFO cost flow
- Periodic system, LIFO cost flow
- Perpetual system, LIFO cost flow
- Periodic system, weighted-average cost flow
- Perpetual system, moving-average cost flow
Your submission must show all calculations used to arrive at the answers. Any written comments must be formatted according to the CSU-Global Guide to Writing and APA Requirements. Insert comments, as needed, using Excel’s “Add a Comment” function.
11 years ago
A++++++ answers
NOT RATED
Purchase the answer to view it
_cost_of_goods_sold.xls- depreciaiton_and_others.xls
