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
Chapter 4, Problem 9QP
Summary Introduction
To determine: The sensitivity report using solver.
a)
Summary Introduction
To determine: The price drop of watermelons for the given condition.
b)
Summary Introduction
To determine: The price increase of cantaloupes for the given condition.
c)
Summary Introduction
To determine: Whether the solution is optimal for the given condition.
d)
Summary Introduction
To determine: The acres that the farmer should lease and the maximum amount to be paid.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Pls help ASAP for both
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
Use the following data to answer all of the remaining questions. Consider a commodity market where the products provided by all sellers are identical.
A group of 12 potential buyers in this market have willingness to pay (WTP) as follows (in random order): $65, $60, $55, $80, $70, $30, $20, $55, $10, $45, $40, and $15.
A group of potential suppliers serving this market have wiliness to accept (WTA) as follows (also in random order): $20, $25, $30, $10, $45, $50, $55, $15, $20, $30, $40, and $60.
What is the value captured by all sellers?
Buyers
2. What is the value captured in this market by an individual buyer with WTP = $80?
3. What is the total consumers surplus (i.e., all buyers) in this market?
Value added
4. What is the value added for the supplier with a WTA (willingness to accept) of $15?
Chapter 4 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
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
- You are the Economic Consultant for Zuku Farms Ghana Limited. Zuku produces cowpea in a community where producers are able to switch back and forth between cowpea and groundnut depending on market conditions. Consequently, you were tasked by the management of Zuku and you estimated the demand function for cowpea as follows: where is the quantity of cowpea demanded in bags per month, is the average price of cowpea in Ghana Cedis, is the average price of groundnut in Ghana Cedis, and Y is the income of consumers. Assuming is initially GH¢31.00 per bag, Y is GH¢1001.50 Required: Find the resulting demand function for cowpea and determine the number of bags Zuku can sell at GH¢ 45.00 per bag. Management is considering increasing price of cowpea by GH¢10.00 per bag. Advise management on this price change using the concept of price elasticity of demand. Explain why management should be worried about a reduction in the price of groundnutarrow_forwardYou are the manager of GearNet and must decide how many Internet hubs to produce to maximize your firm’s profit. GearNet and its only rival (NetWorks) sell dual-speed Internet hubs that are identical from consumers’ perspectives. The market price for hubs depends on the total quantity produced by the two firms. A survey reveals that the market price of the hubs depends on total market output as follows: Combined Hub Production of GearNet and NetWorks Market Price of Hubs (per unit) 500 units $120 750 units $100 1,000 units $90 GearNet and NetWorks each use labor, materials, and machines to produce output. GearNet purchases labor and materials on an as-needed basis; its machines were purchased three years ago and are being depreciated according to the straight-line method. GearNet’s accounting department has provided the following data about its unit production costs: Item GearNet’s Unit Cost for an Output of: 250 units…arrow_forwardWhat is e augmented form of the problem? Why is it called so?arrow_forward
- Please solve The figure below illustrates the demand for money for transaction (L1) and speculative motives (L2) in South Africa: A recession similar to the one experienced between 2009 and 2011 in the global economy will a.Shift curve L1 to the left. b.Shift curve L1 to the left and curve L2 to the right. c.Shift curve L2 to the left and have no impact on curve L1. d.Shift both curves L1 and L2 to the leftarrow_forwardJayZee Electronics wanted to expand its operations by considering of putting up another warehouse to store their electronic supplies from different suppliers. The table below shows the payoff for all alternatives available for JayZee Electronics in all 3 states of nature. The probabilities for every state of nature is also provided. Size of the Warehouse Good Market ($) Fair Market ($) Poor Market ($) Small 40,000 -10,000 -20,000 18,000 Medium 80,000 90,000 Large Very Large -40,000 -160,000 100,000 175,000 350,000 25,000 Probabilities 0.35 0.45 0.20 Using Decision Making under Uncertainty (Use Sheet 1 and rename it to Lastname_Uncertainty) (a) Develop a decision table for this decision. (b) What is the maximax decision? (c) What is the maximin decision? (d) What is the equally likely decision? (e) What is the criterion of realism decision? Use an a value of 0.8. (f) Develop an opportunity loss table. (g) What is the minimax regret decision? Using Decision Making under Risk (Use Sheet 1…arrow_forwardPlease answer all parts A Rhino cement company owns two production plants. Plant 1 costs 20977 per day to operate, and it can produce 330 bags of high-grade cement, 475 bags of medium-grade cement , and 508 bags of low-grade cement each day. Plant 2 is newer and more modern. It costs 22570 per day to operate, and it can produce 435 bags of high-grade cement,271 bags of medium-grade cement, and 274 bags of low-grade cement each day. The company has orders totaling 24539 bags of high-grade cement, 25248 bags of medium-grade cement, and 33749 bags of low-grade cement. How many days should it run each plant to minimize its costs and still produce enough cement to meet its orders? What is the value of the first dual variable? What is the value of the second dual variable? What is the value of the third dual variable? What is the value of dual optimal solution z?arrow_forward
- A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y = 3,600+ 0.16x, where y is the annual cost and x is the miles driven. a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $ b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $ (enter your response as a whole number). (enter your response as a whole number).arrow_forwardGiven the decision tree below, determine which alternative should be purchase given the probability of poor and good economic conditions. Explain your answer.arrow_forwardI want to answer to solve ㅠㅠㅠㅠ. Q1. A builder has located a piece of property that she would like to but and eventually build on. The land is currently zoned for four homes per acre, but she is planning to request new zoning. What she builds depends on approval of zoning requests and your analysis of this problem to advise her. With her input and your help, the decision process has been reduced to the following costs, alternatives, and probabilities Cost of land $2 MillionProbability of rezoning .6If the land is rezoned, there will be additional costs for new roads, lighting, and so on of $1 million. If the land is rezoned, the contractor must decide whether to build a shopping center or 1,500 apartments that the tentative plan shows would be possible. If she builds a shopping center, there is a 70% chance that she can sell the shopping center to a large department store chin for $4 million over her construction cost, which excludes the land; and there is a 30% chance that she can…arrow_forward
- Suppose the equilibrium price for good quality used cars is $20,000. And the equilibrium price for poor quality used cars is $10,000. Assume a potential used car buyer has imperfect information as to the condition of any given used car. Assume this potential buyer believes the probability a given used car is good quality is .60 and the probability a given used car is low quality is .40. Assume the seller has perfect information on all cars in inventory. What policy or mechanism could solve any informational imbalances and restore the market to an efficient allocation of used cars? a. Third-party provided information on the history of the car (ex: maintenance records, accident records, verified millage and verify repairs). b. Legal remedies and laws restricting fraudulent sales of used cars. c. Obtainablepublications discussing quality, price and possible repairs of all cars --used and new. d. All of the above.arrow_forwardDetermining Margin Potential Finding the maximum amount of profit you can generate from one unit of a product is called Margin Potential. This is useful for a company when making a decision about whether to go into production or not. In its simplest form, you can calculate Margin Potential as: Margin Potential = Maximum Price - Minimum Unit Costs Price Use the information table below to find the maximum price that customers deem acceptable. You can find this in the Customer Buying Criteria for each segment. Minimum Material Cost Calculate the minimum Material Cost per segment using the following equation and table below: Minimum Material Cost = [(Lowest Acceptable MTBF * 0.30) / 1000] + Trailing Edge Material Cost Minimum Labor Cost Calculate the minimum Labor Cost for each segment. Assume a base labor cost of $11.20 ($11.20 is a rough estimate of labor cost used solely to illustrate the Margin Potential Concept). Minimum Labor Cost = [$11.20 - (1.12 * Automation Ratings Below)] + 1.12…arrow_forwardDo the following problems using either TreePlan A student is deciding which scholarships (out of two) to accept. The first scholarship is worth $10,000 but carries the condition that recipients cannot accept another other forms of income (such as other scholarships). The second scholarship is awarded in a competition, where this student has a 50% chance of earning $7,000, a 40% chance of earning $10,000, and a 10% chance of earning $15,000. The student must inform the administrator of the first scholarship whether she will be accepting their offer today. A. Develop a decision tree to determine which scholarship this student should accept (using our normal decision criteria). B. Under what circumstance might the student accept the other scholarship?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