Question
Lei Chang was hired as chief executive office (CEO) in late November by the board of directors of Global Images Corporation, a company that produces
Lei Chang was hired as chief executive office (CEO) in late November by the board of directors of Global Images Corporation, a company that produces an advanced global positioning system (GPS) device. The previous CEO had been fired by the board due to a series of shady business practices including shipping defective GPS devices to dealers.
Chang felt that his first priority on the job was to restore employee morale - which had suffered during the previous CEO's tenure. He was particularly anxious to build a sense of trust between himself and the company's employees. His second priority was to prepare the budget for the coming year, which the board of directors wanted to review in their December 15 meeting.
After hammering out the details in meetings with key managers, Chang was able to put together a budget that he and his management team felt the company could realistically meet during the coming year. That budget appears below:
Basic budget data:
Units in beginning inventory 0
Units produced 400,000
Units sold 400,000
Units in ending inventory 0
Variable costs per unit:
Direct materials (4 parts @ $14.30 per part) $ 57.20
Direct labor (.5 hrs @ $30 per hour) 15.00
Variable manufacturing overhead 5.00
Variable selling and administrative* 10.00
Total variable costs per unit $ 87.20
Fixed costs:
Fixed manufacturing overhead** $ 6,888,000
Fixed selling and administrative 4,560,000
Total fixed costs $11,448,000
*Variable selling and administrative expenses are related to commission and shipping costs.
**Fixed manufacturing overhead is applied on the basis of units produced. Since Global Images has only one product they chose the simplest allocation method available. As a result, fixed manufacturing overhead per unit is determined by dividing the total fixed manufacturing overhead costs by the number of units produced.
Per unit product cost:
Direct materials $57.20
Direct labor 15.00
Variable MO 5.00
Fixed MO per unit ($6,888,000/400,000) 17.22
Total product cost per unit $94.42
Budgeted Income Statement:
Sales (400,000 units x $120 per unit) $48,000,000
Less costs of goods sold
Beginning inventory $ -0-
Add costs of goods manufactured
(400,000 x $94.42 per unit) 37,768,000
Cost of good available for sale 37,768000
Less ending inventory -0- 37,768,000
Gross margin 10,232,000
Less selling and administrative
Variable selling and administrative
(400,000 x $10 per unit) 4,000,000
Fixed selling and administrative 4,560,000 8,560,000
Net Income $ 1,672,000
After Chang presented the budget proposal to the board of directors, they made it clear that this budget was not as ambitious as they had hoped. The most influential member of the board stated that "managers should have to stretch to meet profit goals." After some discussion, the board decided to set a profit goal of $2,000,000 for the coming year. To provide strong incentives and a win-win situation, the board agreed to pay out bonuses to top managers of $10,000 to $25,000 each if this profit goal was eventually met. The bonus would be all or nothing. If actual net operating income turned out to be $2,000,000 or more, the bonus would be paid. Otherwise, no bonus would be allowed.
As a result of the board's new goal, Chang and his team revised the budget. They determined that to meet the $2,000,000 profit goal, the company would have to produce and sell 410,000 units. The new budget appears below:
Updated Budgeted Income Statement:
Sales (410,000 units x $120 per unit) $49,200,000
Less costs of goods sold
Beginning inventory $ -0-
Add costs of goods manufactured
(400,000 x $94 per unit) 38,540,000
Cost of good available for sale 38,540000
Less ending inventory -0- 38,540,000
Gross margin 10,660,000
Less selling and administrative
Variable selling and administrative
(410,000 x $10 per unit) 4,100,000
Fixed selling and administrative 4,560,000 8,660,000
Net Income $ 2,000,000
Per unit product cost:
Direct materials $57.20
Direct labor 15.00
Variable MO 5.00
Fixed MO per unit ($6,888,000/410,000) 16.80
Total product cost per unit $94.00
Unfortunately, by the end of October of the next year it had become clear that the company would not be able to make the $2,000,000 target profit. In fact, it looked like the company would wind up the year as originally planned, with sales of 400,000 units, no ending inventories, and a profit in excess of $1,600,000 but would not be as much as $2,000,000. Actual results for the ten months ending October 31 are presented below:
Sales (340,000 units x $120 per unit) $40,800,000
Less costs of goods sold
Beginning inventory $ -0-
Add costs of goods manufactured
(340,000 x $94.55 per unit) 32,147,000
Cost of good available for sale 32,147,000
Less ending inventory -0- 32,147,000
Gross margin 8,653,000
Less selling and administrative
Variable selling and administrative
(340,000 x $10 per unit) 3,400,000
Fixed selling and administrative 3,800,000 7,200,000
Net Income $ 1,453,000
In addition to potentially not meeting the higher sales target, the product cost per unit is higher than the original expectation of $94.42 which was estimated using 400,000 units of production. Since Global Images is on track to produce and sell 400,000 this increase in costs seems like further bad news and a bit confusing. At the beginning of the year, a number of initiatives were undertaken to help improve profitability. First, the Purchasing Manager found a new vender that would supply parts at a much lower cost than the prior supplier.1 Second, the Production Manager reorganized the labor force, replacing some junior technicians with more senior technicians. While it was expected that this action would increase the average hourly wage for direct labor, it was expected that the senior technicians would be so much more efficient that the increase in efficiency would more than make up for the higher pay. In addition, the senior technicians would increase the quality, reduce defects, rejects and reworked units.
Given the higher product cost and lower sales, it seemed clear that Global would not reach the $2,000,000 net income goal and the managers would not receive a bonus. As a result, several managers who were reluctant to lose their year-end bonuses approached Chang and suggested that the company could still show a profit of $2,000,000. The managers pointed out that at the present rate of sales, there was enough capacity to produce tens of thousands of additional GPS Devices for the warehouse and thereby shift fixed manufacturing overhead to another year.
Chang felt a considerable amount of pressure to make a decision. His managers feel that their bonus is in jeopardy and there are only two months left in the year and some type of decision must be made soon. Before he makes a decision on the production proposal he wants to get an idea on how well they are doing right now and why they have not achieved the expected benefits from the two initiatives. Further, he wants to get an idea of what projected profits will be if they continue with the current costs and sell 400,000 units. Finally, he wants to understand the implications of his managers' suggestion to increase production and inventory. As a result, he requested and obtained data from the accounting department regarding the break-down of product costs so far this year.
1 The standard cost per part is based on the original supplier's prices.
Units produced 340,000
Direct material purchases 1,500,000 parts
Total direct material costs for purchases $20,700,000
Direct materials used in production 1,400,800 parts
Direct labor hours worked 173,400
Direct labor costs $ 5,375,000
Total variable manufacturing
overhead costs $ 1,700,000
Total fixed manufacturing
Overhead costs $ 5,740,000
Quality Measures:
Standard2 Actual
Rejected units as a percent
of units produced3 .5% 2.5%
Reworked units as a percent
of units produced 4 1% 3%
2. If sales are 400,000 units for the year and the selling price and cost structure remain the same, estimated how many units would have to be produced in order to show a profit of at least $2,000,000 under absorption costing.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started