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 2, Problem 22QP
a)
Summary Introduction
To formulate: An LP model for the problem.
b)
Summary Introduction
To sketch: The feasible region for the problem.
c)
Summary Introduction
To calculate: The optimal solution using corner points.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Casting molds are produced by MYMOLD company. Each order has unique specifications, depending on customer needs. MYMOLD has received an order of two molds from a customer. The agreed selling price of the molds is 5000TL per mold. According to the agreement, for a defective mold the customer will pay 1000TL instead of the standard price. The customer will not buy any more than two molds and there is a 2000 TL fine for not meeting the demand with two non-defective molds. The excess molds can be salvaged for 500 TL per piece. The cost of production per mold is 2000TL and the probability of producing a non-defective mold is 0.8. Assume that MYMOLD decided to produce two molds, and the first production has been succesfull (a non-defective mold is produced). What is the expected profit given the result of the first production?
The annual maintenance costs of a machine that has been in use for 3 years are 300 TL, 350 TL and 375 TL, respectively. The machine is expected to be available for 8 years after purchase. The maintenance costs foreseen for the coming years are 400 TL in the first year and 150 TL in the following years. If the machine is sold today, it can be sold for 1500 TL, and in the following years for 1000 TL. What is the optimum regeneration time of the machine if the MCVO is 10%?
Digital Controls, Inc. (DCI), manufactures two models of a radar gun used by police to monitor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the smaller model B has an
accuracy of plus or minus
miles per hour.
For the next week, the company has orders for 100 units of model A and 150 units of model B. Although DCI purchases all the electronic components used in both models, the plastic cases for both models are
manufactured at a DCI plant in Newark, New Jersey. Each model A case requires 4 minutes of injection-molding time and 6 minutes of assembly time. Each model B case requires 3 minutes of injection-molding time and
8 minutes of assembly time. For next week, the Newark plant has 600 minutes of injection-molding time available and 1,080 minutes of assembly time available. The manufacturing cost is $10 per case for model A and $6
per case for model B. Depending upon demand and the time available at the Newark plant, DCI occasionally…
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - Prob. 1.10C
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_forwardIt costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.arrow_forwardIn this version of dice blackjack, you toss a single die repeatedly and add up the sum of your dice tosses. Your goal is to come as close as possible to a total of 7 without going over. You may stop at any time. If your total is 8 or more, you lose. If your total is 7 or less, the house then tosses the die repeatedly. The house stops as soon as its total is 4 or more. If the house totals 8 or more, you win. Otherwise, the higher total wins. If there is a tie, the house wins. Consider the following strategies: Keep tossing until your total is 3 or more. Keep tossing until your total is 4 or more. Keep tossing until your total is 5 or more. Keep tossing until your total is 6 or more. Keep tossing until your total is 7 or more. For example, suppose you keep tossing until your total is 4 or more. Here are some examples of how the game might go: You toss a 2 and then a 3 and stop for total of 5. The house tosses a 3 and then a 2. You lose because a tie goes to the house. You toss a 3 and then a 6. You lose. You toss a 6 and stop. The house tosses a 3 and then a 2. You win. You toss a 3 and then a 4 for total of 7. The house tosses a 3 and then a 5. You win. Note that only 4 tosses need to be generated for the house, but more tosses might need to be generated for you, depending on your strategy. Develop a simulation and run it for at least 1000 iterations for each of the strategies listed previously. For each strategy, what are the two values so that you are 95% sure that your probability of winning is between these two values? Which of the five strategies appears to be best?arrow_forward
- Three methods can be used for producing heat sensors for high-temperature furnaces. Method A will have a fixed cost of $140,000 per year and a production cost of $62 per part. Method B will have a fixed cost of $210,000 per year and a production cost of $28 per part. Method C will require the purchase of equipment costing $500,000. It will have a life of five years and a 25% of first cost salvage value. The production cost will be $53 per part. At an interest rate of 10% per year, determine the breakeven annual production rate between the two lowest cost methods.arrow_forwardHill's Hardware Store is offering an incentive to customers. For every snowblowerr purchased at Hill's Hardware the customer will recieve a voucher for $25 off a future purchase. Each sale of a snowblower also includes complimentary maintenance. The maintenance can be performed by other vendors but most customers choose to have the maintenance done by Hill's Hardware. The snowblowers also include a one year warranty against any defects in workmanship without any additional charge to the customer. Assume you purchase a lsnowblower from Hill's Hardware. You leave the store with the snowblower and the voucher for $25 off a future purchase. How many performance obligations does Hill's Hardware have for this transaction? Question 18 options: a) 1 b) 2 c) 3arrow_forwardA company is operating in two unrelated businesses. The first one is making common salt, which is sold in one kilogram consumer packs. The second business is making readymade garments. The owner of the businesses has decided to implement Materials Requirement Planning (MRP) in one of the two businesses, which is likely to give him greater benefit. Assuming that the current turnover and profits of both the units are comparable, compare the relative benefits and limitations of Materials Requirement Planning (MRP) for these two businesses.arrow_forward
- FRUIT COMPUTER COMPANY Fruit Computer Company manufactures memory chips in batches of ten chips. From past experience, Fruit knows that 80% of all batches contain 10% (1 out of 10) defective chips, and 20% of all batches contain 50% (5 out of 10) defective chips. If a good (that is, 10% defective) batch of chips is sent to the next stage of production, processing costs of $4000 are incurred, and if a bad batch (50% defective) is sent on to the next stage of production, processing costs of $16000 are incurred. Fruit also has the alternative of reworking a batch at a cost of $4000. A reworked batch is sure to be a good batch. Alternatively, for a cost of $400, Fruit can test one chip from each batch in an attempt to determine whether the batch is defective. QUESTIONS 1.Determine a strategy so Fruit can minimize the expected total cost per batch. 2.Compute the EVSI and EVPI.arrow_forwardA company owns a 5-year-old turret lathe that has a book value of $23,000. The present market value for the lathe is $18,000. The expected decline in market value is $1,700/year to a minimum market value of $4,080; maintenance plus operating costs for the lathe equal $4,470/year.A new turret lathe can be purchased for $46,000 and will have an expected life of 8 years. The market value for the turret lathe is expected to equal $46,000(0.70)k at the end of year k. Annual maintenance and operating cost is expected to equal $1,900. Based on a 12% MARR, should the old lathe be replaced now? Use an equivalent uniform annual cost comparison, a planning horizon of 7 years, and the cash flow approach.EUAC for keeping old turret lathe: $EUAC for replacing turret lathe: $arrow_forwardA suburb of Dayton, Ohio, has four local dry cleaners that compete with each other on the basis of price and service speed. Each of them can perform the same basic services at the same level of quality. The following table provides the price that each dry cleaner charges to clean a two-piece suit, as well as the quoted number of days that the service will take. Dry Cleaner Price Number of Days A $ 8.00 3 B $ 9.50 3 C $ 9.00 2 D $ 7.50 4 Which of these dry cleaners are NOT on the efficient frontier?arrow_forward
- 5. Meg Jones, the CEO of Ajax Computer Company, and Brad Smith, its Director of Operations, had been discussing how to increase the firm’s production of the company’s flagship XR58. The XR58 was particularly important because it sold 12,500 of them in the most recent year for $950, at a gross margin of 55%. After a lot of discussion, they decided to pursue an incentive system designed to increase production by 12% in the next year. After Brad discussed this possible incentive with the production team, the team determined that it could increase production by this amount without adding any more people or equipment. They believed they could accomplish this improvement primarily through process redesign. To incent them to do the hard work of process improvement, Brad told the team that it would receive 25% of the increased profits if it met the new production goal. For this team of 20 people, this would mean an additional compensation of _________ for each team member, on average, for…arrow_forwardA company makes parts that cost $35.00 in material and labor. 92% of the parts are produced defect free and are sold for full price at $110 each. 2% of the parts made must be scrapped. Scrap parts are sold for $8.00 each. The remaining 6% of the parts made must be reworked at a cost of $12.00 each. After rework 1% still must be scrapped and the other 5% is sold at a discounted price of $90 each. a. Draw the tree diagram showing the quality cost situation. b. Determine the earnings per part. c. Determine the cost of poor quality (COPQ). d. Determine the earnings per part and COPQ if the rework operation was shut down and the parts that required reworking were just sold for scrap instead.arrow_forwardDraw the stress relaxation curves of the following models: b. c. a. σ b www d. www b www barrow_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,