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
If the Poisson's ratio of an elastic material is 0.4, then find the ratio of modulus of rigidity to Young's modulus..If the Poisson's ratio of an elastic material is 0.4, then find the ratio of modulus of rigidity to Young's Modulus If the Poisson's ratio of an elastic material is 0.4, then find the ratio of modulus of rigidity to Young's modulus...?
Mansfield Energy Corp has recently taken over a fuel supply plant that is in close proximity to one of its competitors. The collection point for both fuel companies is located at the same seaport. The general manager of Mansfield Energy Corp intends to hire a consultant to train Mansfield Energy Corp’s employees regarding the new procedures for affixing the fuel lines at the collection point to the high-capacity storage tanks and is debating whether the competitor should be invited to attend given that they use the same seaport. The general manager is mindful of the high cost of hiring the consultant and sourcing the equipment to train Mansfield Energy Corp’s employees and is therefore hesitant to invite his competitors. The manager is also aware that there have been no accidents at the port since operations started 10 years ago and might not invite the competitors to participate in the training. The General Manager decides, based on the high price for the consultant (facilitation fee,…
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…
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
- An industrial engineer has designed two alternative methods for accomplishing a production job. Both methods involve the acquisition of the same working place and other capital equipment to be used for this job only. Method A calls for a crew consisting of three men each costing Php30/hr. This method will result in the production of 10 units per hour of which two will be reject. Method B calls for a crew of two men each costing Php35/hr and should result in the production of eight units per hour of which one will be reject. The cost of the direct material lost in each reject is Php20. If a certain total number of units is to be produced find which method is economical?arrow_forwardCodeword Codeword is a medium-size firm that designs and manufactures electronic systems for the mass transit industry. It competes with other firms to win contracts to provide such systems. When Codeword receives a contract, it creates a project to complete the work. Most projects range from $10 million to $50 million in cost and from one to three years in duration. Codeword can have 6 to 12 projects going on at any one time, in various stages of completion—some just starting and others finishing. Codeword has a handful of project managers who report to the general manager; other people report to their functional manager. For example, the electronics engineers all report to the manager of electrical engineering, who reports to the general manager. The functional manager assigns particular individuals to work on various projects. Some people work full-time on a project, whereas others split their time among two or three projects. Although individuals are assigned to work for a project…arrow_forwardPaige Turner has been working in a law firm for the last two years and has been bullied by her manager ever since she joined. She is given targets that are impossible to complete within the given time frame. When she is unable to complete her work, her manager admonishes her in front of everyone. In addition, Paige is not invited to take part in discussions that involve making decisions about client's accounts, which are being attended by all other team members.Identify TWO (2) types of workplace discrimination that are evident in this scenario. Justify your answer.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_forwardThe Colonial Housearrow_forward9. Dana is 30 years old and owns a wedding planning business. She takes care of all wedding events details from arranging flowers, tables, theme to catering food to a high standard. She has a good reputation in the market. Recently, she discovered another food catering company with wider varieties and lower prices that her customers will love to have. Thus, she decided to write a negative letter to the current catering company to inform them about terminating their business together. Dana has to plan her negative letter very carefully and to explain the needs of her customers: * A.to avoid responsibility for the message B.to improve future performance on the part of the sender C.to avoid adding a personal message to the recipient D.to gain control of the context of the message E.to minimize damage to the business relationshiparrow_forward
- There are two companies manufacturing drones. Company A manufactures mass market drones, while company B manufactures customised drones according to customers’ requirements. In 2020, company A produces 3,200 drones, 3% of which were found to be defective and cannot pass the quality check. Company A employs 5 workers working an average of 8 hours a day in the drone production, and they worked 200 working days in 2020.In contrast, company B produces 900 drones, 10% of which were found to be defective and cannot pass the quality check. Company B employs 3 workers working an average of 6 hours a day in the drone production, and they worked 170 days in 2020. (a) If the drone manufacturing is seen as a process, what is considered as the output of the production processes of companies A and B and why? (b) Measure the single-factor manpower productivity for the two companies. (c) Is it reasonable to compare the manpower productivity of the two companies and reach a conclusion that one company…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_forwardJOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12arrow_forward
- Company 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_forwardJean is a wealth manager who has recently switched jobs and moved to the London office of a French bank. Jean has more than 10 years of experience as a wealth manager and strong, long relationships with several clients. Most of his clients are based in the Middle East. Jean is eager to start onboarding clients and is putting pressure on his new employer to cut corners and simplify the process. He argues that the onboarding process should be automatic since the clients already held accounts with his previous employer – a US bank with offices in London – so Jean’s previous employer had already reviewed the clients’ information and profiles. Furthermore, and in order not to waste time, Jean says that he should be allowed to informally manage the portfolios of his clients which are still held with his former employer until the clients are fully onboarded. Discuss the approach of John in the context of regulatory guidelines and professional standards.arrow_forwardA convenience store manager earns a base salary plus a small bonus of $190 for each of ten different possible monthly milestones he meets. If the manager meets a milestone, the full bonus is paid. However, if the manager falls even one penny short, none of that bonus is paid. Suppose each of the ten milestones requires 40 hours of effort to meet, and that the manager has 160 hours of effort to allocate to work each month. Question: In order to maximize the total monthly bonus, the manager should allocate___hours toward meeting each of ___ milestones and ___hours toward meeting each of the remaining___ sales milestones. There are 4 blanks to fill for this questionarrow_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,