Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. Note: Round your average cost
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. Note: Round your "average cost per unit" to 2 decimal places. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{|l|} c) Average Cost \\ \\ Beginning inventory \end{tabular}} & \multicolumn{3}{|c|}{ Cost of Goods Available for Sale } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{3}{|c|}{ Ending Inventory } \\ \hline & \multirow{2}{*}{\begin{tabular}{r} \# of units \\ 160 \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Available \\ for Sale \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{c} # of units \\ sold \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ Unit \end{tabular} & \begin{tabular}{l} Cost of \\ Goods \\ Sold \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{l} \# of units in \\ ending \\ inventory \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ unit \end{tabular} & \begin{tabular}{c} Ending \\ Inventory \end{tabular} \\ \hline & & & $8,000 & & & & & & \\ \hline \multicolumn{10}{|l|}{ Purchases: } \\ \hline March 5 & 460 & & 25,300 & & & & & & \\ \hline March 18 & 240 & & 14,400 & & & & & & \\ \hline March 25 & 320 & & 19,840 & & & & & & \\ \hline Total & 1,180 & & $67,540 & & & $ & & & $ \\ \hline d) Specific Identification & \multicolumn{3}{|c|}{ Cost of Goods Available for Sale } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{3}{|c|}{ Ending Inventory } \\ \hline & \# of units & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Available \\ for Sale \end{tabular} & \begin{tabular}{c} \# of units \\ sold \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Sold \end{tabular} & \begin{tabular}{l} \# of units in \\ ending \\ inventory \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Ending \\ Inventory \end{tabular} \\ \hline Beginning inventory & 160 & $50.00 & $8,000 & & $50.00 & $ & & $50.00 & $ \\ \hline \multicolumn{10}{|l|}{ Purchases: } \\ \hline March 5 & 460 & $55.00 & 25,300 & & $55.00 & 0 & & $55.00 & 0 \\ \hline March 18 & 240 & $60.00 & 14,400 & & $60.00 & 0 & & $60.00 & 0 \\ \hline March 25 & 320 & $62.00 & 19,840 & & $62.00 & 0 & & $62.00 & 0 \\ \hline Total & 1,180 & & $67,540 & 0 & & & 0 & & \\ \hline \end{tabular} Problem 5-1A (Algo) Periodic: Alternative cost flows LO P1 [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic inventory system. It entered into the following purchases and sales transactions for March. For specific identification, the March 9 sale consisted of 60 units from beginning inventory and 420 units from the March 5 purchase; the March 29 sale consisted of 100 units from the March 18 purchase and 180 units from the March 25 purchase. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{|l|} c) Average Cost \\ \\ Beginning inventory \end{tabular}} & \multicolumn{3}{|c|}{ Cost of Goods Available for Sale } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{3}{|c|}{ Ending Inventory } \\ \hline & \multirow{2}{*}{\begin{tabular}{r} \# of units \\ 160 \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Available \\ for Sale \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{c} # of units \\ sold \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ Unit \end{tabular} & \begin{tabular}{l} Cost of \\ Goods \\ Sold \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{l} \# of units in \\ ending \\ inventory \end{tabular}} & \begin{tabular}{c} Average \\ Cost per \\ unit \end{tabular} & \begin{tabular}{c} Ending \\ Inventory \end{tabular} \\ \hline & & & $8,000 & & & & & & \\ \hline \multicolumn{10}{|l|}{ Purchases: } \\ \hline March 5 & 460 & & 25,300 & & & & & & \\ \hline March 18 & 240 & & 14,400 & & & & & & \\ \hline March 25 & 320 & & 19,840 & & & & & & \\ \hline Total & 1,180 & & $67,540 & & & $ & & & $ \\ \hline d) Specific Identification & \multicolumn{3}{|c|}{ Cost of Goods Available for Sale } & \multicolumn{3}{|c|}{ Cost of Goods Sold } & \multicolumn{3}{|c|}{ Ending Inventory } \\ \hline & \# of units & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Available \\ for Sale \end{tabular} & \begin{tabular}{c} \# of units \\ sold \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Cost of \\ Goods \\ Sold \end{tabular} & \begin{tabular}{l} \# of units in \\ ending \\ inventory \end{tabular} & \begin{tabular}{c} Cost per \\ unit \end{tabular} & \begin{tabular}{c} Ending \\ Inventory \end{tabular} \\ \hline Beginning inventory & 160 & $50.00 & $8,000 & & $50.00 & $ & & $50.00 & $ \\ \hline \multicolumn{10}{|l|}{ Purchases: } \\ \hline March 5 & 460 & $55.00 & 25,300 & & $55.00 & 0 & & $55.00 & 0 \\ \hline March 18 & 240 & $60.00 & 14,400 & & $60.00 & 0 & & $60.00 & 0 \\ \hline March 25 & 320 & $62.00 & 19,840 & & $62.00 & 0 & & $62.00 & 0 \\ \hline Total & 1,180 & & $67,540 & 0 & & & 0 & & \\ \hline \end{tabular} 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. Note: Round your "average cost per unit" to 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started