Help me please with this assignment , show full explanation in excel please

Assignments: Intermediate Acc x 5 Question 2 - GO! - CH 08 APPI X x1 Integrated Excel Tool C a ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252720964176582_IE0801S X O A 06HOBUTb : Excel McGraw Hill Excel Question - Saved Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing Comments & Cut 11 ~ A A = ab Wrap Text Number [ Autosum AY Calibri O Mc Hill LE Copy Clear Paste Sort & Find & Format Painter BIUDab v Av Merge & Center $ ~ % 9 78 08 Conditional Format As Styles Insert Delete Format Open Formatting Table Filter ~ Select Undo Clipboard Font Alignment Number Styles Cells Editing MHE Tool D26 " X V fx B E F G H J K L M N 0 P Q R Dublin Corporation provides the following information related to its inventory during the month of October 2022. Date Units Per unit October 1 nventory on hand 3,000 units at cost of $6.00 per unit October 9 Solo 2,400 units for $10.00 each October 12 Purchase 1,200 units at a cost of $6.30 per unit 10 October 18 Sold 1,000 units for $10.20 each 11 October 24 Purchase 1,400 units at a cost of $7.20 per unit 12 October 31 Inventory on hand units 13 14 Required: Using calculations based on a PERPETUAL inventory system, determine the inventory balance Dublin would report in its October 31 balance sheet and the 15 cost of goods sold it would report in its October income statement using each of the following cost flow methods. 16 17 1. Determine the cost assigned to ending inventory and to cost of goods sold using the FIFO method. 18 19 Perpetual FIFO 20 Cost of Goods Available for Sale Cost of Goods Sold - October 9 Cost of Goods Sold - October 18 Ending Inventory Cost of Goods # of units in Number of Cost per Available for Number of Cost of Number of Cost per Cost of ending Cost per Ending 21 units unit Sale units sold Cost per unit Goods Sold units sold unit Goods Sold inventory unit Inventory 22 Beginning inventory $0.00 SO $0.00 $0.00 SO 23 Purchase of October 12 $0.00 $0.00 0 $0.0 24 Purchase of October 24 $0.00 $0.00 $0.0 25 Total So so 26 27 2. Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method. E Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +Assignments: Intermediate Acc x 5 Question 2 - GO! - CH 08 APPI X x1 Integrated Excel Tool C a ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252720964176582_IE0801S X O A 06HOBUTb : Excel McGraw Hill Excel Question - Saved Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing Comments & Cut 11 ~ A A = E ab Wrap Text O Mc Calibri Number [ AutoSum AY LE Copy Hill Paste BIUDab Av E E Clear Format Painter Merge & Center $ ~ % 9 78 08 Conditional Format As Styles Insert Delete Format Sort & Find & Open Formatting Table Filter ~ Select Undo Clipboard Font Alignment Number Styles Cells Editing MHE Tool D26 V X V fx A B C D E F G H K M N P Q R units unit Sale units sold Cost per unit | Goods Sold | units sold unit | Goods Sold | Inventory unit |Inventory 22 Beginning inventory $0.0 $0.OC $0.00 23 Purchase of October 12 $0.00 $0.00 $0.00 SO 24 Purchase of October 24 $0.00 $0.00 $0.00 0 25 Tota so so 26 27 2. Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method. 28 Perpetual LIFO 30 Cost of Goods Available for Sale Cost of Goods Sold - October 9 Cost of Goods Sold - October 18 Ending Inventory Cost of Goods # of units in Number of Cost per Available for Number of Cost of Number of Cost per Cost of ending Cost per Ending 31 units unit Sale units sold Cost per unit | Goods Sold units sold unit Goods Sold | inventory unit Inventory 32 Beginning inventory 0 $0.00 so $0.00 SO $0.00 $0.00 SO 33 Purchase of October 12 0 $0.00 0 $0.OC $0.00 SO $0.00 SO 34 Purchase of October 24 0 50.00 0 $0.0 $0.00 $0.00 0 35 Total 0 so so so so 36 37 3. Compute the amount of gross profit under the two methods: 38 Perpetual Perpetual 39 FiFO LIFO 40 Sales 41 Cost of goods sold 42 Gross profit 43 44 45 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +