PLEASE PROVIDE EXCEL FORMULAS FOR EACH YELLOW SQUARE IN PICTURE!! Dublin Corporation provides the following information related to its inventory during the month of October $2024.$

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 wauld repart in its Octaber incorne statement using each of the following cost flow methads.

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