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
A gold mining area in Lanao contains on average 1 ounce of gold per ton. Two methods of processing are available; method a cost 1.5m per ton and recovers 90% of gold: method b cost 1.3m per ton and recovers 80% of the gold. If gold can be sold for 2.4m per ounce which method is better and by how much
The Fly-Right Airplane Company builds small jet airplanes to sell to corporations for use by their executives. To meet the needs of
these executives, the company's customers sometimes order a custom design of the airplanes being purchased. When this occurs, a
substantial start-up cost is incurred to initiate the production of these airplanes. Fly-Right has recently received purchase requests from
three customers with short deadlines. However, because the company's production facilities already are almost completely tied up
filling previous orders, it will not be able to accept all three orders. Therefore, a decision now needs to be made on the number of
airplanes the company will agree to produce (if any) for each of the three customers. The relevant data are given in the next table. The
first row gives the start-up cost required to initiate the production of the airplanes for each customer. Once production is under way.
the marginal net revenue (which is the purchase price minus the…
The 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)
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
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardSales representatives sell two products A and B. Based on historical data there is an average 20 euro commission for every call on product A and a 10 euro commission for every call on product B. Data also shows that sales representatives spend about 3 hours per call for product A and 2 hour for product B. The company requires at least 25 calls per month for each product and not more than 100 calls per month on any one product. How should the sales representatives allocate their monthly 165 working hours between making calls selling products A and B if they want to maximize their commission? a) Mathematically formulate the LP model for maximizing commissions (=primal problem) b) Mathematically formulate the dual problem of the primal problem. Implement both LP models (primal and dual) using Excel Solver. c) Report the optimal objective functions, decision variable values and the shadow prices of both the primal and dual problems. d) Confirm that these numbers are in line with…arrow_forwardSales The Marketing Club at your college has decided to raise funds by selling three types of T-shirt: one with a single-color "ordinary" design, one with a two-color "fancy" design, and one with a three-color "very fancy" design. The club feels that it can sell up to 320 T-shirts. "Ordinary" T-shirts will cost the club $6 each, "fancy" T-shirts $8 each, and "very fancy" T-shirts $10 each, and the club has a total purchasing budget of $3,200. It will sell "ordinary" T-shirts at a profit of $2 each, "fancy" T-shirts at a profit of $5 each, and "very fancy" T-shirts at a profit of $2 each. How many of each kind of T-shirt should the club order to maximize profit? "ordinary" T-shirt(s)"fancy" T-shirt(s)"very fancy" T-shirt(s) What is the maximum profit the club can make?arrow_forward
- As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…arrow_forwardGreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $4 (in thousands)is available for this promotional campaign. Based on- past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R2-12M2-9RM + 20R +37M, Where S = total sales R = amount spent on radio advertising M = amount spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. The problem is formulated as below: Max -2R2-12M²-9RM+20R+37M s.t. 1R+1M=0 Using Excel Solver, solve the above nonlinear optimization model. (a) What…arrow_forwardThe ABC Corporation has been engaged in the manufacture of electronic components for automobiles for the last five years. The company employees 350 employees and about 30 supervisors and managers. The increase in technology requires that employees be sent to cope with the increasing demand for updated new products consistent with the demand of local and foreign customers. The HR Manager suggested that three of the managers and eight supervisors be sent to the mother company in Japan for updates in technology on car electronics. The Vice President for Finance and the Operation Manager opposed the recommendation on the basis of cost-cutting and lack of personnel to handle the operations while they were asway for two months. They suggested that technicians from the mother company be invited instead to handle the training in the Philippines. The cost of training by the mother company would double the cost of training as they are paid higher allowances and salaries that will be charged to…arrow_forward
- A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16arrow_forwardA manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 unitsarrow_forwardA manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?arrow_forward
- Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…arrow_forwardBest Buy is the largest consumer electronics retailer in the United States with 2015 sales of more than $40 billion. The company competes aggressively on price with rivals such as Costco Wholesale, Sam’s Club, Walmart, and Target, but is also known by consumers for its first-rate customer service. Best Buy customers have commented that the retailer’s sales staff is exceptionally knowledgeable about products and can direct them to the exact location of difficult-to-find items. Best Buy customers also appreciate that demonstrationmodels of PC monitors, digital media players, and other electronics are fully powered and ready for in-store use. Best Buy’s Geek Squad tech support and installation services are additional customer service features valued by many customers.Discussion Question:How would you characterize Best Buy’s competitive strategy? Should it be classified as a low-cost provider strategy? A differentiation strategy? A best-cost strategy? Explain your answer.arrow_forwardCompany ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…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,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,