Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
APC 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…
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.)
A new electric power generation plant is expected to cost $42,000,000 to
complete. The revenues generated by the new plant are expected to be
$3,875,000 per year, while operational expenses are estimated to be
$2,000,000 per year. The plant will last 40 years, and the electric authority
uses a 3% interest rate. Determine if the plant will be able to recover its
investment using the following methods:
a. IRR (show your solution for interpolation; use 5 decimal places for the
interpolation procedure)
b. Payback period
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
- Problem 1: A government committee is considering the economic benefits of a program of preventative flu vaccinations. We will assume that the flu vaccine is completely effective so if the vaccine is implemented, there will be no flu cases. It is estimated that a vaccination program will cost $9 million and that the probability of flu striking in the next year is 0.70. If vaccinations are not introduced then the estimated cost to the government if flu strikes in the next year is $7 million with probability 0.15, $10 million with probability 0.25 and $15 million with probability 0.6. One alternative open to the committee is to institute an "early-warning" monitoring scheme (costing $3 million) which will enable it to detect an outbreak of flu early and therefore decide whether or not to institute a rush vaccination program (costing $12 million because of the need to vaccinate quickly before the outbreak spreads, again with the vaccine being completely effective) or to do nothing with…arrow_forwardBlueberry, Inc. is a cell phone manufacturer serving the North American market. Current annual demand of their product in North America is 5,000,000. Over the next two years, demand in North America is expected to go up by 50 percent with a probability of 0.80, or go down by 15 percent with a probability of 0.20. Blueberry, Inc. currently has a production facility in N. America with a capacity of 5,000,000 units per year while the variable production cost per phone is $10. Each phone sells for $35. Blueberry, Inc. is contemplating on adding 5,000,000 units of capacity to the plant which will incur an additional fixed cost of $75,000,000. Assume that Blueberry, Inc. uses a discount factor of 12 percent. a. What is the probability that the demand will be more than 10,000,000? b. Will you recommend the option to to Blueberry's VP for Supply Chain? Explain.arrow_forwardThe owner of the Burger Doodle Restaurant is considering two ways to expand operations: open a drive-up window or serve breakfast. The increase in profits resulting from these proposed expansions depends on whether a competitor opens a franchise down the street. The possible profits from each expansion in operations, given both future competitive situations, are shown in the following payoff table: Competitor Decision Open Not Open Drive-up window $-6,000 $20,000 Breakfast 4,000 8,000 Select the best decision, using the following decision criteria. a. Maximax b. Maximinarrow_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_forwardThe total crude oil produced by a country up to the end of 2013 was 20 bn barrels of oil and the remaining oil reserve at the end of 2013 was thought to be 36 bn barrels. The production in 2013 was 0.72 bn barrels. Using Hubbert theory, estimate the total amount of oil extracted up to the peak of production (Qpeak), and the production in the peak year (Ppeak)arrow_forwardSOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.arrow_forward
- The Energy Tech Company is considering making a bid for a fuel processing contract from the Uganda government. Energy Tech's CEO decided to bid $112 million. The management team estimates that it has a 60% chance of winning the contract with this bid amount. If the company wins the contract, it can choose one of three methods for processing the fuel. The company can develop a new method to process the fuel, use the existing process, though inefficient, or to subcontract the processing to a number of smaller companies once they get the fuel. The following tables present the results of these alternatives: DEVELOP NEW PROCESS Outcomes Probability Profit in ($1,000,000s) High success 0.30 $600 Moderate success 0.60 $300 Failure 0.10 ($100) USE CURRENT, BUT INEFFICIENT PROCESS: Outcomes Probability Profit ($1,000,000s) High success 0.50 $300 Moderate success 0.30 $200 Failure 0.20 ($40) SUBCONTRACT: Outcome…arrow_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_forwardCool Beans is a locally owned coffeeshop that competes with two large coffee chains, Planet Euro and Frothies. Alicia, the owner, is considering two different marketing promotions and thinks that CLV analysis will help her decide the best course of action. An average specialty coffee drink sells for $3.14 and has a margin of 79%. One promotion is providing loyalty cards to her regular customers that would give them one free specialty coffee drink after 10 regular purchases. Alicia estimates that this will increase the frequency of their purchases by 16%. Currently, her customers average buying 2 specialty drinks per week. The second promotion is targeted at new customers. She would offer a free specialty drink to incoming college freshmen by providing a coupon with their orientation packages. Because of her location near the college, she expects that 330 students will come to Cool Beans for a free trial of those, she anticipates that 14% will become regular customers who will purchase…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