a.
To prepare: The income statement and determine if it is profitable.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
a.
Explanation of Solution
The income statement for the company has been prepared:
Working note: Preparation of income statement and computation of net income has been shown below:
b.
To compute: Operating breakeven point units and dollars.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
b.
Explanation of Solution
Breakeven point is the point at which the company neither earns
The operating break even for the company has been computed:
Working note: The computation of operating break even for the company has been computed has been shown below:
c.
To compute: Operating breakeven point units with target profit.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
c.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
The operating break even with target profit for the company has been computed:
Working note: The computation of operating break even with target profit for the company has been computed has been shown below:
d.
To compute: Selling price that would lead to operating breakeven point using goal seek.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
d.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
Step 1: Enter all the details using the formulas
Working notes: Its computation using formulas has been shown below:
Step 2: Go to ‘data’ tab and click on ‘what-if analysis’ to select ‘goal seek’ function. Set the value of profit as 0 by changing the selling price. It has been shown below:
Step 3: Click on ‘OK’. The new selling price that would lead to operating profit would be computed.
e.
To compute: DOL, DFL and DCL.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
e.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
Leverage is the degree of change in component on the other component. It can be divided into three categories i.e. degree of operating leverage (DOL), degree of financial leverage (DFL) and degree of combined leverage (DCL).
Working notes: Calculation for each leverage has been shown below:
Want to see more full solutions like this?
Chapter 7 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- Artisan Metalworks has a bottleneck in their production that occurs within the engraving department. Jamal Moore, the COO, is considering hiring an extra worker, whose salary will be $55,000 per year, to solve the problem. With this extra worker, the company could produce and sell 3,000 more units per year. Currently, the selling price per unit is $25 and the cost per unit is $7.85. Using the information provided, calculate the annual financial impact of hiring the extra worker.arrow_forwardShelby Industries has a capacity to produce 45.000 oak shelves per year and is currently selling 40,000 shelves for $32 each. Martin Hardwoods has approached Shelby about buying 1,200 shelves for a new project and is willing to pay $26 each. The shelves can be packaged in bulk; this saves Shelby $1.50 per shelf compared to the normal packaging cost. Shelves have a unit variable cost of $27 with fixed costs of $350,000. Because the shelves dont require packaging, the unit variable costs for the special order will drop from $27 per shelf to $25.50 per shelf. Shelby has enough idle capacity to accept the contract. What is the minimum price per shelf that Shelby should accept for this special order?arrow_forwardDeuce Sporting Goods manufactures a high-end model tennis racket. The company’s forecasted income statement for the year, before any special orders, is as follows: Fixed costs included in the forecasted income statement are $400,000 in manufacturing cost of goods sold and $200,000 in selling expenses. A new client placed a special order with Deuce, offering to buy 1,000 tennis rackets for $100.00 each. The company will incur no additional selling expenses if it accepts the special order. Assuming that Deuce has sufficient capacity to manufacture 1,000 more tennis rackets, by what amount would differential income increase (decrease) as a result of accepting the special order? (Hint: First compute the variable cost per unit relevant to this decision.)arrow_forward
- At Stardust Gems, a faux gem and jewelry company, the setting department is a bottleneck. The company is considering hiring an extra worker, whose salary will be $67,000 per year, to ease the problem. Using the extra worker, the company will be able to produce and sell 9,000 more units per year. The selling price per unit is $20. The cost per unit currently is $15.85 as shown: What is the annual financial impact of hiring the extra worker for the bottleneck process?arrow_forwardCadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.arrow_forwardPoleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year: The selling price of Poleskis single product is 16. In recent years, profits have fallen and Poleskis management is now considering a number of alternatives. Poleski wants to have a net income next year of 250,000, but expects to sell only 120,000 units unless some changes are made. The president of Poleski has asked you to calculate the companys projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companys net income objective for next year. Also, compute Poleskis contribution margin per unit, contribution margin ratio, and break-even point for next year. The worksheet CVP has been provided to assist you. Note that the data from the problem have already been entered into the Data Section of the worksheet.arrow_forward
- Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Cutrate Furniture approached Jansen about buying 1,200 shelves for bookcases it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shell. The $1.50 per-shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320.000. However, the $130 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jansen accepts the special order? A. Profits will decrease by $1,200. B. Profits will increase by $31,200. C. Profits will increase by $600. D. Profits will increase by $7,200.arrow_forwardKerr Manufacturing sells a single product with a selling price of $600 with variable costs per unit of $360. The companys monthly fixed expenses are $72,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of January when they will sell 500 units. How many units will Kerr need to sell in order to realize a target profit of $120,000? What dollar sales will Kerr need to generate in order to realize a target profit of $120,000? Construct a contribution margin income statement for the month of June that reflects $600,000 in sales revenue for Kerr Manufacturing.arrow_forwardDelta Co. sells a product for $150 per unit. The variable cost per unit is $90 and fixed costs are $15,250. Delta Co.s tax rate is 36% and the company wants to earn $44,000 after taxes. What would be Deltas desired pre-tax income? What would be break-even point in units to reach the income goal of $44,000 after taxes? What would be break-even point in sales dollars to reach the income goal of $44000 after taxes? Create a contribution margin income statement to show that the break-even point calculated in B, generates the desired after-tax income.arrow_forward
- Nico Parts, Inc., produces electronic products with short life cycles (of less than two years). Development has to be rapid, and the profitability of the products is tied strongly to the ability to find designs that will keep production and logistics costs low. Recently, management has also decided that post-purchase costs are important in design decisions. Last month, a proposal for a new product was presented to management. The total market was projected at 200,000 units (for the two-year period). The proposed selling price was 130 per unit. At this price, market share was expected to be 25 percent. The manufacturing and logistics costs were estimated to be 120 per unit. Upon reviewing the projected figures, Brian Metcalf, president of Nico, called in his chief design engineer, Mark Williams, and his marketing manager, Cathy McCourt. The following conversation was recorded: BRIAN: Mark, as you know, we agreed that a profit of 15 per unit is needed for this new product. Also, as I look at the projected market share, 25 percent isnt acceptable. Total profits need to be increased. Cathy, what suggestions do you have? CATHY: Simple. Decrease the selling price to 125 and we expand our market share to 35 percent. To increase total profits, however, we need some cost reductions as well. BRIAN: Youre right. However, keep in mind that I do not want to earn a profit that is less than 15 per unit. MARK: Does that 15 per unit factor in preproduction costs? You know we have already spent 100,000 on developing this product. To lower costs will require more expenditure on development. BRIAN: Good point. No, the projected cost of 120 does not include the 100,000 we have already spent. I do want a design that will provide a 15-per-unit profit, including consideration of preproduction costs. CATHY: I might mention that post-purchase costs are important as well. The current design will impose about 10 per unit for using, maintaining, and disposing our product. Thats about the same as our competitors. If we can reduce that cost to about 5 per unit by designing a better product, we could probably capture about 50 percent of the market. I have just completed a marketing survey at Marks request and have found out that the current design has two features not valued by potential customers. These two features have a projected cost of 6 per unit. However, the price consumers are willing to pay for the product is the same with or without the features. Required: 1. Calculate the target cost associated with the initial 25 percent market share. Does the initial design meet this target? Now calculate the total life-cycle profit that the current (initial) design offers (including preproduction costs). 2. Assume that the two features that are apparently not valued by consumers will be eliminated. Also assume that the selling price is lowered to 125. a. Calculate the target cost for the 125 price and 35 percent market share. b. How much more cost reduction is needed? c. What are the total life-cycle profits now projected for the new product? d. Describe the three general approaches that Nico can take to reduce the projected cost to this new target. Of the three approaches, which is likely to produce the most reduction? 3. Suppose that the Engineering Department has two new designs: Design A and Design B. Both designs eliminate the two nonvalued features. Both designs also reduce production and logistics costs by an additional 8 per unit. Design A, however, leaves post-purchase costs at 10 per unit, while Design B reduces post-purchase costs to 4 per unit. Developing and testing Design A costs an additional 150,000, while Design B costs an additional 300,000. Assuming a price of 125, calculate the total life-cycle profits under each design. Which would you choose? Explain. What if the design you chose cost an additional 500,000 instead of 150,000 or 300,000? Would this have changed your decision? 4. Refer to Requirement 3. For every extra dollar spent on preproduction activities, how much benefit was generated? What does this say about the importance of knowing the linkages between preproduction activities and later activities?arrow_forwardNow assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.arrow_forwardMaple Enterprises sells a single product with a selling price of $75 and variable costs per unit of $30. The companys monthly fixed expenses are $22,500. What is the companys break-even point in units? What is the companys break-even point in dollars? Construct a contribution margin income statement for the month of September when they will sell 900 units. How many units will Maple need to sell in order to reach a target profit of $45,000? What dollar sales will Maple need in order to reach a target profit of $45,000? Construct a contribution margin income statement for Maple that reflects $150,000 in sales volume.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning