5 20 points eBook Print Following an exponential distribution, the average lifespan of a smartphone battery is 2.3 years. The battery manufacturer wants to offer a warranty for its customers to receive a free replacement if the battery fails during the first year. Each battery generates a profit of $10.85, and the replacement cost is $6.35. Use Excel's Analysis ToolPak, with a seed of 1, to develop a Monte Carlo simulation for the lifespan of 100 batteries. a. What is the expected total cost of this warranty program? Note: Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places. The expected total cost of the warranty program for every 100 batteries sold References b. In order to cover the cost of the warranty program, how many additional battery units does the company need to sell? Note: Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places. Additional batteries the company needs to sell for every 100 batteries currently sold

5 20 points eBook Print Following an exponential distribution, the average lifespan of a smartphone battery is 2.3 years. The battery manufacturer wants to offer a warranty for its customers to receive a free replacement if the battery fails during the first year. Each battery generates a profit of $10.85, and the replacement cost is $6.35. Use Excel's Analysis ToolPak, with a seed of 1, to develop a Monte Carlo simulation for the lifespan of 100 batteries. a. What is the expected total cost of this warranty program? Note: Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places. The expected total cost of the warranty program for every 100 batteries sold References b. In order to cover the cost of the warranty program, how many additional battery units does the company need to sell? Note: Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places. Additional batteries the company needs to sell for every 100 batteries currently sold

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 8EB: Shonda & Shonda is a company that does land surveys and engineering consulting. They have an...

See similar textbooks

Similar questions

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?
Reset cells to their initial values. Sweet Pleasures, Inc., is considering undertaking a 1,200 per month advertising campaign to promote Sweet Pleasures chocolate as exclusive and extraordinarily tasty. What price (dollars and cents) would Sweet Pleasures have to charge for each box to be able to pay for the campaign, pay back the 10,000 note, and have 15,000 left over at the end of April? (Try different prices in cell C9.) Sales price ___
Austins cell phone manufacturer wants to upgrade their product mix to encompass an exciting new feature on their cell phone. This would require a new high-tech machine. You are excited about his new project and are recommending the purchase to your board of directors. Here is the information you have compiled in order to complete this recommendation: According to the information, the project will last 10 years and require an initial investment of $800,000, depreciated with straight-line over the life of the project until the final value is zero. The firms tax rate is 30% and the required rate of return is 12%. You believe that the variable cost and sales volume may be as much as 10% higher or lower than the initial estimate. Your boss understands the risks but asks you to explain the alternatives in a brief memo to the board, Write a memo to the Board of Directors objectively weighing out the pros and cons of this project and make your recommendation(s).
Covington Pharmacies has decided to automate its insurance claims process. Two networked computer systems are being considered. The systems have an expected life of two years. The net cash flows associated with the systems are as follows. The cash benefits represent the savings created by switching from a manual to an automated system. The companys cost of capital is 10 percent. Required: 1. Compute the NPV and the IRR for each investment. 2. Show that the project with the larger NPV is the correct choice for the company.
Dinaro Inc. is looking at an investment project that has an NPV of ($5,000). The hurdle rate is 8%.
The values of Alabama building contracts (in millions of dollars) for a 12-month period are as follows: Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast. Use α = 0.2. Which provides the better forecasts based on MSE? What is the forecast for the next month using exponential smoothing with α = 0.2?
Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
The Siler Construction Company is about to bid on a new industrial construction project. To formulate their bid, the company needs to estimate the time required for the project. Based on past experience, management expects that the project will require at least 24 months, and could take as long as 48 months if there are complications. The most likely scenario is that the project will require 30 months. a. Assume that the actual time for the project can be approximated using a triangular probability distribution. What is the probability that the project will take less than 30 months? b. What is the probability that the project will take between 28 and 32 months? c. To submit a competitive bid, the company believes that if the project takes more than 36 months, then the company will lose money on the project. Management does not want to bid on the project if there is greater than a 25% chance that they will lose money on this project. Should the company bid on this project?
Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.
Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Giorgio Co. is looking at an investment project with an internal rate of return of 10.8%. The initial outlay for the investment is $90,000. The hurdle rate or minimum acceptable rate of return is 10.2%.