When Sharon Michaels arrived at her office at Waltham Motors Division on June 4, 1991, she was pleased to find the monthly performance report for May on her desk. Her job as division controller was to analyze results of operations each month and to prepare a narrative report on operations which was to be forwarded to corporate headquarters of Marco Corporation. Waltham Motors was a wholly owned subsidiary of Marco. The atmosphere at the division had been one of apprehensiveness throughout the month of May, and today would provide a chance to find out how well division management had compensated for the recent loss of a major customer contract. Waltham Motors manufactured electric motors of a single design which were sold to household appliance manufacturers. Originally a family-owned business, the division had been acquired in late 1990 by the Marco Corporation. Few changes had been made in either the company's operating procedures or systems, as Marco's management had chosen to delay changing procedures and systems until it was able to observe how well those in use at Waltham functioned. In April, Sharon Michaels, who had earned a master's degree in business administration in 1989, was transferred from the corporate headquarters controller's office to Waltham Motors. She was joined in late May David Marshall, also from Marco, who was to be the new division manager. Because of the lost contract, Michaels had asked the plant accountant to assemble the May figures as quickly as possible, but she was amazed that the\ were ready so soon. At headquarters, monthly results had rarely been available Waltham Motors Division able until several days after the end of each month. Even though the plant accountant had promised Sharon that he would be able to prepare the report in a single day with some overtime work, she was surprised that he had been able to do so. The division had prepared a budget for 1991 based on estimated sales and production costs. Because sales were not subject to seasonal fluctuations, the monthly budget was merely Vl2 of the annual budget. No adjustments had been made to the May budget when the contract was lost in April. A glance at the performance report confirmed Ms. Michael's worst fears. Instead of a budgeted profit of $91,200, the report showed the division had lost $7,200 in May. Even allowing for the lost volume, she had expected a better showing than indicated by the performance report. The plant accountant had attached the following memo to the report: June 3, 11:00 p.m. Sharon: As promised, here is the performance report for May. (I told you smaller is better; well show headquarters how efficient our plant accounting department is!) I am sure you'll find the bottom line as disappointing as I did, but plant performance really looks good, and the crews there may deserve our compliments. Note how they are at or under budget on every single cost except for supervision. I suspect that the unfavorable variance in supervision was caused directly by the work involved in controlling other costs.
Because I worked late, I am taking a day off tomorrow. The other data you re¬ quested are as follows:
1. There were no beginning and ending inventories in work in progress or finished goods.
2. Per unit standard costs used in budgeting this year was:
Direct material $ 6 direct labor 16
3. We are still using two hours per unit as standard labor time.
4. Actual material prices have been 5% less than expected.
5. Actual direct labor costs have been $8.20 per hour due to the increase in medical benefits granted last January.
Questions:1. Prepare a flexible budget showing what revenues and costs should have been for production of 14,000 units, assuming that selling price per unit, the variable costs per unit, and the total fixed costs were expected to remain the same as in the budget shown in Exhibit 1.
Exhibit 1 Performance Report, May 1991
Budget Actual Variance
Units 18,000 14,000 4,000
Sales $864,000 $686,000 $178,000 U
Variable manufacturing costs:
Direct material $108,000 $85,400 $22,600 F
Direct labor 288,000 246,000 42,000 F
Indirect labor 57,600 44,400 13,200 F
Idle time 14,400 14,200 200 F
Clean-up time 10,800 10,000 800 F
Miscellaneous supplies 5,200 4,000 1,200 F
Total variable manufacturing cost $484,000 $404,000 $80,000 F
Variable shopping costs $28,800 $28,000 $800 F
Total variable costs $512,800 $432,000 $80,800 F
Contribution margin $351,200 $254,000 $97,200 U
Nonvariable manufacturing costs:
Supervision $57,600 $58,800 $1,200 U
Rent 20,000 20,000 ----
Depreciation 60,000 60,000 ----
Other 10,000 10,400 ----
Total nonvariable manufacturing costs $148,000 $149,200 $1,200 U
Selling and administrative costs 112,000 112,000 ----
Total nonvariable and programmed costs $260,000 $261,200 $1,200 U
Operating income (loss) 91,200 (7,200) (98,400)
Budgeted Selling price per Unit | Is euail to | Toal slaes value/No. of units sold | |
864000/18000 | |||
48 | |||
Budgeted Variable cost per Unit | Is euail to | Total variable cost/No. of budgeted untits | |
512800/18000 | |||
28.48888889 | |||
Budget for 14,000 units with the same rate selling price per unit and Variable cost per unit | |||
Budget | |||
Units | Calcualtion | 14000 | |
Sales | 14000*48 | 672000 | |
Variable Manufacturing costs | |||
Direct material | (108000/18000)*14000 | 84000 | |
Direct Labour | (288000/18000)*14000 | 224000 | |
Indirect Labour | (57600/18000)*14000 | 44800 | |
Idle time | (14400/18000)*14000 | 11200 | |
Clean up time | (10800/18000)*14000 | 8400 | |
Misc.Supplies | (5200/18000)*14000 | 4044.444 | |
Total Variable manufacturing Costs | 376444.4 | ||
Variable shopping costs | (28800/18000)*14000 | 22400 | |
Total Variable costs | 398844.4 | ||
Contribution margin | 273155.6 | ||
Non Variable manufacturing costs | |||
Supervision | 57600 | ||
Rent | 20000 | ||
Depreciation | 60000 | ||
Other | 10000 | ||
Total Non Variable manufacturing costs | 148000 | ||
Selling and distribution costs | 112000 | ||
Total non Variable and programmed costs | 260000 | ||
Operating income | 13155.56 |
When Sharon Michaels arrived at her office at Waltham Motors Division on June 4, 1991, she...
Questions 1. Using budget data, how many motors would have to be sold for Waltham Motors Division to break even? 2. Using budget data, what was the total expected cost per unit if all manufacturing and shipping overhead (both variable and fixed) was allocated to planned production? What was the actual per unit cost of production and shipping? 3. Comment on the performance report and the plant accountant's analysis of results. How, if at all, would you suggest the performance...
Munoz Corporation has four divisions: the assembly division, the processing division, the machining division, and the packing division. All four divisions are under the control of the vice president of manufacturing. Each division has a manager and several departments that are directed by supervisors. The chain of command runs downward from vice president to division manager to supervisor. The processing division is composed of the paint and finishing departments. The May responsibility reports for the supervisors of these departments follow....
Carol Morgan manages the production division of Munoz Corporation. Ms. Morgan's responsibility report for the month of August follows: Budget Actual Variance Controllable costs Raw materials Labor Maintenance Supplies Total $18,720 11,660 3,500 2,450 $36,330 $22,320 16,940 5, 100 1,300 $45,660 $3,600 U 5, 280 U 1,600 U 1,150 F $9,330 U The budget had called for 3,600 pounds of raw materials at $5.20 per pound, and 3,600 pounds were used during August; however, the purchasing department paid $6.20 per...
Check my work Carol Morgan manages the production division of Perez Corporation. Ms. Morgan's responsibility report for the month of August follows: Budget Actual variance Controllable costs Raw materials Labor Maintenance Supplies Total $22,560 8.918 3,900 2,550 $37,928 $27,260 13.568 5,500 1,450 $47,778 $4,700 U 4,650 U 1,600 U 1,100 F $9,850 U The budget had called for 4,700 pounds of raw materials at $4.80 per pound, and 4,700 pounds were used during August; however, the purchasing department paid $5.80...
Carol Morgan manages the production division of Munoz Corporation. Ms. Morgan's responsibility report for the month of August follows: Budget Actual Variance Controllable costs Raw materials Labor Maintenance Supplies Total $15,910 9,936 3.300 2,000 $31,146 $19,610 14,766 5.100 950 $40,426 $ 3.700 U 4,830 0 1.800 U 1.050 F 39.280 0 The budget had called for 3,700 pounds of raw materials at $4,30 per pound, and 3,700 pounds were used during August; however, the purchasing department paid $5.30 per pound...
Carol Morgan manages the production division of Munoz Corporation. Ms. Morgan's responsibility report for the month of August follows: Budget Variance Actual Controllable costs $19,610 14,766 5,100 950 Raw materials Labor $15,910 9,936 3,300 2,000 $3,700 U 4,830 1,800 1,050 F Maintenance Supplies $9,280 $31,146 $40,426 Total The budget had called for 3,700 pounds of raw materials at $4.30 per pound, and 3,700 pounds were used during August; however the purchasing department paid $5.300 per pound for the materials. The...
*Problem 6-30 Lexi Belcher picked up the monthly report that Irvin Santamaria left on her desk. She smiled as her eyes went straight to the bottom line of the report and saw the favorable variance for operating income, confirming her decision to push the workers to get those last 270 cases off the production line before the end of the month. But as she glanced over the rest of numbers, Lexi couldn't help but wonder if there were errors in...
Lexi Belcher picked up the monthly report that Irvin Santamaria left on her desk. She smiled as her eyes went straight to the bottom line of the report and saw the favorable variance for operating income, confirming her decision to push the workers to get those last 300 cases off the production line before the end of the month. But as she glanced over the rest of numbers, Lexi couldn't help but wonder if there were errors in some of...
Flexible budget memo Understanding Flexible Budgets You have been a loyal employee of NRG Corporation for 16 years. In December of 2018, you were excited to be promoted to Profit Center Manager, where you gained the responsible for the profits and losses of NRG's time of energy drink products. The product line's master budget was created and approved prior to your start date as the manager, but with the entire fiscal year 2019 still ahead, you had the chance to...
Please help Understanding Flexible Budgets You have been a loyal employee of NRG Corporation for 16 years. In December of 2018, you were excited to be promoted to Profit Center Manager, where you gained the responsible for the profits and losses of NRG's time of energy drink products. The product line's master budget was created and approved prior to your start date as the manager, but with the entire fiscal year 2019 still ahead, you had the chance to prove...