Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Faldo Company produces a single product. The projected income statement for the coming year, based on sales of 200,000 units, is as follows: Required: 1. Compute the unit contribution margin and the units that must be sold to break even. Suppose that 30,000 units are sold above the break-even point. What is the profit? 2. Compute the contribution margin ratio and the break-even point in dollars. Suppose that revenues are 200,000 greater than expected. What would the total profit be? 3. Compute the margin of safety in sales revenue. 4. Compute the operating leverage. Compute the new profit level if sales are 20 percent higher than expected. 5. How many units must be sold to earn a profit equal to 10 percent of sales? 6. Assume the income tax rate is 40 percent. How many units must be sold to earn an after-tax profit of 180,000?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_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_forward
- Maple 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_forwardSuppose that a company is spending 60,000 per year for inspecting, 30,000 for purchasing, and 40,000 for reworking products. A good estimate of nonvalue-added costs would be a. 70,000. b. 130,000. c. 40,000. d. 90,000. e. 100,000.arrow_forwardKeleher 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:arrow_forward
- Klamath Company produces a single product. The projected income statement for the coming year is as follows: Required: 1. Compute the unit contribution margin and the units that must be sold to break even. 2. Suppose 10,000 units are sold above break-even. What is the operating income? 3. Compute the contribution margin ratio. Use the contribution margin ratio to compute the break-even point in sales revenue. (Note: Round the contribution margin ratio to four decimal places, and round the sales revenue to the nearest dollar.) Suppose that revenues are 200,000 more than expected for the coming year. What would the total operating income be?arrow_forwardMarlin Motors sells a single product with a selling price of $400 with variable costs per unit of $160. The companys monthly fixed expenses are $36,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 November when they will sell 130 units. How many units will Marlin need to sell in order to realize a target profit of $48,000? What dollar sales will Marlin need to generate in order to realize a target profit of $48.000? Construct a contribution margin income statement for the month of February that reflects $200,000 in sales revenue for Marlin Motors.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
- Wellington, Inc., reports the following contribution margin income statement for the month of May. The company has the opportunity to purchase new machinery that will reduce its variable cost per unit by $10 but will increase fixed costs by 20%. Prepare a projected contribution margin income statement for Wellington, Inc., assuming it purchases the new equipment. Assume sales level remains unchanged.arrow_forwardA company has prepared the following statistics regarding its production and sales at different capacity levels. Total costs: 1. At what point is break-even reached in sales dollars? In units? (Hint: Use the capacity level to determine the number of units.) 2. If the company is operating at 60% capacity, should it accept an offer from a customer to buy 10,000 units at 3 per unit?arrow_forwardLotts Company produces and sells one product. The selling price is 10, and the unit variable cost is 6. Total fixed cost is 10,000. Required: 1. Prepare a CVP graph with Units Sold as the horizontal axis and Dollars as the vertical axis. Label the break-even point on the horizontal axis. 2. Prepare CVP graphs for each of the following independent scenarios: (a) Fixed cost increases by 5,000, (b) Unit variable cost increases to 7, (c) Unit selling price increases to 12, and (d) Fixed cost increases by 5,000 and unit variable cost is 7.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY