Flexed Budgets: Difference between revisions
No edit summary |
No edit summary |
||
| Line 22: | Line 22: | ||
|Raw Material | |Raw Material | ||
|(40,000) | |(40,000) | ||
|(36,000)36k | |(36,000)36k m | ||
|(36,900) 37k m | |(36,900) 37k m | ||
|- | |- | ||
| Line 46: | Line 46: | ||
|} | |} | ||
Remember to Flex only those items that vary with | Remember to Flex only those items that vary with output | ||
Budgeted Profit + Favourable variances - Adverse variances = Actual Profit | Budgeted Profit + Favourable variances - Adverse variances = Actual Profit | ||
==SALES VARIANCES== | ==SALES VARIANCES== | ||
Sales Volume variance = Difference between Original and Flexed Budget Profit or contribution e.g. 20k-16k =4k adverse ( | 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 | For all other variances the Original Budget is ignored | ||
| Line 60: | Line 60: | ||
Total Material Variance = Difference between Actual Cost and Flexed Cost, 36.9k-36 = .9 adverse. This is made up of | 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 | *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 | 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 | *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 | or (SQ-AQ)*SP | ||
| Line 70: | Line 70: | ||
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 | 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 | or (SH-AH)*SR | ||
| Line 80: | Line 79: | ||
Total Overhead Var is Act oh - Flexed o/h = 20.7k - 20K = 0.7k adverse | 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 * | Then Actual hrs * Standard Rate - Standard Hours * Standard Rates | ||
O/H expenditure | O/H expenditure variance | ||
Actual hours * Actual rate - Actual hours * | Actual hours * Actual rate - Actual hours * Standard Rate | ||
Reconciliation of Variances | ==Reconciliation of Variances== | ||
Budgeted Profit.........................................20,000 | Budgeted Profit.........................................20,000 | ||
| Line 102: | Line 101: | ||
Market Share and Market Size Variances ( | ==Market Share and Market Size Variances (Sales Volume Variance)== | ||
Actual Units sold | 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 | X | ||
Contribution | Contribution | ||
| Line 112: | Line 111: | ||
= Market Share Variance...................................................Market Size Variance | = Market Share Variance...................................................Market Size Variance | ||
Things to | ==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]] | ||
[[Category:Finance]] | [[Category:Finance]] | ||
Revision as of 19:26, 23 September 2012
Evaluate the budget based upon the actual not the budgeted volume. Thereby determining if the div met its labour, material and overheads budget
| Original | Flexed | Actual | |
| O/P | 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
LABOUR VARIANCES
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
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