Hannon Company: Prepare a flexible manufacturing budget
Not what you're looking for?
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 ...
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.