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
Videos
Textbook Question
Chapter 3, Problem 26QP
A manufacturer of prefabricated homes has decided to subcontract four components of the homes. Several companies are interested in receiving this business, but none can handle more than one subcontract. The bids made by the companies for the various subcontracts are summarized in the following table.
Assuming all the companies can perform each subcontract equally well, to which company should each subcontract be assigned if the home manufacturer wants to minimize payments to the subcontractors?
- a. Formulate an LP model for this problem.
- b. Create a spreadsheet model for this problem and solve it using Solver.
- c. What is the optimal solution?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Description
Cariveh Co sells automotive supplies from 25 different locations in one country. Each branch has up to 30 staff working there, although most of the accounting systems are designed and implemented from the company's head office. All accounting systems, apart from petty cash, are computerised, with the internal audit department frequently advising and implementing controls within those systems. Cariveh has an internal audit department of six staff, all of whom have been employed at Cariveh for a minimum of five years and some for as long as 15 years. In the past, the chief internal auditor appoints staff within the internal audit department, although the chief executive officer (CEO) is responsible for appointing the chief internal auditor. The chief internal auditor reports directly to the finance director. The finance director also assists the chief internal auditor in deciding on the scope of work of the internal audit department. You are an audit manager in the internal audit…
An action or a decision cannot be ethical unless a leader reaches it using ethical processes. in favor or opposed to the statement
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
- An action or a decision cannot be ethical unless a leader reaches it using ethical processes. in favor or opposed to the statement aboarrow_forwardYour firm has been the auditor of Caribild Products, a listed company, for a number of years. The engagement partner has asked you to describe the matters you would consider when planning the audit for the year ended 31January 2022. During recent visit to the company you obtained the following information: (a) The management accounts for the 10 months to 30 November 2021 show a revenue of $260 million and profit before tax of $8 million. Assume sales and profits accrue evenly throughout the year. In the year ended 31 January 2021 Caribild Products had sales of $220 million and profit before tax of $16 million. (b) The company installed a new computerised inventory control system which has operated from 1 June 2021. As the inventory control system records inventory movements and current inventory quantities, the company is proposing: (i) To use the inventory quantities on the computer to value the inventory at the year-end (ii) Not to carry out an inventory count at the year-end (c)…arrow_forwarddesign a Dashboard with three (3) elements that you think would be useful to the company in providingprudent system analytics. Justify the selection of the three (3) elements and how theycontribute to decision-makingarrow_forward
- [ Solve without using Al" [ For the circuit shown in Fig. 2.20, the transistors are identical and have the following parameters: hfe = 50, hie = 1.1K, hre = 0, and hoe = 0. Calculate Avf, Rif and Rof. Ans: 45.4; 112 KN; 129. 150k ww 47k www + 4.7k Rif 25 V [ 10k 47k 4.7k V₁ [ w 6% R₁1000 50µF Q2 5μF I 33k 50µF 4.7k- 4.7k R₁ Rof www Fig. 2.20 Circuit for Q7. [ [ [ [arrow_forwardIn regards to the Belize Road Safety Project 2012Identify and describe the technique or method used by the project sponsor to select the project among competing or multiple other projects ideas for the country. Hint: (Benefits Measurement, Constrained Optimization, Other?) Identify and describe five (5) characteristics that made this endeavor a project. Use project data or information to support your answer.arrow_forward1.Only give a graph with proper description and 2 immage with proper description of this bellow question and mention that where from u collect that any website/article/book/reserce as reference? One of the most important questions faced by business leaders in the strategic marketing process is a choice of timing to launch new product /technologies and enter new markets. There are two options: to be a pioneer or to be a follower. Both have advantages and risks, the relative success of each strategy depends on several factors, both internal and external. the advantages of being a pioneer and follower companies. product life cycle strategies do successful pioneer and follower companies implement to increase growth and maintain a strong competitive advantage or not, examples of companies to support statements made.arrow_forward
- 1.How relevant are the concepts of competencies to the jobs in a chicken-processing plant? 2.What information sources would be of most significance regarding jobs in a chicken-processing plant? A strategy of growth indicates growing sales, increasing demand, and expanding operations for the organization. When the organization is growing and expanding, it most likely needs to hire new employees in the future. In some cases, the organization may be able to hire employees readily without additional work. If, for example, a firm is currently receiving 100 qualified applicants per month but has only been hiring 5, the firm may be able to meet any targeted growth by simply hiring 10 people per month. In many ways, a stability strategy may be the easiest for the HR manager to implement because the organization presumably must do what it has been doing all along. But, even here, specific and subtle planning nuances must be considered. For example, the organization will naturally…arrow_forwardFinancial accountingarrow_forwardWhat are the Circuit City performance objectives, value vs NVA, opportunities to improve root cause, variation? What are the defects, opportunities, units, metrics, data collection plan, validating the measurement system for the Circuit City company? What is the protocol, methodology, data collection of a case study, could you please explain?arrow_forward
- by the end of 2013, the IPL port was operational and the naphtha was flowing to the HFC plant in Central India after being granted the port contract in Summer 2012. The plant was located in an industrial area that had several pipelines in the general geographic area including a crude oil pipeline leading to a refinery, and a pipeline carrying pesticides to be processed and redistributed to local farms in the area. In July 2014, Ajay Patel, the logistics general manager received notification that there were some minor leaks along the pipeline that were being fixed. Workers in the area had experienced sudden headaches and lightheadedness and the company immediately moved to investigate the leak and address faulty seams that had eroded and weakened. The flow of naphtha was temporarily stopped for 72 hours so two portions of the pipeline could be removed, and the eroded portions replaced. Patel put enormous pressure on the repair team to get the repair done quicker than the usual time…arrow_forwardPatel sat down with the head of public relations, the CEO, and a few Board members to weigh options. On the one hand, they knew there had already been problems along their pipeline causing health concerns a few months before. Apparently, there were substandard materials used in some of the pipeline sections that eroded which they had addressed quickly as soon as they knew there was an issue. This information was public and is one of the reasons why the media was jumping on the story. On the other hand, their pipeline was not the only one in the area. At least two other pipelines moved materials that were dangerous if released in the environment. Was the problem HFC's or another company's or maybe both or ALL? At the present moment until hazard investigation crews could investigate on- site at all the pipelines, there were more questions than answers. Patel had the accident investigation team dispatched to the area. He was debating whether he should call the other companies to jointly…arrow_forward1. Since your manager desires several business reports, justify with an explanation three (3) queries you will likely make regarding the reports' creation. For one (1) report, indicate what type of business report it is (NB! Research Types of Business Reports), outline the layout and possible content relevant to the case scenario (NB! You can show it diagrammatically if desired), and which Management level and Functional area, with justification, would be best served by this report. 2. Design diagrammatically a Form layout with a Subform that facilitates data entry for yourdatabase system. Provide a brief description of the form's purpose and functionality. 3.Identify a feature of MS Access to ensure end-users have a centralised area for accessingand completing tasks. Explain how this feature enhances usability and efficiency.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
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY