Individual Assignment - You are NOT allowed to work with anyone else for this assignment. This means that you are NOT allowed to discuss with other the solution or your approach to solving this case.

data mining

Description

*** Reminder of the Honor Code ***

Individual Assignment -  You are NOT allowed to work with anyone else for this assignment. This means that you are NOT allowed to discuss with other the solution or your approach to solving this case. Even more strictly, you are NOT allowed to share a soft copy of any of your work on the assignments. Nor is it permissible for one student simply to tell another student the answer, neither share your final paper by any means (not electronically, hard copy or, verbally).

***

Apply the knowledge acquired in the Data Optimization class and through the use of Solver help the management team of Maple Inc. reach a conclusion. At minimum, consider doing the following:

1.    Read the case, “Designing Optimal Capacity Planning Strategies

2.    Calculate the optimum production schedule for the five years demand with the Guadalajara plant.

3.    Calculate the optimum production schedule for the five years demand without Guadalajara plant.

4.    Calculate the yearly cost savings of opening the Guadalajara plant

5.    Prepare a proposal for the management team of Maple on what to do:

o   Should they open the Guadalajara plant?  Why yes or why not?

o   Should they shut down the operations of any plant?

o   Be sure to provide management implications of your recommendations

o   A screenshot of a cell phone

Description automatically generatedincluding: HR, Marketing, PR Production, and Finance.

Deliverables

1 of 2: Submit your Excel file with your work in solver and any relevant calculations (building this should take you between 90 to 120 minutes).

2 of 2: Submit a maximum one Word page (~500 words, excluding exhibits) with your write-up including the answers above. (Do not structure as Q&A, prepare a business report addressed to Richard Rubrics).

 


Related Questions in data mining category