Module code:- IMAT5264
Title of the Assignment:- Candy Assignment
This coursework item is :- Summative
The learning outcomes that are assessed by this coursework are:
1.Identify the required components of a BI system by systematic analysis of a perceived problem area appraisal of available techniques and tools and the critical evaluation of developed systems.
2.Conceptual under standing of a range of predictive analysis techniques critically evaluating current research and new insights.
3. Design appropriate BI systems using appropriate BI approaches.
IMAT5264 Business Intelligence Application & Development Assignment-De Montfort University UK
This coursework is:
Your task is to prepare a management report in which to illustrate to management how the techniques of forecasting optimisation and simulation and Business Intelligence more broadly could be useful to the organisation.
As management know little of these techniques you need to demonstrate how they will work in practice. For this purpose data has been supplied for you to carry out some of the techniques. Further details of the task and deliverables are given overleaf.
East Midlands Candy
East Midlands Candy (EMC) is a small local confectionary manufacturer founded in Leicester UK in 1850. Over the years the organisation has evolved to produce a range of sweet products including chocolates crisps and snacks and range of cakes supplied to sweet shops vending machine companies hotels and cinemas. There is also a retail section which is offered through a network of branches found in tow+6 ns, cities and in large sub urbs throughout in the East Midlands.
A new Chief executive has recently been appointed following the retirement of the previous CEO. The new senior management team is now keen to upgrade the organisations IT provision to become more market focused and efficient. As part of this initiative the management is considering setting up a new department of ‘Business Under standing’. The purpose of this department is to assist management to under stand customers better and to make justified decisions on operational management. This department will undertake Business Intelligence related activities and in particular will be focused on using techniques in forecasting linear programming and simulation in relation to the company’s activities.
Your task is to prepare a management report in which to illustrate to management how the techniques of fore casting optimisation linear programming and simulation and Business Intelligence could be useful to the organisation.
As management know little of these techniques you need to demonstrate how they will work in practice. For this purpose data has been supplied for you to carry out some of the techniques.
The report should be broken down into four parts as detailed overleaf. Your report should include your workings and/or spreadsheets for the practical exercises and a reference list. These could include hand written and scanned LP formulations, excel spreadsheets and a list of references used. We will have access to your SAS BI work on the SAS server so you do not need to supply any thing other than the screen shots of your SAS BI work within your report.
It is expected that you will prepare and submit a comprehensive word processed structured logical technical report in the correct format.
A typical report structure includes: Title page contents introduction and main body of report conclusions recommendations and appendix (where appropriate). Notes on report writing is available on BB.
Note: The title page should contain: Module code and your p-number (name optional), assignment title deadline date module tutor’s name. You should include your p-number in the footer of every page along with page numbers (there should be no page number dis played in the title page).
The marking criteria are supplied at the end of this document.
Part 1 Decision Making Techniques
1.1. Forecasting
a. Provide an overview of how forecasting techniques could be useful. Highlight any problems or areas of caution with the technique of forecasting.
b. Application of forecasting techniques. For this task you should use the data
supplied in Appendix 1. Use this data to demonstrate how the different products
show different characteristics with regard to forecasting. Identify the most appropriate fore casting technique for each of the three products given and justify your choice. Give forecasts for year 4. Critically evaluate your results high lighting whether you consider the model to be good or not. Use just one of the product’s data to demonstrate a methodology for evaluating your model.
1.2. Linear Programming/Linear optimisation
a. Provide an overview of how linear programming could be useful. Critically evaluate the technique and identify areas in the organisation where linear programming could be used. (The ASW text book has a large number of examples especially in Chapter
b.Application of linear programming techniques. For this task you should carry out a linear programming analysis using the data in appendix 2. In the first example formulate and solve the problem and hence identify the mix that gives the optimal results and advise management on producing these products. In the case of the second example on staff labour planning please only formulate the problem – there is no requirement to solve this problem.
1.3. Simulation
a. Provide an overview of how the technique of queuing models and simulation could be useful. Critically evaluate the technique and identify areas in the organisation where this technique could be used.
b. Carry out an analysis of a retail branch queueing system noting the following information:
The Leicester branch experiences a mean arrival rate of 2 per minute.
The average time to serve a customer is 0.5 minutes.
Investigate the effects of different numbers of servers on the customers’ total time in the system (i.e queueing time plus service time)
Interpret results for management and advise on the number of branch staff required. You can assume a single queue system is in operation
Part 2 Business Intelligence Systems
The owners of EMC have asked you to develop a Business Intelligence application for the Sales department. The Sales Department is currently split into three groups, each of which has responsibility for one customer area (retail, wholesale and grocery). The members of each team are to be provided with an Information Delivery Portal (IDP) page. The information dis played is to be relevant to each sales group i.e. it is to be filtered to display the customer group they have a responsibility for. All users can be considered low level IT users.
In Section 1 of the IDP page a web report is to be displayed showing the sales history for each product group a tab page for each year) in table form. This table should show as a minimum the sales totals for each product group for that sales group. You may choose to add additional measures. Be aware that as the designer you need to find an appropriate balance of detail for the user.
IMAT5264 Business Intelligence Application & Development Assignment-De Montfort University UK
In Section 2 of the IDP page, a web report is to be displayed in a graphical format. This should show sales to all customers in a selected product group. Refer to the data sets provided to identify these groups. The user should be prompted as to which product group and year they are interested in. Remember they should only see sales for their customer group. The graph format is your choice (pie chart bar chart etc.).
In section 3 of the IDP page produce a dashboard showing total sales of each product group for the current year which is 2003. Set the range based on:-
Above target being +10% on 2002 sales
On Target being between 90% and 110% of 2002 sales
Below target being less than 90% of 2002 sales.
Again the choice of gauge is yours; remember to limit the data to that sales group’s customers. You will need to manually calculate the value to enter for each range. There is no way for SAS to calculate this requirement.
The data is already registered in metadata within the SAS BI suite, within the shared folder.
The files you will need include – Candy_Customer, Candy_Products, Candy_Sales_History Candy_Time_Periods and Candy_Sales_Summary.
You will need to create information maps filters and prompts as necessary to complete the tasks.
IMAT5264 Business Intelligence Application & Development Assignment-De Montfort University UK
To achieve a pass you will need to demonstrate an understanding of SAS techniques as we have covered in labs. To achieve a distinction level pass you will need to demonstrate your ability to produce an application tailored to non-technical user needs. Refer to the marking sheet for more detail on the marking.
Include samples of your work in your report and an evaluation of your system, identifying any areas where this system could be improved – for example highlight shortcomings in the software.
Part 3 Compliance
Compile a brief overview of compliance issues that may affect this business and the proposed business intelligence systems. This will require some self-study on your part and there are resources for this on the Blackboard site for the module in the Compliance Reading – Week 1 folder on why business intelligence unit (BIU) systems fail.
Part 4 Report format and structure
There are 10% of the marks allocated for the correct report structure and clarity of the supporting material including layout clarity grammar spelling referencing and appropriate depth of coverage.
Submit your structured word processed report. Your report should include your workings and/or spread sheets for the practical exercises and a reference list. These could include hand written and scanned LP formulations, excel spreadsheets and a list of references used.
ORDER This IMAT5264 Business Intelligence Application & Development Assignment NOW And Get Instant Discount
Read More :
