Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} hline multicolumn{14}{|c|}{ Perpetual FIFO: } hline multirow{3}{*}{begin{tabular}{l} Date January 1 end{tabular}} & multicolumn{3}{|c|}{ Goods purchased } & multicolumn{5}{|c|}{ Cost of Goods Sold
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Perpetual FIFO: } \\ \hline \multirow{3}{*}{\begin{tabular}{l} Date \\ January 1 \end{tabular}} & \multicolumn{3}{|c|}{ Goods purchased } & \multicolumn{5}{|c|}{ Cost of Goods Sold } & \multicolumn{5}{|c|}{ Inventory Balance } \\ \hline & \multicolumn{2}{|l|}{ \# 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}{l} Cost of \\ Goods Sold \end{tabular}} & \multicolumn{2}{|l|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|l} \begin{tabular}{l} Cost \\ per \\ unit \end{tabular} \\ $2800 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{l} Inventory \\ Balance \end{tabular}} \\ \hline & & & & & & & & & 3000 & at & & = & $840.00 \\ \hline \multirow{2}{*}{ January 9} & 700 & at & $3000 & & & & & & 3000 & at & $280 & = & $840.00 \\ \hline & & & & & & & & & 700 & at & 5300 & = & 21000 \\ \hline Total January 9 & & & & & & & & & & & & & $1,05000$ \\ \hline \multirow{3}{*}{ January 25} & 1000 & at & $3140 & & & & & & 3000 & at & 5280 & = & $84000 \\ \hline & & & & & & & & & 700 & at & $300 & = & 21000 \\ \hline & & & & & & & & & 1000 & at & 5314 & = & 31400 \\ \hline \begin{tabular}{l} Total January \\ 25 \end{tabular} & & & & & & & & & & & & & $3.36400 \\ \hline \multirow{3}{*}{ January 26} & & & & 3000 & at & $280 & = & $840.00 & 40 & at & $2.80 & = & 112.00 \\ \hline & & & & 300 & at & \$. 300 & = & 9000 & 100 & at & $300 & = & 300.00 \\ \hline & & & & 330 & at & $314 & = & 1,036.20 & 140 & at & $3.14 & = & 43060 \\ \hline \begin{tabular}{l} Total January \\ 26 \end{tabular} & & & & & & & & $1,96620 & & & & & $85160 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Perpetual FIFO: } \\ \hline \multirow{3}{*}{\begin{tabular}{l} Date \\ January 1 \end{tabular}} & \multicolumn{3}{|c|}{ Goods purchased } & \multicolumn{5}{|c|}{ Cost of Goods Sold } & \multicolumn{5}{|c|}{ Inventory Balance } \\ \hline & \multicolumn{2}{|l|}{ \# 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}{l} Cost of \\ Goods Sold \end{tabular}} & \multicolumn{2}{|l|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|l} \begin{tabular}{l} Cost \\ per \\ unit \end{tabular} \\ $2800 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{l} Inventory \\ Balance \end{tabular}} \\ \hline & & & & & & & & & 3000 & at & & = & $840.00 \\ \hline \multirow{2}{*}{ January 9} & 700 & at & $3000 & & & & & & 3000 & at & $280 & = & $840.00 \\ \hline & & & & & & & & & 700 & at & 5300 & = & 21000 \\ \hline Total January 9 & & & & & & & & & & & & & $1,05000$ \\ \hline \multirow{3}{*}{ January 25} & 1000 & at & $3140 & & & & & & 3000 & at & 5280 & = & $84000 \\ \hline & & & & & & & & & 700 & at & $300 & = & 21000 \\ \hline & & & & & & & & & 1000 & at & 5314 & = & 31400 \\ \hline \begin{tabular}{l} Total January \\ 25 \end{tabular} & & & & & & & & & & & & & $3.36400 \\ \hline \multirow{3}{*}{ January 26} & & & & 3000 & at & $280 & = & $840.00 & 40 & at & $2.80 & = & 112.00 \\ \hline & & & & 300 & at & \$. 300 & = & 9000 & 100 & at & $300 & = & 300.00 \\ \hline & & & & 330 & at & $314 & = & 1,036.20 & 140 & at & $3.14 & = & 43060 \\ \hline \begin{tabular}{l} Total January \\ 26 \end{tabular} & & & & & & & & $1,96620 & & & & & $85160 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Perpetual FIFO: } \\ \hline \multirow{3}{*}{\begin{tabular}{l} Date \\ January 1 \end{tabular}} & \multicolumn{3}{|c|}{ Goods purchased } & \multicolumn{5}{|c|}{ Cost of Goods Sold } & \multicolumn{5}{|c|}{ Inventory Balance } \\ \hline & \multicolumn{2}{|l|}{ \# 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}{l} Cost of \\ Goods Sold \end{tabular}} & \multicolumn{2}{|l|}{ \# of units } & \multirow{2}{*}{\begin{tabular}{|l} \begin{tabular}{l} Cost \\ per \\ unit \end{tabular} \\ $2800 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{l} Inventory \\ Balance \end{tabular}} \\ \hline & & & & & & & & & 3000 & at & & = & $840.00 \\ \hline \multirow{2}{*}{ January 9} & 700 & at & $3000 & & & & & & 3000 & at & $280 & = & $840.00 \\ \hline & & & & & & & & & 700 & at & 5300 & = & 21000 \\ \hline Total January 9 & & & & & & & & & & & & & $1,05000$ \\ \hline \multirow{3}{*}{ January 25} & 1000 & at & $3140 & & & & & & 3000 & at & 5280 & = & $84000 \\ \hline & & & & & & & & & 700 & at & $300 & = & 21000 \\ \hline & & & & & & & & & 1000 & at & 5314 & = & 31400 \\ \hline \begin{tabular}{l} Total January \\ 25 \end{tabular} & & & & & & & & & & & & & $3.36400 \\ \hline \multirow{3}{*}{ January 26} & & & & 3000 & at & $280 & = & $840.00 & 40 & at & $2.80 & = & 112.00 \\ \hline & & & & 300 & at & \$. 300 & = & 9000 & 100 & at & $300 & = & 300.00 \\ \hline & & & & 330 & at & $314 & = & 1,036.20 & 140 & at & $3.14 & = & 43060 \\ \hline \begin{tabular}{l} Total January \\ 26 \end{tabular} & & & & & & & & $1,96620 & & & & & $85160 \\ \hline \end{tabular} Required information Use the following information for the Quick Study below. (Algo) (5-7) [The following information applies to the questions displayed below.] A company reports the following beginning inventory and two purchases for the month of January. On January 26 , the company sells 330 units. Ending inventory at January 31 totals 140 units. QS 6.5 (Algo) Perpetual: Inventory costing with FIFO LO P1 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on he FIFO method. Required information Use the following information for the Quick Study below. (Algo) (5-7) [The following information applies to the questions displayed below.] A company reports the following beginning inventory and two purchases for the month of January. On January 26 , the company sells 330 units. Ending inventory at January 31 totals 140 units. QS 6.5 (Algo) Perpetual: Inventory costing with FIFO LO P1 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on he FIFO method. A company reports the following beginning inventory and two purchases for the month of January. On January 26 , the company sells 330 units. Ending inventory at January 31 totals 140 units
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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