Explore BrainMass

Cash Budgeting


PLEASE SHOW CALCULATIONS 1. A firm expects to sale 25,000 units of its product at $11 per unit. Pretax income is predicted to be $60,000. If the variable costs per unit are $6, total fixed costs must be: 2. Management anticipates fixed costs of $72,500 and variable costs equal to 40% of sales. What will pretax income equ

Standard cost, cash collections, key to entire operating budget.

13. A standard cost or production standard that assumes maximum operating conditions and 100% efficiency at all times is called a(n): a. ideal standard. b. past experience standard. c. attainable standard. d. average standard. 14. A key to estimating an accurate amount of cash to be collected from sales is: a. the ac

Cash Budget and Cost Variance Analysis

Please see the attached file for better format. Problem 5: Preparation of a Cash Budget The sales budget of Mulls Company for the fourth quarter of 20X6 is as follows: October November December Sales $91,000 $76,000 $108,000 Sales are 20% cash, 80% credit

Cash Budget: The Hale Company

Cash Budget The Hale Company is currently working on its cash budget for the coming year. The following information is available: Projected sales for the coming year: Month Projected Sales January $850,000 February 750,000 March 730,000 April

Capital Budgeting - finance

Complete each tab, based on the spreadsheet problems. Chapter 1 Spreadsheet Exercise Assume that Monsanto Corporation is considering the renovation and/or replacement of some of its older and outdated carpet-manufacturing equipment. Its objective is to improve the

After Tax Cash Flows - Capital Budgeting Problem for Kiddie Toys Company

Please help with Part 2/Page 3 Kiddie Toys Company Problem. After Tax Cash Flows The Kiddie Toys Company must decide whether to manufacture a new product line -- Breakdance Doll. The company has already spent $460,000 (which was totally tax deductible) to design the product and test the market. If the company decides to g

PROBLEM 10-3. Master Budget

Techlabs operates a computer training center.The following data relate to the preparation of a master budget for January 2012. 1. At the end of 2011, the company's general ledger indicated the following balances: Debits Credits Cash $ 50,000 Accounts Payable $ 40,000 Accounts receivable 40,000 Note payable 60,000 Equipmen

Capital Budgeting - Estimating Cash Flow

Every company has capital projects. - Verizon wireless is building a data center in Niagara County NY. The initial investment breaks down like this: - Land and utilities, $60 million. - Estimated building cost, $500 million. - Phase 1 equipment, 2011-13, $640 million. - Phase 2 equipment, 2014-15, $800 million. -

Building a Cash Budget

Orion Corporation is preparing a cash budget for the six months beginning January 1. Shown below are the company's expected collection pattern and the budgeted sales for the period. Expected collection pattern: 65% collected in the month of sale 20% collected in the month after sale 10% collected in the second month afte

Monthly Cash Budget

The treasurer of Unisyms Company has accumulated the following budget information for the first two months of the coming year: March April Sales. $450,000 $520,000 Manufacturing costs 290,000 350,000 Selling and administrative expenses 41,400 46,400 Capital additions 250,000 --- The company expects to sell about

Capital Budgeting BrainMass Expert Explains

Degnan Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine. The following information is given. Existing Machine Proposed Machine Cost $100,000 Cost $150,000 Purchased 2 yrs

'MBA Level Accounting Questions

