In: Finance
Hanno had the following static budget for March, when it expected to sell 4,000 sandwiches:
Sales revenue | $ 48,000 |
Variable costs | $ 32,000 |
Fixed costs | $ 5,000 |
Net income | $11,000 |
Hanno actually sold 5,000 sandwiches during March at $12 each.
Variable costs were $38,000 and fixed costs were $4,800.
A. Prepare a flexible budget at for March that will help Hanno separate the volume variance from the flexible budget variance. Make your income statement match my format and compute net income.
B. What is the volume variance for variable costs?
C. What is the flexible budget variance for variable costs?
Description | 4000 Units | Per unit | ||||
Sales revenue | $48,000 | 12.00 | ||||
Variable costs | $32,000 | 8.00 | ||||
Fixed costs | $5,000 | 1.25 | ||||
Net income | $11,000 | 2.75 | ||||
Budgeted | Actual | |||||
Description | 5000 Units | Per unit | Per unit | |||
Sales revenue | $60,000 | 12.00 | $60,000 | 12.00 | ||
Variable costs | $40,000 | 8.00 | $38,000 | 7.60 | ||
Fixed costs | $5,000 | 1.00 | $4,800 | 0.96 | ||
Net income | $15,000 | 3.00 | $17,200 | 3.44 | ||
Material quanitity variance | = (Standard production - Actual production) * Budgered Price | |||||
= (5000 - 5000)*8 | ||||||
0 | ||||||
Flexible budget variance | = (Standard Quantity - Actual Quantity) * Budgered Price | |||||
= (4000 - 5000)*8 | ||||||
(8,000) | ||||||