Question

In: Accounting

roblem 11-40 Profitability Analysis; Pro Forma Income Statement [LO 11-5, 11-7] [The following information applies to...

roblem 11-40 Profitability Analysis; Pro Forma Income Statement [LO 11-5, 11-7]

[The following information applies to the questions displayed below.]

RayLok Incorporated has invented a secret process to improve light intensity and, as a result, manufactures a variety of products related to this process. Each product is independent of the others and is treated as a separate profit/loss division. Product (division) managers have a great deal of freedom to manage their divisions as they think best. Failure to produce target divisional income is dealt with severely; however, rewards for exceeding one’s profit objective are, as one division manager described them, lavish.

The DimLok Division sells an add-on automotive accessory that automatically dims a vehicle’s headlights by sensing a certain intensity of light coming from a specific direction. DimLok has had a new manager in each of the 3 previous years because each manager failed to reach RayLok’s target profit level. Donna Barnes has just been promoted to manager and is studying ways to meet the current target profit for DimLok.

DimLok’s two profit targets for the coming year are $1,500,000 (30% return on the investment in the annual fixed costs of the division) and $40 (pre-tax) profit for each DimLok unit sold. Other constraints on the division’s operations are as follows:

  • Production cannot exceed sales because RayLok’s corporate advertising program stresses completely new product models each year, although the models might have only cosmetic changes.
  • DimLok’s selling price cannot vary above the current selling price of $240 per unit but may vary as much as 5% below $240.
  • A division manager can elect to expand fixed production or selling facilities; however, the target profit objective related to fixed costs is increased by 30% of the cost of any such expansion. Furthermore, a manager cannot expand fixed facilities by more than 40% of existing fixed cost levels without approval from the board of directors.

Donna is now examining data gathered by her staff to determine whether DimLok can achieve its target profits of $1,500,000 and $40 per unit. A summary of these reports shows the following:

  • Last year’s sales were 43,000 units at $240 per unit.
  • DimLok’s current manufacturing facility capacity is 53,000 units per year, but can be increased to 106,000 units per year with an increase of $1,130,000 in annual fixed costs.
  • Present variable costs amount to $100 per unit, but DimLok’s vendors are willing to offer direct materials discounts amounting to $15 per unit, beginning with unit number 73,001.
  • Sales can be increased up to 126,000 units per year by committing large blocks of product to institutional buyers at a discounted unit price of $225. However, this discount applies only to sales in excess of 53,000 units per year.

Donna believes that these projections are reliable and is now trying to determine what DimLok must do to meet the profit objectives assigned by RayLok’s board of directors.

Part 1

Required:

1. Determine the dollar amount of DimLok’s present annual fixed costs per year.

2. Determine the number of units that DimLok must sell to achieve both profit objectives. Be sure to consider all constraints in determining your answer.

3. Without regard to your answer in requirement 2, assume that Donna decides to sell 53,000 units at $240 per unit and 29,690 units at $225 per unit.

(a) Prepare a budgeted income statement (contribution format) for DimLok showing budgeted operating income.

(b) Would this projected operating income meet the stated profit objectives?

Solutions

Expert Solution

1.

Current Fixed Cost

Profit target ar 30% on fixed cost = $1,500,000

Fixed Cost is (Profit / 30%) = $5,000,000

2.

A Selling Price $240
B Variable Cost $100
C Contribution per unit (A-B) $140
D Profit per Dimlock $40
E Revised Contribution per Dimlok (C-D) $100
F

Fixed cost and profit needed

(5,000,000+1,500,000)

$6,500,000
G

Number of Dimlok to be sold

[(Fixed cost + profit) / contribution per dimlok]

(F/E)

$65000

Since units is exceeding capacity of 58000 units fixed cost will increase by $1,130,000 per year

A Revised Fixed cost ($5,000,000+$1,130,000) $6,130,000
B Profit at 30% on above(A x 30/100) $1,839,000
C Total (A+B) $7,969,000
D Contribution per Dimlok $100
E Numbrt of Dimlok to be sold (C/D) 79690 Units

Cross Checking

A Sales - (79690 units x $240) $19,125,600
B Less: Variable Cost (79690 x $100) $7,969,000
C Contribution (A-B) $11,156,600
D Fixed Cost (Revised) $6,130,000
E Net Profit (C-D) $5,026,600
F 30% on Fixed Cost $1,839,000
G Profit at $40 on Dimlok Sold (79690 x $40) $3,187,600
H Total Profit Achieved (F+G) $5,026,600

3a)

Budgeted Income Statement

Sales

(53000 x $240)

(29690 (WN-1) x $225)

Total Sales

$12,720,000

$6,680,250

$19,400,250

Less:Variable Cost

(73000 x $100)

(9690 (WN-2) x $(100-15)

Total Variable cost

$7,300,000

$823.650

($8,123,650)

Contribution $11,276,600
Less: Fixed Cost (Revised) ($6,130,000)
Net Profit $5,146,600

WN - 1

Given in Question 53000 units and 29690 units

So Total 82690 Units

Actually 29690 = 82690 - 53000

WN - 2

Variable Cost 73000 given in Question

So, 9690 = 82690 - 73000

3b)

Profit Objective is acheived

Profit Required

ROI on Fixed Cost - 30% = $1,839,000 ($6,130,000 x 30/100)

Profit if $40 per Dimlok = $3,307,600 ($82690 x $40)

Total Profit = $5,146,600 ($1,839,000 + $3,307,600)


Related Solutions

CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s Oil Service Company: Actual Sales 3rd QTR                    Estimated Sales 4th QTR July        $1,200,000                               Oct.                $3,000,000 Aug.       $1,400,000                              Nov. $5,000,000 Sept.     $1,600,000                              Dec.                $7,000,000 ****************************************************************** Actual Purchases 3rd QTR             Estimated Purchases 4th QTR July       $1,000,000                              Oct.                  $3,000,000 Aug.      $1,500,000                               Nov.    $4,000,000 Sept.     $2,000,000                               Dec.               $1,000,000 __________________________________________________________________ One-half (50 percent) of the sales each month are...
Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a...
Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 70,000 Operating Expenses $ 63,000 Common Stock 100,000 Cash Flow from Investing Activities 79,400 Notes...
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of...
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 15% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 65% of sales. Austin's tax rate, interest expense, and dividend payout ratio...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies...
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies to the questions displayed below.]    Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company...
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies...
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies to the questions displayed below.]    Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
Capital Budgeting Risk Analysis Project Instruction Create the pro forma income statement and estimate the cash...
Capital Budgeting Risk Analysis Project Instruction Create the pro forma income statement and estimate the cash flows for the following project. Decide whether to accept this project based on analysis of the NPV, Profitability Index, and IRR. Project Assumptions (Base Case) Equipment Life 6 Years Initial Equipment Cost $2,500,000 in year 0 Depreciation Straight Line Method Initial Revenue $1,000,000 in year 1 Revenue growth rate year 2 10% Revenue growth rate year 3 15% Revenue growth rate year 4 10%...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company for 2013 and an expected sales growth rate of 6.61 % for​ 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. ​(Round to three decimal​ places.) Sales Revenue $22,811,000 ____ % Cost of goods sold $-11,638,000 ___% Selling, general, and administrative expenses $-3,973,000 ____% Depreciation expenses $ -1,369,000...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT