5. Master Budget Actual Results
Sales Volume in Unit 2,500 2,700
Sales Revenue $ 37,500 41,000
Variable Cost of Goods Sold 20,000 21,200
Variable S&A 5,000 5,500
Contribution Margin 12,500 14,300
Fixed Cost of Goods Sold 4,000 4,200
Fixed S&A 3,000 2,900
Operating Income 5,500 7,200
a. Make a flexible budget.
b. Compute a revenue/spending variance and indicate its favorability.
Solution a& b:
Particulars | Actual results | Revenue and spending variances | Flexible Budget | |
Nos of units | 2700 | 2700 | ||
Sales revenue | $41,000.00 | $500.00 | F | $40,500.00 |
Variable expenses: | ||||
Variable cost of goods sold | $21,200.00 | $400.00 | F | $21,600.00 |
Variable S&A | $5,500.00 | $100.00 | U | $5,400.00 |
Total Variable Expenses | $26,700.00 | $300.00 | F | $27,000.00 |
Contribution margin | $14,300.00 | $800.00 | F | $13,500.00 |
Fixed Expenses: | ||||
Fixed Cost of goods sold | $4,200.00 | $200.00 | U | $4,000.00 |
Fixed S&A | $2,900.00 | $100.00 | F | $3,000.00 |
Total Fixed Expenses | $7,100.00 | $100.00 | U | $7,000.00 |
Net Operating Income | $7,200.00 | $700.00 | F | $6,500.00 |
Solomon Manufacturing Company established the following standard price and cost data. Sales price $ 8.50 per unit Variable manufacturing cost $ 3.80 per unit Fixed manufacturing cost $ 2,500 total Fixed selling and administrative cost $ 900 total Solomon planned to produce and sell 2,500 units. Actual production and sales amounted to 2,700 units. Required Prepare the pro forma income statement in contribution format that would appear in a master budget. Prepare the pro forma income statement in contribution format...
10 Which of the following statements is true? activity is higher than expected total fixed costs should be higher than expected. I civity is lower than expected, total fixed costs should be lower than expected Fixed costs should not be included in a flexible budget because they do not change when the level of activity changes. C A revenue variance is favorable if the actual revenue is greater than the revenue in the master (static planning) budget. A spending variance...
OIive Company makes slver belt buckles. The company's master budget appears In the first column of the table Required: Complete the table by preparing Olve's flexible budget for 4,000, 6,000, and 7,000 units. (Round your Intermediate calculetions to 2 decimal places.) Master Budget Flexible Budget (5,000 Units) Flexible Budget (6,000 Units) Flexible Budget (7,000 Units) (4,000 Units) Direct materials 1,000 Direct labor 2,500 Variable manufacturing overhead 1,500 Fixed manufacturing overhead 17,900 Total manufacturing cost 22,900
Hanno had the following static budget for March, when it expected to sell 4,000 sandwiches: Sales revenue $ 48,000 Variable costs $ 28,000 Fixed costs $ 5,000 Net income $15,000 Hanno actually sold 5,000 sandwiches during March at $12 each. Variable costs were $37,500 and fixed costs were $4,800. A. Prepare a flexible budget at for March that will help Hanno separate the volume variance from the flexible budget variance. Make your income statement match my format and compute net...
Olive Company makes silver belt buckles. The company’s master budget appears in the first column of the table. Required: Complete the table by preparing Olive’s flexible budget for 4,200, 6,200, and 7,200 units. (Round your intermediate calculations to 2 decimal places.) Master Budget Flexible Budget( 4200 Units) Flexible Budget (6200 Units) Flexibile Budget (7200 Budgets) Direct Materials 1,560 Direct Labor 2,600 Variable Manufacturing Overhead 2,080 Fixed Moh 18,000 Total: 24,240
Prepare a flexible budget using the following information: Sales Price $20 per unit Cost of goods sold is 30% of Sales Price Variable Operating Cost are $2.50 per unit sold Fixed Operating Cost are $15,000 Sales levels 10,000, 12,500, 15,000
#3 only. 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating Income Variance; Spreadsheet Application The following information is available for Brownstone Products Company for the month of July Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Actual Master Budget 3.800 4,000 $53,200 $60,000 19.000 16,000 16.000 15,000 7,700 8,000 10.000 9,000 Required 1. What was the total operating income variance for July, rounded to the...
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2,000 U ? Sales revenue ? 13,000 F ? ? ? Less: Variable mfg. costs $ 87,750 $ 91,000 ? $ 105,000 Variable mktg/adm.costs ? $ 3,250 U ? $ 4,000 F 30,000 Contribution margin $ 52,000 ? ? $ 6,000 U ? What is the master budget sales revenue?
3. ABC Company has the master/static budget and actual of operating result (2015) as shown beloW. ABC Company Operating Results For year 2015 Master Budget 20,000 1,000,000 500,000 Actual Variance Units sold Revenue Variable cost Variable production overhead 15,000 742,500 390,000 160,000500 32,500 F 225,000 5,000 U 257,500 U 110,000 F 115,000 U 5,000 F 110,000 U Contribution margin Fixed production overhead Operating income 340,000 150,000 190,000 45,000 80,000 3.1 Prepare a flexible budget for ABC Company for vear 2015...
Master Master Budget Variance Actual 60,500 Budget 57,000 Sales volume (number of cases sold) Sales revenue Less: Variable expenses Contribution margin Less: Fixed expenses $ 193,700 $ 71,200 176,700 62,700 $ 122,500 $ 73,200 114,000 72,000 $ 49,300 $ 42,000 Operating income The budgeted sales price per unit is $ 3.10 Requirement 2. What is the budgeted variable expense per unit? The budgeted variable expense per unit is $ 1.10. Requirement 3. What is the budgeted fixed cost for the...