ACC 406 Lecture Notes - Lecture 11: Stabilisation Force In Bosnia And Herzegovina, Sensitivity Analysis, Unit
Document Summary
Get access
Related Documents
Related Questions
Consider the following information from Grantham Company,then see the instructions that | ||||||||
follow. | ||||||||
Grantham Company manufactures dog whistles. The followinginformation is available from | ||||||||
the budgetary control system for 2016, and was used to createthe master budget. Grantham | ||||||||
applies overhead using an activity index of direct laborhours. | ||||||||
Variable Costs | Rate per direct labor hour | |||||||
Indirect labor | $0.52 | |||||||
Indirect materials | 0.36 | |||||||
Factory utilities | 0.88 | |||||||
Factory repairs | 0.48 | |||||||
Fixed Costs | Amount per year | |||||||
Depreciation | $25,300 | |||||||
Insurance | 9,300 | |||||||
Property taxes | 5,800 | |||||||
Supervision | 61,500 | |||||||
The master overhead budget was prepared with the expectationthat 462,000 direct labor | ||||||||
hours would be worked during the year. In August, 39,500 directlabor hours were worked. | ||||||||
At that level of activity, actual costs were as shown below: | ||||||||
Variable Costs | ||||||||
Indirect labor | $0.54 | per labor hour | ||||||
Indirect materials | 0.34 | per labor hour | ||||||
Factory utilities | 0.91 | per labor hour | ||||||
Factory repairs | 0.53 | per labor hour | ||||||
Fixed Costs | ||||||||
Depreciation | $2,108 | |||||||
Insurance | 825 | |||||||
Property taxes | 500 | |||||||
Supervision | 5,250 | |||||||
Instructions: | ||||||||
Prepare a monthly manufacturing overhead flexible budget,assuming production levels | ||||||||
ranging from 30,000 to 45,000 direct labor hours, in incrementsof 5,000. | ||||||||
Prepare a budget report for August comparing actual results tothe flexible budget. Explain | ||||||||
whether costs were successfully controlled and how you cantell. | ||||||||
THIS ASSIGNMENT MUST BE COMPLETED IN EXCEL. You should developan efficient and | ||||||||
customizable production cost report, using formulas wheneverpossible instead of keyed in | ||||||||
values. No numeric values except the ones shown above shouldneed to be keyed in. |