ACTG 1P12 Lecture Notes - Lecture 19: Deutsche Luft Hansa, Fixed Cost, Variable Cost
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. |
Several years ago, Westmont Corporation developed acomprehensive budgeting system for planning and control purposes.While departmental supervisors have been happy with the system, thefactory manager has expressed considerable dissatisfaction with theinformation being generated by the system.
A typical departmental cost report for a recent periodfollows:
Assembly Department Cost Report For the Month Ended March 31 | |||||||
Actual Results | Planning Budget | Variances | |||||
Machine-hours | 50,000 | 55,000 | |||||
Variable costs: | |||||||
Supplies | $ | 48,950 | $ | 52,250 | $ | 3,300 | F |
Scrap | 32,400 | 33,000 | 600 | F | |||
Indirect materials | 82,800 | 88,000 | 5,200 | F | |||
Fixed costs: | |||||||
Wages and salaries | 89,250 | 90,000 | 750 | F | |||
Equipment depreciation | 70,000 | 70,000 | â | ||||
Total cost | $ | 323,400 | $ | 333,250 | $ | 9,850 | F |
After receiving a copy of this cost report, the supervisor ofthe Assembly Department stated, âThese reports are super. It makesme feel really good to see how well things are going in mydepartment. I canât understand why those people upstairs complainso much about the reports.â
For the last several years, the companyâs marketing departmenthas chronically failed to meet the sales goals expressed in thecompanyâs monthly budgets.
Required:
1. The companyâs president is uneasy about the cost reports,what can be the reason? (You may select more than oneanswer. Single click the box with the question mark to produce acheck mark for a correct answer and double click the box with thequestion mark to empty the box for a wrong answer.)
Cost reports are ineffective sincebudgeted costs at one level of activity are compared to actualcosts at another level of activity. | |
Cost reports show whether fixedcosts are controlled and do not show whether variable costs arecontrolled. | |
Cost reports are effective sincebudgeted costs at one level of activity are compared to actualcosts at another level of activity. | |
Cost reports show whether fixedcosts and variable costs are controlled. |
2. What kind of reports should be used to give better insightinto how well departmental supervisors are controlling costs?
Flexible budget performance reportsmust be used | |
Fixed budget performance reportsmust be used |
3. Complete the new performance report for the quarter, based onFlexible Budget Performance approach. (Indicate the effectof each variance by selecting "F" for favorable, "U" forunfavorable, and "None" for no effect (i.e., zero variance). Inputall amounts as positive values.)
4. Were costs well controlled in March?