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

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 6R: Reset cells to their initial values. Sweet Pleasures, Inc., is considering undertaking a 1,200 per...

See similar textbooks

Similar questions

i will 10 upvotes urgent Assume the annual retention rate for a cell phone subscriber is 70 percent and the customer generates $300 per year in profit. Assuming an annual discount rate of 8 percent, compute the value of a customer. Please use excel worksheet to solve and show formulas
13. Gadgeteer Inc. is planning the market strategy for their new widget. They could bring it directly to market. This would result in a 40% chance of a successful launch (and therefore a 60% chance of an unsuccessful one). A successful launch would result in a NPV of $22 million. A failed one would result in a negative NPV of $9 million. Or, they could test market the product for two years (thus delaying any potential launch by two years). The test marketing would also cost a present value of $1.5 million. However, it would increase the probability of success to 75%. The relevant discount rate is 11%. Should Gadgeteer test market the widget?
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 ___
DLR Rheosystems makes high performance rotational viscometers capable of steady shear and yield stress testing in a rugged, compact footprint. How much could the company afford to spend now on new equipment in lieu of spending Php 200 000 one year from now and Php 300 000 three years from now, if the company uses an interest rate of 15 % per year? a.) Php 236 715.33 b.) Php 371 176.91 c.) Php 288 621.15 d.) Php 345 440.06
F2. Penske has come up with a new gadget prototype and is ready to go ahead with pilot production and test marketing. The pilot production and test marketing phase will last for one year and cost $560,000. The management team believes that there is a 40% chance that the test marketing will be successful (which also means 60% chance of test marketing failure) and that there will be sufficient demand for the new gadget. If the test-marketing phase is successful, then Penske will invest $3.1 million in year one to build a plant that will generate expected annual after-tax cash flows of $600,000 in perpetuity beginning in year two. If the test marketing is not successful, Penske can still go ahead and build the new plant, but the expected annual after-tax cash flows would be only $220,000 in perpetuity beginning in year two. Penske's cost of capital is 20.00%. Assume that Penske has the ability to ignore the pilot production and test marketing and to go ahead and build its manufacturing…
What are the important EOQ assumptions and comment if theseassumptions are realistic in a real-world situation. (c) CalcCo is a manufacturer of calculators, currently producing 200 perweek. One component for every calculator is a liquid crystal display(LCD), which the company purchases from LCDCo for £1 per LCD.CalcCo management wants to avoid any shortage of LCDs, since thiswould disrupt production, so LCDCo guarantees a delivery time of 0.5weeks on each order. The placement of each order is estimated torequire 1 hour of clerical time, with a direct cost of £15 per hour plusoverhead costs of another £5 per hour.What should be the Economic Order Quantity (EOQ), the reorder point(assume no safety stock) and the TC? To ensure production continuityCalcCo determined that the standard deviation of the lead timedemand is 20 LCDs. To ensure a 90% confidence of productioncontinuity the company has decided to introduce a safety stock. Whatis this stock and re-calculate the order point.(d)…
Not use excel Q) You are considering buying solar photovoltaic panels for your home. Your current monthly energy bills average $125. Your panels are expected to be serviceable for 30 years. The panels would cost $18,000 upfront. The panels would supply all the electricity you need. There is a 26% federal tax break this year for renewable energy purchases. What is the IRR (write as a percentage)? ________________ Is it a good idea (Yes or No, based on IRR)? _____________ ********************** PLEASE ROUND ROI TO ONE (1) DECIMAL POINT ONLY!*******************
6. A large electronic retailer is considering the purchase of software that will minimize shipping expenses in its supply chain network. This software, including installation and training would be a $10 million investment for the retailer. If the firm nominal interest is 15% per year and the life of the software is four years, what annual savings in shipping expenses must there be justify the purchase of the software?
Minden Co. is considering buying new computer software that will assist customers in their product choices. The cost is $50,000. The benefit will be an additional cash inflow of $25,000 for four years, at which point the software will need replacing with a more modern version. The return on average investment is _______________. Question 15 options: 25.0% none of the options 42.5% 50.0% 30.0%
Can i get a step by step please 4a2) A new watch project for the Omegga company has the following data. The estimated sales price of the new watch is $200 and the sales volume to be 1,000 units in year 1, 1,250 units in year 2, and 1,325 units in year 3. The project has a three-year life. Variable costs amount to $125 per unit and fixed costs are $135,000 per year. The project requires an initial investment of $178,000, which is depreciated straight-line to zero over the three-year project life. The actual market value of the initial investment at the end of year 3 is $52,000. Initial net working capital investment is $57,000 and NWC will maintain a level equal to 18% of sales each year thereafter. The tax rate is 35% and the required return on the project is 11%. Given the $57,000 initial investment in NWC, what change occurs for NWC during year 1? Explain.
Dunder Mitfin plans to install a computer system to measure the dimensions of products so thar the proper size boxes can be used to ship items. This well save packing materials, cardboard, and labor. If the savings will be $132310 the first year and increases by $ 9521each year for 9 years. What is the present worth of the system at an interest rate of 12%.Write your answer to two decimal places
Investing $2,000,000 in TQM's Channel Support Systems initiative will at a minimum increase demand for your products 3.0% in this and in all future rounds. (Refer to the TQM Initiative worksheet in the CompXM Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,608,638. Assuming similar sales next year, the 3.0% increase in demand will provide $4,908,259 of additional revenue. With the overall contribution margin of 34.2%, after direct costs this revenue will add $1,678,625 to the bottom line. For simplicity, assume that the demand increase and margins will remain at last year's levels. How long will it take to achieve payback on the initial $2,000,000 TQM investment, rounded to the nearest month? A. 10 months B. TQM investment will not have a significant financial impact C. 14 months D. 5 months