Requirements 1. Open general ledger T-accounts and enter opening balances as of September 30 , 2024 2. Open inventory records for the three inventory items and enter opening balances as of September 30,2024. Complete the inventory records using the following transactions: Oct. 1, 12, 15, 28; Nov. 1, 5, 15, 18, and Dec. 27 3. Record the transactions in the general journal. 4. Post transactions to the general ledger. 5. Prepare adjusting entries for the year ended December 31, 2024, and post to the ledger: a. Depreciation, $48,500 ( 75% selling, 25% administrative). b. Supplies on hand: office, $200; warehouse, $650. c. A physical inventory account resulted in the following counts: desk lamps, 1,990; table lamps, 5,995; and floor lamps, 6,000. Update the inventory records. 6. Prepare an adjusted trial balance. 7. Provide a summary for the month, in both units and dollars, of the change in inventory for each item in the following format. (Click the icon to view the format) Does the sum of the ending belances in the inventory records match the balance in Merchandise Inventory in the general ledger? If not, review the transactions to find your error. 8. Prepare Davis Lamp Company's multi-step income statement and statement of retained Data table Accumulated Depreciation Accounts Payable Common Stock Retained Earnings Dividends Sales Revenue Cost of Goods Sold Salaries Expense-Selling Utilities Expense-Selling Supplies Expense-Selling Depreciation Expense-Selling Salaries Expense-Administrative Utilities Expense-Administrative Supplies Expense-Admipistrative Depreciation Expense-Administrative Total Requirements 4. Post transactions to the general ledger. 5. Prepare adjusting entries for the year ended December 31, 2024, and post to the ledger: a. Depreciation, $48,500 (75\% selling, 25% administrative). b. Supplies on hand: office, $200; warehouse, $650. c. A physical inventory account resulted in the following counts: desk lamps, 1,990; table lamps, 5,995; and floor lamps, 6,000. Update the inventory records. 6. Prepare an adjusted trial balance. 7. Provide a summary for the month, in both units and dollars, of the change in inventory for each item in the following format: (Click the icon to view the format.) Does the sum of the ending balances in the inventory records match the balance in Merchandise Inventory in the general ledger? If not, review the transactions to find your error. 8. Prepare Davis Lamp Company's multi-step income statement and statement of retained earnings for the year ended December 31,2024, and a classified balance sheet as of December 31, 2024 9. Calculate the following ratios for DLC as of December 31, 2024: gross profit percentage, inventory turnover, and days' sales in inventory. 10. Record and post the closing entries. 11. Prepare a post-closing trial balance. The Davis Lamp Company (DLC) is a wholesale company that purchases lamps from the manufacturer and resells them to retail stores. 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 The trial baiance for DLC as of September 30, 2024 follows: (Click the icon to view the trial balance.) Merchandise Inventory as of September 30 consists of the following lamps (Click the icon to view the Merchandise Inventory) During the fourth quarter of 2024, DLC completed the following transactions (3) (Click the icon to view the transactions) Read the requirements Requirement 1. Open general ledger T-accounts and enter opening balances as of September 30, 2024. (Enter a "0" on the normal side of the T-account for accounts with a zero balance as of September 30, 2024 . Abbreviation used Depr = depreciation ) Cash Accounts Payable Sales Revenue Accounts Receivable Common Stock Cost of Goods Sold Data table \begin{tabular}{lrrr} \hline Item & Quantity & Unit Cost & \multicolumn{1}{c}{ Total Cost } \\ \hline Desk Lamp & 2,500$ & 8$ & 20,000 \\ Table Lamp & 3,000 & 18 & 54,000 \\ Floor Lamp & 2,000 & 26 & 52,000 \\ Total & & $ & 126,000 \\ \hline \end{tabular}