Purchase Solution

Hannon Company: Prepare a flexible manufacturing budget

Not what you're looking for?

Ask Custom Question

BE21-4

See the attached file for proper format of the table.

Hannon Company expects to produce 1,200,000 units of Product XX in 2010. Monthly production is expected to range from 80,000 to 120,000 units. Budgeted variable manufacturing costs per unit are: direct materials $4, direct labor $6, and overhead $8. Budgeted fixed manufacturing costs per unit for depreciation are $2 and for supervision are $1. Complete the flexible manufacturing budget for the relevant range value using 20,000 unit increments.

HANNON COMPANY
Monthly Flexible Manufacturing Budget
For the Year 2010
Activity level

Finished goods
Variable costs
Direct materials $
$
$

Direct labor

Overhead

Total variable costs $
$
$

Fixed costs
Depreciation

Supervision

Total fixed costs

Total costs $
$
$

Purchase this Solution

Solution Summary

Your tutorial is shown in Excel (attached, click in cells to see computations). The trick is to solve for the monthly fixed costs. The per unit is based on the annual activity. So, you multiply the per unit times the annual units to get the total and then adjust it to monthly.

I have shown the three levels of activity requested.

Solution Preview

Your tutorial is shown in Excel (attached, click in cells to see computations). The trick is to solve for ...

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
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.