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
Codeword
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…
Mono Industries has a project with the following projected cash flows:
Initial Cost, Year 0: P200,000
Cash flow year one: P25,000
Cash flow year two: P75,000
Cash flow year three: P150,000
Cash flow year four: P150,000
Using a 10% discount rate for this project and the NPV model, should this project
be accepted or rejected?
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.
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
- Clinton Financial Consultants is a firm of chartered accountants and financial consultants. Amongst its many activities , it specializes in arranging finance for new entrepreneurs. It helps them in evaluation, preparing viable reports, documentation, legal documentation and finally obtaining a loan from banking or financial institutions. The task involves preparing a proposal, checking the background of the client firm for its creditworthiness, preparing pro forma balance sheets and profit and loss accounts for the term of the loan, carrying out a need analysis, preparing loan agreement documents and finally obtaining the loan for the client. To facilitate better management, the firm uses PERT. It is currently processing the proposed loan for Alfa enterprises. The team assigned for this project has identified the following activities: Activity Description Immediate Predecessor A Start preparing proposal as per template - B Check credit worthiness of firm - C Create a rough draft…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_forwardA manufacturing company intends to develop an application software for automating its design process. The task details associated to the project are shown in Table 1 below. The duration of each task follows a Beta distribution. Project crashing up to a maximum of 2 days per task is allowed, with the exception of tasks B and J, subject to the crash costs being met. Task Task Details Time (days) Optimistic Most likely Preceding Task Crash Pessimistic Cost per day ($) A High-level analysis. 7. Nil 700 B. Selection of hardware platform. 2 1500 C. Installation and commissioning of hardware. Detailed analysis of core modules. 1500 10 12 10 13 A 1500 Detailed analysis of supporting modules. Programming of core modules. E 6. 10 12 1000 F 800 10 15 D Programming of supporting modules. Quality assurance of core modules. 10 15 20 E 800 7 1000 Quality assurance (QA) of supporting modules. Core module training. Development and QA of accounting reporting. L. 8 1500 1 2 C,H 1500 K 2 E 1000…arrow_forward
- Scenario You are going to plant a rectangular flower bed consisting of tulips in the middle surrounded by daisies on the outside. You have the same amount of each flower and will need an equal area for each. You want the border of daisies to be uniform around the tulips in the middle, as shown in the diagram below:arrow_forwardA political party is planning a half-hour television show. The show will have at least 3 minutos of direct requests for money from viowers Three of the party's politicians will be on the show-a senator, a congresswoman, and a governor The senator, a party "elder statesman," demands that he be on screen for at least twice as long as the governor The total time taken by the senator and the governor must be at least twice the time taken y the congresswoman Based on a pre-show survey, it is believed that 33, 38, and 43 (in thousands) viewers will watch the program for each minute the senator, congresswoman, and governor, respectively, are on the air. Find the time that should be allotted to each politician in order to get the maximum number of viewers Find the maximum number of viewers The quantity to be maximized, z, is the number of viewers in thousands. Let x, be the total number of minutes allotted to the senator, x, be the total number of minutes allottod to the congresswoman, and x,…arrow_forward13arrow_forward
- How can we solve this question?arrow_forwardPlease help with solving Part Barrow_forwardThe Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. Use different colors to distinguish the data.arrow_forward
- The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. N (no of Units) Time to Produce Nth Cumulative Time (1 to N) 1 2 3 4 5 6 7 8 9 10arrow_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_forwardGreen Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. a) Define the objective function and constraint equations. b) Graph the feasible region. c) What is a maximum-profit daily production plan at the new factory? d) How much profit will such a plan yield, assuming whatever is produced is sold?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,