Question
The following information is available for Brownstone Products Company for the month of July: Actual Master Budget Units 3,800 4,000 Sales revenue $53,600 $60,000 Variable
The following information is available for Brownstone Products Company for the month of July:
Actual | Master Budget | |||||
Units | 3,800 | 4,000 | ||||
Sales revenue | $53,600 | $60,000 | ||||
Variable manufacturing costs | 19,000 | 16,000 | ||||
Fixed manufacturing costs | 16,000 | 15,000 | ||||
Variable selling and administrative expenses | 7,700 | 8,000 | ||||
Fixed selling and administrative expenses | 10,000 | 9,000 | ||||
1. What was the total operating income variance for July, rounded to the nearest whole dollar? Was this variance favorable (F) or unfavorable (U)?
2. Set up a spreadsheet to compute the July sales volume variance and the flexible-budget variance for the month, both in terms of contribution margin and in terms of operating income. Round all dollar amounts to the nearest whole number.
3. Discuss implications of these variances on strategic cost management for Brownstone.
4. Configure your spreadsheet so that it will allow the firm to prepare pro-forma budgets for activities within its relevant range of operations. Use your spreadsheet to prepare a flexible budget for each of the following two output levels (round all dollar amounts in the flexible budgets to the nearest whole number):
a. 3,750 units.
b. 4,150 units.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started