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 3, Problem 23QP
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
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…
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…
Walker 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 6
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 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 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 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 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 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_forwardCompany 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_forward
- The 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_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_forwardTropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession has deflated the market, resulting in many…arrow_forward
- Tropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession has deflated the market, resulting in many…arrow_forwardTropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession has deflated the market, resulting in many…arrow_forwardTropicana is a major producer of orange juice. Different consumers have different valuations for Tropicana orange juice. Twenty-five percent of consumers value a 64 oz carton of juice at $6; while the remaining seventy-five percent value the same carton at $4. In common with many producers of consumer products, Tropicana often distribute coupons. The first group of consumers (the $6 valuation group) dislike the hassle associated with coupons; their disutility from keeping track of a coupon is $1. In contrast, the second group do not greatly mind dealing with coupons, and suffer a disutility of only 15c.(Here, "disutility" is simply a fancy way of saying dislike, with dislike measured in dollar terms.)Tropicana’s marginal cost of producing and distributing the juice is $3. Part (a)What pricing strategy do you suggest that Tropicana adopt Part (b) Tropicana doesn’t distribute coupons in an electronic form that could be stored by a smart phone. Briefly explain why notarrow_forward
- please answer in 30 mins and all parts.arrow_forwardHERO Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of pesos) depends on demand as follows: Demand Demand Demand Staffing Options High Medium Low Own staff 352 325 300 Outsider vendor 450 300 150 Combination 400 325 250 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using:i. the optimistic approach and the conservative approach iii. the minimax regret approach iv. the Laplace methodarrow_forwardTropical Leisure Limited Tropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession has deflated the…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