Question: Please help me do it in excel solver TE Connectivity requires to produce 12 thousand, 17 thousand and 13 thousand connectors during the next 3

Please help me do it in excel solver

TE Connectivity requires to produce 12 thousand, 17 thousand and 13 thousand connectors during the next 3 months (April, May, June). The plant can produce more than necessary at a cost of $ .07 per month of storage. The cost of material for each piece is $ 5dls per piece produced in April, $ 7dls in May and $ 6dls in June.

The company will start the month of April with 280 operators. Each operator can produce 50 pieces per month. To adjust its workforce to demand, the plant can hire and fire workers each month at a cost of $ 100 per hire and $ 300 per layoff.

Define the Model Variables Define the objective function of the Model. Define the Model constraints Determine the Total Minimum Cost, as well as the quantity to produce per month, the extra inventory at the end of each month, the layoffs and hiring at the beginning of each month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!