1. Calculate the Weighted Average Cost for each transaction.

2. Determine the Cost of Sales for each sale transaction.

Determine the  Cost of Purchase for each sale transaction.

Calculate the Inventory Total Cost for each transaction.

Transcribed Image Text:

Sign for Cost Sign for Cost of Sales (sale Purchase/ Purchase Sign of Purchase = 1, Weighted (purchase (purchase = 1 Date Sale Units Unit Cost +1, sale = -1) 1, sale =0) purchase = Units on 0) Hand Cost of Purchase Inventory Cost of Sales Total Cost Average Cost 2 150 $ 18,000.00 $ 120.00 3 1-Oct Purchase 4 1-Oct Sale 100 $ 125.00 60 5 3-Oct Purchase 50 $ 126.00 6 4-Oct Purchase 60 $ 131.00 7 4-Oct Sale 50 8 4-Oct Purchase 60 $ 132.00 9 7-Oct Sale 120 10 7-Oct Purchase 80 $ 134.00 11 8-Oct Purchase 20 $ 134.00 12 8-Oct Sale 30 13 8-Oct Purchase 40 $ 135.00 14 9-Oct Sale 20 15 9-Oct Purchase 50 $ 135.00 16 9-Oct Sale 10 17 9-Oct Sale 20 18 10-Oct Purchase 50 $ 137.00 19 10-Oct Purchase 20 $ 139.00 20 11-Oct Sale 40 21 11-Oct Sale 30 22 14-Oct Purchase 40 $ 145.00 23 14-Oct Sale 10 24 15-Oct Sale 30 25 15-Oct Sale 10 26 16-Oct Purchase 80 $ 145.00 27 17-Oct Sale 50 28 17-Oct Sale 10 29 18-Oct Sale 50 30 18-Oct Sale 30 31 21-Oct Sale 30 32 21-Oct Purchase 100 $ 143.00 33 22-Oct Sale 70 34 23-Oct Purchase 10 $ 143.00 35 24-Oct Sale 100 36 25-Oct Sale 30 37 25-Oct Sale 20 38 28-Oct Purchase 70 $ 146.00 39 28-Oct Purchase 30 $ 147.00 40 29-Oct Sale 130 41 30-Oct Purchase 20 $ 150.00 42 30-Oct Sale 70 43 31-Oct Purchase 50 $ 153.00 44 31-Oct Purchase 20 $ 153.00 45 46 Sign for Cost Sign for Cost of Sales (sale Purchase/ Purchase Sign of Purchase = 1, Weighted (purchase (purchase = 1 Date Sale Units Unit Cost +1, sale = -1) 1, sale =0) purchase = Units on 0) Hand Cost of Purchase Inventory Cost of Sales Total Cost Average Cost 2 150 $ 18,000.00 $ 120.00 3 1-Oct Purchase 4 1-Oct Sale 100 $ 125.00 60 5 3-Oct Purchase 50 $ 126.00 6 4-Oct Purchase 60 $ 131.00 7 4-Oct Sale 50 8 4-Oct Purchase 60 $ 132.00 9 7-Oct Sale 120 10 7-Oct Purchase 80 $ 134.00 11 8-Oct Purchase 20 $ 134.00 12 8-Oct Sale 30 13 8-Oct Purchase 40 $ 135.00 14 9-Oct Sale 20 15 9-Oct Purchase 50 $ 135.00 16 9-Oct Sale 10 17 9-Oct Sale 20 18 10-Oct Purchase 50 $ 137.00 19 10-Oct Purchase 20 $ 139.00 20 11-Oct Sale 40 21 11-Oct Sale 30 22 14-Oct Purchase 40 $ 145.00 23 14-Oct Sale 10 24 15-Oct Sale 30 25 15-Oct Sale 10 26 16-Oct Purchase 80 $ 145.00 27 17-Oct Sale 50 28 17-Oct Sale 10 29 18-Oct Sale 50 30 18-Oct Sale 30 31 21-Oct Sale 30 32 21-Oct Purchase 100 $ 143.00 33 22-Oct Sale 70 34 23-Oct Purchase 10 $ 143.00 35 24-Oct Sale 100 36 25-Oct Sale 30 37 25-Oct Sale 20 38 28-Oct Purchase 70 $ 146.00 39 28-Oct Purchase 30 $ 147.00 40 29-Oct Sale 130 41 30-Oct Purchase 20 $ 150.00 42 30-Oct Sale 70 43 31-Oct Purchase 50 $ 153.00 44 31-Oct Purchase 20 $ 153.00 45 46