Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 22QP
Summary Introduction
To determine: The sensitivity report using solver.
a)
Summary Introduction
To determine: Whether the optimal solution is unique.
b)
Summary Introduction
To determine: The total cost increase if it is forced to ship from location 1 to location 3.
c)
Summary Introduction
To determine: The increase in total cost for the given information.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is the best choice of the crop given a constraint of 1000 acres?
Sarah has a startup business that makes two distinct bird feeders that she has designed. Sarah is planning on operating a small factory to build the bird feeders. She is looking at two possible locations, A and B. If she chooses location A, the lease on the building will be higher than location B, thus leading to higher fixed costs than what she would have with location B. However, if she makes more than 20,000 units, both locations will likely have to be expanded, both the physical buildings and the manufacturing equipment. Variable costs to produce each unit will vary by location as well as by product. For example, the first design will have variable costs of $10 and $15 in locations A and B respectively, while the second bird feeder design will have variable costs of $20 and $25 respectively depending on location. However, she thinks that variable costs will decrease if she sells more than 5,000 units, as she will receive discounts from her suppliers at that point. She is unsure of…
A farmers' cooperative association plans to build a new sugar mill in Georgetown. Theprimary objective of the mill is to provide the farmers with a place to take their crop forprocessing that will reduce their transportation costs. The members of the co-op believe thatthe center-of-gravity method is appropriate for this objective. While there are over 200 sugarcane farms in the region, they are tightly clustered around six villages. Using the data below,use the center-of-gravity method to calculate the coordinates of the best location for this mill.All mileage references use Browns Town as (0,0).VillageMiles East ofBrowns TownMiles North ofBrowns TownSugar CanetonnageBarney Valley 90 10 240,000Blue Pasture 140 60 320,000Congo Valley 20 70 450,000Bower 50 20 120,000Rabacca 100 80 60,000Salem 10 120 140,000
Chapter 4 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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
- Even though independent gasoline stations have been having a difficult time. Murad has been thinking about starting her own independent gasoline station. Murad's problem is to decide how large his station would be. The annual returns will depend on both the size of his station and a number of marketing factors related to the oil industry and demand for gasoline. After a careful analysis, Murad developed the following table: Size of the first station Small Medium Large Very large Probability Good market,$ 50 000 80 000 100 000 300 000 20% Fair market,$ 20 000 30 000 30 000 25 000 30% a) what is the maximax decision? b) what is the maximin decision c) what is the equally likely decision (Laplace) d) What is the Expected Monetary Value Criterion (EMV Criterion) Poor market, $ -10 000 -20 000 -40 000 -160 000 50%arrow_forwardDefine the term constraint.arrow_forwardA local real estate investor in Kingston is considering three alternative investments: a motel, a restaurant, or a theater. Profits from the motel or restaurant will be affected by the availability of gasoline and the number of tourists; profits from the theater will be relatively stable under any conditions. The following payoff table shows the profit or loss that could result from each investment:                                                            Real Estate Investor Payoff Table   Payoffs are Profits    States of Nature (Gasoline Availability)  Decision Alternatives Shortage Stable Supply Surplus Motel $–8,000 $15,000 $22,000 Restaurant $2,000 $8,000 $6,000 Theater $6,000 $6,000 $5,000        Which option should the real estate investor choose if he uses the LaPlace criterion?                                                          Using…arrow_forward
- Two vaccination schemes are recently adopted in Lebanon, Pfizer and Astrazenica. The profit for each one of these is dependent on the site (clinic or hospital) performing the vaccination process. This is shown in the following payoff table. Ministry of health considering the maximum profit to be able to cover the cost of staff where vaccination process can either be in a small clinics, or medium size hospitals or in main hospitals     Assume the payoffs represent profits. Determine the alternative that would be chosen under each of these decision criteria: Maximin, Maximax, Laplace. In your own opinion, which alternative likely to be excluded and why?  The ministry of health would like to check the possible loss. Find out the minimax regret table and identify the recommended alternative.  Assuming the probability of getting Pfizer is 0.6 and getting Astrazenica is 40%, determine the expected value of perfect information using the regret table.   Compute the EVPI again…arrow_forwardOhio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: ITT Cost per Thousand Gallons (Y) $1,024 Thousands of Gallons Sold (X) 434.7 Plant 962 466.4 251.3 372. 1,065 1,006 1.045 245.0 258.6 1,068 988 997 1,063 1,000 $10.218 614.9 414.0 267.5 380,4 3 704 9 9 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model is given by the…arrow_forwardA national truck rental services has a surplus of one truck in each of the cities, 1, 2, 3, 4, 5, and 6 and a deficit of one truck in each of the cities 7,8,9,10,11 and 12.The distance (in kilometers) between the cities with a surplus and cities with deficit are displayed below:a) b) How should the trucks be displayed so as to maximize the total distance travelled?                          1                    2                        3                       4                  5                 6 7 41 72 39 52 25 51 8 22 29 49 65 81 50 9 27 39 60 51 32 32 10 45 50 48 52 37 43 11 82 40 40 60 51 30arrow_forward
- Ohio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: ITT Plant 1 Cost per Thousand Gallons (Y) $1,024 Thousands of Gallons Sold (X) 434.7 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 258.6 614.9 7 988 8. 997 414.0 267.5 380.4 3,704.9 9 1,063 1,000 $10,218 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model is…arrow_forwardOhio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: Plant ITT Thousands of Gallons Sold (X) 434.7 Cost per Thousand Gallons (Y) 1 $1,024 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 6. 258.6 7 988 614.9 414.0 8 997 9 1,063 1,000 $10,218 267.5 380,4 3,704.9 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model…arrow_forwardTommy Hilfiger is currently considering to source certain textile goods, Tommy Jeans, from Mexico. The estimated shipping time from Mexico to the U.S. for each shipment of Tommy Jeans is 4 days and the estimated freight cost of each shipment is $800. On the other hand, the current average shipping time from Vietnam to the U.S. for each shipment of Tommy Jeans is 23 days and the average freight cost is $2300. Even though the shipping time and freight cost seem to be much lower in case of Mexico, Tommy Hilfiger management is concerned about the production cost of each Jeans shipment. The management anticipates that the production cost of each Jeans shipment will be higher in Mexico compared to Vietnam. However, Tommy Hilfiger management has decided that even if the total cost (sum of production cost, freight cost, and holding cost) remain similar to Vietnam, Tommy Hilfiger will still source Jeans from Mexico because of the reduced shipping time, which, in turn, will result in better…arrow_forward
- KOOKABOORA CONTAINER CORPORATION (From Business Organization and Management – Dr. Roberto Medina)    When the Clark Special Economic Zone in Pampanga opened its gates for investors in light and medium industries, the Kookaboora Container Corporation (KCC) was among the first ten companies to locate in the zones’s premises. KCC manufactures containers of various shapes and sizes which are used by manufacturers of industrial chemicals, food products, cooking oil, motor oil and others.     The production department of KCC is headed by Engr. Nicolas, a licensed mechanical engineer. He is a tickler for discipline. When even small mistakes happen in his department, he personally calls the offending employee and metes appropriate penalty. As a result, his department was judged best in efficiency. Very minimal wastage in materials and time were recorded by the department.     Under the direct supervision of Engr. Nicolas are 10 supervisors who are graduates of engineering courses and…arrow_forwardKOOKABOORA CONTAINER CORPORATION (From Business Organization and Management – Dr. Roberto Medina)    When the Clark Special Economic Zone in Pampanga opened its gates for investors in light and medium industries, the Kookaboora Container Corporation (KCC) was among the first ten companies to locate in the zones’s premises. KCC manufactures containers of various shapes and sizes which are used by manufacturers of industrial chemicals, food products, cooking oil, motor oil and others.     The production department of KCC is headed by Engr. Nicolas, a licensed mechanical engineer. He is a tickler for discipline. When even small mistakes happen in his department, he personally calls the offending employee and metes appropriate penalty. As a result, his department was judged best in efficiency. Very minimal wastage in materials and time were recorded by the department.     Under the direct supervision of Engr. Nicolas are 10 supervisors who are graduates of engineering courses and…arrow_forwardA company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation costarrow_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,