Explore BrainMass

Cash Budgeting

Quarterly Cash Budget

Given the new details below to do the following: · Construct a quarterly cash budget for Lawrence · Tell me what is the largest amount of bank debt needed and when is it needed · Circle them in the on the borrowing line of the matrix · What is the largest amount of surplus cash flow generated by Lawrence and when doe

Cash Receipts & Cash Budget

2. The Merry Christmas Gift Shoppe has forecast its sales revenues and purchases for the last 5 months of 2008 to be as follows: Sales Purchases August $22,000 $17,000 September 15,000 19,500 October 25,000 29,000 November 30,000 20,000 December 26,000 24,000 60% of sales are on credit. On the basis of past experie

Meeks Company: compute cash collections, budgeted inventory, cash payments

See attached file All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for the following

Preparing a cash budget

Prepare a cash budget for Rotor Products, Inc. for the second quarter of 2006, based on the following. All are for cash: Total Sales March 2006 (actual) 425,000 April 2006 330,000 May, 2006 420,000 June, 2006 450,000 The company estimates its purchases

Cash budget problem

The following information is budgeted for Jana supply company for the next quarter: April May June Sales $110,000 $130,000 $180,000 Merchandise purchases $85,000 $92,000 $105,000 Selling and administrative

Activity based budgeting

Please see attached file. The Airhart Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $190,000 $78,000 $34,000 February

Sales Budget and Cash Collections Budget Schedule

Accounts receivable, May 31: (.3 x May sales of $450,000) = $135,000. Monthly forecasted sales: June, $400,000; July, $440,000; August, $500,000; September, $530,000. Sales consist of 70% cash and 30% credit. All credit accounts are collected in the month following the sales. Uncollected accounts are negligible and may be i

Master budget

Prepare a master budget for the following: Victoria kite Company, a small Melbourne firm that sells kites on the web wants a master budget for the next three months, beginning January 1, 2008. It desires an ending minimum cash budget of $ 5,000 each month. Sales are forecast at an average wholesale selling price of $ 8 per

Wilma Brown, treasurer of Columbia Civic Theater (CCT)

See attach word document and excel file. Wilma Brown, treasurer of Columbia Civic Theater (CCT), was preparing a loan request to the Northeast National Bank in December 2004. The loan was necessary to meet the cash needs of the theater for year 2005. In a few short years, the CCT had established itself as a premier theater. I

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. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $30 and total sales in January were $180

Cash Budget: The Total Budgeted Cash Disbursements

Question: Davis Corporation is preparing its Manufacturing Overhead Budget for the fourth quarter of the year. The budgeted variable factory overhead rate is $1.8 per direct labor-hour; the budgeted fixed factory overhead is $117,000 per month, of which $30,000 is factory depreciation. If the budgeted direct labor time for No

Determing the Budgeted Cash Disbursements for December

The Bandeiras Company, a merchandising firm, has budgeted its activity for December according to the following information: - Sales at $560,000, all for cash. - Merchandise inventory on November 30 was $303,000. - Budgeted depreciation for December is $38,000. - The cash balance at December 1 was $30,000. - Selling and ad

Cash disbursements for manufacturing overhead

Question 6: Cartier Inc. bases its manufacturing overhead budget on budgeted direct labor-hours. The variable overhead rate is $5.2 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $40,330 per month, which includes depreciation of $12,370. All other fixed manufacturing overhead costs represent cu

Cash Collections in April

Question 2: Pitkins Company collects 17% of a month's sales in the month of sale, 65% in the month following sale, and 14% in the second month following sale. The remainder is uncollectible. Budgeted sales for the next four months are: January February March April Budgeted sales $202,000 $303,000 $353,000 $2

Prepare a cash budget

State what additional assumptions and information that you would need to prepare a cash budget.

P7-2A Oneida Company: Preparation of cash budgets (for three periods)

Preparation of cash budgets (for three periods) See pdf attached Question 2: (10 points) Problem 7-2A: Preparation of cash budgets (for three periods) L.O. C3, P2 During the last week of August, Oneida Company's owner approaches the bank for an $100,000 loan to be made on September 2 and repaid on November 30 with annua

Prepare a master budgeting template for sales, production and cash flow

Budgeting Your task is to make a master budgeting template in a spreadsheet. Obtain the pre-formatted spreadsheet (master.xls). The information necessary for making the master budget is given in Part I of the spreadsheet. You need to enter formulas in Part II. Once you enter all required formulas, you can use this mas

Importance of Cash Budgets in the master budgeting process

What is the main reason for preparing a cash budget in the master budgeting process? What additional steps need to be taken for seasonal businesses to ensure an optimal outcome? What are the risks associated with inaccuracies in preparing the pro forma income statement and cash budget?

Preparing a Monthly Cash Budget for CBM

To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a Cash Budget for his latest venture- Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next nine months: March 2004: $250,000 April: 275,000

Define each of the budgets listed and briefly describe its uses

Directions: define each of the budgets listed and briefly describe its uses. 1.Sales budget 2.Production budget 3.Direct materials budget 4.Direct labor budget 5.Manufacturing overhead budget 6.Selling and administrative expense budget 7.Budgeted income statement 8.Cash budget

Prepare a Cash Budget for The Sharpe Corporation

4-6A. (Cash budget) The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $ 90,000 May $300,000 February 120,000 June 270,000 March 135,000 July 225,000 April 240,000 August 150,000 Of Sharpe's sales, 10 percent is for cash, another 60 percent is collected in the month foll

Garber Corporatioan: Sales and Production Budgets

Sales and Production Budgets The marketing department of Graber Corporation has submitted the following sales forecast for the upcoming fiscal year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales..................... 16,000 15,000 14,000 1

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