Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Additional? information: Direct? labor, manufacturing? overhead, selling and adm

ID: 2465827 • Letter: A

Question

Additional? information:

Direct? labor, manufacturing? overhead, selling and administrative? costs, and income tax expense are paid in the quarter incurred.

a. Please prepare Haney Company's budgeted income statement for the first quarter of 2017.

Haney Company

Budgeted Income Statement

For the Quarter Ended March 31, 2017

Sales Revenue ?

Cost of Goods Sold ?

Gross Profit ?

Selling and Administrative Expenses ?

Income before Income Taxes ?

Income Tax Expense ?

Net Income ?

b. Please, prepare Haney ?Company's budgeted statement of cash flows for the first quarter of 2017.

Haney Batting Company

Budgeted Statement of Cash Flows

For the Quarter Ended March 31, 2017

Operating Activities:

Cash receipts from customers ?

Cash payments for operating expenses (?)

Cash payments for income taxes (?)

Net cash provided by (used for) operating activities ?

Investing Activities:

Cash payments for equipment purchases (?)

Net cash used for investing activities (?)

Financing Activities:

Net cash provided by (used for) financing activities 0

Net increase (decrease) in cash ?

Cash balance, January 1, 2017 ?

Cash balance, March 31, 2017 ?

c. Please prepare Haney Company's budgeted balance sheet as of March 31?,2017.

Direct materials purchases are paid 50?%in the quarter purchased and 50?% in the next quarter.

Direct? labor, manufacturing? overhead, selling and administrative? costs, and income tax expense are paid in the quarter incurred.

Data Table Haney Company Post-Closing Trial Balance December 31, 2016 Account Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Equipment Accumulated Depreciation Accounts Payable Common Stock Retained Earnings Totals Debit Credit 30,000 21,600 16,000 25,900 125,000 S 60,000 14,500 70,000 74,000 $ 218,500$ 218,500 Table Budgeted total sales, all on account Budgeted direct materials to be purchased and used Budgeted direct labor cost Budgeted manufacturing overhead costs $ 305,500 30,000 10,000 Variable manufacturing overhead Depreciation Insurance and property taxes 2,100 1,100 1,050 71,800 Budgeted cost of goods sold Budgeted selling and administrative expenses Salaries expense Rent expense Insurance expense Depreciation expense Supplies expense 13,000 3,500 1,100 300 12,220 264,000 42,000 40,000 Budgeted cash receipts from customers Budgeted income tax expense Budgeted purchase and payment for capital expenditures (additional equipment)

Explanation / Answer

Sales Revenue 305,500

Cost of Goods Sold 71800

Gross Profit 233,700

Selling and Administrative Expenses 30,120

Income before Income Taxes 203,580

Income Tax Expense 42000

Net Income 161,580

Cash Flow

From Operating Activities

Net income 161,580

Add: depreciation (1100 + 300) 1,400

Less: Inc in Debtors (305,500 - 264000) 41,500

Add: Inc in Creditors (50% of 30000) 15,000

Total Cash from operations 136,480

Cash from Investing

Capital Expenditure -40000

Total Cash from Investing (40000)

Net cash inflow 96480

ADD: Opening balance 30,000

closing balance 126,480

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote