MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
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.)
The Walgreen chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows:
Find the best location using the Center of Gravity Excel template.
Market Segment
Location
Coordinates
Number of Customers
x
y
1
4
15
3300
2
10
13
900
3
5
2
1250
4
9
6
3500
ChocoTown has a 4,000 square foot outlet store that serves five major customer regions, denoted A, B, C, D and E. The locations of the points representing the customer regions and their weekly demands are shown in the table below. The ChocoTown outlet store is at location (10,20).
Customer
Region
Location
Demand
($/week)
A
(0,10)
4,000
B
(0,20)
2,000
C
(20,0)
4,000
D
(30,20)
3,000
E
(40,10)
2,000
CandyTime is a new competitor of ChocoTown and they are considering opening a 4,000 square foot store at location (30,10). Assume the travel time from location i to j in minutes equals the straight line distance from i to j.
a) Use the spatial interaction model to estimate the demand that would be captured by the new CandyTime store.
Demand captured by CandyTime = ___________
b) Suppose the CandyTime store is located at (30,10), but it is not 4,000 square feet. Use the spatial interaction model to find the size in square feet for…
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_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forward
- Mark Ewing has decided to enter contract with uber service provider in his area. The driver offers a car variety of mileage or distance to be travelled to him. All contracts were to be signed for three years. The first option has a monthly rent of P3,000, with a total mileage allowance of 36,000 kilometers (an average of 12,000 kilometers per year) and a cost of P35 per kilometer for any kilometers over 36,000. The following table summarizes each of the Uber Service Contract offered to him: 3-Year Contract Monthly Cost Mileage Allowance Cost Per Excess Kilometer Option A P3,000 30,000 P 35 Option B P3,500 45,000 P 25 Option C P4,000 54,000 P 15 Mark has estimated that, during the 3 years of the agreement, there is a 40% chance he will drive an average of 12,000 kilometers per year, a 30% chance he will drive an average of 15,000 miles per year, and a 30% chance that he will drive 18,000 miles per year. In evaluating the options, Mark would…arrow_forwardAdelie 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…arrow_forwardAPC industries has been experiencing significant growth and has been having difficulty meeting customer demands recently. They are considering three options to address this issue. They can move to a larger facility, add a second shift or use a subcontractor to assist in production. The annual payoff of each option depends on if the current market continues to expand hold s steady or declines. The expected payoff for each combination is shown in the table below Option Expand Steady Decline Move to larger facility 250,000 125,000 -90,000 Add a second shift 175,000 80,000 -45,000 Subcontract 90,000 15,000 -10,000 Which option should APC choose with the Hurwicz criterion with α = 0.5? Using a minimax regret approach, what alternative should she choose? After reading about economic predictions, APC has assigned the probability that the market will be expanded, or be steady or be weak at 20%, 50%, and 30 %. Using expected monetary values, what option should be chosen, and what…arrow_forward
- 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,000arrow_forwardA manufacturing firm plans to expand the current distribution network. The manager of the firm considers whether to extend a long-term contract with the current company who has done business with the firm in the past and whose distribution system reaches 60% of all potential customers. The second option is to sign a one-year contract with a new distribution company. The new company used to reach only 30% of customers, but they claim that they have invested heavily over the past year in distribution resources and now expect to be able to reach 80% of customers. The manager is not that sure about the new company’s claim and give them about 50% of trust. If the new distributor still covers only 30% in year 1, however, the company can switch back to the familiar old distributor. The manager of the firm wants to develop two-scenario plans: 3-year and 10-year planning horizon. Which distributor should the manager choose for each plan? Show your analysis.arrow_forwardE-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?arrow_forward
- Joburg Logistics (JL), a distributor of various products in Polokwane receives their products from suppliers in Durban, Cape Town, and Johannesburg. The company's management is concerned with the supply cost of a certain product that is supplied by a manufacturer in Durban. Currently JL has a contract with Transnet Freight Rail (TFR) for the transport of the orders from Durban. The following are the rail rate and transit time: Transit time (rail) Rail rate 5 days R2.75/unit The impact on the transport and inventory carrying cost because of this arrangement is a concern of the logistics director, Mrs Micky. As a result, Mrs Micky has requested the logistics manager to evaluate the option to use a 3PL service provider for the shipment from Durban to Johannesburg. The logistics manager has identified a certain 3PL company that has the capacity to perform this contract. However, in order to provide a transport rate, the 3PL company required the size and frequency of orders. JL currently…arrow_forwardYour fast-food outlet, Burger Queen, has obtained a license to open branches in three closely situated South African cities: Brakpan, Nigel, and Springs. Your market surveys show that Brakpan and Nigel each provide a potential market of 2,500 burgers a day, while Springs provides a potential market of 1,000 burgers per day. Your company can only finance an outlet in one of those cities at the present time. Your main competitor, Burger Princess, has also obtained licenses for these cities, and is similarly planning to open only one outlet. If you both happen to locate at the same city, you will share the total business from all three cities equally, but if you locate in different cities, you will each get all the business in the cities in which you have located, plus half the business in the third city. The payoff is the number of burgers you will sell per day minus the number of burgers your competitor will sell per day. Set up the payoff matrix. O a. Your Competitor B N S Вг 1,5001…arrow_forwardIn the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2 years, 240 and 240, respectively were sold in fall, 350 and 320 in winter,150 and165 in spring, and 340 and 195 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Fall: Winter: Spring: Summer: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
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY