Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am stuck, please help me solve this and provide a thorough explanation on which formulas to insert. Thank you. FIFO LIFO REQUIRED: Determine the

I am stuck, please help me solve this and provide a thorough explanation on which formulas to insert. Thank you.

FIFO

image text in transcribed

image text in transcribed

LIFO

image text in transcribed

image text in transcribed

REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Notice that the sum of cost of goods sold, $0, plus ending inventory, $4,640, equals total cost of goods available for sale, $25,880. REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. \begin{tabular}{|c|c|c|c|c|c|} \hline \begin{tabular}{l} Calculate cost of goods sold for the \\ January 11 sale of 350 units. \end{tabular} & 350 & units@ & $12 & per unit = & $4,200 \\ \hline \multirow{7}{*}{\begin{tabular}{l} Calculate cost of goods sold for the \\ January 17 sale of 530 units. \end{tabular}} & & units@ & & units@ & \\ \hline & & units@: & $12 & units@ & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \multicolumn{6}{|c|}{ Total Cost of Goods Sold for January - 1,520 units } \\ \hline & & & & & \\ \hline Ending Inventory - Perpetual LIFO: & \begin{tabular}{c} Units in \\ Ending \\ Inventory \end{tabular} & @ & \begin{tabular}{c} Cost per \\ unit \end{tabular} & = & \begin{tabular}{l} Inventory \\ Balance \end{tabular} \\ \hline & & & & & \\ \hline & & & & & \\ \hline \multicolumn{5}{|c|}{ Total Ending Inventory for January - 290 units } & \\ \hline \end{tabular}

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

Accounting Understanding And Practice

Authors: Robert Perks

3rd Edition

0077124782, 9780077124786

More Books

Students also viewed these Accounting questions