Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help solving Problem #6 in this attachment. I am struggling to solve and not sure where to start. Problem #6 QUESTIONS - Answer

I need help solving Problem #6 in this attachment. I am struggling to solve and not sure where to start.

image text in transcribedimage text in transcribedimage text in transcribed
Problem #6 QUESTIONS - Answer the Following Questions Using the Information that follows. 6) Compute the Following: A) Ending Cash Balance 1. January 2. February B) Total Cash Receipts 1. January 2. February C) Total Cash Disbursements 1. January 2. February D) Net Cash Flow 1. January 2. February E) Net Income 1. January 2. February F) Compute the Difference between Budgeted Net Income and Net Cash Flow 1. January 2. February G) List 3 Reasons Why there is a Difference between the Budgeted Net Income and Net Cash Flow for this Business. *Show All WORK and Calculations used to Compute your Answers and amounts.Problem #6 INFORMATION - Use the Following information to Answer the Questions Above. The Business had the Following Budgeted Information for the 1st 2 Months of the Year.(Jan+Feb) 1. Costs Include: a. Direct materials= $55 per unit, Direct Labor=$75 per unit, Selling Costs are $20 per unit b. Factory Rent = $44,000 per month, Salaries=$33,000 per month c. Utility Costs =$22,000 per month, Depreciation Expenses =$11,000 per month d. Selling, General and Administrative Costs = $10,000 for the month. e. The Business Plans to Purchase Equipment In January that will Cost =$55,000 f. 50% of All Variable costs are paid in the month Incurred, 50% are paid in the month after. g. All Fixed Costs are paid for in the Current Month. 2. Sales Information; a. Sales Price is $200 per UNIT. b. 80% of All Sales are on Credit and 20% are Cash c. 30% of All Credit Sales will be collected during the current month and 70% will be collected in the month after the Sale. 3. Sales Projections: a. December = 1,500 Units to be Sold b. January= 2,500 Units c. February = 3,500 Units 4. Production Projections: a. December = 2,000 Units b. January= 3,000 Units c. February = 1,000 Units 5. Cash Balances: a. The Expected Cash Balanced at December 31/January 1st is expected to be $44,000 b. This Business Requires a $30,000 Minimum Balance at ALL Times. 6. Bank Borrowings and LINE of Credit: a. Our Business Can Borrow Cash and Repay Cash from the Line of Credit Monthly. b. Borrowings and Repayments must be made in a $1,000 increments c. Borrowings Must be made at the Beg of the Month, therefore we will have to pay any Interest Cost in those Months where we Borrow. d. Repayments Must be made at the End of Month, therefore we will have to Pay Interest Costs in those Months where we make a repayment of the Loan. e. Repayments of the Loan Principal Balance are made Only when we Estimate an Excess of Cash is Available f. Interest payments will be made at the END of every month based on the Outstanding Principal amounts using an Annual Interest Rate of 12% g. Interest MUST be Paid Every Month on the Outstanding Principal Balance regardless of when the principal is repaid. 8Show the Following Details in Your Computations Reports 1. CASH BUDGET SUMMARY (See Example in Chapter 9 ) a. Set up 5 Columns, as Follows; i. 1-Descriptions / 2-JAN Calcs / 3-JAN Amounts / 4-FEB Calcs / 5-FEB Amount, b. Set up 10 Rows One for Each of the Following: 1. Beg Balance 2. + Total Cash Receipts (Cash Inflows) show Details in separate Cash Receipts Report = Cash Available - Total Cash Disbursements (Cash Outflows) - show Details in separate Cash Report 6. = Excess or (Deficiency) of Cash Available Financing Section 7. + Borrowings 8. - Finance Repayments - Interest Payments 10 =End Cash Balance 2. Cash Receipts Details a. ROWS, Set up 6 Rows Down the Left side as Follows; 1. Dec Credit 2. Jan Cash 3. Jan Credit 4. Feb Cash 5. 6. Feb Credit Total Cash Receipts b. COLUMNS, Set up 5 Columns across the Top as Follows; 1-Descriptions / 2-Jan Calcs / 3-Jan Inflows / 4-Feb Cales / 5-Feb Inflows 3. Cash Disbursements Details a. ROWS, Set up 12 Rows Down the Left similar to the Cash Receipts Section Above. 1. DM Dec DM Jan 3. DM Feb DL Dec DL Jan 6. DL Feb 7. Selling DEC 8. Selling JAN 9. Selling FEB 10. Fixed Costs 11. Other Cash Disbursements or Outflows 12. Total Cash Disbursement Line b. COLUMNS, Set up 5 Columns across the Top as Follows I. 1-Descriptions / 2-Jan Calcs / 3-Jan Outflows / 4-Feb Cales / 5-Feb Outflows 4. Cash Flow - Compute Net Cash Flows For Each Month a. ROWS, Set Up 3 Rows as Follows 1. Cash Receipts . Less (Cash Disbursements) 3. = NET CASH FLOW b. COLUMNS, Set up 3 Columns across the Top as Follows; 1. Description / Jan Cash Flow Feb Cash Flow 5. Net Income - Compute Net Income using the Variable Costing (CVP) Method a. ROWS, Set Up 5 Rows Along the Left Side as Follows; 1. Sales Revenues - Variable Costs = Contribution Margin - Fixed Costs = NET INCOME b. COLUMNS, Set up 3 Columns across the Top as Follows; 1. Descriptions / Jan Net Income / Feb Net Income * SHOW All Calculations as Needed & Reference to them

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

Financial Accounting

Authors: Jeffrey Waybright, Robert Kemp

1st Edition

013606048X, 9780136060482

More Books

Students also viewed these Accounting questions