Break-even point and target profit measured

Assignment Help Accounting Basics
Reference no: EM131116563

  1. Break-Even Point and Target Profit Measured in Sales Dollars (Multiple Products). Hi-Tech Incorporated produces two different products with the following monthly data (these data are the same as the previous exercise).

  2. Cell GPS Total
    Selling price per unit $100 $400
    Variable cost per unit $ 40 $240
    Expected unit sales 21,000 9,000 30,000
    Sales mix 70 percent 30 percent 100 percent
    Fixed costs

    $1,800,000
  3. Assume the sales mix remains the same at all levels of sales.
  4. Required:
  5. Round your answers to the nearest hundredth of a percent and nearest dollar where appropriate. (An example for percentage calculations is 0.434532 = 0.4345 = 43.45 percent; an example for dollar calculations is $378.9787 = $379.)

  6. Using the information provided, prepare a contribution margin income statement for the month similar to the one in Figure 6.5 "Income Statement for Amy's Accounting Service".
  7. Calculate the weighted average contribution margin ratio.
  8. Find the break-even point in sales dollars.
  9. What amount of sales dollars is required to earn a monthly profit of $540,000?
  10. Assume the contribution margin income statement prepared in requirement a is the company's base case. What is the margin of safety in sales dollars?
  • 32.Changes in Sales Mix. Hi-Tech Incorporated produces two different products with the following monthly data (these data are the same as the previous exercise).


    Cell GPS Total
    Selling price per unit $100 $400
    Variable cost per unit $ 40 $240
    Expected unit sales 21,000 9,000 30,000
    Sales mix 70 percent 30 percent 100 percent
    Fixed costs

    $1,800,000

    Required:

    1. If the sales mix shifts to 50 percent Cell and 50 percent GPS, would the break-even point in units increase or decrease? Explain. (Detailed calculations are not necessary but may be helpful in confirming your answer.)
    2. Go back to the original projected sales mix. If the sales mix shifts to 80 percent Cell and 20 percent GPS, would the break-even point in units increase or decrease? Explain. (Detailed calculations are not necessary but may be helpful in confirming your answer.)
  • Break-Even Point and Target Profit Measured in Sales Dollars (Multiple Products). Hi-Tech Incorporated produces two different products with the following monthly data (these data are the same as the previous exercise).

    Cell GPS Total 
    Selling price per unit $100 $400 
    Variable cost per unit $ 40 $240 
    Expected unit sales 21,000 9,000 30,000 
    Sales mix 70 percent 30 percent 100 percent 
    Fixed costs $1,800,000
    Assume the sales mix remains the same at all levels of sales.

    Required

    Round your answers to the nearest hundredth of a percent and nearest dollar where appropriate. (An example for percentage calculations is 0.434532 = 0.4345 = 43.45 percent; an example for dollar calculations is $378.9787 = $379.)

    a.Using the information provided, prepare a contribution margin income statement for the month similar to the one in Figure 6.5 "Income Statement for Amy's Accounting Service".

    b.Calculate the weighted average contribution margin ratio.

    c.Find the break-even point in sales dollars.

    d.What amount of sales dollars is required to earn a monthly profit of $540,000?

    e.Assume the contribution margin income statement prepared in requirement a is the company's base case. What is the margin of safety in sales dollars?

    32.Changes in Sales Mix. Hi-Tech Incorporated produces two different products with the following monthly data (these data are the same as the previous exercise).

    Cell GPS Total 
    Selling price per unit $100 $400 
    Variable cost per unit $ 40 $240 
    Expected unit sales 21,000 9,000 30,000 
    Sales mix 70 percent 30 percent 100 percent 
    Fixed costs $1,800,000

    Required:

    a.If the sales mix shifts to 50 percent Cell and 50 percent GPS, would the break-even point in units increase or decrease? Explain. (Detailed calculations are not necessary but may be helpful in confirming your answer.)

    b.Go back to the original projected sales mix. If the sales mix shifts to 80 percent Cell and 20 percent GPS, would the break-even point in units increase or decrease? Explain. (Detailed calculations are not necessary but may be helpful in confirming your answer.)

    33.CVP Sensitivity Analysis (Single Product). Bridgeport Company has monthly fixed costs totaling $200,000 and variable costs of $40 per unit. Each unit of product is sold for $50. Bridgeport expects to sell 30,000 units each month (this is the base case).

    Required:

    For each of the independent situations in requirements b through d, assume that the number of units sold remains at 30,000.

    a.Prepare a contribution margin income statement for the base case.

    b.Refer to the base case. What would the operating profit be if the unit sales price increases 10 percent?

    c.Refer to the base case. What would the operating profit be if the unit variable cost decreases 20 percent?

    d.Refer to the base case. What would the operating profit be if total fixed costs decrease 20 percent?22.Make-or-Buy Decision. Coffee Mugs, Inc., currently manufactures ceramic coffee mugs. Management is interested in outsourcing production to a reputable manufacturing company that can supply the cups for $2 per unit. Coffee Mugs produces 100,000 mugs each year. Variable production costs are $0.80 and annual fixed costs are $150,000. If production is outsourced, all variable costs and 40 percent of annual fixed costs will be eliminated.

    Perform differential analysis using the format presented in Figure 7.2 "Make-or-Buy Differential Analysis for Best Boards, Inc." and explain which alternative is best, Alternative 1 (producing internally) or Alternative 2 (outsourcing).

    24.Customer Decision. Consulting Group LLC has two customers. Customer One generates $150,000 in income afterdirect fixed costs are deducted, and Customer Two generates $200,000 in income after direct fixed costs are deducted.Allocated fixed costs total $300,000 and are assigned 30 percent to Customer One and 70 percent to Customer Two based on several different cost drivers. Total allocated fixed costs remain the same regardless of how these costs are assigned to customers.

    Calculate the amount of allocated fixed costs to be assigned to each customer, and determine the profit or loss for each customer. Should Consulting Group drop Customer Two? Explain.

    1. 29.Net Present Value Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000. The company's required rate of return is 11 percent.
    2. Required:

    3. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.
    4. Find the net present value of this investment using the format presented in Figure 8.2 "NPV Calculation for Copy Machine Investment by Jackson's Quality Copies".
    5. Should the company purchase the blueprint machine? Explain.


    Net Present Value Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000.

    The company's required rate of return is 11 percent.

    Required:

    a.Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.

    b.Find the net present value of this investment using the format presented in Figure 8.2 "NPV Calculation for Copy Machine Investment by Jackson's Quality Copies".

    c.Should the company purchase the blueprint machine? Explain.
    30.Internal Rate of Return Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000. The company's required rate of return is 11 percent (this is the same data as the previous exercise).

    Required:
    a.Use trial and error to approximate the internal rate of return for this investment proposal. Round to the nearest dollar.
    b.Should the company purchase the blueprint machine? Explain.
    31. Payback Period Calculation. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000 (this is the same data as the previous exercise). Determine the payback period for this investment using the format shown in Table 8.1 "Calculating the Payback Period for Jackson's Quality Copies".

  • 33.CVP Sensitivity Analysis (Single Product). Bridgeport Company has monthly fixed costs totaling $200,000 and variable costs of $40 per unit. Each unit of product is sold for $50. Bridgeport expects to sell 30,000 units each month (this is the base case).

    Required:

    For each of the independent situations in requirements b through d, assume that the number of units sold remains at 30,000.

    1. Prepare a contribution margin income statement for the base case.
    2. Refer to the base case. What would the operating profit be if the unit sales price increases 10 percent?
    3. Refer to the base case. What would the operating profit be if the unit variable cost decreases 20 percent?
    4. Refer to the base case. What would the operating profit be if total fixed costs decrease 20 percent?
  • Internal Rate of Return Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000. The company's required rate of return is 11 percent (this is the same data as the previous exercise).

    Required:

    1. Use trial and error to approximate the internal rate of return for this investment proposal. Round to the nearest dollar.
    2. Should the company purchase the blueprint machine? Explain.
  • Payback Period Calculation. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000 (this is the same data as the previous exercise). Determine the payback period for this investment using the format shown in Table 8.1 "Calculating the Payback Period for Jackson's Quality Copies".
  • Reference no: EM131116563

    Questions Cloud

    Manufacturing complex comprises several operating units : Shale Oil Company’s Aston, Ohio, manufacturing complex comprises several operating units. These units process the crude oil that is pumped through and transform it into a multitude of hydrocarbon products. Determine the expected shutdown time and the..
    Find a recent newspaper or magazine article : Identify in your own words, what part of this article, website or ad appears like pseudopsychology and/or is pseudoscientific. Attach an electronic link to the source so others can read the content too.
    Restate in the form of a question : Restate in the form of a question. Use complete sentences.Ms. S is the sole shareholder and chief executive officer of SMJ Corporation. Ms. S's college roommate recently lost her job, is in financial difficulty, and has asked Ms. S for a loan. Ins..
    Explain the various types of insurance : Explain the various types of insurance available to you. Which insurances are of most importance to you now - and why? And what insurances do you think you might need in the future - explain why?
    Break-even point and target profit measured : Break-Even Point and Target Profit Measured in Sales Dollars (Multiple Products). Hi-Tech Incorporated produces two different products with the following monthly data (these data are the same as the previous exercise).
    How the rate of teenage smoking in the united states : In contrast, macroeconomics is concerned with things that affect the country as a whole, such as how the rate of teenage smoking in the United States would be affected by an increase in the tax on cigarettes."
    What is the critical path after the time reduction : A project manager is faced with the following activities and times associated with a building construction. Each activity can be crashed at most by 2 weeks. The cost associated with each week time reduction is given below. Which activities need to be..
    Basic heap operations : Heap This question is designed to help you get a better understanding of basic heap operations. You will be given queries of 3 types:• "1 v" -Add an element v to the heap.• "2 v" -Delete the element v from the heap.• "3" -Print the minimum of all the..
    Calculate the price elasticity of demand for winter wheat : Did the bumper harvest increase or decrease the total revenue of American wheat farmers? How could you have predicted this from your answer to part a?

    Reviews

    Write a Review

    Accounting Basics Questions & Answers

      Hark inc had cash sales of 400000 and credit sales of

    hark inc. had cash sales of 400000 and credit sales of 1100000. the accounts receivable balance increased 25000 during

      Determining the closing entries

    Royston Realty reported the following accounts on its income statement:

      What steps can an organization take to overcome

    Identify five major global issues that deter the spread of e-commerce. What steps can an organization take to overcome these barriers?

      Carrying value of the bonds payable

    The amount of the proceeds from the issuance that should be accounted for as the initial carrying value of the bonds payable would be.

      You have decided to start an engineering design firm and

    you have decided to start an engineering design firm and have borrowed 1 million at 5.25 compounded quarterly. this

      Rollins products company has had poor operating results for

    rollins products company has had poor operating results for the past two years. as the accountant for rollins products

      All overtime was worked by the early shift during may shift

    woodlands restaurant supply operates in two shifts paying a late-shift premium of 10 percent and an overtime premium of

      What is the per share par or stated value of the common

    Divide the class in three sections and divide each section into groups of three to five students. Assign each section one of the companies. Group Tasks Based on the company assigned to your group, answer the following questions: What is the per share..

      Transfer of title to inventory

    Identify whether the transactions described should be recorded by Cameron Companies during December 2014 (fill in the blank with a D) or January 2015 (fill in the blank with a J).

      Xyz is considering buying new production equipment the new

    xyz produces a water filter that attaches to the faucet and cleans all water that passes through the faucet. revenue

      How much will she accumulate in the fund

    Becky wants to invest $3,200 in a money market fund at the end of each year for three years in order to save money to go to college. If the prevailing rate of interest is 11% how much will she accumulate in the fund at the end of the three year pe..

      Donna weber age 24 and single provided the following

    donna weber age 24 and single provided the following information on her 2013 income tax return adjusted gross income

    Free Assignment Quote

    Assured A++ Grade

    Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

    All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd