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
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…
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…
As part of a quality improvement initiative, Enterprise Technology employeescomplete a three-day training program on teaming and a two-day training programon problem-solving. The manager of quality improvement has requested that atleast eight training programs on teaming and at least ten training programs on problem-solving be offered during the next six months. In addition, senior-level managementhas specified that at least twenty-five training programs must be offered during this period.Enterprise Technology hires a consultant to teach the training programs. Duringthe next quarter, the consultant has eighty-four days of training time available. Each trainingprogram on teaming costs ten-thousand dollars and each training program on problem-solvingcosts eight thousand dollars.
a. First step is to formulate a linear programming model that can be used to determine thenumber of training programs on teaming and the number of training programs onproblem-solving that should be offered in…
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_forwardA cost benefit analysis (also known as a benefit cost analysis) is a process by which organizations can analyze decisions, systems or projects, or determine a value for intangibles. The model is built by identifying the benefits of an action as well as the associated costs, and subtracting the costs from benefits. When completed, a cost benefit analysis will yield concrete results that can be used to develop reasonable conclusions around the feasibility and/or advisability of a decision or situation: (1) Make reference to any organisation of your choice as a case study of the firm's products, to discuss, how you can apply Social Cost Benefit Analysis to arrive at the decision rule in your strategic thinking; and (2) Critically discuss steps in Cost Benefit Analysis.arrow_forwardPls help ASAP for botharrow_forward
- In the business model canvas, a description of the value proposition should answer which of the following questions? Multiple Choice How much does it cost to produce our products? How do we reach our customers? How do we produce our products? What do we do for our customers? How do we interact with our customers?arrow_forwardThe Pert Mustangarrow_forwardLake Stevens Marina has estimated that fixed costs per month are $350,000 and variable cost per dollar of sales is $0.30 . The selling price per dollar of sales is: $1.00 Determine the effect on the break-even point in sales dollars considering each of the following independently. 1. Total fixed costs increase to $365,000. Break-even point = ÷ = 2. Variable costs decline to $0.25 per sales dollar. Break-even point = ÷ = 3. The anticipated sales volume increases to $1,100,000. Break-even point = ÷ = Comment on the BEPs from the above analyses in questions 1,2,3.arrow_forward
- 2. 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 $8000. 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. Determine the optimal…arrow_forwardLaura is the associate director of a nonprofit agency that aids children and families. She is the head of a department that focuses on evaluating the skill-building programs the agency provides to families. She reports directly to the agency leadership. Overall, the agency has been cautious in hiring this year because of increased competition for federal grant funding. However, they have also suffered high staff turnover. Two directors, three key research staff, and one staff person from the finance department have left. Laura has a demanding schedule that requires frequent travel; however, she supervises two managers who in turn are responsible for five staff members each. Both managers have been appointed within the last six months. Manager 1: Kelly has a specific background in research. She manages staff who provide research support to another department that delivers behavioral health services to youth. Kelly supports her staff and is very organized; however, she often takes a very…arrow_forwardPlease answer this case. Thank youarrow_forward
- PT. Corona is currently trying to determine the size of the computer system which will provide optimal cost consequences when using the leasing method. The results of each decision choice and acceptance of the business situation (high and low) are summarized in the following table. Situation: Reception High $ 300,000 $ 200,000 $ 100,000 Alternative decisions Low Great leasing system Medium system leasing Small leasing system -$ 15,000 $ 20,000 $ 60,000 The director of this company wants to know which decision is best based on several approaches, namely a) approach optimistic, b) approach conservative, c) approach minimax-regret. Help the Director find the answer.arrow_forwardPROBLEM B 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 should 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 P10,000 and each training program on problem-solving costs P8,000. 1. 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. 2. Graph…arrow_forward: You are employed by Univeristy of Gujrat , a university that provides a range of training and education, including Computing, and Information & Communication Technology (ITC). The Head of Department of ITC, Mr Rumi, has discovered that on more than one occasion recently a computer virus has been introduced to the computers in the department. He thinks that the viruses have been introduced from computer disks brought in by students. He has decided to introduce a system where all disks used in the department must be checked for a virus before they can be put into the computers. He says to you, I would like you to send a memo in my name to all teachers who use the computer rooms. You will have to tell them that all disks brought in by students must be checked before there are used. The teachers have to check them carefully, of course. We have got to stop these viruses being introduced before they cause serious problems. Oh yes, reminds them to lock up the rooms when they leave.…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,