Problem 3 - Accounting

Question

The production supervisor of the Machining Department for Nell Company agreed to the following monthly static budget for the upcoming year: Nell Company Machining Department Monthly Production Budget Wages . . . . . . . . . . . . . . . . . . . . . . \(540,000 Utilities . . . . . . . . . . . . . . . . . . . . . . 36,000 Depreciation . . . . . . . . . . . . . . . . . . 60,000 ________ Total . . . . . . . . . . . . . . . . . . . . . . \)636,000 ________ ________ The actual amount spent and the actual units produced in the first three months of 2010 in the Machining Department were as follows: Amount Spent Units Produced January \(600,000 110,000 February 570,000 100,000 March 545,000 90,000 The Machining Department supervisor has been very pleased with this performance, since actual expenditures have been less than the monthly budget. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows: Wages per hour \)18.00 Utility cost per direct labor hour $1.20 Direct labor hours per unit 0.25 Planned unit production 120,000 a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. b. Compare the flexible budget with the actual expenditures for the first three months. What does this comparison suggest?

Step-by-Step Solution

Answer

The flexible budget revealed actual spending was higher than expected in January and February but matched March. Suggests fluctuating control over expenses.

Step 1: Calculate Flexible Budget for January

Begin by calculating the variable costs based on actual production for January. The costs involved are wages and utilities, both of which depend on the number of units produced. Calculate the wages by multiplying the units produced (110,000) by the direct labor hours per unit (0.25) and by the wages per hour ($18.00). Then, calculate utilities by multiplying the same total labor hours by the utility cost per hour ($1.20). Add the fixed depreciation cost ($60,000) to get the total flexible budget cost for January.

Step 2: Calculate Flexible Budget for February

Repeat the process for February. Use the units produced in February (100,000) and repeat the calculations to find the wages and utilities costs. Calculate wages as 100,000 units * 0.25 hours/unit * $18/hour and utilities as total hours * $1.20/hour. Add the fixed depreciation ($60,000).

Step 3: Calculate Flexible Budget for March

Perform the same calculation for March. Use the units produced in March (90,000) for your calculations. Determine the wages as 90,000 units * 0.25 hours/unit * $18/hour and utilities as total hours * $1.20/hour. Add the fixed depreciation cost ($60,000) to get the total for March.

Step 4: Compare Flexible Budget with Actual Expenditures

After calculating the flexible budget values for each month, compare each result with the actual expenditures. Subtract the flexible budget amount from the actual amount spent for each month to find if there was overspending or underspending. Analyze whether the actual expenditures were higher or lower than the budgeted amounts.

Key Concepts

Machining Department Costs

In a manufacturing setting such as Nell Company's Machining Department, costs are crucial to understand. These include both fixed and variable costs. Fixed costs remain constant regardless of production volume, such as depreciation, which is set at $60,000 monthly for this department.

Variable costs fluctuate with production levels and include items like wages and utilities. Wages in the Machining Department are calculated based on the hours worked, which in turn depends on the number of units produced. With wages set at $18 per hour and each unit requiring 0.25 direct labor hours, the costs can change significantly as production levels vary.

Similarly, utility costs, set at $1.20 per direct labor hour, are another variable cost. The Machining Department must constantly monitor these costs as they directly affect the department's monthly budget and overall financial performance.

Budget Variance Analysis

Budget variance analysis is an integral part of financial management. It helps businesses understand differences between planned financial outcomes and actual financial performance. In the context of Nell Company's Machining Department, comparing the flexible budget against actual expenditures allows for a deeper understanding of how well the department controls costs.

Variances can be favorable or unfavorable. A favorable variance occurs when actual costs are less than budgeted, while an unfavorable variance is when actual costs exceed budgeted amounts. For example, if the flexible budget for wages was set at $495,000 in January but actual wages spent were $600,000, this would indicate an unfavorable variance, suggesting more was spent than intended.

Regular variance analysis is essential for maintaining control over finances and ensuring that resources are used efficiently and effectively.

Cost Control in Manufacturing

Cost control in manufacturing is about managing expenses to remain within budgetary limits. Effective cost control involves constantly monitoring direct labor, material, and overhead costs to prevent overspending.

In Nell Company's Machining Department, leveraging tools like the flexible budget aids in cost control. By adjusting budget expectations based on actual production volumes, management can identify areas of overspending more accurately. For instance, if utilities consistently exceed the flexible budget despite stable production levels, it suggests inefficiencies that need addressing.

This proactive approach allows the department to refine operations, reduce unnecessary expenditures, and allocate resources where they are most needed. Implementing cost control measures ensures the department maintains profitability and remains competitive.

Production Budgeting

Production budgeting is the process of planning the production output in units and the associated costs over a certain period. For the Machining Department, this involves setting a static budget based on expected production and adjusting it through a flexible budget to reflect actual activity.

Static budgets set an expected production volume, but as seen in the case of Nell Company, the actual output can vary each month. A flexible budget accounts for this variability by adjusting variable costs for the number of units actually produced while keeping fixed costs like depreciation consistent.

This transition from a static to a flexible budget is crucial for reflecting the real circumstances and making informed financial decisions. Having a robust production budget allows for better strategic planning, aligns resources efficiently, and helps meet operational goals without unnecessary financial strain.