PLEASE INCLUDE ALL EXCEL FORMULAS IN EVERY SINGLE EXCEL CELL. EXAMPLE: B$2+$C$2.$ JUST PLS INCLUDE FORMULAS IN EVERY CELL AND ILL RATE YOU WELL.Dublin Corporation provides the following information related to its inventory 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.

Determine the cost assigned to ending inventory and to cost of goods sold using the FIFO method.