Purchase Solution

Cash budget

Not what you're looking for?

Ask Custom Question

Imagine it is July 2009 and you are a budget analyst for your company that makes seasonal items. Create a cash budget for the months July through December using the sales estimates and other information about the company given below.

Sales forecast
Month Sales (in thousands)
May 200
June 200
July 400
August 500
September 600
October 600
November 500
December 300
January 200

The company offers a 5% discount if they pay at the time of the sale. About 20% take advantage of this. Meaning for every $100 of merchandise sold, the company collects $19 in the sale month, representing 20% of the sales being sold at a 5% discount or at 95% of the full price ($100 * .2 * .95 = $19).

50% of each month's sales are collected one month after the sale, 30% are collected two months after the sale.

Raw materials are 60% of the sales. Materials are ordered two months in advance and paid in the following month. Example: materials for July are ordered in May and paid for in June.

Manufacturing labor is 20% of the sales and wages are paid for in the month of the sales. Example: Labor in July will be 20% of the July sales (.2 * $400 = 80) and is paid in July.

Managerial salaries are $30 per month.

Rent and lease payments total $15 per month.

Tax payments of $25 will be made in September and December.

The company will spend $100 for a new machine in August.

The beginning cash balance in July is $120 and the minimum cash balance the company needs is $50.

A. Month May Jun Jul Aug Sep Oct Nov Dec Jan
Sales (thousands $) 200 200 400 500 600 600 500 300 200
Cash receipts:
30-day
60-day
Total receipts

Materials
Labor
Salaries (30 in Jul, 30 in Aug already filled in)
Rent/Lease (15 in Jul, 15 in Aug already filled in)
Taxes
New Machine (100 in Aug already filled in)
Total expenditures

Change in cash
Beginning cash (120 in Jul already filled in)
End cash without Loan
Loan
End cash with loan

Loan repayment
Cumulative loan

Cash surplus

B. What will the A/R balance be at the end of 2009?

C. Assume everything occurs exactly as the cash budget predicts and the company gets the loans forecast on the cash budget. Given the minimum cash balance of $50, will the company be assured that there will never be a cash shortfall at anytime during the forecast of July through December? Explain.

D. Why does this profitable company borrow money for a few months each year?

Purchase this Solution
Solution Summary

The solution explains how to prepare a cash budget. Sales forecasts for estimates and other information are determined.

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • What information is needed in order to prepare a cash budget?

    171897 Cash Budgets and Operating Budgets What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

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

    The cash budget is somewhat based upon the operating budget, as sales are used to calculate what is expected in terms of the cash receipts budget. As you will find out, cash is king.

  • Budgeting

    8276 Cash budgeting: production budget, purchasing budget, sales budget and cash budget See attachment for a cash budgeting question. Please see the attached file.

  • Operating budget and cash budgets

    235866 Operating budget and a cash budget What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

  • Cash Budget

    Why is it important to create a cash budget? Please see the attachment The solution explains how to create a cash budget and explains the importance of cash budget

  • The Purpose of the Cash Budget

    Cash budget sales budget, purchase budget, production budget etc. The cash budget is a summary of the firm's expected cash inflows and Outflows over a particular period of time.

  • Budgets for Healthcare Organization

    The expense budget lists all operating expenses that are expected to be incurred during the budget period, both fixed and variable. 3) Cash budget The cash budget represents the organization's cash inflows and outflows.

  • What are the steps to creating a cash budget?

    This is usually the last budget that the company prepares. To prepare a cash budget, the first number used to start the budget is the beginning cash balance.

  • 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

    251803 Solving a cash budget problem Is there concerns with the cash budget and the company with this budget attachment. Is there concerns with the cash budget and the company with this budget attachment Let us understand about budget.

View More Related Solutions