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
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
microsoft excel data analysis 7th
Microsoft Excel Data Analysis And Business Modeling 7th Edition Wayne Winston - Solutions
The current price of a company’s stock is $20. The company is a takeover target. If the takeover is successful, the company’s stock price will increase to $30. If the takeover is unsuccessful, the stock price will drop to $12. Determine the range of values for the probability of a successful
When a roulette wheel is spun, the possible outcomes are 0, 00, 1, 2, ..., 36. If you bet on a number coming up, you win $35 if your number comes up and you lose $1 otherwise. What is the mean and standard deviation of your winnings on a single play of the game?
A stock currently sells for $40. You have bought one share of the stock at this price. In the next month, there is a 60 percent chance the stock price will double and a 40 percent chance the stock will drop 50 percent. In a month, you will sell the stock. Find the mean and standard deviation of
Suppose you bet on an odd number coming up in roulette. If an odd number comes up, you win $1, and if an odd number does not come up, you lose $1. Find the mean and standard deviation of your profit.
Suppose you can set the mean number of ounces of soda that is put into a can. The actual number of ounces has a standard deviation of 0.05 ounces. Answer the following questions:If you set the mean at 12.03 ounces, and a soda can is acceptable if it contains at least 12 ounces, what fraction of
The annual demand for a drug is normally distributed with a mean of 40,000 units and a standard deviation of 10,000 units. Answer the following questions:What is the probability that annual demand is between 35,000 and 49,000 units?If you want to have only a 5 percent chance of running out of the
The probability of winning a game of craps is 0.493. If I play 10,000 games of craps and bet the same amount on each game, what is the probability that I’m ahead? Begin by determining the mean and standard deviation of the profit in one game of craps. Then use the CLT.
The weekly sales of Volvo’s Cross Country station wagons are normally distributed with a mean of 1,000 and standard deviation of 250. Answer the following questions:What is the probability that between 400 and 1,100 station wagons will be sold during one week?There is a 1 percent chance that
My time for swimming 100 yards follows a normal random variable with a mean that equals 51 seconds and a standard deviation of 1.5 seconds. If I swim the race in under 49 seconds, I will win the race. What is the chance I win the race?
The federal government wants to charge a Medicare surcharge to Americans 65 or older whose income ranks in the top 2 percent of all American family incomes. If the American family incomes follow a normal random variable with a mean that equals $60,000 and a standard deviation that equals $20,000,
The voltage held by a voltage regulator follows a normal random variable with a mean that equals 200 volts and a standard deviation that equals 5 volts. A regulator meets the specifications if the regulator can hold a voltage between 185 and 210 volts. What fraction of the regulators meet the
Texas wants to give welfare checks to the poorest 5 percent of all Texas families. If the family income in Texas follows a normal random variable with a mean that equals $50,000 and a standard deviation that equals $15,000, what income level should be the cutoff for welfare?
A rod meets its specifications if its diameter is between 0.98 and 1.02 inches. The mean diameter of a rod is 1 inch. What should the standard deviation of rods equal for 99 percent of rods to meet the specifications?
The number of bottles of iced tea sold by a supermarket on a Monday follows a normal random variable with a mean that equals 100 and a standard deviation that equals 12. On a given Monday, what is the chance that the supermarket will sell at least 105 bottles of iced tea? Fill in the blank: There
Assume the mean daily percentage change in the Dow Jones Industrial Average Index is 1 percent, with a standard deviation of 1.5 percent. Assume there are 252 trading days in a year. What is the chance the Dow Jones Industrial Average Index increases by 20 percent or more during a year?
I have 500 potential customers who come to my candy store each day. Seventy percent of the customers buy no pieces of candy, 15 percent buy one piece, 10 percent buy two pieces, and 5 percent buy three pieces. What is the chance that I sell at least 280 pieces of candy in a day?
In Game 7 of the Boston Celtics–Los Angeles Lakers 2010 NBA finals, the Lakers were favored by seven points. Looking at past NBA games, you will find that bookmakers’ forecasts are unbiased. Also, the standard deviation of bookmaker forecasts in past NBA games is 12 points. Before the game,
A leading cell phone company forecasts that next year it will sell 3 million units of its bestselling phone. In the past, actual sales have been unbiased, with forecast errors having a standard deviation equal to 10 percent of the forecasted sales. What are the chances that fewer than 2.5 million
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.What is the probability that in two years the stock will sell for more than $45?
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.What is the probability that in two years the stock will sell for less than $25?
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.You are 95 percent sure that the price of the stock in two years will be between what two values?
If a city has only one hospital, where should it be located?
I am borrowing $100,000 for a 15-year mortgage. The annual rate of interest is 8 percent. How can I determine my monthly mortgage payment?
How should an auto company allocate its advertising budget between different advertising formats?
How should cities transport students to more distant schools to obtain racial balance?
How should a drug company allocate its sales-force efforts among its products?
The tax rate charged to a drug company depends on the country/region in which a product is produced. How can a drug company determine where each drug should be made?
A drug company has $2 billion allocated to purchasing biotech companies. Which companies should it buy?
At a chip-manufacturing plant, four technicians (A, B, C, and D) produce three products (1, 2, and 3). This month, the chip manufacturer can sell 80 units of Product 1, 50 units of Product 2, and at most 50 units of Product 3. Technician A can make only Products 1 and 3. Technician B can make only
A computer-manufacturing plant produces mice, keyboards, and video-game joysticks. The per-unit profit, per-unit labor usage, per-unit machine-time usage, and monthly demand are given in the following table:Each month, a total of 13,000 labor hours and 3,000 hours of machine time are available. How
Jason makes diamond bracelets, necklaces, and earrings. He wants to work a maximum of 160 hours per month. He has 800 ounces of diamonds. The profit, labor time, and ounces of diamonds required to produce each product are given in the following table. If demand for each product is unlimited, how
Shoeco manufactures three types of shoes. Demand for shoes is unlimited, and 40 hours per week of machine time and labor are available. A pair of shoes yields the profit and uses the number of minutes of machine time and labor given in the following table. Assuming the number of pairs of shoes made
Woodco produces tables and chairs. The unit profit, the wood used (in square feet), and the number of skilled carpentry hours used to produce a pair of shoes are given in the table below. An integer number of desks and chairs must be made, and demand is unlimited. How can we maximize the weekly
The Houston Credit Union is open weekdays 9 a.m. to 5 p.m. Full-time tellers who work the full day (no lunch break) are paid $200 per day. Part-time tellers working 11 a.m.–1 p.m. may be hired for $80 per day. The number of tellers needed each hour is shown in Figure 68- 5. Develop a linear
The Pine Valley Credit Union is trying to schedule bank tellers. The credit union is open 8 a.m.–6 p.m. and needs the number of tellers each hour as shown in the following table. Fulltime tellers can work 8 a.m.–5 p.m. (with a noon–1 p.m. lunch hour) or 9 a.m.–6 p.m. (with a 1 p.m.–2 p.m.
Figure 68-4 shows the number of people in different demographic groups who watched various TV shows and the cost (in thousands of dollars) of placing a 30-second ad on each show. For example, it cost $160,000 to place a 30-second ad on Modern Family (see figure). The show was watched by 6 million
The number of telephone reservation operators needed by an airline during each time of day is shown in the following table. Each operator works one of the following six-hour shifts: midnight–6:00 a.m., 6:00 a.m.–noon, noon–6:00 p.m., or 6:00 p.m.–midnight. What is the minimum number of
Suppose Bank 24 has 22 employees and that the goal is to schedule employees so that they have the maximum number of weekend days off. How should the workers be scheduled?
Suppose Bank 24 employees are paid $150 per day the first five days they work and can work a day of overtime at a cost of $350. How should the bank schedule its employees?
A hardware store has 50 riding mowers at each of its Houston, Dallas, and San Antonio warehouses. This month, 35 mowers will be sold in Houston, Dallas, San Antonio, and Austin. The costs of shipping a mower from each warehouse to each city are given in Figure 69-3. Determine how demand can be met
Suppose that each day, Northern, Central, and Southern California each use 100 billion gallons of water. Also assume that Northern California and Central California have available 120 billion gallons of water, whereas Southern California has 40 billion gallons of water available. The cost of
The following table gives the distances between Boston, Chicago, Dallas, Los Angeles, and Miami. Each city requires 40,000 kilowatt hours (kWh) of power. Chicago, Dallas, and Miami are capable of producing 70,000 kWh. Assume that shipping 1,000 kWh over 100 miles costs $4. From where should power
Your company produces and sells drugs at several different locations. The decision about where to produce goods for each sales location can have a huge impact on profitability. The model here is like the model used in this chapter to determine where drugs should be produced. Use the following
For the capital budgeting example discussed in conjunction with Figures 70-1 through 70-3, use conditional formatting to highlight in yellow fill each row corresponding to a selected project.Figure 70.1Figure 70.2Figure 70.3 123456SHSSHR2272222 5 Do IT? 8 9 10 11 18 19 A 20 B Total NPV 9293 0
Jill is trying to determine her class schedule for the next semester. A semester consists of two seven-week half semesters. Jill must take four courses during each half semester. There are five time slots during each semester. Of course, Jill cannot take the same course twice. Jill has associated a
A publishing company is trying to determine which of 36 books it should publish this year.The file Pressdata.xlsx gives the following information about each book:Projected revenue and development costs (in thousands of dollars) Pages in each bookWhether the book is geared toward an audience of
In the equation SEND + MORE = MONEY, each letter represents a different digit from 0–9. Which digit is associated with each letter?
Assume you want to take out a $300,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 6 percent. Twenty years from now, you need to make an ending balloon payment of $40,000. Because you expect your income to increase, you want to structure the loan so that at
Blair’s mother is saving for her daughter’s college education. The following payments must be made at the indicated times:The following investments are available:Today, one year from now, two years from now, three years from now, and four years from now, she can invest money for one year and
I owe $10,000 on one credit card that charges 18 percent annual interest and $5,000 on another credit card that charges 12 percent annual interest. Interest for the month is based on the month’s beginning balance. I can afford to make total payments of $2,000 per month, and the minimum monthly
You have borrowed $50,000 to be repaid in 24 end-of-month payments. The annual rate of interest is 10 percent. In months 7, 13, and 19, the monthly payment increases by $500. How much should you pay each month?
Suppose you want to locate a single restroom so that company employees have to travel the smallest possible distance per day when going to the bathroom. Employees work in four locations within the plant as described in the following table:Assume that employees always walk in a north–south or
Solve Problem 2 if the company wants to locate two restrooms.Data from in Problem 2Suppose you want to locate a single restroom so that company employees have to travel the smallest possible distance per day when going to the bathroom. Employees work in four locations within the plant as described
Cook County General Hospital is attempting to schedule work for its 20 nurses. Each nurse will work four consecutive days and is assigned to one of the following schedules:Each nurse will be assigned for the week to either the ICU or a patient ward. Each nurse’s satisfaction with their assignment
In the fictional state of Politicians Care About the USA, there are eight congressional districts. Each of 15 cities must be assigned to a congressional district, and each district must be assigned from 150,000 to 250,000 voters. The makeup of each district is given below. Assign the cities to
A small job shop needs to schedule six jobs. The due date and days needed to complete each job are given below. In what order should the jobs be scheduled to minimize the total days the jobs are late? Job Processing time 19 2 7 Due date(measured from today) 32 29
A 3-by-3 magic square places the integers 1–9 in the square so that the sum down each column, across each row, and along the two diagonals all equal 15. Use the Evolutionary solving method to design a 3-by-3 magic square.
A small supermarket is trying to determine how many copies of People magazine it should order each week. The owner believes the demand for People is governed by the following discrete random variable:The supermarket pays $1.00 for each copy of People and assumes a copy sells at the store for $1.95.
On average, what will be the sum of the numbers generated by the formula =RANDARRAY(3,4,2,5)?
A greeting-card company is trying to determine how many Valentine’s Day greeting cards to produce. The cost of printing x cards is $2 million + 0.70x. For example, printing 1 million cards costs $2.7 million. Demand for cards follows a normal random variable with a mean of 2 million and a
The demand in pounds for kale salad on Sunday is normally distributed with a mean of 500 and a standard deviation of 100. Kale salad costs $3.00 per pound to produce and sells for $8.00 per pound. At the end of the day, the leftover kale salad has no value. Considering the production levels of 500,
The Monday demand for almond croissants is normally distributed with a mean of 100 and a standard deviation of 25. It costs $1.00 to produce a croissant, which sells for $4.00. Leftover croissants must be disposed of at a cost of $0.40 each. The bakery is considering producing 80, 100, 120, or 140
A supermarket is trying to determine how many meatloaf dinners it should produce on Monday. The Monday demand for meatloaf dinners is normally distributed with a mean of 100 and a standard deviation of 20. The cost of producing a meatloaf dinner is $2.00, and the dinner sells for $7.00. It costs
An auto dealer believes that demand for 2015 model cars will be normally distributed with a mean of 200 and a standard deviation of 30. His cost of receiving a GMC Envoy is $25,000, and he sells an Envoy for $40,000. Half of all the Envoys not sold at full price can be sold for $30,000. He is
How would the optimal bid change if you had 12 competitors?
Suppose you are bidding for an oil well that you believe will yield $40 million (including the cost of developing and mining the oil) in profits. Three competitors are bidding against you, and each competitor’s bid is assumed to follow a normal random variable, with a mean of $30 million and a
Baseball player Robinson Cano is asking for salary arbitration on his contract. Salary arbitration in Major League Baseball works as follows: The player submits a salary that he thinks he should be paid, as does the team. The arbitrator (without seeing the salaries submitted by the player or the
Investor Peter Fischer is bidding to take over a biotech company. The company is equally likely to be worth any amount between $0 and $200 per share. Only the company itself knows its true value. Peter is such a good investor that the market will immediately estimate the firm’s value at 50
A commonly used continuous random variable is the uniform random variable. A uniform random variable—written as U(a, b)—is equally likely to assume any value between two given numbers a and b. Explain why the formula =a+(b–a)*RAND() can be used to simulate U(a, b). With Office 365, how would
Two beverage companies are bidding on the exclusive rights to sell soda at the University of Houston for the next 10 years. Company 1 will earn 50 cents profit per bottle sold (exclusive of the payment to the university) and believes the number of bottles sold during the next 10 years will be
You are bidding on a project to fix all the potholes on Westheimer Road in Houston. You estimate the cost of fixing the potholes is $4 million. Four competitors are going to bid against you. Each competitor’s bid is normally distributed, with a mean of $6 million and a standard deviation of 0.5
Suppose you believe that it is two times more likely that investment returns for each of the next five years will be more like the period 1992–2001 than the period 1972–1991. For example, the chance that next year will be like 1993 has twice the probability that next year will be like 1980.
Many mutual funds and investors hedge the risk that stocks will go down by purchasing put options. How could an asset-allocation model be used to determine an optimal hedging strategy that uses puts?
Determine the correlations (based on the 1973–2012 data) among annual returns on stocks, T-bills, and bonds. Then determine the correlations (based on the 1,000 scenarios created by bootstrapping) among the final values for stocks, T-bills, and bonds. Does it appear that the bootstrapping
Suppose you believe that over the next five years, stocks will produce returns that are 5 percent worse per year, on average, than the 1973–2012 data. Find an asset allocation among stocks, T-bills, and bonds that yields an expected annual return of at least 6 percent, yet minimizes risk. 6 7
Assume the current price of Intel stock is $20 per share. What is the probability that during the next three years, you will earn at least a 30-percent return (for the three-year period) on a purchase of Intel stock? B 3 4 Code 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 D E F 0.014746
Assume the current price of Microsoft stock is $28 per share. What is the probability that in two years, the price of Microsoft stock will be at least $35? 3 4 Code 5 6 7 8 9 10 11 12 13 14 15 16 17 18 B 19 20 21 22 23 D E F 0.014746 0.006237 0.008828 MSFT INTC 1 2 8/2/2002 -0.08316 -0.15397
Solve Problem 1 again, but this time assume that during the next two years, Microsoft will on average perform 6 percent better per year than it performed during the 1997–2002 period for which you have data. B 3 4 Code 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 D E F 0.014746 0.006237
Suppose 30 people are in a room. What is the probability that at least two of them have the same birthday?
What is the probability of getting dealt one pair in five-card draw poker?
What is the probability of getting dealt two pairs in five-card draw poker?
In the game of keno, 82 balls (numbered 1–82) are mixed up, and then 20 balls are randomly drawn. Before the 20 balls are drawn, a player chooses 10 different numbers. If at least five of the numbers are drawn, the player wins. What is the probability of winning?
What odds should the bookmaker give on Kansas winning the Final Four if the bookmaker wants to earn an average of 10 cents per dollar bet?
What is the probability of getting dealt a flush in five-card draw poker?
If you break a one-inch stick in two places that are randomly chosen, you have three smaller sticks. What are the chances that the three sticks form a triangle?
Suppose each hitter on a baseball team has a 50 percent chance of hitting a home run and a 50 percent chance of striking out. On average, how many runs will this team score in an inning?
Katy and Taylor toss a coin 100 times. Each time heads comes up, Katy pays Taylor $1; each time tails comes up, Taylor pays Katy $2. What is the chance that Taylor is never ahead?
You toss a fair coin 20 times. Estimate the chance you throw at least four consecutive heads.
At the beginning of 2015, you have $100 invested in a stock. Each year there is a 60 percent chance that the stock increases 50 percent, a 20 percent chance the stock goes up 10 percent, and a 20 percent chance the stock drops 50 percent. What is the chance that by the beginning of 2065, your cash
In the game blackjack, the dealer draws cards until her total is 16 or higher. Then she stops. Assume an ace counts as 1 and a jack, queen, or king counts as 10. If the dealer draws cards with replacement, what is the chance her final total will be 19, 20, and 21?
You are going to roll a fair die 50 times. If the die comes up even, you are paid the number of dots showing on the die. If the die comes up odd, you lose $1. What is the chance you are ever at least $75 ahead?
Consider three decks of cards. Deck 1 contains 10 cards: three twos, four fives, and three nines. Deck 2 contains four cards that are numbered 1–4. Deck 3 contains six cards numbered 1–6. Gregory draws one card from Deck 1; Taylor draws one card from Deck 2 and one card from Deck 3. What is the
You are testing a new flu drug. Of the 24 flu victims who were given the drug, 20 felt better and four felt worse. Of the nine flu victims who were given a placebo, six felt better and three felt worse. What is the probability that the drug is more effective than the placebo?
A talk on the dangers of high cholesterol was given to eight workers. Each worker’s cholesterol was tested both before the talk and several weeks after the talk, with the results given below. What is the probability that the talk caused the workers to undertake lifestyle changes that reduced
The beta of a stock is simply the slope of the best-fitting line used to predict the monthly return on the stock from the monthly return given in the Standard & Poor’s (S&P) 500 index. A beta that is larger than 1 indicates that a stock is more cyclical than the market, whereas a beta of
Merck is debating whether to invest in a pioneer biotech project. The company estimates that project is worth –$56 million. Investing in the pioneer project gives Merck the option to own, if it wants to, a much bigger technology that will be available in four years. If Merck does not participate
Develop a worksheet that uses the following inputs to compute an annual profit:Annual fixed costUnit costUnit priceAnnual demand = 10,000 – 100 * (price)Protect the cells used to compute the annual demand and annual profit.
You own the rights to a biotech drug. Your best estimate is that the current value of these rights is $50 million. Assuming that the annual volatility of biotech companies is 90 percent and the risk-free rate is 5 percent, what is the value of an option to sell the rights to the drug five years
The current price of copper is 95 cents per pound. The annual volatility for copper prices is 20 percent, and the risk-free rate is 5 percent. In one year, you have the option (if you want it) to spend $1.25 million to mine 8 million pounds of copper. The copper can be sold at whatever the copper
You have an option to buy a new plane in three years for $25 million. Your current estimate of the value of the plane is $21 million. The annual volatility for the change in the plane’s value is 25 percent, and the risk-free rate is 5 percent. What is the option to buy the plane worth?
Showing 600 - 700
of 914
1
2
3
4
5
6
7
8
9
10
Step by Step Answers
Get 50% OFF
Claim Now
