Instructions: Calculate the ending inventory, cost of goods sold, cost of goods available for sale, and gross profit under the perpetual FIFO on April 30.

***Please, DO NOT copy and paste from other answers on Chegg as some are wrong, if you don't know the answer, please take your time and investigate. Thank you in advance.***

you can get sales price by multiply for example 100*5.00, or 400*5.10... and then sum them all

P7.4 ( 3) Excel (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of transactions concerning part X for the month of April was as follows. \begin{tabular}{cccccc} \multicolumn{3}{c}{ Purchases } & & \multicolumn{2}{c}{ Sales } \\ \cline { 1 - 1 } \cline { 5 - 6 } April 1 (balance on hand) & 100@ & $5.00 & & April 5 & 300 \\ 4 & 400@ & 5.10 & & 12 & 200 \\ 11 & 300@ & 5.30 & & 27 & 800 \\ 18 & 200@ & 5.35 & & 28 & 150 \\ 26 & 600@ & 5.60 & & & \\ 30 & 200@ & 5.80 & & & \end{tabular}