Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 40P
a)
Summary Introduction
To build: The @RISK model which would contain the amount of money left with Person X, putting money in an FSA, and paying extra medical expenses in the output.
Introduction: Simulation model is the digital prototype of the physical model that helps to
b)
Summary Introduction
To build: The @RISK model which would contain the amount of money left with Person X, putting money in an FSA, and paying extra medical expenses in the output.
Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A borrower wants to lower the amount of
money they pay in
interest over the life of a loan. Which of these
tactics is best for
decreasing the amount of interest the
borrower would pay?
making payments small enough to create
negative amortization
never defaulting on a monthly payment
making monthly payments on a non-
amortized loan
making biweekly payments on an amortized
loan
You deposit $6,000 in an account earning 2% interest compounded monthly. How much will you have in the account in 10 years?
If a borrower takes out an interest-only loan,
when are they expected to pay the principal of
the loan?
only after the borrower refinances
as a balloon payment at the end of the loan term
They aren't; interest over time will add up to
more than the principal amount.
in periodic monthly payments
Chapter 10 Solutions
Practical Management Science
Ch. 10.2 - Use the RAND function and the Copy command to...Ch. 10.2 - Use Excels functions (not @RISK) to generate 1000...Ch. 10.2 - Use @RISK to draw a uniform distribution from 400...Ch. 10.2 - Use @RISK to draw a normal distribution with mean...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - Use @RISK to draw a binomial distribution that...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - We all hate to keep track of small change. By...Ch. 10.4 - Prob. 11PCh. 10.4 - In August of the current year, a car dealer is...
Ch. 10.4 - Prob. 13PCh. 10.4 - Prob. 14PCh. 10.4 - Prob. 15PCh. 10.5 - If you add several normally distributed random...Ch. 10.5 - In Problem 11 from the previous section, we stated...Ch. 10.5 - Continuing the previous problem, assume, as in...Ch. 10.5 - In Problem 12 of the previous section, suppose...Ch. 10.5 - Use @RISK to analyze the sweatshirt situation in...Ch. 10.5 - Although the normal distribution is a reasonable...Ch. 10.6 - When you use @RISKs correlation feature to...Ch. 10.6 - Prob. 24PCh. 10.6 - Prob. 25PCh. 10.6 - Prob. 28PCh. 10 - Six months before its annual convention, the...Ch. 10 - Prob. 30PCh. 10 - A new edition of a very popular textbook will be...Ch. 10 - Prob. 32PCh. 10 - W. L. Brown, a direct marketer of womens clothing,...Ch. 10 - Assume that all of a companys job applicants must...Ch. 10 - Lemingtons is trying to determine how many Jean...Ch. 10 - Dilberts Department Store is trying to determine...Ch. 10 - It is surprising (but true) that if 23 people are...Ch. 10 - Prob. 40PCh. 10 - At the beginning of each week, a machine is in one...Ch. 10 - Simulation can be used to illustrate a number of...Ch. 10 - Prob. 43PCh. 10 - Prob. 46PCh. 10 - If you want to replicate the results of a...Ch. 10 - Suppose you simulate a gambling situation where...Ch. 10 - Prob. 49PCh. 10 - Big Hit Video must determine how many copies of a...Ch. 10 - Prob. 51PCh. 10 - Prob. 52PCh. 10 - Why is the RISKCORRMAT function necessary? How...Ch. 10 - Consider the claim that normally distributed...Ch. 10 - Prob. 55PCh. 10 - When you use a RISKSIMTABLE function for a...Ch. 10 - Consider a situation where there is a cost that is...
Knowledge Booster
Similar questions
- It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years. Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2. There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed. The cost of clinical trials is assumed to follow a triangular distribution with best case 100 million, most likely case 150 million, and worst case 250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed. If clinical trials succeed, the drug will be sold for five years, earning a profit of 6 per unit sold. If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case 1 billion, most likely case 1.5 billion, and worst case 2.5 billion. The plant cost will be depreciated on a straight-line basis during the five years of sales. Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales. During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units. Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less. Cash flows are discounted 15% per year, and the tax rate is 40%. Use simulation to model Mercks situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the projects NPV? (Hint: The way the uncertainty about the first year sales is stated suggests using the General distribution, implemented with the RISKGENERAL function. Similarly, the way the uncertainty about the annual growth rate is stated suggests using the Cumul distribution, implemented with the RISKCUMUL function. Look these functions up in @RISKs online help.)arrow_forwardA project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)arrow_forwardThe following is an excerpt from a business plan: "To open our new upscale toy store, We R Toys, we require a total of $225,000. The owners will be providing $100,000 of this amount from their own savings, and their friends and families have promised an additional $25,000. Therefore, We R Toys requires a bank loan of $100,000." In which section of We R Toys' business plan would this information be found? O Executive Summary O Sales Strategies Market Analysis O Financial Projections O Funding Requirementsarrow_forward
- What is the main reason lenders pay borrowers' property taxes through a pre-paid escrow account? It prevents a tax lien from being applied to the home. The tax lien would be senior to the mortgage lien. It prevents the borrower from refinancing with another lender because they would lose all of their escrow funds. It allows the lender to earn interest on the pre- paid tax money as itsits in the account. It allows the lender to take advantage of corporate tax deductions.arrow_forwardSuppose that your monthly net income is $2,950. Your monthly debt payments include your student loan payment and a gas credit card. They total $590. What is your debt payments-to-income ratio? %arrow_forwardYou have deposited $10,800 into an account that will earn an interest rate of 8% compounded semiannually. How much will you have in this account at the end of 10 years? $16,564.89 $27,213.75 $23,664.13 $28,396.96arrow_forward
- A company had the following accounts and balances as of December 31: Account Debit Credit Cash $ 20,000 Accounts Receivable 2,000 Supplies 1,500 Prepaid Insurance 1,400 Accounts Payable $ 4,000 Total equity 14,900 Lodging Revenue 7,000 Salaries Expense 500 Utilities Expense 500 Totals $ 25,900 $ 25,900 Using the information in the table, calculate the total assets reported on the balance sheet for the period. Multiple Choice $23,400. $25,400. $25,900. $22,500. $24,900.arrow_forwardAssume your home is assessed at $250,000. You have a $241,000 loan for 25 years at 6 percent. Your property tax rate is 1.4 percent of the assessed value. In year one, you would pay $15,665 in mortgage interest and $3,500 in property tax (1.4 percent on $250,000 assessed value). What is the total deduction you can take on your federal income tax return?arrow_forwardWith the success of your business, you are ready to establish a storefront. However, you do not have the necessary funds to acquire the building and pay the necessary rent. You are considering borrowing a short-term note from a bank for $130,000. Required part B. Research the lending practices of a local bank. Determine the interest rate charged for a $130,000 loan. What collateral does the bank require to secure the loan? Determine your overall payback amount if you were to repay the loan in less than one year. Choose either a payback with periodic payments or all at the end of the loan term and compare the outcomes. After conducting your research, would you consider borrowing the money? What positive and negative outcomes accompany borrowing the money? Instead of borrowing on a short-term note, you are thinking on borrowing $130,000 and signed a 5-year, note payable with a 12% interest rate. Each annual payment is in the amount of $34,920 and payment is due each Dec. 31. What is…arrow_forward
- Suppose you are 45 and have a $410,000 face amount, 15-year, limited-payment, participating policy (dividends will be used to build up the cash value of the policy). Your annual premium is $1,435. The cash value of the policy is expected to be $16,400 in 15 years. Using time value of money and assuming you could invest your money elsewhere for a 7 percent annual yield, calculate the net cost of insurance. Use (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)arrow_forwardIf $ 650 is deposited at the end of each quarter into an account paying 11% compounded quarterly, how much money will be in that account after 6 years? Round your answer to two digits!arrow_forwardYou have just received a business valuation report that is dated six months ago. Describe the factors that might have changed during the past six months and, therefore, caused the value of the business today to be different from the value six months ago. Which of these changes affect the expected cash flows, and which affect the discount rate that you would use in a discounted cash flow valuation of this company?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,