Explore BrainMass

Cash Budgeting

Sales Budget

Please see the attached file. 04. The budget director of Flory's Kitchen Shop has prepared the following sales budget. The company had $100,000 of accounts receivable at January 1. The company normally collects 100 percent of its accounts receivable in the month following the sale. Required: (a) Complete the schedule

Preparing a Master Budget for Cello Company

Prepare a Master Budget, on Excel, as described in the attachment. The CELLO Company wants a Master Budget for the next three months beginning January 1, 2009. It desired an ending minimum cash balance of $4000 each month. Sales are forecasted at average selling prices of $4 per unit. Inventories are supposed to equal 125%

Finance problems: inventory, AR credit policies, cash budgets, Lockbox

See attachment. I need help with problems 26.7,26.14,27.8 and 28.10. 26.7 Indicate whether the following company actions increase, decrease, or cause no change to the cash cycle and the operating cycle. a. The use of discounts offered by suppliers is decreased. b. More finished goods are being produced for orders in

Financial Statements

Please see the attached file. Results of operation for the 4th quarter 07: Sale of product 400,000 Less variable cost of goods sold 225,000 Contribution margin 175,000 Less fixed production costs 65,000 Less fixed selling & admin exp. 27,000 92,000 Income before taxes 83,000 Less taxes on incom

Capes Corporation: Cash flow budget and Merchandise purchase budget

Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: - Sales are budgeted at $390,000 for November, $360,000 for December, and $340,000 for January. - Collections are expected to be 85% in the month of sale, 10% in the month following the sale, and 5% uncollectible. - Th

Prepare a Cash Budget for J Car & Sons Company

How do I prepare a cash budget? Also, I'd like to demonstrate if the company meets their minimum cash requirement of $10,000. ------- J. Car & Sons Company has gathered the following information: April 30 ending cash balance $25,000 Dividends paid in May $12,000 Cash expenditures in May for operating expens

Finance: Cash Budgeting for West Valley Mem Hospital

Cash Budgeting?Hospital The management of West Valley Memorial Hospital needs to prepare a cash budget for July 2006. The following information is available: a. The cash balance on July 1, 2006, is $236,000. b. Actual services performed during May and June and projected services for July are: May June July Cash services (b

Preparing the Master Budget for Colombo Industries

Please see the attached file. Columbo Industries Limited manufactures a single model trench coat sold throughout Canada. Projected Sales in units for the first five months of the 2004/05 financial year are as follows... July 35,000 August 20,000 September 15,000 October 8,000 November 6,000 The following informatio

Budget Improvement

I need, in your opinion, 9-11 or so ways that the budgeting processes in a manufacturing or merchandising company (any company really) can be improved either by direct material purchases, direct labor, manufacturing overhead, and operating expenses (more so on the operating expenses side). I am not looking for a "how-to" bud

Cash Budgeting

How does the timing of cash receipts and disbursements affect cash budgeting? Is it possible for an organization to be profitable and run out of cash? How?

Cash Budget - April, May, June

Credit Sales April May June 160,000 140,000 192,000 Credit Purchases 68,000 64,000 80,000 Cash Disbursements 8,000 7,000 8,400 Interest 3,000 3,000

Cash Budgeting - Requesting a Line of Credit

Helen is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2003 and 2004: May 2003 $180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2004 180,000

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?

Midwest Distributing Company - Merchandising Transactions

See the attached file. Midwest Distributing Company completed these merchandising transactions in the month of April. At the beginning of April, the ledger of Midwest showed Cash of $9,000 and Common Stock of $9,000. April. 2 Purchased merchandise on account from Kane Supply Co. $6,300, terms 2/10, n/30. 4 Sold merchandi

Units Purchased & Income Statement

Master budget, Adams Company, a merchandising firm that sells one product, estimates it will sell 12,000 units of its product at $60 per unit in December. The company has prepared other information to prepare a budget for December, as shown here: Merchandise inventory, December 1 2,000 units Desired merchandise inv

Cash Budgeting Manufacturing Company

Hare Manufacturing Company makes wax for automobiles. As part of overall planning, a cash budget is prepared quarterly each year. You have been asked to assist in preparing the cash budget for the fourth quarter of the company's fiscal year. The following information is available: a. Sales Third Quarter (actual).......

VitaPup produces a vitamin-enhanced dog food that is sold in Kansas.

I really need help solving these practice exercises, please let me know if you can help. Exercise #1 VitaPup produces a vitamin-enhanced dog food that is sold in Kansas. The company expects sales to be 12,600 bags in January, 14,500 bags in February, 19,000 bags in March, and 21,500 bags in April. There are 1,260 bags on h

Riordan Manufacturing: Planning and Budgeting

Research Riordan Manufacturing and prepare a 1,050-1,400-word paper addressing the following topics: 1) Explain the importance of strategic planning in maximizing shareholder wealth. 2) Using the Economic Forecast on the Finance and Accounting intranet, demonstrate how forecasting has been used in the budgeting process for

West Valley Memorial Hospital

The management of West Valley Memorial Hospital needs to prepare a cash budget for July 2006. The following information is available: a. The cash balance on July 1st is $236,000. b. Actual services performed during May and June and projected services for July are: Cash services (bills paid by individuals): May: $110,0

Budgeted Sales and Purchases

Please help me with the following: Bell Company reports sales on credit and pays operating costs in the month incurred. Amounts for 2007 are: March April May June July BUDGET.SALES $300,000 $290,000 $320,000 $280,000 $210,000 BUDGET.PURCH. 144,000 $120,000 $128,000

Prepare Cash Budget - Ace Traders

Good Day, Please assist with the attached question. Regards The following information pertains to Ace Traders for the three months ended 31 May 2007. Actual March Budgeted April May R R R Sales (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash and 90% on credit) 240 000 280 00

Cash Budget Problem

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

Accounting - cash budgets and variances

See attached file for full problem description. Markus Corporation's sales of gizmos are 25% for cash and 75% on credit. Past collection history indicates that credit sales are collected as follows: 30% in the month of sale 60% in the month following sale 10% in the second month followin

Budgeted Income Statement

P9-6A Kurian Industries' balance sheet at December 31, 2005, is presented below. Additional information accumulated for the budgeting process is as follows. Budgeted data for the year 2006 include the following. Prepare purchases and income statement budgets for a merchandiser. (SO 6) KURIAN INDUSTRIES Balance Sheet Dec

Cash Budget

The Carlquist Company makes and sells a product called Product K. Each unit of Product K sells for $24 and has a unit variable cost of $18. The company has budgeted the following data for November: Sales of $1,152,000, all in cash A cash balance on November 1 of $48,000 Cash disbursements (other than interest) during No

Cash Budgets for Randall Company

Randall Company is a merchandising company that sells a single product. The company's inventories, production, and sales in units for the next three months have forecasted as follows: October November December Beginning Inventory 10,000 10,000 10,000 Merchandise Purchases 60,000 70,000 35,000 Sales 60,000 70,000 40,000