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
is it necessary to identify the cause of the problem?
Business impact analysis (BIA)?What job or home network functions would the BIA identify?
Rare Agri-Products Ltd. is considering a new project with a projected life of seven (7) years. The project falls under the government’s subsidy program for encouraging local agricultural products and is eligible for a one-time rebate of 25% on any initial equipment installed for the project. The initial equipment (IE) will cost $41,000,000. An additional equipment (AE) costing $3,500,000 will be needed at the end of year 3. At the end of seven (7) years, the original equipment, IE, will have no resale value but the supplementary equipment, AE, can be sold for $50,000. A working capital of $1,350,000 will be needed. The project is forecast to generate sales of agri-products over the seven years as follows:
Year 1 70,000 units
Year 2 100,000 units
Years 3-5 250,000 units
Years 6-7 325,000 units
A sale price of $150 per unit for the first two years is expected and then decline to $90 per unit thereafter as the newness of the product loses some sheen. The variable expenses will amount to…
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
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?arrow_forward
- Department of Health contractor for overpriced faceshield and PPE supplies has been able to summarize its total annual fixed costs to as PHP5,000,000 and the total variable cost of production for each set of overpriced faceshield and PPE is PHP2000. A. If IATF agreed that only 5000 units is expected to sell to the government this year, what should the per unit selling be to make a 25% profit this year? B. If foreign sales of 3000 units per year is to be added to the 5000 units government contract above and a % profit is acceptable for this contractor again, what could be the new selling price per unit?arrow_forwardAvondale Industries’ training and development office was asked to develop and implement a training program for its engineers located in its Bengaluru, India site. The program was developed in conjunction with several managers in Bengaluru who needed to improve the flow of their projects, many of which were not delivered on time. The managers felt that project management training would help their engineers develop the skills needed to understand the importance of time management, setting of goals and objectives, and prioritizing their goals to assist in making better use of their time. The training was delivered as requested, but three months later the managers reported they had seen no improvement in meeting project delivery deadlines. Which statement best explains why the training was not effective? Cultural differences were not accounted for when the training and development team organized the training and was thus not effective. The engineers relied too heavily on…arrow_forwardWrite a report to FAA management that describes the primary cause of the problems, a detailed plan to solve them, shows how the plan solves the problems, and describe any other benefits it will provide.arrow_forward
- Alicia Wong Alicia Wong, Corporate Supply Manager, Thain Foods Limited, wanted to prepare a proposal to manufacture mustard in-house. Mustard, an important ingredient in many of the company’s products, was currently purchased from an outside supplier. She hoped a comprehensive proposal could be prepared in one-month’s time for the CEO’s approval Thain Foods Limited (TFL) had been in business for morethan 30 years. Its products included a wide range of syrupsfudges, cone dips, sauces, mayonnaise, and salad dressings. Its customers were major food chains, hotels, and restaurants in North America and Europe. TFL believed in continuous improvement to its operations. Over the last two years, it invested more than $2 million in plant facilities, the bulk of it new, state-ofthe-art process equipment and process control. All production and process control functions were computerized for maximum efficiency. TFL employed about 120 people. It had a corporate structure of CEO; president; executive…arrow_forwardAlicia Wong Alicia Wong, Corporate Supply Manager, Thain Foods Limited, wanted to prepare a proposal to manufacture mustard in-house. Mustard, an important ingredient in many of the company’s products, was currently purchased from an outside supplier. She hoped a comprehensive proposal could be prepared in one-month’s time for the CEO’s approval Thain Foods Limited (TFL) had been in business for morethan 30 years. Its products included a wide range of syrupsfudges, cone dips, sauces, mayonnaise, and salad dressings. Its customers were major food chains, hotels, and restaurants in North America and Europe. TFL believed in continuous improvement to its operations. Over the last two years, it invested more than $2 million in plant facilities, the bulk of it new, state-ofthe-art process equipment and process control. All production and process control functions were computerized for maximum efficiency. TFL employed about 120 people. It had a corporate structure of CEO; president; executive…arrow_forwardPlease read the Case study XSU Spring Concert in Chapter 7, Pg. 237 (Image attached) and answer the following Questions, You are a member of the X State University (XSU) student body entertainment committee. Your committee has agreed to sponsor a spring concert. The motive behind this concert is to offer a safe alternative to Hasta Weekend. Hasta Weekend is a spring event in which students from XSU rent houseboats and engage in heavy partying. Traditionally this occurs during the last weekend in May. Unfortunately, the partying has a long history of getting out of hand, sometimes leading to fatal accidents. After one such tragedy last spring, your committee wants to offer an alternative experience for those who are eager to celebrate the change in weather and the pending end of the school year.You have just finished a preliminary scope statement for the project (attached). You are now brainstorming potential risks associated with the project.1. Identify potential risks associated…arrow_forward
- Zutshwa TrustZutshwa Salt project, operated by the Qhaa Qhing Conservation Trust, is in the process ofexpansion which would result in production increasing threefold and possible export of salt.This was explained by the manager of Local Enterprise Authority (LEA) in Hukuntsi, MrGolebaone Molefe, during a tour of the project by President Dr Mokgweetsi Masisi on Thursday.Dr Masisi, who was in Zutshwa to launch the National Mindset Change campaign, encouragedmanagement of Zutshwa Salt to develop strategies that would grow their business and make itsustainable.However, Mr Molefe said the project was currently not sustainable."The current 44 ponds are not producing enough profit to sustain the business," he said whenbriefing President Masisi during the tour.He said LEA assisted the trust to compile a business plan last year aimed at making the projectprofitable.He said they sent the plan to United Nations Development Programme (UNDP), the SouthernAfrica Development Commission (SADC) and…arrow_forwardDefine a problem statement and provide an example.arrow_forwardA battery manufacturing plant has been ordered to cease discharging acidic waste liquids containing mercury into the city sewer system. As a result, the firm must now adjust the pH and remove the mercury from its waste liquids. Quotations from three firms are included in the following table of costs. Bidder Installed Cost Annual Operating Cost Annual Income from Mercury Recovery Salvage Value Foxhill $ 70,000 $5000 $6500 $10,000 Instrument Quicksilver 50,000 5000 2500 0 Almaden 90,000 5000 7800 10,000 If the installation will last 15 years and money is worth 12%, which equipment should be purchased?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
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