Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The research department of Unilever Ltd has recommended to the marketing department to launch a shampoo of three different types. The marketing manager has to decide one of the types of shampoo to be launched under the following estimated pay offs for various levels of sales:
Estimated levels of sales
15,000
10,000
5,000
1. Egg shampoo
2. Clinic shampoo
3. Deluxe shampoo
3000
1000
1000
3000
3000
250
1000
1000
1000
What will be the marketing manager’s decision if
i. Maximum criterion is applied?
ii. Minimax criterion is applied?
iii. Maximax criterion is applied?
iv. Laplace criterion is used?
v. Hurwicz criterion is used? Use α = 0.75
To what extent may the concept of optimality be used in dynamic programming?
I need 3 answers
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
- Company A proposes a customer loyalty plan, and customers can get reward points for purchasing product A for $100. This reward point can be redeemed for product B for free, or purchase product C, product B and merchant C at a discounted price of $30 The normal stand-alone selling prices of the products are $20 and $50 respectively. Company A estimates that 60% of customers would choose to redeem B for free Commodity, 40% of customers will choose to purchase Commodity C at a discounted price of $30, then the transaction price should be shared among the rewards What is the amount of incentive points? (A)$10.71 (B)$16,67 (C)$19.35 (D)$24.24arrow_forwardDuring the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…arrow_forwardA car company is planning the introduction of a new electric car. There are two options for production. One is to produce the electric car at the company’s existing plant in Illinois, sharing production with its other products that are currently being produced there. If the sales of the electric car are moderate, this will work out well as there is significant capacity to produce all of the products there. However, if sales of the electric car are strong, this option would necessitate Adding a 3rd shift, which would lead to significantly higher costs. Another option is to build a new plant in Ohio. The new plant would have sufficient capacity to meet whatever level of demand for the new car. However, if sales of the new car not strong, the plant would be underutilized and less efficient. Since this is a new product, sales are hard to predict. The forecast indicates there is a 60% chance of strong sales (annual sales of 100,000), and 40% chance of moderate sales (annual sales of…arrow_forward
- How do you know when an optimal solution has been reached?arrow_forwardThe Wisteria University athletic department is considering a campaign next year to raise funds for a new athletic field. To a large extent, the response to the campaign depends on how successful the soccer team is in the fall. In the past they have had winning seasons 60% of the time. If they have a winning season (G), many alumni will contribute and the campaign will raise $3 million. If they have a losing season (P), very few will contribute and they will lose $2 million. If the campaign does not take place, no cost is incurred. On September 1, prior to the start of the season, the athletics department must decide whether to conduct the campaign next year. d) A famous soccer guru, William Walsh, has offered to evaluate whether the team will have a winning season. For $100,000 he will evaluate the team's spring and preseason practices. William will give his prediction on September 1 as to what type of season, G or P, the team will have. In similar situations in the past, when…arrow_forwardThe Wisteria University athletic department is considering a campaign next year to raise funds for a new athletic field. To a large extent, the response to the campaign depends on how successful the soccer team is in the fall. In the past they have had winning seasons 60% of the time. If they have a winning season (G), many alumni will contribute and the campaign will raise $3 million. If they have a losing season (P), very few will contribute and they will lose $2 million. If the campaign does not take place, no cost is incurred. On September 1, prior to the start of the season, the athletics department must decide whether to conduct the campaign next year. a) Develop a decision tree formulation for this problem by identifying the alternative options, the states of nature, and the payoff matrix. b) According to the maximum expected value rule, should the campaign be conducted? c) What is the VEIP? d) A famous soccer guru, William Walsh, has offered to evaluate whether the team…arrow_forward
- In terms of dynamic programming, define the optimality principle.arrow_forwardPROBLEM SOLVING (DECISION THEORY) Example: A farmer wants to decide which of the three crops he should plant on his 100 Acre farm. The profit from each is dependent on the rainfall during the growing seasons. The farmer has categorized the amount of rainfall as high, medium, low. His estimated profit for each is show in the table: Rainfall Crop A Crop B Crop C High 8000 3500 5000 Medium 4500 4500 5000 Low 2000 5000 4000 Determine the various criterion from which the final decision has to be made. If the farmer wishes to plant only one crop, decide which will be his choice using the following criterion•Maximax criterion •Maximin criterion •Hurwicz criterion •Laplace criterionarrow_forward3. The comptroller of Microsoft Corporation has $100 million of excess funds to invest. She has been introduced to invest the entire amount for one year in either stocks or bonds (but not both) and then to reinvest the entire fund in either stocks or bonds (but not both) for one year more. The objective is to maximize the expected monetary value of the fund at the end of the second year. The annual rates of return on these investments depend on the economic environment, as shown in the following table: Rate of Return Economic Environment Stocks Bonds Growth 20% 5% Recession -10% 10% Depression -50% 20% The probabilities of growth, recession, and depression for the first year are 0.7, 0.3, and 0, respectively. If growth occurs in the first year, these probabilities remain the same for the second year. However, if a recession occurs in the first year, these probabilities change to 0.2, 0.7, and 0.1, respectively, for the second year. Construct the decision tree for this problem and…arrow_forward
- Is it possible to describe how optimality is used in dynamic programming?arrow_forwardPaul Atreides wants to save money to meet three objectives. First, he would like to be able to retire 20 years from now with retirement income of $15,000 per month for 20 years, with the first payment received 20 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $100,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $100,000 to Chani, his girlfriend. He can afford to save $3,000 per month for the next 10 years. If he can earn an 10 percent EAR before he retires and an 9 percent EAR after he retires, how much will he have to save each month in years 11 through 20? Note: To provide coherence and organization to your work, arrange your work for this question as follows: Step 1: Convert both EARs to annual nominal rates Step 2: Compute the amount needed at the 20-year mark from now Step 3: Compute the amount in hand at the 10-year mark from now Step…arrow_forwardPaul Atreides wants to save money to meet three objectives. First, he would like to be able to retire 20 years from now with retirement income of $15,000 per month for 20 years, with the first payment received 20 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $100,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $100,000 to Chani, his girlfriend. He can afford to save $3,000 per month for the next 10 years. If he can earn an 10 percent EAR before he retires and an 9 percent EAR after he retires, how much will he have to save each month in years 11 through 20?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill Education
Management (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSON
Business Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSON
Fundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON