assignment_mod_08_new.xlsx
Review the transactions and financial position of Cascade Inc. for the month of September in the
Excel Template
.
Requirements:
>M8 Assignment
-Sep
-Sep
Purchase 0
Sale 22 Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Purchases Cost of Goods Sold Inventory on Hand Purchases Cost of Goods Sold Inventory on Hand
Module 8 Assignment:
Cascade Inc. completed the following inventory transactions during the month of September:
Date
Item
Quantity
Unit Cost
1
Balance
25
$80
4-Sep
Purchase
40
$78
12-Sep
Sale
52
22
3
$77
30-Sep
Requirements:
1
Prepare a perpetual inventory record using FIFO
Purchases
Cost of Goods Sold
Inventory on Hand
Date Quantity Unit Cost
Total Cost
2
Prepare a perpetual inventory record using LIFO
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost 3
Prepare a perpetual inventory record using average cost
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
