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
Chapter 3, Problem 36QP
a)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
b)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The ABC Corporation has been engaged in the manufacture of electronic components for automobiles for the last five years. The company employees 350 employees and about 30 supervisors and managers. The increase in technology requires that employees be sent to cope with the increasing demand for updated new products consistent with the demand of local and foreign customers.
The HR Manager suggested that three of the managers and eight 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 asway for two 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 charged to…
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…
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 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
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
- In order to produce 1000 units of X in a week units X is scheduled weekly for Operation B (due to 5% scrap ratio) units X is scheduled weekly for Operation A (due to 2% scrap ratio) Based on your answer in part a, find the number of machines required to produce 1000 units of X per week. The total time required to perform Operation B = minutes per week The total time required to perform Operation A = minutes per week H= Available Time in a week = minutes /week Thus FA = . FB = . Since both of the operations A and B are performed on the same machine machines are requiredarrow_forwardAfter finishing your Bachelor of Accounting, you joined a multinational enterprise in 2007. During the last thirteen years in a multinational enterprise, you have performed various roles, including: Evaluating the systems development methodologies and the role of accountants in system development projects, and Appraising the risks inherent in the Enterprise Resource Planning and analysing the role of ethics and the various internal control processes that need to be in place. Recently, you joined a mid-size company for a senior role as a chief information officer. You are excited to perform this senior role. Mark (the head of your organisation) has decided to implement an Enterprise Resource Planning (ERP) system. Recently, Mark has met with a consulting ERP firm based on a friend's recommendation at his club. During a recent meeting, Mark introduced the chief consultant, charming, personable, and seemed very knowledgeable. The CEO's first instinct was to sign a contract with the…arrow_forwardThere 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
- A Las Vegas, Nevada, manufacturer has the option to make or buy one of its component parts. The annual requirement is 20,000 units. A supplier is able to supply the parts for $10 per piece. The firm estimates that it costs $600 to prepare the contract with the supplier. To make the parts in-house, the firm must invest $50,000 in capital equipment, and the firm estimates that it costs $8 per piece to make the parts in-house. Assuming that cost is the only criterion, use breakeven analysis to determine whether the firm should make or buy the item. 1. What is the breakeven quantity? 2. Should the manufacturer Make or Buy? 3. What is the cost savings using your decision in number 2 (above)? Show the total cost for each scenario then the savings amount.arrow_forwardCompany 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_forwardA retail store sold in the month of April 5,000 products that produced $45,000 in sales. In the month of May the company sold 6,000 products. The store workforce consists of four full-time workers who work 40-hour week. In April the store also had seven part-time workers at 10 hours per week, and in May the store had nine part-timers at 15 hours per week (assume four weeks in each month). Using sales dollars as the measure of output (assume the price of the product was the same for both months), what is the percentage change in labor productivity from April to May? Answer: 2.arrow_forward
- discuss the theoretical basis for the use of finite element analysis in predicting stress and deformation in complex mechanical components subjected to various loading conditions.arrow_forwardManufacturing operations can be classified according to the amount of processing or assembly that occurs after a customer order is received. The highest degree of processing occurs in make-to-order operations. A make-to-order operation does not start processing or assembling products until it receives a customer order. A moderate degree of processing occurs in assemble-to-order operations. A company using an assemble-to-order operation divides its manufacturing or assembly process into separate parts or modules. The lowest degree of processing occurs in make-to-stock operations (also called Because the products are standardized, meaning each product is exactly the same as the next, a company using a make-to-stock operation starts ordering parts and assembling finished products before receiving customer orders. A second way to categorize manufacturing operations is by manufacturing flexibility, meaning the degree to which manufacturing operations can easily and quickly change the…arrow_forwardA company that produces fresh cakes daily throws out their unsold cakes at the end of the day. The number of daily customers and sales quantities are available to this bakery. We want to calculate how much the Daily cake production capacity of this company should be. What should we do?arrow_forward
- A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16arrow_forwardA manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?arrow_forwardNewTel is a telephone company with a policy of filling positions internally through promotions, rather than hiring from outside. Until recently, the company had a strong engineering focus and tended to promote people to senior executive positions from the engineering areas. Consequently, almost all of the company's 14 senior executives joined the company over 20 years ago as junior engineers. There is increasing pressure on NewTel to become more market and service oriented. As a result, four people were hired last year from firms to fill new senior executive positions in marketing and service departments. The external hires were necessary because current employees were not sufficiently qualified. Now, there are signs of tension among senior executives, particularly during budget deliberations where there is limited discretionary spending on new corporate activities. The four new hires have been thwarted in their attempts to have the company invest more in marketing and customer…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,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning