60.1K

Verified Solution

Link Copied!

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{12}{|c|}{ Perpetual LIFO: } \\ \hline \multirow[b]{2}{*}{ Date } & \multicolumn{2}{|c|}{ Goods Purchased } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{6}{|c|}{ Inventory Balance } \\ \hline & # of units & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \begin{tabular}{l} \# of units \\ sold \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & Cost of Goods Sold & \multicolumn{2}{|c|}{# of units } & \multirow{2}{*}{\begin{tabular}{|c|} \begin{tabular}{c} Cost per \\ unit \end{tabular} \\ $52.60 \\ \end{tabular}} & \multicolumn{3}{|c|}{\begin{tabular}{c} Inventory \\ Balance \end{tabular}} \\ \hline March 1 & & & & & & 180 & at & & = & $ & 9,468.00 \\ \hline \multicolumn{12}{|l|}{ March 5} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Total March 5} \\ \hline \multicolumn{12}{|l|}{ March 9} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Total March 9} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ March 18} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Total March 18} \\ \hline & & & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{12}{|c|}{ March 25}} \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Total March 25} \\ \hline & & & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{12}{|c|}{ March 29}} \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline Total March 29 & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{12}{|c|}{ Weighted Average Perpetual: } \\ \hline \multirow[b]{3}{*}{ March 1} & \multicolumn{2}{|c|}{ Goods Purchased } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{6}{|c|}{ Inventory Balance } \\ \hline & \multirow[t]{2}{*}{# of units } & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \multirow[t]{2}{*}{\begin{tabular}{c} \# of units \\ sold \end{tabular}} & \multirow[t]{2}{*}{ Cost per unit } & \multirow[t]{2}{*}{ Cost of Goods Sold } & \multicolumn{2}{|c|}{ \# of units } & \multicolumn{2}{|c|}{\begin{tabular}{l} Cost per \\ unit \end{tabular}} & \multicolumn{2}{|c|}{ Inventory Balance } \\ \hline & & & & & & 180 & at & $ & 52.60 & = & 9,468.00 \\ \hline \multirow{2}{*}{\multicolumn{12}{|c|}{ March 5}} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Average March 5} \\ \hline \multicolumn{12}{|l|}{ March 9} \\ \hline \multicolumn{12}{|l|}{ March 18} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Average March 18} \\ \hline \multirow{2}{*}{\multicolumn{12}{|c|}{ March 25}} \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ Averoge March 25} \\ \hline \multicolumn{12}{|l|}{ March 29} \\ \hline Totals & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ Perpetual FIFO: } \\ \hline \multirow[b]{2}{*}{ Date } & \multicolumn{2}{|c|}{ Goods Purchased } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{5}{|c|}{ Inventory Balance } \\ \hline & \# of units & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \begin{tabular}{l} \# of units \\ sold \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & Cost of Goods Sold & \multicolumn{2}{|c|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|c|} \begin{tabular}{c} Cost per \\ unit \end{tabular} \\ $52.60 \\ \end{tabular}} & \multicolumn{2}{|r|}{\begin{tabular}{c} Inventory \\ Balance \end{tabular}} \\ \hline March 1 & & & & & & 180 & at & & = & \$ 9,468.00 \\ \hline \multicolumn{11}{|l|}{ March 5} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 5} \\ \hline \multicolumn{11}{|l|}{ March 9} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 9} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ March 18} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 18} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ March 25} \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 25} \\ \hline & & & & & & & & & & \\ \hline March 29 & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline Total March 29 & & & & & & & & & & \\ \hline \end{tabular} Required information [The following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, ( c ) weighted average, and ( d ) specific identification. For pecific identification, units sold include 105 units from beginning inventory, 235 units from the March 5 purchase, 85 units from the March 18 purchase, and 125 units from the March 25 purchase. Complete this question by entering your answers in the tabs below. Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold include 105 units fron units from the March 5 purchase, 85 units from the March 18 purchase, and 125 units from the March 25 purchase

Answer & Explanation Solved by verified expert

See Answer