Question

In: Accounting

The results for July for Brahms & Sons follow:   Actual (based on actual sales of 100,000...

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.)

Solutions

Expert Solution

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

Related Solutions

The results for July for Brahms & Sons follow:   Actual (based on actual sales of 64,000...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 64,000 units) Master Budget (based on budgeted sales 62,000 units) Sales revenue $ 500,000 $ 527,000 Less Variable costs Direct material 64,000 52,700 Direct labor 81,000 93,000 Variable overhead 88,000 93,000 Marketing 15,400 15,500 Administrative 14,100 15,500 Total variable costs $ 262,500 $ 269,700 Contribution margin $ 237,500 $ 257,300 Less Fixed costs Manufacturing 110,000 104,000 Marketing 23,500 15,500 Administrative 83,400 82,000 Total fixed costs...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 66,000...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 66,000 units) Master Budget (based on budgeted sales 64,000 units) Sales revenue $ 510,000 $ 544,000 Less Variable costs Direct material 66,000 54,400 Direct labor 82,000 96,000 Variable overhead 89,000 96,000 Marketing 15,800 16,000 Administrative 14,200 16,000 Total variable costs $ 267,000 $ 278,400 Contribution margin $ 243,000 $ 265,600 Less Fixed costs Manufacturing 111,000 106,000 Marketing 24,100 16,000 Administrative 84,500 83,000 Total fixed costs...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 98,000...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 98,000 units) Master Budget (based on budgeted sales 96,000 units) Sales revenue $ 650,000 $ 816,000 Less Variable costs Direct material 98,000 81,600 Direct labor 98,000 144,000 Variable overhead 105,000 144,000 Marketing 20,800 24,000 Administrative 15,800 24,000 Total variable costs $ 337,600 $ 417,600 Contribution margin $ 312,400 $ 398,400 Less Fixed costs Manufacturing 138,100 138,000 Marketing 43,800 24,000 Administrative 102,100 99,000 Total fixed costs...
Problem 16-54 Sales Activity Variance (LO 16-3) The results for July for Brahms & Sons follow:...
Problem 16-54 Sales Activity Variance (LO 16-3) The results for July for Brahms & Sons follow: Actual (based on actual sales of 55,000 units) Master Budget (based on budgeted sales 50,000 units) Sales revenue $ 465,000 $ 575,000 Less Variable costs Direct material 60,300 63,000 Direct labor 56,100 79,000 Variable overhead 64,900 79,000 Marketing 21,900 35,000 Administrative 20,300 35,000 Total variable costs $ 223,500 $ 291,000 Contribution margin $ 241,500 $ 284,000 Less Fixed costs Manufacturing 103,900 103,000 Marketing 24,300...
Problem 16-55 Profit Variance Analysis (LO 16-4) The results for July for Brahms & Sons follow:...
Problem 16-55 Profit Variance Analysis (LO 16-4) The results for July for Brahms & Sons follow: Actual (based on actual sales of 62,000 units) Master Budget (based on budgeted sales 60,000 units) Sales revenue $ 490,000 $ 510,000 Less Variable costs Direct material 62,000 51,000 Direct labor 80,000 90,000 Variable overhead 87,000 90,000 Marketing 15,000 15,000 Administrative 14,000 15,000 Total variable costs $ 258,000 $ 261,000 Contribution margin $ 232,000 $ 249,000 Less Fixed costs Manufacturing 104,000 102,000 Marketing 23,000...
Problem 16-55 Profit Variance Analysis (LO 16-4) The results for July for Brahms & Sons follow:  ...
Problem 16-55 Profit Variance Analysis (LO 16-4) The results for July for Brahms & Sons follow:   Actual (based on actual sales of 98,000 units) Master Budget (based on budgeted sales 96,000 units) Sales revenue $ 650,000 $ 816,000 Less Variable costs Direct material 98,000 81,600 Direct labor 98,000 144,000 Variable overhead 105,000 144,000 Marketing 20,800 24,000 Administrative 15,800 24,000 Total variable costs $ 337,600 $ 417,600 Contribution margin $ 312,400 $ 398,400 Less Fixed costs Manufacturing 138,100 138,000 Marketing 43,800...
. Below is information about actual sales of a product for June and July and the...
. Below is information about actual sales of a product for June and July and the expected sales of August, September and October. Selling price for the product is $100. June $230,000, July $240,000, August $220,000, September $280,000 and October $310,000. November $340,000 Costs of Goods Sold equals to 70% of Sales. The end of inventory policy is 40% of the next month of quantity sales.   Inventory is purchased on continuous basis during the month. 60% of inventory costs are...
Below is TeaSpot's July contribution report, comparing budgeted and actual results for its tie-dyed t-shirt. Actual...
Below is TeaSpot's July contribution report, comparing budgeted and actual results for its tie-dyed t-shirt. Actual Master Budget # of Tie-Dyed Shirts Sold 217,000 shirts 215,000 shirts Sales Revenue $ 5,989,200 $ 5,934,000 Direct Materials: White Shirts 592,410 591,250 Rubber Bands 22,785 17,200 Drying Bags 39,060 32,250 Direct Labor 1,085,000 774,000 Variable Overhead 781,200 696,600 Total Variable Costs 2,520,455 2,111,399 Contribution Margin 3,468,745 3,822,700 Standard Costs for one tie-dyed shirt: White Shirts 1 shirt at $2.75 per shirt Rubber Bands...
Q14-Q18 are based on this case: XTi Co. gathered the following actual results for the current...
Q14-Q18 are based on this case: XTi Co. gathered the following actual results for the current month: Actual Units produced                                                                             1,200 Direct materials purchased 6,400 lbs. @ $11 per lb for $70,400; and used 5,800 lbs. Direct labor cost (2,150 hours @$22 per hour)                              $47,300 Manufacturing overhead costs incurred: $19,350 Variable and $9,650 Fixed overhead. The Static original budgeted production was 1,000 units. The Input standards were:                                                                            Std Quantity   x   Std Price per input =Std Cost per Output U...
Q14-Q18 are based on this case: XTi Co. gathered the following actual results for the current...
Q14-Q18 are based on this case: XTi Co. gathered the following actual results for the current month: Actual Units produced                                                                             1,200 Direct materials purchased 6,400 lbs. @ $11 per lb for $70,400; and used 5,800 lbs. Direct labor cost (2,150 hours @$22 per hour)                              $47,300 Manufacturing overhead costs incurred: $19,350 Variable and $9,650 Fixed overhead. The Static original budgeted production was 1,000 units. The Input standards were:                                                                            Std Quantity   x   Std Price per input =Std Cost per Output U...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT