- A company is preparing its selling and administrative budget. It has determined that its variable selling cost is 10% of sales revenue and its variable administrative cost is $3 per unit sold. Fixed selling costs are $50,000 per month and fixed administrative costs are $80,000 per month. The company plans to sell 20,000 units in June at a price of $25 per unit. What is the total budgeted selling expense for June?
Answer: $100,000
The question asks specifically for selling expenses only, so administrative costs must be excluded.
1. Calculate total sales revenue: 20,000 units × $25/unit = $500,000
2. Calculate variable selling costs: 10% × $500,000 = $50,000
3. Identify fixed selling costs: $50,000 per month
4. Total budgeted selling expense: $50,000 (variable) + $50,000 (fixed) = $100,000
Distractor A ($110,000) incorrectly mixes fixed selling costs with variable administrative costs. Distractor B ($140,000) represents total administrative expenses only. Distractor D ($240,000) represents total S&A expenses for the month.
- A company's S&A expense budget includes depreciation of $10,000 per month, fixed cash expenses of $40,000 per month, and variable cash expenses equal to 15% of sales. For the second quarter, total budgeted S&A expense is $285,000. What are the budgeted sales for the second quarter?
Answer: $900,000
This problem requires working backwards from the total budgeted expense to find the underlying sales revenue.
1. Calculate total fixed expenses for the quarter:
- Depreciation: 3 months × $10,000 = $30,000
- Fixed cash expenses: 3 months × $40,000 = $120,000
- Total fixed expenses = $150,000
2. Calculate total variable expenses:
- Total budgeted S&A = Total fixed + Total variable
- $285,000 = $150,000 + Total variable expenses
- Total variable expenses = $135,000
3. Solve for sales revenue:
- Variable expenses = 15% of sales
- $135,000 = 0.15 × Sales
- Sales = $135,000 ÷ 0.15 = $900,000
- What is the total selling and administrative expense that should appear in a flexible budget for May?
Answer: $258,000
A flexible budget adjusts the original static budget for the actual level of activity. It recalculates variable costs while keeping fixed costs the same.
1. Determine the Variable Cost Component from the Static Budget:
- Total Budgeted S&A = Fixed S&A + Variable S&A
- $250,000 = $90,000 + Variable S&A \implies Total Variable S&A = $160,000.
2. Calculate the Per-Unit Variable Cost:
- Variable Cost per Unit = Total Variable S&A / Budgeted Units = $160,000 / 40,000 units = $4.00 per unit.
3. Calculate the Flexible Budget for the Actual Activity Level:
- Flexible Budget Variable Costs = Actual Units \times Variable Cost per Unit = 42,000 units \times $4.00/unit = $168,000.
- Flexible Budget Fixed Costs = $90,000 (Fixed costs do not change with activity within the relevant range).
- Total Flexible Budget = $168,000 + $90,000 = $258,000.
- What is the total amount of insurance and property tax expense that should be included in the administrative budget for the month of June?
Answer: $8,000
The question asks for the budgeted expense for June, which requires accruing these costs evenly over the year, regardless of the cash payment dates.
1. Monthly Insurance Expense: The annual premium is $36,000. The monthly expense is the annual amount divided by 12.
- Monthly Insurance Expense = $36,000 / 12 months = $3,000 per month.
2. Monthly Property Tax Expense: The annual tax is $60,000. The monthly expense is the annual amount divided by 12.
- Monthly Property Tax Expense = $60,000 / 12 months = $5,000 per month.
3. Total Budgeted Expense for June: Sum the monthly accrued expenses.
- Total Expense for June = $3,000 (Insurance) + $5,000 (Property Tax) = $8,000.
Distractor A ($0) represents the cash outflow in June, which is incorrect as the question asks for expense. Distractor C ($30,000) is the semi-annual cash payment for property taxes, which occurs in May, not June, and is a cash flow, not a monthly expense. Distractor D ($38,000) is the sum of the monthly insurance expense ($3,000) and the semi-annual tax payment ($30,000), confusing accrual and cash concepts.
- What is the total budgeted advertising expense for the next quarter?
Answer: $250,000
The total advertising budget consists of a fixed fee and a variable cost based on projected clicks, which in turn is based on projected sales.
1. Calculate the Number of Clicks per Unit Sold:
- The ratio is 500 clicks per 100 units, which simplifies to 5 clicks per unit sold.
2. Calculate Total Budgeted Clicks:
- Total Clicks = Budgeted Sales (units) \times Clicks per Unit = 20,000 units \times 5 clicks/unit = 100,000 clicks.
3. Calculate the Variable Advertising Cost:
- Variable Cost = Total Clicks \times Cost per Click = 100,000 clicks \times $2.00/click = $200,000.
4. Calculate Total Budgeted Advertising Expense:
- Total Expense = Fixed Fee + Variable Cost = $50,000 + $200,000 = $250,000.
- The administrative department of a company budgets its office supply costs using a flexible budget formula of $1,500 per month plus $5 per purchase order. In July, the static budget planned for 400 purchase orders. The actual results for July showed office supply costs of $3,550 with 420 purchase orders processed. What is the spending variance for office supplies in July?
Answer: $50 Favorable
The spending variance compares actual costs to the flexible budget amount for the actual level of activity.
1. Calculate the flexible budget for actual activity:
- Flexible budget = $1,500 + ($5 × 420 purchase orders)
- Flexible budget = $1,500 + $2,100 = $3,600
2. Calculate the spending variance:
- Spending variance = Actual cost - Flexible budget cost
- Spending variance = $3,550 - $3,600 = -$50
3. Interpret the variance:
- Since actual cost is less than budgeted cost, the variance is $50 Favorable
- What is the total budgeted selling and administrative expense for the quarter based on the revised sales forecast?
Answer: $364,000
To create a flexible budget for the revised sales volume, we need to calculate the per-unit variable costs and apply them to the new volume while keeping fixed costs unchanged.
1. Calculate per-unit variable costs from original budget:
- Sales commission rate = $60,000 ÷ 30,000 units = $2.00 per unit
- Shipping cost rate = $45,000 ÷ 30,000 units = $1.50 per unit
- Total variable cost rate = $2.00 + $1.50 = $3.50 per unit
2. Calculate variable costs for revised volume:
- Total variable costs = 34,000 units × $3.50 = $119,000
3. Identify fixed costs (unchanged at any volume):
- Total fixed costs = $150,000 + $75,000 + $20,000 = $245,000
4. Calculate total revised S&A budget:
- Total budget = $119,000 + $245,000 = $364,000
Distractor A ($350,000) represents the original static budget. Distractor B ($358,000) incorrectly flexes only one variable cost component. Distractor C ($397,000) incorrectly treats advertising as variable.
- What is the total selling and administrative expense in U.S. dollars that should be recorded in the master budget?
Answer: $143,000
The master budget should be prepared using the company's budgeted exchange rate for translating revenues and expenses. The forward contract rate is used for hedging cash flows and affects the cash budget and realized gains/losses, but not the initial expense budget itself.
1. Calculate Total S&A Expense in Euros (€):
- Fixed Costs = €80,000
- Variable Costs = 10% of €500,000 = €50,000
- Total S&A Expense = €80,000 + €50,000 = €130,000.
2. Translate Total S&A Expense to U.S. Dollars ($):
- Use the budgeted exchange rate of $1.10/€.
- Total S&A Expense in USD = €130,000 \times $1.10/€ = $143,000.
Distractor B ($145,600) incorrectly uses the forward contract rate of $1.12/€ for budgeting the expense. Distractor C ($130,000) correctly calculates the expense in euros but fails to translate it to U.S. dollars. Distractor D ($550,000) incorrectly translates the sales figure instead of the expense figure.
- If Meridian's actual sales for 2024 turn out to be $2,640,000 (10% higher than budgeted), what should the total selling and administrative expenses be in a flexible budget for performance evaluation purposes?
Answer: $364,200
For flexible budgeting, variable costs adjust with actual sales while fixed costs remain constant. Variable selling expenses: Commission (3%) + Shipping (1.5%) = 4.5% × $2,640,000 = $118,800. Variable administrative expenses: 0.8% × $2,640,000 = $21,120. Fixed administrative expenses: $180,000 + $45,000 = $225,000. Total S&A expenses = $118,800 + $21,120 + $225,000 = $364,200. Choice B incorrectly applies the 10% increase to all expenses. Choice C uses budgeted sales instead of actual. Choice D omits variable administrative costs.
- Peterson Manufacturing is preparing quarterly selling and administrative budgets. Sales commissions are paid at 4% of sales in the month of sale, but advertising expenses are paid two months after the expense is incurred. Budgeted sales are: January $500,000, February $600,000, March $700,000, April $800,000. Advertising expenses are budgeted at 2% of sales each month. If other S&A expenses total $25,000 per month, what are the total cash disbursements for S&A expenses budgeted for March?
Answer: $63,000
March cash disbursements include: (1) March sales commissions paid in March: 4% × $700,000 = $28,000, (2) January advertising paid in March (2-month delay): 2% × $500,000 = $10,000, (3) Other S&A expenses: $25,000. Total = $28,000 + $10,000 + $25,000 = $63,000. Choice B incorrectly includes February advertising. Choice C includes March advertising paid immediately. Choice D omits the January advertising payment.
- What are the total budgeted cash disbursements for selling and administrative expenses for July?
Answer: $119,000
To find the total cash disbursements for S&A in July, we must sum all cash payments made during that month, considering payment timing and excluding non-cash expenses.
1. Sales Commissions: Paid in July are for June sales. Disbursement = 4% of June sales = 0.04×$600,000=$24,000.
2. Administrative Salaries: Paid in July = $80,000.
3. Advertising: Paid in July = $15,000.
4. Depreciation: This is a non-cash expense and is excluded from the cash disbursement budget.
5. Property Taxes: The semi-annual payments are made on June 30 and December 31. There is no cash payment for property taxes in July.
Total Cash Disbursements for July = $24,000 (Commissions) + $80,000 (Salaries) + $15,000 (Advertising) = $119,000. - Phoenix Manufacturing uses activity-based budgeting for its S&A expenses. Customer service costs are driven by the number of customer orders processed, while shipping administration costs are driven by the number of shipments. The company budgets customer service at $15 per order and shipping administration at $8 per shipment. Budgeted activity for Q2 includes 1,800 customer orders resulting in 2,700 shipments (some orders require multiple shipments). Fixed S&A costs are $95,000 for the quarter. If actual Q2 results show 1,950 orders and 2,925 shipments, what is the flexible budget variance for total S&A expenses if actual expenses were $150,900?
Answer: $3,250 unfavorable
Flexible budget based on actual activity: Customer service: $15 × 1,950 = $29,250. Shipping administration: $8 × 2,925 = $23,400. Fixed costs: $95,000. Total flexible budget = $147,650. Flexible budget variance = Actual $150,900 - Flexible budget $147,650 = $3,250 unfavorable. Choice A uses budgeted rather than actual activity levels. Choice B incorrectly treats the variance as favorable. Choice D confuses the variance with the change in order volume.
- Using the high-low method, what is the budgeted total S&A cost for a month with planned sales of 12,500 units?
Answer: $170,000
The high-low method is used to determine the fixed and variable components of a mixed cost. Once the cost formula is derived, it can be used to budget costs for any activity level.
1. Calculate the Variable Cost per Unit (V):
- V=(Cost at High Point−Cost at Low Point)/(Activity at High Point−Activity at Low Point)
- V=($182,000−$150,000)/(14,000−10,000) = $32,000 / 4,000\text{ units} = $8.00\text{ per unit}.
2. Calculate the Total Fixed Cost (F): Substitute the variable rate into the cost equation for either the high or low point. Using the low point:
- Total Cost = F + (V × Activity)
- $150,000 = F + ($8.00 \times 10,000\text{ units})
- $150,000 = F + $80,000 \implies F = $70,000.
3. Budget for the Planned Sales Level: Use the derived cost formula (Y = $70,000 + $8.00X) for 12,500 units.
- Budgeted Cost = $70,000 + ($8.00 \times 12,500\text{ units}) = $70,000 + $100,000 = $170,000. - A company's static budget for S&A expenses was $120,000 for a sales volume of 15,000 units. The actual S&A expenses were $125,000 for a volume of 16,000 units. A flexible budget analysis reveals a $1,800 unfavorable spending variance. What are the fixed costs in the S&A budget?
Answer: $72,000
This problem requires working backwards from the variance information to determine the cost structure.
1. Calculate the flexible budget amount:
- Spending Variance = Actual Cost - Flexible Budget Cost
- $1,800 U = $125,000 - Flexible Budget Cost
- Flexible Budget Cost = $125,000 - $1,800 = $123,200
2. Set up equations (where F = fixed costs, V = variable cost per unit):
- Static budget: F + (V × 15,000) = $120,000
- Flexible budget: F + (V × 16,000) = $123,200
3. Solve for variable cost per unit:
- Subtracting the first equation from the second: 1,000V = $3,200
- V = $3.20 per unit
4. Solve for fixed costs:
- F + (15,000 × $3.20) = $120,000
- F + $48,000 = $120,000
- F = $72,000
- Sterling Corporation's S&A budget includes expenses that vary with both sales volume and the number of customer transactions. Sales commissions are 4% of sales revenue, while transaction processing fees are $2.50 per transaction. The company budgets 2,400 transactions generating $960,000 in sales for the quarter. Fixed administrative costs are $75,000 quarterly. During budget revision, management decides to target the same sales revenue but with 20% fewer transactions (representing larger average transaction sizes). What is the change in total quarterly S&A expenses under the revised budget?
Answer: Decrease of $1,200
Original budget: Commissions 4% × $960,000 = $38,400. Transaction fees $2.50 × 2,400 = $6,000. Fixed costs $75,000. Total = $119,400. Revised budget: Commissions remain $38,400 (same sales). New transactions: 2,400 × 0.8 = 1,920. Transaction fees $2.50 × 1,920 = $4,800. Fixed costs $75,000. New total = $118,200. Decrease = $119,400 - $118,200 = $1,200. Choice B calculates the reduction in transaction fees only. Choice C assumes no impact since sales revenue is unchanged. Choice D incorrectly applies the 20% reduction to total variable costs.
- What is the selling and administrative expense variance for March to be reported on a flexible budget performance report?
Answer: $500 Unfavorable
A flexible budget performance report compares actual results to what the budget would have been for the actual level of activity. The variance is the difference between the actual cost and the flexible budget cost.
1. Calculate the Flexible Budget for S&A: Use the cost formula with the actual number of units sold (21,000).
- Flexible Budget S&A = $45,000 + ($2.50 \times 21,000 units) = $45,000 + $52,500 = $97,500.
2. Calculate the Variance: Compare the actual S&A expense to the flexible budget amount.
- Variance = Actual Expense - Flexible Budget Expense = $98,000 - $97,500 = $500.
3. Determine if Favorable or Unfavorable: Since the actual expense ($98,000) is higher than what it should have been for that activity level ($97,500), the variance is Unfavorable.
Therefore, the variance is $500 Unfavorable.
- What is the total budgeted administrative expense for the period?
Answer: $105,825
This problem is complex because the bonus is an administrative expense that is based on operating income, which itself is reduced by the bonus. This requires an algebraic solution.
Let B = Bonus and OI = Operating Income.
1. Set up the equations:
- B=0.03×OI
- OI = \text{Sales} - \text{COGS} - \text{All S&A Expenses}
- OI=$1,200,000−$700,000−$120,000−$80,000−$100,000−B
2. Calculate Operating Income before the bonus:
- OI before bonus = $1,200,000 - $700,000 - $120,000 - $80,000 - $100,000 = $200,000.
3. Solve for the Bonus (B):
- OI=$200,000−B
- Substitute this into the bonus formula: B=0.03×($200,000−B)
- B=$6,000−0.03B
- 1.03B=$6,000
- B=$6,000/1.03≈$5,825.24 (rounded to $5,825).
4. Calculate Total Budgeted Administrative Expense:
- Total Admin Expense = Fixed Admin (excluding bonus) + Bonus
- Total Admin Expense = $100,000 + $5,825 = $105,825. - Based on this information, what is the total budgeted administrative expense for the quarter?
Answer: $240,200
The question specifically asks for the total budgeted administrative expense, so selling expenses must be identified and excluded.
1. Identify and Calculate Quarterly Administrative Expenses:
- Administrative Salaries: $55,000/month \times 3 months = $165,000.
- Office Rent: $18,000/month \times 3 months = $54,000.
- Bad Debt Expense: First, find credit sales: $900,000 \times 80% = $720,000. Then calculate the expense: 1% \times $720,000 = $7,200.
- Office Supplies: $0.50/transaction \times 10,000 transactions = $5,000.
2. Sum the Administrative Expenses:
- Total = $165,000 + $54,000 + $7,200 + $5,000 = $231,200.
Distractor Analysis: Choice B incorrectly includes selling expenses. Choice C includes only fixed administrative costs (salaries and rent). Choice D includes only administrative salaries.
- What are the total budgeted cash disbursements for S&A expenses for the third quarter?
Answer: $277,500
Cash disbursements include only actual cash payments made during the third quarter, excluding non-cash items like depreciation.
1. Salaries (paid monthly): 3 months × $50,000 = $150,000
2. Commissions (paid one month in arrears):
- July payment (for June sales): 5% × $400,000 = $20,000
- August payment (for July sales): 5% × $450,000 = $22,500
- September payment (for August sales): 5% × $500,000 = $25,000
- Total commission payments = $67,500
3. Advertising: Single payment of $60,000 in August
4. Depreciation: $12,000 (non-cash, excluded from cash disbursements)
5. Total cash disbursements: $150,000 + $67,500 + $60,000 = $277,500
Distractor A includes commissions on July-September sales instead of June-August. Distractor C omits the advertising payment. Distractor D incorrectly includes depreciation as a cash expense.
- If the new marketing strategy is implemented, what would be the new total budgeted S&A expense?
Answer: $982,000
This is a multi-step problem. First, determine the variable S&A rate. Second, calculate the new sales level and new fixed costs. Finally, compute the new total S&A budget.
1. Find the Variable S&A Rate:
- Total S&A = Fixed S&A + Variable S&A
- $860,000 = $380,000 + Variable S&A \implies Variable S&A = $480,000.
- Variable Rate = Total Variable S&A / Total Sales = $480,000 / $4,000,000 = 12% of sales.
2. Determine New Sales and Fixed Costs:
- New Sales = $4,000,000 \times 1.15 = $4,600,000.
- New Fixed S&A = $380,000 + $50,000 = $430,000.
3. Calculate New Total S&A Expense:
- New Total S&A = New Fixed S&A + (Variable Rate × New Sales)
- New Total S&A = $430,000 + (0.12 \times $4,600,000) = $430,000 + $552,000 = $982,000.
