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_forwardG.97.arrow_forward
- The Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large amount of individual person-hours, so for planning purposes, the company would like to forecast future demand, specifically through its Web site, which has increasingly become the primary source of sales. Following is the company’s Web site demand (in items sold) for the past 36 months: Develop a linear trend forecast model, an exponentially smoothed model (a = 0.20), and a 5-month moving average forecast model and indicate which one you think should be used to forecast Web site demand.arrow_forwardBargain 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_forward
- JMA 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_forwardABC Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the management (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The profit of the operations depends on future demand. The annual profit of each option (in thousands of dollars) and for each state of demand is summarized in the following table: Staffing Options Own Staff Outside Vendor Combination High 650 900 800 Demand Medium 650 600 650 Low 600 300 400 1. If the manager of ABC Corporation is optimistic, which staffing option will he/she choose? 2. If the manager of ABC Corporation is conservative, which staffing option will he/she choose? 3. Suppose the probabilities of high, medium, and low demand are 40%, 10% and 50%, respectively. Using the expected value approach, which staffing option should the manager choose? 4. What is the expected value of perfect information?arrow_forwardAntonio Banderos & Scarves sells headwear that is very popular in the fall-winter season. Units sold are anticipated as follows: October 1,700 November 2,700 December 5,400 January 4,400 14,200 If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. The production manager thinks the above assumption is too optimistic and decides to go with level production to avoid being out of merchandise. She will produce the 14,200 items at a level of 3,550 per month. a. What is the ending inventory at the end of each month? Compare the units sold to the units produced and keep a running total. (Do not leave any empty spaces; input a O wherever it is required. Negative values should be indicated by a minus sign.) October November December January Antonio Banderos & Scarves Units sold Units Produced Change in inventory Ending inventory b. If the inventory costs $4 per unit and will be financed through the bank at 12…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