Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 15, Problem 5P
Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows:
- a. If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation?
- b. Construct a risk profile for the optimal decision in part (a). What is the
probability of the cost exceeding $700,000?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
XYZ Manufaturing company has hired a new VP (D.A.King) for managing capacity investment decisions. Mr. King reviews the situation after he comes on board and decides that he can invest in Batch manufacturing, Custom manufacturing or Group technology. Mr. King will not be able to forecast demand accurately till after the technology choices are made. Demand will be classified into four scenarios: poor, fair, good and excellent. The table below indicates the payoffs for each combination of technology choice and demand scenario.
POOR
FAIR
GOOD
EXCELLENT
PROBABILITY
0.1
0.4
0.3
0.2
Batch
- $200,000
$1,000,000
$1,200,000
$1,300,000
Custom
$100,000
$300,000
$700,000
$800,000
Group Technology
- $1,000,000
-$500,000
$500,000
$2,000,000
1.What is the expected monetary value of choosing the Group Technology option?
2.What is the expected monetary value of choosing the Batchoption?
3What is the BEST decision based on…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:
MONTH
DEMAND (UNITS)
January
4,200
February
4,300
March
4,000
April
4,400
May
5,000
June
4,700
July
5,300
August
4,900
September
5,400
October
5,700
November
6,300
December
6,000
Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
To be reasonably confident of meeting demand, Nina decides to use three standard errors of estimate for safety. How many additional units should be held to meet this level…
First Securities, Inc., an investment firm, has $380,000 on account. The chief investment officer would like to reinvest the $380,000 in a portfolio that would maximize return on investment while at the same time maintaining a relatively conservative mix of stocks and bonds. The following table shows the investment opportunities and rates of return.
Investment Opportunity
Rate of Return
Municipal Bonds (X1)
0.095
High Tech Stock (X2)
0.146
Blue Chip Stock (X3)
0.075
Federal Bonds (X4)
0.070
a) The Board of Directors has mandated that at least 60 percent of the investment consist of a combination of municipal and federal bonds, at least 25 percent Blue Chip Stock, no more than 30 percent High Tech and Blue Chip Stock, and no more than 15 percent High Tech Stock.
Based on above problem, how many constraints are in this problem?
A) 3
B) 4
C) 5
D) 2
b) Based on part a, which of the…
Chapter 15 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 15 - Prob. 1PCh. 15 - Southland Corporation’s decision to produce a new...Ch. 15 - Amy Lloyd is interested in leasing a new Honda and...Ch. 15 - Investment advisors estimated the stock market...Ch. 15 - Hudson Corporation is considering three options...Ch. 15 - Prob. 6PCh. 15 - Myrtle Air Express decided to offer direct service...Ch. 15 - Video Tech is considering marketing one of two new...Ch. 15 - Seneca Hill Winery recently purchased land for the...Ch. 15 - Hemmingway, Inc. is considering a $5 million...
Ch. 15 - The following profit payoff table was presented in...Ch. 15 - Suppose that you are given a decision situation...Ch. 15 - A firm has three investment alternatives. Payoffs...Ch. 15 - Alexander Industries is considering purchasing an...Ch. 15 - In a certain state lottery, a lottery ticket costs...Ch. 15 - Three decision makers have assessed utilities for...Ch. 15 - In Problem 22, if P(s1) = 0.25, P(s2) = 0.50, and...Ch. 15 - Translate the following monetary payoffs into...Ch. 15 - Consider a decision maker who is comfortable with...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- If during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.arrow_forward23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes 1/2 of the food and 1/3 of the manufactured goods. Manufacturing consumes 1/2 of the food and 2/3 of the manufactured goods. Assuming the economy is closed and in equilibrium, find the relative outputs of the farming and manufacturing industries.arrow_forwardHudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Staffing Options Demand High Own staff Outside vendor Combination Medium Low 650 900 800 650 600 600 300 650 500 If the demand probabilities for high, medium and low are 0.2, 0.5, and 0.3, respectively. What is the probability of the cost exceeding $700,000?arrow_forward
- A manager of inventory systems believes that inventory models are important decision- making tools. The manager often uses an Economic Order Quantity policy, but has never considered a backorder model, because the company has always treated backorders as a bad practice to be avoided. However, with upper management's continued pressure to cut costs, you have been asked to analyze the economics of a backorder policy for some products. A specific product has annual demand of 800 units, an order cost of $150/order, an annual holding cost of $3/item, and a backorder cost of $20/item. Your task it to determine the annual savings, when compared with an EOQ model, that backorders would allow. Assume 250 working days per year.arrow_forwardThe Arctic Air Company produces residential air conditioners. The manufacturing manager wants to develop a sales and operations plan for the next year based on the following demand and capacity data (in hundreds of product units): Undertime is unpaid, and no cost is associated with unused overtime or subcontractor capacity. Producing one air conditioning unit on regular time costs $1,000, including $300 for labor. Producing a unit on overtime costs $1,150. A subcontractor can produce a unit to Arctic Air specifications for $1,250. Holding an air conditioner in stock costs $60 for each 2-month period, and 200 air conditioners are currently in stock. The plan calls for 400 units to be in stock at the end of period 6. No backorders are allowed. Use the transportation method to develop a plan that minimizes costs.arrow_forwardMyrtle Air Express decided to offer direct service from Cleveland to Myrtle Beach. Management must decide between a full-price service using the company’s new fleet of jet aircraft and a discount service using smaller capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service to Myrtle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Demand for Service Service Strong Weak Full price $960 -$490 Discount $670 $320 1. Suppose that the probability of strong demand is 0.8 and the probability of weak demand is 0.2. What is the optimal decision using the expected value approach?Optimal Decision: Use graphical sensitivity analysis to determine the range of demand probabilities for which each of the decision…arrow_forward
- Myrtle Air Express decided to offer direct service from Cleveland to Myrtle Beach. Management must decide between a full-price service using the company’s new fleet of jet aircraft and a discount service using smaller capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service to Myrtle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Demand for Service Service Strong Weak Full price $960 -$490 Discount $670 $320 d. Suppose that the probability of strong demand is 0.8 and the probability of weak demand is 0.2. What is the optimal decision using the expected value approach?Optimal Decision: e. Use graphical sensitivity analysis to determine the range of demand probabilities for which each of the decision…arrow_forwardG.97.arrow_forwardMyrtle Air Express decided to offer direct servide from Cleveland to Myrtle Beach. Management must decide between a full-price service using the company's new fleet of jet aircraft and a discount service using smaller-capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based on three possible levels of demand for service to Myrtle Beach: strong, medium and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Demand for Service Service Strong Medium Weak Full Price 950 600 -400 Discount 750 450 300 Probability 0.4 0.3 0.3 Suppose that management of Myrtle Air Express has developed the following utility function: U(950) = 100, U(750) = 89, U(600) = 72, U(450) = 58, U(300) = 48, and U(-400) = 0. Use the expected utility approach to determine the optimal decision. What is the…arrow_forward
- Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February 25,000 March April 20,000 May June July August September October November December Exercise 5A-2 Part 1 (Algo) 15,000 Required: 1. Prepare a scattergraph plot. (Place car wash costs on the vertical axis and rental returns on the horizontal axis.) Instructions: Car Wash Costs (in dollars) 30,000 10,000 Rental Returns Car Wash Costs $ 11,400 $ 13,300 $ 12, 200 $ 14,900 $ 16,600 $ 24,100 $ 22,600 $ 23,200 $ 23,200 $ 22,300 $ 11,100 $ 15,600 1. On the graph below, use the point tool (January) to plot rental returns on the horizontal axis and car wash costs on the vertical axis. 5,000 2. Repeat…arrow_forwardJMA Manufacturing is considering expanding the company’s manufacturing capacity at its New Bern plant. Engineering has developed estimates for three expansion plans. A small expansion will cost $1 million. A medium-sized expansion will cost $2 million, while a major expansion will cost $5 million. The income generated by the expansion will depend on the demand for JMA’s product. Marketing has developed estimates for the net present value (not including the fixed cost of the capacity expansion) associated with each of the expansion alternatives based on low and high demand scenarios. If JMA decides to go with the small expansion, marketing estimates the company can earn $0.5 million if demand is low and $2 million if demand is high. With the medium expansion, income will be $2 million (low demand) and $3 million (high demand). With the large expansion, marketing estimates income will be $4 million if demand is low and $8 million if demand is high. Marketing estimates there is a one in…arrow_forwardJMA Manufacturing is considering expanding the company's manufacturing capacity at its New Bern plant. Engineering has developed estimates for three expansion plans. A small expansion will cost $1 million. A medium-sized expansion will cost $2 million, while a major expansion will cost $5 million. The income generated by the expansion will depend on the demand for JMA's product. Marketing has developed estimates for the net present value (not including the fixed cost of the capacity expansion) associated with each of the expansion alternatives based on low and high demand scenarios. If JMA decides to go with the small expansion, marketing estimates the company can earn $0.5 million if demand is low and $2 million if demand is high. With the medium expansion, income will be $2 million (low demand) and $3 million (high demand). With the large expansion, marketing estimates income will be $4 million if demand is low and $8 million if demand is high. Marketing estimates there is a one in…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Mod-01 Lec-01 Discrete probability distributions (Part 1); Author: nptelhrd;https://www.youtube.com/watch?v=6x1pL9Yov1k;License: Standard YouTube License, CC-BY
Discrete Probability Distributions; Author: Learn Something;https://www.youtube.com/watch?v=m9U4UelWLFs;License: Standard YouTube License, CC-BY
Probability Distribution Functions (PMF, PDF, CDF); Author: zedstatistics;https://www.youtube.com/watch?v=YXLVjCKVP7U;License: Standard YouTube License, CC-BY
Discrete Distributions: Binomial, Poisson and Hypergeometric | Statistics for Data Science; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=lHhyy4JMigg;License: Standard Youtube License