Describe results of your simulation using simulation report

Assignment Help Basic Computer Science
Reference no: EM132223537

Exercise 1. The Net Present Value (NPV) Model

Shambles, a large toy retailer, are looking at bringing out a new range of soft toys. The range under consideration is "Mythical Beasts." The "Mythical Beasts" range will cost £50,000 to setup and has running costs of £12,000 per year after that for five years. The predicted return from this range is:

Year

2012

2013

2014

2015

2016

£

24,000

29,000

32,000

35,000

40,000

1. Assume a discount rate of 10%. Use Excel to set up a discounted cash flow analysis of the above information, calculating the net present value (NPV) for the investment. Remember that the initial expenditure takes place in 2011.

Your spreadsheet must be constructed in such a way that it can accom- modate different values of the discount rate, and must be as efficient as possible. This means that formulas and fixed cell referencing must be used where appropriate. Also, the entire analysis must be contained in a single table. Include a print-out of cell values as well as a print-out of cell for- mulas.

2. From the information in the spreadsheet only, decide whether or not this is a worthwhile investment, giving your reasons.

3. Calculate the NPV for discount rates of 20%, 30%, 40% and 50%, giving your answers to two decimal places.

4. Using Excel and the data generated from part (c), plot NPV against the discount rate in the range 10% to 50%.

5. Use your graph to estimate the discount rate that would give an NPV of zero. What is the significance of this discount rate? (Hint: What happens at discount rates lower and higher than this figure?)

Exercise 2. The Linear Programming (Optimization) Model

Shambles have selected the "Mythical Beasts" range and decided to con- centrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximize profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Each toy (Pegasus or Phoenix) takes 12 minutes to sew; there are 10 hours (600 minutes) available for sewing each day. Each Pegasus toy takes 6 min- utes to stuff, whereas each Phoenix toy takes 18 minutes to stuff; there are 10 hours (600 minutes) available for stuffing each day. Pegasus generates £8 profit per toy whilst Phoenix generates £16 profit per toy.

It is also required that at least 10 Pegasus toys and at least 20 Phoenix toys are produced each day. What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

1. Determine the maximum by pen-and-paper mathematical calculations and drawing. More precisely:
(a) Write the constraints of the problem and the objective function
(b) Compute mathematically the coordinates of the feasible region

(c)Draw the feasible region
(d)Compute the final solution [2 marks] (e)Draw the isoprofit line and use it to compute the solution graphically
(f)Change the numbers of the per-toy profit so that the maximum profit is achieved at a different corner of the feasible region.

2. Use the Microsoft Excel solver to solve this problem. Include:
(a)a print-out of cell values
(b)a print-out of cell formulae

(c)a print-out of the Solver dialogue box with optimization conditions and constraints
(d)an answer report from the solver
(e)a statement of the answer in words

Exercise 3. GPSS Simulation Model

(Remember that you can download the free Windows version of GPSS (i.e. GPSS World student version)

The sales counter next to the soft toy display in Shambles receives a cus-tomer every 6-10 minutes. Most of these customers (80%) are buying toys and are dealt with by the cashier in 5-15 minutes. The remaining 20% of customers come to open accounts that require an account manager. These customers wait for the account manager, who spends 20-40 minutes in serv- ing them. You are required to simulate an 8-hour day in this department using GPSS.

1. To begin with, construct a flowchart describing the above events using suitable GPSS blocks.

2. Now carry out the simulation in GPSS, showing your program code and simulation report.

3. Describe the results of your simulation using the simulation report, giving as much detail as possible.

4. Modify the simulation so that you factor in not one, but two cashiers. Show your modified program code and the simulation report and discuss what were the observable changes in the simulation.

Exercise 4. Association Rule Mining

A simple TDB is given below:

TID    Items bought
10    a, b, c
20    a, c
30    c, b

Please mine all the association rules with minimum support 66% (that is, 0.66). More precisely, you are required to do the following:

1. Determine, using the Apriori algorithm, all the item sets that have support equal to or higher than 66%. You must clearly show the steps of applying this algorithm.

2. For each item set selected in the above process, determine all the rules formed using that item set and compute the confidence for each such rule.

3. Please explain in one paragraph what is the difference between support and confidence.

Exercise 5. Artificial Neural Networks

There are four training input/target pairs for a two-class problem:

2465_figure.jpg

A two-input perceptron with hard limit activation function is used to solve this classification problem. Write down the step-by-step solution to train the classifier by the basic perceptron learning algorithm, starting with the initial weight vector [2, 1, 4] . Namely, you are required to do the following:

1. Describe the modified problem (by augmenting with 1 the vectors ei).

2. Solve the modified problem by running the perceptron algorithm, showing the step-by-step evolution of the variables manipulated by the algorithm.

3. Construct the solution of the original problem from that of the modified problem.

4. Interpret graphically the problem and your solution, explaining, in graph- ical terms, what is the meaning of the values 0 and 1 for di and why does your solution satisfy these constraints.

Exercise 6. DSS Case Study

Design a DSS to help decision-makers run the 2020 Tokyo Olympics.

Your proposal (including diagrams and write-up) may use any combina- tion of DSS types, technology, architectures, frameworks, etc. that have been covered in the course. You may also apply them to any aspects of the case study mentioned above.

Credit will be given for the following areas:

1. Good description of the different stages in your decision making process.

2. Identification of the suitable DSS types relevant for this problem.

3. Good overall design with appropriate choice of the models that are useful for solving the problem.

4. Creativity, practicality and innovative thinking.

Verified Expert

In the given assignment, we were given with the 5 exercises containing some questions that were answered.They were in relation to calculation of NPV, DSS, etc.The above assignment was done in excel sheet through application of formulas and detailed calculations were shown.

Reference no: EM132223537

Questions Cloud

Compare business-level strategies of three major companies : Analyze and compare the business-level strategies of three major companies.
Recommend a right strategic alternative feasibility : Review Chick-fill-A's current corporate strategy and recommend a right Strategic Alternative Feasibility.
Scrutinize and support new dimensions of learning : Which creates the challenge to comprehend, scrutinize, and support new dimensions of learning (Edudemic, 2015).
True about the dimensions of tort liability : Which of the following is true about the dimensions of tort liability? Which of the following is an example of a battery?
Describe results of your simulation using simulation report : BIS2500 – DECISION SUPPORT SYSTEMS - Describe the results of your simulation using the simulation report, giving as much detail as possible
Improve employee satisfaction vary from country to country : Do you think that the benefits offered and the strategy used to improve employee satisfaction vary from country to country?
Corporate strategic choices in foreign countries : Find an article that you think represents ideas about a company or organization's Corporate Strategic Choices in foreign countries.
Examine current issue related to personal financial planning : ADMS 4506 Financial Planning Assignment - Prepare a report that examines a current issue related to personal financial planning or personal finance in Canada
How can one demonstrate active listening : When communicating, how can one demonstrate active listening? Also, how can the sender help to ensure the receiver is engaged in active listening?

Reviews

len2223537

1/27/2019 11:33:48 PM

The submission deadlines are as follows: Part A (Exercises 1-3): 13, 23:59 PM Part B (Exercises 4-6): 7, 23:59 PM You are required to work on the exercises as follows: – for exercises 1,2,4 and 5 either individually or in groups of at most two – for these exercises, each term you should submit a single word document per group – for exercises 3 and 6, individually – for these exercises, each term you should submit one word document per person

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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