Purchase Solution

Cash Budget Problem

Not what you're looking for?

Ask Custom Question

Complete the following --use the attached spreadsheet template and fill in the blanks (send back as a reply to this note in this, the main newsgroup:

CASH BUDGETING PROBLEM

Norman Larson, a recent graduate of University of Phoenix with huge potential, has accepted a position as an entry level accountant with Builders R Us Manufacturing Company. The president of the company, U. R. Wright , has requested Norman to provide him with a cash flow for the period of April 30 to June 30, which happens to be the end of the current fiscal year. The following information is available:

All sales are credit sales, with 20% of sales collected in the month of sales, 60% collected in the month following sales, 15% collected in the second month following the sale, and the remaining 5% written off as bad debt losses in the sixth month following the sale. Raw materials purchased each month are 75% of the next month?s sales. Payment for raw materials is made during the month after the purchase. Norman is required to maintain a minimum balance of $5,000 in the checking account, and the balance on April 1st is $6,000. Rent, insurance, and other expenses are $1,000 per month.

Sales and wage data are as follows:

ACTUAL

Sales
Wages

February
$ 30,000
$ 3,000

March
$ 30,000
$ 3,000

ESTIMATED

Sales
Wages

April
$ 30,000
$ 3,000

May
$ 40,000
$ 4,000

June
$ 50,000
$ 5,000

July
$ 60,000
$ 6,000

August
$ 50,000
$ 5,000

September
$ 40,000
$ 4,000

Prepare the cash budget for the period April 30 through June 30. For any month during which a cash shortage is indicated, assume that the Friendly Online National Bank will make funds available. Use the budget worksheet provided to solve the problem.

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Budget Discussion Questions for Mama's Needlework

    Cash Budget: Why doesn't the Net Cash from Operations of $93 match the Annual Budget $105? One reason is that our budget components were only for Product B. What is the other reason? Cash Budget: Why did they borrow $50 in the first quarter?

  • Cash Budget

    Explain how the minimum cash balance requirement in part b of the problem affects the monthly cash budgets prepared in part a of the problem. 4.

  • Cash Budgeting.

    249916 Filing Out Values in a Proforma Cash Budget Problem 2 The director of budget of the store Flory' s Kitchen has prepared the following budget of sales. The business has balance of $100.000 in accounts receivable to January 1.

  • Cash Budget

    209089 Finance problem cash budget 23. Cash Budget. The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay.

  • Cash Budget for Pine Mulch Company

    195763 Cash Budget for Pine Mulch Company The attached problem describes the financials for Pine Mulch Company at the end of the first quarter, with sales ending in March.

  • Schedule of budgeted operating cash

    For understanding purposes, please format in three sections in excel: a) Cash collection schedule b) Purchases and payment budget c) Monthly cash budget Please put the problem in excel format.

  • Monthly cash flow budget for Pepperton

    Does it appear from your results that the treasurer should be concerned about investing excess cash or looking for a bank loan? The treasurer has a big problem beginning in February, according to the attached cash flow budget.

  • Description of Accounting: Cash budget

    Prepare a cash inflow budget for December, January, and February. Problem: Prepare a cash inflow budget for December, January, and February. Solution: The solution is presented in a Word document. Thank you. FINANCE 29.

  • Description of a cash budget & its useful to an organization

    For example, a typical problem may advise you to compute a cash receipts budget while estimating that 75% of the sales are collected in the month that they are sold, 20% of the sales are collected in the month following, and 5% of sales are never collected

  • Schedule of Expected Cash Collections and Cash Budget

    PROBLEM 9-14 Schedule of Expected Cash Collections; Cash Budget [L02, LOS] Jodi Horton, president of the retailer Crestline Products, has just approached the company's bank with a request for a $30,000, 90-day loan.

View More Related Solutions