Prepare materials ledger card and weighted average method

use reference below and format.

Figure 2-11 Comparison of Inventory Valuation Methods A B C D E F G H J 1 2 3 4 5 Date Received First-In, First-Out Method Issued Balance Quantity Unit Price Amount Quantity Unit Price Amount Quantity Unit Price Amount 6 7 Dec. 1 1,000 20.00 20,000.00 8 10 500 20.00 10,000.00 500 20.00 10,000.00 9 15 1,000 24.00 24,000.00 500 20.00 10 1,000 24.00 34,000.00 11 20 250 20.00 5,000.00 250 20.00 12 1,000 24.00 29,000.00 13 26 250 20.00 14 250 24.00 11,000.00 750 24.00 18,000.00 15 28 500 26.00 13,000.00 750 24.00 500 26.00 31,000.00 16 17 30 500 24.00 12,000.00 250 24.00 500 26.00 19,000.00 18 19 20 21 Received Issued 22 Date Quantity Unit Price Amount Last-In, First-Out method Quantity Unit Price Amount Quantity Unit Price Amount Balance 23 1,000 24 Dec. 1 20.00 20,000.00 25 10 500 20.00 10,000.00 500 20.00 10,000.00 26 15 1,000 24.00 24,000.00 500 20.00 1,000 24.00 34,000.00 27 28 20 250 24.00 6,000.00 500 20.00 750 24.00 28,000.00 29 30 26 500 24.00 12,000.00 500 20.00 250 24.00 16,000.00 31 32 28 500 26.00 13,000.00 500 20.00 250 24.00 33 500 34. 26.00 29,000.00 35 30 500 26.00 13,000.00 500 20.00 36 250 24.00 16,000.00 37 38 39 Received 40 Date Weighted Average Method Issued Quantity Unit Price Amount Quantity Unit Price Amount Quantity Unit Price Amount Balance 41 42 Dec. 1 1,000 20.00 20,000.00 43 44 15 45 20 46 26 47 28 BOGO. 10 500 20.00 10,000.00 1,000 24.00 24,000.00 250 22.6667 5,666.67 500 22.6667 11,333.33) 500 1,500 22.6667 34,000.00 1,250 22.6667 28,333.33 750 22.6667 17,000.00 20.00 10,000.00 500 26.00 13,000.00 1,250 24.00 30,000.00 48 30 500 24.00 12,000.00 750 24.00 18,000.00