Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[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
[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.
Date | Activities | Units Acquired at Cost | Units Sold at Retail | ||||
---|---|---|---|---|---|---|---|
March 1 | Beginning inventory | 100 | units | @ $50 per unit | |||
March 5 | Purchase | 400 | units | @ $55 per unit | |||
March 9 | Sales | 420 | units | @ $85 per unit | |||
March 18 | Purchase | 120 | units | @ $60 per unit | |||
March 25 | Purchase | 200 | units | @ $62 per unit | |||
March 29 | Sales | 160 | units | @ $95 per unit | |||
Totals | 820 | units | 580 | units |
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold include 80 units from beginning inventory, 340 units from the March 5 purchase, 40 units from the March 18 purchase, and 120 units from the March 25 purchase.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Perpetual FIFO: } \\ \hline \multirow[b]{2}{*}{ Date } & \multicolumn{3}{|c|}{ Goods Purchased } & \multicolumn{5}{|c|}{ Cost of Goods Sold } & \multicolumn{5}{|c|}{ Inventory Balance } \\ \hline & \multicolumn{2}{|c|}{ \# of units } & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} \# of units \\ sold \end{tabular}} & \multirow[t]{2}{*}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \multicolumn{2}{|c|}{ Cost of Goods Sold } & \multicolumn{2}{|c|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{c} \begin{tabular}{c} Cost per \\ unit \end{tabular} \\ $50.00 \end{tabular}} & \multicolumn{2}{|c|}{ Inventory Balance } \\ \hline March 1 & & & & & & & & & 100 & at & & = & $5,000.00 \\ \hline \multirow{2}{*}{ March 5} & 400 & at & $55.00 & & & & & & 100 & at & $50.00 & = & $5,000.00 \\ \hline & & & & & & & & & 400 & at & $55.00 & = & 22,000.00 \\ \hline Total March 5 & & & & & & & & & & & & & $27,000.00 \\ \hline \multirow{2}{*}{ March 9} & & & & 80 & at & $50.00 & = & 4,000.00 & & at & $50.00 & & \\ \hline & & & & & at & $55.00 & = & 0.00 & & at & $55.00 & & \\ \hline Total March 9 & & & & & & & & $4,000.00 & & & & & \\ \hline \multirow{3}{*}{ March 18} & 120 & at & $60.00 & & & & & & & at & $50.00 & & \\ \hline & & & & & & & & & & at & $55.00 & & \\ \hline & & & & & & & & & & at & $60.00 & & \\ \hline \multicolumn{14}{|l|}{ Total March 18} \\ \hline \multirow{4}{*}{ March 25} & 200 & at & $62.00 & & & & & & & at & $50.00 & & \\ \hline & & & & & & & & & & at & $55.00 & & \\ \hline & & & & & & & & & & at & $60.00 & & \\ \hline & & & & & & & & & & at & $62.00 & & \\ \hline \multicolumn{14}{|l|}{ Total March 25} \\ \hline & & & & & & & & & & & & & \\ \hline \multicolumn{14}{|l|}{ March 29} \\ \hline & & & & & & & & & & & & & \\ \hline \multicolumn{14}{|l|}{ Total March 29} \\ \hline Totals & & & & & & & & 4,000.00 & & & & & 0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ Perpetual LIFO: } \\ \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}{c} \# of units \\ sold \end{tabular} & \multirow[t]{2}{*}{\begin{tabular}{c} \begin{tabular}{c} Cost per \\ unit \end{tabular} \\ \end{tabular}} & Cost of Goods Sold & \multicolumn{2}{|c|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|c|} \begin{tabular}{c} Cost per \\ unit \end{tabular} \\ $50.00 \\ \end{tabular}} & \multicolumn{2}{|c|}{ Inventory Balance } \\ \hline March 1 & & & & & & 100 & at & & = & $5,000.00 \\ \hline \multicolumn{11}{|l|}{ March 5} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 5} \\ \hline \multicolumn{11}{|l|}{ March 9} \\ \hline Ividicio & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 9} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ March 18} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 18} \\ \hline & & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{ March 25}} \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 25} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ March 29} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Total March 29} \\ \hline Totals & & & & & 0.00 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ Weighted Average Perpetual: } \\ \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}{c} \# 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} \\ $50.00 \end{tabular}} & \multicolumn{2}{|c|}{ Inventory Balance } \\ \hline March 1 & & & & & & 100 & at & & = & 5,000.00 \\ \hline \multicolumn{11}{|l|}{ March 5} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Average March 5} \\ \hline \multicolumn{11}{|l|}{ March 9} \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{ March 18}} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Average March 18} \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{ March 25}} \\ \hline & & & & & & & & & & \\ \hline \multicolumn{11}{|l|}{ Average March 25} \\ \hline \multicolumn{11}{|l|}{ March 29} \\ \hline Totals & & & & & 0.00 & & & & & \\ \hline \end{tabular} Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold include 80 units from beginning inventory, 340 units from the March 5 purchase, 40 units from the March 18 purchase, and 120 units from the March 25 purchase
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