Explore BrainMass

Manufacturing Standard Cost Sheets

Assignment (submit Excel file plus 12-15 slides presentation w/ speaker notes)

** Open attachment for data **

One of your clients, Moore Manufacturing has asked you to assist them in evaluating their performance against their budgets. The management of Moore Manufacturing has provided the following standard cost sheet for one of its products:
1. Determine the following for the period:
a. Flexible budget for variable overhead based on output for the period
b. Total variable overhead applied to production during the period
c. Total budgeted fixed factory overhead
d. Total fixed factory overhead applied to production during the period
Calculate the following variances using four-variance analysis:
. Total variable overhead variance
a. Variable overhead spending variance
b. Variable overhead efficiency variance
c. Total under applied or over applied variable overhead
d. Fixed overhead spending variance
e. Production volume variance
f. Total fixed overhead variance
g. Total under applied or over applied fixed overhead
Calculate the following variances using three-variance analysis:
. Factory overhead spending variance
a. Factory overhead efficiency variance
b. Production volume variance
Calculate the total overhead flexible budget variance and the production volume variance using a two-variance analysis. (in excel file).

2. Prepare a 12-15 slides presentation for the management team at Moore Manufacturing explaining the variances and evaluating their performance. (ppt file)

© BrainMass Inc. brainmass.com July 19, 2018, 9:58 am ad1c9bdddf


Solution Summary

The solution examines manufacturing standard cost sheets.