In: Accounting
Smith Enterprises manufactures tires for the Formula 1 motor racing circuit. For August 2017, it budgeted to manufacture and sell 3 comma 700 tires at a variable cost of $ 76 per tire and total fixed costs of $ 54 comma 000. The budgeted selling price was $ 108 per tire. Actual results in August 2017 were 3 comma 400 tires manufactured and sold at a selling price of $ 110 per tire. The actual total variable costs were $ 282 comma 200, and the actual total fixed costs were $ 50 comma 500.
1. Prepare a performance report that uses a flexible budget and a static budget.
2. Comment on the results in requirement 1.
1) Solution:
| 
 Actual Results  | 
 Flexible- Budget Variances  | 
 Flexible Budget  | 
 Sales-Volume Variances  | 
 Static Budget  | 
|
| 
 1  | 
 2 = 1 - 3  | 
 3  | 
 4 = 3-5  | 
 5  | 
|
| 
 Actual tires  | 
 3400  | 
 0  | 
 3,400  | 
 300 U  | 
 3,700  | 
| 
 Revenues  | 
 3400*110 = 374,000  | 
 6,800 F  | 
 3400*108 = 367,200  | 
 32,400 U  | 
 3700*108=399,600  | 
| 
 Variable costs  | 
 282,200  | 
 40,800 U  | 
 3400*71=241,400  | 
 21,300 F  | 
 3700*71 = 262,700  | 
| 
 Contribution Mragin  | 
 91800  | 
 34,000 U  | 
 125800  | 
 11,100 U  | 
 136900  | 
| 
 Fixed cost  | 
 50,500  | 
 3,500 F  | 
 54,000  | 
 0  | 
 54,000  | 
| 
 Operating income  | 
 41,300  | 
 30,500 U  | 
 71,800  | 
 11,100 U  | 
 82,900  | 
Total flexible-budget variance 30,500 U
Total static-budget variance: 41,600 U
2)
| 
 Actual  | 
 Budgeted  | 
|
| 
 Units  | 
 3400  | 
 3700  | 
| 
 Unit selling price  | 
 110  | 
 108  | 
| 
 Unit variable cost  | 
 282200/3400 = 83  | 
 76  | 
| 
 Fixed costs  | 
 50,500  | 
 54,000  | 
The operating income in total static-budget variance is $41,600 U. The total flexible-budget variance is also unfavorable at ($30,500) and an unfavorable sales-volume variance ($11,100).