Purchase Solution

Flexible budgets variance analysis: Brownstone Products

Not what you're looking for?

Ask Custom 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,200 $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. Set up a spreadsheet to compute the July sales volume variance and the flexible-budget variance for the month in terms of both contribution margin and operating income
2. Create an electronic spreadsheet that will allow the firm to prepare pro forma budgets for activities within the relevant range of operations and prepare flexible budgets when sales are:
a. 3,750 units
b. 4,150 units

Purchase this Solution

Solution Summary

Your tutorial gives you a spreadsheet to tease out the volume variances and the flexible budget variances as well as two pro forma contribution margin income statements at the two desired levels. You can change the volume in units and the spreadsheet will update (yellow cells). Two references are provided.

Solution Preview

Your tutorial gives you a spreadsheet to tease out the volume variances and ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Operations Management

This quiz tests a student's knowledge about Operations Management