Purchase Solution

Braemar Saddlery flexible budgeting

Not what you're looking for?

Ask Custom Question

Braemar Saddlery uses department budgets and performance reports in planning and controlling its manufacturing operations. The following annual performance report for the custom saddle production department was presented to the president of the company: (see attached)

Although a production volume of 5,000 saddles was originally budgeted for the year, the actual volume of production achieved for the year was 6,000 saddles. Direct materials and direct labor are charged to production at actual cost. Factory overhead is applied to production at the predetermined rate of 150 percent of the actual direct labor cost.

After a quick glance at the performance report showing an unfavorable manufacturing cost variance of $75,000, the president said to the accountant: "Fix this thing so it makes sense. It looks as though our production people really blew the budget. Remember that we exceeded our budgeted production schedule by a significant margin. I want this performance report to show a better picture of our ability to control costs."

Prepare a revised performance report for the year on a flexible budget basis. Use the same format as the production report above, but revise the budgeted cost figures to reflect the actual production level of 6,000 saddles. (Leave no cells blank - be certain to enter "0" wherever required. Amounts to be deducted should be indicated with a minus sign. Round your per unit answers to 1decimal place. Omit the "$" sign in your response.)

Purchase this Solution

Solution Summary

Your tutorial is in Excel (attached) and shows the new performance report and how to compute the applied and underapplied overhead.

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
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.