New Semester Started Get 50% OFF Study Help! --h --m --s Claim Now

Question Answers

Textbooks

Find textbooks, questions and answers

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Study Help
Tutors
AI Study Planner NEW
Sell Books

Search
Sign In
Register

study help
mathematics
statistics

Data Analysis And Decision Making 4th Edition Christian Albright, Wayne Winston, Christopher Zappe - Solutions

In the capital budgeting model in Figure 14.40, investment 4 has the largest ratio of NPV to cash requirement, but it is not selected in the optimal solution. How much NPV is lost if Tatham is forced to select investment 4? Answer by solving a suitably modified model.
As it currently stands, investment 7 in the capital budgeting model in Figure 14.40 has the lowest ratio of NPV to cash requirement, 2.5. Keeping this same ratio, can you change the cash requirement and NPV for investment 7 in such a way that it is selected in the optimal solution? Does this lead
Expand the capital budgeting model in Figure 14.40 so that there are now 20 possible investments. You can make up the data on cash requirements, NPVs, and the budget. However, use the following guidelines: The cash requirements and NPVs for the various investments can vary widely, but the ratio of
Suppose in the capital budgeting model in Figure 14.40 that each investment requires $2000 during year 2 and only $5000 is available for investment during year 2.a. Assuming that available money un-invested at the end of year 1 cannot be used during year 2, what combination of investments
How difficult is it to expand the Great Threads model to accommodate another type of clothing? Answer by assuming that the company can also produce sweatshirts. The rental cost for sweatshirt equipment is $1100, the variable cost per unit and the selling price are $15 and $45, respectively, and
Referring to the previous problem, if it is optimal for the company to produce sweatshirts, use SolverTable to see how much larger the fixed cost of sweatshirt machinery would have to be before the company would not produce any sweatshirts. However, if the solution to the previous problem calls for
In the Great Threads model, the production quantities in row 16 were not constrained to be integers. Presumably, any fractional values could be safely rounded to integers. See whether this is true. Constrain these quantities to be integers and then run Solver. Are the optimal integer values the
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both binding—the company is using all it has. a. Use SolverTable to see what happens to the optimal solution when the amount of available cloth increases from its current value. Capture all of the
In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solver to find the new optimal solution. How much profit does the company lose because of having to
In the original Western Airlines set-covering model in Figure 14.52, we assumed that each city must be covered by at least one hub. Suppose that for added flexibility in flight routing, Western requires that each city must be covered by at least two hubs. How do the model and optimal solution
In the original Western Airlines set-covering model in Figure 14.52, we used the number of hubs as the objective to minimize. Suppose instead that there is a fixed cost of locating a hub in any city, where these fixed costs can vary across cities. Make up some reasonable fixed costs, modify the
Set-covering models such as the original Western Airlines model in Figure 14.52 often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three hubs because we know this is optimal.
How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 14.55. Add several cities that must be served: Memphis, Dallas, Tucson, Philadelphia, Cleveland, and Buffalo. You can look up the distances from these cities to each other and to
The models in this section are often called combinatorial models because each solution is a combination of the various 0s and 1s, and there are only a finite number of such combinations. For the capital budgeting model in Figure 14.40, there are seven investments, so there are 27 = 128 possible
Make up an example, as described in Problem 54, with 20 possible investments. However, do it so that the ratios of NPV to cash requirement are in a very tight range, from 3.0 to 3.2. Then use Solver to find the optimal solution when the Solver tolerance is set to its default value of 5%, and record
In the Great Threads model, we found an upper bound on production of any clothing type by calculating the amount that could be produced if all of the resources were devoted to this clothing type.a. What if you instead use a very large value such as 1,000,000 for this upper bound? Try it and see
In the last sheet of the finished version of the Fixed Cost Manufacturing file, we illustrated one way to model the Great Threads problem with IF functions, but saw that this approach doesn’t work. Try a slightly different approach here. Eliminate the binary variables in row 14 altogether, and
In the peak-load pricing model, the demand functions have positive and negative coefficients of prices. The negative coefficients indicate that as the price of a product increases, demand for that product decreases. The positive coefficients indicate that as the price of a product increases, demand
In the peak-load pricing model, we assumed that the capacity level is a decision variable. Assume now that capacity has already been set at 30 kwh. Change the model appropriately and run Solver. Then use SolverTable to see how sensitive the optimal solution is to the capacity level, letting it vary
For each of the following, answer whether it makes sense to multiply the matrices of the given sizes. In each case where it makes sense, demonstrate an example in Excel, where you make up the numbers. a. AB, where A is 3 x 4 and B is 4 x 1b. AB, where A is 1 x 4 and B is 4 x 1c. AB, where A is 4 x
Add a new stock, stock 4, to the portfolio optimization model. Assume that the estimated mean and standard deviation of return for stock 4 are 0.125 and 0.175, respectively. Also, assume the correlations between stock 4 and the original three stocks are 0.3, 0.5, and 0.8. Run Solver on the modified
In the portfolio optimization model, stock 2 is not in the optimal portfolio. Use SolverTable to see whether it ever enters the optimal portfolio as its correlations with stocks 1 and 3 vary. Specifically, use a two-way SolverTable with two inputs, the correlations between stock 2 and stocks 1 and
The stocks in the portfolio optimization model are all positively correlated. What happens when they are negatively correlated? Answer for each of the following scenarios. In each case, two of the three correlations are the negatives of their original values. Discuss the differences between the
In many cases you can assume that the portfolio return is at least approximately normally distributed. Then you can use Excel’s NORMDIST function as in Chapter 5 to calculate the probability that the portfolio return is negative. The relevant formula is = NORMDIST(0,mean,stdev,1), where mean and
A bus company believes that it will need the following numbers of bus drivers during each of the next five years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; 75 drivers in year 5. At the beginning of each year, the bus company must decide how many drivers
A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per
A bank is attempting to determine where to invest its assets during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rates of return on each type of investment are known to be the following: bonds, 6%; home loans,
A fertilizer company blends silicon and nitrogen to produce two types of fertilizers. Fertilizer 1 must be at least 40% nitrogen and sells for $70 per pound. Fertilizer 2 must be at least 70% silicon and sells for $40 per pound. The company can purchase up to 8000 pounds of nitrogen at $15 per
LP models are used by many Wall Street firms to select a desirable bond portfolio. The following is a simplified version of such a model. A company is considering investing in four bonds; $1 million is available for investment. The expected annual return, the worst-case annual return on each bond,
At the beginning of year 1, you have $10,000. Investments A and B are available; their cash flows are shown in the file S14_84.xlsx. Assume that any money not invested in A or B earns interest at an annual rate of 8%.a. Determine how to maximize your cash on hand at the beginning of year 4.b. Use
An oil company produces two types of gasoline, G1 and G2, from two types of crude oil, C1 and C2. G1 is allowed to contain up to 4% impurities, and G2 is allowed to contain up to 3% impurities. G1 sells for $48 per barrel, whereas G2 sells for $72 per barrel. Up to 4200 barrels of G1 and up to 4300
The government is auctioning off oil leases at two sites: 1 and 2. At each site 10,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bidding for the oil. Government rules state that no bidder can receive more than 40% of the land being auctioned. Cliff has bid
An automobile company produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed in the file S14_87.xlsx, where a blank means that a shipment is not allowed. Los
An oil company produces oil from two wells. Well 1 can produce up to 150,000 barrels per day, and well 2 can produce up to 200,000 barrels per day. It is possible to ship oil directly from the wells to the company’s customers in Los Angeles and New York. Alternatively, the company could transport
Based on Bean et al. (1987). Boris Milkem’s firm owns six assets. The expected selling price (in millions of dollars) for each asset is given in the file S14_89.xlsx. For example, if asset 1 is sold in year 2, the firm receives $20 million. To maintain a regular cash flow, Milkem must sell at
Based on Sonderman and Abrahamson (1985). In treating a brain tumor with radiation, physicians want the maximum amount of radiation possible to bombard the tissue containing the tumors. The constraint is, however, that there is a maximum amount of radiation that normal tissue can handle without
A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a fixed cost; it is incurred if any of this type of computer is produced. A total of 30,000 chips and
A food company produces tomato sauce at five different plants. The tomato sauce is then shipped to one of three warehouses, where it is stored until it is shipped to one of the company’s four customers. All of the inputs for the problem are given in the fileS14_92.xlsx, as follows:• The plant
You are given the following means, standard deviations, and correlations for the annual return on three potential investments. The means are 0.12, 0.15, and 0.20. The standard deviations are 0.20, 0.30, and 0.40. The correlation between stocks 1 and 2 is 0.65, between stocks 1 and 3 is 0.75, and
You have $50,000 to invest in three stocks. Let Ri be the random variable representing the annual return on $1 invested in stock i. For example, if Ri = 0.12, then $1 invested in stock i at the beginning of a year is worth $1.12 at the end of the year. The means are E(R1) = 0.14, E(R2) = 0.11, and
The risk index of an investment can be obtained by taking the absolute values of percentage changes in the value of the investment for each year and averaging them. Suppose you are trying to determine the percentages of your money to invest in T-bills, gold, and stocks. The file S14_95.xlsx lists
Broker Sonya Wong is currently trying to maximize her profit in the bond market. Four bonds are available for purchase and sale at the bid and ask prices shown in the file S14_96.xlsx. Sonya can buy up to 1000 units of each bond at the ask price or sell up to 1000 units of each bond at the bid
A financial company is considering investing in three projects. If it fully invests in a project, the realized cash flows (in millions of dollars) will be as listed in the file S14_97.xlsx. For example, project 1 requires a cash outflow of $3 million today and returns $5.5 million three years from
You are a CFA (chartered financial analyst). An overextended client has come to you because she needs help paying off her credit card bills. She owes the amounts on her credit cards listed in the file S14_98.xlsx. The client is willing to allocate up to $5000 per month to pay off these credit
A food company produces two types of turkey cutlets for sale to fast-food restaurants. Each type of cutlet consists of white meat and dark meat. Cutlet 1 sells for $4 per pound and must consist of at least 70% white meat. Cutlet 2 sells for $3 per pound and must consist of at least 60% white meat.
Each hour from 10 A.M. to 7 P.M., a bank receives checks and must process them. Its goal is to process all checks the same day they are received. The bank has 13 check processing machines, each of which can process up to 500 checks per hour. It takes one worker to operate each machine. The bank
An oil company has oil fields in San Diego and Los Angeles. The San Diego field can produce up to 500,000 barrels per day, and the Los Angeles field can produce up to 400,000 barrels per day. Oil is sent from the fields to a refinery, either in Dallas or in Houston. (Assume that each refinery has
An electrical components company produces capacitors at three locations: Los Angeles, Chicago, and New York. Capacitors are shipped from these locations to public utilities in five regions of the country: northeast (NE), northwest (NW), Midwest (MW), southeast (SE), and southwest (SW). The cost of
Based on Bean et al. (1988). The owner of a shopping mall has 10,000 square feet of space to rent and wants to determine the types of stores that should occupy the mall. The minimum number and maximum number of each type of store and the square footage of each type are given in the file
It is currently the beginning of 2010. A city (labeled C for convenience) is trying to sell municipal bonds to support improvements in recreational facilities and highways. The face values (in thousands of dollars) of the bonds and the due dates at which principal comes due are listed in the file
This problem deals with strategic planning issues for a large company.18 The main issue is planning the company’s production capacity for the coming year. At issue is the overall level of capacity and the type of capacity—for example, the degree of flexibility in the manufacturing system. The
Kate Torelli, a security analyst for Lion Fund, has identified a gold-mining stock (ticker symbol GMS) as a particularly attractive investment. Torelli believes that the company has invested wisely in new mining equipment. Furthermore, the company has recently purchased mining rights on land that
Use the RAND function and the Copy command to generate a set of 100 random numbers.a. What fraction of the random numbers are smaller than 0.5?b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5?c. What fraction of the random numbers are larger
Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?b. What
Use @RISK to draw a uniform distribution from 400 to 750. Then answer the following questions.a. What are the mean and standard deviation of this distribution?b. What are the 5th and 95th percentiles of this distribution?c. What is the probability that a random number from this distribution is less
Use @RISK to draw a normal distribution with mean 500 and standard deviation 100. Then answer the following questions.a. What is the probability that a random number from this distribution is less than 450?b. What is the probability that a random number from this distribution is greater than 650?c.
Use @RISK to draw a triangular distribution with parameters 300, 500, and 900. Then answer the following questions.a. What are the mean and standard deviation of this distribution?b. What are the 5th and 95th percentiles of this distribution?c. What is the probability that a random number from this
Use @RISK to draw a binomial distribution that results from 50 trials with probability of success 0.3 on each trial, and use it to answer the following questions.a. What are the mean and standard deviation of this distribution?b. You have to be more careful in interpreting @RISK probabilities with
Use @RISK to draw a triangular distribution with parameters 200, 300, and 600. Then superimpose a normal distribution on this drawing, choosing the mean and standard deviation to match those from the triangular distribution. (Click on the Add Overlay button and then choose the distribution to
We all hate to keep track of small change. By using random numbers, it is possible to eliminate the need for change and give the store and the customer a fair deal. This problem indicates how it could be done.a. Suppose that you buy something for $0.20. How could you use random numbers (built into
A company is about to develop and then market a new product. It wants to build a simulation model for the entire process, and one key uncertain input is the development cost. For each of the following scenarios, choose an appropriate distribution together with its parameters, justify your choice in
Continuing the preceding problem, suppose that another key uncertain input is the development time, which is measured in an integer number of months. For each of the following scenarios, choose an appropriate distribution together with its parameters, justify your choice in words, and use @RISK to
Suppose you own an expensive car and purchase auto insurance. This insurance has a $1000 deductible, so that if you have an accident and the damage is less than $1000, you pay for it out of your pocket. However, if the damage is greater than $1000, you pay the first $1000 and the insurance pays the
In August of the current year, a car dealer is trying to determine how many cars of the next model year to order. Each car ordered in August costs $20,000. The demand for the dealer’s next year models has the probability distribution shown in the file S15_12.xlsx. Each car sells for $25,000. If
In the Walton Bookstore example, suppose that Walton receives no money for the first 50 excess calendars returned but receives $2.50 for every calendar after the first 50 returned. Does this change the optimal order quantity?
A sweatshirt supplier is trying to decide how many sweatshirts to print for the upcoming NCAA basketball championships. The final four teams have emerged from the quarterfinal round, and there is now a week left until the semifinals, which are then followed in a couple of days by the finals. Each
In the Walton Bookstore example with a discrete demand distribution, explain why an order quantity other than one of the possible demands cannot maximize the expected profit.
If you add several normally distributed random numbers, the result is normally distributed, where the mean of the sum is the sum of the individual means, and the variance of the sum is the sum of the individual variances. This is a difficult result to prove mathematically, but it is easy to
In Problem 11 from the previous section, we stated that the damage amount is normally distributed. Suppose instead that the damage amount is triangularly distributed with parameters 500, 1500, and 7000. That is, the damage in an accident can be as low as $500 or as high as $7000, the most likely
Continuing the previous problem, assume, as in Problem 11, that the damage amount is normally distributed with mean $3000 and standard deviation $750. Run @RISK with 5000 iterations to simulate the amount you pay for damage. Compare your results with those in the previous problem. Does it appear to
In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the “best” order quantity—in this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss
Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation
Although 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 modeled better with a distribution
The Fizzy Company produces six-packs of soda cans. Each can is supposed to contain at least 12 ounces of soda. If the total weight in a six-pack is less than 72 ounces, Fizzy is fined $100 and receives no sales revenue for the six-pack. Each six-pack sells for $3.00. It costs Fizzy $0.02 per ounce
When you use @RISK’s correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random numbers, each with mean 100 and standard deviation 10, and with correlation 0.7.
Repeat the previous problem, but make the correlation between the two inputs equal to –0.7. Explain how the results change.
Repeat Problem 23, but now make the second input variable triangularly distributed with parameters 50, 100, and 500. This time, verify not only that the correlation between the two inputs is approximately 0.7, but also that the shapes of the two input distributions are approximately what they
Suppose you are going to invest equal amounts in three stocks. The annual return from each stock is normally distributed with mean 0.01 (1%) and standard deviation 0.06. The annual return on your portfolio, the output variable of interest, is the average of the three stock returns. Run @RISK, using
The effect of the shapes of input distributions on the distribution of an output can depend on the output function. For this problem, assume there are 10 input variables. The goal is to compare the case where these 10 inputs each have a normal distribution with mean 1000 and standard deviation 250
The Business School at State University currently has three parking lots, each containing 155 spaces. Two hundred faculty members have been assigned to each lot. On a peak day, an average of 70% of all lot 1 parking sticker holders show up, an average of 72% of all lot 2 parking sticker holders
Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000
You have made it to the final round of the show Let’s Make a Deal. You know that there is a $1 million prize behind either door 1, door 2, or door 3. It is equally likely that the prize is behind any of the three doors.The two doors without a prize have nothing behind them. You randomly choose
A new edition of a very popular textbook will be published a year from now. The publisher currently has 2000 copies on hand and is deciding whether to do another printing before the new edition comes out. The publisher estimates that demand for the book during the next year is governed by the
A hardware company sells a lot of low-cost, high volume products. For one such product, it is equally likely that annual unit sales will be low or high. If sales are low (60,000), the company can sell the product for $10 per unit. If sales are high (100,000), a competitor will enter and the company
W. L. Brown, a direct marketer of women’s clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the
Assume that all of a company’s job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 20% means that the company will accept applicants for
Lemington’s is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemington’s works as follows. At the beginning of the
Dilbert’s Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for $21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the
The annual return on each of four stocks for each of the next five years is assumed to follow a normal distribution, with the mean and standard deviation for each stock, as well as the correlations between stocks, listed in the file S15_37.xlsx. You believe that the stock returns for these stocks
It is surprising (but true) that if 23 people are in the same room, there is about a 50% chance that at least two people will have the same birthday. Suppose you want to estimate the probability that if 30 people are in the same room, at least two of them will have the same birthday. You can
Simulation can be used to illustrate a number of results from statistics that are difficult to understand with non-simulation arguments. One is the famous central limit theorem, which says that if you sample enough values from any population distribution and then average these values, the resulting
In statistics we often use observed data to test a hypothesis about a population or populations. The basic method uses the observed data to calculate a test statistic (a single number), as discussed in Chapter 9. If the magnitude of this test statistic is sufficiently large, the null hypothesis is
A technical note in the discussion of @RISK indicated that Latin Hypercube sampling is more efficient than Monte Carlo sampling. This problem allows you to see what this means. The file S15_44.xlsx gets you started. There is a single output cell, B5. You can enter any random value in this cell,
We are continually hearing reports on the nightly news about natural disasters—droughts in Texas, hurricanes in Florida, floods in California, and so on. We often hear that one of these was the “worst in over 30 years,” or some such statement. Are natural disasters getting worse these days,
In Example 16.1, the possible profits vary from negative to positive for each of the 10 possible bids examined.a. For each of these, use @RISK’s RISKTARGET function to find the probability that Miller’s profit is positive. Do you believe these results should have any bearing on Miller’s
If the number of competitors in Example 16.1 doubles, how does the optimal bid change?
Referring to Example 16.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Miller’s optimal bid increase or decrease? To study this question, assume that each competitor’s bid, expressed as a multiple of Miller’s cost to complete the
In Example 16.2, the gamma distribution was used to model the skewness to the right of the lifetime distribution. Experiment to see whether the triangular distribution could have been used instead. Let its minimum value be 0, and choose its most likely and maximum values so that this triangular
See how sensitive the results in Example 16.2 are to the following changes. For each part, make the change indicated, run the simulation, and comment on any differences between your outputs and the outputs in the example.a. The cost of a new camera is increased to $300.b. The warranty period is
Rerun the new car simulation from Example 16.4, but now introduce uncertainty into the fixed development cost. Let it be triangularly distributed with parameters $600 million, $650 million, and $850 million. (You can check that the mean of this distribution is $700 million, the same as the cost

Showing 11200 - 11300 of 88243

First
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Last

Step by Step Answers

Services

Sitemap
Fun
Definitions
Become Tutor
Used Textbooks
Study Help Categories
Recent Questions
Expert Questions
Campus Wear
Sell Your Books

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship
Online Quiz
Give Feedback, Get Rewards

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Student Discount
Campus Ambassador

Secure Payment

Download Our App

© 2026 SolutionInn. All Rights Reserved