Purchase Solution

NPC Overhead variances

Not what you're looking for?

Ask Custom Question

NPC developed its overhead application rate from the annual budget. The budget is based on an expected total output of 720,000 units requiring 3,600,000 machine hours. The company is able to schedule production uniformly throughout the year.
A total of 66,000 units requiring 315,000 machine hours were produced during May. Actual overhead costs for May amonted to 375,000. The actual costs, as rcompared to the annual budget and to 1/12 of the annual budget are:

Total per unit per machine monthly acctual
Amount hours budget cost for May
Variable overhead:
indirect material...1,224,000 1.70 0.34 102,000 111,000
indirect labour........900,000 1.25 0.25 75,000 75,000
Fixed overhead:
supervision...........648,000 0.90 0.18 54,000 51,000
utilities..................540,000 0.75 0.15 45,000 54,000
depreciation..........1,008,000 1.40 0.28 84,000 84,000
___________________________________________________________
Total: 4,320,000 6.00 1.20 360,000 375,000

1. Prepare a schedule showing the following amounts for NPC in May.
a. Applied overhead costs
b.Variable overhead spending variance
c.fixed overhead budget variance
d.variable overhead efficiency variance
e.fixed overhead volume variance
2.draw a graph to depict the variable overhead variances.

Purchase this Solution

Solution Summary

Your tutorial is attached (in Excel, click in cells to see computations) showing you how to complete the four variances, solving for the standard rates, what is applied to the products and showing you a bar graph of actual vs. budget for variable overhead.

Solution Preview

Your tutorial is attached (in Excel, click in cells to see ...

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
Lean your Process

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

Operations Management

This quiz tests a student's knowledge about Operations Management

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.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.