Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantum Economics And Finance

Authors: David Orrell

3rd Edition

1916081630, 978-1916081635

More Books

Students also viewed these Finance questions