As the Quality Sweaters problem is now modeled, if all inputs remain fixed except for the number mailed, profit will increase indefinitely as the number mailed increases. This hardly seems realistic—the company could becomeinfinitely rich. Discuss realistic ways to modify the model so that this unrealistic behavior is eliminated.

As the Quality Sweaters problem is now modeled, if all inputs remain fixed except for the number mailed, profit will increase indefinitely as the number mailed increases. This hardly seems realistic—the company could becomeinfinitely rich. Discuss realistic ways to modify the model so that this unrealistic behavior is eliminated.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.
Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?
Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…
Consider a consumer that lives only for two periods. He works in period 1 (and gets income Y1) and moves up the corporate ladder in period 2 (and gets income Y1 < Y2). This consumer has the usual preferences over time: u(C1) + βu(C2) Assume once again that a consumer cannot borrow, but can borrow and immediately sell some MacGuffins, and in the next period, the consumer must buy back the MacGuffins to return to the lender. Assume that MacGuffin t r a d e s a t P1 > 0 in the first period and is expected to trade at P ̃2 in the second period. Write down the new budget constraint. Would a consumer borrow a MacGuffin? What is the condition on the P ̃2? Is P ̃2 a fair price of a MacGuffin? Could the consumer be better off with a MacGuffin?
A few years ago, Michael purchased a home for $394,000. Today, the home is worth $520,000. His remaining mortgage balance is $166,000. Assuming Michael can borrow up to 80 percent of the market value of his home, what is the maximum amount he can borrow?
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
Based on current dividend yields and expected capital gains, the expected rates of return on portfolios A and B are 11 % and 14 %, respectively. The beta of A is 0.8 % while that of B is 1.5. The T-bill is currently 6 %, while the expected rate of return of the S&P 500 index is 12 %. The standard deviation of portfolio A is 10 % annually, while that of B is 31 % , and that of the index is 20 %: If you currently hold a market index portfolio, would you choose to add either of these portfolios to your holdings? Explain. If instead you could invest only in bills and one of these portfolios, which would you choose, and why? Investor Y, who put K1 in large stocks (the S & P 500 portfolio) on December 31, 1925, and re-invested all dividends in that portfolio, would have ended on December 31, 2003, with K1992.80.
BADLY NEED YOUR HELP PLEASE. 1.) True or false? Briefly explain. _____ Your firm has the opportunity to invest $20 million in a new project. The interest rate on the firm’s debt is 7% and the cost of equity is 14%. The cost of capital for the project depends on whether the firm finances the project with new debt or new equity. _____ You are thinking about investing in either stock A or stock B. Both stocks have an expected return of 12%, but stock A has a standard deviation of 25% annually and stock B has a standard deviation of 35% annually. You should invest in stock A since it is less risky. _____ Your firm currently has a debt-to-equity ratio of 10%: debt = $50 million and equity = $500 million (market values). The interest rate on the firm’s debt (rD) is 8% and the cost of equity (rE) is 13%. Since the cost of debt rD is lower than the cost of equity rE, the firm can lower its overall cost of capital by borrowing more. Ignore taxes.