Answer and Explanation:
a. The computation of ending inventory and cost of goods sold using the three different cost flow assumptions: FIFO, LIFO, and Weighted Average is shown below:-
Cost of goods sold = (200 × $18) + (800 × $20) + (1,040 × (2,040-200-800)
= (200 × $18) + (800 × $20) + (1,040 × $24)
= $3,600 + $16,000 + $24,960
= $44,560
Ending Inventory Under FIFO = (1,200 - 1,040) × (2,040-200-800)
= 160 × $24
= $3,840
Under LIFO method
Cost of goods sold is
= (1,200 × $24) + (800 × $20) + (40 × $18)
= $28,800 + $16,000 + $720
= $45,520
Ending Inventory Under LIFO is
= (200 - 40) × $18
= 160 × $18
= $2,880
Weighted Average cost flow Assumption
Weighted Average cost per apple = Cost of Beginning inventory and purchase ÷ Total apple available
Cost of Beginning inventory and purchases is
= (200 × $18) + (800 × $20) + (1,200 × $24)
= $3,600 + $16,000 + $28,800
= $48,400
Total apples available is
= 200 + 800 + 1,200
= 2,200
Weighted Average cost per apple is
= $48,400 ÷ 2,200
= $22
Cost of goods sold is
= 2,040 × $22
= $44,880
Ending Inventory is
= 160 × $22
= $3,520
b. The Preparation of income statement, a balance sheet, and a statement of cash flows under each of the three cost flow assumptions is prepared below:-
Income Statement Amount
Sales (2,040 × $40) $81,600
Less: Cost of goods sold ($44,560)
Gross Profit $37,040
Less: Operating Expenses ($26,000)
Income before income taxes $11,040
Less: Income tax (30% × $11,280) ($3,312)
Net Income $7,728
Balance Sheet
Assets
Cash $9,488
Inventory $3,840
Total Assets $13,328
Liabilities and Stockholder's Equity
Common Stock $2,500
Retained Earnings $10,828
Total Liabilities and Equity $13,328
Working note
cash = (opening + Sales - Purchases - Operating expenses - Income tax expenses )
= $2,000 + $81,600 - $44,800 - $26,000 - $3,312
= $9,488
Retained earning = (Opening + Net Income)
= $3,100 + $7,728
= $10,828
Statement of Cash Flow
Cash Flow from Operating Activities
Cash Sales $81,600
Payment to Accounts Payable ($44,800)
Operating Expenses ($26,000)
Income tax paid ($3,312)
Net Increase in cash and
cash equivalents $7,488
Add: Opening Cash and
cash equivalents $2,000
Closing Cash and cash equivalents $9,488
LIFO cost flow Assumption
Income Statement
Sales (2,040 × $40) $81,600
Less: Cost of goods sold ($45,520)
Gross Profit $36,080
Less: Operating Expenses ($26,000)
Income before income taxes $10,080
Less: Income tax (30% × $10,080) ($3,024)
Net Income $7,056
Balance Sheet
Assets
Cash $9,776
Inventory $2,880
Total Assets $12,656
Liabilities and Stockholder's Equity
Common Stock $2,500
Retained Earnings $10,156
Total Liabilities and Equity $12,656
Working note:-
Cash = (opening + Sales - Purchases payment - Operating expenses -Income tax expenses)
= $2,000 + $81,600 - $44,800 - $26,000 - $3,024
= $9,776
Retained earning = (Opening + Net Income)
= $3,100 + $7,056
= $10,156
Statement of Cash Flows
Cash Flow from Operating Activities
Cash Sales $81,600
Payment to Accounts Payable ($44,800)
Operating Expenses ($26,000)
Income tax paid ($3,024)
Net Increase in cash and
cash equivalents $7,776
Add: Opening Cash and
cash equivalents $2,000
Closing Cash and cash equivalents $9,776
Weighted Average cost flow Assumption
Income Statement
Sales (2,040 × $40) $81,600
Less: Cost of goods sold ($44,880)
Gross Profit $36,720
Less: Operating Expenses ($26,000)
Income before income taxes $10,720
Less: Income tax (30% × $10,720) ($3,216)
Net Income $7,504
Balance Sheet
Assets
Cash $9,584
Inventory $3,520
Total Assets $13,104
Liabilities and Stockholder's Equity
Common Stock $2,500
Retained Earnings $10,604
Total Liabilities and Equity $13,104
Working note
Cash = opening + Sales - Purchases payment - Operating expenses - Income tax expenses )
= $2,000 + $81,600 - $44,800 - $26,000 - $3,126
= $9,584
Retained earning = (Opening + Net Income)
= $3,100 + $7,504
= $10,604
Statement of Cash Flows
Cash Flow from Operating Activities
Cash Sales $81,600
Payment to Accounts Payable ($44,800)
Operating Expenses ($26,000)
Income tax paid ($3,216)
Net Increase in cash and
cash equivalents $7,584
Add: Opening Cash and
cash equivalents $2,000
Closing Cash and
cash equivalents $9,584