Need help with excel formulas please

1 B C D E F G H crude oil. 3 \begin{tabular}{|c|c|c|c|c|} \hline Beginning inventory and purchases & Units (barrels) & Cost per barrel & Total cost & Units(Barrels)inendinginventory \\ \hline Beginning inventory - January 1 & 125 & $95 & $11,875 & \\ \hline 1-Mar & 50 & $101 & $5,050 & \\ \hline 1-Jun & 65 & $98 & $6,370 & \\ \hline 1-Sep & 75 & $90 & $6,750 & \\ \hline 1-Dec & 50 & $103 & $5,150 & \\ \hline Ending inventory & 110 & & & \\ \hline \end{tabular} Required: Please use the above information to answer the following: Note: Use cells A4 to D10 from the given information to complete this question. Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment