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 3, Problem 10QP
Summary Introduction
To develop: A spreadsheet model for the problem and solve it using solver.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Long-Life Insurance has developed a linear model that it uses to determine the amount of term life Insurance a family of four should
have, based on the current age of the head of the household. The equation is:
y=150 -0.10x
where
y= Insurance needed ($000)
x = Current age of head of household
b. Use the equation to determine the amount of term life Insurance to recommend for a family of four of the head of the household is
40 years old. (Round your answer to 2 decimal places.)
Amount of term life insurance
thousands
Please answer all parts
A Rhino cement company owns two production plants. Plant 1 costs 20977 per day to operate, and it can produce 330 bags of high-grade cement, 475 bags of medium-grade cement , and 508 bags of low-grade cement each day. Plant 2 is newer and more modern. It costs 22570 per day to operate, and it can produce 435 bags of high-grade cement,271 bags of medium-grade cement, and 274 bags of low-grade cement each day. The company has orders totaling 24539 bags of high-grade cement, 25248 bags of medium-grade cement, and 33749 bags of low-grade cement. How many days should it run each plant to minimize its costs and still produce enough cement to meet its orders?
What is the value of the first dual variable?
What is the value of the second dual variable?
What is the value of the third dual variable?
What is the value of dual optimal solution z?
The state firefighters’ association has a membership of 15,000. The purpose of the organization is to provide some financial support to the families of deceased member firefighters and to organize a conference each year bringing together firefighters from all over the state. Annually, members are billed dues and calls. “Calls” are additional funds required to take care of payments made to the families of deceased members. The bookkeeping work for the association is handled by the elected treasurer, Bob Smith, although it is widely known that his wife, Laura, does all of the work. Bob runs unopposed each year at the election, since no one wants to take over the tedious and time consuming job of tracking memberships. Bob is paid a stipend of $8000 per year, but his wife spends well over 20 hours per week on the job. The organization, however, is not happy with their performance. A computer system is used to track the billing and receipt of funds. This system was developed in 1984 by a…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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_forwardDuring the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…arrow_forwardhow to solve this in excel solver?arrow_forward
- The XYZ Corporation has been engaged in the manufacture of electronic components for automobiles for the last 5 years. The company employs 350 employees and about 30 supervisors and managers. The increase in technology requires that employees be sent to training to cope with the increasing demand for updated new products consistent with the demand of local and foreign customers. The HR manager suggested that 3 of the managers and 8 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 away for 2 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…arrow_forwardPrepare and run the LP to solve this problemarrow_forwardLong-Life Insurance developed a linear model to determine the amount of term life insurance a family of four should have, based on the head of the household's current age. The equation is: y = 163 -0.45xwherey = Insurance needed ($000)x = Current age of head of household Calculate the amount of term life insurance you would recommend for a family of four if the head of the household is 53 years old. (Round your answer to 2 decimal places.)arrow_forward
- Emily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer. Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time. Emily knows that if any section of…arrow_forwardThe new Chief Operating Officer (COO) of Lee Ching Chemical Company, MaxChing, has found that the firm has been dumping its toxic waste into the local riverfor the last four years and falsifying information to officials about the amounts ofalleged cancer-causing materials in the waste. The plant overseer claims there is noevidence that the waste will cause cancer. Besides, within a hundred kilometersdownriver, there are only a few fishing villages. If the company had to treat thesubstance to neutralize its potentially harmful effects and transport it to a legaldumpsite, the operating costs of the company would rise to a level that could renderthe company uncompetitive. When the organization loses its competitive advantage,five thousand local workers can become unemployed and the economy of that towncould collapse. Question: If you were the COO, what would you do? Why?arrow_forwardMichael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 percent. He has decided to invest no more than 30 percent of the total amount in Fund B and no more than 40 percent of the total amount in Fund C. a. Formulate a linear programming model that can be used to determine the amount of investments Michael should allocate to each type of fund to maximize the total annual return.b. How much should be allocated to each type of fund? What is the total annual return?arrow_forward
- A linear programming computer package is needed. Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follows. Bean Cost per Pound Available Pounds 1 2 3 1 $0.50 2 $0.70 3 $0.45 Consumer tests with coffee products were used to provide ratings on a scale of 0-100, with higher ratings indicating higher quality. Product quality standards for the blended coffee require a consumer rating for aroma to be at least 75 and a consumer rating for taste to be at least 80. The individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows: Bean Aroma Rating Taste Rating 75 85 60 85 lb lb lb 450 87 650 74 450 Assume that the aroma and taste attributes of the coffee blend will be a weighted average of the attributes of the beans used in the blend. (a) What is the minimum-cost blend (in pounds) that will meet the quality standards and provide 1,000 pounds of the blended…arrow_forwardModern Oak Furniture Limited had been in business for more than 40 years, serving customers in Southwestern Ontario. The business consists of three different divisions Custom Designs Division Manufacturers crafted items, such as dining room suites Kitchen Cabinets Division Manufactures kitchen cabinets Banister Division Manufactures and installs quality oak railings Each division reports to a Vice-President, who in turn report to the President of the company, Mr. Frederick Johannsson, who was also to founder of the company. Total sales for all divisions are projected to reach 10,000,000.00 in the current fiscal year. Mr. Johannsson has been quite pleased with the performance of two of the divisions, Custom Designs and Kitchen Cabinets, which together account for about 85% of the company’s sales revenue. He does however, have some concerns about the Banister Division based on the previous year’s profit performance and the first week of August’s sales report for the…arrow_forward
arrow_back_ios
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,