Subject: acounting A manufacturer of kitcken appliances is preparing to set the price on a new blender. Implement the given model on a spreadsheet andconstruct a one-way data table to estimate the price for which profit is maximized.Total Profit=17,500 +2517P-2P²Find the price that produces the maximum profit on the range from $200 to $700.The manufacturer should set the price on the new blender at $(Type whole numbers.)for a maximum profit of $

To construct a one-way data table in Excel, we will need to create a range of prices to test and…

Answered: A manufacturer of kitcken appliances is…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 10EB: Keleher Industries manufactures pet doors and sells them directly to the consumer via their web...

See similar textbooks

Similar questions

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
Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:
More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next year. The projected income statement is as follows: Required: 1. Set up the given income statement on a spreadsheet (e.g., ExcelTM). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d). 2. Calculate the break-even units for each product for each of the preceding sales mixes.
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
Baghdad Company produces a single product. They have recently received the result of a market survey that indicates that they can increase the retail price of their product by 10% without losing customers or market share. All other costs will remain unchanged. If they enact the 10% price increase, what will be their new break-even point in units and dollars? Their most recent CVP analysis is:
Marchete Company produces a single product. They have recently received the results of a market survey that indicates that they can increase the retail price of their product by 8% without losing customers or market share. All other costs will remain unchanged. Their most recent CVP analysis is shown. If they enact the 8% price increase, what will be their new break-even point in units and dollars?
Jonathan was preparing a new product analysis for Brand X. On the basis of consumer research, he had already decided to sell the product at $10 retail. Retailers traditionally expected a 40% margin and wholesalers a 20% margin (N.B. Both are expressed as a % of the selling price). Brand X’s variable costs are $2 per unit, and total fixed costs are estimated to be $28,000. The forecasted volume at this price is 9,000 units. Will Johnny’s brand make a profit with this planned selling price?
a) Build a spreadsheet model that calculates profit or loss, using the principles of good spreadsheet design. If Harris makes 15,000 units, what is the resulting profit? b) Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? c) Construct a two-way data table with production volume as the column input and revenue per unit as the row input. Vary production volume from 0 to 100,000 in increments of 10,000. Input the revenue per units as $.75, $.85, $.95, $1.05. d) Use Goal Seek to find the exact breakeven point. Hint: To value: = 0.
Prepare and present a computation which illustrates what price should be selected in order to maximize profits when The company is considering the launch of a new product, component TDX 489 with the following information: Standard cost per box Variable cost 6,20 fixed cost 1,60 Total 7,80 Market research forecast of demand Selling price 13 12 11 10 9 Demand box 5000 6000 7200 11200 13400 The company only has enough production capacity to make 7000 boxes. However, it would be possible to purchase product TDX 489 from a subcontractor at £7.75 per box for orders up to 5000 boxes and £7 per box if the orders exceed 5000 boxes.
Tennis Products, Inc., produces three models of high-quality tennis rackets. The following table contains recent information on the sales, costs, and profitability of thethree models: The company is considering lowering the price of Model A to $27 in an effort toincrease the number of units sold. Based on the results of price changes that havebeen instituted in the past, Tennis Products’ chief economist estimates the arc priceelasticity of demand to be 2.5. Furthermore, she estimates the arc cross elasticity ofdemand between Model A and Model B to be approximately 0.5 and between ModelA and Model C to be approximately 0.2. Variable costs per unit are not expected tochange over the anticipated changes in volume.a. Evaluate the impact of the price cut on the (i) total revenue and (ii) contributionmargin of Model A. Based on this analysis, should the firm lower the price ofModel A?b. Evaluate the impact of the price cut on the (i) total revenue and (ii) contributionmargin for the entire…
After conducting a market research study, Magnificent Manufacturing decided to produce a new interior door to complement its exterior door line. It is estimated that the new interior door can be sold at a target price of $270. The annual target sales volume for interior doors is 29,000. Magnificent has target operating income of 40% of sales. What are target sales revenues? A. $4,698,000 B. $3,132,000 C. $10,962,000 D. $7,830,000
Your company has reviewed its new product that it introduced last year, and it has been found that the annual salesIt amounts to (8,000) units, the unit selling price is (140) dinars, and annual fixed costs are (27,000)dinars and the variable cost of the unit (60) dinars. You are asked to answer the following, using an analysisTie level at it:1- What is the current break-even size, calculate it algebraically and graphically.2- Calculate the profit under the current sales volume.3- To what extent can the sales volume be increased if the company wants to achieve net profits that increase?(25%) of the profit achieved under the current prevailing situation, that is, in light of the current sales volume?4- To what extent can fixed costs be reduced, if the company wants to achieve net profits that increase?(20) percent of the profit achieved under the current prevailing situation, that is, in light of the current sales volume?

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS