MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Long-Life Insurance has developed a linear model that it uses to determine the amount of term life Insurance a family of four should
have, based on the current age of the head of the household. The equation is:
y=150 -0.10x
where
y= Insurance needed ($000)
x = Current age of head of household
b. Use the equation to determine the amount of term life Insurance to recommend for a family of four of the head of the household is
40 years old. (Round your answer to 2 decimal places.)
Amount of term life insurance
thousands
Management of the Toys R4U Company needs to decide whether to introduce a certain new novelty
toy for the upcoming Christmas season, after which it would be discontinued. The total cost required
to produce and market this toy would be $500,000 plus $15 per toy produced. The company would
receive revenue of $35 for each toy sold.
Assuming that every unit of this toy that is produced is sold, write an expression for the profit in terms
of the number produced and sold. Then find the break-even point that this number must exceed to
make it worthwhile to introduce this toy.
Now assume that the number that can be sold might be less than the number produced. Write an
expression for the profit in terms of these two numbers.
Formulate a spreadsheet that will give the profit in part b for any values of the two numbers.
Write a mathematical expression for the constraint that the number produced should not exceed the
number that can be sold.
A salesperson has been trying to create a competitive market analysis (CMA) for a potential listing. The
immediate neighborhood has many bank owned foreclosure properties, which seem to have depressed
the prices showing up in public records and on the MLS system. In this case, the salesperson
A: Can seek similar properties from a neighborhood across town with fewer foreclosures to use as
"comps"
B: Cannot use a CMA since it will not show true market value. The broker should ask the sellers what they
want for their home and list at that price.
C: Should advise the sellers to rent their present home until the market improves. This way they can have
an additional income to allow them to move up to a better home in a better neighborhood. The broker
could then seek to sell the rented home to a house flipper as an investment.
D: Should seek any non-foreclosure "arm's length" transactions for properties similar to her subject
property in the same or nearby neighborhoods. Even if their prices…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.arrow_forwardA company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?arrow_forwardSeas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forward
- Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)arrow_forwardPlay Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.arrow_forwardMULTIPLE CHOICE QUESTIONS An ecommerce company decides to send a gift voucher worth $1000 to a set of customers they believe would make a purchase of at least $5000. They develop a model to identify potential customers who can make a purchase of $5000 if we send the $1000 voucher. Which of the following is more critical about the model? O False negative is worse than False positive if voucher amount crosses $5000 O Both False positive and negative are acceptable O False positive is worse than a False negative O False negative is worse than a False positive Which of the following statements is TRUE? O Tree based models are normally not affected by outliers O Presence of outliers in the data has no effect on Regression models O Standard scaler performs well on features that have outliers O Tree-based models do not rely on dividing the feature space into sub-sectionsarrow_forward
- Arçelik Refrigerator Production Inc. manufactures various types of refrigerators. Currently, it has produced the AA-No Frost type refrigerator and wants to do a research on its market value. The company identified its 6-person expert housewife customer and requested the valuation of the AA-No Frost refrigerator. These customers use a similar type of General Electric refrigerator, and the General Electric refrigerator value is -0.5352 in the valuation of this refrigerator. Values are determined out of 1000. According to this information, what is the value of the AA-No Frost refrigerator? What does it mean when compared to General Electric?arrow_forwardRandolph College and Salem College are within 20 milesof each other, and the students at each college frequentlydate. The students at Randolph College are debating howgood their dates are at Salem College. The Randolphstudents have sampled several hundred of their fellowstudents and asked them to rate their dates from 1 to 5(where 1 is excellent and 5 is poor) according to physicalattractiveness, intelligence, and personality. Following arethe resulting probability distributions for these three traits:arrow_forwardA purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.b. What is the optimal value of the holding and setup costs for wafers when theoptimal source is used?arrow_forward
- A purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.a. Which source should be used, and what is the size of the standing order?arrow_forwardRajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…arrow_forwardJoseph Biggs owns his own sno-cone business and lives 30 miles from a California beach resort The sale of sno-cones is highly dependent on his location and on the weather. At the resort, his profit will be $ 120 per day in fair weather, $10 per day in bad weather. At home, his profit will be $70 in fair weather and $55 in bad weather. Assume that on any particular day, the weather service suggests a 40% chance of foul weather. what decision is recommended by the expected value criterion?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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License