I need help filling in the blanks for inventory records for the desk lamps. Please help.

Requirement 2 and Requirement 5c. 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 . For the year ended December 31,2024 , a physical inventory account resulted in the following counts: desk lamps, 1,484; table lamps, 6,291; and floor lamps, 9,400 . Update the inventory records. Begin with the inventory record for desk lamps. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.) More info More info More info Data table More info