Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Students have asked these similar questions
The 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)
E-5 Boston Executive, Inc., produces executive limousines and currently manufactures the mini-bar inset at these costs: (refer the attached image)  The company received an offer from Elite Mini-Bars to produce the insets for $2,100 per unit and supply 1,000 mini-bars for the coming year’s estimated production. If the company accepts this offer and shuts down production of this part of the business, production workers and supervisors will be reassigned to other areas. Assume that for the short-term decision-making process demonstrated in this problem, the company’s total labor costs (direct labor and supervisor salaries) will remain the same if the bar inserts are purchased. The specialized equipment cannot be used and has no market value. However, the space occupied by the mini-bar production can be used by a different production group that will lease it for $55,000 per year. Should the company make or buy the mini-bar insert?
Morton Corporation manufactures computers and wants to select a supplier to purchase chips for its computers. There are two major suppliers of chips – AirBoxChips and SoftChips.  AirBoxChips is a relatively big company and has a good reputation in terms of reliability and delivery. As it is a big company, it provides supply guarantee and sells its products with a higher price. Specifically, it charges $1.20 for each chip that it sells. SoftChips is small company having limited capacity. Even though it charges $0.90 for each chip that it sells, it does not provide supply guarantee. If it is a low-demand year, Softchips is able to satisfy Morton’s demand fully. However, if it is a high-demand year, it allocates only 90,000 chips for the purchase of Morton. If Morton cannot purhcase chips from its contracted supplier, it buys chips on the spot market. Spot market prices for chips are $2.00 per unit in a low-demand year and $4.00 per unit in a high-demand year. Demand in chips has a 75%…

Chapter 14 Solutions

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics

Knowledge Booster
Background pattern image
Management
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY