232531581 Scottsville Textile Mill
Assignment 1 (Individual Assignment)
25% Marks Due date: 9 July 2012 (no word limit)
Case Study: Scottsville Textile Mill
_________________________________________________________
This task will relate to analytical skills in solving optimisation problem (linear programming) using Excel with Solver add-in.
Scottsville Textile Mill1
1
Case from Anderson, D., Sweeney D., Williams T., Martin, K. (2010), An Introduction to Management Science Quantitative Approaches to Decision Making, 13 edition, South Western, Cengage.
1
Assessment Criteria
Student should
Clearly define all variables.
Mathematically formulate the problem with clear explanation for each constraint.
provide all assumption, if any
provide explanation for Excel outputs.
Discuss and interpret the results. The following criteria will also be considered:
Organization of the report.
Clarity of presentation and the sequence of the topics
Comprehensiveness of the discussion.
Student must submit the soft version of the excel solution.
2
25% Marks Due date: 9 July 2012 (no word limit)
Case Study: Scottsville Textile Mill
_________________________________________________________
This task will relate to analytical skills in solving optimisation problem (linear programming) using Excel with Solver add-in.
Scottsville Textile Mill1
1
Case from Anderson, D., Sweeney D., Williams T., Martin, K. (2010), An Introduction to Management Science Quantitative Approaches to Decision Making, 13 edition, South Western, Cengage.
1
Assessment Criteria
Student should
Clearly define all variables.
Mathematically formulate the problem with clear explanation for each constraint.
provide all assumption, if any
provide explanation for Excel outputs.
Discuss and interpret the results. The following criteria will also be considered:
Organization of the report.
Clarity of presentation and the sequence of the topics
Comprehensiveness of the discussion.
Student must submit the soft version of the excel solution.
2