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 8QP
Summary Introduction
To determine: The sensitivity report using solver.
a)
Summary Introduction
To determine: The change in the optimal solution when the profit of Bike R decreased to $35.
b)
Summary Introduction
To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.
c)
Summary Introduction
To interpret: The shadow price for the supply of polymer.
d)
Summary Introduction
To determine: The justification for the given statement.
e)
Summary Introduction
To determine: The new optimal level of profit for the given condition.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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 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?
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.c. If the replenishment lead time for wafers is three months, determine the reorderpoint based on the on-hand level of inventory of wafers
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
- 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_forwardSuppose 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_forwardCombined-cycle power plants use two combustion turbines to produce electricity. Heat from the first turbine’s exhaust is captured to heat waterand produce steam sent to a second steam turbine that generates additional electricity. A 968-megawatt combined-cycle gas fired plant can be purchased for $450 million, has no salvage value, and produces a net cash flow(revenues less expenses) of $50 million per year over its expected 30-year life. Solve, a. If the hurdle rate (MARR) is 12% per year, how profitable an investment is this power plant? b. What is the simple payback period for the plant? Is this investment acceptable?arrow_forward
- Can you please answer a and b to this questionarrow_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_forwardA home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?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_forwardThe Fish House (TFH) in Norfolk, Virginia, sells fresh fish and seafood. TFH receives daily shipments of farm-raised trout from a nearby supplier. Each trout costs $2.45 and is sold for $3.95. To maintain its reputation for freshness, at the end of the day TFH sells any leftover trout to a local pet food manufacturer for $1.25 each. The owner of TFH wants to determine how many trout to order each day. Historically, the daily demand for trout is: Demand 10 11 12 13 14 15 16 17 18 19 20 Probability 0.02 0.06 0.09 0.11 0.13 0.15 0.18 0.11 0.07 0.05 0.03 a. Construct a payoff matrix for this problem. b. How much should the owner of TFH be willing to pay to obtain a demand forecast that is 100% accurate? give a clear explanation for (b)arrow_forwardPorter five forces model, developed by Michael E. Porter of Harvard University in 1979, holds the purpose to analyse the industry in order to determine the level of intensity regarding the competition and attractiveness of the industry. The attractiveness of an industry is measured in terms of profit; more profitability means a more attractive industry and low profitability means a low attractive industry. Porter’s Five Forces model is a powerful management tool for analysing the current industry profitability and attractiveness by using the outside-in perspective. Within the last decades, the model has attracted some criticism because of the developing Internet economy. Due to an increasing significance of Digitalization,Globalization and Deregulation, the industry structure of the ‘Old Economy’ changed fundamentally. The ‘New Economy’ is not comparable with the ‘Old Economy’, which is the basis of the Five Forces model. Moreover, the last decades have shown that Information…arrow_forward
- Current Asset Usage Policy Payne Products had $2.4 million in sales revenues in the most recent year and expects sales growth to be 25% this year. Payne would like to determine the effect of various current assets policies on its financial performance. Payne has $3 million of fixed assets and intends to keep its debt ratio at its historical level of 50%. Payne's debt interest rate is currently 9%. You are to evaluate three different current asset policies: (1) a restricted policy in which current assets are 45% of projected sales, (2) a moderate policy with 50% of sales tied up in current assets, and (3) a relaxed policy requiring current assets of 60% of sales. Earnings before interest and taxes are expected to be 11% of sales. Payne's tax rate is 35%. What is the expected return on equity under each current asset level? Round your answers to two decimal places. Tight policy % Moderate policy % Relaxed policy %arrow_forwardSuppose that this particular study compared a large group of individuals who play squash regularly with those of an equal-sized group who get no exercise at all. Playing squash does provide a good cardiovascular workout. However, we also know that squash players tend to be affluent enough to belong to clubs with squash courts. Wealthy individuals may have great access to health care, which can also improve cardiovascular health. If our analysis is sloppy, we may attribute health benefits to playing squash when in fact the real benefit comes from being wealthy enough to play squash (in which case playing polo would also be associ ated with better heart health, even though the horse is doing most of the work). Or perhaps causality goes the other direction. Could having a healthy heart “cause” exercise? Yes. Individuals who are infirm, particularly those who have some incipient form of heart disease, will find it much harder to exercise. They will certainly be less likely to play squash…arrow_forwardYou 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_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,