IT445 Q3

profileabuassel1402
Assignments3Questions.docx
Home>Computer Science homework help>IT445 Q3

Pg. 02

خطأ! استخدم علامة التبويب "الصفحة الرئيسية" لتطبيق Heading 1 على النص الذي ترغب في أن يظهر هنا.

Assignment 3

[Total Mark for this Assignment is 6]

Decision support systems

IT445

College of Computing and Informatics

Question One

2 Marks

Learning Outcome(s): LO3

Use some DSS and demonstrate the database working with DSS and statistical models

ABC chocolate manufacturing company needs to decide on how many chocolate bars should they produce each month to maximize the company profit. ABC consider two types of chocolate bar ‘dark' and 'salted caramel’. Dark chocolate bar required $20 of raw ingredients and take 2 day to make and salted caramel chocolate bar required $30 of raw ingredients and take 4 working days to make. The profit contribution of each dark chocolate bar is $2 and salted caramel chocolate bar is $5. The Manufacture has capacity of 100,000 working days per month and ingredients budget of $10,000 per month. Using linear programming modelling for ABC company problem, answer the following questions.

a) Identify decision, constraint and result variables, and objective function.  

b) Represent the model in excel sheet, run the model and show the result. Provide a screenshot of your solution. [Hint: using excel solver]. 

Question Two

2 Marks

Learning Outcome(s): LO2

Analyze various industrial applications of DSS and their limitations.

Give the name and a brief discussion of any four major types of models used in DSS?

Question Three

2 Marks

Learning Outcome(s): LO1

Describe the structure of Decision Support Systems (DSS) and their services

Write the differences between Forward Chaining and Backward Chaining also list some suitable application areas for both.