D Frank Weston, supervisor of the Freemont Corporation's Machining Department, was 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 42,000 Planning Budget 40,000 Machine-hours Direct labor wages Supplies Maintenance ok Utilities Supervision Depreciation nices Total Variances $ 81,800 $ 79,600 $ 2,200 U 25,300 23,200 2,100 U 24,300 21,700 2,600 U 22,000 20,300 1,700 U 49,000 49,000 83,000 83,000 $ 285,400 $ 276,800 $ 8,600 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 my department worked more efficiently last month than ever before. Instead, he tore me apart. I thought for a minute 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 $15,300; the fixed component of the budgeted utilities cost is $13,600. Required: 2. Complete the performance report that will help Mr. Weston's superiors assess how well costs were controlled in the machining department. Note: Do not round your Intermediate calculations. Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero varlance). Input all amounts as positive values. Freemont Corporation-Machining Department Actual Results Flexible Budget Performance Report For the Month Ended June 30 Revenue and Spending Flexible Variances Budget Activity Variances Planning Budget Machine-hours 42.000 40.000 Direct labor wages 81.800 S 79.600 Supplies 25.300 23.200 Maintenance 24.300 21,700 Utilities 22.000 20,300 Supervision 49.000 49,000 Depreciation 83.000 83.000 Total $ 285.400 S 276,800

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter17: Job Order Costing (job)
Section: Chapter Questions
Problem 7R: Nutts management is very concerned about the cost of overhead on its jobs. When jobs are complete,...
icon
Related questions
Question

please answer in table format or i will dislike

D
Frank Weston, supervisor of the Freemont Corporation's Machining Department, was 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
42,000
Planning
Budget
40,000
Machine-hours
Direct labor wages
Supplies
Maintenance
ok
Utilities
Supervision
Depreciation
nices
Total
Variances
$ 81,800
$ 79,600
$ 2,200 U
25,300
23,200
2,100 U
24,300
21,700
2,600 U
22,000
20,300
1,700 U
49,000
49,000
83,000
83,000
$ 285,400
$ 276,800
$ 8,600 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 my department worked more efficiently last
month than ever before. Instead, he tore me apart. I thought for a minute 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 $15,300; the fixed component of the budgeted utilities cost is
$13,600.
Required:
2. Complete the performance report that will help Mr. Weston's superiors assess how well costs were controlled in the machining
department.
Note: Do not round your Intermediate calculations. Indicate the effect of each varlance by selecting "F" for favorable, "U" for
unfavorable, and "None" for no effect (l.e., zero varlance). Input all amounts as positive values.
Freemont Corporation-Machining Department
Actual
Results
Flexible Budget Performance Report
For the Month Ended June 30
Revenue and Spending Flexible
Variances
Budget
Activity Variances
Planning
Budget
Machine-hours
42.000
40.000
Direct labor wages
81.800
S
79.600
Supplies
25.300
23.200
Maintenance
24.300
21,700
Utilities
22.000
20,300
Supervision
49.000
49,000
Depreciation
83.000
83.000
Total
$ 285.400
S 276,800
Transcribed Image Text:D Frank Weston, supervisor of the Freemont Corporation's Machining Department, was 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 42,000 Planning Budget 40,000 Machine-hours Direct labor wages Supplies Maintenance ok Utilities Supervision Depreciation nices Total Variances $ 81,800 $ 79,600 $ 2,200 U 25,300 23,200 2,100 U 24,300 21,700 2,600 U 22,000 20,300 1,700 U 49,000 49,000 83,000 83,000 $ 285,400 $ 276,800 $ 8,600 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 my department worked more efficiently last month than ever before. Instead, he tore me apart. I thought for a minute 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 $15,300; the fixed component of the budgeted utilities cost is $13,600. Required: 2. Complete the performance report that will help Mr. Weston's superiors assess how well costs were controlled in the machining department. Note: Do not round your Intermediate calculations. Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero varlance). Input all amounts as positive values. Freemont Corporation-Machining Department Actual Results Flexible Budget Performance Report For the Month Ended June 30 Revenue and Spending Flexible Variances Budget Activity Variances Planning Budget Machine-hours 42.000 40.000 Direct labor wages 81.800 S 79.600 Supplies 25.300 23.200 Maintenance 24.300 21,700 Utilities 22.000 20,300 Supervision 49.000 49,000 Depreciation 83.000 83.000 Total $ 285.400 S 276,800
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,