Flexed Budgets: Difference between revisions
No edit summary |
No edit summary |
||
| Line 88: | Line 88: | ||
==Reconciliation of Variances== | ==Reconciliation of Variances== | ||
{| class="wikitable sortable" border="1" cellpadding="5" cellspacing="0" align="center" | |||
|+ '''Flexed Budget''' | |||
|- | |||
| | |||
|Budgeted Profit | |||
|20,000 | |||
| | |||
|- | |||
|Less Sales Volume Variance | |||
|(4,000) | |||
|Difference between Flexed and Actual Sales | |||
|- | |||
|Plus Sales Price Variance | |||
|2,000 | |||
|- | |||
|Less Material Usage Variance | |||
|1,000 | |||
| | |||
|- | |||
|Plus Material Price Variance | |||
|100 | |||
| | |||
|- | |||
|Plus Labor Efficiency Variance | |||
|800 | |||
| | |||
|- | |||
|Less Labor Price Variance | |||
|(300) | |||
| | |||
|- | |||
|Less Fixed Overheads | |||
|700 | |||
| | |||
|- | |||
Actual Profit | |||
|16,00 | |||
| | |||
|} | |||
Budgeted Profit.........................................20,000 | Budgeted Profit.........................................20,000 | ||
Revision as of 12:37, 17 December 2012
Evaluate the budget based upon the actual not the budgeted volume. Thereby determining if the division met its labour, material and overheads budget
| Original | Flexed | Actual | |
| Output | 1000 | 900 | 900 |
| Sales | $100,000 | $90,000 | $92,000 |
| Raw Material | $(40,000) | $(36,000)36k m | $(36,900) 37k m |
| Labor | $(20,000) | $(18,000) 2,250hr | $(17,500) 2,150hr |
| Contribution | $40,000.4/unit | $36,000.4/unit | $37,600 |
| Fixed Overhead | $(20,000) | $(20,000) | $(20,700) |
| Operating Profit | $20,000 | $16,000 | $16,900 |
Remember to Flex only those items that vary with output
Budgeted Profit + Favourable variances - Adverse variances = Actual Profit
Sales Variances
Sales Volume variance = Difference between Original and Flexed Budget Profit or contribution e.g. 20k-16k =4k adverse (Don't Flex the Budget for Fixed Overheads)
For all other variances the Original Budget is ignored
Sales Price Variance = Difference between Actual Revenue and Flexed Revenue 92k - 90k = 2k favourable. Higher prices were obtained
Material Variances
Total Material Variance = Difference between Actual Cost and Flexed Cost, 36.9k-36 = .9 adverse. This is made up of
- Material Usage Variance = Diff between the Actual qty * Std Price and Flex qty budgeted * Budgeted Price = 37km*1-36km*1 = $1k Adverse
or (SP-AP)*qty
- Material Price Variance = Diff between the Actual Qty * Act Price and material Cost budgeted (actual qty * Budgeted cost) 36.9k - 37k*1 = .1 favour
or (SQ-AQ)*SP
Labor Vaiances
Total Material Variance Actual labour cost - Flexed labour cost 17.5k - 18k = $0.5k favourable
Labor Efficiency Variance Diff between Actual lab hrs * std lab cost/hr and Flex lab hrs * std lab cost/hr = 2150*8 (18k/2250) = 17.2-18k =.8k For (SR-AR)*AH
Labor Price Variance Diff between Act lab hrs * actual lab cost and Act hrs * std lab cost = 17,5k - (2150*8) = 0.3 adverse or (SH-AH)*SR
Fixed Overhead Variance
Total Overhead Var is Act oh - Flexed o/h = 20.7k - 20K = 0.7k adverse
If there had been Variable Overheads
O/H efficiency rate Then Actual hrs * Standard Rate - Standard Hours * Standard Rates
O/H expenditure variance Actual hours * Actual rate - Actual hours * Standard Rate
Reconciliation of Variances
Actual Profit| Budgeted Profit | 20,000 | ||
| Less Sales Volume Variance | (4,000) | Difference between Flexed and Actual Sales | |
| Plus Sales Price Variance | 2,000 | ||
| Less Material Usage Variance | 1,000 | ||
| Plus Material Price Variance | 100 | ||
| Plus Labor Efficiency Variance | 800 | ||
| Less Labor Price Variance | (300) | ||
| Less Fixed Overheads | 700 | ||
| 16,00 |
Budgeted Profit.........................................20,000
-SVV.........................................................(4000) (diff between Flexed and actual sales)
+ SP Variance............................................2,000
- MUV.......................................................(1,000)
+MPV...........................................................100
+LEV............................................................800
-LPV............................................................(300)
-FOV...........................................................(700)
Actual Profit..............................................16,900
Actual Units sold Market* Actual Market Share(this is what the actually sold) - Actual Units * Expected Share(This is what they should have sold given their mkt share - Expected units sold * Expected share(THIS IS NOT THE FLEXED #) X Contribution 92000*10%*4=37600 diff 90000*10%*4=36000
= Market Share Variance...................................................Market Size Variance
Things to think about
- Is it significant - what is the trigger for investigation
- Investigate Favorable and Adverse variances
- Use management by exception - spend managing the problems
- Are they normal fluctuations - are you looking over a long enough time period
- Do something about it when you find them
- Is the standard unattainable - basic, ideal and attainable see Standard Costs