I'm finding it difficult to come up with balance sheet and T accounts on the attached document. Can someone please help.

All the calculations are my own. If they are incorrect, please correct them at will. Thank you! :)

Module 4: LIFO Versus FIFO Assignment LIFO Versus FIFO Wilson Lawn & Garden sells lawn and garden equipment and products, including 50-pound bags of fertilizer. Use the following information to determine the cost of goods sold and the value of the ending inventory of fertilizer bags under each of the designated cost flow assumptions. Wilson uses a periodic inventory system. DATE PER UNIT TOTAL June 1 Balance 300 bags at $10 per bag $ 3,000 June 10 Sold 200 bags at $24 per bag $ 4,800 June 11 Purchased 800 bags at $12 per bag $ 9,600 June 15 Sold 500 bags at $25 per bag $ 12,500 June 20 Purchased 500 bags at $13 per bag $ 6,500 June 27 Sold 300 bags at $27 per bag $ 8,100 LIFO Cost of Goods Sold During June: $6000 + $6500 = $12,500 June 30 Ending Inventory Value: $3000 + $3600 = $6600 FIFO Cost of Goods Sold During June: $3000 + $8400 = $11400 June 30 Ending Inventory Value: $1200 + $6500 = $7700 Module 4: LIFO Versus FIFO Assignment Units LIFO $ FIFO $ Beginning Inventory 300 $3000 $3000 + Purchases 1300 $16,100 $16,100 Available for Sale 1600 $19,100 $19,100 -Ending Inventory 600 $6600 $7700 $12,500 $11,400 Cost of Goods Sold LIFO $ FIFO $ Sales $25,400 $25,400 Less: Cost of Goods Sold $12,500 $11,400 Gross Profit $12,900 $14,000 Gross Profit % 50.78% 55.12% Module 4: LIFO Versus FIFO Assignment Using the following information, show how Wilson's June purchases and sales of those same 50-pound fertilizer bags impacted its statement of cash flows, income statement, and balance sheet during the month. Assume all inventory purchases are on credit and that there was no beginning balance in the accounts receivable account. Disregard income taxes and assume that the gross profit represents the net income effect of the transactions. HINT: Use the t-accounts on the next page to help you determine the impact. Assume Wilson used the LIFO method, resulting in cost of goods sold of $12,500 and an ending inventory value of $6,600 There was a $4,200 beginning balance in the accounts payable account on June 1 Suppliers were paid $13,500 during the month of June Wilson earned $25,400 of revenue on sales of the fertilizer bags; $19,900 of the revenue related to cash sales, and the rest were credit sales STATEMENT OF CASH FLOW EFFECTS Received from customers (O) $19,900 Paid to suppliers (O) $13,500 NET CHANGE IN CASH FLOW $6400 INCOME STATEMENT EFFECTS Net sales $25,400 Cost of Goods Sold $12,500 GROSS PROFIT $12,900 Module 4: LIFO Versus FIFO Assignment BALANCE SHEET EFFECTS ASSETS: LIABILITIES + EQUITY: Cash 19,900 Accounts Payable Accounts Receivable 5500 Inventory 6600 CHANGE IN ASSETS $31,000 CHANGE IN LIABILITIES + EQUITY HINT: We're looking for the change in each account during the month of June. Although beginning balances have been provided, they are really irrelevant to this exercise. Cash Bal 10,000 Accounts Receivable Bal Accounts Payable 4,200 Bal Sales Revenue 0 Inventory Bal Retained Earnings 8,800 Bal Cost of Goods Sold Expense 3,000 Module 4: LIFO Versus FIFO Assignment LIFO Versus FIFO Wilson Lawn & Garden sells lawn and garden equipment and products, including 50-pound bags of fertilizer. Use the following information to determine the cost of goods sold and the value of the ending inventory of fertilizer bags under each of the designated cost flow assumptions. Wilson uses a periodic inventory system. DATE PER UNIT TOTAL June 1 Balance 300 bags at $10 per bag $ 3,000 June 10 Sold 200 bags at $24 per bag $ 4,800 June 11 Purchased 800 bags at $12 per bag $ 9,600 June 15 Sold 500 bags at $25 per bag $ 12,500 June 20 Purchased 500 bags at $13 per bag $ 6,500 June 27 Sold 300 bags at $27 per bag $ 8,100 LIFO Cost of Goods Sold During June: $6000 + $6500 = $12,500 June 30 Ending Inventory Value: $3000 + $3600 = $6600 FIFO Cost of Goods Sold During June: $3000 + $8400 = $11400 June 30 Ending Inventory Value: $1200 + $6500 = $7700 Module 4: LIFO Versus FIFO Assignment Units LIFO $ FIFO $ Beginning Inventory 300 $3000 $3000 + Purchases 1300 $16,100 $16,100 Available for Sale 1600 $19,100 $19,100 -Ending Inventory 600 $6600 $7700 $12,500 $11,400 Cost of Goods Sold LIFO $ FIFO $ Sales $25,400 $25,400 Less: Cost of Goods Sold $12,500 $11,400 Gross Profit $12,900 $14,000 Gross Profit % 50.78% 55.12% Module 4: LIFO Versus FIFO Assignment Using the following information, show how Wilson's June purchases and sales of those same 50-pound fertilizer bags impacted its statement of cash flows, income statement, and balance sheet during the month. Assume all inventory purchases are on credit and that there was no beginning balance in the accounts receivable account. Disregard income taxes and assume that the gross profit represents the net income effect of the transactions. HINT: Use the t-accounts on the next page to help you determine the impact. Assume Wilson used the LIFO method, resulting in cost of goods sold of $12,500 and an ending inventory value of $6,600 There was a $4,200 beginning balance in the accounts payable account on June 1 Suppliers were paid $13,500 during the month of June Wilson earned $25,400 of revenue on sales of the fertilizer bags; $19,900 of the revenue related to cash sales, and the rest were credit sales STATEMENT OF CASH FLOW EFFECTS Received from customers (O) $19,900 Paid to suppliers (O) $13,500 NET CHANGE IN CASH FLOW $6400 INCOME STATEMENT EFFECTS Net sales $25,400 Cost of Goods Sold $12,500 GROSS PROFIT $12,900 Module 4: LIFO Versus FIFO Assignment BALANCE SHEET EFFECTS ASSETS: LIABILITIES + EQUITY: Cash 19,900 Accounts Payable Accounts Receivable 5500 Inventory 6600 CHANGE IN ASSETS $31,000 CHANGE IN LIABILITIES + EQUITY HINT: We're looking for the change in each account during the month of June. Although beginning balances have been provided, they are really irrelevant to this exercise. Cash Bal 10,000 Accounts Receivable Bal Accounts Payable 4,200 Bal Sales Revenue 0 Inventory Bal Retained Earnings 8,800 Bal Cost of Goods Sold Expense 3,000 LIFO Versus FIFO Wilson Lawn & Garden sells lawn and garden equipment and products, including 50-pound bags of fertilizer. Use the following information to determine the cost of goods sold and the value of the ending inventory of fertilizer bags under each of the designated cost flow assumptions. Wilson uses a periodic inventory system. DATE PER UNIT TOTAL Inventory (in Units) June 1 Balance 300 bags at $10 per bag $ 3,000 300 bags June 10 Sold 200 bags at $24 per bag $ 4,800 June 11 Purchased 800 bags at $12 per bag $ 9,600 June 15 Sold 500 bags at $25 per bag $ 12,500 June 20 Purchased 500 bags at $13 per bag $ 6,500 June 27 Sold 300 bags at $27 per bag $ 8,100 200 bags 800 bags 500 bags 500 bags Total inventory including purchases for June: 1600 Sold: 1000 Ending inventory: 600 LIFO Cost of Goods Sold During June: $6000 + $6500 = $12,500 June 30 Ending Inventory Value: $3000 + $3600 = $6600 FIFO Cost of Goods Sold During June: $3000 + $8400 = $11400 June 30 Ending Inventory Value: $1200 + $6500 = $7700 300 bags Units LIFO $ FIFO $ Beginning Inventory 300 $3000 $3000 + Purchases 1300 $16,100 $16,100 Available for Sale 1600 $19,100 $19,100 -Ending Inventory 600 $6600 $7700 $12,500 $11,400 Cost of Goods Sold LIFO $ FIFO $ Sales $25,400 $25,400 Less: Cost of Goods Sold $12,500 $11,400 Gross Profit $12,900 $14,000 Gross Profit % 50.78% 55.12% Using the following information, show how Wilson's June purchases and sales of those same 50-pound fertilizer bags impacted its statement of cash flows, income statement, and balance sheet during the month. Assume all inventory purchases are on credit and that there was no beginning balance in the accounts receivable account. Disregard income taxes and assume that the gross profit represents the net income effect of the transactions. HINT: Use the t-accounts on the next page to help you determine the impact. Assume Wilson used the LIFO method, resulting in cost of goods sold of $12,500 and an ending inventory value of $6,600 There was a $4,200 beginning balance in the accounts payable account on June 1 Suppliers were paid $13,500 during the month of June Wilson earned $25,400 of revenue on sales of the fertilizer bags; $19,900 of the revenue related to cash sales, and the rest were credit sales STATEMENT OF CASH FLOW EFFECTS Received from customers (O) $19,900 Paid to suppliers (O) $13,500 NET CHANGE IN CASH FLOW $6400 INCOME STATEMENT EFFECTS Net sales $25,400 Cost of Goods Sold $12,500 GROSS PROFIT $12,900 BALANCE SHEET EFFECTS ASSETS: LIABILITIES + EQUITY: Cash 19,900 Accounts Payable Accounts Receivable 5500 Inventory 6600 CHANGE IN ASSETS $31,000 CHANGE IN LIABILITIES + EQUITY HINT: We're looking for the change in each account during the month of June. Although beginning balances have been provided, they are really irrelevant to this exercise. Cash Bal 10,000 Accounts Receivable Bal Accounts Payable 4,200 Bal Sales Revenue 0 Inventory Bal Retained Earnings 8,800 Bal Cost of Goods Sold Expense 3,000