IT445 Decision Support Systems Homework- Saudi Electronic University
Question 1
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.
• Identify decision, constraint and result variables, and objective function.
• Represent the model in excel sheet, run the model and show the result. Provide a screenshot of your solution. [Hint: using excel solver].
Question 2
Give the name and a brief discussion of any four major types of models used in DSS?
Question 3
Write the differences between Forward Chaining and Backward Chaining also list some suitable application areas for both.
Format your assignment according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.