1. Answer both independent parts. a. Dagwood Company manufactures three products (A,B,C). During the coming period, Dagwood expects to have 7,500 direct labor hours and 5,500 machine hours available. Given the following data, determine how much of each product Dagwood should produce (assume that Dagwood maintains no invento

Develop a master budget in excel - Harrison Company

PROJECT ONE HARRISON COMPANY BUDGET INSTRUCTIONS Below you will find the data for Project One. You will be completing budgets and schedules for the firm's first quarter of operations in the year 20XY. Do all schedules and budgets showing the three months of January-March and a Total column, except for the balance sheet

Preparing a budgeted income statement and balance sheet

Beginning cash balance of July 1 is $63,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,700,000: June (actual), $1,200,000; and July (budgeted),

Budgeting; managerial accounting, practice exam problem

Use the following information to solve for a, b, and c. Coles Company, Inc. makes and sells a single product, Product R. Three yards of Material K are needed to make one unit of Product R. Budgeted production of Product R for the next five months is as follows: Augustâ?¦â?¦â?¦â?¦â?¦. 14,000 units Septemberâ?¦â

Prepare schedule of budgeted cash receipts for Hospital Highline Hospital

A (only one part) Cash Budgeting for a Hospital Highline Hospital provides a wide range of health services in its community. Highline's board of directors has authorized the following capital expenditures: Intra-aortic balloon pump $1,400,000 Computed tomographic scanner 850,000 X-ray equipment 5

Financial Plan for Juan's Taco Company

Juan's Taco Company has restaurants in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker, will finance construction if Juan can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales

Preparing Sales, Production, and Fabric Purchases Budgets

53. Curiosity Corner sells books and various other reading-related products. One of the store's most popular reading-related products is a book pillow for hard cover and soft cover books. The pillows each sell for $8.00. Originally the pillows were handmade by a local artisan. The store's owner has been impressed with the demand

Budgets: Gulf Corporation

Hello, I need help filling out a budget for class. I have attached an Excel file with the fields needing to be filled out. Thank you. See *ATTACHED* file for complete details! ----------- Spreadsheet Format Each sheet of your workbook should include your name, course and section number, and the date. You will have t

Prepare a Cash Distribution Budget

Pete's Pasta (which sells meat & veggie pastas) needs a cash budget for year 3 and has given the following info. Sales are all on account & are estimated to be collected over a 3-month period, with 70% collected in the month of sale, 25% collected in the next month, and 4% collected in the third month. The remaining 1% is esti

Expected cash balance

MacKenzie Ltd. expects the following transactions and events to take place in the upcoming Year 3: Sales projected for Year 3 $2,400,000 (10% of all sales are cash sales, 60% of the remaining sales are collected in the following year and the remainder in the 3rd year) Total

Prepare a cash budget forecast for January and February.

I have to prepare a cash budget for a company. Here are the details: The store's beginning balance is 10,300 in cash. Management forecast that collections from credit customers will be $11,400 in January and $14,800 in February. The store is scheduled to receive $5,000 cash on a business note payable in January. Project

Budgeting in a Nutshell; An Ethical Dilemma

See attached file. CASE 23.1 Budgeting in a Nutshell The purpose of this problem is to demonstrate some of the interrelationships in the budgeting process. Shown below is a very simple balance sheet at January 1, along with a simple budgeted income statement for the month. (Assume dollar amounts are stated in thousands; yo

Accounting F-12

*Please describe how to calculate!!!! Tappet Corporation is preparing its master budget fo the quarter ending March 31. It sells a single product for $25 a unit. Budgeted sales are 40% cash and 60% on credit. All credit sales are collected in the month following the sales. Budgeted sales for the next four months follow:

Budgets : key information

*Please describe how to calculate. ABC company started business on January 1, 2010. The company estimated that sales for the first six months would be as attaches: *Please look at the attachment The Company sells all items on account and expects collections of accounts receivable to be as follows: 60% in the month of th

Master Budget -Cash Sales and Credit Sales Examined

*Please look at the attachment *Please describe how to solve the answers. Near the end of 2009, the management of Pak Corp., a merchandising company, prepared the following estimated balance sheet for Dec 31, 2009. To prepare a master budget for January, February, and March of 2010, management gathers the following info

Working capital management involves the relationship between a firms short term assets and short-term liabilities. The goal of working capital management is to ensure that a firm is able to continue its operations and that it has sufficient ability to satisfy both maturing short-term debt and upcoming operational expenses. The management of working capital involves managing inventories, accounts receivables and payables, and cash. Working capital management policies are implemented to assure the safety of organizational assets, provide required liquidity for operations, obtain the best banking relationships, and attain reasonable return on all funds. Aggressive capital management results in capital being minimize in current assets versus long-term investment. This has the expectation of higher profitability but greater liquidity risks. As an alternative, a more conservative policy places a greater proportion of capital in liquid assets, but at the sacrifice of some profitability. To measure the degree of aggressiveness the current asset to total asset ratio is used with a lower ration, meaning a relatively more aggressive policy must be integrated in an effort to prepare for adequate financial planning procedures (Weinraub, et al, 1998). Cash budgeting involves planning for the inflows of cash into the business so there is cash available to meet operational expenditures. Proper cash management allows for smooth, uninterrupted operations of the business. Poor cash management can result in costly business operations and delays. Therefore, making projections of cash flow in and out of the business should be constructed and monitored on a regular basis.

Working capital management involves the relationship between a firms short term assets and short-term liabilities. The goal of working capital management is to ensure that a firm is able to continue its operations and that it has sufficient ability to satisfy both maturing short-term debt and upcoming operational expenses. The