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 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
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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%?
An airline company has been contracting a maintenance company to do overhauls for its planes at a cost of
$51275 per plane per quarter. The airline company estimates that by building a $1461838 maintenance facility
with a life of 5 years and a residual market value of $770217 at the end of its life, they could handle their own
overhaul at a cost of only $42020 per plane per quarter. What is the minimum number of planes they must
operate to make it just profitable to build this facility? (=2% per quarter).
• 25
O 31
Clear my choice
Digital Controis, 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 3 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 avallable and 1,080 minutes of assembly time availab
The manufacturing cost is $10 per case for model A and $6 per case for model B. Depending upon demand and the time avalable at the Newark plant, DCI occasionally…
Chapter 2 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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 - Prob. 19QPCh. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 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 - For the Lines They Are a-Changin (with apologies...
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_forwardAt the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.arrow_forwardA manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.arrow_forward
- At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…arrow_forwardAt a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…arrow_forwardSturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…arrow_forward
- There is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…arrow_forwardThree 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_forwardChina Mania restaurant’s owners worry about the environment, using paper products made from recycled paper and recycling everything possible. They also gives their employees every Sunday off to be with family, and the restaurant sponsors many local sports teams. It does this while also making sure it is profitable. China Mania demonstratesarrow_forward
- Describe how a continuous simulation model can benefit the business strategy decisions for your chosen business (Retail store)arrow_forwardTaylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…arrow_forwardTaylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…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,