please include all cell references!!

Dublin Corporation provides the following information related to its imventory during the month of October 2023. Required: Using calculations based on a PERPETUAL inventory system, determine the inventory balance Dublin would report in its October 31 balance sheet and the cost of goods sold it would report in its October income statement using each of the following cost flow methods. 1. Determine the cost assigned to ending inventory and to cost of goods sold using the FIFO method. ed to ending inventory and to cost of goods sold using the LIFO method. gross profit under the two methods