Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 24QP
a)
Summary Introduction
To formulate: An linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Beagle Clothiers uses a weighted score for the evaluation and selection of its suppliers of trendy fashion garments. Each supplier is rated on a 10-point scale (10 = highest) for four different criteria: price, quality, delivery, and flexibility (to accommodate changes in quantity and timing). Because of the volatility of the business in
which Beagle operates, flexibility is given twice the weight of each of the other three criteria, which are equally weighted (the sum of the four weights equals 1). The table shows the scores for three potential suppliers for the four performance criteria.
9
Rating
Supplier
A
Supplier B Supplier C
8
5
Criteria
1. Price
2. Quality
3. Delivery
8
9
6
5
6
8
4. Flexibility
7
9
6
Based on the highest weighted score, which supplier should be selected?
Supplier should be selected, with a total weighted score of. (Enter your response rounded to one decimal place.)
Emily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer.
Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time.
Emily knows that if any section of…
Adelie Enterprises is exploring a new service to provide weekly delivery of grocery items to homes in the greater Greenwood area. The company’s customers place Web-based orders and Adelie’s team assembles and delivers the orders in specially designed cardboard boxes. Management, interested in locating a supplier that can provide boxes cheaply and efficiently, has discovered that each potential supplier’s ability to satisfy the company’s requirements is influenced by the level of demand. The following table provides Adelie’s vendor selection criteria, criterion weights, and rankings (1–10 with 10 being the highest) under the assumption that low, moderate,or high demand is generated for their service.a. Which supplier should be selected if there is low demand for Adelie’s new service? Which supplier should be selected under moderate demand assumptions? Under high demand assumptions?b. Which supplier is selected if Adelie evaluates each alternative using a Maximin decision criterion (see…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_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_forwardWalker Accounting Software is marketed to smallaccounting firms throughout the U.S. and Canada. Owner GeorgeWalker has decided to outsource the company’s help desk and isconsidering three providers: Manila Call Center (Philippines),Delhi Services (India), and Moscow Bell (Russia). The following table summarizes the data Walker has assembled. Which outsourc-ing firm has the best rating? (Higher weights imply higher impor-tance and higher ratings imply more desirable providers.) PX PROVIDER RATINGS CRITERION IMPORTANCEWEIGHT MANILA DELHI MOSCOWFlexibility 0.5 5 1 9Trustworthiness 0.1 5 5 2Price 0.2 4 3 6Delivery 0.2 5 6 6arrow_forward
- Universal Auto is a large multinational corporation headquartered in the United States. For segment reporting purposes, the company is engaged in two businesses: production of motor vehicles and information processing services. The motor vehicle business is by far the larger of Universal’s two segments. It consists mainly of domestic U.S. passenger car production, but it also includes small truck manufacturing operations in the United States and passenger car production in other countries. This segment of Universal has had weak operating results for the past several years, including a large loss in 2013. Although the company does not reveal the operating results of its domestic passenger car segments, that part of Universal’s business is generally believed to be primarily responsible for the weak performance of its motor vehicle segment. Idata, the information processing services segment of Universal, was started by Universal about 15 years ago. This business has shown strong,…arrow_forwardUniversal Auto is a large multinational corporation headquartered in the United States. For segment reporting purposes, the company is engaged in two businesses: production of motor vehicles and information processing services. The motor vehicle business is by far the larger of Universal’s two segments. It consists mainly of domestic U.S. passenger car production, but it also includes small truck manufacturing operations in the United States and passenger car production in other countries. This segment of Universal has had weak operating results for the past several years, including a large loss in 2013. Although the company does not reveal the operating results of its domestic passenger car segments, that part of Universal’s business is generally believed to be primarily responsible for the weak performance of its motor vehicle segment. Idata, the information processing services segment of Universal, was started by Universal about 15 years ago. This business has shown strong,…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
- A rice importer has three sources: Thailand, Vietnam, and China. Unfortunately, the annual amount of rice harvested is heavily dependent upon the amount of rainfall during the growing season. The tables below show probabilities and prices for wet, dry, and normal growing seasons. Rice is sold in tons. PROBABILITIES Wet Dry Normal Thailand 0.5 0.2 0.3 Vietnam 0.6 0.3 0.1 China 0.4 0.4 0.2 Price per Pound ($) Wet Wet Dry Normal Thailand 0.95 1.10 1.00 Vietnam 0.85 1.20 0.98 China 0.90 1.15 1.05 This is a maximization problem. A)True B)Flasearrow_forwardA rice importer has three sources: Thailand, Vietnam, and China. Unfortunately, the annual amount of rice harvested is heavily dependent upon the amount of rainfall during the growing season. The tables below show probabilities and prices for wet, dry, and normal growing seasons. Rice is sold in tons. PROBABILITIES Wet Dry Normal Thailand 0.5 0.2 0.3 Vietnam 0.6 0.3 0.1 China 0.4 0.4 0.2 Price per Pound ($) Wet Dry Normal Thailand 0.95 1.10 1.00 Vietnam 0.85 1.20 0.98 China 0.90 1.15 1.05 This is a maximization problem. True or False?arrow_forwardThe following payment period ratios, averaged, for borrowings were reported for the year 2021 by five competing biotech firms in San Diego: KLM-0.378 NOP = 0.348 QRS 0.421 UTV -0.355 XYZ 0.353 Question: Which of these five blotech firms reported the most efficient ("best") ratio for loan O Blotech firm XYZ O Biotech firm UTV OBotech firm KLM 1O Blotech firim QRS Botech firm NOParrow_forward
- Company A sells networking equipment to large corporations and federal, state, and local governments. Corporate sales are the result of a competitive bidding process, where Company A competes against other companies based on selling price. Sales to the government, however, are determined on a cost plus basis, where the selling price is determined by adding a fixed markup percentage to the total job cost. James Lopez is the cost accountant for the Electronics Division of Company A. The division is under pressure from senior management to improve income from operations. As James reviewed the division's job cost sheets, he realized that he could increase the division's income from operations by moving a portion of the direct labor hours that had been assigned to the job order cost sheets of corporate customers onto the job order costs sheets of government customers. He believed that this would create a “win–win” for the division by (1) reducing the cost of corporate jobs, and (2)…arrow_forwardProFood Supply Company This case revolves around the issue of sales strategy. Jon is faced with two alternative sales strategies for trying to make his sales quota. Neither appears to be a good short term solution. Summary ProFood Supply Company, founded in New York in 1960, has grown steadily over the decades to become one of the largest full-service institutional food suppliers in the nation, selling perishable and non-perishable foods and foodservice supplies such as tablecloths, napkins, and tableware. In the past year, ProFood had begun an aggressive push into a new market segment, the hotel/motel restaurant market. Jon Menzes, the ProFood sales representative in Nashville, Tennessee, has been with the company for two years and hopes to move into management someday. His sales manager, Emily Lewis, told him that if he finished the year over 100% of his sales versus quota that he would be put into the pool of candidates considered for a promotion during the next twelve months. To…arrow_forwardThe following graph shows the demand curve for uff, a useful commodity produced on the planet Hermes. The Hermetian currency is the yen. The graph input tool also shows how demand for uff is affected by changes in the average income of Hermetians, as well as the prices of tulg and snick, two other related goods available on the planet. Use the graph input tool to help you answer the following questions. You will not be graded on any changes you make to this graph. Note: Once you enter a value in a white field, the graph and any corresponding amounts in each grey field will change accordingly. Suppose that the price of a gram of uff decreased from 50 yen to 45 yen. This would cause a _____(options: movement along, shift of)the demand curve and therefore an increase in ________ (options: the demand for uff, the quantity of uff demanded) Plug any value lower than the current number into the Average Income box. A decrease in average income causes a leftward ________ (options:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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