Purchase Solution

flexible budget P7-7

Not what you're looking for?

Ask Custom Question

P7-7 Flexible budget for factory overhead
Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity.
Factory Overhead budget
Fixed cost
Depreciation on building and machinery $1,200
Taxes on building and machinery 500
Insurance on building and machinery 500
Superintendent salary 1,500
Supervisors salaries 2,300
Maintenance wages 1,000 7,000
Variable cost
Repairs $400
Maintenance supplies 300
Other supplies 200
Payroll taxes 800
Small tools 300 2,000
Total standard factory overhead $9,000

Required:
1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the rate of application of factory overhead to work in process at each level of volume in both units and direct labor hours.
2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportions to the change in volume, but with the following exceptions. (Hint: Set up a third category for semifixed expenses.)
a. At 110% of capacity, an assistant department head will be needed at a salary of $10,500 annually.
b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. (At other levels it is perfectly variable.)
c. Maintenance supplies expense will remain constant at all levels of production.
d. At 80% of capacity, one part-time maintenance worker, earning $6,000 a year, will be laid off.
e. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was $12,000, it has a ten-year life, and straight-line depreciation will be taken.

Attachments
Purchase this Solution

Solution Summary

Flexible budget is created in excel so the student has a template for future problems.

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.

Income Streams

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

Learning Lean

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

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.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.