Decision support model using visual dss

Assignment Help Marketing Management
Reference no: EM13938543

Question 1:

Right Electronics is an electronics manufacturing company which is based in Adelaide. The company is planning to introduce a new digital monitor into the market. However, in recent times the company has made some bad investment decisions which in turn has impacted their profit bottom line. Thus the senior management requires a thorough analysis of every new product that is introduced to the market. As a business analyst, you have been appointed to advise the senior management on the feasibility of the new product.

An initial analysis conducted by other analysts for the product claim the anticipated net present value (NPV) for the new product line is over $2 million and they have recommended the manufacture of the product based on this assessment.

Your task is to use a decision support system (DSS) and report to the senior management on whether the claim of the NPV being over $2 million is correct or incorrect using the relevant information given in Table.

Table: Summarised product details

Cost of production: $30.00 per unit
Annual overhead cost: $215,000
Initial investment needed: $1,750,000
Estimated selling price: $52.00 per unit
Market at time of introduction: 420,000 units per year
Market growth: 15% per year
Market share: Most likely 12%
Assumed economically useful lifetime: 4 years, commencing 2015
Discount rate used to analyse new product proposals is 15%

You need to assume that the overhead and initial investment occurs at the START of the respective year, profit occurs at the END of the year and initial investment was only applicable to the first year.

Your task:

1. Develop a decision support model using Visual DSS using the variables described above. Include comments within your Visual DSS model to explain the variables and your calculations.

2. Based on the result of your model, what is the net present value (NPV)? Explain whether the claim regarding the NPV being above $2 million is correct or incorrect.

Question 2:

You are now asked to analyse the variations on the impact of market share, cost of producing, overheads and initial investment on the NPV. You need to conduct a risk analysis based on the information below:

a) Market share: could be as low as 4% or as high as 16%, but is most likely to be 12%. The distribution could be represented using a triangular distribution.

b) Unit costs can be described by normal distribution - mean of $35.00 and standard deviation of $13.00.

c) Overhead: could be as low as $100,000 per year or as high as $350,000 per year, but is most likely to be $210,000 per year. The distribution could be represented using a triangular distribution.

d) Initial investment requirements can be uniformly distributed between $800,000 and $2,500,000.

The senior management decided on the following decision criteria:

Decision criteria: The company is unwilling to proceed if there is a 20% or greater chance that the net present value will be less than $1,000,000 (1 million).

Your task:

1. You are required to use Visual DSS to run a Monte Carlo simulation (a Risk Analysis).

2. Produce a cumulative probabilities report and graph for the above question. Based on results and the decision criteria, explain whether the senior management should accept or reject the proposed production of the product.

Question 3:

When the above analysis reached the Chief Executive Officer (CEO) of your company, he became very concerned about the assumptions made in the model. His experience has taught him to consider the uncertainty associated with selling price and production costs more thoroughly. He required further analysis to be done by incorporating the following uncertainties to Question 1 model:

a) Selling price: uniformly distributed between $65 and $45.

b) Unit costs: normally distributed, mean of $30.00, standard deviation of $5.00.
He applied different decision criteria and was willing to go ahead with the product proposal if there was at least an 80% chance the net present value would be greater than $1,000,000.

Your task:

1. You are required to use Visual DSS to run a Monte Carlo simulation (a Risk Analysis). Based on your results determine whether the CEO will proceed under these uncertainties.

2. Produce a cumulative probabilities report and graph for the question. Based on results and the decision criteria, will the CEO accept or reject the proposed production of the product?

PART B:

Discuss the main importance of business intelligence. Explain on how the use of business intelligence and decision support can help to provide values to the company.

Part C:

Explain the main differences between big data and big data analytics. Give a real life example on how big data can be used to support business operations.

Reference no: EM13938543

Questions Cloud

What is the cost of equity for the privately held firm : A privately hold corporation wishes to estimate its cost of equity. The firm has a target debt-to-equity ratio of 0.5 and the marginal tax rate is 35%. The yield on 10 year U.S. Treasury securities is 4% and the expected market risk premium is 6%. Wh..
Library and database research on tv audiences : My research group doesn't watch television. They watch downloaded material on their computers. Is this ok? How much further reading and research should I do using the library's resources?
Biometric authentication methods : Will biometric authentication methods be useful in the future? What kind of attacks could be mounted in practice?
What is the company reporting about near term trends : What is the company reporting about near term trends in revenue/growth/earnings?
Decision support model using visual dss : Develop a decision support model using Visual DSS using the variables described above. Include comments within your Visual DSS model to explain the variables and your calculations.
Expected return on the market portfolio : Currently the risk-free rate is 6% and the expected return on the market portfolio is 11%, the expected return for 3 stocks as priced in the market are listed below with their estimate of beta.
What system engineering means to you : What system engineering means to you? Mention two or three primary benefits that a project/program can derive from the implementation of a well-organised System engineering process, when developing a new product a new product or system.
Is this significantly different from chance : How many degrees of freedom (df) are there in this experiment? What is the value of X square? What is the P value?
Program to handle various string operations. : Write a main program that calls the function with the pointer to the string and the number of characters from the end (not including the end of string character)

Reviews

Write a Review

Marketing Management Questions & Answers

  Integrated marketing communication

Developing an IMC plan of Amazon that aims to create awareness and knowledge amongst Singaporean  consumers of the ethics involved in buying clothing made from Bangladeshi factories  .

  Multiple choice questions on e-commerce

The assignment in Computer Science or Information Technology is about multiple choice questions, particularly in e-commerce. Questions such as types of e-commerce websites, commercial websites, disintermediation, Platform for Piracy, the data that ca..

  Balanced scorecard for red lobster

The assignment in marketing is about Red Lobster, which is one US and Canada's most loved seafood restaurant. It has hundreds of outlets in US and Canada and it now wants to expand further. The approach adopted by Red Lobster has been discussed in fu..

  Marketing plan - marketing audit, swot and smart report

The assignment in marketing is about preparing a marketing plan. As part of marketing plan, the SWOT analysis, assessing the competitive position, identifying critical competitive issues, marketing objectives, strategy and actions have been suggested..

  Marketing plan

Marketing deals with preparing a marketing plan for either an existing product or a new product. Various aspects about launching a new product into the market are discussed ranging from the industry the product belongs to, goals and vision of the com..

  Yamato corporation analysis - harvard case study

Please refer to the PDF for the Case Study and questions.The case study from Harvard Business School is about Yamato Corporation, a parcel delivery company which provides door to door delivery in Japan.

  Marketing plan - create a new product

The assignment in marketing is about competitive analysis for a new product namely "heated insoles". These heated insoles can be put in shoes and they can protect the wearer's feet by keeping them warm during cold winters.

  Report on digital marketing strategy for a website

Promotion strategies of  the one's own developed website

  Integrated marketing campaign of mccafe

Integrated marketing campaign for McDonald's McCafe. McCafe has been launched in Canada. This is a case study which involves the use of digital marketing and social media marketing apart from regular marketing such as TV and radio. All these more are..

  New product development at adidas

In this paper, the researcher also determines the different kind of practices used by Adidas to manufacture shoes for its customers.

  Managing services in competitive environment

Services can be defined as separately identifiable, intangible activities which provide want-satisfaction when marketed to household consumers and/or industrial users.

  Prepare a marketing plan

A marketing plan is an essential tool for any marketer, providing direction for a brand, product or organization. A marketing plan describes the marketing environment, marketing objectives and marketing strategies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd