How do I plug these formulas in properly?

A1 Accessibility tab summary: Given information for this question is presented in rows 2 through 10 . Requirement 1 intormations are presented in cells E5 th A B C D E F G 1 A sneaker uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is 23 pairs. 3 4 Beginning inventory and purchases Units (pairs) Cost per pair Units (pairs) in 5 Beginning inventory Purchase1 7 8 hase 2 Ending inventory 18 $45 Total cost ending inventory Required: Please use the above information to answer the following: 12 13 Note: Use cells A4 to D10 from the given information to complete this question. 14 15 \begin{tabular}{|l|l|l|} \hline & Units (pairs) & \multicolumn{2}{|c|}{ Costs } \\ \hline Beginning inventory & & 12 \\ \hline Purchases & & \\ \hline Goods available for sale & & \\ \hline Ending inventory & & \\ \hline \end{tabular} 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