Concept explainers
a)
To determine: The minimum cost rental plan for the next 12 months.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
b)
To use: The solver table to identify if the total rental cost increases by the same amount of percentage mentioned.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
Trending nowThis is a popular solution!
Chapter 4 Solutions
Practical Management Science
- 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?arrow_forwardAlthough the normal distribution is a reasonable input distribution in many situations, it does have two potential drawbacks: (1) it allows negative values, even though they may be extremely improbable, and (2) it is a symmetric distribution. Many situations are modelled better with a distribution that allows only positive values and is skewed to the right. Two of these that have been used in many real applications are the gamma and lognormal distributions. @RISK enables you to generate observations from each of these distributions. The @RISK function for the gamma distribution is RISKGAMMA, and it takes two arguments, as in =RISKGAMMA(3,10). The first argument, which must be positive, determines the shape. The smaller it is, the more skewed the distribution is to the right; the larger it is, the more symmetric the distribution is. The second argument determines the scale, in the sense that the product of it and the first argument equals the mean of the distribution. (The mean in this example is 30.) Also, the product of the second argument and the square root of the first argument is the standard deviation of the distribution. (In this example, it is 3(10=17.32.) The @RISK function for the lognormal distribution is RISKLOGNORM. It has two arguments, as in =RISKLOGNORM(40,10). These arguments are the mean and standard deviation of the distribution. Rework Example 10.2 for the following demand distributions. Do the simulated outputs have any different qualitative properties with these skewed distributions than with the triangular distribution used in the example? a. Gamma distribution with parameters 2 and 85 b. Gamma distribution with parameters 5 and 35 c. Lognormal distribution with mean 170 and standard deviation 60arrow_forwardYou are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)arrow_forward
- As part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials? morning min afternoon min evening minarrow_forwardFRUIT COMPUTER COMPANY Fruit Computer Company manufactures memory chips in batches of ten chips. From past experience, Fruit knows that 80% of all batches contain 10% (1 out of 10) defective chips, and 20% of all batches contain 50% (5 out of 10) defective chips. If a good (that is, 10% defective) batch of chips is sent to the next stage of production, processing costs of $4000 are incurred, and if a bad batch (50% defective) is sent on to the next stage of production, processing costs of $16000 are incurred. Fruit also has the alternative of reworking a batch at a cost of $4000. A reworked batch is sure to be a good batch. Alternatively, for a cost of $400, Fruit can test one chip from each batch in an attempt to determine whether the batch is defective. QUESTIONS 1.Determine a strategy so Fruit can minimize the expected total cost per batch. 2.Compute the EVSI and EVPI.arrow_forwardA bhaliyaarrow_forward
- Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25arrow_forwarda. Which of the following best describes the meaning of the equation P(25) = 200? 1. When 200 calculators are sold, the profit is $25. II. When 200 calculators are sold, the profit is increasing at a rate of $25 per additional calculator III. When 25 calculators are sold, the profit is $200. IV. When 25 calculators are sold, the profit is increasing at a rate of $200 per additional calculatoarrow_forwardA trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the total annual return (before tax). Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest as least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free. Suppose the decision variable represents the amount of money invested in bond for . Formulate a linear programming (LP) model to solve the optimal strategy. 1. Write down the constraint using the defined decision variables requiring “invest as least 50% of the money in short-term issues”. 2. Write down the constraint using the defined decision…arrow_forward
- Company XYZ produces and sells two types of calculators: Basic and Scientific. The Basic has a lower selling price per unit compared to the Scientific. However, the Basic has a higher contribution margin compared to the Scientific. Due to fixed production capacity, the company has a cap on total production ability. If the company's CEO has decided to shift the sales mix towards producing more Basic calculators. What would be the effect on total profits? a. Cannot be determined using the above information b. Total profits would remain the same Total profits would increase O C. d. None of the given answers e. Total profits would decrease OO00arrow_forwardA home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?arrow_forwarda) The probability that a transistor will last between 12 and 24 weeks is : P(12 < X <24) = F(24, 4, 6) - F(12, 4, 6) = F(24/6, 4) - F(12/6, 4) = F(4, 4) - F(2, 4) = 0.567 -0.143 = 0.424 Explanation: Using the formula, FOX: α; B) = F(x/B; 0)arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,