Objective
Your task will be to design a Decision Support System (DSS) in Microsoft Excel. The DSS should enable a user to analyse the potential for a new product under different market scenarios. You are free to choose your own product as well as define the type of business and the market in which it will compete. You will need to synthesise realistic market research data from either secondary sources, from your own knowledge, or from a combination of these.
Development of the DSS
In designing the DSS you will need to consider:
Who are the likely users
How the DSS will be used
At what stage in the new product development the DSS will be used
How the DSS will fit into the decision making process
What data are require to feed into the DSS
What information/results the DSS will provide
Instructions
1. This assignment does not consist of any precisely defined questions that you must answer. It is deliberately open-ended. Broad guidelines are provided but you may develop your analyses as you see fit. Creativity will be strongly rewarded.
2. You will need to build the DSS in Excel. The model should be fully functional and interactive in that the inputs can be changed by a user (i.e., your seminar leader) and the model’s results automatically calculated and displayed. Please adhere to good spreadsheet practice. A very brief description of how to use the spreadsheet should be given. The DSS will be marked on the basis of its functionality, general appearance, and level of ingenuity.
DSS marking criteria
Functionality
– Does the model appropriately meet the objectives of the assignment?
– Does it allow a user to analyse the potential for a new product or service under different market scenarios (e.g., low vs high sales)?
– Is the model interactive? Can input be supplied by a user and the results automatically displayed? /20
Appearance & Layout
– Does the model adhere to good spreadsheet practice?
– Are inputs clearly designated and separated from calculations?
– Is the model modular? Are similarly related inputs/calculations grouped together appropriately?
– Is the model well laid out in general? Does it flow?
– Is the formatting of the model visually appealing? /20
Documentation
– Is a brief description provided of how to use the spreadsheet?
– Are additional notes/hints provided to the user? /10
Ingenuity
– Is the model’s functionality and analysis overly simplistic or does it show some degree of sophistication? /20
total of 70
Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results
Why Choose US
6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Your Privacy Guaranteed
Unlimited Free Revisions
You May Also Like This:
- Designing marketing plan for a product
- Designing documents
- NR601 Week 2: COPD Case Study Part 2 What is your primary (one) diagnosis for this patient at this time? (support the decision for your diagnosis with pertinent positives and negatives from the case)
- Managerial Decision Making Research and Analysis
- 5pm is an easy way to manage your projects and tasks, share files and notes
- Designing Compliance within the LAN-to-WAN Domain
- Designing proposal
- most common file types imported into Excel
- Operations Decision
- Evidence-Based Practice Proposal – Section C: Literature Support
- Applying Decision-Making Skills
- Strategic and Financial Decision Making
- decision variables, the objective function and constraint requirements in an assignment problem.
- Cost and Decision-Making Analysis
- Information Management for Decision Making
- Congruence Model of Organizational Behavior
- historical analysis of the word Rascal, with professional literature as background and support.
- Leadership Decision Making
- Designing infrastructure and security protocols.
- Improving Decision Making
- Report about banking systems for loans.
- Receiving aids and support during emergencies
- Network Design and Implementation
- NR531-11100 Week 3: Describe the nursing care delivery model used at your current or previous employer. Would you utilize this model at SLMC? Discuss current interprofessional collaboration and how you would encourage collaborative efforts. Does the model support the person-centred nursing framework by McCormack and McCance (2017)? Explain your rationale for choosing to use or not use the person-centred nursing framework.
- Decision-Making Biases and Pitfalls
- Overview of Decision Making
- Ecological Modeling
- Case Study on Ethical Decision Making
- BUS520-TD2-4-Business Analytics and Decision Making
- Advertising