IE 375 - Production Planning Homework Assignment 3 - November 12 A solar panel manufacturer uses a specific type of silicon photovoltaic (PV) cell in production. Demand for this PV cell has a constant rate of 40 per month. The company should decide among three sourcing options for the PV cell: supplier X, supplier Y, or in-house production. Supplier X offers an all-units discount schedule for its PV cells: It charges $50 for each cell if the order size is less than 500, $45 for each cell if the order size is between 500 and 1000, and $40 for each cell if the order size is greater than or equal to 1000. The order setup cost required by this supplier is $2000. Supplier Y offers an incremental discount schedule for its PV cells: It charges $50 for each cell if the order size is less than or equal to 300, $40 for each cell purchased beyond 300 if the order size is between 301 and 600, and $30 for each cell purchased beyond 600. The order setup cost required by this supplier is $1000. For the option of in-house production, it costs $800 to initiate a production