\begin{tabular}{|c|c|c|c|c|} \hline Date & Activities & Units Acquired & at cost & Units Sold at Retail \\ \hline August 1 & Beginning inventory & 100 units e $10 & =$1,000 & \\ \hline August 5 & Purchase & 40 units@ $12 & =$480 & \\ \hline August 10 & Sale & & & 60 units sold \\ \hline August 15 & Purchase & 70 units@ $13 & =$910 & \\ \hline August 25 & Sale & & & 50 units sold \\ \hline \end{tabular} Use the above information to calculate ending inventory using FIFO for a company that uses a perpetual inventory system. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Date } & \multicolumn{2}{|c|}{ Goods purchased } & & \multicolumn{2}{|c|}{ Cost of Goods Sold } & \multicolumn{4}{|c|}{ Inventory Balance } \\ \hline & \begin{tabular}{c} Number of \\ units \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Number \\ of units \\ sold \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of Goods \\ Sold \end{tabular} & \begin{tabular}{c} Number of \\ units \end{tabular} & Cost per unit & Inventory B & Balance \\ \hline \multicolumn{10}{|l|}{ August 1} \\ \hline \multicolumn{10}{|l|}{ gust 5} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{ Total August 5}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{ August 10}} \\ \hline & & & & & & & & & \\ \hline 100 & 10 & & & & & & & & \\ \hline & & C & & & & & & & \\ \hline \multicolumn{10}{|l|}{ August 15} \\ \hline & 1 & & 1 & 11 & & & & & \\ \hline \multicolumn{10}{|l|}{ Total August 15} \\ \hline \multicolumn{10}{|l|}{ August 25} \\ \hline & & a & - & & & & 7 & & \\ \hline Total August 25 & & & & & & & & & \\ \hline \end{tabular}