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