Purchases Inventory-FIFO Periodic Date Units Unit Cost (UC) Total Date Trans Units Uc/Sp

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 13

Purchases Inventory-FIFO Periodic

Date Units Unit Cost (UC) Total Date Trans Units UC/SP
Mar. 5 500 50 ### Mar. 5 Purchase 500 50
10 100 60 6,000.00 7 Sale -200 50
19 400 65 ### Balance 300 50
Total 1,000 ### 15 Sale -300 50
Balance 0
Sales 10 Purchase 100 60
Date Units Selling Price (SP) Total 21 Sale -100 60
Mar. 7 200 150 ### Balance 0
15 300 150 ### 19 Purchase 400 65
21 100 180 ### 21 Sale -200 65
200 195 ### Balance 200 65
27 100 195 ### 27 Sale -100 65
Total 900 ### Balance 100 65
Note: Excluding the cost of freight
End 100 65 6,500 Inventory-FIFO Average
Date Trans Units UC/SP
Mar. 5 Purchase 500 50
10 Purchase 100 60
19 Purchase 400 65
Balance 1000 57
Note: Excluding the cost of freight
O Periodic
Cost
###
###
###
###
-
6,000.00
###
-
###
###
###
###
6,500.00

O Average
Cost
###
6,000.00
###
###
Inventory Beginning 0
Add: Net Purchases ###
Total Cost of Goods Available for S ###
Less: Inventory Ending (per count) ###
Cost of Sales ###

Purchases ###
Freight In 2,000.00
Purchase Discount (520.00)
Net Purchases ###
Gross Sales ###
Sales Returns ###
Net Sales ###
Net Sales ###
COS ###
Gross Income ###
Operating Expenses:
Salaries Expens ###
Rent Expense 5,000.00
Supplies Expens 2,000.00
Depreciation Ex 416.67
Taxes & License ### ###
Net Income (before tax) ###
FIFO-Periodic
Inventory Beginning 0
Add: Net Purchases ###
Total Cost of Goods Available for S ###
Less: Inventory Ending (per count) ###
Cost of Sales ###

Purchases ###
Freight In
Purchase Discount (520.00)
Net Purchases ### Difference due to different cost
###
flow method used
FIFO-Weighted Average
Inventory Beginning 0
Add: Net Purchases ###
Total Cost of Goods Available for S ###
Less: Inventory Ending (per count) ###
Cost of Sales ###
Inventory-FIFO Periodic
Date Trans Units Price Cost
Mar. 5 Purchase 500 50 ###
7 Sale -200 50 ###
Balance 300 50 ###
15 Sale -300 50 ###
Balance 0 -
10 Purchase 100 60 6,000.00
21 Sale -100 60 ###
Balance 0 -
19 Purchase 400 65 ###
due to different cost 21 Sale -200 65 ###
od used Balance 200 65 ###
27 Sale -100 65 ###
Balance 100 65 ###
Note: Excluding the cost of freight
Inventory-FIFO Average
Date Trans Units Price Cost
Mar. 5 Purchase 500 50 ###
10 Purchase 100 60 6,000.00
19 Purchase 400 65 ###
Balance 1000 57 ###
Note: Excluding the cost of freight
Statement of Cost of Goods Sold

Raw Material Inventory Beginning 100,000.00


Net Purchases ###
Raw Materials Available for Use ###
Raw Material Inventory Ending ###
Direct Material Costs (Used) 500,000.00
Direct Labor Costs 700,000.00
Factory Overhead 400,000.00
Total Manufacturing Costs ###
Work in Process Inventory Beginni ###
Total Cost of Goods in Process ###
Work in Process Inventory End ###
Cost of Goods Manufactured ###
Finished Goods Inventory Beginni ###
Goods Available for Sale ###
Finished Goods Inventory Endi ###
Cost of Goods Sold ###
Purchases FIFO-Periodic
Date Units Price Total Inventory Beginning
Mar. 5 500 50 ### Add: Net Purchases
10 100 60 6,000.00 Total Cost of Goods Available for S
19 400 65 ### Less: Inventory Ending (per count)
Total 1,000 57 ### Cost of Sales

Sales Weighted Average-Periodic


Date Units Price Total Inventory Beginning
Mar. 7 200 150 ### Add: Net Purchases
15 350 150 ### Total Cost of Goods Available for S
Less: Inventory Ending (per count)
Cost of Sales

Total 550 ###


LIFO-Periodic
End 450 - Inventory Beginning
Add: Net Purchases
Total Cost of Goods Available for S
Less: Inventory Ending (per count)
Cost of Sales
iodic FIFO-Perpetual
Inventory Beginning 0
### Add: Net Purchases ###
### Total Cost of Goods Available for ###
### Less: Inventory Ending (per count ###
### Cost of Sales ###

Weighted Average-Perpetual
0 Inventory Beginning 0
### Add: Net Purchases ###
### Total Cost of Goods Available for ###
### Less: Inventory Ending (per count ###
### Cost of Sales ###

iodic az
0 Inventory Beginning 0
### Add: Net Purchases ###
### Total Cost of Goods Available for ###
### Less: Inventory Ending (per count ###
### Cost of Sales ###
Purchases WA-Perpetual
Date Units Unit Cost Total Date Transaction Units
Mar. 5 500 50 ### Mar. 5 Purchase 500
10 100 60 6,000.00 7 Sale (200)
19 400 65 ### Balance 300
Total 1,000 57 ### 10 Purchase 100
Total 400
Sales 15 Sale (350)
Date Units Unit Cost Total Balance 50
Mar. 7 200 150 ### 19 Purchase 400
15 300 150 ### Total 450

Total 500 ###

End 500 -
-Perpetual LIFO-Perpetual
Unit Cost Total Purchases Sales
50.00 ### Units Unit Cost Total Cost Units Unit Cos
50.00 ### Mar. 5 500 50 ###
50.00 ### 7 200 50
60.00 6,000.00 10 100 60 6,000.00
52.50 ### 15 100 60
52.50 ### 250 50
52.50 2,625.00 19 400 65 ###
65.00 ###
63.61 ###
Perpetual
Sales Balance
Total Cost Units Unit Cost Total Cost
500 50 ###
### 300 50 ###
100 60 6,000.00
6,000.00
### 50 50 2,500.00
50 50 ###
400 65 ###

You might also like