/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 3 The production supervisor of the... [FREE SOLUTION] | 91影视

91影视

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 鈥渇lex鈥 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?

Short Answer

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

Step by step solution

01

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.
02

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).
03

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.
04

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.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91影视!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

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.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Office Mate Supplies Inc. has "cash and carry" customers and credit customers. Office Mate estimates that \(25 \%\) of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, \(20 \%\) pay their accounts in the month of sale, while the remaining \(80 \%\) pay their accounts in the month following the month of sale. Projected sales for the first three months of 2010 are as follows: \(\begin{array}{lr}\text { August } & \$ 250,000 \\ \text { September } & 290,000 \\ \text { October } & 270,000 \\ & \\ \text { nce on July 31, 2010, was } \$ 200,000 .\end{array}\) The Accounts Receivable balance on July 31, 2010, was \(\$ 200,000\). Prepare a schedule of cash collections from sales for August, September, and October.

Sleep-EZ Suites, Inc., operates a downtown hotel property that has 250 rooms. On average, \(72 \%\) of Sleep-EZ Suites' rooms are occupied on weekdays, and \(48 \%\) are occupied during the weekend. The manager has asked you to develop a direct labor budget for the housekeeping and restaurant staff for weekdays and weekends. You have determined that the housekeeping staff requires 40 minutes to clean each occupied room. The housekeeping staff is paid \(\$ 10\) per hour. The restaurant has five full-time staff (eighthour day) on duty, regardless of occupancy. However, for every 60 occupied rooms, an additional person is brought in to work in the restaurant for the eight-hour day. The restaurant staff is paid \(\$ 8\) per hour. Determine the estimated housekeeping, restaurant, and total direct labor cost for an average weekday and weekend day. Format the budget in two columns, labeled as weekday and weekend day.

Venus Candy Company budgeted the following costs for anticipated production for September 2010: \(\begin{array}{lrlr}\text { Advertising expenses } & \$ 275,000 & \text { Production supervisor wages } & \$ 132,000 \\ \text { Manufacturing supplies } & 15,000 & \text { Production control salaries } & 35,000 \\ \text { Power and light } & 44,000 & \text { Executive officer salaries } & 280,000 \\\ \text { Sales commissions } & 300,000 & \text { Materials management salaries } & 38,000 \\ \text { Factory insurance } & 26,000 & \text { Factory depreciation } & 21,000\end{array}\) Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation are the only factory fixed costs.

Anticipated sales for Sure Grip Tire Company were 42,000 passenger car tires and 15,000 truck tires. There were no anticipated beginning or ending finished goods inventories for either product. Rubber and steel belts are used in producing passenger car and truck tires according to the following table: \begin{tabular}{lrl} & Passenger Car & Truck \\ \hline Rubber & \(30 \mathrm{lbs}\). per unit & \(70 \mathrm{lbs}\). per unit \\ Steel belts & \(4 \mathrm{lbs}\). per unit & \(10 \mathrm{lbs}\). per unit \end{tabular} The purchase prices of rubber and steel are \(\$ 3.20\) and \(\$ 4.20\) per pound, respectively. The desired ending inventories of rubber and steel belts are 40,000 and 10,000 pounds, respectively. The estimated beginning inventories for rubber and steel belts are 46,000 and 8,000 pounds, respectively. Prepare a direct materials purchases budget for Sure Grip Tire Company for the year ended December 31, \(2010 .\)

Accu-Weight, Inc. produces a small and large version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: $$ \begin{array}{lcc} & \text { Small Scale } & \text { Large Scale } \\ \hline \text { North Region unit sales } & 25,000 & 34,000 \\ \text { South Region unit sales } & \underline{27,000} & \underline{32,500} \\\ \text { Total } & 52,000 & 66,500 \end{array} $$ The finished goods inventory estimated for May 1, 2011, for the small and large scale models is 1,500 and 2,300 units, respectively. The desired finished goods inventory for May 31, 2011, for the small and large scale models is 1,100 and 2,500 units, respectively. Prepare a production budget for the small and large scales for the month ended May 31, 2011.

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.