Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John J Wild, Ken Shaw

25th Edition

1260247988, 978-1260247985

More Books

Students also viewed these Accounting questions