I have completed the first two requirements and I am stuck on the rest. This is one long multiple part question. I included pictures of the data tables that I already have completed. Complete requirements #3 through #11 to complete the question.

Cash Accounts Payable Sales Revenue Bal. 425,000 0 Bal. 2,588,425 Bal. Accounts Receivable Cost of Goods Sold Darbys, Capital 364,000 Bal. Bal. 0 Bal. 1,025,000 Merchandise Inventory Darbys, Withdrawals Salaries Expense-Selling 195,000 Bal. 137,200 Bal. 0 Bal. Office Supplies Utilities Expense-Selling Bal. 345 Bal. 36.000 Warehouse Supplies Supplies Expense-Selling Bal. 480 Bal. 0 Land Depreciation Expense-Selling Bal. 14,000 Bal. 0 Building 750,000 Salaries Expense-Administrative Bal. 93,000 Bal. Utilities Expense-Administrative Office Furniture and Equipment Bal. 148,000 Bal. 28,000 Warehouse Fixtures Supplies ExpenseAdministrative Bal. 350,000 Bal. 0 Depr. Expense-Administrative Accumulated Depreciation 249,600 Bal. Bal. 0 Requirement 2 and Requirement 5c. Open inventory records for the three inventory items and enter opening balances as of September 30, 2024 |Desk lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Cost Quantity Cost 2,800 $ Sep. 30 9 $ 25,200 Oct. 1 5,500 $ 12 $ 66,000 2,800 $ 9 $ 25,200 5,500 $ 12 $ 66,000 15 1,400 $ 9 $ 12,600 1,400 $ 9 $ 12,600 5,500 $ 12 $ 66,000 Nov. 1 1,400 $ 9 | $ 12,600 4,000 $ 12 | $ 48,000 1,500 $ 12 $ 18,000 5 5,500 $ 14 $ 77,000 4,000 $ 12 $ 48,000 5,500 $ 14 $ 77,000 15 1,700$ 12 $ 20,400 2,300 $ FA 12 | $ 27,600 5,500 $ 14 $ 77,000 Dec. 27 2,300 $ 12 $ 27,600 2,000 $ 14 $ 28,000 3,500 $ 14 $ 49,000 31 8 $ 14 | $ 112 1,992 $ 14 $ 27,888 $ 143,000 11,000 Totals 11,808 $ 140,312 1,992 $ 27,888 Table lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost 2,000 $ 20 $ 40,000 Sep. 30 Oct. 1 4,500 $ 20 $ 90,000 2,000 $ 20 $ 40,000 4,500 $ 20 $ 90,000 12 2,000 $ 20 $ 40,000 4,000 $ 20 80,000 500 $ 20 $ 10,000 28 2,000 20 $ 40,000 2,000 $ 20 $ 40,000 Nov. 5 7,000 $ 21 $ 147,000 2,000 $ 20 $ 40,000 7,000 $ 21 $ 147,000 18 1,500 $ 20 $ 30,000 500 $ 20 $ 10,000 7,000 $ 21 $ 147,000 Dec. 27 500 $ 20 $ 10,000 5,500 $ 21 $ 115,500 1,500 $ 21 $ 31,500 31 12] $ 21 $ 252 5,488 $ 21 $ 115,248 1 11,500 $ 237,000 Totals 8,012 $ 161,752 5,488 $ 115,248 Floor lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Cost Cost Quantity 2,400 $ Sep. 30 30 $ 72,000 Oct. 1 2,000 $ 21 $ 42,000 2,400 $ 30 $ 72,000 2,000 $ 21 $ 42,000 28 1,100 $ 30 $ 33,000 1,300 $ 30 $ 39,000 2,000 $ 21 $ 42,000 Nov. 5 4,000 $ 23 $ 92,000 1,300] $ 30 $ 39,000 2,000 $ 21 $ 42,000 4,000 $ 23 $ 92,000 18 1,300 $ 30] $ 39,000 1,400 $ 21 ] $ 29,400 23 $ 92,000 600 $ 21 ] $ 12,600 4,000 $ $ 134,000 6,000 Totals $ 84,600 $ 121,400 3,000 5,400 BAC 101 Comprehensive Problem - Guide Requirement #1: Opening T-accounts . O For accounts with normal debit balances Enter 'Bal." first and then the amount (there are two boxes on each side of the T- account) For accounts with normal credit balance o Enter the amount first and then "Bal." Remember to enter zero for accounts without balances on the normal side of the T-account Requirement #2: Open and complete inventory records Remember to add the beginning balance For the inventory on hand, enter the oldest inventory layers first Pay attention to the inventory costing method used by the company Do not forget to adjust for any inventory shrinkage Requirement # 3: Record transactions in the general journal Remember to enter debits first, then credits Select an explanation on the last line of the journal entry table Requirement #4: Post transactions to T-accounts Requirement #5: Prepare adjusting entries and post to T-accounts Remember to post debits before credits Requirement #6: Prepare an adjusted trial balance Debits must equal credits Requirement #7: Prepare a summary of inventory transactions Debits must equal credits Requirement #7: Prepare a summary of inventory transactions Requirement #8: Prepare financial statements Remember how the financial statements are interconnected Requirement #9: Calculate the following ratios: . O . Gross profit % Show as percentage, rounded to 2 decimal places X.XX% Inventory turnover rate Show as a whole number, round to two decimal places X.XX Days' sales in inventory Show final answer as a whole number, rounded to number of days X Enter formula amounts to two decimal places, X.XX (inventory turnover) O . O O Requirement # 10: Record and post the closing entries . Use Clos. And the number of the entry (Clos. (1)) as the reference Requirement 11: Prepare a post-closing trial balance . Debits must equal credits Only permanent/real accounts should have a balance . Item Quantity Unit Cost Total Cost 2,800 $ 9 $ 25,200 Desk Lamp Table Lamp 2,000 $ 20 40,000 72,000 Floor Lamp 2,400 $ 30 $ 137,200 Total - More Info Oct. 1 Oct. 12 Oct. 15 Oct. 20 Oct. 23 Purchased lamps on account from Appalachian Lights, terms n/30, FOB destination: 5,500 desk lamps at $12 each 4,500 table lamps at $20 each 2,000 floor lamps at $21 each Sold lamps on account to Moonbeam Home Furnishings, terms 2/10, n/30: 2,500 table lamps at $48 each Sold lamps on account to Newnan Office Supply, terms 1/10, n/30: 1,400 desk lamps at $17 each Received a check from Moonbeam Home Furnishings for full amount owed on Oct. 12 sale. Received a check from Newnan Office Supply for full amount owed on Oct. 15 sale. Sold lamps on account to Skyway Home Stores, terms 1/10, n/30: 2,000 table lamps at $48 each 1,100 floor lamps at $63 each Paid amount due to Appalachian Lights from Oct. 1 purchase. Paid salaries, $39,000 (75% selling, 25% administrative). Paid utilities, $2,300 (70% selling, 30% administrative). Sold lamps on account to Newnan Office Supply, terms 2/10, n/30: 2,900 desk lamps at $17 each Purchased lamps on account from Appalachian Lights, terms n/30, FOB destination: Oct. 28 Oct. 30 Oct. 31 Oct. 31 Nov. 1 Nov. 5 Nov. 5 Nov. 5 Nov. 8 Purchased lamps on account from Appalachian Lights, terms n/30, FOB destination: 5,500 desk lamps at $14 each 7,000 table lamps at $21 each 4,000 floor lamps at $23 each Received a check from Skyway Home Stores for full amount owed on Oct. 28 sale. Received a check from Newnan Office Supply for full amount owed on Nov. 1 sale. Purchased and paid for supplies: $220 for the office; $775 for the warehouse. Sold lamps on account to Morgan Office Supply, n/30: 1,700 desk lamps at $17 each Sold lamps on account to Metro Discount Stores, terms 3/10, n/30: 1,500 table lamps at $48 each 1,900 floor lamps at $63 each Nov. 10 Nov. 15 Nov. 18 Nov. 28 Received a check from Metro Discount Stores for full amount owed on Nov. 18 sale. Nov. 30 Nov. 30 Dec. 5 Paid salaries, $39,000 (75% selling, 25% administrative). Paid utilities, $2,140 (70% selling, 30% administrative). Paid amount due to Appalachian Lights from Nov. 5 purchase. Received a check from Morgan Office Supply for full amount owed on Nov. 15 sale. Darbys withdrew $55,000 from the business. Dec. 15 Dec. 15 Dec. 27 Sold lamps on account to Moonbeam Home Furnishings, terms 1/10, n/30: Nov. 18 Sold lamps on account to Metro Discount Stores, terms 3/10, n/30: 1,500 table lamps at $48 each 1,900 floor lamps at $63 each Nov. 28 Received a check from Metro Discount Stores for full amount owed on Nov. 18 sale. Nov. 30 Nov. 30 Paid salaries, $39,000 (75% selling, 25% administrative). Paid utilities, $2,140 (70% selling, 30% administrative). Paid amount due to Appalachian Lights from Nov. 5 purchase. Received a check from Morgan Office Supply for full amount owed on Nov. 15 sale. Dec. 5 Dec. 15 Dec. 15 Darbys withdrew $55,000 from the business. Dec. 27 Sold lamps on account to Moonbeam Home Furnishings, terms 1/10, n/30: 5,800 desk lamps at $17 each 2,000 table lamps at $48 each Paid salaries, $39,000 (75% selling, 25% administrative). Paid utilities, $3,000 (70% selling, 30% administrative). Dec. 31 Dec. 31 The company has three inventory items: desk lamps, table lamps, and floor lamps. DLC uses a perpetual inventory system, FIFO method. DLC owns land with a building, which is separated into two parts: office space and warehouse space. All expenses associated with the office are categorized as Administrative Expenses. All expenses associated with the warehouse, which is used for the shipping and receiving functions of the company, are categorized as Selling Expenses. In addition to the land and building, DLC also owns office furniture and equipment and warehouse fixtures. The company uses one accumulated depreciation account for all the depreciable assets. Darbys Lamp Company Trial Balance September 30, 2024 Balance Account Debit Credit Cash $ 425,000 Accounts Receivable 0 Merchandise Inventory 137,200 345 Office Supplies Warehouse Supplies 480 Land 14,000 750,000 148,000 350,000 Building Office Furniture and Equipment Warehouse Fixtures Accumulated Depreciation Accounts Payable Darbys, Capital Darbys, Withdrawals 249,600 0 364,000 0 Warehouse Fixtures 350,000 Accumulated Depreciation $ 249,600 Accounts Payable 0 364,000 Darbys, Capital Darbys, Withdrawals 0 Sales Revenue 2,588,425 Cost of Goods Sold 1,025,000 Salaries Expense-Selling 195,000 Utilities Expense-Selling 36,000 Supplies Expense-Selling 0 0 Depreciation ExpenseSelling Salaries Expense-Administrative Utilities Expense-Administrative 93,000 28,000 Supplies ExpenseAdministrative 0 0 Depreciation Expense-Administrative $ 3,202,025 $ 3,202,025 Total 12:13 1 5G Expert Q&A Done The company has three inventory toms desklames, table lamps, and foor lamps OLC uses a perpetual Inventory system FIFO metod DLC wristand with a bolding, which is separated into two parts office space and warehouse sece. At spenses clied win the office are categorued as Administrative Expenses All expenses associated with the warehouse which is used for the shipping and for all the depreciables Dartiya Lam Company Trial Balance September 30, 2024 Balance Account Det Crede Cash 125.000 Accounts Receiva Merchandise Inventory 137,200 Office Supplies 345 Warehouse Supplies 40 Land 14.000 Building 750.000 Orien Furniture and Equipment 160.000 Warehouse Fixture 350.000 Accumulated Depreciation $ Accounts Payable Durys, Capital 364000 Durys. Withdrawals 0 350.000 $ 248.000 4000 Warehouse Flutures Accued Depreciation Actions Payable Darbys, Capital Darby, Withdrawal Sales Revenue Cost of Goods Sold Salaries Expense-Selling Uilt Expense-Selling Suppilas pense-Selling Depreciation Expanse--Selling Salaries Expanse-Administrative Utilities Expans-Administrative Supplies Expense-Administrative Depreciation Expanse-Administrative Total 1.095.000 195.000 30.000 0 93.000 2000 3.292.025s 2000 12:13 5G Expert Q&A Done 2.00 . 05.000 O. 200 Decor www 2,00 Dec 19 ore Des 1566.00 Dom 14 Hex Vids.COM Dr. Dec 15 Dat www. 5.2007 Dwww.10.00