Using Flexible Budgets The following summary data are from a performance report for Hyland Company for June, during which 9,600 units were produced. The budget reflects the company’s normal capacity of 10,000 units.
Performance report should match the cost for the same volume of production. A separate variance may be provided for quantity variance. The total variance needs to be broken down into rate variance and quantity variance. Hyland may question the significance of the report as the variance related to rate is not separated from quantity variance.
Revised performance report:
A | B | A - B | C | B - C | Rate variance + Quantity variance | |
Actual costs (9600 units) | Budget (9600 units) | Rate variance | Budget (10000 units) | Quantity variance | Total variance | |
Direct Material | 102600 | 100800 | 1800 | 105000 | -4200 | -2400 |
Direct Labour | 207900 | 201600 | 6300 | 210000 | -8400 | -2100 |
Variable overhead | 73800 | 69120 | 4680 | 72000 | -2880 | 1800 |
Fixed overhead | 54300 | 51840 | 2460 | 54000 | -2160 | 300 |
Total | 438600 | 423360 | 15240 | -17640 | -2400 | |
Note - Positive variance is unfavourable variance and negative variance is favourable variance. | ||||||
Unfavourable variance for the same quantity means that the actual cost rate per unit is more than budgeted cost rate per unit. Similarly the variance between budgeted cost at actual quantity versus budgeted cost at budgeted quantity gives quantity variance - the cost that is attributed to reduction of actual quantity from budget quantity. The sum of rate variance and quantity variance is total variance.
Using Flexible Budgets The following summary data are from a performance report for Hyland Company for June, during whic...
W 15 the TCAIUI Vuugu 11-2A. Using Flexible Budget exible Budgets The following summary data are from a performance report for Sterling "pany for May, during which 9.600 units were produced. The budget reflects the company's normal capacity of 10,000 units. Actual Costs (9,600 Units) Variances Direct material .... Direct labor........... Variable overhead .... Fixed overhead. $136,800 277,200 98,400 72,400 $584,800 Budget (10,000 Units) $140,000 280,000 96,000 72,000 $588,000 [$3,200 F] [2,800 F] 2,400 U 400 U [$3,200 F] Total...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 For the Month Actual Flexible Results Spending Variances variances Budget 9,600 Activity Variances Planning Budget...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department’s Flexible Budget Performance Report. Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to...
Requirement 1: Complete the following flexible budget performance report using the numbers from the Business Assignment 2 Instructions file. The Board Company Flexible Budget Performance Report for the month ended August 31 Budgeted units of production: Actual units of production: Units of production variance в (A-B) F/U (A-C) FIU Α Actual Costs Incurred for 9.480 units Flexible Budget Based on 9.480 units Flexible Budget Variance Static Budget Based on 9.000 units Static Budget Variances Variable Costs: Direct materials Direct labor...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department's Flexible Budget Performance Report. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Results Spending Variances Budget...
Sunshine Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget Labor-hours (q) 9,550 9,070 Direct labor ( q) $169,205 $167,125 Indirect...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour answers to 2 decimal places. Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (I.e., zero varlance). Input all amounts as positive values.) Required: Complete the Production Department's Flexible Budget Performance Report. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Results Spending Variances Budget...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department's Flexible Budget Performance Report. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Spending Variances Results Budget...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department's Flexible Budget Performance Report. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Spending Variances Results Budget...
Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department's Flexible Budget Performance Report Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Spending Variances Results Budget...