Decision support systems assignment questions
hasano1
Decisionsupportsystems3.docx|
Pg. 04 |
|
Question Three |
|
|
|
|
Assignment 3
Deadline: THURSDAY 9/4/2020 @ 23:59
[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.
