d Analysis of variances: Materials variances Efficiency Total Price include formula for materials price variance here include formula for materials efficiency variance here Labor variances Labor rate Efficiency Total include formula for labor rate variance here include formula for labor efficiency variance here Efficiency Variable overhead variances Spending Total include formula for spending variance here include formula for labor efficiency variance here Analysis:
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
I could use some help with (d) (at the bottom) on this.
Porter Corporation has just hired Bill Harlow as its new controller. Although Harlow has had little formal accounting training, he professes to be highly experiences, having learned accounting "the hard way" in the field. At the end of his first month's work, Harlow prepared the following performance report:
| Total Actual Costs | Total |
Variances | |
| Direct materials | $216,630 | $237,600 | $20,970 F |
| Direct labor | 119,340 | 132,000 | 12,660 F |
| Variable |
63,000 | 66,000 | 3,000 |
| Fixed overhead | 184,000 | 184,000 | |
| $582,970 | $619,600 | $36,630 F |
In his presentation at Porter's month-end management meeting, Harlow indicated that things were going "fantastically." "The figures indicate," he said, "that the firm is beating its budget in all cost categories." This good news made everyone at the meeting happy and furthered Harlow's acceptance as a member of the management team.
After the management meeting, Susan Jones, Porter's general manager, asked you, as an independent consultant, to review Harlow's report. Jones' concern stemmed from the fact that Porter has never operated as favorably as Harlow's report seems to imply, and she cannot explain the apparent significant improvement.
While review Harlow's report, you are provided the following cost and operating data for June: Porter has a monthly normal capacity of 11,000 direct labor hours or 8,800 units of product. Standard costs per unit for its only product are direct materials 3 pounds at $9 per pound; direct labor, 1.25 hours at $12 per hour; and variable overhead rate per direct labor hour of $6. During June, Porter produced 8,000 units of product, using 24,900 pounds of materials costing $8.70 each, 10,200 direct labor hours at an average rate of $11.70 each, and incurred variable overhead costs of $63,000 and fixed overhead costs of $184,000.
After reviewing Porter's June cost data, you tell Harlow that his cost report contains a classic budgeting error, and you explain how he can remedy it. In response to your suggestion, Harlow revises his report as follows:
| Total Actual Costs | Total Budgeted Costs | Variances | |
| Direct materials | $216,630 | $216,000 | $630 U |
| Direct labor | 119,340 | 120,000 | 660 F |
| Variable overhead | 63,000 | 60,000 | 3,000 U |
| Fixed overhead | 184,000 | 184,000 | |
| $582,970 | $580,000 | $2,970 U |
Harlow's revised report is accompanied by remarks expressing regret at the oversight in the original report.
Required
In your role as consultant,
d) Further analyze Harlow's revised variances, isolating underlying potential causal factors. How do your analyses indicate bases for concern to management?
See the spreadsheet below.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
