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
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
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
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
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
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
Develop a budget plan for diet chocolate candy bars. Be sure to include all revenue sources and expenses associated with this specific product.
"Being significantly under budget is as bad as being over budget, we need to come in exactly as planned." Explain the phrase.
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
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
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.
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
SIMID SPORTS COMPANY Estimated Balance Sheet December 31, 2011 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 18,000 Accounts receivable . . . . . . . . . . . . . . . . . 262,500 Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . 75,000 Total current assets . . . . . . . . . . .
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
1. Projected Sales is a budgeting technique to help companies project the budget for a future term. What happens if this figure is significantly wrong? How does a company determine if this figure is accurate? What other budgets depend on the accuracy of this number? Why? 2. What is the difference between a flexible and static
Complete master budget plus supporting schedules Managerial Accounting 14e Garrison See template and problem data attached
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
Data for Herron Corporation are shown below: Per Unit Percent of Sales Selling price $ 75 100% Variable expenses 45 60% Contribution margin $ 30 40% Fixed expenses are $75,000 per month and the company is selling 3,000 units per month. 6. Required:
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
2008 Carroll Clinic Operating Budget: I. Volume (number of visits) Payer A 9000 Payer B 12,000 Total 21,000 II. Reimbursement (per visit) Pa
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
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
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
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
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
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
Explain the relationships between fixed and variable costs used in a flexible budget and the differences between static and flexible budgets? Explain how a flexible budget lends itself to a cost-volume-profit analysis?
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