Frank Weston, supervisor of the Freemont Corporation’s Machining Department, was visibly upset after being reprimanded for his department’s poor performance over the prior month. The department’s cost control report is given below: Freemont Corporation–Machining Department Cost Control Report For the Month Ended June 30 Actual Results Planning Budget Variances Machine-hours 42,000 40,000 Direct labor wages $ 87,000 $ 84,400 $ 2,600 U Supplies 27,300 24,800 2,500 U Maintenance 24,400 22,500 1,900 U Utilities 22,100 21,100 1,000 U Supervision 53,000 53,000 0 Depreciation 91,000 91,000 0 Total $ 304,800 $ 296,800 $ 8,000 U “I just can’t understand all of these unfavorable variances,” Weston complained to the supervisor of another department. “When the boss called me in, I thought he was going to give me a pat on the back because I know for a fact that my department worked more efficiently last month than it has ever worked before. Instead, he tore me apart. I thought for a minute that it might be over the supplies that were stolen out of our warehouse last month. But they only amounted to a couple of hundred dollars, and just look at this report. Everything is unfavorable.” Direct labor wages and supplies are variable costs; supervision and depreciation are fixed costs; and maintenance and utilities are mixed costs. The fixed component of the budgeted maintenance cost is $16,900; the fixed component of the budgeted utilities cost is $14,000. Required: 2. Complete the performance report that will help Mr. Weston’s superiors assess how well costs were controlled in the machining department. (Round your intermediate calculations to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Frank Weston, supervisor of the Freemont Corporation’s Machining Department, was visibly upset after being reprimanded for his department’s poor performance over the prior month. The department’s cost control report is given below:
Freemont Corporation–Machining Department Cost Control Report For the Month Ended June 30 |
|||||||||
Actual Results | Planning |
Variances | |||||||
Machine-hours | 42,000 | 40,000 | |||||||
Direct labor wages | $ | 87,000 | $ | 84,400 | $ | 2,600 | U | ||
Supplies | 27,300 | 24,800 | 2,500 | U | |||||
Maintenance | 24,400 | 22,500 | 1,900 | U | |||||
Utilities | 22,100 | 21,100 | 1,000 | U | |||||
Supervision | 53,000 | 53,000 | 0 | ||||||
91,000 | 91,000 | 0 | |||||||
Total | $ | 304,800 | $ | 296,800 | $ | 8,000 | U | ||
“I just can’t understand all of these unfavorable variances,” Weston complained to the supervisor of another department. “When the boss called me in, I thought he was going to give me a pat on the back because I know for a fact that my department worked more efficiently last month than it has ever worked before. Instead, he tore me apart. I thought for a minute that it might be over the supplies that were stolen out of our warehouse last month. But they only amounted to a couple of hundred dollars, and just look at this report. Everything is unfavorable.”
Direct labor wages and supplies are variable costs; supervision and depreciation are fixed costs; and maintenance and utilities are mixed costs. The fixed component of the budgeted maintenance cost is $16,900; the fixed component of the budgeted utilities cost is $14,000.
Required:
2. Complete the performance report that will help Mr. Weston’s superiors assess how well costs were controlled in the machining department. (Round your intermediate calculations to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
![**Freemont Corporation—Machining Department**
**Flexible Budget Performance Report**
*For the Month Ended June 30*
| Item | Actual Results | Flexible Budget | Planning Budget |
|--------------------------|----------------|-----------------|-----------------|
| Machine-hours | 42,000 | | 40,000 |
| Direct labor wages | $87,000 | | $84,400 |
| Supplies | $27,300 | | $24,800 |
| Maintenance | $24,400 | | $22,500 |
| Utilities | $22,100 | | $21,100 |
| Supervision | $53,000 | | $53,000 |
| Depreciation | $91,000 | | $91,000 |
| Total | $304,800 | | $296,800 |
**Explanation:**
This table presents the budget performance report for Freemont Corporation's Machining Department for the month ending June 30. The report is segmented into three columns capturing the Actual Results, Flexible Budget, and Planning Budget.
- **Machine-hours**: The actual machine-hours used were 42,000, compared to the planned 40,000 hours.
- **Direct labor wages**: Actual spending was $87,000, slightly higher than the planned $84,400.
- **Supplies**: Costs totaled $27,300 against the planned $24,800.
- **Maintenance**: The actual expense was $24,400, exceeding the planned $22,500.
- **Utilities**: Costed $22,100, more than the planned $21,100.
- **Supervision and Depreciation**: Both matched the planned budgets at $53,000 and $91,000 respectively.
- **Total**: The actual total expenditure was $304,800, higher than the planned budget of $296,800.
The flexible budget column is intended for adjustments based on actual machine-hours, but is not populated here. The report highlights areas where costs exceeded the plan, providing insights into budgetary performance and efficiency.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6e9f74db-68ca-409f-99ca-c3b15e89955c%2F9fcb8015-2714-441e-9265-3a9d2a8cb0e3%2Fag6iajh_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)