Assignment 2 - Assignment # 2 Due Date: March 17, 2011 (at...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment # 2 Due Date: March 17, 2011 (at the beginning of class time) Instructions: This assignment should be completed in groups of at most 3 students. It is required to provide the instructor with a printed report (using Word or your favorite word processor), as well as to send one excel file via Angel with the aggregate plan solved to optimality using excel solver. The report should contain the following: a header with the names of the students and the group number, a clear and complete description of all model variables including units, the objective function clearly indicating if it must be minimized or maximized, all constraints, and finally a summary of the solution found using solver. Five points will be given for organized excel files and reports . The Magna Corporation has estimated the demand for its products for the upcoming year as: Month Demand (in units) January 8,000 February 11,000 March 19,000 April 21,000 May 27,000 Additional Problem Information: There are 70 employees on the payroll. Any change in employment must be
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/23/2011 for the course SCM 475 taught by Professor Rosales during the Spring '11 term at Michigan State University.

Page1 / 2

Assignment 2 - Assignment # 2 Due Date: March 17, 2011 (at...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online