Flexed Budgets
(→Things to think about) |
|||
(11 intermediate revisions by one user not shown) | |||
Line 10: | Line 10: | ||
|Actual | |Actual | ||
|- | |- | ||
− | | | + | |Output |
|1000 | |1000 | ||
|900 | |900 | ||
Line 16: | Line 16: | ||
|- | |- | ||
|Sales | |Sales | ||
− | |100,000 | + | |$100,000 |
− | |90,000 | + | |$90,000 |
− | |92,000 | + | |$92,000 |
|- | |- | ||
|Raw Material | |Raw Material | ||
− | |(40,000) | + | |$(40,000) |
− | |(36,000)36k m | + | |$(36,000)36k m |
− | |(36,900) 37k m | + | |$(36,900) 37k m |
|- | |- | ||
|Labor | |Labor | ||
− | |(20,000) | + | |$(20,000) |
− | |(18,000) 2,250hr | + | |$(18,000) 2,250hr |
− | |(17,500) 2,150hr | + | |$(17,500) 2,150hr |
|- | |- | ||
|Contribution | |Contribution | ||
− | |40,000.4/unit | + | |$40,000.4/unit |
− | |36,000.4/unit | + | |$36,000.4/unit |
− | |37,600 | + | |$37,600 |
|- | |- | ||
|Fixed Overhead | |Fixed Overhead | ||
− | |(20,000) | + | |$(20,000) |
− | |(20,000) | + | |$(20,000) |
− | |(20,700) | + | |$(20,700) |
|- | |- | ||
|Operating Profit | |Operating Profit | ||
− | |20,000 | + | |$20,000 |
− | |16,000 | + | |$16,000 |
− | |16,900 | + | |$16,900 |
|} | |} | ||
Line 88: | Line 88: | ||
==Reconciliation of Variances== | ==Reconciliation of Variances== | ||
+ | {| class="wikitable sortable" border="1" cellpadding="5" cellspacing="0" align="center" | ||
+ | |+ Reconciliation of Variances''' | ||
+ | |- | ||
− | Budgeted Profit | + | |Budgeted Profit |
− | - | + | |20,000 |
− | + | | | |
− | - | + | |- |
− | + | |Less Sales Volume Variance | |
− | + | |(4,000) | |
− | - | + | |Difference between Flexed and Actual Sales |
− | - | + | |- |
− | Actual Profit | + | |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,900 | ||
+ | | | ||
+ | |} | ||
==Market Share and Market Size Variances (Sales Volume Variance)== | ==Market Share and Market Size Variances (Sales Volume Variance)== | ||
− | 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 | + | Actual Units sold Market* Actual Market Share(this is what the actually sold) |
− | X | + | *- Actual Units * Expected Share(This is what they should have sold given their marketkt share |
− | Contribution | + | *- Expected units sold |
− | 92000*10%*4=37600 diff 90000*10%*4=36000 | + | *X Expected share(THIS IS NOT THE FLEXED #) |
+ | *X Contribution 92000*10%*4=37600 diff 90000*10%*4=36000 | ||
Line 117: | Line 146: | ||
* Are they normal fluctuations - are you looking over a long enough time period | * Are they normal fluctuations - are you looking over a long enough time period | ||
* Do something about it when you find them | * Do something about it when you find them | ||
− | * Is the standard unattainable - basic, ideal and attainable see [[Standard | + | * Is the standard unattainable - basic, ideal and attainable see [[Standard Costing]] |
[[Category:Finance]] | [[Category:Finance]] | ||
+ | [[category:Pages Needing Improvement]] |
Latest revision as of 14:46, 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
Contents |
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] Reconciliation of Variances
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,900 |
[edit]
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 marketkt share
- - Expected units sold
- X Expected share(THIS IS NOT THE FLEXED #)
- X Contribution 92000*10%*4=37600 diff 90000*10%*4=36000
= Market Share Variance...................................................Market Size Variance
[edit] 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 Costing