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 3, Problem 35QP
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
Assuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold.
What is a maximum-profit daily production plan for your company?
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…
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 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 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 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 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 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
- 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_forwardDigital 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…arrow_forwardIn 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_forward
- After 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_forwardThe following information describes the accounting procedures at Soufian Sdn. Bhd. Soufian Sdn. Bhd. is a small construction company which processes its daily transactions manually. Soufian, a senior account executive is spending more money than he can afford. He is the authorized signatory on the company’s bank account and write cheques for himself, his accomplices and his creditors. Here, no one is reviewing the supporting documents or reconciling the bank statements. In addition, he has a complete control over the company’s computerized accounting system. Accordingly, because there was no oversight of his work, Soufian is brave enough to do absolutely nothing to conceal the irregularities on the records. An account clerk assists Soufian, but the clerk job is not requiring much attention, for example, only does filing and retrieving documents, answering phones, responding to emails and running errands. On the other hand, Soufian is occupying too much time with his work by not telling…arrow_forwardAn 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 choicearrow_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_forwardAs 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 costarrow_forwardAs 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.  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.  Graph the feasible region.…arrow_forward
- Richard has been a highly regarded employee of the Brier Corporation for almost 20 years. Her loyalty to the company is reflected in her dedication to her job as general accounting clerk from which she has not taken a vacation in almost 12 years. Because of her dedication and long tenure, she has acquired many related responsibilities, which has allowed the Brier Corp to reduce its work force through attrition, control salary expenses and become more efficient and competitive. The following describes Richard’s responsibilities.  Richard receives copies of credit sales orders from the sales department. From these documents she accesses the AR subsidiary ledger from her office computer and records the AR. She then records the sale in the sales journal and posts the transactions to the general ledger accounts. Cash receipts in payment of customer AR come directly to her office. She records the cash receipts in the GL cash and AR accounts and updates the AR subsidiary ledger. She then…arrow_forwardDenmark Corporation sells computer equipment to businesses in the western region of the United States. Each month, the IT division at Demark Corporation prints monthly statements and sends them to the accounts receivable (AR) department, where a clerk mails them to the customers. This corporation's customers mail their payments back to Denmark, where a clerk in AR batches the checks and sends them to the cashier. The AR clerk then uses the payment stub to enter the payments into the computer, where the AR master data are updated to record the payment. Please use this to complete the diagrams and charts below. Please use excel or word for the diagrams. Problem 1. Please create a table of entities and activities Problem 2. Draw a context diagram to support the entities in problem 1. Problem 3. Draw a physical DFD. Please use MS products i.e. word or excel to create this diagramarrow_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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON