Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

those information are provide for this question Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

those information are provide for this question image text in transcribed

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Required: 1. Compute cost of goods available for sale and the number of units available for sale. 2. Compute the number of units in ending inventory. Answer is complete and correct. \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}{l} Cost \\ per \\ unit \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} \# of units \\ sold \end{tabular}} & \multirow[t]{2}{*}{\begin{tabular}{l} Cost \\ per \\ unit \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} Cost of Goods \\ Sold \end{tabular}} & \multicolumn{2}{|c|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|l} \begin{tabular}{c} Cost \\ per \\ unit \end{tabular} \\ $ \\ 51.80 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} Inventory \\ Balance \end{tabular}} \\ \hline March 1 & & & & & & & & & 140 & at & & = & $7,252.00 \\ \hline \multirow{2}{*}{ March 5} & 245 & at & & & & & & & 140 & at & $ & = & $7,252.00 \\ \hline & & & & & & & & & 245 & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & = & 13,916.00 \\ \hline Total March 5 & & & & & & & & & & & & & \begin{tabular}{l} $ \\ 21,168.00 \end{tabular} \\ \hline \multirow{2}{*}{ March 9} & & & & 140 & at & $51.80 & = & $7,252.00 & 0 & at & & & \\ \hline & & & & 160 & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & = & 9,088.00 & & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & = & 4,828.00 \\ \hline Total March 9 & & & & & & & & $16,340.00 & & & & & $4,828.00 \\ \hline \multirow{3}{*}{ March 18} & 105 & at & & & & & & & 0 & at & $ & & \\ \hline & & & & & & & & & & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & = & 4,828.00 \\ \hline & & & & & & & & & 105 & at & & = & 6,489.00 \\ \hline Total March 18 & & & & & & & & & & & & & $ \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{4}{*}{ March 25} & 190 & at & & & & & & & 02 & at & $ & & \\ \hline & & & & & & & & & 85 & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & = & 4,828.00 \\ \hline & & & & & & & & & 105 & at & \begin{tabular}{l} $ \\ 61.80 \end{tabular} & = & 6,489.00 \\ \hline & & & & & & & & & 190 & at & \begin{tabular}{l} $ \\ 63.80 \end{tabular} & = & 12,122.00 \\ \hline Total March 25 & & & & & & & & & & & & & \begin{tabular}{l} $ \\ 23,439.00 \end{tabular} \\ \hline \multirow{4}{*}{ March 29} & & & & 02 & at & $ & = & 0.00 & 02 & at & $ & & \\ \hline & & & & 850 & at & & = & 4,828.00 & 02 & at & \begin{tabular}{l} $ \\ 56.80 \end{tabular} & & \\ \hline & & & & & at & \begin{tabular}{l} $ \\ 61.80 \end{tabular} & = & 5,253.00 & 20 & at & \begin{tabular}{l} $ \\ 61.80 \end{tabular} & = & 1,236.00 \\ \hline & & & & 02 & at & \begin{tabular}{l} $ \\ 63.80 \end{tabular} & = & 0.00 & 190 & at & & = & 12,122.00 \\ \hline Total March 29 & & & & & & & & $10,081.00 & & & & & \begin{tabular}{l} $ \\ 13,358.00 \end{tabular} \\ \hline Totals & & & & & & & & $26,421.00 & & & & & \begin{tabular}{l} $13,358.00 \\ \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Weighted Average Perpetual: } \\ \hline \multirow{3}{*}{\begin{tabular}{l} Date \\ March 1 \end{tabular}} & \multicolumn{3}{|c|}{ Goods Purchased } & \multicolumn{4}{|c|}{ Cost of Goods Sold } & \multicolumn{6}{|c|}{ Inventory Balance } \\ \hline & \multicolumn{2}{|c|}{ \# of units } & \multirow[t]{2}{*}{\begin{tabular}{|l|} 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}} & \begin{tabular}{c} Cost of Goods \\ Sold \end{tabular} & \multicolumn{2}{|c|}{ \# of units } & \multicolumn{2}{|c|}{\begin{tabular}{c} Cost per \\ unit \end{tabular}} & \multicolumn{2}{|r|}{\begin{tabular}{c} Inventory \\ Balance \end{tabular}} \\ \hline & & & & & & & & 140 & at & $ & 51.80 & = & $7,252.00 \\ \hline \multirow{2}{*}{ March 5} & 245 & at & \begin{tabular}{ll} $ & \\ 56.80 & \end{tabular} & & & & & 140 & at & $ & 51.80 & = & $7,252.00 \\ \hline & & & & & & & & 245 & at & $ & 56.80 & = & 13,916.00 \\ \hline \begin{tabular}{l} Average March \\ 5 \end{tabular} & & & & & & & & 385 & at & $ & 54.98 & = & $21,168.00 \\ \hline March 9 & & & & 300 & at & 54.98 & $16,494.00 & & at & $ & 54.98 & = & $4,673.30 \\ \hline \multirow[t]{2}{*}{ March 18} & 105 & at & $31.80 & & & & & 85 & at & $ & 54.98 & = & $4,673.30 \\ \hline & & & & & & & & 105 & at & $ & 61.80 & = & 6,489.00 \\ \hline \begin{tabular}{l} Average March \\ 18 \end{tabular} & & & & & & & & 190 & at & $ & 58.75 & = & \$ 11,162.30 \\ \hline \multirow[t]{2}{*}{ March 25} & 190 & at & & & & & & 190 & at & $ & 58.75 & = & $11,162.50 \\ \hline & & & & & & & & 190 & at & $ & 63.80 & = & 12,122.00 \\ \hline \begin{tabular}{l} Average March \\ 25 \end{tabular} & & & & & & & & 380 & at & $ & 61.27 & = & $23,284.50 \\ \hline March 29 & & & & 170 & at & 61.27 & $10,415.90 & 210 & at & $ & 61.27 & = & \$ 12,866.70 \\ \hline Totals & & & & & & & $26,909.90 & & & & & & \\ \hline \end{tabular} Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold include 85 units from beginning inventory, 215 units from the March 5 purchase, 65 units from the March 18 purchase, and 105 units from the March 25 purchase. 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. 4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, units sold include 85 units from beginning inventory, 215 units from the March 5 purchase, 65 units from the March 18 purchase, and 105 units from the March 25 purchase. Note: Round weighted average cost per unit to two decimals and final answers to nearest whole dollar

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Analysis Synthesis And Design Of Chemical Processes

Authors: Richard Turton, Joseph Shaeiwitz, Debangsu Bhattacharyya, Wallace Whiting

5th Edition

0134177401, 978-0134177403

Students also viewed these Accounting questions