Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
Bartleby Related Questions Icon

Related questions

Question
100%

Hyperion, Inc. currently sells its latest high-speed color printer, the Hyper 500, for $350. It plans to lower the price to $300 next year. Its cost of goods sold for the Hyper 500 is $200 per unit, and thi year's sales are expected to be 20,000 units.

a) Suppose that if Hyperion drops the price to $300 immediatley, it can increase this year's sales by 25% to 25,000 units. What would be the incremental impact on this eyar's EBIT of such a price drop?

b) Suppose that for each printer sold, Hyperion expects additional sales of $75 per year on ink cartridges for the next years, and Hyperion has a gross profit margin of 70% on ink cartridges. What is the incremntal impact on EBIT for the next three years of a priced drop this year?

Expert Solution
Check Mark
Blurred answer
Knowledge Booster
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • Deuce 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.)
    Poleski 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.
    Variety Artisans has a bottleneck in their production that occurs within the engraving department. Arjun Naipul, the COO, is considering hiring an extra worker, whose salary will be $45,000 per year, to solve the problem. With this extra worker, the company could produce and sell 3,500 more units per year. Currently, the selling price per unit is $18 and the cost per unit is $5.85. Using the information provided, calculate the annual financial impact of hiring the extra worker.
  • 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.
    Dimitri Designs has capacity to produce 30,000 desk chairs per year and is currently selling all 30,000 for $240 each. Country Enterprises has approached Dimitri to buy 800 chairs for $210 each. Dimitris normal variable cost is $165 per chair, including $50 per unit in direct labor per chair. Dimitri can produce the special order on an overtime shift, which means that direct labor would be paid overtime at 150% of the normal pay rate. The annual fixed costs will be unaffected by the special order and the contract will not disrupt any of Dimitris other operations. What will be the impact on profits of accepting the order?
    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?
  • Shelby 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?
    Shonda & Shonda is a company that does land surveys and engineering consulting. They have an opportunity to purchase new computer equipment that will allow them to render their drawings and surveys much more quickly. The new equipment will cost them an additional $1.200 per month, but they will be able to increase their sales by 10% per year. Their current annual cost and break-even figures are as follows: A. What will be the impact on the break-even point if Shonda & Shonda purchases the new computer? B. What will be the impact on net operating income if Shonda & Shonda purchases the new computer? C. What would be your recommendation to Shonda & Shonda regarding this purchase?
    Flanders Manufacturing is considering purchasing a new machine that will reduce variable costs per part produced by $0.15. The machine will increase fixed costs by $18,250 per year. The information they will use to consider these changes is shown here.
  • Now 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.
    Schylar Pharmaceuticals, Inc., plans to sell 130,000 units of antibiotic at an average price of 22 each in the coming year. Total variable costs equal 1,086,800. Total fixed costs equal 8,000,000. (Round all ratios to four significant digits, and round all dollar amounts to the nearest dollar.) Required: 1. What is the contribution margin per unit? What is the contribution margin ratio? 2. Calculate the sales revenue needed to break even. 3. Calculate the sales revenue needed to achieve a target profit of 245,000. 4. What if the average price per unit increased to 23.50? Recalculate: a. Contribution margin per unit b. Contribution margin ratio (rounded to four decimal places) c. Sales revenue needed to break even d. Sales revenue needed to achieve a target profit of 245,000
    Oberweis Dairy switched from delivery trucks with regular gasoline engines to ones with diesel engines. The diesel trucks cost $6,000 more than the ordinary gasoline trucks but costs $1,800 per year less to operate. Assume that Oberweis saves the operating costs at the end of each month. If Oberweis uses a discount rate of 1% per month, approximately how many months, at a minimum, must the diesel trucks remain in service for the switch to be sensible?
    • SEE MORE QUESTIONS
    Recommended textbooks for you
  • Excel Applications for Accounting Principles
    Accounting
    ISBN:9781111581565
    Author:Gaylord N. Smith
    Publisher:Cengage Learning
    EBK CONTEMPORARY FINANCIAL MANAGEMENT
    Finance
    ISBN:9781337514835
    Author:MOYER
    Publisher:CENGAGE LEARNING - CONSIGNMENT
    Cornerstones of Cost Management (Cornerstones Ser...
    Accounting
    ISBN:9781305970663
    Author:Don R. Hansen, Maryanne M. Mowen
    Publisher:Cengage Learning
  • Principles of Accounting Volume 2
    Accounting
    ISBN:9781947172609
    Author:OpenStax
    Publisher:OpenStax College
    Intermediate Financial Management (MindTap Course...
    Finance
    ISBN:9781337395083
    Author:Eugene F. Brigham, Phillip R. Daves
    Publisher:Cengage Learning
    Financial Accounting Intro Concepts Meth/Uses
    Finance
    ISBN:9781285595047
    Author:Weil
    Publisher:Cengage
  • Excel Applications for Accounting Principles
    Accounting
    ISBN:9781111581565
    Author:Gaylord N. Smith
    Publisher:Cengage Learning
    EBK CONTEMPORARY FINANCIAL MANAGEMENT
    Finance
    ISBN:9781337514835
    Author:MOYER
    Publisher:CENGAGE LEARNING - CONSIGNMENT
    Cornerstones of Cost Management (Cornerstones Ser...
    Accounting
    ISBN:9781305970663
    Author:Don R. Hansen, Maryanne M. Mowen
    Publisher:Cengage Learning
    Principles of Accounting Volume 2
    Accounting
    ISBN:9781947172609
    Author:OpenStax
    Publisher:OpenStax College
    Intermediate Financial Management (MindTap Course...
    Finance
    ISBN:9781337395083
    Author:Eugene F. Brigham, Phillip R. Daves
    Publisher:Cengage Learning
    Financial Accounting Intro Concepts Meth/Uses
    Finance
    ISBN:9781285595047
    Author:Weil
    Publisher:Cengage