DECISION SUPPORT SYSTEM

Decision Support System

Table of Content

1.INTRODUCTION1

2.Decision Support System1

3.Project Work2

4.Project Development3

4.1Credit Scorecard Analysis3

4.1.1Database3

4.1.2Analysis of information in Excel4

Decision Support System

INTRODUCTION

Elegant Café is a franchise company that offers franchising opportunities in the South East of England. Elegant Café runs state of the art café restaurants in several places in Hampshire namely at Brighton, Portsmouth, Reading, Southampton and Wycombe. They are a café company and offer a wide variety of coffee products, beverages, bakery items and takeaway food products.

Elegant Café wants to build a decision support system that enables them to make analysis and take decisions on a wide variety of data that they possess. The project of building the decision support system was carried out by a team of three members. This paper summarizes the requirements of the Elegant Café; the project work carried out by the team and the contribution of the author (myself) to the project.

Decision Support System

Elegant Café are offering access to a national network and brand identity and are also evaluating the risk factors associated with the potential company to do business with. The company has procured information about the companies that are interested in doing business with Elegant Café and would like to decide on the less risky company to work for. The management wants the decision support system to help them in choosing a less risky company to do business with. Based on a certain set of risk variables, a credit score needs to be calculated and presented visually which would help them to zero in on the potential company.

The company also has demographic information about few of the cities in South East of England and is looking forward for opening up outlets at various other locations based on a higher younger population. The Decision support system must enable the company to decide on the places in which the outlets can be opened.

The company has several months of information on the Cost of Goods sold and the Operating expenses of the company. The company wants to derive income statements and calculate net profit from the available information. The company would also like to forecast its future net profit potential based on the available information. The company would also like to have real time information about the currency rates integrated with the decision support system.



Project Work

The group assignment was performed by four members. The project work was divided into a number of components ...