Could help me with the formulas? Please

Accessibility tab summary: Given information for this question is presented in rows 2 throu (A) xfx Accessibility tab summary: Given information for this question is presente 4 A B D E F Units (pairs) in 4 Beginning imentory and purchases. Units (pairs) Total cost ending imentory \begin{tabular}{|l|r|} \hline Beginning imventory & 12 \\ \hline Purchase 1 & 18 \\ \hline Purchase 2 & 20 \\ \hline Ending imventory & 23 \\ \hline \end{tabular} Cost perpair 5540 $540 5 6 7 8 9 10 Required: Please use the above information to onswer the following: 12 13 Note: Use cells A4 to D10 from the given information to complete this question. 14 15 16 Bedinning inventory Purchases Goods avallable for sale Ending inventory Cost of goods sold \begin{tabular}{|l|r|} \hline Units (pairs) & Costs \\ \hline 12 & $540 \\ \hline 38 & 1,720 \\ \hline 50 & \\ \hline 23 & \\ \hline 27 & \\ \hline \end{tabular} Graded worksheet