In: Accounting
The results for July for Brahms & Sons
follow:
Actual (based on actual sales of 100,000 units) Master Budget
(based on budgeted sales 90,000 units)
Sales revenue $ 640,000 $ 765,000
Less
Variable costs
Direct material 100,000 76,500
Direct labor 95,000 135,000
Variable overhead 102,000 135,000
Marketing 18,400 22,500
Administrative 15,500 22,500
Total variable costs $ 330,900 $ 391,500
Contribution margin $ 309,100 $ 373,500
Less
Fixed costs
Manufacturing 138,300 132,000
Marketing 42,000 22,500
Administrative 98,800 96,000
Total fixed costs $ 279,100 $ 250,500
Operating profits $ 30,000 $ 123,000
Required:
Prepare a profit variance analysis for Brahms & Sons. ( Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
| Profit variance analysis: Brahms & Sons. | |||||||||||
| Actual (100,000 Units) |
Manu-facturingVariance | Marketing &AdministrationVariance | Sales PriceVariance | FlexibleBudget (100,000Units) | SalesActivityVariance | MasterBudget (90,000Units) | |||||
| Sales revenue | 640,000 | 210,000 | U | 850000 | 85000 | F | 765000 | ||||
| Variable costs: | |||||||||||
| Manufacturing | |||||||||||
| Direct material | 100000 | 15000 | U | 85000 | 8500 | U | 76500 | ||||
| Direct labor | 95000 | 55000 | F | 150000 | 15000 | U | 135000 | ||||
| Variable Overhead | 102000 | 48000 | F | 150000 | 15000 | U | 135000 | ||||
| Marketing | 18400 | 6600 | F | 25000 | 2500 | U | 22500 | ||||
| Administration | 15500 | 9500 | F | 25000 | 2500 | U | 22500 | ||||
| Contribution margin | 309100 | 88000 | F | 16100 | F | 210000 | U | 415000 | 41500 | F | 373500 |
| Fixed Costs | |||||||||||
| Manufacturing | 138300 | 6300 | U | 132000 | - | 132000 | |||||
| Marketing | 42000 | 19500 | U | 22500 | - | 22500 | |||||
| Administration | 98800 | 2800 | U | 96000 | - | 96000 | |||||
| Operating profit | 30000 | 81700 | F | 6200 | U | 210000 | U | 164500 | 41,500.00 | F | 123000 |
| *765000/90000*100000=850000 | |||||||||||