Use Excel to draw a decision tree. Knoop Inc. has completed the first year of operations and
No answer yet for this question.
Ask a Tutor
Question:
Use Excel to draw a decision tree.
Transcribed Image Text:
Knoop Inc. has completed the first year of operations and they did end up selling 50,000 bikes in the first year. You believe that you will sell another 50,000 bikes next year. You have a proposal to further expand capacity and introduce some new models. There are three new technologies and you may choose one of them for expansion (or you may decide not to invest and stay with your current sales). Each will require investment in new production lines and some product development costs. While you have a hunch that you may sell 'a lot more' bikes made from new technology, you have no conclusive argument on estimating the true market potential. Your team has come up with an optimistic and a pessimistic sale scenario but you still think that there is a 50-50 chance of either! Assume each bike sold nets $500 in profit. You and your team are particularly excited about the new technologies and think they can afford to invest in one of them. Table 1 summarizes the annual incremental cost of each technology and sales potential. While the cost estimates are pretty good the supplier has warned of inflationary pressures and that there is 25% chance of a cost overrun (meaning probability is 0.25). Table 1: Hi-Tech Bikes Data Technology AI AI + Solar AI Carbon Fiber Normal Cost $ million/year 1.0 1.5 1.7 Overrun Cost million/year 1.2 1.7 1.9 Optimistic Sale Pessimistic Sa (thousands) (thousands) 75 55 80 55 90 50 a. Use the decision tree tool to analyze their problem and propose what should they do? Submit a well formatted decision tree. (15 points) b. How will your recommendation in (a) will change if the AI + Solar cost estimates dropped to $0.8 and $ 1.0 million? (3 points) c. What will be your decision if they could sell 55,000 bikes with the current con- figuration (no new investment) by spending additional $200,000 on advertising? (2 points) 3 Knoop Inc. has completed the first year of operations and they did end up selling 50,000 bikes in the first year. You believe that you will sell another 50,000 bikes next year. You have a proposal to further expand capacity and introduce some new models. There are three new technologies and you may choose one of them for expansion (or you may decide not to invest and stay with your current sales). Each will require investment in new production lines and some product development costs. While you have a hunch that you may sell 'a lot more' bikes made from new technology, you have no conclusive argument on estimating the true market potential. Your team has come up with an optimistic and a pessimistic sale scenario but you still think that there is a 50-50 chance of either! Assume each bike sold nets $500 in profit. You and your team are particularly excited about the new technologies and think they can afford to invest in one of them. Table 1 summarizes the annual incremental cost of each technology and sales potential. While the cost estimates are pretty good the supplier has warned of inflationary pressures and that there is 25% chance of a cost overrun (meaning probability is 0.25). Table 1: Hi-Tech Bikes Data Technology AI AI + Solar AI Carbon Fiber Normal Cost $ million/year 1.0 1.5 1.7 Overrun Cost million/year 1.2 1.7 1.9 Optimistic Sale Pessimistic Sa (thousands) (thousands) 75 55 80 55 90 50 a. Use the decision tree tool to analyze their problem and propose what should they do? Submit a well formatted decision tree. (15 points) b. How will your recommendation in (a) will change if the AI + Solar cost estimates dropped to $0.8 and $ 1.0 million? (3 points) c. What will be your decision if they could sell 55,000 bikes with the current con- figuration (no new investment) by spending additional $200,000 on advertising? (2 points) 3
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these economics questions
-
In the decade of the 2010s, the plans and operations of Avon Inc. in marketing, research, and manufacturing throughout Asia are still being affected by actions taken after a 1998 meeting. The US...
-
In the decade of the 2010s, the plans and operations of Avon Inc. in marketing, research, and manufacturing throughout Asia are still being affected by actions taken after a 1998 meeting. The US...
-
If an object is dropped from a height h, then the time t required for the object to strike the ground is directly proportional to the square root of h. If it requires 1 second for an object to fall...
-
Explain how crime can be prevented as it relates to the beliefs of the classical school of criminology; Assess the major components of the classical school of crime causation; Discuss specific and...
-
A novel process has been proposed to create a composite palladium tube for use as a hydrogen separation membrane in order to produce high-purity hydrogen. To fabricate the composite palladium tube, a...
-
Research sustainability efforts that have been taken by colleges and universities. List three measures your school (or any school in your state) has enacted to address this concern.
-
Purex produces three different types of detergents: Breeze, Fresh, and Joy. The company uses four operations to manufacture the detergents: spray drying, mixing, blending, and packaging. Breeze and...
-
1. What is a data structure? 2. Why do we need data structures? 3. List some common data structures. 4. How data structures are classified? 5. Differentiate linear and non-linear data structure.
-
It is now Prime Day, the deal is selling well, but you just got a call from the vendor explaining that they will not be able to fill any more units for the next 3 weeks. Your Instock Manager (Anjali...
-
The good thing about programming at a low level is that code can be very efficient in terms of space and time. Write a program in assembly language that adds up four even numbers as word variables...
-
Right-tailed test with \(\alpha=0.01\), degrees of freedom in the numerator \(=12\), degrees of freedom in the denominator \(=25\). Find the critical value( \(s\) ) for \(\alpha\).
-
Which of the three raysalpha, beta, or gammahas the greatest penetrating power?
-
An electron confined to an atom has waves that are what?
-
Define the expected real after-tax interest rate. If the tax rate on interest income declines, what happens to the expected real after-tax interest rate?
-
Which type of radiationalpha, beta, or gammaresults in the greatest change in mass number? The greatest change in atomic number?
-
(a) A person drinks fours glasses of cold water (3 C) every day. The volume of each glass is 250 mL. How much heat (in kJ) does the body have to supply to raise the temperature of the water to 37 C,...
-
The cash records of Holly Company show the following four situations. 1. The June 30 bank reconciliation indicated that deposits in transit total $720. During July, the general ledger account Cash...
-
Three things set The Pampered Chef, a direct selling company, apart from its competition in the housewares industry: a passion for providing unique, quality products, a dedication to ensuring...
-
Although licensing and contracting may appear to be desirable, they have drawbacks. What are the drawbacks?
-
What are psychic, psychological and cultural distances? How useful is it to a manager to be able to measure (by index or scales) such distance between countries? Explain.
-
Presented below is selected information related to Tsui Repairs at December 31, 2025. Tsui reports financial information monthly (amounts in thousands). a. Determine the total assets of Tsui Repairs...
-
Explain the career opportunities in accounting.
-
Collins Computer Timeshare entered into the following transactions during May 2025. 1. Purchased computers for R\($20,000\) from Digital Equipment on account. 2. Paid R\($4,000\) cash for May rent on...
Study smarter with the SolutionInn App