Answered step by step
Verified Expert Solution
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.
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. 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 dollarStep 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