Please do not fill in the numbers directly in the form, please fill in the requirements of this figure, for example:=B3+C3 PSOnly one hour left, please help. PS: Please be sure to fill in the same form as the form, otherwise I may not understand it.

For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 Dublin Corporation provides the following information related to its inventory during the month of October: October 1 Inventory on hand-3,000 units; cost $6.00 each. October 9 Sold 2,400 units for $10.00 each. October 12 Purchased 1,200 units for $6.30 each. October 18 Sold 1,000 units for $10.20 each. October 24 Purchased 1,400 units for $7.20 each. October 31 Inventory on hand 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. 2. Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method. 3. Compute the amount of gross profit under the two methods. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Dublin Corporation provides the following information related to its inventory during the month of October 2022. 2. Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method