- A company's static budget for the production of 5,000 units includes variable costs of $75,000 and fixed costs of $40,000. The company actually produced 5,500 units. What is the total budgeted cost that would be shown in a flexible budget prepared for performance evaluation?
Answer: $122,500
First, calculate the variable cost per unit from the static budget: $75,000 / 5,000 units = $15 per unit. Budgeted fixed costs remain $40,000 in total.
The flexible budget is then prepared for the actual production level of 5,500 units.
Budgeted Variable Costs = 5,500 units × $15/unit = $82,500.
Budgeted Fixed Costs = $40,000.
Total Flexible Budget = $82,500 + $40,000 = $122,500.
- A company is upgrading its production line. The change will increase monthly fixed costs by $30,000 but is expected to decrease variable manufacturing costs from $18 to $15 per unit. The previous fixed costs were $100,000 per month. What would the total manufacturing cost be in a flexible budget prepared with the new cost structure, for a production volume of 40,000 units?
Answer: $730,000
The flexible budget must be based on the new cost structure.
New Fixed Costs = $100,000 + $30,000 = $130,000.
New Variable Cost = $15 per unit.
Flexible Budget = New Fixed Costs + (New Variable Cost per unit × Activity Level).
Flexible Budget = $130,000 + ($15 per unit × 40,000 units) = $130,000 + $600,000 = $730,000.
- For the month of March, a company reported a total flexible budget variance for overhead of $8,000 unfavorable. Actual overhead costs for the month were $212,000. Budgeted fixed overhead is $60,000 per month. The company operated at an actual level of 20,000 machine hours. Based on this data, what is the budgeted variable overhead cost per machine hour?
Answer: $7.20
First, determine the flexible budget amount.
Flexible Budget Variance = Actual Cost - Flexible Budget Amount.
$8,000 U = $212,000 - Flexible Budget Amount.
Flexible Budget Amount = $212,000 - $8,000 = $204,000.
Second, use the flexible budget formula to find the variable rate.
Flexible Budget Amount = Fixed Costs + (Variable Rate × Activity).
$204,000 = $60,000 + (Variable Rate × 20,000 hours).
$144,000 = Variable Rate × 20,000 hours.
Variable Rate = $144,000 / 20,000 hours = $7.20 per hour.
- An IT consulting firm uses billable hours as its primary activity driver. The firm's monthly cost formula is $120,000 plus $25 per billable hour. The static budget for August was based on 8,000 billable hours. In August, the firm's consultants actually billed 7,500 hours. What is the total cost in the firm's flexible budget for August?
Answer: $307,500
A flexible budget is prepared based on the actual level of activity, which is 7,500 billable hours.
Flexible Budget = Fixed Costs + (Variable Rate × Actual Activity).
Flexible Budget = $120,000 + ($25 per hour × 7,500 hours) = $120,000 + $187,500 = $307,500.
- A company is producing a new device. Due to learning curve effects, the variable conversion cost is budgeted at $20 per unit for the first 10,000 units and $16 per unit for any additional units. Monthly fixed manufacturing costs are $150,000. What is the total manufacturing cost in the flexible budget for a month where 13,000 units are produced?
Answer: $398,000
The flexible budget must account for the change in the variable rate.
Cost for first 10,000 units = 10,000 units × $20/unit = $200,000.
Cost for next 3,000 units = 3,000 units × $16/unit = $48,000.
Total Variable Cost = $200,000 + $48,000 = $248,000.
Total Flexible Budget Cost = Total Variable Cost + Fixed Cost = $248,000 + $150,000 = $398,000.
- Northern Tech's flexible budget for its assembly department shows variable overhead costs of $9 per direct labor hour and fixed overhead costs of $120,000 per quarter. The department also has a mixed cost for equipment maintenance with a quarterly fixed component of $18,000 plus $3 per direct labor hour. If the department worked 22,000 direct labor hours in the current quarter, but the flexible budget variance analysis shows an unfavorable total overhead variance of $15,000, what were the actual total overhead costs incurred?
Answer: $417,000
The correct answer is B. First, calculate the flexible budget total overhead: Variable overhead = 22,000 × $9 = $198,000. Mixed maintenance cost = $18,000 + (22,000 × $3) = $84,000. Fixed overhead = $120,000. Flexible budget total = $198,000 + $84,000 + $120,000 = $402,000. Since there's an unfavorable variance of $15,000, actual costs exceeded budget by this amount. Actual costs = $402,000 + $15,000 = $417,000. Choice A shows only the budgeted amount. Choice C incorrectly subtracts the variance (favorable treatment). Choice D adds an incorrect variance amount.
- A company's budget includes manufacturing costs and selling costs. The manufacturing cost formula is $80,000 plus $10 per unit produced. The selling cost formula is $30,000 plus $2 per unit sold. The company planned to produce and sell 20,000 units. It actually produced 22,000 units and sold 21,000 units. What is the total cost in the flexible budget for both functions combined?
Answer: $372,000
A flexible budget uses the actual activity level for each respective function.
Flexible Budget (Manufacturing) = $80,000 + ($10/unit × 22,000 units produced) = $80,000 + $220,000 = $300,000.
Flexible Budget (Selling) = $30,000 + ($2/unit × 21,000 units sold) = $30,000 + $42,000 = $72,000.
Total Flexible Budget = $300,000 + $72,000 = $372,000.
- If Stellar Manufacturing operates at 9,500 machine hours during the quarter, what would be the total budgeted cost according to the flexible budget?
Answer: $666,000
The correct answer is A. Variable costs per machine hour: $15 + $25 + $8 = $48. At 9,500 machine hours: Variable costs = 9,500 × $48 = $456,000. Fixed costs = $180,000. Step-fixed supervision cost = $30,000 (since 9,500 < 10,000). Total = $456,000 + $180,000 + $30,000 = $666,000. Choice B incorrectly omits the step-fixed supervision cost. Choice C uses the higher supervision cost tier incorrectly. Choice D adds both supervision cost tiers.
- A manufacturing company's budget for overhead is based on the formula Y = $90,000+$4.50X, where Y is the total budgeted overhead cost and X is the number of direct labor hours. The static budget was prepared assuming 20,000 direct labor hours for the month. Actual activity resulted in 22,500 direct labor hours. What is the total overhead cost that should appear in the flexible budget for the month?
Answer: $191,250
A flexible budget adjusts for the actual level of activity. The formula is Total Cost = Fixed Costs + (Variable Rate × Actual Activity). Using the given formula: Total Cost = $90,000 + ($4.50 per hour × 22,500 hours) = $90,000 + $101,250 = $191,250.
- A company's manufacturing overhead includes variable costs of $3.00 per direct labor hour (DLH) and $1.50 per machine hour (MH). Budgeted fixed overhead is $75,000 per month. The static budget was based on 10,000 DLH and 15,000 MH. The actual activity for the month was 11,000 DLH and 14,000 MH. What is the total manufacturing overhead cost in the monthly flexible budget?
Answer: $129,000
The flexible budget calculates budgeted costs for the actual levels of each cost driver.
Budgeted variable cost from DLH = 11,000 DLH × $3.00/DLH = $33,000.
Budgeted variable cost from MH = 14,000 MH × $1.50/MH = $21,000.
Total flexible budget = ($33,000 + $21,000) + $75,000 Fixed Overhead = $129,000.
- A company's monthly budget includes $100,000 of committed fixed costs (e.g., long-term lease) and $40,000 of discretionary fixed costs (e.g., advertising campaign). The budgeted variable cost is $25 per unit. The static budget was based on a volume of 8,000 units. If the company actually produces 7,500 units, what is the total cost in the flexible budget?
Answer: $327,500
A flexible budget includes all budgeted fixed costs for the period, regardless of whether they are committed or discretionary. The budget is adjusted for variable costs based on the actual activity level.
Budgeted Variable Costs = 7,500 units × $25/unit = $187,500.
Total Budgeted Fixed Costs = $100,000 (committed) + $40,000 (discretionary) = $140,000.
Total Flexible Budget Cost = $187,500 + $140,000 = $327,500.
- A company's manufacturing overhead consists of indirect materials ($2.00/unit), indirect labor ($3.50/unit), and utilities ($0.50/unit). Total fixed manufacturing overhead is $88,000 per period. The company planned to produce 16,000 units but actually produced 18,000 units. What is the flexible budget for total manufacturing overhead for the period?
Answer: $196,000
First, sum the variable overhead rates: $2.00 + $3.50 + $0.50 = $6.00 per unit.
Next, calculate the total budgeted variable overhead for the actual activity level: 18,000 units × $6.00/unit = $108,000.
Finally, add the total budgeted fixed overhead: $108,000 (Variable) + $88,000 (Fixed) = $196,000.
- A company's static budget at 10,000 direct labor hours showed variable costs of $50,000 and fixed costs of $70,000. Actual results for the period were 11,000 direct labor hours and total costs of $128,000. To properly evaluate performance, management must first prepare a flexible budget. What is the total cost in the flexible budget for the period?
Answer: $125,000
First, determine the budgeted variable rate from the static budget: $50,000 / 10,000 hours = $5 per hour. Budgeted fixed costs are $70,000.
Next, calculate the flexible budget using the actual activity level of 11,000 hours.
Flexible Budget = ($5/hour × 11,000 hours) + $70,000 = $55,000 + $70,000 = $125,000.
- A company's factory supervision cost is a step-fixed cost. The cost is $45,000 per month for production up to 15,000 units. If production exceeds 15,000 units, an additional supervisor is hired, increasing the cost to $60,000 per month. The company's variable manufacturing cost is $12 per unit. The static budget was based on 14,000 units. If the company actually produces 16,000 units, what is the total manufacturing cost in the flexible budget?
Answer: $252,000
The flexible budget must use the cost structure relevant to the actual activity level. Since actual production is 16,000 units, the higher step-fixed cost applies.
Variable Costs = 16,000 units × $12/unit = $192,000.
Fixed Costs for this activity level = $60,000.
Total Flexible Budget Cost = $192,000 + $60,000 = $252,000.
- A company's flexible budget for direct materials is based on a standard quantity of 3 kilograms per unit and a standard price of $4.00 per kilogram. Budgeted fixed costs are $25,000 per month. During June, the actual price paid for the material increased unexpectedly to $4.25 per kilogram. The company produced 5,000 units in June. For performance evaluation purposes, what is the total amount for direct materials and fixed costs that should appear in the flexible budget?
Answer: $85,000
A flexible budget is prepared using budgeted or standard prices and rates, not actual ones. The effect of the price change is measured by the price variance.
Budgeted material cost = (5,000 units × 3 kg/unit) × $4.00/kg = 15,000 kg × $4.00/kg = $60,000.
Total flexible budget amount = Budgeted material cost + Budgeted fixed cost = $60,000 + $25,000 = $85,000.
- A company's utility costs are mixed. At the low activity level of 4,000 machine hours, utility costs were $9,000. At the high activity level of 7,000 machine hours, utility costs were $14,250. Using the high-low method, what is the flexible budget for utility costs at an activity level of 6,000 machine hours?
Answer: $12,500
First, use the high-low method to find the cost formula.
Variable Rate = ($14,250 - $9,000) / (7,000 - 4,000) = $5,250 / 3,000 MH = $1.75 per MH.
Fixed Cost = $9,000 - (4,000 MH × $1.75/MH) = $9,000 - $7,000 = $2,000.
Now, prepare the flexible budget for 6,000 machine hours.
Budgeted Cost = $2,000 + ($1.75/MH × 6,000 MH) = $2,000 + $10,500 = $12,500.
- A company produces two products, Gizmos and Widgets. Overhead is applied based on machine hours (MH). The flexible budget formula for monthly overhead is $200,000 + $8 per MH. Gizmos require 2 MH per unit, and Widgets require 4 MH per unit. Actual production for the month was 5,000 Gizmos and 3,000 Widgets. What is the flexible budget amount for total overhead?
Answer: $376,000
First, calculate the total actual machine hours, which is the activity driver.
MH for Gizmos = 5,000 units × 2 MH/unit = 10,000 MH.
MH for Widgets = 3,000 units × 4 MH/unit = 12,000 MH.
Total Actual MH = 10,000 + 12,000 = 22,000 MH.
Next, use the total MH in the flexible budget formula:
Flexible Budget = $200,000 + ($8/MH × 22,000 MH) = $200,000 + $176,000 = $376,000.
- In April, a company incurred total manufacturing costs of $250,000 to produce 10,000 units. In May, it incurred total manufacturing costs of $290,000 to produce 12,000 units. The company's cost structure is not expected to change. What would be the flexible budget for total manufacturing costs if the company plans to produce 11,500 units in June?
Answer: $280,000
First, determine the variable and fixed cost components.
Variable cost per unit = (Change in Cost) / (Change in Activity) = ($290,000 - $250,000) / (12,000 - 10,000) = $40,000 / 2,000 units = $20 per unit.
Fixed Cost = Total Cost - Variable Cost = $250,000 - (10,000 units × $20/unit) = $250,000 - $200,000 = $50,000.
Flexible budget for 11,500 units = $50,000 + ($20/unit × 11,500 units) = $50,000 + $230,000 = $280,000.
- A retailer's selling, general, and administrative (SG&A) expenses include sales commissions of 4% of sales revenue and fixed costs of $60,000 per month. The product's selling price is $25 per unit. The static budget was based on sales of 10,000 units. If the company actually sells 9,000 units, what is the total SG&A expense in the flexible budget?
Answer: $69,000
First, calculate the budgeted sales revenue at the actual activity level: 9,000 units × $25/unit = $225,000.
Next, calculate the budgeted variable costs (commissions): $225,000 × 4% = $9,000.
Finally, add the budgeted fixed costs: $9,000 (Variable) + $60,000 (Fixed) = $69,000.
- The flexible budget formula for a company's total monthly operating costs is $40,000 fixed plus $8.00 per unit produced. Total variable costs consist of direct materials, direct labor, and variable overhead. The direct material cost is $3.50 per unit and variable overhead is $1.50 per unit. What is the flexible budget amount for direct labor if 5,000 units are produced?
Answer: $15,000
First, determine the variable direct labor cost per unit.
Total variable cost per unit = $8.00.
Direct Labor cost per unit = Total VC/unit - Direct Material/unit - Variable Overhead/unit = $8.00 - $3.50 - $1.50 = $3.00 per unit.
Next, calculate the flexible budget for direct labor at the actual activity level.
Flexible budget for direct labor = 5,000 units × $3.00/unit = $15,000.
