Explore BrainMass


Flexible Budget Performance Report

Flexible Budget Performance Report AirQual Test Corporation provides on-site air quality testing services. The company has provided the following data concerning its operations: Fixed component Variable component Actual

Preparation of master budget

FC manufactures two types of cardboard boxes used in shipping canned food, fruit and vegatables. The canned food box - type C and the perishable box - type P have the following material and labor requirements: Box C Box P Direct material req

Master Budget with Supporting Schedules 2 schedules incomplete

The cash budget is composed of four major sections: 1. The receipts section. 2. The disbursements section 3. The cash excess or deficiency section. 4. The financing section. The receipts section lists all of the cash inflows, except from financing, expected during the budget period. Generally, the major source of receipts i

Direct materials purchases budget by month for the first quarter.

See the attached file for proper format. E20-5 Moreno Industries has adopted the following production budget for the first 4 months of 2011. Month Units Month Units January 10,000 March 5,000 February 8,000 April 4,000 Each unit requires 3 pounds of raw materials costing $2 per pound. On Decembe

Zeller Electronics: Projected sales budget for two quarters

See attached file for proper format. Zeller Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators sell for $12 and $25, respectively. Because of the intense competition Zeller faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2010 are a

Budget terminology appropriate definitions

Need help matching the 20 Budget terms with definitions. 1. Match the following terms with the appropriate definition. Magna Carta Mercantilism Thomas Jefferson's famous phrase Public administration Budgeting and Accounting Act of 1921 Full Employment Act of 1946 Annual budget Comprehensive Budget De

Nascar Company: Prepare a production budget for transmissions

Nascar Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending inventory for the first quarter will be 37,500 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 225,000 units; third quarter, 262,500 units; and fourth

Prepare a merchandise purchases budget for the first quarter.

See attached file for proper format. 3. This window shows what is correct and incorrect for the work you have completed so far. Even if all of the work you have done so far is correct, you may not have completed everything. Westile Company buys plain ceramic tiles and prints different designs on them for souvenir and gift

Budgeting and analysis

A company makes a product out of metal. They use two pounds of metal that costs them $20 per pound. They pay their employees $25 an hour and it takes an average of 1.3 hours for them to make the final product. They expect to sell 8,000 units. They also expect to incur $40,000 in fixed costs. Prepare the mastic static budget.

Preparing a Flexible Budget Report

Hannon Company expects to produce 1,200,000 units of Product XX in 2010. Monthly production is expected to range from 80,000 to 120,000 units. Budgeted variable manufacturing costs per unit are: direct materials $4, direct labor $6, and overhead $8. Budgeted fixed manufacturing costs per unit for depreciation are $2 and for supe

Prepare a master budget for January, February, and March

SIMID SPORTS COMPANY Estimated Balance Sheet December 31, 2011 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 18,000 Accounts receivable . . . . . . . . . . . . . . . . . 262,500 Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . 75,000 Total current assets . . . . . . . . . . .

SSpending Variance for Dunkin Medical Clinic flexible budget

Dunklin Medical Clinic measures its activity in terms of patient-visits. Last month, the budgeted level of activity was 1,620 patient-visits and the actual level of activity was 1,540 patient-visits. The cost formula for administrative expenses is $3.20 per patient-visit plus $14,300 per month. The actual administrative expense

Jung Corporation direct materials budget for third quarter

The Jung Corporation's budget calls for the following production:Quarter 1 45,000 units Quarter 2 38,000 units Quarter 3 34,000 units Quarter 4 48,000 units. Each unit of production requires three pounds of direct material. The company's policy is to begin each quarter with an inventory of direct materials equal to 30 percent o

How to budget and plan for mixed costs; fixed costs per unit; costs vs expenses

1. True to their name, mixed costs have components of both fixed and variable costs. They have a fixed based cost regardless of your activity level and they have a piece that varies based on your level of production. An example would be an x-ray machine. There is a fixed cost piece for the depreciation and technician salary. The

Designing a Personal Budget Spreadsheet in Excel

1. Create and format a row to show the months for the year (Jan-Dec). 2. Create and format a row, beneath the month row, to show yearly income for each month (Jan-Dec),and properly label the row and value. 3. Add each expense in a separate row (as identified in step 4) and properly label each row and value. 4. For the expense

Computer estimated cost savings based on budget

Heartland Company's budgeted sales and budgeted cost of goods sold for the coming year are $144,000,000 and $99,000,000 respectively. Short-term interest rates are expected to average 10%. If Heartland can increase inventory turnover from its present level of 9 times a year to a level of 12 times per year, compute its expected c

Preparation of Production budget for the Pletcher Company

See attachment: AE9-4 Pletcher Company produces and sells automobile batteries, the heavy-duty HD-240. The 2011 sales budget is as follows. Quarter HD-240 1 4,600 2 6,900 3 7,590 4 10,780 The January 1, 2011, inventory of HD-240 is 2,510 units. Management desires an ending inventory each quarter equa


Using the attached data and format from the budget tab create a flex-budget for the month of July using 3 or 4 different planned units of sales. Base your assumptions on several different factors: * The trends in actual sales shown at the bottom of the Budget tab * The activity levels needed to turn a profit since the June

Flexible budget analysis vs strategic-budget analysis

Why might managers find a flexible budget analysis more informative than a strategic-budget analysis? Explain your rationale. How might a manager gain insight into the causes of a flexible-budget variance for direct materials? Why might an analyst examining variances in the production area look beyond the business functi

MS Excel - Start up costs and six month projection

My made up business is "Now Hair This" beauty salon MS Excel - Create a Start up Budget and first 6 months operating expenses for your new Business using MS Excel. The Excel spreadsheet must include at a minimum the specifications listed below: a. Create two worksheets. The first worksheet should contain your expected expens

You are a School Social Worker at a High School in Atlanta, Georgia with an annual budget of $500 for programming expenses. You are notified by the Assistant Principal that a transgender student who is transitioning from male-to-female will be entering the junior class at the beginning of the following semester. She also has a sister that will be entering the sophomore class. The Assistant Principal assigned you with the task of organizing a response to ease the students' transition to their new school and into the student community. To your knowledge, this is the first time that a transgender student will be attending the High School and there have not been other experiences within the school district. The school is culturally diverse with various active religious clubs, including a Bible Study group and a Pride Alliance, that meet at lunchtime and afterschool. There is also an active Alumni organization that supports additional school programming with private funds. Questions: 1. What additional information would you need before implementing an intervention plan? 2. With whom would you consult and why? Who would seek to work with? 3. You have $200 of your budget left for this school year. Briefly discuss two possible approaches in addressing this challenge: (a) one approach should address the structural challenges in the high school setting, and (b) the other approach should address the students and the high school community.

You are a School Social Worker at a High School in Atlanta, Georgia with an annual budget of $500 for programming expenses. You are notified by the Assistant Principal that a transgender student who is transitioning from male-to-female will be entering the junior class at the beginning of the following semester. She also has a

Activity-Based Budget for Merit Industries; Banana Computer master budget

See attached files. Activity-Based Budget Merrit Industries Inc. has the following budget information available for February: Administration $40,000 Advertising $15,000 Assembly 1/2 hour per unit X $8 Direct materials 2 pounds per unit X $3 Inspection $200 per batch of 1,000 units Manufacturing overhead $2 per

Budget variance including flexible budget

Tylon's Hardware uses a flexible budget to develop planning information for its warehouse operations. For 20X9, the company anticipated that it would have 96,000 sales units for 664 customer shipments. Average storage bin usage for various inventories was estimated to be 200 per day. The costs and cost drivers were determined to